From c01ddfa157dfed73ab82400a87b7102f1f9f92c2 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sun, 6 Sep 2015 00:11:04 +0000 Subject: [PATCH] This is to fix tiger data that causes geocoding issues. This is not yet integrated into load or documented since requires more testing. Not even installed yet as part of tiger extension git-svn-id: http://svn.osgeo.org/postgis/trunk@14048 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/utility/standardize_tiger_data.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 extras/tiger_geocoder/utility/standardize_tiger_data.sql diff --git a/extras/tiger_geocoder/utility/standardize_tiger_data.sql b/extras/tiger_geocoder/utility/standardize_tiger_data.sql new file mode 100644 index 000000000..67cf946f6 --- /dev/null +++ b/extras/tiger_geocoder/utility/standardize_tiger_data.sql @@ -0,0 +1,8 @@ +CREATE OR REPLACE FUNCTION tiger.standardize_tiger_data(param_states varchar[]) RETURNS void AS +$$ +-- fix park addresses, normalizer puts this in suftype +UPDATE tiger.featnames SET name = replace(name,' Park', ''), suftypabrv = 'Park' where statefp IN (SELECT statefp FROM tiger.state_lookup WHERE abbrev = ANY(param_states) ) + AND name ILIKE '% Park' AND suftypabrv is null; + +$$ +language 'sql'; \ No newline at end of file -- 2.50.1