5 incorrect city names
Brought to you by:
jpyeron,
superjared
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.
Patch to fix zip_codes.sql file
Fixes your SQL DB if you have these incorrect entries
Logged In: YES
user_id=27197
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.
Logged In: NO
Maybe it was 3000 errors and 10000 omissions. It's been a while.