comparison 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
comparison
equal deleted inserted replaced
761:0b1de7e38907 762:b3f922908a31
302 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ 302 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \
303 TSV.DATAVALUE YORDINATE, \ 303 TSV.DATAVALUE YORDINATE, \
304 TS.PARAMETERID GROUP1, \ 304 TS.PARAMETERID GROUP1, \
305 TSV.TIMEVALUE GROUP2, \ 305 TSV.TIMEVALUE GROUP2, \
306 1 GROUP3, \ 306 1 GROUP3, \
307 1 DATAID \ 307 1 DATAID, \
308 M.FEATUREID, \
309 TS.TIMESERIESID \
308 from MEDIAN.TIMESERIES TS, \ 310 from MEDIAN.TIMESERIES TS, \
309 MEDIAN.TIMESERIESVALUE TSV, \ 311 MEDIAN.TIMESERIESVALUE TSV, \
310 MEDIAN.MEASUREMENT M \ 312 MEDIAN.MEASUREMENT M \
311 where TS.TIMESERIESID = TSV.TIMESERIESID AND \ 313 where TS.TIMESERIESID = TSV.TIMESERIESID AND \
312 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ 314 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
462 msv.DATAVALUE YORDINATE, \ 464 msv.DATAVALUE YORDINATE, \
463 mp.KPOSITION KPOSITION, \ 465 mp.KPOSITION KPOSITION, \
464 msv.PARAMETERID GROUP1, \ 466 msv.PARAMETERID GROUP1, \
465 msv.TIMEVALUE GROUP2, \ 467 msv.TIMEVALUE GROUP2, \
466 1 GROUP3, \ 468 1 GROUP3, \
467 2 DATAID \ 469 2 DATAID, \
470 MP.FEATUREID, \
471 MP.MESHID \
468 from MEDIAN.MESHLAYER ml, \ 472 from MEDIAN.MESHLAYER ml, \
469 MEDIAN.MESHPOINT mp, \ 473 MEDIAN.MESHPOINT mp, \
470 MEDIAN.MESH m, \ 474 MEDIAN.MESH m, \
471 MEDIAN.MESHSCALARVALUE msv \ 475 MEDIAN.MESHSCALARVALUE msv \
472 where msv.FEATUREID = mp. FEATUREID AND \ 476 where msv.FEATUREID = mp. FEATUREID AND \
607 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ 611 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
608 MSV.DATAVALUE YORDINATE, \ 612 MSV.DATAVALUE YORDINATE, \
609 MSV.PARAMETERID GROUP1, \ 613 MSV.PARAMETERID GROUP1, \
610 IP.TIMEVALUE GROUP2, \ 614 IP.TIMEVALUE GROUP2, \
611 1 GROUP3, \ 615 1 GROUP3, \
612 3 DATAID \ 616 3 DATAID, \
617 IP.FEATUREID, \
618 IP.SERIESID \
613 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ 619 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
614 MEDIAN.MEASUREMENT M, \ 620 MEDIAN.MEASUREMENT M, \
615 MEDIAN.MEASUREDSCALARVALUE MSV \ 621 MEDIAN.MEASUREDSCALARVALUE MSV \
616 WHERE IP.FEATUREID = M.FEATUREID AND \ 622 WHERE IP.FEATUREID = M.FEATUREID AND \
617 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 623 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
855 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \ 861 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \
856 MSV.DATAVALUE YORDINATE, \ 862 MSV.DATAVALUE YORDINATE, \
857 MSV.PARAMETERID GROUP1, \ 863 MSV.PARAMETERID GROUP1, \
858 ZLOCATION GROUP2, \ 864 ZLOCATION GROUP2, \
859 1 GROUP3, \ 865 1 GROUP3, \
860 3 DATAID \ 866 3 DATAID, \
867 MEDIAN.INSTANTANEOUSPOINT.SURVEYID \
861 FROM MEDIAN.INSTANTANEOUSPOINT, \ 868 FROM MEDIAN.INSTANTANEOUSPOINT, \
862 MEDIAN.MEASUREMENT M, \ 869 MEDIAN.MEASUREMENT M, \
863 MEDIAN.MEASUREDSCALARVALUE MSV \ 870 MEDIAN.MEASUREDSCALARVALUE MSV \
864 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ 871 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
865 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 872 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
925 msv.PARAMETERID GROUP1, \ 932 msv.PARAMETERID GROUP1, \
926 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ 933 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
927 msv.TIMEVALUE GROUP3, \ 934 msv.TIMEVALUE GROUP3, \
928 MEDIAN.MESHPOINT.JPOSITION, \ 935 MEDIAN.MESHPOINT.JPOSITION, \
929 MEDIAN.MESHPOINT.IPOSITION, \ 936 MEDIAN.MESHPOINT.IPOSITION, \
930 2 DATAID \ 937 2 DATAID, \
938 MEDIAN.MESHPOINT.MESHID \
931 from MEDIAN.MESHLAYER ml, \ 939 from MEDIAN.MESHLAYER ml, \
932 MEDIAN.MESHPOINT, \ 940 MEDIAN.MESHPOINT, \
933 MEDIAN.MESH m, \ 941 MEDIAN.MESH m, \
934 MEDIAN.MESHSCALARVALUE msv \ 942 MEDIAN.MESHSCALARVALUE msv \
935 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ 943 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \

http://dive4elements.wald.intevation.org