Friday, March 3, 2017

Lists of the administrative units

Interestingly, I was asked several times lately to provide a full list of the administrative units - sometimes down to subdistrict level, sometimes to village level - for various purposes, for example as the basis of some academic research. In one case the location was requested as well, in another the population. My full set of data is not so easy to use, as it is in XML format and contains a lot of details, and for example the population data is in different XML files than the main list. A subset of the data is found in the spreadsheet, but most notably the Muban are missing in there. But as in all cases a simple CSV file was requested, I quickly coded something to compile such lists, and since I just got yet another request, I now also made these CSV files downloadable for everyone - even I love to know when and where my data is used, for the next time I could simply point to this blog post then...

The ZIP archive contains CSV files for each of the subdivision.
  • Province.csv - all provinces and Bangkok, with their TIS-1099 code, name in English and Thai, the latest population and number of households, and the location of the province hall.
  • District.csv - all districts (Amphoe and Khet), same data with location of the district office
  • Subdistrict.csv - all sub-districts (Tambon and Khwaeng), as before. Locations are the TAO office, but still a lot without location info
  • Village.csv - all administrative villages, however without population data. Note the comments I made earlier about the number of Muban, that list might not be 100% correct. For very few the location of the village headman office (i.e. his home) is added.
If there would be the need, I could also compile the local governments in a similar manner, however as most of those have no TIS-1099 derived code, so it is not so easy to get the hierarchy like in the central administrative units, so would have to think a bit which data would be mandatory in such a CSV then.

No comments: