diff pkg/controllers/shapestretches.go @ 4389:5e38667f740c stretches-for-responsibility

Use stretches as areas of responsibility. This is heavily based on a patch by Tom Gottfried (read: >90% of the work was done by Tom).
author Sascha Wilde <wilde@intevation.de>
date Thu, 12 Sep 2019 18:13:47 +0200
parents 78be85723eff
children 5f47eeea988d
line wrap: on
line diff
--- a/pkg/controllers/shapestretches.go	Wed Sep 11 10:32:19 2019 +0200
+++ b/pkg/controllers/shapestretches.go	Thu Sep 12 18:13:47 2019 +0200
@@ -45,14 +45,14 @@
   nobjnam,
   date_info,
   source_organization
-FROM waterway.stretches WHERE
+FROM users.stretches WHERE
   staging_done AND
   name = $1`
 
 	selectStretchCountriesSQL = `
-SELECT country_code FROM waterway.stretch_countries
-WHERE stretches_id = $1
-ORDER BY country_code`
+SELECT country FROM users.stretch_countries
+WHERE stretch_id = $1
+ORDER BY country`
 )
 
 func flattenPoints(mp wkb.MultiPolygonGeom) []shp.Point {