postcode database files for au & be have lat/lon reversed.

Here are updated versions of the database files.

I figured it would be best to just zip up the files, the patch was nearly 30mb.
2 lots due to the 1mb upload limit.

Updated all to specify the columns for the insert statement.

Here is an updated version of be from #3.
The difference is that in each INSERT statement there is now a space between VALUES and the opening bracket.

Here are updated version of all files in the same style as hutch has in #4.

Also attached is the little script I made to convert the old files to the new format.

It requires the lines of the old files to be of the form:

INSERT INTO zipcodes (zip, city, state, longitude, latitude, timezone, dst, country) VALUES ('0800', 'Darwin', 'NT', '130.842808', '-12.460698', '9', '0', 'au');

It doesn't matter what order the cols are in though or how many cols there are.
It can also handle having commas in the text strings, like some cities in the be file have.

To use the script remove the '_.txt' from the file name, then put it in your drupal root and
in your browser go to www.yoursite.com/parse_location_db.php/country=[country-code]
It will read the file
[path-to-location-module]/database/zipcodes.[country-code].mysql
and output the new file at
[path-to-location-module]/database/new_zipcodes.[country-code].mysql

The [path-to-location-module]/database directory must be writeable.
It should run in a couple of seconds for each file.
It will tell you if it was successful or if it failed and why.

Because of the required formatting it will work for the be file in #5 and all other files in #3.
The script can be easily modified for different formatting if needed.

Note: The script does assume that the last line of the file is the last insert statement.
It won't work properly if there are more line of text after that. It could be changed to work but it doesn't really need to.

Thanks for testing those.
Damn script was supposed to get those last semicolons. Oh well, it's only a quickie one off script.

Here are updated files.

Fixed are end semicolons and the reversed us lon/lats.

I noticed those other ones before, missing data in india and uk, and now I've just noticed another issue already relating to this.
#175193: Zip code database out of date
Oh well, I'll leave this one as is and look at the other issues over at the other issue.

Committed to all. Thanks for the testing.
http://drupal.org/cvs?commit=383930
http://drupal.org/cvs?commit=383928
http://drupal.org/cvs?commit=383922