Mercurial > gemma
changeset 2811:3b1bdbbc0225
added responsible_country to bottleneck_overview
author | Markus Kottlaender <markus@intevation.de> |
---|---|
date | Tue, 26 Mar 2019 13:02:12 +0100 |
parents | 97cf32cf2562 |
children | 30a753f51a3c |
files | schema/gemma.sql |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Tue Mar 26 12:59:29 2019 +0100 +++ b/schema/gemma.sql Tue Mar 26 13:02:12 2019 +0100 @@ -641,7 +641,8 @@ ST_Centroid(area)::Geometry(POINT, 4326) AS point, (lower(stretch)).hectometre AS from, (upper(stretch)).hectometre AS to, - sr.current::text + sr.current::text, + responsible_country FROM bottlenecks bn LEFT JOIN ( SELECT bottleneck_id, max(date_info) AS current FROM sounding_results GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.id