diff gnv-artifacts/doc/conf/queries.properties @ 604:938ce81a6bd0

Integrated Database-Support for the Mapviewer-Interface gnv-artifacts/trunk@666 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 09 Feb 2010 13:01:20 +0000
parents d2f97cb2ac32
children 93978859fa9e
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Fri Feb 05 14:15:09 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Tue Feb 09 13:01:20 2010 +0000
@@ -1191,3 +1191,25 @@
 rasterQuery = SELECT ST_ASTEXT(RASTER) \
     FROM MEDIAN.TOPO_WORLD_2MIN \
     WHERE INTERSECTS(RASTER, "?")
+    
+mapviewer_interface_fis_region = SELECT ID_FIS \
+    FROM MEDIAN.FEATUREAREA, \
+         MEDIAN.FIS_HAS_REGION FHR \
+    WHERE FHR.FEATUREID = MEDIAN.FEATUREAREA.FEATUREID AND \
+          FHR.FEATURETYPE = MEDIAN.FEATUREAREA.FEATURETYPE AND \
+          FHR.FEATURECODE = MEDIAN.FEATUREAREA.FEATURECODE AND \
+          INTERSECTS(SHAPE,"?")
+          
+mapviewer_interface_mapservices_has_fis = SELECT DISTINCT ID_FIS, \
+         ID_MAPSERVICE \
+    FROM MEDIAN.FIS_HAS_MAPSERVICE \
+    WHERE ID_MAPSERVICE IN (?)
+
+mapviewer_interface_mapservices_has_parameter = SELECT DISTINCT ID_PARAMETER \
+    FROM MEDIAN.MAPSERVICE_HAS_PARAMETER \
+    WHERE ID_MAPSERVICE = ?
+
+mapviewer_interface_mapservices_has_parameter_using_layer = SELECT DISTINCT ID_PARAMETER \
+   FROM MEDIAN.LAYER_HAS_PARAMETER \
+   WHERE ID_MAPSERVICE = ? AND \
+         ID_LAYER IN (?)
\ No newline at end of file

http://dive4elements.wald.intevation.org