diff gnv-artifacts/doc/conf/queries.properties @ 649:4fc97074eb90

Added Support for writing Shapefiles and Export them as an Zipfile for the Product Layer. gnv-artifacts/trunk@738 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 05 Mar 2010 12:35:24 +0000
parents 58c32df1a44d
children 9ba6bb85d6dd
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Fri Mar 05 09:13:17 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri Mar 05 12:35:24 2010 +0000
@@ -1221,7 +1221,7 @@
 #############################################
 #############################################
 
-layer = SELECT ID_LAYER KEY, \
+layer = SELECT ROW_ID KEY, \
         TITLE || '-' || LAYER_NAME VALUE \
     FROM MEDIAN.LAYER_HAS_SUBTYPES \
     WHERE ID_FEATURECLASS LIKE ? \
@@ -1230,10 +1230,20 @@
 layer_request_data = SELECT ID_FEATURECLASS, \
         QUERY_STRING, \
         TITLE, \
-        LAYERNAME \
+        LAYER_NAME \
     FROM MEDIAN.LAYER_HAS_SUBTYPES \
-    WHERE ID_LAYER = ? 
+    WHERE ROW_ID = ? 
 
 layer_data = SELECT ST_ASTEXT(SHAPE) \
     FROM ? \
     WHERE ?
+    
+layer_data_with_geom = SELECT ST_ASTEXT(SHAPE) \
+    FROM ? \
+    WHERE ? AND \
+          INTERSECTS(SHAPE,"?")
+    
+geometry_for_subareafilter=SELECT st_astext(SHAPE) \
+    FROM MEDIAN.FEATUREAREA \
+    WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
+           FEATURECODE = ?

http://dive4elements.wald.intevation.org