Thursday, May 18, 2017

Local governments Small-Medium-Large

It took a bit longer than expected to work through the Excel sheets published by DOLA recently to extract the data from there and compile it to be used in my XML files. There were quite a lot of local governments misspelled in the Excel sheets, in some cases an already announced name change wasn't included in them, and also in several cases the district was wrong, so it took some time to match all the data rows from the Excel sheets with the corresponding item in my syntax. The result is a bit lengthy in XML however...


I now have the area value, the DOLA code (which sadly isn't stable like the codes from DOPA) and the Small-Medium-Large assignment for each of the local governments. Though it'd be most interesting to compare these SML assignments over time, an overview of the current numbers is also interesting.
TypeSmallMediumLargeUnknown
TAO5120177352
Thesaban Tambon1875341134
Thesaban Mueang17135260
Thesaban Nakhon02550

A bit strange are the six local governments where the Excel sheets left the SML level empty. As these level are about the economic power of the local government, those in the Large category (ขนาดใหญ่) are the prime candidates to get upgraded to a higher municipal level. It'd be interesting to compare with an older table to see whether this guess matches with reality. I have saved the Excel sheet from DOLA since 2010, so its just the time which is the limiting factor in creating such a statistics.

Fun fact - when looking for an image to add to this post, most of the results for ขนาดใหญ่ ขนาดกลาง ขนาดเล็ก where anal plugs...

No comments: