Mercurial > dive4elements > gnv-client
changeset 199:b66e8a6f3907
Moved Configurationfiles
gnv-artifacts/trunk@253 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Tim Englich <tim.englich@intevation.de> |
---|---|
date | Wed, 21 Oct 2009 10:16:52 +0000 (2009-10-21) |
parents | d19259c86b72 |
children | 2f6a96610cb9 |
files | gnv-artifacts/doc/conf/conf.xml gnv-artifacts/doc/conf/ehcache.xml gnv-artifacts/doc/conf/log.conf gnv-artifacts/doc/conf/log4j.properties gnv-artifacts/doc/conf/queries.properties gnv-artifacts/src/test/ressources/conf.xml gnv-artifacts/src/test/ressources/ehcache.xml gnv-artifacts/src/test/ressources/log.conf gnv-artifacts/src/test/ressources/log4j.properties gnv-artifacts/src/test/ressources/queries.properties |
diffstat | 10 files changed, 1643 insertions(+), 1643 deletions(-) [+] |
line wrap: on
line diff
--- /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 @@ +<artifact-database> + <factories> + <context-factory>de.intevation.gnv.artifacts.context.GNVArtifactContextFactory</context-factory> + <artifact-factories> + <artifact-factory name="fis_marnet" description="Artiefactfactory for Instantiating the Artifact for the FIS Marnet" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_imis" description="Artiefactfactory for Instantiating the Artifact for the FIS IMIS" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_staun" description="Artiefactfactory for Instantiating the Artifact for the FIS STAUN" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_modeldata" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_eisklimatologie" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_sst" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_delphin" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_thermosalinograph" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_chemusurvey" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_gts" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_bsh_ctd" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <artifact-factory name="fis_bsh_cbt" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + </artifact-factories> + </factories> + <artifacts> + <artifact name="fis_marnet"> + <products> + <product name= "timeSeries"> + <artifact-factory name="timeSeries" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="4"/> + <parameter name="fisname" value="fis_marnet"/> + </parameters> + </product> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfile" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="4"/> + <parameter name="fisname" value="fis_marnet"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_imis"> + <products> + <product name= "timeSeries"> + <artifact-factory name="timeSeries" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="18"/> + <parameter name="fisname" value="fis_imis"/> + </parameters> + </product> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfile" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="18"/> + <parameter name="fisname" value="fis_imis"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_staun"> + <products> + <product name= "timeSeries"> + <artifact-factory name="timeSeries" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="17"/> + <parameter name="fisname" value="fis_staun"/> + </parameters> + </product> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfile" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="17"/> + <parameter name="fisname" value="fis_staun"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_modeldata"> + <products> + <product name= "timeSeries"> + <artifact-factory name="timeSeriesMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="2"/> + <parameter name="fisname" value="fis_modeldata"/> + </parameters> + </product> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="2"/> + <parameter name="fisname" value="fis_modeldata"/> + </parameters> + </product> + <product name= "horizontalProfile"> + <artifact-factory name="horizontalProfilehorizontalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="2"/> + <parameter name="fisname" value="fis_modeldata"/> + </parameters> + </product> + <product name= "verticalcrosssection"> + <artifact-factory name="verticalCrossSectionMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.verticalcrosssection.VerticalCrossSectionMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="2"/> + <parameter name="fisname" value="fis_modeldata"/> + </parameters> + </product> + + + + + </products> + </artifact> + <artifact name="fis_eisklimatologie"> + <products> + <product name= "timeSeries"> + <artifact-factory name="timeSeriesMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="38"/> + <parameter name="fisname" value="fis_eisklimatologie"/> + </parameters> + </product> + <product name= "horizontalProfile"> + <artifact-factory name="horizontalProfilehorizontalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="38"/> + <parameter name="fisname" value="fis_eisklimatologie"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_sst"> + <products> + <product name= "timeSeries"> + <artifact-factory name="timeSeriesMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="39"/> + <parameter name="sourceid" value="40"/> + <parameter name="sourceid" value="41"/> + <parameter name="sourceid" value="42"/> + <parameter name="fisname" value="fis_sst"/> + </parameters> + </product> + <product name= "horizontalProfile"> + <artifact-factory name="horizontalProfilehorizontalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="39"/> + <parameter name="sourceid" value="40"/> + <parameter name="sourceid" value="41"/> + <parameter name="sourceid" value="42"/> + <parameter name="fisname" value="fis_sst"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_delphin"> + <products> + <product name= "horizontalProfile"> + <artifact-factory name="horizontalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="34"/> + <parameter name="fisname" value="fis_delphin"/> + </parameters> + </product> + + </products> + </artifact> + <artifact name="fis_thermosalinograph"> + <products> + <product name= "horizontalProfile"> + <artifact-factory name="horizontalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="35"/> + <parameter name="fisname" value="fis_thermosalinograph"/> + </parameters> + </product> + + </products> + </artifact> + <artifact name="fis_chemusurvey"> + <products> + <product name= "horizontalProfile"> + <artifact-factory name="horizontalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="37"/> + <parameter name="fisname" value="fis_chemusurvey"/> + </parameters> + </product> + + </products> + </artifact> + <artifact name="fis_gts"> + <products> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="5"/> + <parameter name="fisname" value="fis_gts"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_bsh_ctd"> + <products> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="32"/> + <parameter name="fisname" value="fis_bsh_ctd"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="fis_bsh_cbt"> + <products> + <product name= "verticalProfile"> + <artifact-factory name="verticalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" + ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> + <parameters> + <parameter name="sourceid" value="36"/> + <parameter name="fisname" value="fis_bsh_cbt"/> + </parameters> + </product> + </products> + </artifact> + <artifact name="timeSeriesMesh"> + <transitions> + + <transition id="timeseries_mesh" description="timeseries_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>timeseries_mesh</queryID> + <dataname>meshid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>timeseries_mesh_coordinate</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_mesh_coordinate" description="timeseries_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> + <dataname>mesh_coordinate</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>timeseries_meshpoint</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_meshpoint" description="timeseries_meshpoint" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> + <queryID>timeseries_meshpoint</queryID> + <dataname>mesh_point</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>timeseries_meshpoint_depth</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_meshpoint_depth" description="timeseries_meshpoint_depth" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>timeseries_meshpoint_depth</queryID> + <dataname>depthid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>timeseries_meshpoint_parameter</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="2"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_meshpoint_parameter" description="timeseries_meshpoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>timeseries_mesh_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>timeseries_meshpoint_interval</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="depthid" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_meshpoint_interval" description="timeseries_interval" transition="de.intevation.gnv.transition.MinMaxTransition"> + <queryID>timeseries_mesh_interval</queryID> + <dataname>timeinterval</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>timeseries_meshpoint_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="depthid" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + </inputvalues> + </transition> + + <transition id="timeseries_meshpoint_calculate_results" description="timeseries_interval" transition="de.intevation.gnv.transition.timeseries.TimeSeriesOutputTransition"> + <queryID>timeseries_mesh_chart_data</queryID> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="depthid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + <inputvalue name="minvalue" type="Date" multiselect="false" usedinquery="1"/> + <inputvalue name="maxvalue" type="Date" multiselect="false" usedinquery="1"/> + + </inputvalues> + <value-names> + <value-name name="feature" value="mesh_point"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="depthid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + + </transitions> + </artifact> + + + <artifact name="timeSeries"> + <transitions> + <transition id="timeseries_timeseriespoint" description="timeseries_timeseriespoint" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>timeseries_timeseriespoint</queryID> + <dataname>featureid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>timeseries_parameter</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_parameter" description="timeseries_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>timeseries_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>timeseries_depth_height</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="featureid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_depth_height" description="timeseries_depth_height" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>timeseries_depth_height</queryID> + <dataname>measurementid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>timeseries_interval</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="featureid" type="Integer" multiselect="false"/> + <inputvalue name="parameterid" type="Integer" multiselect="true"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="timeseries_interval" description="timeseries_interval" transition="de.intevation.gnv.transition.MinMaxTransition"> + <queryID>timeseries_interval</queryID> + <dataname>timeinterval</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>timeseries_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + <inputvalue name="parameterid" type="Integer" multiselect="true"/> + <inputvalue name="measurementid" type="Integer" multiselect="true"/> + </inputvalues> + </transition> + + <transition id="timeseries_calculate_results" description="timeseries_interval" transition="de.intevation.gnv.transition.timeseries.TimeSeriesOutputTransition"> + <queryID>timeseries_chart_data</queryID> + <inputvalues> + <inputvalue name="parameterid" type="Integer" multiselect="true"/> + <inputvalue name="measurementid" type="Integer" multiselect="true"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + <inputvalue name="minvalue" type="Date" multiselect="false"/> + <inputvalue name="maxvalue" type="Date" multiselect="false"/> + </inputvalues> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + + </transitions> + </artifact> + + <artifact name="verticalProfile"> + <transitions> + <transition id="verticalprofile_timeseriespoint" description="timeseries_timeseriespoint" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_point</queryID> + <dataname>featureid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_parameter</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_parameter" description="timeseries_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_date</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="featureid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_date" description="verticalprofile_date" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_date</queryID> + <dataname>dateid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="featureid" type="Integer" multiselect="false"/> + <inputvalue name="parameterid" type="Integer" multiselect="true"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_calculate_results" description="verticalprofile_calculate_results" transition="de.intevation.gnv.transition.profile.vertical.VerticalProfileOutputTransition"> + <queryID>verticalprofile_chart_data</queryID> + <inputvalues> + <inputvalue name="featureid" type="Integer" multiselect="false"/> + <inputvalue name="parameterid" type="Integer" multiselect="true"/> + <inputvalue name="dateid" type="Date" multiselect="true" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + <value-names> + <value-name name="feature" value="featureid"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="dateid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + </transitions> + </artifact> + + <artifact name="verticalProfileMesh"> + <transitions> + <transition id="verticalprofile_mesh" description="verticalprofile_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh</queryID> + <dataname>meshid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_mesh_coordinate</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_mesh_coordinate" description="verticalprofile_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> + <dataname>mesh_coordinate</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_mesh_point</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_mesh_point" description="verticalprofile_mesh_point" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> + <queryID>verticalprofile_mesh_point</queryID> + <dataname>mesh_point</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_meshpoint_parameter</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_meshpoint_parameter" description="verticalprofile_meshpoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_mesh_date</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_mesh_date" description="verticalprofile_mesh_date" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh_date</queryID> + <dataname>dateid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_mesh_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalprofile_mesh_calculate_results" description="verticalprofile_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.vertical.VerticalProfileOutputTransition"> + <queryID>verticalprofile_mesh_chart_data</queryID> + <inputvalues> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="dateid" type="Date" multiselect="true" usedinquery="1"/> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="2"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="2"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + <value-names> + <value-name name="feature" value="mesh_point"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="dateid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + </transitions> + </artifact> + + <artifact name="verticalProfileInstantaneousPoint"> + <transitions> + <transition id="verticalprofile_instantaneouspoint_series" description="verticalprofile_instantaneouspoint_series" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_instantaneouspoint_series</queryID> + <dataname>seriesid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_instantaneouspoint_point</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="verticalprofile_instantaneouspoint_point" description="verticalprofile_instantaneouspoint_point" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_instantaneouspoint_point</queryID> + <dataname>instantaneouspoint_point</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_instantaneouspoint_parameter</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="seriesid" type="Integer" multiselect="false"/> + <inputvalue name="sourceid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="verticalprofile_instantaneouspoint_parameter" description="verticalprofile_instantaneouspoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_instantaneouspoint_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>verticalprofile_instantaneouspoint_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="seriesid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="instantaneouspoint_point" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="verticalprofile_instantaneouspoint_calculate_results" description="verticalprofile_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.vertical.VerticalProfileOutputTransition"> + <queryID>verticalprofile_instantaneouspoint_chart_data</queryID> + <inputvalues> + <inputvalue name="seriesid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="instantaneouspoint_point" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + <value-names> + <value-name name="feature" value="instantaneouspoint_point"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="dateid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + </transitions> + </artifact> + + <artifact name="horizontalProfileInstantaneousPoint"> + <transitions> + <transition id="horizontalprofile_instantaneouspoint_vehicle" description="horizontalprofile_instantaneouspoint_vehicle" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_instantaneouspoint_vehicle</queryID> + <dataname>vehicleid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_instantaneouspoint_cruise</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_instantaneouspoint_cruise" description="horizontalprofile_instantaneouspoint_cruise" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_instantaneouspoint_cruise</queryID> + <dataname>cruiseid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_instantaneouspoint_track</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="vehicleid" type="Integer" multiselect="false"/> + <inputvalue name="sourceid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_instantaneouspoint_track" description="horizontalprofile_instantaneouspoint_track" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_instantaneouspoint_track</queryID> + <dataname>trackid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_instantaneouspoint_surveyinfo</transition> + </reachableTransitions>Eisklimatologie + <inputvalues> + <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="1" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_instantaneouspoint_surveyinfo" description="horizontalprofile_instantaneouspoint_surveyinfo" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_instantaneouspoint_surveyinfo</queryID> + <dataname>surveyid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_instantaneouspoint_parameter</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="1" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_instantaneouspoint_parameter" description="horizontalprofile_instantaneouspoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_instantaneouspoint_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_instantaneouspoint_depth</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="surveyid" type="Integer" multiselect="false" usedinquery="1" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_instantaneouspoint_depth" description="horizontalprofile_instantaneouspoint_depth" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_instantaneouspoint_depth</queryID> + <dataname>measurementid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_instantaneouspoint_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="surveyid" type="Integer" multiselect="false" usedinquery="1" /> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="0" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_instantaneouspoint_calculate_results" description="horizontalprofile_instantaneouspoint_calculate_results" transition="de.intevation.gnv.transition.profile.horizontal.HorizontalProfileOutputTransition"> + <queryID>horizontalprofile_instantaneouspoint_chart_data</queryID> + <inputvalues> + <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="0" /> + <inputvalue name="surveyid" type="Integer" multiselect="false" usedinquery="1" /> + <inputvalue name="measurementid" type="Double" multiselect="true" usedinquery="1" /> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1" /> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + <value-names> + <value-name name="feature" value="trackid"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="measurementid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + </transitions> + </artifact> + + <artifact name="horizontalProfileMesh"> + <transitions> + <transition id="horizontalprofile_mesh" description="horizontalprofile_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh</queryID> + <dataname>meshid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_mesh_coordinate</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="horizontalprofile_mesh_coordinate" description="horizontalprofile_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> + <dataname>mesh_coordinate</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_mesh_point</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="horizontalprofile_mesh_point" description="horizontalprofile_mesh_point" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> + <queryID>verticalprofile_mesh_point</queryID> + <dataname>mesh_point</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_mesh_axis</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_mesh_axis" description="horizontalprofile_mesh_point" transition="de.intevation.gnv.transition.profile.horizontal.NorthSouthEastWestTransition"> + <dataname>axisid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_meshpoint_parameter</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="horizontalprofile_meshpoint_parameter" description="horizontalprofile_meshpoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_meshpoint_depth</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + + <transition id="horizontalprofile_meshpoint_depth" description="horizontalprofile_meshpoint_depth" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>horizontalprofile_meshpoint_depth</queryID> + <dataname>depthid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_mesh_date</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="2"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" useinquery="0"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="horizontalprofile_mesh_date" description="horizontalprofile_mesh_date" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh_date</queryID> + <dataname>dateid</dataname> + <data-multiselect>true</data-multiselect> + <reachableTransitions> + <transition>horizontalprofile_mesh_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="depthid" type="Integer" multiselect="true" usedinquery="0"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="horizontalprofile_mesh_calculate_results" description="horizontalprofile_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.horizontal.HorizontalProfileOutputTransition"> + <queryID>horizontalprofile_mesh_chart_data</queryID> + <inputvalues> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="dateid" type="Date" multiselect="true" usedinquery="1"/> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="2"/> + <inputvalue name="depthid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="2"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + <value-names> + <value-name name="feature" value="mesh_point"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="depthid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + </transitions> + </artifact> + <artifact name="verticalCrossSectionMesh"> + <transitions> + <transition id="verticalcrosssection_mesh" description="verticalcrosssection_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh</queryID> + <dataname>meshid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalcrosssection_mesh_coordinate</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalcrosssection_mesh_coordinate" description="verticalcrosssection_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> + <dataname>mesh_coordinate</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalcrosssection_mesh_point</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalcrosssection_mesh_point" description="verticalcrosssection_mesh__point" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> + <queryID>verticalprofile_mesh_point</queryID> + <dataname>mesh_point</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalcrosssection_mesh_axis</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="verticalcrosssection_mesh_axis" description="verticalcrosssection_mesh_axis" transition="de.intevation.gnv.transition.profile.horizontal.NorthSouthEastWestTransition"> + <dataname>axisid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalcrosssection_mesh_parameter</transition>v + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + <transition id="verticalcrosssection_mesh_parameter" description="verticalcrosssection_mesh_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalprofile_mesh_parameter</queryID> + <dataname>parameterid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalcrosssection_mesh_date</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + + <transition id="verticalcrosssection_mesh_date" description="verticalcrosssection_mesh_date" transition="de.intevation.gnv.transition.DefaultTransition"> + <queryID>verticalcrosssection_mesh_date</queryID> + <dataname>dateid</dataname> + <data-multiselect>false</data-multiselect> + <reachableTransitions> + <transition>verticalcrosssection_mesh_calculate_results</transition> + </reachableTransitions> + <inputvalues> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + </transition> + + <transition id="verticalcrosssection_mesh_calculate_results" description="verticalcrosssection_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.verticalcrosssection.VerticalCrossSectionOutputTransition"> + <queryID>verticalcrosssection_mesh_chart_data</queryID> + <inputvalues> + <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> + <inputvalue name="dateid" type="Date" multiselect="true" usedinquery="1"/> + <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="2"/> + <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="2"/> + <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/> + <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> + </inputvalues> + <value-names> + <value-name name="feature" value="mesh_point"></value-name> + <value-name name="parameter" value="parameterid"></value-name> + <value-name name="measurement" value="depthid"></value-name> + </value-names> + <outputsModes> + <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> + <parameters> + <inputvalue name="width" type="Integer" value="600"/> + <inputvalue name="height" type="Integer" value="400"/> + </parameters> + </outputsMode> + <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> + <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> + </outputsModes> + </transition> + + + + </transitions> + </artifact> + + + + + + </artifacts> + <ehcache> + <configuration>src/test/ressources/ehcache.xml</configuration> + </ehcache> + <geo-backend> + <backend-configuration>../geo-backend/src/test/ressources/ArcSDEConnectionPoolTestCase.properties</backend-configuration> + <query-configuration>src/test/ressources/queries.properties</query-configuration> + </geo-backend> + <rest-server> + <port>8181</port> + </rest-server> + <!-- garbage collection of outdated artifacts --> + <cleaner> + <sleep-time>300000</sleep-time> + </cleaner> + <database> + <user></user> + <password></password> + <!--url>jdbc:h2:src/test/ressources/artifacts.db</url> + <driver>org.h2.Driver</driver> + <sql></sql> --> + </database> +</artifact-database>
--- /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 @@ +<?xml version="1.0" encoding="UTF-8"?> +<ehcache> + <defaultCache maxElementsInMemory="1000" + eternal="true" + overflowToDisk="false" + memoryStoreEvictionPolicy="FIFO" + /> +</ehcache> +
--- /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
--- /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
--- /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
--- 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 @@ -<artifact-database> - <factories> - <context-factory>de.intevation.gnv.artifacts.context.GNVArtifactContextFactory</context-factory> - <artifact-factories> - <artifact-factory name="fis_marnet" description="Artiefactfactory for Instantiating the Artifact for the FIS Marnet" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_imis" description="Artiefactfactory for Instantiating the Artifact for the FIS IMIS" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_staun" description="Artiefactfactory for Instantiating the Artifact for the FIS STAUN" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_modeldata" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_eisklimatologie" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_sst" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_delphin" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_thermosalinograph" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_chemusurvey" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_gts" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_bsh_ctd" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <artifact-factory name="fis_bsh_cbt" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.artifacts.fis.FISArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - </artifact-factories> - </factories> - <artifacts> - <artifact name="fis_marnet"> - <products> - <product name= "timeSeries"> - <artifact-factory name="timeSeries" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="4"/> - <parameter name="fisname" value="fis_marnet"/> - </parameters> - </product> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfile" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="4"/> - <parameter name="fisname" value="fis_marnet"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_imis"> - <products> - <product name= "timeSeries"> - <artifact-factory name="timeSeries" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="18"/> - <parameter name="fisname" value="fis_imis"/> - </parameters> - </product> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfile" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="18"/> - <parameter name="fisname" value="fis_imis"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_staun"> - <products> - <product name= "timeSeries"> - <artifact-factory name="timeSeries" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="17"/> - <parameter name="fisname" value="fis_staun"/> - </parameters> - </product> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfile" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="17"/> - <parameter name="fisname" value="fis_staun"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_modeldata"> - <products> - <product name= "timeSeries"> - <artifact-factory name="timeSeriesMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="2"/> - <parameter name="fisname" value="fis_modeldata"/> - </parameters> - </product> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="2"/> - <parameter name="fisname" value="fis_modeldata"/> - </parameters> - </product> - <product name= "horizontalProfile"> - <artifact-factory name="horizontalProfilehorizontalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="2"/> - <parameter name="fisname" value="fis_modeldata"/> - </parameters> - </product> - <product name= "verticalcrosssection"> - <artifact-factory name="verticalCrossSectionMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.verticalcrosssection.VerticalCrossSectionMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="2"/> - <parameter name="fisname" value="fis_modeldata"/> - </parameters> - </product> - - - - - </products> - </artifact> - <artifact name="fis_eisklimatologie"> - <products> - <product name= "timeSeries"> - <artifact-factory name="timeSeriesMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="38"/> - <parameter name="fisname" value="fis_eisklimatologie"/> - </parameters> - </product> - <product name= "horizontalProfile"> - <artifact-factory name="horizontalProfilehorizontalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="38"/> - <parameter name="fisname" value="fis_eisklimatologie"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_sst"> - <products> - <product name= "timeSeries"> - <artifact-factory name="timeSeriesMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.timeseries.TimeSeriesMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="39"/> - <parameter name="sourceid" value="40"/> - <parameter name="sourceid" value="41"/> - <parameter name="sourceid" value="42"/> - <parameter name="fisname" value="fis_sst"/> - </parameters> - </product> - <product name= "horizontalProfile"> - <artifact-factory name="horizontalProfilehorizontalProfileMesh" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileMeshArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="39"/> - <parameter name="sourceid" value="40"/> - <parameter name="sourceid" value="41"/> - <parameter name="sourceid" value="42"/> - <parameter name="fisname" value="fis_sst"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_delphin"> - <products> - <product name= "horizontalProfile"> - <artifact-factory name="horizontalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="34"/> - <parameter name="fisname" value="fis_delphin"/> - </parameters> - </product> - - </products> - </artifact> - <artifact name="fis_thermosalinograph"> - <products> - <product name= "horizontalProfile"> - <artifact-factory name="horizontalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="35"/> - <parameter name="fisname" value="fis_thermosalinograph"/> - </parameters> - </product> - - </products> - </artifact> - <artifact name="fis_chemusurvey"> - <products> - <product name= "horizontalProfile"> - <artifact-factory name="horizontalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.horizontal.HorizontalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="37"/> - <parameter name="fisname" value="fis_chemusurvey"/> - </parameters> - </product> - - </products> - </artifact> - <artifact name="fis_gts"> - <products> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="5"/> - <parameter name="fisname" value="fis_gts"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_bsh_ctd"> - <products> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="32"/> - <parameter name="fisname" value="fis_bsh_ctd"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="fis_bsh_cbt"> - <products> - <product name= "verticalProfile"> - <artifact-factory name="verticalProfileInstantaneousPoint" description="Artiefactfactory for Instantiating the Artifact for the FIS Modeldata" - ttl="300000" artifact="de.intevation.gnv.profile.vertical.VerticalProfileInstantaneousPointArtifact">de.intevation.artifactdatabase.DefaultArtifactFactory</artifact-factory> - <parameters> - <parameter name="sourceid" value="36"/> - <parameter name="fisname" value="fis_bsh_cbt"/> - </parameters> - </product> - </products> - </artifact> - <artifact name="timeSeriesMesh"> - <transitions> - - <transition id="timeseries_mesh" description="timeseries_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>timeseries_mesh</queryID> - <dataname>meshid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>timeseries_mesh_coordinate</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_mesh_coordinate" description="timeseries_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> - <dataname>mesh_coordinate</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>timeseries_meshpoint</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_meshpoint" description="timeseries_meshpoint" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> - <queryID>timeseries_meshpoint</queryID> - <dataname>mesh_point</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>timeseries_meshpoint_depth</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_meshpoint_depth" description="timeseries_meshpoint_depth" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>timeseries_meshpoint_depth</queryID> - <dataname>depthid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>timeseries_meshpoint_parameter</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="2"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_meshpoint_parameter" description="timeseries_meshpoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>timeseries_mesh_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>timeseries_meshpoint_interval</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="depthid" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_meshpoint_interval" description="timeseries_interval" transition="de.intevation.gnv.transition.MinMaxTransition"> - <queryID>timeseries_mesh_interval</queryID> - <dataname>timeinterval</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>timeseries_meshpoint_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="depthid" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - </inputvalues> - </transition> - - <transition id="timeseries_meshpoint_calculate_results" description="timeseries_interval" transition="de.intevation.gnv.transition.timeseries.TimeSeriesOutputTransition"> - <queryID>timeseries_mesh_chart_data</queryID> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="depthid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - <inputvalue name="minvalue" type="Date" multiselect="false" usedinquery="1"/> - <inputvalue name="maxvalue" type="Date" multiselect="false" usedinquery="1"/> - - </inputvalues> - <value-names> - <value-name name="feature" value="mesh_point"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="depthid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - - </transitions> - </artifact> - - - <artifact name="timeSeries"> - <transitions> - <transition id="timeseries_timeseriespoint" description="timeseries_timeseriespoint" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>timeseries_timeseriespoint</queryID> - <dataname>featureid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>timeseries_parameter</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_parameter" description="timeseries_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>timeseries_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>timeseries_depth_height</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="featureid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_depth_height" description="timeseries_depth_height" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>timeseries_depth_height</queryID> - <dataname>measurementid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>timeseries_interval</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="featureid" type="Integer" multiselect="false"/> - <inputvalue name="parameterid" type="Integer" multiselect="true"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="timeseries_interval" description="timeseries_interval" transition="de.intevation.gnv.transition.MinMaxTransition"> - <queryID>timeseries_interval</queryID> - <dataname>timeinterval</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>timeseries_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - <inputvalue name="parameterid" type="Integer" multiselect="true"/> - <inputvalue name="measurementid" type="Integer" multiselect="true"/> - </inputvalues> - </transition> - - <transition id="timeseries_calculate_results" description="timeseries_interval" transition="de.intevation.gnv.transition.timeseries.TimeSeriesOutputTransition"> - <queryID>timeseries_chart_data</queryID> - <inputvalues> - <inputvalue name="parameterid" type="Integer" multiselect="true"/> - <inputvalue name="measurementid" type="Integer" multiselect="true"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - <inputvalue name="minvalue" type="Date" multiselect="false"/> - <inputvalue name="maxvalue" type="Date" multiselect="false"/> - </inputvalues> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - - </transitions> - </artifact> - - <artifact name="verticalProfile"> - <transitions> - <transition id="verticalprofile_timeseriespoint" description="timeseries_timeseriespoint" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_point</queryID> - <dataname>featureid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_parameter</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_parameter" description="timeseries_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_date</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="featureid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_date" description="verticalprofile_date" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_date</queryID> - <dataname>dateid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="featureid" type="Integer" multiselect="false"/> - <inputvalue name="parameterid" type="Integer" multiselect="true"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_calculate_results" description="verticalprofile_calculate_results" transition="de.intevation.gnv.transition.profile.vertical.VerticalProfileOutputTransition"> - <queryID>verticalprofile_chart_data</queryID> - <inputvalues> - <inputvalue name="featureid" type="Integer" multiselect="false"/> - <inputvalue name="parameterid" type="Integer" multiselect="true"/> - <inputvalue name="dateid" type="Date" multiselect="true" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - <value-names> - <value-name name="feature" value="featureid"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="dateid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - </transitions> - </artifact> - - <artifact name="verticalProfileMesh"> - <transitions> - <transition id="verticalprofile_mesh" description="verticalprofile_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh</queryID> - <dataname>meshid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_mesh_coordinate</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_mesh_coordinate" description="verticalprofile_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> - <dataname>mesh_coordinate</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_mesh_point</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_mesh_point" description="verticalprofile_mesh_point" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> - <queryID>verticalprofile_mesh_point</queryID> - <dataname>mesh_point</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_meshpoint_parameter</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_meshpoint_parameter" description="verticalprofile_meshpoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_mesh_date</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_mesh_date" description="verticalprofile_mesh_date" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh_date</queryID> - <dataname>dateid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_mesh_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalprofile_mesh_calculate_results" description="verticalprofile_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.vertical.VerticalProfileOutputTransition"> - <queryID>verticalprofile_mesh_chart_data</queryID> - <inputvalues> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="dateid" type="Date" multiselect="true" usedinquery="1"/> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="2"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="2"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - <value-names> - <value-name name="feature" value="mesh_point"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="dateid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - </transitions> - </artifact> - - <artifact name="verticalProfileInstantaneousPoint"> - <transitions> - <transition id="verticalprofile_instantaneouspoint_series" description="verticalprofile_instantaneouspoint_series" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_instantaneouspoint_series</queryID> - <dataname>seriesid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_instantaneouspoint_point</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="verticalprofile_instantaneouspoint_point" description="verticalprofile_instantaneouspoint_point" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_instantaneouspoint_point</queryID> - <dataname>instantaneouspoint_point</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_instantaneouspoint_parameter</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="seriesid" type="Integer" multiselect="false"/> - <inputvalue name="sourceid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="verticalprofile_instantaneouspoint_parameter" description="verticalprofile_instantaneouspoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_instantaneouspoint_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>verticalprofile_instantaneouspoint_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="seriesid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="instantaneouspoint_point" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="verticalprofile_instantaneouspoint_calculate_results" description="verticalprofile_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.vertical.VerticalProfileOutputTransition"> - <queryID>verticalprofile_instantaneouspoint_chart_data</queryID> - <inputvalues> - <inputvalue name="seriesid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="instantaneouspoint_point" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - <value-names> - <value-name name="feature" value="instantaneouspoint_point"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="dateid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - </transitions> - </artifact> - - <artifact name="horizontalProfileInstantaneousPoint"> - <transitions> - <transition id="horizontalprofile_instantaneouspoint_vehicle" description="horizontalprofile_instantaneouspoint_vehicle" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_instantaneouspoint_vehicle</queryID> - <dataname>vehicleid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_instantaneouspoint_cruise</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_instantaneouspoint_cruise" description="horizontalprofile_instantaneouspoint_cruise" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_instantaneouspoint_cruise</queryID> - <dataname>cruiseid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_instantaneouspoint_track</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="vehicleid" type="Integer" multiselect="false"/> - <inputvalue name="sourceid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_instantaneouspoint_track" description="horizontalprofile_instantaneouspoint_track" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_instantaneouspoint_track</queryID> - <dataname>trackid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_instantaneouspoint_surveyinfo</transition> - </reachableTransitions>Eisklimatologie - <inputvalues> - <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="1" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_instantaneouspoint_surveyinfo" description="horizontalprofile_instantaneouspoint_surveyinfo" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_instantaneouspoint_surveyinfo</queryID> - <dataname>surveyid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_instantaneouspoint_parameter</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="1" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_instantaneouspoint_parameter" description="horizontalprofile_instantaneouspoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_instantaneouspoint_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_instantaneouspoint_depth</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="surveyid" type="Integer" multiselect="false" usedinquery="1" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_instantaneouspoint_depth" description="horizontalprofile_instantaneouspoint_depth" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_instantaneouspoint_depth</queryID> - <dataname>measurementid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_instantaneouspoint_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="surveyid" type="Integer" multiselect="false" usedinquery="1" /> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="0" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_instantaneouspoint_calculate_results" description="horizontalprofile_instantaneouspoint_calculate_results" transition="de.intevation.gnv.transition.profile.horizontal.HorizontalProfileOutputTransition"> - <queryID>horizontalprofile_instantaneouspoint_chart_data</queryID> - <inputvalues> - <inputvalue name="cruiseid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="trackid" type="Integer" multiselect="false" usedinquery="0" /> - <inputvalue name="surveyid" type="Integer" multiselect="false" usedinquery="1" /> - <inputvalue name="measurementid" type="Double" multiselect="true" usedinquery="1" /> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1" /> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - <value-names> - <value-name name="feature" value="trackid"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="measurementid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - </transitions> - </artifact> - - <artifact name="horizontalProfileMesh"> - <transitions> - <transition id="horizontalprofile_mesh" description="horizontalprofile_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh</queryID> - <dataname>meshid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_mesh_coordinate</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="horizontalprofile_mesh_coordinate" description="horizontalprofile_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> - <dataname>mesh_coordinate</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_mesh_point</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="horizontalprofile_mesh_point" description="horizontalprofile_mesh_point" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> - <queryID>verticalprofile_mesh_point</queryID> - <dataname>mesh_point</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_mesh_axis</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_mesh_axis" description="horizontalprofile_mesh_point" transition="de.intevation.gnv.transition.profile.horizontal.NorthSouthEastWestTransition"> - <dataname>axisid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_meshpoint_parameter</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="horizontalprofile_meshpoint_parameter" description="horizontalprofile_meshpoint_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_meshpoint_depth</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - - <transition id="horizontalprofile_meshpoint_depth" description="horizontalprofile_meshpoint_depth" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>horizontalprofile_meshpoint_depth</queryID> - <dataname>depthid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_mesh_date</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="2"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" useinquery="0"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="horizontalprofile_mesh_date" description="horizontalprofile_mesh_date" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh_date</queryID> - <dataname>dateid</dataname> - <data-multiselect>true</data-multiselect> - <reachableTransitions> - <transition>horizontalprofile_mesh_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="depthid" type="Integer" multiselect="true" usedinquery="0"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="horizontalprofile_mesh_calculate_results" description="horizontalprofile_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.horizontal.HorizontalProfileOutputTransition"> - <queryID>horizontalprofile_mesh_chart_data</queryID> - <inputvalues> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="dateid" type="Date" multiselect="true" usedinquery="1"/> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="2"/> - <inputvalue name="depthid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="2"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - <value-names> - <value-name name="feature" value="mesh_point"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="depthid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - </transitions> - </artifact> - <artifact name="verticalCrossSectionMesh"> - <transitions> - <transition id="verticalcrosssection_mesh" description="verticalcrosssection_mesh" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh</queryID> - <dataname>meshid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalcrosssection_mesh_coordinate</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="sourceid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalcrosssection_mesh_coordinate" description="verticalcrosssection_mesh_coordinate" transition="de.intevation.gnv.transition.SingleInputTransition"> - <dataname>mesh_coordinate</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalcrosssection_mesh_point</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalcrosssection_mesh_point" description="verticalcrosssection_mesh__point" transition="de.intevation.gnv.transition.CoordinateSelectionTransition"> - <queryID>verticalprofile_mesh_point</queryID> - <dataname>mesh_point</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalcrosssection_mesh_axis</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_coordinate" type="Coordinate" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="verticalcrosssection_mesh_axis" description="verticalcrosssection_mesh_axis" transition="de.intevation.gnv.transition.profile.horizontal.NorthSouthEastWestTransition"> - <dataname>axisid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalcrosssection_mesh_parameter</transition>v - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - <transition id="verticalcrosssection_mesh_parameter" description="verticalcrosssection_mesh_parameter" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalprofile_mesh_parameter</queryID> - <dataname>parameterid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalcrosssection_mesh_date</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - - <transition id="verticalcrosssection_mesh_date" description="verticalcrosssection_mesh_date" transition="de.intevation.gnv.transition.DefaultTransition"> - <queryID>verticalcrosssection_mesh_date</queryID> - <dataname>dateid</dataname> - <data-multiselect>false</data-multiselect> - <reachableTransitions> - <transition>verticalcrosssection_mesh_calculate_results</transition> - </reachableTransitions> - <inputvalues> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - </transition> - - <transition id="verticalcrosssection_mesh_calculate_results" description="verticalcrosssection_mesh_calculate_results" transition="de.intevation.gnv.transition.profile.verticalcrosssection.VerticalCrossSectionOutputTransition"> - <queryID>verticalcrosssection_mesh_chart_data</queryID> - <inputvalues> - <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/> - <inputvalue name="dateid" type="Date" multiselect="true" usedinquery="1"/> - <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="2"/> - <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="2"/> - <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/> - <inputvalue name="fisname" type="String" multiselect="false" usedinquery="0"/> - </inputvalues> - <value-names> - <value-name name="feature" value="mesh_point"></value-name> - <value-name name="parameter" value="parameterid"></value-name> - <value-name name="measurement" value="depthid"></value-name> - </value-names> - <outputsModes> - <outputsMode name="chart" description="Chartrepresentation of the Values" mime-type="image/png"> - <parameters> - <inputvalue name="width" type="Integer" value="600"/> - <inputvalue name="height" type="Integer" value="400"/> - </parameters> - </outputsMode> - <outputsMode name="csv" description="CSV-Export der Daten" mime-type="text/plain"/> - <outputsMode name="statistics" description="Statistik zu den Daten" mime-type="text/xml"/> - </outputsModes> - </transition> - - - - </transitions> - </artifact> - - - - - - </artifacts> - <ehcache> - <configuration>src/test/ressources/ehcache.xml</configuration> - </ehcache> - <geo-backend> - <backend-configuration>../geo-backend/src/test/ressources/ArcSDEConnectionPoolTestCase.properties</backend-configuration> - <query-configuration>src/test/ressources/queries.properties</query-configuration> - </geo-backend> - <rest-server> - <port>8181</port> - </rest-server> - <!-- garbage collection of outdated artifacts --> - <cleaner> - <sleep-time>300000</sleep-time> - </cleaner> - <database> - <user></user> - <password></password> - <!--url>jdbc:h2:src/test/ressources/artifacts.db</url> - <driver>org.h2.Driver</driver> - <sql></sql> --> - </database> -</artifact-database>
--- 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 @@ -<?xml version="1.0" encoding="UTF-8"?> -<ehcache> - <defaultCache maxElementsInMemory="1000" - eternal="true" - overflowToDisk="false" - memoryStoreEvictionPolicy="FIFO" - /> -</ehcache> -
--- 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
--- 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
--- 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