dive4elements/river: flys-aft/src/main/resources/sql/aft-common.properties annotate

annotate flys-aft/src/main/resources/sql/aft-common.properties @ 5214:b46df0609276

add lookup tables for floodplain and cross section tracks

author	Tom Gottfried <tom@intevation.de>
date	Mon, 11 Mar 2013 11:43:44 +0100
parents	2b7f44c80857
children	da1e897c7224

rev	line source
5188 2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	1 select.gewaesser = \
2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	2 SELECT GEWAESSER_NR, NAME FROM SL_GEWAESSER
4754 04377ccef10a AFT: Reject AFT gauges which are not inside the calculation range of the corresponding FLYS river. Sascha L. Teichmann <teichmann@intevation.de> parents: 4091 diff changeset	3 select.messstelle = \
5188 2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	4 SELECT NAME, MESSSTELLE_NR, STATIONIERUNG \
4754 04377ccef10a AFT: Reject AFT gauges which are not inside the calculation range of the corresponding FLYS river. Sascha L. Teichmann <teichmann@intevation.de> parents: 4091 diff changeset	5 FROM MESSSTELLE \
5188 2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	6 WHERE GEWAESSER_NR = :GEWAESSER_NR
4775 d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	7 select.abflusstafel = \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	8 SELECT ABFLUSSTAFEL_NR, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	9 ABFLUSSTAFEL_BEZ, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	10 strftime('%s', GUELTIG_VON) * 1000 AS GUELTIG_VON, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	11 strftime('%s', GUELTIG_BIS) * 1000 AS GUELTIG_BIS, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	12 PEGELNULLPUNKT, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	13 BFG_ID \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	14 FROM ABFLUSSTAFEL \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in Sascha L. Teichmann <teichmann@intevation.de> parents: 4774 diff changeset	15 WHERE MESSSTELLE_NR LIKE :number
5188 2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	16 select.tafelwert = \
2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	17 SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \
2b7f44c80857 Stations are now filtered by DiPS not AFT. Sascha L. Teichmann <teichmann@intevation.de> parents: 4775 diff changeset	18 WHERE ABFLUSSTAFEL_NR = :number
4068 21e49e0a2307 Add infrastructure to load SQL statements for databases. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19

http://dive4elements.wald.intevation.org