Mercurial > dive4elements > river
view etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 6837:9da2298ae380
(issue1353) Add river name to query for discharge Info
The previous assumption was that the official number is unique
for a gauge. This assumption is broken by having multiple variants
of a river in the database, like Donau (schleusenkanäle)
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 15 Aug 2013 15:57:13 +0200 |
parents | 5aa05a7a34b7 |
children |
line wrap: on
line source
select.abflusstafel = \ SELECT ABFLUSSTAFEL_NR, \ ABFLUSSTAFEL_BEZ, \ GUELTIG_VON, \ GUELTIG_BIS, \ PEGELNULLPUNKT, \ AT.BFG_ID \ FROM ABFLUSSTAFEL AT \ WHERE MESSSTELLE_NR LIKE :number