Mercurial > gemma

changeset 3740:6f1d5f310e08

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Search delivers now bbox (geometry) for sections and bottlenecks.
author Sascha Wilde <wilde@intevation.de>
date Mon, 24 Jun 2019 12:43:30 +0200
parents e1bd5391a4b8
children 71de5ce5a402
files schema/search_functions.sql
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/search_functions.sql	Mon Jun 24 11:58:08 2019 +0200
+++ b/schema/search_functions.sql	Mon Jun 24 12:43:30 2019 +0200
@@ -49,7 +49,7 @@
   SELECT COALESCE(json_agg(r),'[]')
     INTO _result
     FROM (SELECT objnam AS name,
-                 ST_AsGeoJSON(ST_Centroid(area))::json AS geom,
+                 ST_AsGeoJSON(ST_Envelope(area::geometry))::json AS geom,
                  'bottleneck' AS type
             FROM waterway.bottlenecks
             WHERE objnam ILIKE '%' || search_string || '%'
@@ -120,7 +120,7 @@
   SELECT COALESCE(json_agg(r),'[]')
     INTO _result
     FROM (SELECT objnam AS name,
-                 ST_AsGeoJSON(ST_Centroid(area))::json AS geom,
+                 ST_AsGeoJSON(ST_Envelope(area::geometry))::json AS geom,
                  'section' AS type
             FROM waterway.sections
             WHERE objnam ILIKE '%' || search_string || '%'