Mercurial > dive4elements > gnv-client
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 (?) |