Normalizing irregular zipcodes

[mikepease]

Hi, Regina. Thanks for all the great improvements with the geocoder. I found another issue that popped up in my testing.

Some of the addresses in my database have incorrectly written zipcodes. Either they are not complete (<5 chars), have a dash hanging on the end (55401-), or there was a fumble fingers that added an extra digit in there somewhere (553404)

Whenever the zip is not properly formed, no geocode is returned.

—works with 5 digit zip
select * from geocode('212 3rd Ave N, MINNEAPOLIS, MN 55401')

—breaks with partial 3 digit zip
select * from geocode('212 3rd Ave N, MINNEAPOLIS, MN 554')

—breaks with extra dash
select * from geocode('212 3rd Ave N, MINNEAPOLIS, MN 55401-')

[robe]

fixed at r7517