diff pkg/imports/dmv.go @ 3778:1b11ff97c1d1

Add wwname to import of virtual distance marks.
author Sascha Wilde <wilde@intevation.de>
date Thu, 04 Jul 2019 16:30:19 +0200
parents a5448426e4e2
children 8b75ac5e243e
line wrap: on
line diff
--- a/pkg/imports/dmv.go	Thu Jul 04 16:16:44 2019 +0200
+++ b/pkg/imports/dmv.go	Thu Jul 04 16:30:19 2019 +0200
@@ -66,15 +66,18 @@
 INSERT INTO waterway.distance_marks_virtual (
   location_code,
   geom,
-  related_enc
+  related_enc,
+  wwname
 )
 VALUES (
   ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int),
   ST_SetSRID(ST_MakePoint($6, $7), 4326)::geography,
-  $8
+  $8,
+  $9
 ) ON CONFLICT (location_code) DO UPDATE SET
   geom = ST_SetSRID(ST_MakePoint($6, $7), 4326)::geography,
-  related_enc = $8
+  related_enc = $8,
+  wwname = $9
 `
 )
 
@@ -140,6 +143,12 @@
 				continue
 			}
 
+			if dr.Wwname.Loc == nil {
+				feedback.Warn("missing wwname: %s", code)
+				ignored++
+				continue
+			}
+
 			if _, err := insertStmt.ExecContext(
 				ctx,
 				code.CountryCode,
@@ -149,6 +158,7 @@
 				code.Hectometre,
 				float64(*dr.Lon), float64(*dr.Lat),
 				string(*dr.Relenc),
+				string(*dr.Wwname.Loc),
 			); err != nil {
 				return nil, err
 			}