Thursday, October 19, 2017

New ccaatt geocodes

Not only did the DOPA statistics page get a facelift - including a double spelling mistake "Official Statstics Registration Sytstems" - but also the geocode lists were updated a second time this year. Now the new subdistrict of Bangkok are included - funnily all the codes I added temporarily into my XML were actually the final ones - and also some further municipalities now have a code. Unlike the previous update, the codes deleted in the ccaatt table were all added again.

Central administrative codes

From ccaatt Excel sheet
Oddly, the two new subdistricts of Saphan Sung were forgotten. There are also no codes prepared for planned new districts in Yala yet.
the

Local administrative codes

From rcode Excel sheet
My usual comment to these municipal codes - the current coding scheme cannot cover all the municipalities, internally in my software I already use the one I proposed some years ago, and it works fine.

Tuesday, October 17, 2017

Wang Nuea TAO to be merged with Wang Nuea municipality

There hasn't been any changes to the local governments since the upgrade of Pa Sak almost exactly two years ago, maybe due to the proposed abolish of the TAO level. However, in the meeting number 44 of the board two to consider draft laws on September 9, the merge of Wang Nuea TAO (องค์การบริหารส่วนตำบลวังเหนือ) with Wang Nuea subdistrict municipality (เทศบาลตำบลวังเหนือ) was discussed. As I still cannot access moi.go.th, I can only read indirectly through the Google cache, yet what I can find in the transcript of the meeting suggests the change is forthcoming very soon - maybe directly with end of the term of the TAO council on October 19th. Waiting for the end of the council term is somewhat strange, given that the local elections are suspended since the coup in 2014 already, but it was similar with the upgrade of Pa Sak mentioned before.

The transcript states, that due to the low population in the TAO - 1949 according to the transcript, 2167 in the latest DOPA statistics - the TAO should be abolished. A poll on whether the citizen approve this dissolution has been done, asking with which local government Wang Nuea shall be merged.
  • Wang Nuea municipality: 679 votes
  • Ban Mai municipality: 217 votes
  • Wang Sai TAO: 25 votes
  • Thung Hua TAO: 5 votes
  • Wang Tai TAO: 5 votes
The voters chose the obvious solution, to let the Wang Nuea municipality cover almost whole subdistrict Wang Nuea (Ban Mai covers a small part of the sub district as well).

Thursday, October 5, 2017

Fun with flags

On September 28th the Thai flag celebrated its centennial, which coincides with the timing of the latest Royal Gazette announcement on the Thai flag published yesterday, clarifying the Thai flag act of 1979 with the exact definition of the colors of the flag in the CIELAB color space.

ColourL*a*b*ΔE
Red36.455.4725.42Not exceeding 1.5
White96.61-0.15-1.48Not exceeding 1.5
Blue18.637.89-19.45Not exceeding 1.5

And it seems I am not the only one who is constantly monitoring the Royal Gazette announcements, as the Wikipedia article on the Flag of Thailand was already updated yesterday accordingly by Paul012.

And since the Wikipedia article also linked an unofficial translation of the flag act, its notable that this act does not mention anything about the flags for each province, the obscure flags I never saw anywhere but seem to exist - yet many other flags are defined in the act, even obscure one like the Boy Scout provincial flags.

Friday, September 29, 2017

Province governor reshuffle

With the end of the fiscal year, its traditionally also the date on which the province governors get transferred to new provinces, or to other posts within the Ministry of Interior, as well as deputy governors getting promoted to governors and assigned their first province.

The first part of this annual reshuffle has already been announced in the Royal Gazette on September 15, a total of 24 officials being reassigned to new posts. Out of these, there are four governors transferred to other positions within the ministry, 16 governors being transferred to new provinces, and one transferred from a post within the MOI to become province governor - the other three are transfers from and to other posts only. All of the transfers are effective October 1.

Due to lack of time I don't write up the full list here, you can find it either in the Gazette announcement, or translated into XML in my data collection. The second part of the reshuffle, the promotion of deputy governors, isn't published in the Gazette yet, but was already published in the press - I'll add it as soon as I see the announcement. And as usual, sadly the names of those governors who will retire is not listed anywhere, so can only guess them from the posts which get assigned a new name without any transfer of the previous incumbent.

Wednesday, September 20, 2017

Statistical yearbook 1923

Google books has scanned many very old reference books, but they are all only visible in the snippit mode, teasing enough to make sure its the resource one would need but still making it impossible to use them. It is quite annoying to have valuable information so near and still so far. When I last week again tried in vain to check the old yearbooks in the online library of the NSO - the scans there stop after a few pages - and then looked Google Books, I noticed that there actually is a form to ask for a book to be fully available. Without much hope I entered it for the 1923 yearbook, stating that by Thai law works from juristic persons have a copyright term of 50 years after publication and it thus should be long freely available. And to my total surprise - just one week later I received an email that the review is done, and the book is now fully readable.

Though they just changed access to this one year edition - after this success I'll do the same request for the other years as well later - it gives access quite a lot of interesting tables. The number of administrative units in 1922 for each of the 18 Monthon - totally there were 80 provinces, 421 districts and 5061 subdistricts. And most useful - and the reason why I chose this edition in my request - are the population numbers for each of the provinces from the 1919 census. The 1952 yearbook strangely had lot of nonsense numbers for this year. Also, especially the 1952 yearbook hide the fact that there were more provinces in 1919, and quietly added them to those provinces into which these were integrated in 1932.

There are some notable data points for some provinces. Phra Nakhon and  Phuket had far more male than female citizen, the ratio was over 130% for these. Though the numbers by nationality are only listed at Monthon level, these two Monthon have far less Siamese than others, and instead lots of Chinese - indicating there were many single male workers who could not bring a Chinese wife. Even more striking are the numbers for Monthon Pattani - only 15% of the population is listed as Siamese, the majority are Malay. The table is titled by "nationality", and not ethnic group, hence it seems that these were not considered full citizens back then. 100 years later the lack of integration of these people is still and unresolved problem...

Apart from the rather unusual way the province names were romanized in this edition of the yearbook, there are two province where a different name is listed than the one I expected - Lampang and Nan both are preceded by the word "Nakhon". While I had read about it for Lampang before, I have to investigate these further - at least there seems to be no official Royal Gazette announcement removing the "Nakhon" from these province names.

Anyway, now the census 1919 XML has been updated with all the data, the numbers of subdivisions are in a Yearbook1923.XML, and I will also soon update my big spreadsheet to show these province population numbers as well. And for those who prefer spreadsheets over XML, there's also a spreadsheet with the 1923 data I picked from the book. Next projects now should be to get the 1909 and the 1929 census data from yearbooks as well.

Friday, September 1, 2017

180 Khwaeng in Bangkok

It seems the number of subdistricts (Khwaeng, แขวง) in Bangkok has just or will very soon be increased from 169 to 180. The Thai Wikipedia Potapt, who is very active in keeping the articles on the subdivisions up-to-date in the Thai Wikipedia, has just updated all the relevant articles both in the Thai and in the English Wikipedia. I haven't yet seen any announcement in the Royal Gazette, but as he is always quite conservative in adding things, I trust he has very good sources that these changes are indeed forthcoming - but will wait till I have the official announcement to update Wikidata and the German Wikipedia then.

The new subdistricts will end the oddity of districts with just a single subdistrict. Its sad that the latest list of the ccaatt codes was just published, so it will be a guessing game which numbers are to be assigned to the new districts.

  • Phra Khanong district: Bang Chak subdistrict split to create Phra Khanong Tai subdistrict (แขวงพระโขนงใต้). District will have 2 subdistricts now, new subdistrict probably receiving the code 100910 as the next free code.
  • Phaya Thai district: Sam Sen Nai subdistrict split to create Phaya Thai subdistrict (แขวงพญาไท). District will have 2 subdistricts now, new subdistrict probably receiving the code 101406. The original subdistricts having the name Phaya Thai in their name were split off to Ratchathewi district in 1989.
  • Din Daeng district: Din Daeng subdistrict split to create Ratchadaphisek subdistrict (แขวงรัชดาภิเษก). District will have 2 subdistricts now, new subdistrict probably receiving the code 102602.
  • Suan Luang district: Suan Luang subdistrict split to create On Nut and Phatthanakan subdistricts (แขวงอ่อนนุช, แขวงพัฒนาการ). District will have 3 subdistricts now.
  • Saphan Sung district: Saphan Sung subdistrict split to create Rat Phatthana and Thap Chang subdistricts (แขวงราษฎร์พัฒนา, แขวงทับช้าง). District will have 3 subdistricts now.
  • Bang Na district: Bang Na subdistrict split into two new subdistrict named Bang Na Nuea (แขวงบางนาเหนือ) and Bang Na Tai (แขวงบางนาใต้). It remains to be seen if this will be done by abolishing the previous subdistrict and creating two new subdistricts, or by renaming it and creating one new ones.
  • Bang Bon district: Bang Bon subdistrict split into four new subdistrict named Bang Bon Nuea (แขวงบางบอนเหนือ), Bang Bon Tai (แขวงบางบอนใต้), Khlong Bang Phran (แขวคลองบางพราน) and Khlong Bang Bon (แขวงคลองบางบอน). It remains to be seen if this will be done by abolishing the previous subdistrict and creating four new ones, or by renaming it and creating three new ones.

Friday, August 25, 2017

ccaatt lists of 2017

Earlier this month, DOPA uploaded a new version of their geocode lists, this time changing the format to XLS files. Whereas the rcode file (containing codes for the municipalities) shows no changes compared to the list from last year, there is only one changes in the ccaatt list - it now only contains the Tambon, all the provinces, districts as well as the subdistricts in Bangkok were removed. I have no idea ifr this was intentionally, or a mistake when changing to the XLS format. When comparing it my list of tambon, only two spelling variants show up:
  • Ba Rue Si (บุฤๅษี) wrongly spelled บุฤาษี
  • Su-ngai Kolok (สุไหงโกลก) spelled with hyphen as สุไหงโก-ลก
and I noticed I myself had two misspellings in my spreadsheet, copied from some old erroneous lists and long corrected in the XML version.

Thus the only thing interesting at these new files is what they don't contain - no numbers yet for the two districts in planning in Yala province. As I haven't found anything official about them for quite some time, it seems it still needs quite some time till those get created.