# HG changeset patch # User Tim Englich # Date 1256120212 0 # Node ID b66e8a6f3907e68a6af4bbaabe7377fb71b8a41f # Parent d19259c86b723699de8e32222cc487ea5f6d1567 Moved Configurationfiles gnv-artifacts/trunk@253 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/doc/conf/conf.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/gnv-artifacts/doc/conf/conf.xml Wed Oct 21 10:16:52 2009 +0000 @@ -0,0 +1,1069 @@ + + + de.intevation.gnv.artifacts.context.GNVArtifactContextFactory + + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + de.intevation.artifactdatabase.DefaultArtifactFactory + + + + + + + + + + + + timeseries_mesh + meshid + false + + timeseries_mesh_coordinate + + + + + + + + + mesh_coordinate + false + + timeseries_meshpointv + + + + + + + + + timeseries_meshpoint + mesh_point + false + + timeseries_meshpoint_depthv + + + + + + + + + + timeseries_meshpoint_depth + depthid + true + + timeseries_meshpoint_parameterv + + + + + + + + + + timeseries_mesh_parameter + parameterid + true + + timeseries_meshpoint_interval + + + + + + + + + + + timeseries_mesh_interval + timeinterval + false + + timeseries_meshpoint_calculate_results + + + + + + + + + + + + timeseries_mesh_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + timeseries_timeseriespoint + featureid + false + + timeseries_parameter + + + + + + + + + timeseries_parameter + parameterid + true + + timeseries_depth_height + + + + + + + + + timeseries_depth_height + measurementid + true + + timeseries_interval + + + + + + + + + + timeseries_interval + timeinterval + false + + timeseries_calculate_results + + + + + + + + + + timeseries_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + verticalprofile_point + featureid + false + + verticalprofile_parameter + + + + + + + + + verticalprofile_parameter + parameterid + true + + verticalprofile_date + + + + + + + + + verticalprofile_date + dateid + true + + verticalprofile_calculate_results + + + + + + + + + + verticalprofile_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + verticalprofile_mesh + meshid + false + + verticalprofile_mesh_coordinate + + + + + + + + + mesh_coordinate + false + + verticalprofile_mesh_pointv + + + + + + + + + verticalprofile_mesh_point + mesh_point + false + + verticalprofile_meshpoint_parameterv + + + + + + + + + + verticalprofile_mesh_parameter + parameterid + true + + verticalprofile_mesh_date + + + + + + + + + + verticalprofile_mesh_date + dateid + true + + verticalprofile_mesh_calculate_results + + + + + + + + + + + verticalprofile_mesh_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + verticalprofile_instantaneouspoint_series + seriesid + false + + verticalprofile_instantaneouspoint_point + + + + + + + + verticalprofile_instantaneouspoint_point + instantaneouspoint_point + false + + verticalprofile_instantaneouspoint_parameterv + + + + + + + + + verticalprofile_instantaneouspoint_parameter + parameterid + true + + verticalprofile_instantaneouspoint_calculate_results + + + + + + + + + verticalprofile_instantaneouspoint_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + horizontalprofile_instantaneouspoint_vehicle + vehicleid + false + + horizontalprofile_instantaneouspoint_cruise + + + + + + + + horizontalprofile_instantaneouspoint_cruise + cruiseid + false + + horizontalprofile_instantaneouspoint_track + + + + + + + + + horizontalprofile_instantaneouspoint_track + trackid + false + + horizontalprofile_instantaneouspoint_surveyinfo + Eisklimatologie + + + + + + + horizontalprofile_instantaneouspoint_surveyinfo + surveyid + false + + horizontalprofile_instantaneouspoint_parameter + + + + + + + + + horizontalprofile_instantaneouspoint_parameter + parameterid + true + + horizontalprofile_instantaneouspoint_depth + + + + + + + + + + horizontalprofile_instantaneouspoint_depth + measurementid + true + + horizontalprofile_instantaneouspoint_calculate_results + + + + + + + + + + + horizontalprofile_instantaneouspoint_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + verticalprofile_mesh + meshid + false + + horizontalprofile_mesh_coordinate + + + + + + + + + mesh_coordinate + false + + horizontalprofile_mesh_pointv + + + + + + + + + verticalprofile_mesh_point + mesh_point + false + + horizontalprofile_mesh_axisv + + + + + + + + + axisid + false + + horizontalprofile_meshpoint_parameterv + + + + + + + + + verticalprofile_mesh_parameter + parameterid + true + + horizontalprofile_meshpoint_depth + + + + + + + + + + + + horizontalprofile_meshpoint_depth + depthid + true + + horizontalprofile_mesh_datev + + + + + + + + + + + + verticalprofile_mesh_date + dateid + true + + horizontalprofile_mesh_calculate_results + + + + + + + + + + + + + horizontalprofile_mesh_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + verticalprofile_mesh + meshid + false + + verticalcrosssection_mesh_coordinate + + + + + + + + + mesh_coordinate + false + + verticalcrosssection_mesh_pointv + + + + + + + + + verticalprofile_mesh_point + mesh_point + false + + verticalcrosssection_mesh_axisv + + + + + + + + + axisid + false + + verticalcrosssection_mesh_parameterv + + + + + + + + + verticalprofile_mesh_parameter + parameterid + false + + verticalcrosssection_mesh_date + + + + + + + + + + + + verticalcrosssection_mesh_date + dateid + false + + verticalcrosssection_mesh_calculate_results + + + + + + + + + + + + verticalcrosssection_mesh_chart_data + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + src/test/ressources/ehcache.xml + + + ../geo-backend/src/test/ressources/ArcSDEConnectionPoolTestCase.properties + src/test/ressources/queries.properties + + + 8181 + + + + 300000 + + + + + + + diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/doc/conf/ehcache.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/gnv-artifacts/doc/conf/ehcache.xml Wed Oct 21 10:16:52 2009 +0000 @@ -0,0 +1,9 @@ + + + + + diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/doc/conf/log.conf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/gnv-artifacts/doc/conf/log.conf Wed Oct 21 10:16:52 2009 +0000 @@ -0,0 +1,4 @@ +.level=FINEST +handlers=java.util.logging.ConsoleHandler +java.util.logging.FileHandler.formatter=java.util.logging.SimpleFormatter +java.util.logging.FileHandler.pattern=rest-%u-%g.log diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/doc/conf/log4j.properties --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/gnv-artifacts/doc/conf/log4j.properties Wed Oct 21 10:16:52 2009 +0000 @@ -0,0 +1,9 @@ +# Set root logger level to DEBUG and its only appender to A1. +log4j.rootLogger=DEBUG, A1 + +# A1 is set to be a ConsoleAppender. +log4j.appender.A1=org.apache.log4j.ConsoleAppender + +# A1 uses PatternLayout. +log4j.appender.A1.layout=org.apache.log4j.PatternLayout +log4j.appender.A1.layout.ConversionPattern=%d [%t] %-5p %c - %m%n diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/doc/conf/queries.properties --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Wed Oct 21 10:16:52 2009 +0000 @@ -0,0 +1,552 @@ +############################################# +############################################# +########## Zeitserie ############## +############################################# +############################################# + +timeseries_timeseriespoint=SELECT DISTINCT \ + tsp.FEATUREID KEY, \ + tsp.NAME VALUE \ + FROM MEDIAN.TIMESERIESPOINT tsp, \ + MEDIAN.MEASUREMENT mmt \ + WHERE tsp.FEATUREID = mmt.FEATUREID AND \ + mmt.SOURCEID = ? \ + order by tsp.name + +timeseries_parameter=SELECT DISTINCT \ + p.PARAMETERID KEY, \ + p.GERMANNAME VALUE \ + from MEDIAN.PARAMETER p \ + where p.PARAMETERID in \ + (select distinct \ + ts.PARAMETERID \ + from MEDIAN.TIMESERIES ts \ + where ts.TIMESERIESID in \ + (select distinct \ + tsv.TIMESERIESID \ + from MEDIAN.TIMESERIESVALUE tsv \ + where tsv.MEASUREMENTID in \ + (select m.MEASUREMENTID \ + from MEDIAN.MEASUREMENT m, \ + MEDIAN.TIMESERIESPOINT tsp \ + where m.FEATUREID = tsp.FEATUREID and \ + tsp.FEATUREID IN ( ? )\ + )\ + )\ + ) \ + ORDER BY p.GERMANNAME + +timeseries_depth_height=SELECT DISTINCT \ + m.MEASUREMENTID KEY, \ + m.ZLOCATION VALUE \ + from MEDIAN.MEASUREMENT m \ + where m.MEASUREMENTID in \ + (SELECT DISTINCT \ + t_v.MEASUREMENTID \ + from MEDIAN.TIMESERIESVALUE t_v \ + where t_v.TIMESERIESID in \ + (SELECT DISTINCT \ + t.TIMESERIESID \ + from MEDIAN.TIMESERIES t \ + where t.PARAMETERID in \ + (SELECT DISTINCT \ + p.PARAMETERID \ + from MEDIAN.PARAMETER p \ + where m.FEATUREID IN ( ? ) and \ + p.PARAMETERID IN (?)\ + )\ + )\ + )\ + ORDER BY m.ZLOCATION DESC + +timeseries_interval=select min(tv.TIMEVALUE) MIN, \ + max(tv.TIMEVALUE) MAX \ + from MEDIAN.TIMESERIES t , \ + MEDIAN.TIMESERIESVALUE tv \ + where tv.TIMESERIESID = t.TIMESERIESID AND \ + t.PARAMETERID IN ( ? ) AND \ + tv.MEASUREMENTID IN ( ? ) + +timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \ + tv.DATAVALUE YORDINATE, \ + t.PARAMETERID GROUP1, \ + tv.MEASUREMENTID GROUP2, \ + tv.TIMESERIESID GROUP3 \ + FROM MEDIAN.TIMESERIESVALUE tv, \ + MEDIAN.TIMESERIES t \ + WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ + t.PARAMETERID IN ( ? ) AND \ + tv.MEASUREMENTID IN ( ? ) AND \ + tv.TIMEVALUE >= ? AND \ + tv.TIMEVALUE <= ? \ + ORDER BY tv.MEASUREMENTID , \ + tv.TIMESERIESID , \ + t.PARAMETERID , \ + tv.TIMEVALUE + +############################################# +############################################# +########## Zeitserie Mesh ############## +############################################# +############################################# + +timeseries_mesh = SELECT OBJECTID KEY, \ + m.NAME VALUE \ + FROM MEDIAN.MESH m \ + WHERE SOURCEID IN (?) \ + ORDER BY m.NAME +timeseries_meshpoint = SELECT FEATUREID, \ + ST_ASTEXT(SHAPE) \ + FROM MEDIAN.MESHPOINT \ + WHERE MESHID in \ + (SELECT DISTINCT MESHID \ + FROM MEDIAN.MESH \ + WHERE OBJECTID = ?) AND \ + KPOSITION = 1 AND \ + INTERSECTS(SHAPE,"?") + +timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ + 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT mp \ + where ml.KPOSITION = mp.KPOSITION and \ + ml.MESHID = mp.MESHID and \ + mp.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + mp.MESHID = m.MESHID AND \ + IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ + JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + order by ml.UPPERZLOCATION desc + +timeseries_mesh_parameter=SELECT distinct \ + p.PARAMETERID KEY , \ + p.GERMANNAME VALUE \ + from MEDIAN.PARAMETER p, \ + MEDIAN.MESHSCALARVALUE msc, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + msc.PARTID = m.PARTIDMIN AND \ + msc.PARAMETERID = p.PARAMETERID \ + order by p.GERMANNAME +timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ + min(TIMEVALUE) MIN, \ + max(TIMEVALUE) MAX \ + from MEDIAN.MESHSCALARVALUE msc , \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + msc.PARTID >= m.PARTIDMIN AND \ + msc.PARTID <= m.PARTIDMAX AND \ + msc.PARAMETERID IN (?) + +timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ + msv.TIMEVALUE XORDINATE, \ + msv.DATAVALUE YORDINATE, \ + msv.PARAMETERID GROUP1, \ + msv.FEATUREID GROUP2, \ + mp.FEATUREID GROUP3 \ + from MEDIAN.MESHSCALARVALUE msv , \ + MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where (m.OBJECTID = ? AND \ + msv.PARTID >= m.PARTIDMIN AND \ + msv.PARTID <= m.PARTIDMAX ) AND \ + msv.FEATUREID in ( ? ) AND \ + msv.PARAMETERID in ( ? ) AND \ + mp.FEATUREID in ( ? ) AND \ + msv.TIMEVALUE >= ? AND \ + msv.TIMEVALUE <= ? \ + order by mp.FEATUREID, \ + msv.FEATUREID, \ + msv.PARAMETERID, \ + msv.TIMEVALUE + +############################################# +############################################# +########## Vertikalprofil ############## +############################################# +############################################# + +verticalprofile_point=SELECT DISTINCT \ + tsp.FEATUREID KEY, \ + tsp.NAME VALUE \ + FROM MEDIAN.TIMESERIESPOINT tsp, \ + MEDIAN.MEASUREMENT mmt \ + WHERE tsp.FEATUREID = mmt.FEATUREID AND \ + mmt.SOURCEID = ? \ + order by tsp.name + +verticalprofile_parameter=SELECT DISTINCT \ + p.PARAMETERID KEY, \ + p.GERMANNAME VALUE \ + from MEDIAN.PARAMETER p, \ + MEDIAN.TIMESERIES ts, \ + MEDIAN.TIMESERIESVALUE tsv, \ + MEDIAN.MEASUREMENT m \ + where ts.PARAMETERID = p.PARAMETERID and \ + ts.TIMESERIESID = tsv.TIMESERIESID and \ + m.MEASUREMENTID = tsv.MEASUREMENTID and \ + m.FEATUREID = ? \ + ORDER BY p.GERMANNAME + +verticalprofile_date=select distinct \ + tsv.TIMEVALUE KEY, \ + tsv.TIMEVALUE VALUE \ + from MEDIAN.TIMESERIES ts , \ + MEDIAN.TIMESERIESVALUE tsv, \ + MEDIAN.MEASUREMENT m \ + where ts.TIMESERIESID = tsv.TIMESERIESID and \ + m.MEASUREMENTID = tsv.MEASUREMENTID and \ + m.FEATUREID = ? and \ + ts.PARAMETERID IN ( ? ) \ + order by tsv.TIMEVALUE + +verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \ + tsv.DATAVALUE YORDINATE, \ + ts.PARAMETERID GROUP1, \ + tsv.TIMEVALUE GROUP2, \ + 1 GROUP3 \ + from MEDIAN.TIMESERIES ts, \ + MEDIAN.TIMESERIESVALUE tsv, \ + MEDIAN.MEASUREMENT m \ + where ts.TIMESERIESID = tsv.TIMESERIESID and \ + m.MEASUREMENTID = tsv.MEASUREMENTID and \ + m.FEATUREID = ? and \ + ts.PARAMETERID IN ( ? ) AND \ + tsv.TIMEVALUE IN (?) \ + ORDER BY tsv.TIMEVALUE , \ + tsv.TIMESERIESID , \ + ts.PARAMETERID , \ + tsv.TIMEVALUE + +############################################# +############################################# +########## Vertikalprofil Mesh ############## +############################################# +############################################# + +verticalprofile_mesh = SELECT OBJECTID KEY, \ + m.NAME VALUE \ + FROM MEDIAN.MESH m \ + WHERE SOURCEID IN (?) \ + order by m.NAME + +verticalprofile_mesh_point = SELECT FEATUREID, \ + ST_ASTEXT(SHAPE) \ + FROM MEDIAN.MESHPOINT \ + WHERE MESHID in \ + (SELECT DISTINCT MESHID \ + FROM MEDIAN.MESH \ + WHERE OBJECTID = ?) AND \ + KPOSITION = 1 AND \ + INTERSECTS(SHAPE,"?") + +verticalprofile_mesh_parameter=SELECT distinct \ + p.PARAMETERID KEY , \ + p.GERMANNAME VALUE \ + from MEDIAN.PARAMETER p, \ + MEDIAN.MESHSCALARVALUE msc, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + m.PARTIDMIN = msc.PARTID AND \ + msc.PARAMETERID = p.PARAMETERID \ + order by p.GERMANNAME + +verticalprofile_mesh_date= select distinct \ + msv.TIMEVALUE KEY, \ + msv.TIMEVALUE VALUE \ + from MEDIAN.MESHSCALARVALUE msv , \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + msv.PARTID >= m.PARTIDMIN AND \ + msv.PARTID <= m.PARTIDMAX AND \ + msv.PARAMETERID in (?) \ + order by msv.TIMEVALUE + +verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ + msv.DATAVALUE YORDINATE, \ + msv.PARAMETERID GROUP1, \ + msv.TIMEVALUE GROUP2, \ + 1 GROUP3 \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m, \ + MEDIAN.MESHSCALARVALUE msv \ + where msv.FEATUREID = mp. FEATUREID AND \ + ml.KPOSITION = mp.KPOSITION and \ + ml.MESHID = mp.MESHID and \ + m.MESHID = mp.MESHID AND \ + m.PARTIDMIN <= msv.PARTID AND \ + m.PARTIDMAX >= msv.PARTID AND \ + msv.PARAMETERID in (?) AND \ + msv.TIMEVALUE in (?) AND \ + m.OBJECTID = ? AND \ + mp.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + mp.MESHID = m.MESHID AND \ + IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ + JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + order by msv.PARAMETERID, \ + msv.TIMEVALUE, \ + ml.UPPERZLOCATION + +############################################# +############################################# +##### Vertikalprofil InstantaneousPoint ##### +############################################# +############################################# + +verticalprofile_instantaneouspoint_series = SELECT DISTINCT \ + S.SERIESID KEY , \ + S.DESCRIPTION VALUE \ + FROM MEDIAN.SERIES S, \ + MEDIAN.INSTANTANEOUSPOINT I, \ + MEDIAN.MEASUREMENT M \ + WHERE S.SERIESID = I.SERIESID AND \ + I.POINTSPEC = 4 AND \ + I.FEATUREID = M.FEATUREID AND \ + M.SOURCEID= ? \ + ORDER BY S.DESCRIPTION + +verticalprofile_instantaneouspoint_point = SELECT DISTINCT \ + I.FEATUREID KEY, \ + to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \ + I.TIMEVALUE \ + FROM MEDIAN.INSTANTANEOUSPOINT I, \ + MEDIAN.MEASUREMENT M \ + WHERE I.SERIESID = ? AND \ + I.POINTSPEC = 4 AND \ + I.FEATUREID = M.FEATUREID AND \ + M.SOURCEID = ? \ + ORDER BY I.TIMEVALUE + +verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ + P.PARAMETERID KEY , \ + P.GERMANNAME VALUE \ + FROM MEDIAN.PARAMETER P, \ + MEDIAN.INSTANTANEOUSPOINT IP, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE IP.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + MSV.PARAMETERID = P.PARAMETERID AND \ + IP.FEATUREID = ? \ + ORDER BY P.GERMANNAME + +verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ + MSV.DATAVALUE YORDINATE, \ + MSV.PARAMETERID GROUP1, \ + IP.TIMEVALUE GROUP2, \ + 1 GROUP3 \ + FROM MEDIAN.INSTANTANEOUSPOINT IP, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE IP.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + IP.FEATUREID = ? AND \ + MSV.PARAMETERID in (?) \ + ORDER BY IP.TIMEVALUE, \ + MSV.PARAMETERID, \ + M.ZLOCATION + +############################################# +############################################# +#### Horizontalprofil InstantaneousPoint #### +############################################# +############################################# +horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \ + V.VEHICLEID KEY, \ + V.NAME VALUE \ + FROM MEDIAN.VEHICLE V, \ + MEDIAN.CRUISE C, \ + MEDIAN.TRACK T, \ + MEDIAN.SURVEYINFO S, \ + MEDIAN.INSTANTANEOUSPOINT I, \ + MEDIAN.MEASUREMENT M \ + WHERE V.VEHICLEID = C.VEHICLEID AND \ + C.CRUISEID = T.CRUISEID AND \ + T.TRACKID = S.TRACKID AND \ + S.SURVEYID = I.SURVEYID AND \ + I.FEATUREID = M.FEATUREID AND \ + M.SOURCEID = ? \ + ORDER BY V.NAME +horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ + C.CRUISEID KEY , \ + C.NAME VALUE \ + FROM MEDIAN.CRUISE C, \ + MEDIAN.TRACK T, \ + MEDIAN.SURVEYINFO S, \ + MEDIAN.INSTANTANEOUSPOINT I, \ + MEDIAN.MEASUREMENT M \ + WHERE C.CRUISEID = T.CRUISEID AND \ + T.TRACKID = S.TRACKID AND \ + S.SURVEYID = I.SURVEYID AND \ + I.FEATUREID = M.FEATUREID AND \ + C.VEHICLEID = ? AND \ + M.SOURCEID = ? AND \ + C.NAME IS NOT NULL \ + ORDER BY C.NAME +horizontalprofile_instantaneouspoint_track= SELECT \ + T.TRACKID KEY , \ + to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ + FROM MEDIAN.TRACK T \ + WHERE T.CRUISEID = ? \ + ORDER BY T.STARTDATE, \ + T.ENDDATE, \ + T.NAME +horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ + SURVEYID KEY , \ + to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \ + FROM MEDIAN.SURVEYINFO \ + WHERE TRACKID = ? \ + ORDER BY STARTDATE, \ + ENDDATE, \ + DESCRIPTION +horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ + P.PARAMETERID KEY , \ + P.GERMANNAME VALUE \ + FROM MEDIAN.PARAMETER P , \ + MEDIAN.MEASUREMENT M , \ + MEDIAN.INSTANTANEOUSPOINT IP , \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE P.PARAMETERID = MSV.PARAMETERID AND \ + MSV.MEASUREMENTID = M.MEASUREMENTID AND \ + M.FEATUREID = IP.FEATUREID AND \ + IP.SURVEYID = ? \ + ORDER BY P.GERMANNAME +horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ + M.ZLOCATION KEY, \ + M.ZLOCATION VALUE \ + FROM MEDIAN.MEASUREMENT M , \ + MEDIAN.INSTANTANEOUSPOINT IP \ + WHERE M.FEATUREID = IP.FEATUREID AND \ + IP.SURVEYID = ? \ + ORDER BY M.ZLOCATION +horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \ + MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \ + MSV.DATAVALUE YORDINATE , \ + MSV.PARAMETERID GROUP1 , \ + ZLOCATION GROUP2 , \ + 1 GROUP3 \ + FROM MEDIAN.INSTANTANEOUSPOINT, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \ + M.ZLOCATION IN (?) AND \ + MSV.PARAMETERID in (?) \ + ORDER BY MSV.PARAMETERID, \ + M.ZLOCATION, \ + MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE + +############################################# +############################################# +########### Horizontalprofil MESH ########### +############################################# +############################################# +horizontalprofile_meshpoint_depth = SELECT DISTINCT \ + mp.KPOSITION KEY, \ + 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT mp \ + where ml.KPOSITION = mp.KPOSITION and \ + ml.MESHID = mp.MESHID and \ + mp.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + mp.MESHID = m.MESHID AND \ + IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ + JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + order by mp.KPOSITION + +horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ + msv.DATAVALUE YORDINATE, \ + msv.PARAMETERID GROUP1, \ + MEDIAN.MESHPOINT.KPOSITION GROUP2, \ + msv.TIMEVALUE GROUP3, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT , \ + MEDIAN.MESH m, \ + MEDIAN.MESHSCALARVALUE msv \ + where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ + ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ + ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ + m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ + m.PARTIDMIN <= msv.PARTID AND \ + m.PARTIDMAX >= msv.PARTID AND \ + msv.PARAMETERID in (?) AND \ + msv.TIMEVALUE in (?) AND \ + m.OBJECTID = ? AND \ + MEDIAN.MESHPOINT.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + mp.MESHID = m.MESHID AND \ + KPOSITION in ( ? ) and \ + ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + order by msv.TIMEVALUE, \ + MEDIAN.MESHPOINT.KPOSITION, \ + msv.PARAMETERID, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION + + +############################################# +############################################# +########### Profilschnitt MESH ########### +############################################# +############################################# +verticalcrosssection_mesh_date = select distinct \ + msv.TIMEVALUE KEY, \ + msv.TIMEVALUE VALUE \ + from MEDIAN.MESHSCALARVALUE msv , \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + msv.PARTID >= m.PARTIDMIN AND \ + msv.PARTID <= m.PARTIDMAX AND \ + msv.PARAMETERID = ? \ + order by msv.TIMEVALUE +verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ + msv.DATAVALUE YORDINATE, \ + msv.PARAMETERID GROUP1, \ + msv.TIMEVALUE GROUP2, \ + MEDIAN.MESHPOINT.JPOSITION, \ + MEDIAN.MESHPOINT.IPOSITION, \ + MEDIAN.MESHPOINT.KPOSITION \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT , \ + MEDIAN.MESH m, \ + MEDIAN.MESHSCALARVALUE msv \ + where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ + ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ + ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ + m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ + m.PARTIDMIN <= msv.PARTID AND \ + m.PARTIDMAX >= msv.PARTID AND \ + msv.PARAMETERID = ? AND \ + msv.TIMEVALUE = ? AND \ + m.OBJECTID = ? AND \ + MEDIAN.MESHPOINT.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + mp.MESHID = m.MESHID AND \ + ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + order by msv.TIMEVALUE, \ + msv.PARAMETERID, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION, \ + MEDIAN.MESHPOINT.KPOSITION + \ No newline at end of file diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/src/test/ressources/conf.xml --- a/gnv-artifacts/src/test/ressources/conf.xml Wed Oct 21 10:09:53 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,1069 +0,0 @@ - - - de.intevation.gnv.artifacts.context.GNVArtifactContextFactory - - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - de.intevation.artifactdatabase.DefaultArtifactFactory - - - - - - - - - - - - timeseries_mesh - meshid - false - - timeseries_mesh_coordinate - - - - - - - - - mesh_coordinate - false - - timeseries_meshpointv - - - - - - - - - timeseries_meshpoint - mesh_point - false - - timeseries_meshpoint_depthv - - - - - - - - - - timeseries_meshpoint_depth - depthid - true - - timeseries_meshpoint_parameterv - - - - - - - - - - timeseries_mesh_parameter - parameterid - true - - timeseries_meshpoint_interval - - - - - - - - - - - timeseries_mesh_interval - timeinterval - false - - timeseries_meshpoint_calculate_results - - - - - - - - - - - - timeseries_mesh_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - timeseries_timeseriespoint - featureid - false - - timeseries_parameter - - - - - - - - - timeseries_parameter - parameterid - true - - timeseries_depth_height - - - - - - - - - timeseries_depth_height - measurementid - true - - timeseries_interval - - - - - - - - - - timeseries_interval - timeinterval - false - - timeseries_calculate_results - - - - - - - - - - timeseries_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - verticalprofile_point - featureid - false - - verticalprofile_parameter - - - - - - - - - verticalprofile_parameter - parameterid - true - - verticalprofile_date - - - - - - - - - verticalprofile_date - dateid - true - - verticalprofile_calculate_results - - - - - - - - - - verticalprofile_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - verticalprofile_mesh - meshid - false - - verticalprofile_mesh_coordinate - - - - - - - - - mesh_coordinate - false - - verticalprofile_mesh_pointv - - - - - - - - - verticalprofile_mesh_point - mesh_point - false - - verticalprofile_meshpoint_parameterv - - - - - - - - - - verticalprofile_mesh_parameter - parameterid - true - - verticalprofile_mesh_date - - - - - - - - - - verticalprofile_mesh_date - dateid - true - - verticalprofile_mesh_calculate_results - - - - - - - - - - - verticalprofile_mesh_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - verticalprofile_instantaneouspoint_series - seriesid - false - - verticalprofile_instantaneouspoint_point - - - - - - - - verticalprofile_instantaneouspoint_point - instantaneouspoint_point - false - - verticalprofile_instantaneouspoint_parameterv - - - - - - - - - verticalprofile_instantaneouspoint_parameter - parameterid - true - - verticalprofile_instantaneouspoint_calculate_results - - - - - - - - - verticalprofile_instantaneouspoint_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - horizontalprofile_instantaneouspoint_vehicle - vehicleid - false - - horizontalprofile_instantaneouspoint_cruise - - - - - - - - horizontalprofile_instantaneouspoint_cruise - cruiseid - false - - horizontalprofile_instantaneouspoint_track - - - - - - - - - horizontalprofile_instantaneouspoint_track - trackid - false - - horizontalprofile_instantaneouspoint_surveyinfo - Eisklimatologie - - - - - - - horizontalprofile_instantaneouspoint_surveyinfo - surveyid - false - - horizontalprofile_instantaneouspoint_parameter - - - - - - - - - horizontalprofile_instantaneouspoint_parameter - parameterid - true - - horizontalprofile_instantaneouspoint_depth - - - - - - - - - - horizontalprofile_instantaneouspoint_depth - measurementid - true - - horizontalprofile_instantaneouspoint_calculate_results - - - - - - - - - - - horizontalprofile_instantaneouspoint_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - verticalprofile_mesh - meshid - false - - horizontalprofile_mesh_coordinate - - - - - - - - - mesh_coordinate - false - - horizontalprofile_mesh_pointv - - - - - - - - - verticalprofile_mesh_point - mesh_point - false - - horizontalprofile_mesh_axisv - - - - - - - - - axisid - false - - horizontalprofile_meshpoint_parameterv - - - - - - - - - verticalprofile_mesh_parameter - parameterid - true - - horizontalprofile_meshpoint_depth - - - - - - - - - - - - horizontalprofile_meshpoint_depth - depthid - true - - horizontalprofile_mesh_datev - - - - - - - - - - - - verticalprofile_mesh_date - dateid - true - - horizontalprofile_mesh_calculate_results - - - - - - - - - - - - - horizontalprofile_mesh_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - verticalprofile_mesh - meshid - false - - verticalcrosssection_mesh_coordinate - - - - - - - - - mesh_coordinate - false - - verticalcrosssection_mesh_pointv - - - - - - - - - verticalprofile_mesh_point - mesh_point - false - - verticalcrosssection_mesh_axisv - - - - - - - - - axisid - false - - verticalcrosssection_mesh_parameterv - - - - - - - - - verticalprofile_mesh_parameter - parameterid - false - - verticalcrosssection_mesh_date - - - - - - - - - - - - verticalcrosssection_mesh_date - dateid - false - - verticalcrosssection_mesh_calculate_results - - - - - - - - - - - - verticalcrosssection_mesh_chart_data - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - src/test/ressources/ehcache.xml - - - ../geo-backend/src/test/ressources/ArcSDEConnectionPoolTestCase.properties - src/test/ressources/queries.properties - - - 8181 - - - - 300000 - - - - - - - diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/src/test/ressources/ehcache.xml --- a/gnv-artifacts/src/test/ressources/ehcache.xml Wed Oct 21 10:09:53 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,9 +0,0 @@ - - - - - diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/src/test/ressources/log.conf --- a/gnv-artifacts/src/test/ressources/log.conf Wed Oct 21 10:09:53 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,4 +0,0 @@ -.level=FINEST -handlers=java.util.logging.ConsoleHandler -java.util.logging.FileHandler.formatter=java.util.logging.SimpleFormatter -java.util.logging.FileHandler.pattern=rest-%u-%g.log diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/src/test/ressources/log4j.properties --- a/gnv-artifacts/src/test/ressources/log4j.properties Wed Oct 21 10:09:53 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,9 +0,0 @@ -# Set root logger level to DEBUG and its only appender to A1. -log4j.rootLogger=DEBUG, A1 - -# A1 is set to be a ConsoleAppender. -log4j.appender.A1=org.apache.log4j.ConsoleAppender - -# A1 uses PatternLayout. -log4j.appender.A1.layout=org.apache.log4j.PatternLayout -log4j.appender.A1.layout.ConversionPattern=%d [%t] %-5p %c - %m%n diff -r d19259c86b72 -r b66e8a6f3907 gnv-artifacts/src/test/ressources/queries.properties --- a/gnv-artifacts/src/test/ressources/queries.properties Wed Oct 21 10:09:53 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,552 +0,0 @@ -############################################# -############################################# -########## Zeitserie ############## -############################################# -############################################# - -timeseries_timeseriespoint=SELECT DISTINCT \ - tsp.FEATUREID KEY, \ - tsp.NAME VALUE \ - FROM MEDIAN.TIMESERIESPOINT tsp, \ - MEDIAN.MEASUREMENT mmt \ - WHERE tsp.FEATUREID = mmt.FEATUREID AND \ - mmt.SOURCEID = ? \ - order by tsp.name - -timeseries_parameter=SELECT DISTINCT \ - p.PARAMETERID KEY, \ - p.GERMANNAME VALUE \ - from MEDIAN.PARAMETER p \ - where p.PARAMETERID in \ - (select distinct \ - ts.PARAMETERID \ - from MEDIAN.TIMESERIES ts \ - where ts.TIMESERIESID in \ - (select distinct \ - tsv.TIMESERIESID \ - from MEDIAN.TIMESERIESVALUE tsv \ - where tsv.MEASUREMENTID in \ - (select m.MEASUREMENTID \ - from MEDIAN.MEASUREMENT m, \ - MEDIAN.TIMESERIESPOINT tsp \ - where m.FEATUREID = tsp.FEATUREID and \ - tsp.FEATUREID IN ( ? )\ - )\ - )\ - ) \ - ORDER BY p.GERMANNAME - -timeseries_depth_height=SELECT DISTINCT \ - m.MEASUREMENTID KEY, \ - m.ZLOCATION VALUE \ - from MEDIAN.MEASUREMENT m \ - where m.MEASUREMENTID in \ - (SELECT DISTINCT \ - t_v.MEASUREMENTID \ - from MEDIAN.TIMESERIESVALUE t_v \ - where t_v.TIMESERIESID in \ - (SELECT DISTINCT \ - t.TIMESERIESID \ - from MEDIAN.TIMESERIES t \ - where t.PARAMETERID in \ - (SELECT DISTINCT \ - p.PARAMETERID \ - from MEDIAN.PARAMETER p \ - where m.FEATUREID IN ( ? ) and \ - p.PARAMETERID IN (?)\ - )\ - )\ - )\ - ORDER BY m.ZLOCATION DESC - -timeseries_interval=select min(tv.TIMEVALUE) MIN, \ - max(tv.TIMEVALUE) MAX \ - from MEDIAN.TIMESERIES t , \ - MEDIAN.TIMESERIESVALUE tv \ - where tv.TIMESERIESID = t.TIMESERIESID AND \ - t.PARAMETERID IN ( ? ) AND \ - tv.MEASUREMENTID IN ( ? ) - -timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \ - tv.DATAVALUE YORDINATE, \ - t.PARAMETERID GROUP1, \ - tv.MEASUREMENTID GROUP2, \ - tv.TIMESERIESID GROUP3 \ - FROM MEDIAN.TIMESERIESVALUE tv, \ - MEDIAN.TIMESERIES t \ - WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ - t.PARAMETERID IN ( ? ) AND \ - tv.MEASUREMENTID IN ( ? ) AND \ - tv.TIMEVALUE >= ? AND \ - tv.TIMEVALUE <= ? \ - ORDER BY tv.MEASUREMENTID , \ - tv.TIMESERIESID , \ - t.PARAMETERID , \ - tv.TIMEVALUE - -############################################# -############################################# -########## Zeitserie Mesh ############## -############################################# -############################################# - -timeseries_mesh = SELECT OBJECTID KEY, \ - m.NAME VALUE \ - FROM MEDIAN.MESH m \ - WHERE SOURCEID IN (?) \ - ORDER BY m.NAME -timeseries_meshpoint = SELECT FEATUREID, \ - ST_ASTEXT(SHAPE) \ - FROM MEDIAN.MESHPOINT \ - WHERE MESHID in \ - (SELECT DISTINCT MESHID \ - FROM MEDIAN.MESH \ - WHERE OBJECTID = ?) AND \ - KPOSITION = 1 AND \ - INTERSECTS(SHAPE,"?") - -timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ - 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ - from MEDIAN.MESHLAYER ml, \ - MEDIAN.MESHPOINT mp \ - where ml.KPOSITION = mp.KPOSITION and \ - ml.MESHID = mp.MESHID and \ - mp.FEATUREID in \ - ( select FEATUREID \ - from MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ - JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ - order by ml.UPPERZLOCATION desc - -timeseries_mesh_parameter=SELECT distinct \ - p.PARAMETERID KEY , \ - p.GERMANNAME VALUE \ - from MEDIAN.PARAMETER p, \ - MEDIAN.MESHSCALARVALUE msc, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - msc.PARTID = m.PARTIDMIN AND \ - msc.PARAMETERID = p.PARAMETERID \ - order by p.GERMANNAME -timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ - min(TIMEVALUE) MIN, \ - max(TIMEVALUE) MAX \ - from MEDIAN.MESHSCALARVALUE msc , \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - msc.PARTID >= m.PARTIDMIN AND \ - msc.PARTID <= m.PARTIDMAX AND \ - msc.PARAMETERID IN (?) - -timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ - msv.TIMEVALUE XORDINATE, \ - msv.DATAVALUE YORDINATE, \ - msv.PARAMETERID GROUP1, \ - msv.FEATUREID GROUP2, \ - mp.FEATUREID GROUP3 \ - from MEDIAN.MESHSCALARVALUE msv , \ - MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where (m.OBJECTID = ? AND \ - msv.PARTID >= m.PARTIDMIN AND \ - msv.PARTID <= m.PARTIDMAX ) AND \ - msv.FEATUREID in ( ? ) AND \ - msv.PARAMETERID in ( ? ) AND \ - mp.FEATUREID in ( ? ) AND \ - msv.TIMEVALUE >= ? AND \ - msv.TIMEVALUE <= ? \ - order by mp.FEATUREID, \ - msv.FEATUREID, \ - msv.PARAMETERID, \ - msv.TIMEVALUE - -############################################# -############################################# -########## Vertikalprofil ############## -############################################# -############################################# - -verticalprofile_point=SELECT DISTINCT \ - tsp.FEATUREID KEY, \ - tsp.NAME VALUE \ - FROM MEDIAN.TIMESERIESPOINT tsp, \ - MEDIAN.MEASUREMENT mmt \ - WHERE tsp.FEATUREID = mmt.FEATUREID AND \ - mmt.SOURCEID = ? \ - order by tsp.name - -verticalprofile_parameter=SELECT DISTINCT \ - p.PARAMETERID KEY, \ - p.GERMANNAME VALUE \ - from MEDIAN.PARAMETER p, \ - MEDIAN.TIMESERIES ts, \ - MEDIAN.TIMESERIESVALUE tsv, \ - MEDIAN.MEASUREMENT m \ - where ts.PARAMETERID = p.PARAMETERID and \ - ts.TIMESERIESID = tsv.TIMESERIESID and \ - m.MEASUREMENTID = tsv.MEASUREMENTID and \ - m.FEATUREID = ? \ - ORDER BY p.GERMANNAME - -verticalprofile_date=select distinct \ - tsv.TIMEVALUE KEY, \ - tsv.TIMEVALUE VALUE \ - from MEDIAN.TIMESERIES ts , \ - MEDIAN.TIMESERIESVALUE tsv, \ - MEDIAN.MEASUREMENT m \ - where ts.TIMESERIESID = tsv.TIMESERIESID and \ - m.MEASUREMENTID = tsv.MEASUREMENTID and \ - m.FEATUREID = ? and \ - ts.PARAMETERID IN ( ? ) \ - order by tsv.TIMEVALUE - -verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \ - tsv.DATAVALUE YORDINATE, \ - ts.PARAMETERID GROUP1, \ - tsv.TIMEVALUE GROUP2, \ - 1 GROUP3 \ - from MEDIAN.TIMESERIES ts, \ - MEDIAN.TIMESERIESVALUE tsv, \ - MEDIAN.MEASUREMENT m \ - where ts.TIMESERIESID = tsv.TIMESERIESID and \ - m.MEASUREMENTID = tsv.MEASUREMENTID and \ - m.FEATUREID = ? and \ - ts.PARAMETERID IN ( ? ) AND \ - tsv.TIMEVALUE IN (?) \ - ORDER BY tsv.TIMEVALUE , \ - tsv.TIMESERIESID , \ - ts.PARAMETERID , \ - tsv.TIMEVALUE - -############################################# -############################################# -########## Vertikalprofil Mesh ############## -############################################# -############################################# - -verticalprofile_mesh = SELECT OBJECTID KEY, \ - m.NAME VALUE \ - FROM MEDIAN.MESH m \ - WHERE SOURCEID IN (?) \ - order by m.NAME - -verticalprofile_mesh_point = SELECT FEATUREID, \ - ST_ASTEXT(SHAPE) \ - FROM MEDIAN.MESHPOINT \ - WHERE MESHID in \ - (SELECT DISTINCT MESHID \ - FROM MEDIAN.MESH \ - WHERE OBJECTID = ?) AND \ - KPOSITION = 1 AND \ - INTERSECTS(SHAPE,"?") - -verticalprofile_mesh_parameter=SELECT distinct \ - p.PARAMETERID KEY , \ - p.GERMANNAME VALUE \ - from MEDIAN.PARAMETER p, \ - MEDIAN.MESHSCALARVALUE msc, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - m.PARTIDMIN = msc.PARTID AND \ - msc.PARAMETERID = p.PARAMETERID \ - order by p.GERMANNAME - -verticalprofile_mesh_date= select distinct \ - msv.TIMEVALUE KEY, \ - msv.TIMEVALUE VALUE \ - from MEDIAN.MESHSCALARVALUE msv , \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - msv.PARTID >= m.PARTIDMIN AND \ - msv.PARTID <= m.PARTIDMAX AND \ - msv.PARAMETERID in (?) \ - order by msv.TIMEVALUE - -verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ - msv.DATAVALUE YORDINATE, \ - msv.PARAMETERID GROUP1, \ - msv.TIMEVALUE GROUP2, \ - 1 GROUP3 \ - from MEDIAN.MESHLAYER ml, \ - MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m, \ - MEDIAN.MESHSCALARVALUE msv \ - where msv.FEATUREID = mp. FEATUREID AND \ - ml.KPOSITION = mp.KPOSITION and \ - ml.MESHID = mp.MESHID and \ - m.MESHID = mp.MESHID AND \ - m.PARTIDMIN <= msv.PARTID AND \ - m.PARTIDMAX >= msv.PARTID AND \ - msv.PARAMETERID in (?) AND \ - msv.TIMEVALUE in (?) AND \ - m.OBJECTID = ? AND \ - mp.FEATUREID in \ - ( select FEATUREID \ - from MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ - JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ - order by msv.PARAMETERID, \ - msv.TIMEVALUE, \ - ml.UPPERZLOCATION - -############################################# -############################################# -##### Vertikalprofil InstantaneousPoint ##### -############################################# -############################################# - -verticalprofile_instantaneouspoint_series = SELECT DISTINCT \ - S.SERIESID KEY , \ - S.DESCRIPTION VALUE \ - FROM MEDIAN.SERIES S, \ - MEDIAN.INSTANTANEOUSPOINT I, \ - MEDIAN.MEASUREMENT M \ - WHERE S.SERIESID = I.SERIESID AND \ - I.POINTSPEC = 4 AND \ - I.FEATUREID = M.FEATUREID AND \ - M.SOURCEID= ? \ - ORDER BY S.DESCRIPTION - -verticalprofile_instantaneouspoint_point = SELECT DISTINCT \ - I.FEATUREID KEY, \ - to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \ - I.TIMEVALUE \ - FROM MEDIAN.INSTANTANEOUSPOINT I, \ - MEDIAN.MEASUREMENT M \ - WHERE I.SERIESID = ? AND \ - I.POINTSPEC = 4 AND \ - I.FEATUREID = M.FEATUREID AND \ - M.SOURCEID = ? \ - ORDER BY I.TIMEVALUE - -verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ - P.PARAMETERID KEY , \ - P.GERMANNAME VALUE \ - FROM MEDIAN.PARAMETER P, \ - MEDIAN.INSTANTANEOUSPOINT IP, \ - MEDIAN.MEASUREMENT M, \ - MEDIAN.MEASUREDSCALARVALUE MSV \ - WHERE IP.FEATUREID = M.FEATUREID AND \ - M.MEASUREMENTID = MSV.MEASUREMENTID AND \ - MSV.PARAMETERID = P.PARAMETERID AND \ - IP.FEATUREID = ? \ - ORDER BY P.GERMANNAME - -verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ - MSV.DATAVALUE YORDINATE, \ - MSV.PARAMETERID GROUP1, \ - IP.TIMEVALUE GROUP2, \ - 1 GROUP3 \ - FROM MEDIAN.INSTANTANEOUSPOINT IP, \ - MEDIAN.MEASUREMENT M, \ - MEDIAN.MEASUREDSCALARVALUE MSV \ - WHERE IP.FEATUREID = M.FEATUREID AND \ - M.MEASUREMENTID = MSV.MEASUREMENTID AND \ - IP.FEATUREID = ? AND \ - MSV.PARAMETERID in (?) \ - ORDER BY IP.TIMEVALUE, \ - MSV.PARAMETERID, \ - M.ZLOCATION - -############################################# -############################################# -#### Horizontalprofil InstantaneousPoint #### -############################################# -############################################# -horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \ - V.VEHICLEID KEY, \ - V.NAME VALUE \ - FROM MEDIAN.VEHICLE V, \ - MEDIAN.CRUISE C, \ - MEDIAN.TRACK T, \ - MEDIAN.SURVEYINFO S, \ - MEDIAN.INSTANTANEOUSPOINT I, \ - MEDIAN.MEASUREMENT M \ - WHERE V.VEHICLEID = C.VEHICLEID AND \ - C.CRUISEID = T.CRUISEID AND \ - T.TRACKID = S.TRACKID AND \ - S.SURVEYID = I.SURVEYID AND \ - I.FEATUREID = M.FEATUREID AND \ - M.SOURCEID = ? \ - ORDER BY V.NAME -horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ - C.CRUISEID KEY , \ - C.NAME VALUE \ - FROM MEDIAN.CRUISE C, \ - MEDIAN.TRACK T, \ - MEDIAN.SURVEYINFO S, \ - MEDIAN.INSTANTANEOUSPOINT I, \ - MEDIAN.MEASUREMENT M \ - WHERE C.CRUISEID = T.CRUISEID AND \ - T.TRACKID = S.TRACKID AND \ - S.SURVEYID = I.SURVEYID AND \ - I.FEATUREID = M.FEATUREID AND \ - C.VEHICLEID = ? AND \ - M.SOURCEID = ? AND \ - C.NAME IS NOT NULL \ - ORDER BY C.NAME -horizontalprofile_instantaneouspoint_track= SELECT \ - T.TRACKID KEY , \ - to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ - FROM MEDIAN.TRACK T \ - WHERE T.CRUISEID = ? \ - ORDER BY T.STARTDATE, \ - T.ENDDATE, \ - T.NAME -horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ - SURVEYID KEY , \ - to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \ - FROM MEDIAN.SURVEYINFO \ - WHERE TRACKID = ? \ - ORDER BY STARTDATE, \ - ENDDATE, \ - DESCRIPTION -horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ - P.PARAMETERID KEY , \ - P.GERMANNAME VALUE \ - FROM MEDIAN.PARAMETER P , \ - MEDIAN.MEASUREMENT M , \ - MEDIAN.INSTANTANEOUSPOINT IP , \ - MEDIAN.MEASUREDSCALARVALUE MSV \ - WHERE P.PARAMETERID = MSV.PARAMETERID AND \ - MSV.MEASUREMENTID = M.MEASUREMENTID AND \ - M.FEATUREID = IP.FEATUREID AND \ - IP.SURVEYID = ? \ - ORDER BY P.GERMANNAME -horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ - M.ZLOCATION KEY, \ - M.ZLOCATION VALUE \ - FROM MEDIAN.MEASUREMENT M , \ - MEDIAN.INSTANTANEOUSPOINT IP \ - WHERE M.FEATUREID = IP.FEATUREID AND \ - IP.SURVEYID = ? \ - ORDER BY M.ZLOCATION -horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \ - MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \ - MSV.DATAVALUE YORDINATE , \ - MSV.PARAMETERID GROUP1 , \ - ZLOCATION GROUP2 , \ - 1 GROUP3 \ - FROM MEDIAN.INSTANTANEOUSPOINT, \ - MEDIAN.MEASUREMENT M, \ - MEDIAN.MEASUREDSCALARVALUE MSV \ - WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ - M.MEASUREMENTID = MSV.MEASUREMENTID AND \ - MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \ - M.ZLOCATION IN (?) AND \ - MSV.PARAMETERID in (?) \ - ORDER BY MSV.PARAMETERID, \ - M.ZLOCATION, \ - MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE - -############################################# -############################################# -########### Horizontalprofil MESH ########### -############################################# -############################################# -horizontalprofile_meshpoint_depth = SELECT DISTINCT \ - mp.KPOSITION KEY, \ - 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ - from MEDIAN.MESHLAYER ml, \ - MEDIAN.MESHPOINT mp \ - where ml.KPOSITION = mp.KPOSITION and \ - ml.MESHID = mp.MESHID and \ - mp.FEATUREID in \ - ( select FEATUREID \ - from MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ - JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ - order by mp.KPOSITION - -horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ - msv.DATAVALUE YORDINATE, \ - msv.PARAMETERID GROUP1, \ - MEDIAN.MESHPOINT.KPOSITION GROUP2, \ - msv.TIMEVALUE GROUP3, \ - MEDIAN.MESHPOINT.JPOSITION , \ - MEDIAN.MESHPOINT.IPOSITION \ - from MEDIAN.MESHLAYER ml, \ - MEDIAN.MESHPOINT , \ - MEDIAN.MESH m, \ - MEDIAN.MESHSCALARVALUE msv \ - where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ - ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ - ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ - m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ - m.PARTIDMIN <= msv.PARTID AND \ - m.PARTIDMAX >= msv.PARTID AND \ - msv.PARAMETERID in (?) AND \ - msv.TIMEVALUE in (?) AND \ - m.OBJECTID = ? AND \ - MEDIAN.MESHPOINT.FEATUREID in \ - ( select FEATUREID \ - from MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - KPOSITION in ( ? ) and \ - ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ - order by msv.TIMEVALUE, \ - MEDIAN.MESHPOINT.KPOSITION, \ - msv.PARAMETERID, \ - MEDIAN.MESHPOINT.JPOSITION , \ - MEDIAN.MESHPOINT.IPOSITION - - -############################################# -############################################# -########### Profilschnitt MESH ########### -############################################# -############################################# -verticalcrosssection_mesh_date = select distinct \ - msv.TIMEVALUE KEY, \ - msv.TIMEVALUE VALUE \ - from MEDIAN.MESHSCALARVALUE msv , \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - msv.PARTID >= m.PARTIDMIN AND \ - msv.PARTID <= m.PARTIDMAX AND \ - msv.PARAMETERID = ? \ - order by msv.TIMEVALUE -verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ - msv.DATAVALUE YORDINATE, \ - msv.PARAMETERID GROUP1, \ - msv.TIMEVALUE GROUP2, \ - MEDIAN.MESHPOINT.JPOSITION, \ - MEDIAN.MESHPOINT.IPOSITION, \ - MEDIAN.MESHPOINT.KPOSITION \ - from MEDIAN.MESHLAYER ml, \ - MEDIAN.MESHPOINT , \ - MEDIAN.MESH m, \ - MEDIAN.MESHSCALARVALUE msv \ - where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ - ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ - ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ - m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ - m.PARTIDMIN <= msv.PARTID AND \ - m.PARTIDMAX >= msv.PARTID AND \ - msv.PARAMETERID = ? AND \ - msv.TIMEVALUE = ? AND \ - m.OBJECTID = ? AND \ - MEDIAN.MESHPOINT.FEATUREID in \ - ( select FEATUREID \ - from MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ - order by msv.TIMEVALUE, \ - msv.PARAMETERID, \ - MEDIAN.MESHPOINT.JPOSITION , \ - MEDIAN.MESHPOINT.IPOSITION, \ - MEDIAN.MESHPOINT.KPOSITION - \ No newline at end of file