Mercurial > gemma

changeset 1024:96ea805d44b9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
back end: Added new field "type" to search results.
author Sascha Wilde <wilde@intevation.de>
date Wed, 24 Oct 2018 12:29:25 +0200
parents 337a7f4c8a16
children a55f20dc8d8d
files pkg/controllers/search.go
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/search.go	Wed Oct 24 12:24:26 2018 +0200
+++ b/pkg/controllers/search.go	Wed Oct 24 12:29:25 2018 +0200
@@ -26,12 +26,13 @@
 const (
 	searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]')
 FROM (SELECT (location_code).hectometre || ' rhm' AS name,
-             ST_AsGeoJSON(geom)::json AS geom
+             ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type
       FROM waterway.distance_marks_virtual
       WHERE (location_code).hectometre = $1) r`
 	searchBottleneckSQL = `SELECT COALESCE(json_agg(r),'[]')
 FROM (SELECT objnam AS name,
-             ST_AsGeoJSON(ST_Centroid(area))::json AS geom
+             ST_AsGeoJSON(ST_Centroid(area))::json AS geom,
+             'bottleneck' AS type
       FROM waterway.bottlenecks
       WHERE objnam ILIKE $1) r`
 )