Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 205:6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
gnv-artifacts/trunk@261 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Thu, 22 Oct 2009 14:02:30 +0000 |
| parents | b66e8a6f3907 |
| children | 01ac348ac4a4 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Thu Oct 22 08:50:21 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Thu Oct 22 14:02:30 2009 +0000 @@ -313,17 +313,19 @@ M.SOURCEID= ? \ ORDER BY S.DESCRIPTION -verticalprofile_instantaneouspoint_point = SELECT DISTINCT \ - I.FEATUREID KEY, \ - to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \ - I.TIMEVALUE \ - FROM MEDIAN.INSTANTANEOUSPOINT I, \ +verticalprofile_instantaneouspoint_point = SELECT \ + MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ + to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ + MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ + ST_ASTEXT(SHAPE) \ + FROM MEDIAN.INSTANTANEOUSPOINT, \ MEDIAN.MEASUREMENT M \ - WHERE I.SERIESID = ? AND \ - I.POINTSPEC = 4 AND \ - I.FEATUREID = M.FEATUREID AND \ + WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ + MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ + MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ M.SOURCEID = ? \ - ORDER BY I.TIMEVALUE + ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ + MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ P.PARAMETERID KEY , \ @@ -388,8 +390,7 @@ S.SURVEYID = I.SURVEYID AND \ I.FEATUREID = M.FEATUREID AND \ C.VEHICLEID = ? AND \ - M.SOURCEID = ? AND \ - C.NAME IS NOT NULL \ + M.SOURCEID = ? \ ORDER BY C.NAME horizontalprofile_instantaneouspoint_track= SELECT \ T.TRACKID KEY , \ @@ -544,9 +545,8 @@ where m.OBJECTID = ? AND \ mp.MESHID = m.MESHID AND \ ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ - order by msv.TIMEVALUE, \ - msv.PARAMETERID, \ - MEDIAN.MESHPOINT.JPOSITION , \ - MEDIAN.MESHPOINT.IPOSITION, \ - MEDIAN.MESHPOINT.KPOSITION - \ No newline at end of file + order by msv.TIMEVALUE, \ + msv.PARAMETERID, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION, \ + MEDIAN.MESHPOINT.KPOSITION \ No newline at end of file