changeset 1917:2fda3f17e47c

Distance marks virtual imports: Swapped Lat/Lon.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Jan 2019 18:34:03 +0100
parents 8750f50b6cee
children 62b5f6e48e82
files pkg/imports/dmv.go
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/dmv.go	Fri Jan 18 18:20:34 2019 +0100
+++ b/pkg/imports/dmv.go	Fri Jan 18 18:34:03 2019 +0100
@@ -85,10 +85,10 @@
 )
 VALUES (
   ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int),
-  ST_SetSRID(ST_MakePoint($6, $7), 4326)::geography,
+  ST_SetSRID(ST_MakePoint($7, $6), 4326)::geography,
   $8
 ) ON CONFLICT (location_code) DO UPDATE SET
-  geom = ST_SetSRID(ST_MakePoint($6, $7), 4326)::geography,
+  geom = ST_SetSRID(ST_MakePoint($7, $6), 4326)::geography,
   related_enc = $8
 `
 )