Mercurial > dive4elements > gnv-client
diff 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 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Fri Mar 12 11:28:36 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Fri Mar 12 11:36:38 2010 +0000 @@ -1233,11 +1233,11 @@ FROM MEDIAN.LAYER_HAS_SUBTYPES \ WHERE ROW_ID = ? -layer_data = SELECT ST_ASTEXT(SHAPE) \ +layer_data = SELECT ST_ASTEXT(SHAPE), ? \ FROM ? \ WHERE ? -layer_data_with_geom = SELECT ST_ASTEXT(SHAPE) \ +layer_data_with_geom = SELECT ST_ASTEXT(SHAPE), ? \ FROM ? \ WHERE ? AND \ INTERSECTS(SHAPE,"?") @@ -1246,3 +1246,9 @@ FROM MEDIAN.FEATUREAREA \ WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ FEATURECODE = ? + +layer_colums= SELECT COLUMN_NAME \ + FROM SDE.COLUMN_REGISTRY \ + WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \ + OWNER = '?' AND \ + TABLE_NAME = '?'