Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
648:7c67ff162e87 | 649:4fc97074eb90 |
---|---|
1219 ############################################# | 1219 ############################################# |
1220 ######### Layer Contis und Nauthis ########## | 1220 ######### Layer Contis und Nauthis ########## |
1221 ############################################# | 1221 ############################################# |
1222 ############################################# | 1222 ############################################# |
1223 | 1223 |
1224 layer = SELECT ID_LAYER KEY, \ | 1224 layer = SELECT ROW_ID KEY, \ |
1225 TITLE || '-' || LAYER_NAME VALUE \ | 1225 TITLE || '-' || LAYER_NAME VALUE \ |
1226 FROM MEDIAN.LAYER_HAS_SUBTYPES \ | 1226 FROM MEDIAN.LAYER_HAS_SUBTYPES \ |
1227 WHERE ID_FEATURECLASS LIKE ? \ | 1227 WHERE ID_FEATURECLASS LIKE ? \ |
1228 ORDER BY LAYER_NAME | 1228 ORDER BY LAYER_NAME |
1229 | 1229 |
1230 layer_request_data = SELECT ID_FEATURECLASS, \ | 1230 layer_request_data = SELECT ID_FEATURECLASS, \ |
1231 QUERY_STRING, \ | 1231 QUERY_STRING, \ |
1232 TITLE, \ | 1232 TITLE, \ |
1233 LAYERNAME \ | 1233 LAYER_NAME \ |
1234 FROM MEDIAN.LAYER_HAS_SUBTYPES \ | 1234 FROM MEDIAN.LAYER_HAS_SUBTYPES \ |
1235 WHERE ID_LAYER = ? | 1235 WHERE ROW_ID = ? |
1236 | 1236 |
1237 layer_data = SELECT ST_ASTEXT(SHAPE) \ | 1237 layer_data = SELECT ST_ASTEXT(SHAPE) \ |
1238 FROM ? \ | 1238 FROM ? \ |
1239 WHERE ? | 1239 WHERE ? |
1240 | |
1241 layer_data_with_geom = SELECT ST_ASTEXT(SHAPE) \ | |
1242 FROM ? \ | |
1243 WHERE ? AND \ | |
1244 INTERSECTS(SHAPE,"?") | |
1245 | |
1246 geometry_for_subareafilter=SELECT st_astext(SHAPE) \ | |
1247 FROM MEDIAN.FEATUREAREA \ | |
1248 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
1249 FEATURECODE = ? |