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.

Type

Small

Medium

Large

Unknown

TAO

5120

177

35

2

Thesaban Tambon

1875

341

13

4

Thesaban Mueang

17

135

26

0

Thesaban Nakhon

0

25

5

0

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:

Changwat, Amphoe, Tambon

Everything about the administrative subdivisions of Thailand - history, current news, facts hardly found in English, reviews of corresponding books, the Wikipedia coverage of these entities...

Feedback of all kind is very welcome, either by public comments at the corresponding posting, or also by private email. Comments only posted to spam or containing anything which might give me legal problems in Thailand will be deleted.