From 10fbda702b539d3d931435e1cff82fc156a7e103 Mon Sep 17 00:00:00 2001 From: marc tobias Date: Sat, 25 May 2019 20:43:38 +0200 Subject: [PATCH] exclude postcode ranges separated by colon from centre point calculation --- sql/update-postcodes.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/update-postcodes.sql b/sql/update-postcodes.sql index 1cbc8858..d59df15b 100644 --- a/sql/update-postcodes.sql +++ b/sql/update-postcodes.sql @@ -6,7 +6,7 @@ SELECT country_code, ST_Centroid(ST_Collect(ST_Centroid(geometry))) as centroid FROM placex WHERE address ? 'postcode' - AND address->'postcode' NOT SIMILAR TO '%(,|;)%' + AND address->'postcode' NOT SIMILAR TO '%(,|;|:)%' AND geometry IS NOT null GROUP BY country_code, pc; -- 2.43.2