Mercurial > dive4elements > gnv-client
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 = ?