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@209: FROM MEDIAN.PARAMETER P, \ tim@209: MEDIAN.TIMESERIES TS, \ tim@209: MEDIAN.TIMESERIESVALUE TSV, \ tim@209: MEDIAN.MEASUREMENT M, \ tim@209: MEDIAN.TIMESERIESPOINT TSP \ tim@209: WHERE M.FEATUREID = TSP.FEATUREID AND \ tim@209: M.MEASUREMENTID = TSV.MEASUREMENTID AND \ tim@209: TS.TIMESERIESID = TSV.TIMESERIESID AND \ tim@209: P.PARAMETERID = TS.PARAMETERID AND \ tim@209: TSP.FEATUREID = ? \ tim@209: ORDER BY P.GERMANNAME tim@209: tim@199: timeseries_depth_height=SELECT DISTINCT \ tim@209: M.MEASUREMENTID KEY, \ tim@209: M.ZLOCATION VALUE \ tim@209: FROM MEDIAN.MEASUREMENT M, \ tim@209: MEDIAN.TIMESERIESVALUE TSV, \ tim@209: MEDIAN.TIMESERIES T, \ tim@209: MEDIAN.PARAMETER P \ tim@209: WHERE M.MEASUREMENTID = TSV.MEASUREMENTID AND \ tim@209: TSV.TIMESERIESID = T.TIMESERIESID AND \ tim@209: T.PARAMETERID = P.PARAMETERID AND \ tim@209: M.FEATUREID = ? AND \ tim@209: P.PARAMETERID IN (?)\ 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@217: tv.TIMESERIESID GROUP3, \ tim@217: t.TIMEINTERVAL GAPID \ 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@209: timeseries_meshpoint = SELECT MEDIAN.MESHPOINT.FEATUREID, \ tim@199: ST_ASTEXT(SHAPE) \ tim@209: FROM MEDIAN.MESHPOINT, \ tim@209: MEDIAN.MESH M \ tim@209: WHERE MEDIAN.MESHPOINT.MESHID = M.MESHID AND \ tim@199: KPOSITION = 1 AND \ tim@209: M.OBJECTID = ? AND \ tim@199: INTERSECTS(SHAPE,"?") tim@199: tim@209: timeseries_meshpoint_depth = SELECT MP.FEATUREID KEY, \ tim@209: 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ tim@209: from MEDIAN.MESHLAYER ML, \ tim@209: MEDIAN.MESHPOINT MP, \ tim@209: MEDIAN.MESH M \ tim@209: WHERE ML.KPOSITION = MP.KPOSITION AND \ tim@209: ML.MESHID = MP.MESHID AND \ tim@209: M.OBJECTID = ? AND \ tim@209: MP.MESHID = M.MESHID AND \ tim@209: IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ tim@209: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ tim@209: 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@217: mp.FEATUREID GROUP3, \ tim@217: -1 GAPID \ 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@211: tim@211: verticalprofile_minmaxdepth= SELECT min(M.ZLOCATION) MIN, \ tim@211: max(M.ZLOCATION) MAX \ tim@211: FROM MEDIAN.MEASUREMENT M, \ tim@211: MEDIAN.TIMESERIES TS, \ tim@211: MEDIAN.TIMESERIESVALUE TSV \ tim@211: WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \ tim@211: M.MEASUREMENTID = TSV.MEASUREMENTID and \ tim@211: M.FEATUREID = ? and \ tim@211: TS.PARAMETERID IN ( ? ) tim@211: 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@211: verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ tim@211: TSV.DATAVALUE YORDINATE, \ tim@211: TS.PARAMETERID GROUP1, \ tim@211: TSV.TIMEVALUE GROUP2, \ tim@199: 1 GROUP3 \ tim@211: from MEDIAN.TIMESERIES TS, \ tim@211: MEDIAN.TIMESERIESVALUE TSV, \ tim@211: MEDIAN.MEASUREMENT M \ tim@211: where TS.TIMESERIESID = TSV.TIMESERIESID AND \ tim@211: M.MEASUREMENTID = TSV.MEASUREMENTID AND \ tim@211: M.FEATUREID = ? AND \ tim@211: TS.PARAMETERID IN ( ? ) AND \ tim@211: TSV.TIMEVALUE IN (?) AND \ tim@211: M.ZLOCATION >= ? AND \ tim@211: M.ZLOCATION <= ? \ tim@211: ORDER BY TSV.TIMEVALUE , \ tim@211: TSV.TIMESERIESID , \ tim@211: TS.PARAMETERID , \ tim@211: 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@223: verticalprofile_mesh_with_area = SELECT M.OBJECTID KEY, \ tim@223: M.NAME VALUE \ tim@223: FROM MEDIAN.MESHPOINT, \ tim@223: MEDIAN.MESH M \ tim@223: WHERE M.SOURCEID IN (?) AND \ tim@223: M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ tim@223: INTERSECTS(SHAPE, \ tim@223: (SELECT st_astext(SHAPE) \ tim@223: FROM MEDIAN.FEATUREAREA \ tim@223: WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ tim@223: FEATURECODE = ? )\ tim@223: ) \ tim@223: order by M.NAME tim@223: 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@213: verticalprofile_mesh_mindepth = SELECT MP.KPOSITION KEY, \ tim@213: 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ tim@213: from MEDIAN.MESHLAYER ML, \ tim@213: MEDIAN.MESHPOINT MP, \ tim@213: MEDIAN.MESH M \ tim@213: WHERE ML.KPOSITION = MP.KPOSITION AND \ tim@213: ML.MESHID = MP.MESHID AND \ tim@213: M.OBJECTID = ? AND \ tim@213: MP.MESHID = M.MESHID AND \ tim@213: IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ tim@213: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ tim@213: ORDER BY ML.UPPERZLOCATION DESC tim@213: tim@213: verticalprofile_mesh_maxdepth = SELECT MP.KPOSITION KEY, \ tim@213: 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ tim@213: from MEDIAN.MESHLAYER ML, \ tim@213: MEDIAN.MESHPOINT MP, \ tim@213: MEDIAN.MESH M \ tim@213: WHERE ML.KPOSITION = MP.KPOSITION AND \ tim@213: ML.MESHID = MP.MESHID AND \ tim@213: M.OBJECTID = ? AND \ tim@213: MP.MESHID = M.MESHID AND \ tim@213: IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ tim@213: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ tim@213: MP.KPOSITION < ? \ tim@213: ORDER BY ML.UPPERZLOCATION DESC tim@213: 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@213: JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \ tim@213: mp.KPOSITION <= ? AND \ tim@213: mp.KPOSITION >= ? \ 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@211: tim@211: verticalprofile_instantaneouspoint_minmaxdepth = SELECT min(M.ZLOCATION) MIN, \ tim@211: max(M.ZLOCATION) MAX \ tim@211: FROM MEDIAN.INSTANTANEOUSPOINT IP, \ tim@211: MEDIAN.MEASUREMENT M, \ tim@211: MEDIAN.MEASUREDSCALARVALUE MSV \ tim@211: WHERE IP.FEATUREID = M.FEATUREID AND \ tim@211: M.MEASUREMENTID = MSV.MEASUREMENTID AND \ tim@211: IP.FEATUREID = ? AND \ tim@211: MSV.PARAMETERID in (?) tim@211: 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@211: MSV.PARAMETERID in (?) AND \ tim@211: M.ZLOCATION >= ? AND \ tim@211: M.ZLOCATION <= ? \ 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@206: V.NAME || ' ' || \ tim@206: C.NAME || ' ' || \ tim@206: TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \ tim@206: TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE , \ tim@206: V.NAME , \ tim@206: C.NAME \ tim@199: FROM MEDIAN.CRUISE C, \ tim@206: MEDIAN.VEHICLE V, \ tim@199: MEDIAN.TRACK T, \ tim@199: MEDIAN.SURVEYINFO S, \ tim@199: MEDIAN.INSTANTANEOUSPOINT I, \ tim@199: MEDIAN.MEASUREMENT M \ tim@206: WHERE C.VEHICLEID = V.VEHICLEID AND \ tim@206: 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@206: ORDER BY V.NAME, 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@216: ############# 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@216: MEDIAN.MESHPOINT.KPOSITION tim@216: tim@216: ############################################# tim@216: ############################################# tim@216: ########## Horizontalschnitt MESH ########### tim@216: ############################################# tim@216: ############################################# tim@216: horizontalcrosssection_meshpoint_depth = SELECT DISTINCT MP.KPOSITION KEY, \ tim@216: 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ tim@216: from MEDIAN.MESHLAYER ML, \ tim@216: MEDIAN.MESHPOINT MP, \ tim@216: MEDIAN.MESH M \ tim@216: WHERE ML.KPOSITION = MP.KPOSITION AND \ tim@216: ML.MESHID = MP.MESHID AND \ tim@216: M.OBJECTID = ? AND \ tim@216: MP.MESHID = M.MESHID \ tim@216: ORDER BY MP.KPOSITION tim@216: tim@216: horizontalcrosssection_mesh_date = select distinct \ tim@216: msv.TIMEVALUE KEY, \ tim@216: msv.TIMEVALUE VALUE \ tim@216: from MEDIAN.MESHSCALARVALUE msv , \ tim@216: MEDIAN.MESH m \ tim@216: where m.OBJECTID = ? AND \ tim@216: msv.PARTID >= m.PARTIDMIN AND \ tim@216: msv.PARTID <= m.PARTIDMAX AND \ tim@216: msv.PARAMETERID = ? \ tim@216: order by msv.TIMEVALUE tim@216: tim@218: horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ tim@218: MSV.DATAVALUE YORDINATE, \ tim@218: MEDIAN.MESHFACE.JPOSITION, \ tim@218: MEDIAN.MESHFACE.IPOSITION, \ tim@218: MEDIAN.MESHFACE.KPOSITION \ tim@218: from MEDIAN.MESHLAYER ML, \ tim@218: MEDIAN.MESHFACE, \ tim@218: MEDIAN.MESH M, \ tim@218: MEDIAN.MESHSCALARVALUE MSV \ tim@218: where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \ tim@218: ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \ tim@218: ML.MESHID = MEDIAN.MESHFACE.MESHID and \ tim@218: M.MESHID = MEDIAN.MESHFACE.MESHID AND \ tim@218: M.PARTIDMIN <= MSV.PARTID AND \ tim@218: M.PARTIDMAX >= MSV.PARTID AND \ tim@218: MSV.PARAMETERID = ? AND \ tim@218: MSV.TIMEVALUE = ? AND \ tim@218: M.OBJECTID = ? AND \ tim@218: MEDIAN.MESHFACE.KPOSITION = ? \ tim@218: order by MEDIAN.MESHFACE.JPOSITION , \ tim@223: MEDIAN.MESHFACE.IPOSITION tim@223: tim@223: tim@223: area_filter = SELECT DISTINCT \ tim@223: FEATUREID KEY ,\ tim@223: DESCRIPTION VALUE \ tim@223: FROM MEDIAN.FEATUREAREA \ tim@223: WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ tim@223: FEATUREID > 0 \ tim@223: ORDER BY FEATUREID tim@223: tim@223: subarea_filter = SELECT \ tim@223: FEATURECODE KEY, \ tim@223: NAME VALUE \ tim@223: FROM MEDIAN.FEATUREAREA \ tim@223: WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ tim@223: FEATUREID = ? \ tim@223: ORDER BY NAME tim@223: