diff gnv-artifacts/doc/conf/queries.properties @ 762:b3f922908a31

ISSUE122: Added all required Columns for the CSV-Export. gnv-artifacts/trunk@817 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 22 Mar 2010 12:47:44 +0000
parents 1614b27dcbfa
children f28a7eac542a
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Mon Mar 22 11:23:33 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Mon Mar 22 12:47:44 2010 +0000
@@ -304,7 +304,9 @@
            TS.PARAMETERID GROUP1, \
            TSV.TIMEVALUE GROUP2, \
            1 GROUP3, \
-           1 DATAID \
+           1 DATAID, \
+           M.FEATUREID, \
+           TS.TIMESERIESID \
     from MEDIAN.TIMESERIES TS, \
          MEDIAN.TIMESERIESVALUE TSV, \
          MEDIAN.MEASUREMENT M \
@@ -464,7 +466,9 @@
            msv.PARAMETERID GROUP1, \
            msv.TIMEVALUE GROUP2, \
            1 GROUP3, \
-           2 DATAID \
+           2 DATAID, \
+           MP.FEATUREID, \
+           MP.MESHID \
     from MEDIAN.MESHLAYER ml, \
          MEDIAN.MESHPOINT mp, \
          MEDIAN.MESH m, \
@@ -609,7 +613,9 @@
         MSV.PARAMETERID GROUP1, \
         IP.TIMEVALUE GROUP2, \
         1 GROUP3, \
-        3 DATAID \
+        3 DATAID, \
+        IP.FEATUREID, \
+        IP.SERIESID \
     FROM MEDIAN.INSTANTANEOUSPOINT IP, \
          MEDIAN.MEASUREMENT M, \
          MEDIAN.MEASUREDSCALARVALUE MSV \
@@ -857,7 +863,8 @@
         MSV.PARAMETERID GROUP1, \
         ZLOCATION GROUP2, \
         1 GROUP3, \
-        3 DATAID \
+        3 DATAID, \
+        MEDIAN.INSTANTANEOUSPOINT.SURVEYID \
     FROM MEDIAN.INSTANTANEOUSPOINT, \
          MEDIAN.MEASUREMENT M, \
          MEDIAN.MEASUREDSCALARVALUE MSV \
@@ -927,7 +934,8 @@
            msv.TIMEVALUE GROUP3, \
            MEDIAN.MESHPOINT.JPOSITION, \
            MEDIAN.MESHPOINT.IPOSITION, \
-           2 DATAID \
+           2 DATAID, \
+           MEDIAN.MESHPOINT.MESHID \
     from MEDIAN.MESHLAYER ml, \
          MEDIAN.MESHPOINT, \
          MEDIAN.MESH m, \

http://dive4elements.wald.intevation.org