khanh
Joined: 05/01/2015 13:36:02
Messages: 1
Offline
|
What should the table structure look like for postal code files downloaded from:
http://download.geonames.org/export/zip/
According to webpage it states the following, but it's really not complete. Any help would be much appreciated, especially in the form of a SQL statement:
country code : iso country code, 2 characters
postal code : varchar(20)
place name : varchar(180)
admin name1 : 1. order subdivision (state) varchar(100)
admin code1 : 1. order subdivision (state) varchar(20)
admin name2 : 2. order subdivision (county/province) varchar(100)
admin code2 : 2. order subdivision (county/province) varchar(20)
admin name3 : 3. order subdivision (community) varchar(100)
admin code3 : 3. order subdivision (community) varchar(20)
latitude : estimated latitude (wgs84)
longitude : estimated longitude (wgs84)
accuracy : accuracy of lat/lng from 1=estimated to 6=centroid
|