Greetings,

We are about to create a database of cities in Ukraine and I decided to provide you with it when it is finished. I wonder , were did you get information about zip codes as well as longitude and latitude?

I would also like to know are there any other databases for countries except for US and DE already developed?

Thanks.

CommentFileSizeAuthor
#6 ZIP CODES UKRAINE.tgz218.35 KBwebdevbyjoss

Comments

bdragon’s picture

bdragon commented
Component: Miscellaneous » Data update

(Changing component to Data update.)

Hi.

I just took over development of Location, and am working on getting it back into shape.

I'm thinking it would be best to maintain the zip code databases outside of CVS. I will probabaly set up some infrastructure to maintain them (with transaction history) so they can get small fixes applied more efficiently.

Another thing I'm looking into is the possibility of having an optional utility built in to periodically fetch updates.

ardas’s picture

ardas commented

The main issue in zipcodes table structure at my opinion is it is not normalized and cities are not a separate entity with its own code. For example:

INSERT INTO zipcodes VALUES ('00544','Holtsville','NY','40.922326','-72.637078',-5,1,'us');
INSERT INTO zipcodes VALUES ('00601','Adjuntas','PR','18.180103','-66.749470',-4,0,'us');
INSERT INTO zipcodes VALUES ('00602','Aguada','PR','18.363285','-67.180240',-4,0,'us');

Ideally, cities Holtsville, Adjuntas, Aguada must be stored in a separate table and have their own PK - a code which will identify them within a state. May be even a unique code which will include state code, so that every city has a unique code and will not duplicate with any other city.

Zipcodes table will have a FK column with city code.

This will help to build a flexible system where user can choose country and state from drop down list and than choose city from drop down list as well. These comboboxes can be turned into AJAX activeselects very simply. I saw many requests of this functionality in Drupal but there is no graceful solution for this problem today.

What do you think?

yesct’s picture

yesct commented
Status: Active » Postponed (maintainer needs more info)

I this update still needed? The last comment was over a year ago. If someone could evaluate the status for the Ukraine and please post back, that would be great.

I added this to the list of data updates at #175193: Zip code database out of date

webdevbyjoss’s picture

webdevbyjoss commented

I'm ready to contribute to this project. What is the progress for this?

yesct’s picture

yesct commented

webdevbyjoss, I'm sorry no one has answered you, maybe try contacting ardas, to see what the progress on that end is?

webdevbyjoss’s picture

webdevbyjoss commented
StatusFileSize
new ZIP CODES UKRAINE.tgz218.35 KB

I have found the TAB-separated file of Ukrainian cities/towns/villages and zip codes from Magento ukrainian community. Possibly we can incorporate that data into Drupal as well.

yesct’s picture

yesct commented
Status: Postponed (maintainer needs more info) » Needs work

someone please make a patch for the latest dev version. maybe then it will be any easy commit?

ankur’s picture

ankur commented

The file submitted here needs to be converted into a format matching that of the other zipcode files. Also, we'll need some kind of verification that this data is OK for us to use.

legolasbo’s picture

legolasbo
he/him
Primary language Dutch
Location Middelburg
commented
Issue summary: View changes
Status: Needs work » Closed (outdated)

Closing old D6 issues as D6 is end of life