Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 119:4841808819d9
Added the new FIS
FIS GTS
FIS CTD
FIS XBT
to the Configuration.
This three FIS uses Data from InstantaneousPoint
Some CodeCleanup done
gnv-artifacts/trunk@182 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 05 Oct 2009 10:15:15 +0000 |
| parents | 820238357bab |
| children | 5134266f00e7 |
comparison
equal
deleted
inserted
replaced
| 118:5ebc059064a6 | 119:4841808819d9 |
|---|---|
| 293 ############################################# | 293 ############################################# |
| 294 ##### Vertikalprofil InstantaneousPoint ##### | 294 ##### Vertikalprofil InstantaneousPoint ##### |
| 295 ############################################# | 295 ############################################# |
| 296 ############################################# | 296 ############################################# |
| 297 | 297 |
| 298 verticalprofile_instantaneouspoint_series = SELECT S.SERIESID KEY, \ | 298 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \ |
| 299 S.SERIESID KEY , \ | |
| 299 S.DESCRIPTION VALUE \ | 300 S.DESCRIPTION VALUE \ |
| 300 FROM MEDIAN.SERIES S | 301 FROM MEDIAN.SERIES S, \ |
| 301 | 302 MEDIAN.INSTANTANEOUSPOINT I, \ |
| 302 verticalprofile_instantaneouspoint_point = SELECT IP.FEATUREID KEY, \ | 303 MEDIAN.MEASUREMENT M \ |
| 303 IP.SHAPE VALUE \ | 304 WHERE S.SERIESID = I.SERIESID AND \ |
| 304 FROM MEDIAN.INSTANTANEOUSPOINT IP \ | 305 I.POINTSPEC = 4 AND \ |
| 305 WHERE IP.POINTSPEC = 4 AND \ | 306 I.FEATUREID = M.FEATUREID AND \ |
| 306 IP.SERIESID = ? | 307 M.SOURCEID= ? \ |
| 308 ORDER BY S.DESCRIPTION | |
| 309 | |
| 310 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \ | |
| 311 I.FEATUREID KEY, \ | |
| 312 to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \ | |
| 313 I.TIMEVALUE \ | |
| 314 FROM MEDIAN.INSTANTANEOUSPOINT I, \ | |
| 315 MEDIAN.MEASUREMENT M \ | |
| 316 WHERE I.SERIESID = ? AND \ | |
| 317 I.POINTSPEC = 4 AND \ | |
| 318 I.FEATUREID = M.FEATUREID AND \ | |
| 319 M.SOURCEID = ? \ | |
| 320 ORDER BY I.TIMEVALUE | |
| 307 | 321 |
| 308 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ | 322 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ |
| 309 P.PARAMETERID KEY , \ | 323 P.PARAMETERID KEY , \ |
| 310 P.GERMANNAME VALUE \ | 324 P.GERMANNAME VALUE \ |
| 311 FROM MEDIAN.PARAMETER P, \ | 325 FROM MEDIAN.PARAMETER P, \ |
| 410 horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \ | 424 horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \ |
| 411 M.YLOCATION XORDINATE_YCOORD , \ | 425 M.YLOCATION XORDINATE_YCOORD , \ |
| 412 MSV.DATAVALUE YORDINATE , \ | 426 MSV.DATAVALUE YORDINATE , \ |
| 413 MSV.PARAMETERID GROUP1 , \ | 427 MSV.PARAMETERID GROUP1 , \ |
| 414 IP.TIMEVALUE GROUP2 , \ | 428 IP.TIMEVALUE GROUP2 , \ |
| 415 1 GROUP3 \ | 429 ZLOCATION GROUP3 \ |
| 416 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ | 430 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ |
| 417 MEDIAN.MEASUREMENT M, \ | 431 MEDIAN.MEASUREMENT M, \ |
| 418 MEDIAN.MEASUREDSCALARVALUE MSV \ | 432 MEDIAN.MEASUREDSCALARVALUE MSV \ |
| 419 WHERE IP.FEATUREID = M.FEATUREID AND \ | 433 WHERE IP.FEATUREID = M.FEATUREID AND \ |
| 420 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ | 434 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
| 421 IP.SURVEYID = ? AND \ | 435 IP.SURVEYID = ? AND \ |
| 422 M.ZLOCATION IN (?) AND \ | 436 M.ZLOCATION IN (?) AND \ |
| 423 MSV.PARAMETERID in (?) \ | 437 MSV.PARAMETERID in (?) \ |
| 424 ORDER BY IP.TIMEVALUE, \ | 438 ORDER BY M.ZLOCATION, \ |
| 425 MSV.PARAMETERID, \ | 439 MSV.PARAMETERID, \ |
| 426 M.ZLOCATION | 440 IP.TIMEVALUE |
| 427 | 441 |
| 428 ############################################# | 442 ############################################# |
| 429 ############################################# | 443 ############################################# |
| 430 ########### Horizontalprofil MESH ########### | 444 ########### Horizontalprofil MESH ########### |
| 431 ############################################# | 445 ############################################# |
| 477 msv.TIMEVALUE, \ | 491 msv.TIMEVALUE, \ |
| 478 msv.PARAMETERID, \ | 492 msv.PARAMETERID, \ |
| 479 mp.JPOSITION , \ | 493 mp.JPOSITION , \ |
| 480 mp.IPOSITION | 494 mp.IPOSITION |
| 481 | 495 |
| 496 |