#2 5 incorrect city names

Bill Kocik

I have discovered 5 zip codes for which the city names
are incorrect (though I imagine there are more).

94401 should be San Mateo, not Russian River
95462 should be Monte Rio, not Russian River Md
43160 should be Washington Court House, not Washington
84762 should be Duck Creek Village, not Duck Creek
Village Cpu
26351 should be Glenville, not Baldwin (USPS says
Baldwin is acceptable, as is Gilmer, but Glenville is
the actual name)

I'm attaching a patch to fix the zip_codes.sql file.


  • Bill Kocik

    Bill Kocik - 2006-09-02

    Patch to fix zip_codes.sql file

  • Bill Kocik

    Bill Kocik - 2006-09-02

    Fixes your SQL DB if you have these incorrect entries

  • David Finch

    David Finch - 2008-02-04

    Logged In: YES
    Originator: NO

    The number of incorrect city names is closer to 10000, nearly all giving street names instead of the city name, plus a handful of truncations. And there are about 3000 omissions.

    I found the errors by comparing this database to http://databases.about.com/od/access/a/zipcodedatabase.htm, which is free but unfortunately isn't public domain.

  • Nobody/Anonymous

    Logged In: NO

    Maybe it was 3000 errors and 10000 omissions. It's been a while.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks