Mercurial > gemma

changeset 2811:3b1bdbbc0225

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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