Wms geometry

From MapbenderWiki

File

./mapbender/http/tools/wms_geometry.sql

Notice

PostgreSQL with PostGIS has to be your administration database for Mapbender

Add new Column the_geom in table layer_epsg

• the_geom is a new geometry column for polygons. It is filled with the polygon, that replesents the Extent of a WMS.

Select AddGeometryColumn('mapbender','layer_epsg','the_geom',4326,'POLYGON',2); UPDATE layer_epsg set the_geom = transform( geometryfromText( 'POLYGON(('|| layer_epsg.minx || ' ' || layer_epsg.miny || ',' || layer_epsg.minx || ' ' || layer_epsg.maxy || ',' || layer_epsg.maxx || ' ' || layer_epsg.maxy || ',' || layer_epsg.maxx || ' ' || layer_epsg.miny || ',' || layer_epsg.minx || ' ' || layer_epsg.miny || '))',ltrim(epsg,'EPSG:')::int4) ,4326 ) where epsg != 'EPSG:31492' AND epsg != 'EPSG:31493' AND epsg != 'EPSG:31494' AND epsg != 'EPSG:42304' AND epsg != 'EPSG:102257' AND epsg != 'NONE' ;

Create a view qry_wms_extent

• qry_wms_extent is included in the map-file mapbender_wms.map

Create view qry_wms_extent as Select DISTINCT layer.layer_id,layer.fkey_wms_id, layer_pos, wms.wms_id, wms.wms_title,wms.wms_version,wms.wms_abstract,wms.wms_getcapabilities, layer_epsg.epsg, layer_epsg.minx, layer_epsg.miny, layer_epsg.maxx, layer_epsg.maxy, layer_epsg.the_geom from layer LEFT JOIN wms ON wms.wms_id = layer.fkey_wms_id LEFT JOIN layer_epsg ON layer.layer_id = layer_epsg.fkey_layer_id where layer.layer_pos=0;