NAMFREL Civic Tech: Distributed SMS Quick Count (2004) & Geomapping Validation (2016)
Architected 2004 distributed multi-server SMS quick count with job queueing, Jabber/XMPP, and telco SMPP; deployed 2016 GIS geomapping for election count validation
Verified Online Sources, Press & Recognition
Historical Election Tabulation & NAMFREL 2004 Quick Count
“Documentation covering NAMFREL's innovative integration of SMS mobile messaging for nationwide precinct vote tabulation.”
NAMFREL Parallel Count & SMS Transmission Archives
“Historical news coverage examining NAMFREL's deployment of SMS text messaging for nationwide precinct-level parallel vote tabulation.”
Philippine Election Returns 2016 Open Dataset
“Parsed, structured open election returns repository used for independent electoral analysis and geomapping validation.”
Executive Overview
NAMFREL has served as the accredited citizen watchdog for Philippine elections. Macoy volunteered across two critical technological junctures: modernizing precinct tabulation through mobile SMS in 2004, and introducing GIS geomapping in 2016 to verify geographic tally integrity.
The Challenge
In 2004, absorbing massive bursts of incoming SMS traffic sent by thousands of remote voting precincts across the country without dropping messages or overwhelming a single database server—years before modern cloud message queues existed. In 2016, rapidly identifying regional anomalies and validating election returns against physical precinct boundaries.
The Solution & Architecture
In 2004, designed a distributed multi-server architecture: direct telco SMPP binds fed into Kannel SMS gateways, which dispatched incoming messages into worker nodes via asynchronous job queueing coordinated by Jabber (XMPP) messaging protocol, before persisting verified tallies into MySQL. In 2016, applied GIS spatial analytics and interactive geomapping to track precinct returns in real time and open-source the dataset on GitHub.
Key Technical & Operational Highlights
Impact & Outcomes
Engineered a pioneering distributed multi-server job queueing architecture powered by Jabber/XMPP to handle nationwide SMS concurrency in 2004
Empowered election observers with real-time geospatial visualization to track vote counting credibility across provinces (2016)
Provided transparent, machine-readable election return datasets for public researchers and journalists