Mercurial > gemma

diff pkg/imports/fm_bcnlat.go @ 4909:6f244b5eb716 fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use table inheritance to define common fairway marks attributes
author Tom Gottfried <tom@intevation.de>
date Mon, 10 Feb 2020 14:56:43 +0100
parents 52c31d3b5131
children bcb8b69e4358
line wrap: on
line diff
--- a/pkg/imports/fm_bcnlat.go	Fri Feb 07 19:42:09 2020 +0100
+++ b/pkg/imports/fm_bcnlat.go	Mon Feb 10 14:56:43 2020 +0100
@@ -51,7 +51,7 @@
 
 func (bcnlatJobCreator) Depends() [2][]string {
 	return [2][]string{
-		{"fairway_marks"},
+		{"fairway_marks_bcnlat"},
 		{},
 	}
 }
@@ -85,7 +85,7 @@
 with a as (
   select users.current_user_area_utm() AS a
 )
-INSERT INTO waterway.fairway_marks (
+INSERT INTO waterway.fairway_marks_bcnlat (
   geom,
   datsta,
   datend,
@@ -114,10 +114,11 @@
     OR ST_Intersects((select a from a),
       ST_Transform(newfm, (select ST_SRID(a) from a)))
 ON CONFLICT (
-    CAST((0, geom,
+  CAST((geom,
       datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
-      scamin, picrep, txtdsc, sordat, sorind, colour, colpat, condtn,
-      bcnshp, catlam, dirimp) AS waterway.fairway_marks)
+      scamin, picrep, txtdsc, sordat, sorind,
+      0, colour, colpat, condtn, bcnshp, catlam, dirimp
+    ) AS waterway.fairway_marks_bcnlat)
   )
   DO NOTHING
 RETURNING id