diff gnv-artifacts/doc/conf/queries.properties @ 776:cee3a0c22bb1

Modified the Workflow for Verticalprofiles on Instantaneouspoints so that the Inputvalues of the Mapviewer-Interface take effect. Also integrated the Regionfilter to this Product gnv-artifacts/trunk@843 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 26 Mar 2010 15:29:41 +0000
parents f28a7eac542a
children feeaf5aec552
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Fri Mar 26 15:20:32 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri Mar 26 15:29:41 2010 +0000
@@ -569,12 +569,24 @@
           MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
           M.SOURCEID= ? AND \
           INTERSECTS(SHAPE, \
-                     (SELECT st_astext(SHAPE) \
-                      FROM MEDIAN.FEATUREAREA \
-                      WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
-                             FEATURECODE = ? )\
+                    (SELECT st_astext(SHAPE) \
+                     FROM MEDIAN.FEATUREAREA \
+                     WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
+                            FEATURECODE = ? )\
                      ) \
     ORDER BY S.DESCRIPTION
+verticalprofile_instantaneouspoint_series_with_wkt = SELECT \
+        S.SERIESID KEY, \
+        S.DESCRIPTION VALUE \
+    FROM MEDIAN.INSTANTANEOUSPOINT, \
+         MEDIAN.SERIES S, \
+         MEDIAN.MEASUREMENT M \
+    WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \
+          MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
+          MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
+          M.SOURCEID= ? AND \
+          INTERSECTS(SHAPE, "?") \
+    ORDER BY S.DESCRIPTION
     
 verticalprofile_instantaneouspoint_point = SELECT \
         MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
@@ -590,6 +602,41 @@
     ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
              MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
 
+verticalprofile_instantaneouspoint_point_with_aera = 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 MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
+          MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
+          MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
+          M.SOURCEID = ? AND \
+          INTERSECTS(SHAPE, \
+                    (SELECT st_astext(SHAPE) \
+                     FROM MEDIAN.FEATUREAREA \
+                     WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
+                            FEATURECODE = ? )\
+                     ) \
+    ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
+             MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
+             
+verticalprofile_instantaneouspoint_point_with_wkt = 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 MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
+          MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
+          MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
+          M.SOURCEID = ? AND \
+          INTERSECTS(SHAPE,"?") \
+    ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
+             MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
+
 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
         P.PARAMETERID KEY, \
         p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \

http://dive4elements.wald.intevation.org