[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