Mercurial > dive4elements > river
diff etl/src/main/resources/sql/flys-common.properties @ 6893:60f39ee19473
ETL: Potential fix for flys/1453.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 21 Aug 2013 16:13:36 +0200 |
| parents | 3bb6c2a3ef72 |
| children | 389bf6b7d371 |
line wrap: on
line diff
--- a/etl/src/main/resources/sql/flys-common.properties Wed Aug 21 15:46:39 2013 +0200 +++ b/etl/src/main/resources/sql/flys-common.properties Wed Aug 21 16:13:36 2013 +0200 @@ -7,7 +7,7 @@ WHERE w.kind = 0 \ GROUP BY r.id, r.name select.gauges = \ - SELECT id, name, official_number \ + SELECT id, name, official_number, station \ FROM gauges \ WHERE river_id = :river_id next.gauge.id = \