Two elements in list of assigned ISO 3166-1 alpha-2 codes not contained in zone.tab
To aid the discussion on how much extra work it is to map all currently assigned ISO 3166-1 alpha-2 codes to at least one zone, I did: 1) import a) a list of ISO 3166-1 codes http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_ele... b) the list of ISO 3166-1 codes from tzdata2012c/zone.tab 2) performed the query SELECT DISTINCT(tz_zonelist.iso_3166_1), tz_countrylist.iso_3166_1 FROM tz_countrylist LEFT JOIN tz_zonelist ON tz_countrylist.iso_3166_1= tz_zonelist.iso_3166_1 ORDER BY `tz_zonelist`.`iso_3166_1` ASC 3) obtained the results iso_3166_1 iso_3166_1 NULL HM NULL BV AD AD ... That means the only ISO 3166-1 codes not mapped seem to be HM and BV. Any corrections welcome! -- Tobias Conradi Rheinsberger Str. 18 10115 Berlin Germany http://tobiasconradi.com/
On Fri, May 11, 2012 at 11:23 PM, Tobias Conradi <tobias.conradi@gmail.com> wrote:
... a) a list of ISO 3166-1 codes http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_ele... ...
A more authoritative source might be: http://www.iso.org/iso/iso-3166-1_decoding_table (search for "Table 3:"). Unfortunately, the official country names are given in GREAT RUNES; so, as a practical matter, one might want to use the Wikipedia list as the primary source for generating machine-readable data (CSV files, for example) and the ISO list for manual double checking. --Bill Seymour
On 12/05/2012 05:23, Tobias Conradi wrote:
To aid the discussion on how much extra work it is to map all currently assigned ISO 3166-1 alpha-2 codes to at least one zone, I did:
1) import
a) a list of ISO 3166-1 codes http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_ele...
b) the list of ISO 3166-1 codes from tzdata2012c/zone.tab
2) performed the query
SELECT DISTINCT(tz_zonelist.iso_3166_1), tz_countrylist.iso_3166_1 FROM tz_countrylist LEFT JOIN tz_zonelist ON tz_countrylist.iso_3166_1= tz_zonelist.iso_3166_1 ORDER BY `tz_zonelist`.`iso_3166_1` ASC
3) obtained the results iso_3166_1 iso_3166_1 NULL HM NULL BV AD AD ...
That means the only ISO 3166-1 codes not mapped seem to be HM and BV.
Any corrections welcome!
Well done, but you did all that after trying to convince us list subscribers that you had no idea how to find out which of several text files in a directory contained a text string you were looking for? -- -=( Ian Abbott @ MEV Ltd. E-mail: <abbotti@mev.co.uk> )=- -=( Tel: +44 (0)161 477 1898 FAX: +44 (0)161 718 3587 )=-
participants (3)
-
Bill Seymour -
Ian Abbott -
Tobias Conradi