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 (?) |