[tz] Two elements in list of assigned ISO 3166-1 alpha-2 codes not contained in zone.tab

Tobias Conradi tobias.conradi at gmail.com
Sat May 12 04:23:06 UTC 2012


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_elements

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/


More information about the tz mailing list