Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 242:5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
gnv-artifacts/trunk@310 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 10 Nov 2009 08:35:18 +0000 |
| parents | 8500529d82af |
| children | b599de3db552 |
comparison
equal
deleted
inserted
replaced
| 241:8500529d82af | 242:5925739d25ac |
|---|---|
| 448 msv.TIMEVALUE , \ | 448 msv.TIMEVALUE , \ |
| 449 from MEDIAN.MESHLAYER ml, \ | 449 from MEDIAN.MESHLAYER ml, \ |
| 450 MEDIAN.MESHPOINT, \ | 450 MEDIAN.MESHPOINT, \ |
| 451 MEDIAN.MESH m, \ | 451 MEDIAN.MESH m, \ |
| 452 MEDIAN.MESHSCALARVALUE msv, \ | 452 MEDIAN.MESHSCALARVALUE msv, \ |
| 453 MEDIAN.SOURCEINFO SI, \ | 453 MEDIAN.SOURCEINFO SI \ |
| 454 where m.SOURCEID = SI.SOURCEID AND \ | 454 where m.SOURCEID = SI.SOURCEID AND \ |
| 455 msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ | 455 msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ |
| 456 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | 456 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
| 457 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ | 457 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
| 458 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | 458 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
| 698 order by msv.TIMEVALUE, \ | 698 order by msv.TIMEVALUE, \ |
| 699 MEDIAN.MESHPOINT.KPOSITION, \ | 699 MEDIAN.MESHPOINT.KPOSITION, \ |
| 700 msv.PARAMETERID, \ | 700 msv.PARAMETERID, \ |
| 701 MEDIAN.MESHPOINT.JPOSITION , \ | 701 MEDIAN.MESHPOINT.JPOSITION , \ |
| 702 MEDIAN.MESHPOINT.IPOSITION | 702 MEDIAN.MESHPOINT.IPOSITION |
| 703 | |
| 704 horizontalprofile_mesh_odv_data = SELECT SI.NAME CRUISE, \ | |
| 705 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 706 '*' TYPE, \ | |
| 707 ST_ASTEXT(SHAPE), \ | |
| 708 0 BOTDEPTH, \ | |
| 709 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 710 msv.DATAVALUE , \ | |
| 711 msv.PARAMETERID PARAMETERID, \ | |
| 712 msv.TIMEVALUE, \ | |
| 713 MEDIAN.MESHPOINT.JPOSITION , \ | |
| 714 MEDIAN.MESHPOINT.IPOSITION \ | |
| 715 from MEDIAN.MESHLAYER ml, \ | |
| 716 MEDIAN.MESHPOINT , \ | |
| 717 MEDIAN.MESH m, \ | |
| 718 MEDIAN.MESHSCALARVALUE msv, \ | |
| 719 MEDIAN.SOURCEINFO SI \ | |
| 720 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ | |
| 721 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 722 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 723 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 724 m.SOURCEID = SI.SOURCEID AND \ | |
| 725 m.PARTIDMIN <= msv.PARTID AND \ | |
| 726 m.PARTIDMAX >= msv.PARTID AND \ | |
| 727 msv.PARAMETERID in (?) AND \ | |
| 728 msv.TIMEVALUE in (?) AND \ | |
| 729 m.OBJECTID = ? AND \ | |
| 730 MEDIAN.MESHPOINT.FEATUREID in \ | |
| 731 ( select FEATUREID \ | |
| 732 from MEDIAN.MESHPOINT mp, \ | |
| 733 MEDIAN.MESH m \ | |
| 734 where m.OBJECTID = ? AND \ | |
| 735 mp.MESHID = m.MESHID AND \ | |
| 736 KPOSITION in ( ? ) and \ | |
| 737 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ | |
| 738 order by msv.TIMEVALUE, \ | |
| 739 MEDIAN.MESHPOINT.KPOSITION, \ | |
| 740 msv.PARAMETERID, \ | |
| 741 MEDIAN.MESHPOINT.JPOSITION , \ | |
| 742 MEDIAN.MESHPOINT.IPOSITION | |
| 703 | 743 |
| 704 | 744 |
| 705 ############################################# | 745 ############################################# |
| 706 ############################################# | 746 ############################################# |
| 707 ############# Profilschnitt MESH ############ | 747 ############# Profilschnitt MESH ############ |