Joined: 12/02/2018 23:00:43
Location: Vancouver, BC, Canada
I'm trying to associate geonameIds from countrysubdivision.txt with records from GB_full.csv via admin2 codes, and I'm having some difficulty.
I see that some records from GB_full.csv have the ISO 3166-2 code in the admin2 code column. However others (the majority) have values that I am not sure the meaning of.
For example, some are all digits, as here:
GB DH1 Shincliffe England ENG Durham 11609048 4
Here it's 11609048.
Others are of the form 'E' followed by digits:
GB DL10 4AA Richmond England ENG North Yorkshire E10000023 Richmondshire District E07000166 54.4068874368985 -1.73566402625828 6
Here it's E10000023.
I'm wondering if you can shed some light on what these mean, and if there's a good way to do what I'm trying to do.