Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 482:64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
gnv-artifacts/trunk@557 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 17 Jan 2010 21:26:21 +0000 |
| parents | 62fc63d0f71d |
| children | c6249cb631df |
comparison
equal
deleted
inserted
replaced
| 481:20dde2b6f1b5 | 482:64e65daa65e9 |
|---|---|
| 1083 msv.PARAMETERID = ? \ | 1083 msv.PARAMETERID = ? \ |
| 1084 order by msv.TIMEVALUE | 1084 order by msv.TIMEVALUE |
| 1085 | 1085 |
| 1086 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ | 1086 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ |
| 1087 MSV.DATAVALUE YORDINATE, \ | 1087 MSV.DATAVALUE YORDINATE, \ |
| 1088 MEDIAN.MESHFACE.JPOSITION, \ | 1088 MEDIAN.MESHPOINT.JPOSITION, \ |
| 1089 MEDIAN.MESHFACE.IPOSITION, \ | 1089 MEDIAN.MESHPOINT.IPOSITION, \ |
| 1090 MEDIAN.MESHFACE.KPOSITION, \ | 1090 MEDIAN.MESHPOINT.KPOSITION, \ |
| 1091 MSV.PARAMETERID, \ | |
| 1092 MSV.TIMEVALUE, \ | |
| 1091 2 DATAID \ | 1093 2 DATAID \ |
| 1092 from MEDIAN.MESHLAYER ML, \ | 1094 from MEDIAN.MESHLAYER ML, \ |
| 1093 MEDIAN.MESHFACE, \ | 1095 MEDIAN.MESHPOINT, \ |
| 1094 MEDIAN.MESH M, \ | 1096 MEDIAN.MESH M, \ |
| 1095 MEDIAN.MESHSCALARVALUE MSV \ | 1097 MEDIAN.MESHSCALARVALUE MSV \ |
| 1096 where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \ | 1098 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ |
| 1097 ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \ | 1099 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
| 1098 ML.MESHID = MEDIAN.MESHFACE.MESHID and \ | 1100 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
| 1099 M.MESHID = MEDIAN.MESHFACE.MESHID AND \ | 1101 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
| 1100 M.PARTIDMIN <= MSV.PARTID AND \ | 1102 M.PARTIDMIN <= MSV.PARTID AND \ |
| 1101 M.PARTIDMAX >= MSV.PARTID AND \ | 1103 M.PARTIDMAX >= MSV.PARTID AND \ |
| 1102 MSV.PARAMETERID = ? AND \ | 1104 MSV.PARAMETERID = ? AND \ |
| 1103 MSV.TIMEVALUE = ? AND \ | 1105 MSV.TIMEVALUE = ? AND \ |
| 1104 M.OBJECTID = ? AND \ | 1106 M.OBJECTID = ? AND \ |
| 1105 MEDIAN.MESHFACE.KPOSITION = ? \ | 1107 MEDIAN.MESHPOINT.KPOSITION = ? \ |
| 1106 order by MEDIAN.MESHFACE.JPOSITION, \ | 1108 order by MEDIAN.MESHPOINT.JPOSITION, \ |
| 1107 MEDIAN.MESHFACE.IPOSITION | 1109 MEDIAN.MESHPOINT.IPOSITION |
| 1108 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ | 1110 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ |
| 1109 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | 1111 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ |
| 1110 '*' TYPE, \ | 1112 '*' TYPE, \ |
| 1111 ST_ASTEXT(SHAPE), \ | 1113 ST_ASTEXT(SHAPE), \ |
| 1112 0 BOTDEPTH, \ | 1114 0 BOTDEPTH, \ |