GeoTIFF -> Wavelet compression (Ermapper ecw, JPEG2000) -> Raster on rDBMS
SHP (ESRI) -> GML, KML, GeoJSON -> rDBMS
# TABELLA SENZA DATI GEOMETRICICREATE TABLE comparti(id serial,name varchar (300))# AGGIUNTA DI UNA COLONNA GEOMETRICASELECT AddGeometryColumn('public', 'comparti','the_geom', 423, 'POLYGON', 2);
SELECT name, ST_Area(the_geom) FROM comparti;SELECT ST_Union(the_geom) from comparti;
http://webgis/wms?SERVICE=wms&REQUEST=GetCapabilities
http://webgis/cache/wms?LAYERS=Ortofoto&FORMAT=jpg&TRANSPARENT=FALSE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&SRS=EPSG%3A32633&BBOX=740461,4469516,744557,4473612&WIDTH=256&HEIGHT=256
http://webgis/wms?version=1.1.0&service=WFS&request=GetFeature&typename=catasto_2011&bbox=748320.39999962,4469952.6000061,748330.39999962,4469962.6000061
var lon = 5;var lat = 40;var zoom = 5;var map, layer;map = new OpenLayers.Map('map');layer = new OpenLayers.Layer.WMS( "OpenLayers WMS","http://webgis/cache/wms", {layers: 'CATASTO'});map.addLayer(layer);map.setCenter(new OpenLayers.LonLat(lon, lat), zoom);map.addControl( new OpenLayers.Control.LayerSwitcher() );