Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 336:1b9ca0f2d498

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added marker for different data sources in sql queries. gnv-artifacts/trunk@402 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Tue, 08 Dec 2009 11:18:27 +0000
parents 3eff9241ea1e
children c94936b1f4ba
comparison
equal deleted inserted replaced
335:e964a3d8f7bc 336:1b9ca0f2d498
272 272
273 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ 273 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \
274 TSV.DATAVALUE YORDINATE, \ 274 TSV.DATAVALUE YORDINATE, \
275 TS.PARAMETERID GROUP1, \ 275 TS.PARAMETERID GROUP1, \
276 TSV.TIMEVALUE GROUP2, \ 276 TSV.TIMEVALUE GROUP2, \
277 1 GROUP3 \ 277 1 GROUP3, \
278 1 DATAID \
278 from MEDIAN.TIMESERIES TS, \ 279 from MEDIAN.TIMESERIES TS, \
279 MEDIAN.TIMESERIESVALUE TSV, \ 280 MEDIAN.TIMESERIESVALUE TSV, \
280 MEDIAN.MEASUREMENT M \ 281 MEDIAN.MEASUREMENT M \
281 where TS.TIMESERIESID = TSV.TIMESERIESID AND \ 282 where TS.TIMESERIESID = TSV.TIMESERIESID AND \
282 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ 283 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
407 408
408 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ 409 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
409 msv.DATAVALUE YORDINATE, \ 410 msv.DATAVALUE YORDINATE, \
410 msv.PARAMETERID GROUP1, \ 411 msv.PARAMETERID GROUP1, \
411 msv.TIMEVALUE GROUP2, \ 412 msv.TIMEVALUE GROUP2, \
412 1 GROUP3 \ 413 1 GROUP3, \
414 2 DATAID \
413 from MEDIAN.MESHLAYER ml, \ 415 from MEDIAN.MESHLAYER ml, \
414 MEDIAN.MESHPOINT mp, \ 416 MEDIAN.MESHPOINT mp, \
415 MEDIAN.MESH m, \ 417 MEDIAN.MESH m, \
416 MEDIAN.MESHSCALARVALUE msv \ 418 MEDIAN.MESHSCALARVALUE msv \
417 where msv.FEATUREID = mp. FEATUREID AND \ 419 where msv.FEATUREID = mp. FEATUREID AND \
550 552
551 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ 553 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
552 MSV.DATAVALUE YORDINATE, \ 554 MSV.DATAVALUE YORDINATE, \
553 MSV.PARAMETERID GROUP1, \ 555 MSV.PARAMETERID GROUP1, \
554 IP.TIMEVALUE GROUP2, \ 556 IP.TIMEVALUE GROUP2, \
555 1 GROUP3 \ 557 1 GROUP3, \
558 3 DATAID \
556 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ 559 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
557 MEDIAN.MEASUREMENT M, \ 560 MEDIAN.MEASUREMENT M, \
558 MEDIAN.MEASUREDSCALARVALUE MSV \ 561 MEDIAN.MEASUREDSCALARVALUE MSV \
559 WHERE IP.FEATUREID = M.FEATUREID AND \ 562 WHERE IP.FEATUREID = M.FEATUREID AND \
560 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 563 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
740 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE), \ 743 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE), \
741 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \ 744 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \
742 MSV.DATAVALUE YORDINATE, \ 745 MSV.DATAVALUE YORDINATE, \
743 MSV.PARAMETERID GROUP1, \ 746 MSV.PARAMETERID GROUP1, \
744 ZLOCATION GROUP2, \ 747 ZLOCATION GROUP2, \
745 1 GROUP3 \ 748 1 GROUP3, \
749 3 DATAID \
746 FROM MEDIAN.INSTANTANEOUSPOINT, \ 750 FROM MEDIAN.INSTANTANEOUSPOINT, \
747 MEDIAN.MEASUREMENT M, \ 751 MEDIAN.MEASUREMENT M, \
748 MEDIAN.MEASUREDSCALARVALUE MSV \ 752 MEDIAN.MEASUREDSCALARVALUE MSV \
749 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ 753 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
750 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 754 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
809 msv.DATAVALUE YORDINATE, \ 813 msv.DATAVALUE YORDINATE, \
810 msv.PARAMETERID GROUP1, \ 814 msv.PARAMETERID GROUP1, \
811 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ 815 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
812 msv.TIMEVALUE GROUP3, \ 816 msv.TIMEVALUE GROUP3, \
813 MEDIAN.MESHPOINT.JPOSITION, \ 817 MEDIAN.MESHPOINT.JPOSITION, \
814 MEDIAN.MESHPOINT.IPOSITION \ 818 MEDIAN.MESHPOINT.IPOSITION, \
819 2 DATAID \
815 from MEDIAN.MESHLAYER ml, \ 820 from MEDIAN.MESHLAYER ml, \
816 MEDIAN.MESHPOINT, \ 821 MEDIAN.MESHPOINT, \
817 MEDIAN.MESH m, \ 822 MEDIAN.MESH m, \
818 MEDIAN.MESHSCALARVALUE msv \ 823 MEDIAN.MESHSCALARVALUE msv \
819 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ 824 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
937 MSV.TIMEVALUE, \ 942 MSV.TIMEVALUE, \
938 MSV.DATAVALUE, \ 943 MSV.DATAVALUE, \
939 MSV.PARAMETERID PARAMETER, \ 944 MSV.PARAMETERID PARAMETER, \
940 MEDIAN.MESHPOINT.JPOSITION, \ 945 MEDIAN.MESHPOINT.JPOSITION, \
941 MEDIAN.MESHPOINT.IPOSITION, \ 946 MEDIAN.MESHPOINT.IPOSITION, \
942 MEDIAN.MESHPOINT.KPOSITION \ 947 MEDIAN.MESHPOINT.KPOSITION, \
948 2 DATAID \
943 from MEDIAN.MESHLAYER ml, \ 949 from MEDIAN.MESHLAYER ml, \
944 MEDIAN.MESHPOINT, \ 950 MEDIAN.MESHPOINT, \
945 MEDIAN.MESH m, \ 951 MEDIAN.MESH m, \
946 MEDIAN.SOURCEINFO SI, \ 952 MEDIAN.SOURCEINFO SI, \
947 MEDIAN.MESHSCALARVALUE msv \ 953 MEDIAN.MESHSCALARVALUE msv \
997 1003
998 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ 1004 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \
999 MSV.DATAVALUE YORDINATE, \ 1005 MSV.DATAVALUE YORDINATE, \
1000 MEDIAN.MESHFACE.JPOSITION, \ 1006 MEDIAN.MESHFACE.JPOSITION, \
1001 MEDIAN.MESHFACE.IPOSITION, \ 1007 MEDIAN.MESHFACE.IPOSITION, \
1002 MEDIAN.MESHFACE.KPOSITION \ 1008 MEDIAN.MESHFACE.KPOSITION, \
1009 2 DATAID \
1003 from MEDIAN.MESHLAYER ML, \ 1010 from MEDIAN.MESHLAYER ML, \
1004 MEDIAN.MESHFACE, \ 1011 MEDIAN.MESHFACE, \
1005 MEDIAN.MESH M, \ 1012 MEDIAN.MESH M, \
1006 MEDIAN.MESHSCALARVALUE MSV \ 1013 MEDIAN.MESHSCALARVALUE MSV \
1007 where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \ 1014 where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \
http://dive4elements.wald.intevation.org