Case study / Office directory
อปท.com case study
อปท.com is a directory of more than 7,800 Thai local-government offices. Each office has a page with a map and weather, and the site adds warning maps, trip ideas, news and an AI question assistant. The data is public and refreshed on a schedule.
- Role
- Built and run by me
- Stack
- PHP 8.2, MariaDB, MapLibre, cron jobs
- Interface
- Thai
- Data
- Public sources, updated on a schedule
My role
I built and run the site: the search, the office pages, the maps, the scheduled data jobs and the AI assistant. The interface is in Thai.
The problem
Thailand has thousands of local-government offices. Finding the right one, and seeing what is happening in its area, means visiting many separate sites. People who plan a trip or follow a warning want one clear page for a place.
The approach
Every office gets its own page. The page joins a map, weather and news for that area. Province pages show risk areas on a warning map in light or dark theme. A trip hub shows seasons, festivals and a live warning banner.
An AI assistant answers questions in Thai. It carries a notice that AI can be wrong. I use AI only where it answers a real question.
Data comes from public sources and updates on a schedule through cron jobs. If a source fails, the page keeps the last data and says when it was updated, instead of hiding the section.
Stack
PHP 8.2, MariaDB, MapLibre and cron jobs, as listed on the demo page. The AI part uses the shared AI gateway described in the IDUnify case study.
Screens
Public data, updated daily
Public pages with public data, updated daily. Contact details on office pages are blurred in the screenshots.







What is public and what is not
Public: the site, its public data, the stack and the screens above. The live site is อปท.com.
Not public: server details, the data update rules and anything about private integrations. I do not publish traffic numbers or search rankings. I do not claim that the data is complete or error free.
Related pages
Need a data-driven directory?
If you have public data and want a searchable site with maps and scheduled updates, tell me what you have. I reply with a one-page recommendation first.
Book the free consult