Interstate 35W Service Road

[mikepease]

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

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

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

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

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

[robe]

fixed at r7632