SPATIOTEMPORAL DATABASE DESIGN OF SERIAL INSURGENT EVENTS IN THE SOUTHERNMOST THAILAND

摘要

Due to the political, cultural, and religious conflicts, serial insurgent events in the southernmost Thailand, covering 3 provinces i.e. Pattani, Yala, and Narathiwat, have been active since 2004 to recent. They cause impacts to overall societies in Thailand. The events have become more and more severe and there is no sign to stop. Few databases of these events are being recorded as relational database but no specifically on temporal data. The purpose of this study is using UML (Unified Modeling Language) to design the object-orientated GIS database system involving spatial, attribute, and temporal data. Conceptually, the system user requirements are obtained from questionnaires. Logically, the temporal data are designed based on temporal geometric primitives (instant and period), temporal reference system (calendar and clock), and operation on temporal relative position of ISO19108:20002. Because of lacking of systematic positioning data, the most detail spatial data are recorded by points of landmarks such as villages, school, mosques, monasteries, etc. Attribute data involve in active firebrands, action approaches, weapon, and vehicle used, relevant events, etc. The system will be further developed using object-orientated programming and the Google API (Application Programming Interface). The web-based application of the system designed will include functions, for instance, create, add, edit, delete, import, export, interactive table fusion, and display. Few years of data will be input for the system and application tests. The system developed could be useful and helpful specifically for experts in criminology of government agencies.