Mercurial > dive4elements > gnv-client
comparison geo-backend/src/test/ressources/QueryExecutorTestCase.properties @ 269:db8920c5346d
Added further Queries for Testing Spatial-Query-Support
geo-backend/trunk@220 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 14 Oct 2009 10:58:49 +0000 |
| parents | 000e00592ba5 |
| children | ff1b7967e6b9 |
comparison
equal
deleted
inserted
replaced
| 268:71b2f263f036 | 269:db8920c5346d |
|---|---|
| 33 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = 1895 AND \ | 33 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = 1895 AND \ |
| 34 m.ZLOCATION IN (-16.843 , -15.852) AND \ | 34 m.ZLOCATION IN (-16.843 , -15.852) AND \ |
| 35 MSV.PARAMETERID in (2 , 1) \ | 35 MSV.PARAMETERID in (2 , 1) \ |
| 36 ORDER BY MSV.PARAMETERID, \ | 36 ORDER BY MSV.PARAMETERID, \ |
| 37 m.ZLOCATION | 37 m.ZLOCATION |
| 38 | |
| 39 spatial_query_without_intersects2 = SELECT ST_ASTEXT(SHAPE), \ | |
| 40 msv.DATAVALUE YORDINATE, \ | |
| 41 msv.PARAMETERID GROUP1, \ | |
| 42 msv.TIMEVALUE GROUP2, \ | |
| 43 MEDIAN.MESHPOINT.KPOSITION GROUP3, \ | |
| 44 MEDIAN.MESHPOINT.JPOSITION , \ | |
| 45 MEDIAN.MESHPOINT.IPOSITION \ | |
| 46 from MEDIAN.MESHLAYER ml, \ | |
| 47 MEDIAN.MESHPOINT , \ | |
| 48 MEDIAN.MESH m, \ | |
| 49 MEDIAN.MESHSCALARVALUE msv \ | |
| 50 where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ | |
| 51 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 52 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 53 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 54 m.PARTIDMIN <= msv.PARTID AND \ | |
| 55 m.PARTIDMAX >= msv.PARTID AND \ | |
| 56 msv.PARAMETERID in (2,1) AND \ | |
| 57 msv.TIMEVALUE in (to_date('2009.10.15 23:00:00', 'YYYY.MM.DD HH24:MI:SS')) AND \ | |
| 58 m.OBJECTID = 3 AND \ | |
| 59 MEDIAN.MESHPOINT.FEATUREID in \ | |
| 60 ( select FEATUREID \ | |
| 61 from MEDIAN.MESHPOINT mp, \ | |
| 62 MEDIAN.MESH m \ | |
| 63 where m.OBJECTID = 3 AND \ | |
| 64 mp.MESHID = m.MESHID AND \ | |
| 65 KPOSITION in ( 1 ) and \ | |
| 66 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = 2003771)) \ | |
| 67 order by MEDIAN.MESHPOINT.KPOSITION, \ | |
| 68 msv.TIMEVALUE, \ | |
| 69 msv.PARAMETERID, \ | |
| 70 MEDIAN.MESHPOINT.JPOSITION , \ | |
| 71 MEDIAN.MESHPOINT.IPOSITION |