[postgis-devel] [PostGIS] #1112: Interstate 35W Service Road

[PostGIS]

#1112: Interstate 35W Service Road
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Depending on how this address is written, it either is fast and accurate,
 or slow and wrong.

 --Original address:
 --8401 W 35W Service Dr NE, Blaine, MN 55449

 --full address on Interstate service road geocodes to completely wrong
 place[[BR]]

 select *
 from geocode('8401 W 35W Service Dr NE, Blaine, MN 55449')

 --This works great!
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon,
 *
 from geocode('8401 35W, Blaine, MN 55449')

 --This works great!
 select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
 ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
 from geocode('8401 35W West, Blaine, MN 55449')

 --This takes 2.5 minutes to run and gets the wrong answer[[BR]]

 select *
 from geocode('8401 West 35W, Blaine, MN 55449')

 --This takes 2.5 minutes to run and gets the wrong answer[[BR]]

 select *
 from geocode('8401 W 35W, Blaine, MN 55449')

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