Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 1101:e38f93d64253

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
A depth in an odv export has a negative value now (issue230). gnv-artifacts/trunk@1227 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 28 Jun 2010 09:33:11 +0000
parents fb2d07f7a5ae
children 19813e72ec06
comparison
equal deleted inserted replaced
1100:2e50dfd45753 1101:e38f93d64253
521 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \ 521 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \
522 MEDIAN.TIMESERIESPOINT.NAME STATION, \ 522 MEDIAN.TIMESERIESPOINT.NAME STATION, \
523 '*' TYPE, \ 523 '*' TYPE, \
524 ST_ASTEXT(SHAPE), \ 524 ST_ASTEXT(SHAPE), \
525 0 BOTDEPTH, \ 525 0 BOTDEPTH, \
526 (M.ZLOCATION *-1) DEPTH, \ 526 (M.ZLOCATION) DEPTH, \
527 TSV.TIMEVALUE, \ 527 TSV.TIMEVALUE, \
528 TSV.DATAVALUE, \ 528 TSV.DATAVALUE, \
529 TS.PARAMETERID PARAMETER, \ 529 TS.PARAMETERID PARAMETER, \
530 TSV.MEASUREMENTID, \ 530 TSV.MEASUREMENTID, \
531 TSV.TIMESERIESID, \ 531 TSV.TIMESERIESID, \
635 verticalprofile_odv_data_vector = SELECT SI.NAME CRUISE, \ 635 verticalprofile_odv_data_vector = SELECT SI.NAME CRUISE, \
636 MEDIAN.TIMESERIESPOINT.NAME STATION, \ 636 MEDIAN.TIMESERIESPOINT.NAME STATION, \
637 '*' TYPE, \ 637 '*' TYPE, \
638 ST_ASTEXT(SHAPE), \ 638 ST_ASTEXT(SHAPE), \
639 0 BOTDEPTH, \ 639 0 BOTDEPTH, \
640 (M.ZLOCATION *-1) DEPTH, \ 640 (M.ZLOCATION) DEPTH, \
641 TVV.TIMEVALUE, \ 641 TVV.TIMEVALUE, \
642 TVV.XCOMPONENT, \ 642 TVV.XCOMPONENT, \
643 TVV.YCOMPONENT, \ 643 TVV.YCOMPONENT, \
644 TVV.ZCOMPONENT, \ 644 TVV.ZCOMPONENT, \
645 TVV.SPEED, \ 645 TVV.SPEED, \
814 verticalprofile_mesh_odv_data=select SI.NAME CRUISE, \ 814 verticalprofile_mesh_odv_data=select SI.NAME CRUISE, \
815 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ 815 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
816 '*' TYPE, \ 816 '*' TYPE, \
817 ST_ASTEXT(SHAPE), \ 817 ST_ASTEXT(SHAPE), \
818 0 BOTDEPTH, \ 818 0 BOTDEPTH, \
819 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 819 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)) DEPTH, \
820 msv.DATAVALUE, \ 820 msv.DATAVALUE, \
821 msv.PARAMETERID PARAMETER, \ 821 msv.PARAMETERID PARAMETER, \
822 msv.TIMEVALUE , \ 822 msv.TIMEVALUE , \
823 '1' QF \ 823 '1' QF \
824 from MEDIAN.MESHLAYER ml, \ 824 from MEDIAN.MESHLAYER ml, \
936 verticalprofile_mesh_odv_data_vector=SELECT SI.NAME CRUISE, \ 936 verticalprofile_mesh_odv_data_vector=SELECT SI.NAME CRUISE, \
937 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ 937 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
938 '*' TYPE, \ 938 '*' TYPE, \
939 ST_ASTEXT(SHAPE), \ 939 ST_ASTEXT(SHAPE), \
940 0 BOTDEPTH, \ 940 0 BOTDEPTH, \
941 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 941 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)) DEPTH, \
942 MVV.XCOMPONENT, \ 942 MVV.XCOMPONENT, \
943 MVV.YCOMPONENT, \ 943 MVV.YCOMPONENT, \
944 MVV.ZCOMPONENT, \ 944 MVV.ZCOMPONENT, \
945 MVV.SPEED, \ 945 MVV.SPEED, \
946 MVV.DIRECTION, \ 946 MVV.DIRECTION, \
1121 verticalprofile_instantaneouspoint_odv_data = SELECT S.DESCRIPTION CRUISE, \ 1121 verticalprofile_instantaneouspoint_odv_data = SELECT S.DESCRIPTION CRUISE, \
1122 MEDIAN.INSTANTANEOUSPOINT.FEATUREID STATION, \ 1122 MEDIAN.INSTANTANEOUSPOINT.FEATUREID STATION, \
1123 '*' TYPE, \ 1123 '*' TYPE, \
1124 ST_ASTEXT(SHAPE), \ 1124 ST_ASTEXT(SHAPE), \
1125 0 BOTDEPTH, \ 1125 0 BOTDEPTH, \
1126 (M.ZLOCATION * -1) DEPTH, \ 1126 (M.ZLOCATION) DEPTH, \
1127 MSV.DATAVALUE, \ 1127 MSV.DATAVALUE, \
1128 MSV.PARAMETERID PARAMETER, \ 1128 MSV.PARAMETERID PARAMETER, \
1129 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE , \ 1129 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE , \
1130 '1' QF \ 1130 '1' QF \
1131 FROM MEDIAN.SERIES S, \ 1131 FROM MEDIAN.SERIES S, \
http://dive4elements.wald.intevation.org