[postgis-devel] [PostGIS] #1109: Lake Drive is good; Lake DR - not so good

[PostGIS]

#1109: Lake Drive is good; Lake DR - not so good
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by mikepease):

 I think the previous comment about needing to match against multiple
 possible normalizations is a very good observation.

 If it helps, here's another example where the normalizer doesn't find the
 right match.  Parsing addresses is a pain in the hind-quarters.  Thanks,
 Regina!

 209 TURNERS CROSSROAD S, GOLDEN VALLEY, MN 55416

 The actual street name is "TURNERS CROSSROAD", but the normalizer is
 parsing CROSSROAD as street type XRD.

 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('209 TURNERS CROSSROAD S, GOLDEN VALLEY, MN 55416')

 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('209 TURNERSCROSSROAD S, GOLDEN VALLEY, MN 55416')

 --this finds the right address, but it far lower ranked than the top
 (incorrect) result
 select * from normalize_address('209 TURNERS CROSSROAD S, GOLDEN VALLEY,
 MN 55416')

 --this works!
 select * from normalize_address('209 TURNERSCROSSROAD S, GOLDEN VALLEY, MN
 55416')

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