GeoTIFF -> Wavelet compression (Ermapper ecw, JPEG2000) -> Raster on rDBMS
SHP (ESRI) -> GML, KML, GeoJSON -> rDBMS
# TABELLA SENZA DATI GEOMETRICI
CREATE TABLE comparti(
id serial,
name varchar (300)
)
# AGGIUNTA DI UNA COLONNA GEOMETRICA
SELECT 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() );