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