Source of data for "official" country/region list

automation locale country country-codes
jfrobishow picture jfrobishow · Jun 24, 2009 · Viewed 8k times · Source

Lately we've started getting issues with outdated countries / regions list being presented to users of our web-application.

We currently have a few DB tables to store localized country names along with their regions (states). However as the planet goes, that list is in constant evolution and it's proving to be a pain to maintain as some regions are deleted, some merged - existing data needs to be updated all the time.

What are, if any exist, the best practices when it come to dealing with multi-locale countries/regions list?

Is there a place or a standard in place? I know of ISO 3166, but their list isn't exactly DB friendly ... plus it's not fully localized.

An ideal solution would simply allow us to "sync" to it? Preferably in multiple language. The solution would preferably be free or subscription based with an historic of what changed so we could update our data (aka tblAddress)

Thanks!

Answer

Jason picture Jason · Jun 30, 2009

geonames is pretty accurate in this respect, and they update regularly.

http://www.geonames.org/export/

Related questions

How can I pass an argument to a PowerShell script?

There's a PowerShell script named itunesForward.ps1 that makes iTunes fast forward 30 seconds: $iTunes = New-Object -ComObject iTunes.Application if ($iTunes.playerstate -eq 1) { $iTunes.PlayerPosition = $iTunes.PlayerPosition + 30 } It is executed with a prompt line command: powershell.exe itunesForward.ps1 Is it …

Read More
Typing the Enter/Return key using Python and Selenium

I'm looking for a quick way to type the Enter or Return key in Selenium. Unfortunately, the form I'm trying to test (not my own code, so I can't modify) doesn't have a Submit button. When working with it manually, …

Read More
automatically execute an Excel macro on a cell change

How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my working code is: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("H5")) Is Nothing Then …

Read More