tim@199: ############################################# tim@199: ############################################# tim@199: ########## Zeitserie ############## tim@199: ############################################# tim@199: ############################################# tim@199: tim@199: timeseries_timeseriespoint=SELECT DISTINCT \ tim@199: tsp.FEATUREID KEY, \ tim@199: tsp.NAME VALUE \ tim@199: FROM MEDIAN.TIMESERIESPOINT tsp, \ tim@199: MEDIAN.MEASUREMENT mmt \ tim@199: WHERE tsp.FEATUREID = mmt.FEATUREID AND \ tim@199: mmt.SOURCEID = ? \ tim@199: order by tsp.name tim@199: tim@199: timeseries_parameter=SELECT DISTINCT \ tim@199: p.PARAMETERID KEY, \ tim@199: p.GERMANNAME VALUE \ tim@199: from MEDIAN.PARAMETER p \ tim@199: where p.PARAMETERID in \ tim@199: (select distinct \ tim@199: ts.PARAMETERID \ tim@199: from MEDIAN.TIMESERIES ts \ tim@199: where ts.TIMESERIESID in \ tim@199: (select distinct \ tim@199: tsv.TIMESERIESID \ tim@199: from MEDIAN.TIMESERIESVALUE tsv \ tim@199: where tsv.MEASUREMENTID in \ tim@199: (select m.MEASUREMENTID \ tim@199: from MEDIAN.MEASUREMENT m, \ tim@199: MEDIAN.TIMESERIESPOINT tsp \ tim@199: where m.FEATUREID = tsp.FEATUREID and \ tim@199: tsp.FEATUREID IN ( ? )\ tim@199: )\ tim@199: )\ tim@199: ) \ tim@199: ORDER BY p.GERMANNAME tim@199: tim@199: timeseries_depth_height=SELECT DISTINCT \ tim@199: m.MEASUREMENTID KEY, \ tim@199: m.ZLOCATION VALUE \ tim@199: from MEDIAN.MEASUREMENT m \ tim@199: where m.MEASUREMENTID in \ tim@199: (SELECT DISTINCT \ tim@199: t_v.MEASUREMENTID \ tim@199: from MEDIAN.TIMESERIESVALUE t_v \ tim@199: where t_v.TIMESERIESID in \ tim@199: (SELECT DISTINCT \ tim@199: t.TIMESERIESID \ tim@199: from MEDIAN.TIMESERIES t \ tim@199: where t.PARAMETERID in \ tim@199: (SELECT DISTINCT \ tim@199: p.PARAMETERID \ tim@199: from MEDIAN.PARAMETER p \ tim@199: where m.FEATUREID IN ( ? ) and \ tim@199: p.PARAMETERID IN (?)\ tim@199: )\ tim@199: )\ tim@199: )\ tim@199: ORDER BY m.ZLOCATION DESC tim@199: tim@199: timeseries_interval=select min(tv.TIMEVALUE) MIN, \ tim@199: max(tv.TIMEVALUE) MAX \ tim@199: from MEDIAN.TIMESERIES t , \ tim@199: MEDIAN.TIMESERIESVALUE tv \ tim@199: where tv.TIMESERIESID = t.TIMESERIESID AND \ tim@199: t.PARAMETERID IN ( ? ) AND \ tim@199: tv.MEASUREMENTID IN ( ? ) tim@199: tim@199: timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \ tim@199: tv.DATAVALUE YORDINATE, \ tim@199: t.PARAMETERID GROUP1, \ tim@199: tv.MEASUREMENTID GROUP2, \ tim@199: tv.TIMESERIESID GROUP3 \ tim@199: FROM MEDIAN.TIMESERIESVALUE tv, \ tim@199: MEDIAN.TIMESERIES t \ tim@199: WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ tim@199: t.PARAMETERID IN ( ? ) AND \ tim@199: tv.MEASUREMENTID IN ( ? ) AND \ tim@199: tv.TIMEVALUE >= ? AND \ tim@199: tv.TIMEVALUE <= ? \ tim@199: ORDER BY tv.MEASUREMENTID , \ tim@199: tv.TIMESERIESID , \ tim@199: t.PARAMETERID , \ tim@199: tv.TIMEVALUE tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: ########## Zeitserie Mesh ############## tim@199: ############################################# tim@199: ############################################# tim@199: tim@199: timeseries_mesh = SELECT OBJECTID KEY, \ tim@199: m.NAME VALUE \ tim@199: FROM MEDIAN.MESH m \ tim@199: WHERE SOURCEID IN (?) \ tim@199: ORDER BY m.NAME tim@199: timeseries_meshpoint = SELECT FEATUREID, \ tim@199: ST_ASTEXT(SHAPE) \ tim@199: FROM MEDIAN.MESHPOINT \ tim@199: WHERE MESHID in \ tim@199: (SELECT DISTINCT MESHID \ tim@199: FROM MEDIAN.MESH \ tim@199: WHERE OBJECTID = ?) AND \ tim@199: KPOSITION = 1 AND \ tim@199: INTERSECTS(SHAPE,"?") tim@199: tim@199: timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ tim@199: 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ tim@199: from MEDIAN.MESHLAYER ml, \ tim@199: MEDIAN.MESHPOINT mp \ tim@199: where ml.KPOSITION = mp.KPOSITION and \ tim@199: ml.MESHID = mp.MESHID and \ tim@199: mp.FEATUREID in \ tim@199: ( select FEATUREID \ tim@199: from MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: mp.MESHID = m.MESHID AND \ tim@199: IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ tim@199: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ tim@199: order by ml.UPPERZLOCATION desc tim@199: tim@199: timeseries_mesh_parameter=SELECT distinct \ tim@199: p.PARAMETERID KEY , \ tim@199: p.GERMANNAME VALUE \ tim@199: from MEDIAN.PARAMETER p, \ tim@199: MEDIAN.MESHSCALARVALUE msc, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: msc.PARTID = m.PARTIDMIN AND \ tim@199: msc.PARAMETERID = p.PARAMETERID \ tim@199: order by p.GERMANNAME tim@199: timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ tim@199: min(TIMEVALUE) MIN, \ tim@199: max(TIMEVALUE) MAX \ tim@199: from MEDIAN.MESHSCALARVALUE msc , \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: msc.PARTID >= m.PARTIDMIN AND \ tim@199: msc.PARTID <= m.PARTIDMAX AND \ tim@199: msc.PARAMETERID IN (?) tim@199: tim@199: timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ tim@199: msv.TIMEVALUE XORDINATE, \ tim@199: msv.DATAVALUE YORDINATE, \ tim@199: msv.PARAMETERID GROUP1, \ tim@199: msv.FEATUREID GROUP2, \ tim@199: mp.FEATUREID GROUP3 \ tim@199: from MEDIAN.MESHSCALARVALUE msv , \ tim@199: MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m \ tim@199: where (m.OBJECTID = ? AND \ tim@199: msv.PARTID >= m.PARTIDMIN AND \ tim@199: msv.PARTID <= m.PARTIDMAX ) AND \ tim@199: msv.FEATUREID in ( ? ) AND \ tim@199: msv.PARAMETERID in ( ? ) AND \ tim@199: mp.FEATUREID in ( ? ) AND \ tim@199: msv.TIMEVALUE >= ? AND \ tim@199: msv.TIMEVALUE <= ? \ tim@199: order by mp.FEATUREID, \ tim@199: msv.FEATUREID, \ tim@199: msv.PARAMETERID, \ tim@199: msv.TIMEVALUE tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: ########## Vertikalprofil ############## tim@199: ############################################# tim@199: ############################################# tim@199: tim@199: verticalprofile_point=SELECT DISTINCT \ tim@199: tsp.FEATUREID KEY, \ tim@199: tsp.NAME VALUE \ tim@199: FROM MEDIAN.TIMESERIESPOINT tsp, \ tim@199: MEDIAN.MEASUREMENT mmt \ tim@199: WHERE tsp.FEATUREID = mmt.FEATUREID AND \ tim@199: mmt.SOURCEID = ? \ tim@199: order by tsp.name tim@199: tim@199: verticalprofile_parameter=SELECT DISTINCT \ tim@199: p.PARAMETERID KEY, \ tim@199: p.GERMANNAME VALUE \ tim@199: from MEDIAN.PARAMETER p, \ tim@199: MEDIAN.TIMESERIES ts, \ tim@199: MEDIAN.TIMESERIESVALUE tsv, \ tim@199: MEDIAN.MEASUREMENT m \ tim@199: where ts.PARAMETERID = p.PARAMETERID and \ tim@199: ts.TIMESERIESID = tsv.TIMESERIESID and \ tim@199: m.MEASUREMENTID = tsv.MEASUREMENTID and \ tim@199: m.FEATUREID = ? \ tim@199: ORDER BY p.GERMANNAME tim@199: tim@199: verticalprofile_date=select distinct \ tim@199: tsv.TIMEVALUE KEY, \ tim@199: tsv.TIMEVALUE VALUE \ tim@199: from MEDIAN.TIMESERIES ts , \ tim@199: MEDIAN.TIMESERIESVALUE tsv, \ tim@199: MEDIAN.MEASUREMENT m \ tim@199: where ts.TIMESERIESID = tsv.TIMESERIESID and \ tim@199: m.MEASUREMENTID = tsv.MEASUREMENTID and \ tim@199: m.FEATUREID = ? and \ tim@199: ts.PARAMETERID IN ( ? ) \ tim@199: order by tsv.TIMEVALUE tim@199: tim@199: verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \ tim@199: tsv.DATAVALUE YORDINATE, \ tim@199: ts.PARAMETERID GROUP1, \ tim@199: tsv.TIMEVALUE GROUP2, \ tim@199: 1 GROUP3 \ tim@199: from MEDIAN.TIMESERIES ts, \ tim@199: MEDIAN.TIMESERIESVALUE tsv, \ tim@199: MEDIAN.MEASUREMENT m \ tim@199: where ts.TIMESERIESID = tsv.TIMESERIESID and \ tim@199: m.MEASUREMENTID = tsv.MEASUREMENTID and \ tim@199: m.FEATUREID = ? and \ tim@199: ts.PARAMETERID IN ( ? ) AND \ tim@199: tsv.TIMEVALUE IN (?) \ tim@199: ORDER BY tsv.TIMEVALUE , \ tim@199: tsv.TIMESERIESID , \ tim@199: ts.PARAMETERID , \ tim@199: tsv.TIMEVALUE tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: ########## Vertikalprofil Mesh ############## tim@199: ############################################# tim@199: ############################################# tim@199: tim@199: verticalprofile_mesh = SELECT OBJECTID KEY, \ tim@199: m.NAME VALUE \ tim@199: FROM MEDIAN.MESH m \ tim@199: WHERE SOURCEID IN (?) \ tim@199: order by m.NAME tim@199: tim@199: verticalprofile_mesh_point = SELECT FEATUREID, \ tim@199: ST_ASTEXT(SHAPE) \ tim@199: FROM MEDIAN.MESHPOINT \ tim@199: WHERE MESHID in \ tim@199: (SELECT DISTINCT MESHID \ tim@199: FROM MEDIAN.MESH \ tim@199: WHERE OBJECTID = ?) AND \ tim@199: KPOSITION = 1 AND \ tim@199: INTERSECTS(SHAPE,"?") tim@199: tim@199: verticalprofile_mesh_parameter=SELECT distinct \ tim@199: p.PARAMETERID KEY , \ tim@199: p.GERMANNAME VALUE \ tim@199: from MEDIAN.PARAMETER p, \ tim@199: MEDIAN.MESHSCALARVALUE msc, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: m.PARTIDMIN = msc.PARTID AND \ tim@199: msc.PARAMETERID = p.PARAMETERID \ tim@199: order by p.GERMANNAME tim@199: tim@199: verticalprofile_mesh_date= select distinct \ tim@199: msv.TIMEVALUE KEY, \ tim@199: msv.TIMEVALUE VALUE \ tim@199: from MEDIAN.MESHSCALARVALUE msv , \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: msv.PARTID >= m.PARTIDMIN AND \ tim@199: msv.PARTID <= m.PARTIDMAX AND \ tim@199: msv.PARAMETERID in (?) \ tim@199: order by msv.TIMEVALUE tim@199: tim@199: verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ tim@199: msv.DATAVALUE YORDINATE, \ tim@199: msv.PARAMETERID GROUP1, \ tim@199: msv.TIMEVALUE GROUP2, \ tim@199: 1 GROUP3 \ tim@199: from MEDIAN.MESHLAYER ml, \ tim@199: MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m, \ tim@199: MEDIAN.MESHSCALARVALUE msv \ tim@199: where msv.FEATUREID = mp. FEATUREID AND \ tim@199: ml.KPOSITION = mp.KPOSITION and \ tim@199: ml.MESHID = mp.MESHID and \ tim@199: m.MESHID = mp.MESHID AND \ tim@199: m.PARTIDMIN <= msv.PARTID AND \ tim@199: m.PARTIDMAX >= msv.PARTID AND \ tim@199: msv.PARAMETERID in (?) AND \ tim@199: msv.TIMEVALUE in (?) AND \ tim@199: m.OBJECTID = ? AND \ tim@199: mp.FEATUREID in \ tim@199: ( select FEATUREID \ tim@199: from MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: mp.MESHID = m.MESHID AND \ tim@199: IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ tim@199: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ tim@199: order by msv.PARAMETERID, \ tim@199: msv.TIMEVALUE, \ tim@199: ml.UPPERZLOCATION tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: ##### Vertikalprofil InstantaneousPoint ##### tim@199: ############################################# tim@199: ############################################# tim@199: tim@199: verticalprofile_instantaneouspoint_series = SELECT DISTINCT \ tim@199: S.SERIESID KEY , \ tim@199: S.DESCRIPTION VALUE \ tim@199: FROM MEDIAN.SERIES S, \ tim@199: MEDIAN.INSTANTANEOUSPOINT I, \ tim@199: MEDIAN.MEASUREMENT M \ tim@199: WHERE S.SERIESID = I.SERIESID AND \ tim@199: I.POINTSPEC = 4 AND \ tim@199: I.FEATUREID = M.FEATUREID AND \ tim@199: M.SOURCEID= ? \ tim@199: ORDER BY S.DESCRIPTION tim@199: tim@205: verticalprofile_instantaneouspoint_point = SELECT \ tim@205: MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ tim@205: to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ tim@205: MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ tim@205: ST_ASTEXT(SHAPE) \ tim@205: FROM MEDIAN.INSTANTANEOUSPOINT, \ tim@199: MEDIAN.MEASUREMENT M \ tim@205: WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ tim@205: MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ tim@205: MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ tim@199: M.SOURCEID = ? \ tim@205: ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ tim@205: MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE tim@199: tim@199: verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ tim@199: P.PARAMETERID KEY , \ tim@199: P.GERMANNAME VALUE \ tim@199: FROM MEDIAN.PARAMETER P, \ tim@199: MEDIAN.INSTANTANEOUSPOINT IP, \ tim@199: MEDIAN.MEASUREMENT M, \ tim@199: MEDIAN.MEASUREDSCALARVALUE MSV \ tim@199: WHERE IP.FEATUREID = M.FEATUREID AND \ tim@199: M.MEASUREMENTID = MSV.MEASUREMENTID AND \ tim@199: MSV.PARAMETERID = P.PARAMETERID AND \ tim@199: IP.FEATUREID = ? \ tim@199: ORDER BY P.GERMANNAME tim@199: tim@199: verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ tim@199: MSV.DATAVALUE YORDINATE, \ tim@199: MSV.PARAMETERID GROUP1, \ tim@199: IP.TIMEVALUE GROUP2, \ tim@199: 1 GROUP3 \ tim@199: FROM MEDIAN.INSTANTANEOUSPOINT IP, \ tim@199: MEDIAN.MEASUREMENT M, \ tim@199: MEDIAN.MEASUREDSCALARVALUE MSV \ tim@199: WHERE IP.FEATUREID = M.FEATUREID AND \ tim@199: M.MEASUREMENTID = MSV.MEASUREMENTID AND \ tim@199: IP.FEATUREID = ? AND \ tim@199: MSV.PARAMETERID in (?) \ tim@199: ORDER BY IP.TIMEVALUE, \ tim@199: MSV.PARAMETERID, \ tim@199: M.ZLOCATION tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: #### Horizontalprofil InstantaneousPoint #### tim@199: ############################################# tim@199: ############################################# tim@199: horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \ tim@199: V.VEHICLEID KEY, \ tim@199: V.NAME VALUE \ tim@199: FROM MEDIAN.VEHICLE V, \ tim@199: MEDIAN.CRUISE C, \ tim@199: MEDIAN.TRACK T, \ tim@199: MEDIAN.SURVEYINFO S, \ tim@199: MEDIAN.INSTANTANEOUSPOINT I, \ tim@199: MEDIAN.MEASUREMENT M \ tim@199: WHERE V.VEHICLEID = C.VEHICLEID AND \ tim@199: C.CRUISEID = T.CRUISEID AND \ tim@199: T.TRACKID = S.TRACKID AND \ tim@199: S.SURVEYID = I.SURVEYID AND \ tim@199: I.FEATUREID = M.FEATUREID AND \ tim@199: M.SOURCEID = ? \ tim@199: ORDER BY V.NAME tim@199: horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ tim@199: C.CRUISEID KEY , \ tim@199: C.NAME VALUE \ tim@199: FROM MEDIAN.CRUISE C, \ tim@199: MEDIAN.TRACK T, \ tim@199: MEDIAN.SURVEYINFO S, \ tim@199: MEDIAN.INSTANTANEOUSPOINT I, \ tim@199: MEDIAN.MEASUREMENT M \ tim@199: WHERE C.CRUISEID = T.CRUISEID AND \ tim@199: T.TRACKID = S.TRACKID AND \ tim@199: S.SURVEYID = I.SURVEYID AND \ tim@199: I.FEATUREID = M.FEATUREID AND \ tim@199: C.VEHICLEID = ? AND \ tim@205: M.SOURCEID = ? \ tim@199: ORDER BY C.NAME tim@199: horizontalprofile_instantaneouspoint_track= SELECT \ tim@199: T.TRACKID KEY , \ tim@199: to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ tim@199: FROM MEDIAN.TRACK T \ tim@199: WHERE T.CRUISEID = ? \ tim@199: ORDER BY T.STARTDATE, \ tim@199: T.ENDDATE, \ tim@199: T.NAME tim@199: horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ tim@199: SURVEYID KEY , \ tim@199: to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \ tim@199: FROM MEDIAN.SURVEYINFO \ tim@199: WHERE TRACKID = ? \ tim@199: ORDER BY STARTDATE, \ tim@199: ENDDATE, \ tim@199: DESCRIPTION tim@199: horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ tim@199: P.PARAMETERID KEY , \ tim@199: P.GERMANNAME VALUE \ tim@199: FROM MEDIAN.PARAMETER P , \ tim@199: MEDIAN.MEASUREMENT M , \ tim@199: MEDIAN.INSTANTANEOUSPOINT IP , \ tim@199: MEDIAN.MEASUREDSCALARVALUE MSV \ tim@199: WHERE P.PARAMETERID = MSV.PARAMETERID AND \ tim@199: MSV.MEASUREMENTID = M.MEASUREMENTID AND \ tim@199: M.FEATUREID = IP.FEATUREID AND \ tim@199: IP.SURVEYID = ? \ tim@199: ORDER BY P.GERMANNAME tim@199: horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ tim@199: M.ZLOCATION KEY, \ tim@199: M.ZLOCATION VALUE \ tim@199: FROM MEDIAN.MEASUREMENT M , \ tim@199: MEDIAN.INSTANTANEOUSPOINT IP \ tim@199: WHERE M.FEATUREID = IP.FEATUREID AND \ tim@199: IP.SURVEYID = ? \ tim@199: ORDER BY M.ZLOCATION tim@199: horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \ tim@199: MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \ tim@199: MSV.DATAVALUE YORDINATE , \ tim@199: MSV.PARAMETERID GROUP1 , \ tim@199: ZLOCATION GROUP2 , \ tim@199: 1 GROUP3 \ tim@199: FROM MEDIAN.INSTANTANEOUSPOINT, \ tim@199: MEDIAN.MEASUREMENT M, \ tim@199: MEDIAN.MEASUREDSCALARVALUE MSV \ tim@199: WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ tim@199: M.MEASUREMENTID = MSV.MEASUREMENTID AND \ tim@199: MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \ tim@199: M.ZLOCATION IN (?) AND \ tim@199: MSV.PARAMETERID in (?) \ tim@199: ORDER BY MSV.PARAMETERID, \ tim@199: M.ZLOCATION, \ tim@199: MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: ########### Horizontalprofil MESH ########### tim@199: ############################################# tim@199: ############################################# tim@199: horizontalprofile_meshpoint_depth = SELECT DISTINCT \ tim@199: mp.KPOSITION KEY, \ tim@199: 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ tim@199: from MEDIAN.MESHLAYER ml, \ tim@199: MEDIAN.MESHPOINT mp \ tim@199: where ml.KPOSITION = mp.KPOSITION and \ tim@199: ml.MESHID = mp.MESHID and \ tim@199: mp.FEATUREID in \ tim@199: ( select FEATUREID \ tim@199: from MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: mp.MESHID = m.MESHID AND \ tim@199: IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ tim@199: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ tim@199: order by mp.KPOSITION tim@199: tim@199: horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ tim@199: msv.DATAVALUE YORDINATE, \ tim@199: msv.PARAMETERID GROUP1, \ tim@199: MEDIAN.MESHPOINT.KPOSITION GROUP2, \ tim@199: msv.TIMEVALUE GROUP3, \ tim@199: MEDIAN.MESHPOINT.JPOSITION , \ tim@199: MEDIAN.MESHPOINT.IPOSITION \ tim@199: from MEDIAN.MESHLAYER ml, \ tim@199: MEDIAN.MESHPOINT , \ tim@199: MEDIAN.MESH m, \ tim@199: MEDIAN.MESHSCALARVALUE msv \ tim@199: where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ tim@199: ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ tim@199: ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ tim@199: m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ tim@199: m.PARTIDMIN <= msv.PARTID AND \ tim@199: m.PARTIDMAX >= msv.PARTID AND \ tim@199: msv.PARAMETERID in (?) AND \ tim@199: msv.TIMEVALUE in (?) AND \ tim@199: m.OBJECTID = ? AND \ tim@199: MEDIAN.MESHPOINT.FEATUREID in \ tim@199: ( select FEATUREID \ tim@199: from MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: mp.MESHID = m.MESHID AND \ tim@199: KPOSITION in ( ? ) and \ tim@199: ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ tim@199: order by msv.TIMEVALUE, \ tim@199: MEDIAN.MESHPOINT.KPOSITION, \ tim@199: msv.PARAMETERID, \ tim@199: MEDIAN.MESHPOINT.JPOSITION , \ tim@199: MEDIAN.MESHPOINT.IPOSITION tim@199: tim@199: tim@199: ############################################# tim@199: ############################################# tim@199: ########### Profilschnitt MESH ########### tim@199: ############################################# tim@199: ############################################# tim@199: verticalcrosssection_mesh_date = select distinct \ tim@199: msv.TIMEVALUE KEY, \ tim@199: msv.TIMEVALUE VALUE \ tim@199: from MEDIAN.MESHSCALARVALUE msv , \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: msv.PARTID >= m.PARTIDMIN AND \ tim@199: msv.PARTID <= m.PARTIDMAX AND \ tim@199: msv.PARAMETERID = ? \ tim@199: order by msv.TIMEVALUE tim@199: verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ tim@199: msv.DATAVALUE YORDINATE, \ tim@199: msv.PARAMETERID GROUP1, \ tim@199: msv.TIMEVALUE GROUP2, \ tim@199: MEDIAN.MESHPOINT.JPOSITION, \ tim@199: MEDIAN.MESHPOINT.IPOSITION, \ tim@199: MEDIAN.MESHPOINT.KPOSITION \ tim@199: from MEDIAN.MESHLAYER ml, \ tim@199: MEDIAN.MESHPOINT , \ tim@199: MEDIAN.MESH m, \ tim@199: MEDIAN.MESHSCALARVALUE msv \ tim@199: where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ tim@199: ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ tim@199: ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ tim@199: m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ tim@199: m.PARTIDMIN <= msv.PARTID AND \ tim@199: m.PARTIDMAX >= msv.PARTID AND \ tim@199: msv.PARAMETERID = ? AND \ tim@199: msv.TIMEVALUE = ? AND \ tim@199: m.OBJECTID = ? AND \ tim@199: MEDIAN.MESHPOINT.FEATUREID in \ tim@199: ( select FEATUREID \ tim@199: from MEDIAN.MESHPOINT mp, \ tim@199: MEDIAN.MESH m \ tim@199: where m.OBJECTID = ? AND \ tim@199: mp.MESHID = m.MESHID AND \ tim@199: ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ tim@205: order by msv.TIMEVALUE, \ tim@205: msv.PARAMETERID, \ tim@205: MEDIAN.MESHPOINT.JPOSITION , \ tim@205: MEDIAN.MESHPOINT.IPOSITION, \ tim@205: MEDIAN.MESHPOINT.KPOSITION