[postgis-tickets] r16441 - add Saint standarization

[Regina Obe]

Author: robe
Date: 2018-03-02 19:31:51 -0800 (Fri, 02 Mar 2018)
New Revision: 16441

Modified:
   trunk/extras/tiger_geocoder/utility/standardize_tiger_data.sql
Log:
add Saint standarization

Modified: trunk/extras/tiger_geocoder/utility/standardize_tiger_data.sql
===================================================================
--- trunk/extras/tiger_geocoder/utility/standardize_tiger_data.sql	2018-03-02 01:47:41 UTC (rev 16440)
+++ trunk/extras/tiger_geocoder/utility/standardize_tiger_data.sql	2018-03-03 03:31:51 UTC (rev 16441)
@@ -4,5 +4,10 @@
 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;
 
+-- spell out Saint
+-- fix park addresses, normalizer puts this in suftype
+UPDATE tiger.featnames SET name = replace(name,'St ', 'Saint ') where statefp IN (SELECT statefp FROM tiger.state_lookup WHERE abbrev = ANY(param_states) )
+     AND name ILIKE 'St %';
+
 $$
-language 'sql';
\ No newline at end of file
+language 'sql';