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

PostGIS trac at osgeo.org
Thu Jul 7 09:02:36 PDT 2011


#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):

 Hopefully this is more helpful than annoying.
 Here's 3 more example cases of this issue:

 1701 Main Street, Hopkins, MN 55343   -> (works with Mainstreet)

 1421 ENERGY PARK DR, ST. PAUL, MN 55108   -> (works with ENERGYPARK DR)

 4343 MEADOW BROOK BLVD, ST. LOUIS PARK, MN 55416  -> (works with
 MEADOWBROOK BLVD)


 --works
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('1701 MainStreet, Hopkins, MN 55343')

 --doesn't work
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('1701 Main Street, Hopkins, MN 55343')

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


More information about the postgis-devel mailing list