County Roads and Highways

[mikepease]

County Roads and Highways that are referred to by number seem to confuse the geocoder.

—This well-formed county road address doesn't geocode to the correct location
select (addy).*,* from geocode('16725 Co Rd 24, Plymouth, MN 55447')

—Spelled out in long form also gets an incorrect location
select (addy).*,* from geocode('16725 County Road 24, Plymouth, MN 55447')

—But it works when you put in just the number of the road without saying county road
select (addy).*,* from geocode('16725 24, Plymouth, MN 55447')

—Also works when referring to the same road by name

select (addy).*,* from geocode('16725 Rockford Road, Plymouth, MN 55447')

—Similar example for County Highway (doesn't work)
select (addy).*,* from geocode('13800 County Hwy 9, Andover, MN 55304')

—Works with just the number of the hwy
select (addy).*,* from geocode('13800 9, Andover, MN 55304')

[robe]

Mike,

This one we are actually working on but a bit tricky. Most of our interest for the main project we are currently working on is mostly these road like addresses. But thanks for submitting. Was planning to do that myself. Also much appreciated for itemizing these issues.

[mikepease]

Thanks for working so quickly on these issues! I hope to start using this geocoder for my project work when the bugs are pretty well worked out.

You may already know this, but I found this error also applies to State and US Highways. Probably also Interstates, but I didn't find an example of that yet.

—US Highway doesn't work select (addy).*,* from geocode('3859 Highway 61 W, Red Wing, MN 55066') —works with just number select (addy).*,* from geocode('3859 Highway 61 W, Red Wing, MN 55066')

—state hiway doesn't work select (addy).*,* from geocode('2901 Highway 13 W, Burnsville, MN 55337') —works with just number select (addy).*,* from geocode('2901 13, Burnsville, MN 55337')

[mikepease]

One more little note;

This issue also seems to apply to county roads named by a letter too. Example:

1940 County Road C W, Roseville, MN 55113

[robe]

Partial fix at r7567.

Mike I think in working thru rating piece, I might have broken the

select (addy).*,* from geocode('16725 Rockford Road, Plymouth, MN 55447');

I just get back the road, location , state, zip, but it's missing the street number.

Also need to work out the:

1940 County Road C W, Roseville, MN 55113

case as I was assuming all these kinds of roads would have numbers for names.

[robe]

More revisions at r7586. Can parse out alphanumeric roads now, but doesn't handle direction just yet.

[robe]

okay now can handle post at r7588 so:

1940 County Road C W, Roseville, MN 55113

Normalizes right to:

1940||C|Co Rd|W||Roseville|MN|55113

Regarding other issue with not getting 16725. I think its my data since I don't see that in my ranges and when I pick something I see it geocodes right.

I'll leave this open till Mike confirms.

[mikepease]

Great. This appears to be handling alphanumeric roads and highways much better now.

One thing I noticed is there's a difference between the normalized address from normalize_address() and geocode().

select (addy).*,* from geocode('1940 County Road C W, Roseville, MN 55113')

Addy returns as: "(1940_CW_{Roseville,MN,55113,t)" Doesn't indicate "County Road"}

select normalize_address('1940 County Road C W, Roseville, MN 55113') returns a more complete description that includes the county road: "(1940_{C,"Co Rd",W}Roseville,MN,55113,t)"

[mikepease]

4533 PARK AVE S, MINNEAPOLIS, MN 55407 doesn't work, but the alternate equivalent address using county road does work. 4533 County Road 33, MINNEAPOLIS, MN 55407

Perhaps this is a regression issue with your recent normalizer changes?

—incorrectly matches to a different street in Fridley, MN

select abs(ST_X(geomout)::numeric(8,5))

'W, '

ST_Y(geomout)::numeric(8,5)

'N' as lat_lon, *

from geocode('4533 PARK AVE S, MINNEAPOLIS, MN 55407')

—use the alternate county road name and it works

select abs(ST_X(geomout)::numeric(8,5))

'W, '

ST_Y(geomout)::numeric(8,5)

'N' as lat_lon, *

from geocode('4533 County Road 33, MINNEAPOLIS, MN 55407')

[robe]

Yah this is the same bug as the LAKE one.

[robe]

I'm closing this one out since this is done expcet for the interstate issue which is already a separate ticktet.