Hi folks,

here it is a database import file for Austria zipcodes. It would be nice, if it would be delivered with upcoming module versions.

cu

Comments

yesct’s picture

Component: Miscellaneous » Data update
yesct’s picture

Version: 6.x-3.0 » 6.x-3.x-dev

This file contains lines like:

INSERT INTO `zipcodes` VALUES('1010', 'Wien', 'WIE', '46.766700', '14.766700', 1, 1, 'at');
INSERT INTO `zipcodes` VALUES('1020', 'Wien', 'WIE', '46.644200', '13.892200', 1, 1, 'at');
INSERT INTO `zipcodes` VALUES('1030', 'Wien', 'WIE', '46.766700', '14.866700', 1, 1, 'at');
INSERT INTO `zipcodes` VALUES('1040', 'Wien', 'WIE', '46.792800', '14.813100', 1, 1, 'at');
INSERT INTO `zipcodes` VALUES('1050', 'Wien', 'WIE', '46.644200', '13.892200', 1, 1, 'at');

What kind of format does it have to be to be easy to commit as part of an upcoming dev release? A new file? like:
#73714: Support for the Netherlands (NL) location.nl.inc location.xx.inc, a location.cc.inc file?
or a patch (http://drupal.org/patch/create)?

I'm fairly certain, anything would have to be against the current dev release.

joergm’s picture

Hi folks,

the associated longitude/lattitude information to zipcode for vienna austria in zipcode.at_.mysql_.gz are definitly wrong:

correct is:
1010 Wien 48.2 16.3667

wrong is:
1010 Wien 46.766700 14.766700 as contained in zipcode.at_.mysql_.gz

Is there any update available?

Thx Joerg

hutch’s picture

Status: Active » Needs work

I can confirm that the lat/lon for postcode 110 is completely wrong and so are most if not all of the others, the Austria entries for the zipcodes table as provided at the start of this thread need to be redone.
Contributions welcome!

herkimer’s picture

StatusFileSize
new31.75 KB

Hello,

I am probably a bit late to the party on this....but I also verified that the file posted above had incorrect latitude and longitude data.

I was unable to locate a SQL file with the correct data, so I built one. My apologies if this is redundant work, or if there is a better source.

legolasbo’s picture

Issue summary: View changes
Status: Needs work » Closed (outdated)

Closing old D6 issues as D6 is end of life