The Zip Code Database Project

Tracker: Bugs

5 5 incorrect city names - ID: 1550979

Last Update: Comment added ( nobody )

Details:

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
Court
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.

Submitted:

Bill Kocik ( bkocik ) - 2006-09-02 11:07

Priority:

Status:

Open

Resolution:

None

Assigned:

Nobody/Anonymous

Category:

None

Group:

None

Visibility:

Public

Comments ( 2 )

Date: 2008-02-04 17:14 Sender: nobody Logged In: NO Maybe it was 3000 errors and 10000 omissions. It's been a while.
Date: 2008-02-04 16:53 Sender: dtfinch 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.

Log in to comment.

Attached Files ( 2 )

Filename	Description	Download
zip_codes_patch.txt	Patch to fix zip_codes.sql file	Download
zip_code_fixes.sql	Fixes your SQL DB if you have these incorrect entries	Download

Changes ( 2 )

Field	Old Value	Date	By
File Added	191703: zip_code_fixes.sql	2006-09-02 11:10	bkocik
File Added	191702: zip_codes_patch.txt	2006-09-02 11:08	bkocik

The Zip Code Database Project

Tracker: Bugs

Comments ( 2 )

Log in to comment.

Attached Files ( 2 )

Changes ( 2 )

About SourceForge

Find Software

Develop Software

Community

Help