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

annotate flys-aft/src/main/resources/sql/aft-common.properties @ 4837:9e25c7523485

Fixed calculation of effective width in MINFO SQ relation. * Get all (including empty datasets) from db. * Filter empty datasets when processing data of the same date. * Added debug outputs.

author	Raimund Renkert <rrenkert@intevation.de>
date	Wed, 23 Jan 2013 11:14:41 +0100
parents	d9f1202cef78
children	2b7f44c80857

rev	line source
4068 21e49e0a2307 Add infrastructure to load SQL statements for databases. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 select.gewaesser = 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	2 select.messstelle = \
4774 9dcc32fc5167 Moved check for calculation range intersection to SQL statement. Sascha L. Teichmann <teichmann@intevation.de> parents: 4754 diff changeset	3 SELECT NAME, MESSSTELLE_NR \
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	4 FROM MESSSTELLE \
4774 9dcc32fc5167 Moved check for calculation range intersection to SQL statement. Sascha L. Teichmann <teichmann@intevation.de> parents: 4754 diff changeset	5 WHERE GEWAESSER_NR = :GEWAESSER_NR AND STATIONIERUNG BETWEEN :START_KM AND :END_KM
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	6 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	7 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	8 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	9 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	10 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	11 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	12 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	13 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	14 WHERE MESSSTELLE_NR LIKE :number
4091 a91c7e982c32 Make W/Q values from AFT and FLYS loadable. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4090 diff changeset	15 select.tafelwert = SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \
a91c7e982c32 Make W/Q values from AFT and FLYS loadable. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4090 diff changeset	16 WHERE ABFLUSSTAFEL_NR = :number
4068 21e49e0a2307 Add infrastructure to load SQL statements for databases. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17

http://dive4elements.wald.intevation.org