Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 223:05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
gnv-artifacts/trunk@287 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Thu, 05 Nov 2009 15:16:51 +0000 |
| parents | 926530bda1a7 |
| children | 2b7a40b5b535 |
comparison
equal
deleted
inserted
replaced
| 222:3e82b4f1c455 | 223:05663e307495 |
|---|---|
| 223 verticalprofile_mesh = SELECT OBJECTID KEY, \ | 223 verticalprofile_mesh = SELECT OBJECTID KEY, \ |
| 224 m.NAME VALUE \ | 224 m.NAME VALUE \ |
| 225 FROM MEDIAN.MESH m \ | 225 FROM MEDIAN.MESH m \ |
| 226 WHERE SOURCEID IN (?) \ | 226 WHERE SOURCEID IN (?) \ |
| 227 order by m.NAME | 227 order by m.NAME |
| 228 | |
| 229 verticalprofile_mesh_with_area = SELECT M.OBJECTID KEY, \ | |
| 230 M.NAME VALUE \ | |
| 231 FROM MEDIAN.MESHPOINT, \ | |
| 232 MEDIAN.MESH M \ | |
| 233 WHERE M.SOURCEID IN (?) AND \ | |
| 234 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 235 INTERSECTS(SHAPE, \ | |
| 236 (SELECT st_astext(SHAPE) \ | |
| 237 FROM MEDIAN.FEATUREAREA \ | |
| 238 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
| 239 FEATURECODE = ? )\ | |
| 240 ) \ | |
| 241 order by M.NAME | |
| 228 | 242 |
| 229 verticalprofile_mesh_point = SELECT FEATUREID, \ | 243 verticalprofile_mesh_point = SELECT FEATUREID, \ |
| 230 ST_ASTEXT(SHAPE) \ | 244 ST_ASTEXT(SHAPE) \ |
| 231 FROM MEDIAN.MESHPOINT \ | 245 FROM MEDIAN.MESHPOINT \ |
| 232 WHERE MESHID in \ | 246 WHERE MESHID in \ |
| 638 MSV.TIMEVALUE = ? AND \ | 652 MSV.TIMEVALUE = ? AND \ |
| 639 M.OBJECTID = ? AND \ | 653 M.OBJECTID = ? AND \ |
| 640 MEDIAN.MESHFACE.KPOSITION = ? \ | 654 MEDIAN.MESHFACE.KPOSITION = ? \ |
| 641 order by MEDIAN.MESHFACE.JPOSITION , \ | 655 order by MEDIAN.MESHFACE.JPOSITION , \ |
| 642 MEDIAN.MESHFACE.IPOSITION | 656 MEDIAN.MESHFACE.IPOSITION |
| 657 | |
| 658 | |
| 659 area_filter = SELECT DISTINCT \ | |
| 660 FEATUREID KEY ,\ | |
| 661 DESCRIPTION VALUE \ | |
| 662 FROM MEDIAN.FEATUREAREA \ | |
| 663 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
| 664 FEATUREID > 0 \ | |
| 665 ORDER BY FEATUREID | |
| 666 | |
| 667 subarea_filter = SELECT \ | |
| 668 FEATURECODE KEY, \ | |
| 669 NAME VALUE \ | |
| 670 FROM MEDIAN.FEATUREAREA \ | |
| 671 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
| 672 FEATUREID = ? \ | |
| 673 ORDER BY NAME | |
| 674 |