I need geo database in format County->Region->City. I use this database:
https://www.maxmind.com/en/worldcities
As i understand country code use ISO: https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2. For example this line:
us,sand point,Sand Point,AK,,55.3397222,-160.4972222
mean:
US - County United States
Sand Point - City name
AK - Region Alaska
But where i can get list of regions codes?
Thank you.
The region codes are listed here:
http://www.maxmind.com/download/geoip/misc/region_codes.csv
The first column is the country code, the second column is the region code within that country. So this line means that AK
in US
is Alaska:
US,AK,"Alaska"