Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 728:f6630d0203da
Put all Attributes of the Databasetables into the Shapefile which will be produced for the Product Layer
gnv-artifacts/trunk@764 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 12 Mar 2010 11:36:38 +0000 |
| parents | 9ba6bb85d6dd |
| children | 3f8f71e88587 |
comparison
equal
deleted
inserted
replaced
| 727:22dc921cd8b1 | 728:f6630d0203da |
|---|---|
| 1231 QUERY_STRING, \ | 1231 QUERY_STRING, \ |
| 1232 ID_MAPSERVICE || '_' ||ID_LAYER \ | 1232 ID_MAPSERVICE || '_' ||ID_LAYER \ |
| 1233 FROM MEDIAN.LAYER_HAS_SUBTYPES \ | 1233 FROM MEDIAN.LAYER_HAS_SUBTYPES \ |
| 1234 WHERE ROW_ID = ? | 1234 WHERE ROW_ID = ? |
| 1235 | 1235 |
| 1236 layer_data = SELECT ST_ASTEXT(SHAPE) \ | 1236 layer_data = SELECT ST_ASTEXT(SHAPE), ? \ |
| 1237 FROM ? \ | 1237 FROM ? \ |
| 1238 WHERE ? | 1238 WHERE ? |
| 1239 | 1239 |
| 1240 layer_data_with_geom = SELECT ST_ASTEXT(SHAPE) \ | 1240 layer_data_with_geom = SELECT ST_ASTEXT(SHAPE), ? \ |
| 1241 FROM ? \ | 1241 FROM ? \ |
| 1242 WHERE ? AND \ | 1242 WHERE ? AND \ |
| 1243 INTERSECTS(SHAPE,"?") | 1243 INTERSECTS(SHAPE,"?") |
| 1244 | 1244 |
| 1245 geometry_for_subareafilter=SELECT st_astext(SHAPE) \ | 1245 geometry_for_subareafilter=SELECT st_astext(SHAPE) \ |
| 1246 FROM MEDIAN.FEATUREAREA \ | 1246 FROM MEDIAN.FEATUREAREA \ |
| 1247 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | 1247 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
| 1248 FEATURECODE = ? | 1248 FEATURECODE = ? |
| 1249 | |
| 1250 layer_colums= SELECT COLUMN_NAME \ | |
| 1251 FROM SDE.COLUMN_REGISTRY \ | |
| 1252 WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \ | |
| 1253 OWNER = '?' AND \ | |
| 1254 TABLE_NAME = '?' |