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