Mercurial > dive4elements > river
diff flys-aft/src/main/resources/sql/aft-common.properties @ 4754:04377ccef10a
AFT: Reject AFT gauges which are not inside the calculation range of the corresponding FLYS river.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Thu, 03 Jan 2013 14:39:48 +0100 |
| parents | a91c7e982c32 |
| children | 9dcc32fc5167 |
line wrap: on
line diff
--- a/flys-aft/src/main/resources/sql/aft-common.properties Thu Jan 03 14:19:45 2013 +0100 +++ b/flys-aft/src/main/resources/sql/aft-common.properties Thu Jan 03 14:39:48 2013 +0100 @@ -1,5 +1,8 @@ select.gewaesser = SELECT GEWAESSER_NR, NAME FROM SL_GEWAESSER -select.messstelle = SELECT NAME, MESSSTELLE_NR FROM MESSSTELLE WHERE GEWAESSER_NR = :GEWAESSER_NR +select.messstelle = \ + SELECT NAME, MESSSTELLE_NR, STATIONIERUNG \ + FROM MESSSTELLE \ + WHERE GEWAESSER_NR = :GEWAESSER_NR select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \ ABFLUSSTAFEL_BEZ, \ strftime('%s', GUELTIG_VON) * 1000 AS GUELTIG_VON, \