[Mapbender-commits] r9080 - trunk/mapbender/tools/wms_extent

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2014-09-22 03:26:56 -0700 (Mon, 22 Sep 2014)
New Revision: 9080

Modified:
   trunk/mapbender/tools/wms_extent/extents.map
Log:
Bugfix to allow showing multipolygons from postgis column

Modified: trunk/mapbender/tools/wms_extent/extents.map
===================================================================
--- trunk/mapbender/tools/wms_extent/extents.map	2014-09-19 12:53:09 UTC (rev 9079)
+++ trunk/mapbender/tools/wms_extent/extents.map	2014-09-22 10:26:56 UTC (rev 9080)
@@ -110,8 +110,8 @@
 	TYPE POLYGON
 	CONNECTIONTYPE postgis 
 	CONNECTION   "dbname=mapbender user=postgres port=5432 host=localhost"
-	DATA "bounding_geom from (select bounding_geom , 1 as oid from mb_metadata where uuid = \'%metadata_uuid%\') as foo USING UNIQUE oid USING SRID=4326"
-
+	DATA "geom FROM (SELECT (st_dumprings((ST_Dump(bounding_geom)).geom)).path[1],(st_dumprings((ST_Dump(bounding_geom)).geom)).geom
+FROM mb_metadata WHERE uuid = \'%metadata_uuid%\') AS rings USING UNIQUE path USING SRID=4326"
 	METADATA
 		WMS_TITLE "Metadata polygon"
 		WMS_SRS "EPSG:4326"