Thread: postcodes csv format for every country here

hi guys i found the link below where you can download all different countrys postcodes in csv format here the link

http://www.eventme.com/pc/PostalCodeHelp.aspx

admin sorry if your not allowed to post links i didnt know

also has any one got list of uk counties please

hi,

have everywher the postcode completed for german?

the csf file from http://www.eventme.com/pc/PostalCodeHelp.aspx

this i have downloaded but how can i integrated in mysql?

Originally Posted by Jack Kubel

hi,

have everywher the postcode completed for german?

the csf file from http://www.eventme.com/pc/PostalCodeHelp.aspx

this i have downloaded but how can i integrated in mysql?

Upload the file here so we can take a look at it.

Smoge

hi,

here is the file.

best regards

most of these files donot have a lattitude or longitude coordinates.
So wondering how would one use this data to do a radius search.

I looked at this, and saw some problems with this:

PLZ,City (+ City District if available),State,District (if available)

"City District if available" is are in the same field as "City".... this info should be in it's own field.

example:
76831,Ilbesheim bei Landau in der Pfalz ,RP,SÜW

What is the city, what is the district? Is it all a city?

Data like this is difficult to import without going through it manually and splitting up the info, or writing some code to do the same.

Smoge

76831= this is the zipcode

Ilbesheim bei Landau in der Pfalz = this al is really the city

RP = this is the federal state Rheinland Pfalz

SÜW = orientation

i think it´s not good idea to insert this code

have you idea how can i create self this code for germany or how can i get this code?

thanks Jack

Originally Posted by Jack Kubel

76831= this is the zipcode

Ilbesheim bei Landau in der Pfalz = this al is really the city

RP = this is the federal state Rheinland Pfalz

SÜW = orientation

i think it´s not good idea to insert this code

have you idea how can i create self this code for germany or how can i get this code?

thanks Jack

I think you could import it, maybe the city district makes no difference... maybe it SHOULD be in the same field as city.

As ijk said; most of these files donot have a lattitude or longitude coordinates.

I am not sure where to get the files really needed; with all the info and lattitude or longitude coordinates.

Sounds like a job for someone to do on Google.

Smoge

I've never been to the UK, so I'm not familiar with the difference between a "county" and "unitary authority". However you can find the latitude and longitude of every city in the world by going here:

World/Europe/United Kingdom/England for example:

http://www.getty.edu/vow/TGNHierarch...jectid=7002445


I've been trying to get my Web Scraper to get them all but it keeps breaking since I don't know the rules of county v unitary authority and because the "old country" doesn't follow any conventional rules of place like the US. I've also been toying with the idea of using city on auto complete instead of zip all together. Just haven't figured it out yet. Check it out, may be of some value to some of you.