comparison gnv-artifacts/doc/conf/queries.properties @ 604:938ce81a6bd0

Integrated Database-Support for the Mapviewer-Interface gnv-artifacts/trunk@666 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 09 Feb 2010 13:01:20 +0000
parents d2f97cb2ac32
children 93978859fa9e
comparison
equal deleted inserted replaced
603:78499af390a2 604:938ce81a6bd0
1189 ORDER BY NAME 1189 ORDER BY NAME
1190 1190
1191 rasterQuery = SELECT ST_ASTEXT(RASTER) \ 1191 rasterQuery = SELECT ST_ASTEXT(RASTER) \
1192 FROM MEDIAN.TOPO_WORLD_2MIN \ 1192 FROM MEDIAN.TOPO_WORLD_2MIN \
1193 WHERE INTERSECTS(RASTER, "?") 1193 WHERE INTERSECTS(RASTER, "?")
1194
1195 mapviewer_interface_fis_region = SELECT ID_FIS \
1196 FROM MEDIAN.FEATUREAREA, \
1197 MEDIAN.FIS_HAS_REGION FHR \
1198 WHERE FHR.FEATUREID = MEDIAN.FEATUREAREA.FEATUREID AND \
1199 FHR.FEATURETYPE = MEDIAN.FEATUREAREA.FEATURETYPE AND \
1200 FHR.FEATURECODE = MEDIAN.FEATUREAREA.FEATURECODE AND \
1201 INTERSECTS(SHAPE,"?")
1202
1203 mapviewer_interface_mapservices_has_fis = SELECT DISTINCT ID_FIS, \
1204 ID_MAPSERVICE \
1205 FROM MEDIAN.FIS_HAS_MAPSERVICE \
1206 WHERE ID_MAPSERVICE IN (?)
1207
1208 mapviewer_interface_mapservices_has_parameter = SELECT DISTINCT ID_PARAMETER \
1209 FROM MEDIAN.MAPSERVICE_HAS_PARAMETER \
1210 WHERE ID_MAPSERVICE = ?
1211
1212 mapviewer_interface_mapservices_has_parameter_using_layer = SELECT DISTINCT ID_PARAMETER \
1213 FROM MEDIAN.LAYER_HAS_PARAMETER \
1214 WHERE ID_MAPSERVICE = ? AND \
1215 ID_LAYER IN (?)

http://dive4elements.wald.intevation.org