Zip 07060 is turning up “Plainfield, NJ”, but should be “North Plainfield, NJ” (which is important because it’s a different congressional district).

I see this place for updates http://trac.civicspacelabs.com/cgi-bin/trac.cgi/log/trunk/database/zipco...
But don’t see a way to update it myself.

Help?

Background:
It’s interesting, google maps gets this wrong, yahoo gets it right. I believe the local resident who informed me, and even if you look at google it seems pretty clear that this address should be North Plainfield: “184 Sandford Avenue 07060”.

CommentFileSizeAuthor
#3 zipcodes.in.mysql.gz368.13 KBchaos21in

Comments

ankur’s picture

ankur commented
Status: Active » Fixed

Fixes have been committed to HEAD, DRUPAL-4-6.

These including updating database/zipcodes.us.mysql as well as another database update. The database update merely executes and update statement to change the city to 'North Plainfield' for the row in the zipcodes table whose country is 'us' and whose zip is '07060'. You can either do this manually in the DB yourself, or you can get the update upgrade script from the CVS (location_upgrade.php) and run the update yourself. If you know how to do both, they'll probably take the same amt of time each.

-Ankur

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
chaos21in’s picture

chaos21in commented
Title: database correction (location module misfire) » zipcodes.mysql correction (location module)
Version: » 6.x-3.x-dev
Status: Closed (fixed) » Active
StatusFileSize
new zipcodes.in.mysql.gz368.13 KB

I have created a zipcodes.in.mysql file for zipcodes for india.. the file in gzip format is available at

http://www.thinkindia.co.uk/php/zip/zipcodes.in.mysql.gz

There are two problems though.

1. In india the zipcodes are set as per postoffice names and not city names. (according to http://www.indiapost.gov.in/Pincode.html) So i put the postoffice name in "city" field.

2. There are multiple Post Offices come under same zipcode.

Due to 2nd problem i cannt import this file into my database. It is giving error. So i was wondering if it is possible to make apporpritate changes in zipcodes.mysql file to accept this file.

--rafi

chaos21in’s picture

chaos21in commented

Dont download the file attached with last posting, its corrupt. Download the same from
http://www.thinkindia.co.uk/php/zip/zipcodes.in.mysql.gz

--rafi

bdragon’s picture

bdragon commented
Component: Code » Data update

Changing component to Data update.

brmassa’s picture

brmassa commented
Status: Active » Fixed

Guys,

fixed on HEAD. Soon on Location 3.

regards,

massa

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.