comparison gnv-artifacts/doc/conf/queries.properties @ 356:3eee1369c79b

Added the Unit of the Parameter to the Query for Parameters in all Parameterqueries where it was still missing. Now the Unit will be displaied in the Combobox and in the Diagramm-Axis-Description gnv-artifacts/trunk@429 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 15 Dec 2009 14:55:42 +0000
parents 24c21a720aa5
children 061355435075
comparison
equal deleted inserted replaced
355:fce70ff3486b 356:3eee1369c79b
146 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ 146 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
147 ORDER BY ML.UPPERZLOCATION DESC 147 ORDER BY ML.UPPERZLOCATION DESC
148 148
149 timeseries_mesh_parameter=SELECT distinct \ 149 timeseries_mesh_parameter=SELECT distinct \
150 p.PARAMETERID KEY, \ 150 p.PARAMETERID KEY, \
151 p.GERMANNAME VALUE \ 151 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
152 p.GERMANNAME \
152 from MEDIAN.PARAMETER p, \ 153 from MEDIAN.PARAMETER p, \
153 MEDIAN.MESHSCALARVALUE msc, \ 154 MEDIAN.MESHSCALARVALUE msc, \
154 MEDIAN.MESH m \ 155 MEDIAN.MESH m \
155 where m.OBJECTID = ? AND \ 156 where m.OBJECTID = ? AND \
156 msc.PARTID = m.PARTIDMIN AND \ 157 msc.PARTID = m.PARTIDMIN AND \
236 mmt.SOURCEID = ? \ 237 mmt.SOURCEID = ? \
237 order by tsp.name 238 order by tsp.name
238 239
239 verticalprofile_parameter=SELECT DISTINCT \ 240 verticalprofile_parameter=SELECT DISTINCT \
240 p.PARAMETERID KEY, \ 241 p.PARAMETERID KEY, \
241 p.GERMANNAME VALUE \ 242 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
243 p.GERMANNAME \
242 from MEDIAN.PARAMETER p, \ 244 from MEDIAN.PARAMETER p, \
243 MEDIAN.TIMESERIES ts, \ 245 MEDIAN.TIMESERIES ts, \
244 MEDIAN.TIMESERIESVALUE tsv, \ 246 MEDIAN.TIMESERIESVALUE tsv, \
245 MEDIAN.MEASUREMENT m \ 247 MEDIAN.MEASUREMENT m \
246 where ts.PARAMETERID = p.PARAMETERID and \ 248 where ts.PARAMETERID = p.PARAMETERID and \
385 MP.KPOSITION < ? \ 387 MP.KPOSITION < ? \
386 ORDER BY ML.UPPERZLOCATION DESC 388 ORDER BY ML.UPPERZLOCATION DESC
387 389
388 verticalprofile_mesh_parameter=SELECT distinct \ 390 verticalprofile_mesh_parameter=SELECT distinct \
389 p.PARAMETERID KEY, \ 391 p.PARAMETERID KEY, \
390 p.GERMANNAME VALUE \ 392 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
393 p.GERMANNAME \
391 from MEDIAN.PARAMETER p, \ 394 from MEDIAN.PARAMETER p, \
392 MEDIAN.MESHSCALARVALUE msc, \ 395 MEDIAN.MESHSCALARVALUE msc, \
393 MEDIAN.MESH m \ 396 MEDIAN.MESH m \
394 where m.OBJECTID = ? AND \ 397 where m.OBJECTID = ? AND \
395 m.PARTIDMIN = msc.PARTID AND \ 398 m.PARTIDMIN = msc.PARTID AND \
528 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ 531 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
529 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE 532 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
530 533
531 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ 534 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
532 P.PARAMETERID KEY, \ 535 P.PARAMETERID KEY, \
533 P.GERMANNAME VALUE \ 536 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
537 p.GERMANNAME \
534 FROM MEDIAN.PARAMETER P, \ 538 FROM MEDIAN.PARAMETER P, \
535 MEDIAN.INSTANTANEOUSPOINT IP, \ 539 MEDIAN.INSTANTANEOUSPOINT IP, \
536 MEDIAN.MEASUREMENT M, \ 540 MEDIAN.MEASUREMENT M, \
537 MEDIAN.MEASUREDSCALARVALUE MSV \ 541 MEDIAN.MEASUREDSCALARVALUE MSV \
538 WHERE IP.FEATUREID = M.FEATUREID AND \ 542 WHERE IP.FEATUREID = M.FEATUREID AND \
721 ORDER BY STARTDATE, \ 725 ORDER BY STARTDATE, \
722 ENDDATE, \ 726 ENDDATE, \
723 DESCRIPTION 727 DESCRIPTION
724 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ 728 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
725 P.PARAMETERID KEY, \ 729 P.PARAMETERID KEY, \
726 P.GERMANNAME VALUE \ 730 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
731 p.GERMANNAME \
727 FROM MEDIAN.PARAMETER P, \ 732 FROM MEDIAN.PARAMETER P, \
728 MEDIAN.MEASUREMENT M, \ 733 MEDIAN.MEASUREMENT M, \
729 MEDIAN.INSTANTANEOUSPOINT IP, \ 734 MEDIAN.INSTANTANEOUSPOINT IP, \
730 MEDIAN.MEASUREDSCALARVALUE MSV \ 735 MEDIAN.MEASUREDSCALARVALUE MSV \
731 WHERE P.PARAMETERID = MSV.PARAMETERID AND \ 736 WHERE P.PARAMETERID = MSV.PARAMETERID AND \

http://dive4elements.wald.intevation.org