[postgis-devel] [PostGIS] #1110: Saint Paul vs. St. Paul

[PostGIS]

#1110: Saint Paul vs. St. Paul
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Is there a way that the normalizer could look for alternate spellings of
 cities?  For instance, several major cities in Minnesota are "Saint"
 something.  St. Paul, St. Cloud, etc.
 The official spelling in the database is St. Paul, but addresses often
 spell out the full word "Saint Paul".

 --works great![[BR]]

 select * from geocode('101 7th St, St. Paul, MN')

 --takes 2 minutes and fails to find the location[[BR]]
 select * from geocode('101 7th St, Saint Paul, MN')

 --works fine if the zip code is included[[BR]]
 select * from geocode('101 7th St, Saint Paul, MN 55102')

 I'm not sure if there are other words like "Saint" that have alternate
 legitimate spellings for a city name.  Can you think of any?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1110>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.