[postgis-devel] [PostGIS] #1074: Matching on different street spelling?

[PostGIS]

#1074: Matching on different street spelling?
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by mikepease):

 The latest version is working better, but it can still get stumped.
 Here's my results:

 Works well now:[[BR]]
 4373 LAKE DR, ROBBINSDALE, MN 55422
 8525 COTTAGE WOOD TERR, Blaine, MN 55434
 3420 RHODE ISLAND AVE S, ST. LOUIS PARK, MN 55426
 1421 ENERGY PARK DR, ST. PAUL, MN 55108
 4343 MEADOW BROOK BLVD, ST. LOUIS PARK, MN 55416


 Still not getting the correct location:[[BR]]
 1701 Main Street, Hopkins, MN 55343

 --Mainstreet works, that's the actual street name but "Street" is getting
 pulled into street type and then no match is found for just "Main" in
 Hopkins.  I think this is a different case.

 This case is when a street name has a keyword for a street type in it.
 When that keyword is pulled out of the street name, no match is found.

 Your full text search idea might fix this.  Or could a partial match work,
 like

 street_name ilike 'Main%'

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1074#comment:9>
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.