Ticket #1110 (new defect)
Saint Paul vs. St. Paul
|Reported by:||mikepease||Owned by:||robe|
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".
select * from geocode('101 7th St, St. Paul, MN')
--takes 2 minutes and fails to find the location
select * from geocode('101 7th St, Saint Paul, MN')
--works fine if the zip code is included
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?