]> git.openstreetmap.org Git - nominatim.git/commitdiff
exclude postcode ranges separated by colon from centre point calculation
authormarc tobias <mtmail@gmx.net>
Sat, 25 May 2019 18:43:38 +0000 (20:43 +0200)
committermarc tobias <mtmail@gmx.net>
Sat, 25 May 2019 18:43:38 +0000 (20:43 +0200)
sql/update-postcodes.sql

index 1cbc88588aa0cf04ce486cff28ac7387ebf0604b..d59df15b67565cc4061aabba4a34d925f6e8111a 100644 (file)
@@ -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;