comparison gnv-artifacts/doc/conf/queries.properties @ 799:feeaf5aec552

ISSUE213: Wrong Geometrytype used for the generation of an Layer with Multipolygon-Geometries gnv-artifacts/trunk@881 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 06 Apr 2010 11:56:53 +0000
parents cee3a0c22bb1
children 8065295ae255
comparison
equal deleted inserted replaced
798:6cff63d0c434 799:feeaf5aec552
1358 WHERE ID_MAPSERVICE = ? AND \ 1358 WHERE ID_MAPSERVICE = ? AND \
1359 ID_LAYER IN (?) 1359 ID_LAYER IN (?)
1360 1360
1361 ############################################# 1361 #############################################
1362 ############################################# 1362 #############################################
1363 ######### Layer Contis und Nauthis ########## 1363 # Layer Contis, Nauthis and Marinefeatures #
1364 ############################################# 1364 #############################################
1365 ############################################# 1365 #############################################
1366 1366
1367 layer = SELECT ROW_ID KEY, \ 1367 layer = SELECT ROW_ID KEY, \
1368 TITLE || '-' || LAYER_NAME || '-' || BAND VALUE \ 1368 TITLE || '-' || LAYER_NAME || '-' || BAND VALUE \
1393 layer_colums= SELECT OWNER || '.' || TABLE_NAME || '.' || COLUMN_NAME \ 1393 layer_colums= SELECT OWNER || '.' || TABLE_NAME || '.' || COLUMN_NAME \
1394 FROM SDE.COLUMN_REGISTRY \ 1394 FROM SDE.COLUMN_REGISTRY \
1395 WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \ 1395 WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \
1396 OWNER = '?' AND \ 1396 OWNER = '?' AND \
1397 TABLE_NAME = '?' 1397 TABLE_NAME = '?'
1398
1399 geometry_type = select geometry_type \
1400 from sde.geometry_columns \
1401 where f_table_schema = '?' and \
1402 f_table_name = '?' and \
1403 f_geometry_column='SHAPE'

http://dive4elements.wald.intevation.org