Mercurial > dive4elements > gnv-client
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 \ |