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 = ?

http://dive4elements.wald.intevation.org