Ian Macabulos

Ian Macabulos

Full-Stack Developer

Better San Fernando

Independent Civic Information & Transparency for San Fernando

Better San Fernando is an independent, open-source civic-information and transparency portal for San Fernando, Pampanga. It organizes public services, projects, government information, legislation, transparency records, and statistics into an interface designed to make public information easier to find, understand, and trace back to its sources. It is not an official City Government website or affiliated with it.

Next.jsTypeScriptTailwind CSSZodMapLibre
Better San Fernando homepage with civic search, services, projects, and public information

Building a BetterLGU for my own city

I discovered the BetterGov / BetterLGU initiative, where developers and communities maintain independent information portals for Philippine LGUs. I chose to build and maintain one for my own city, San Fernando, Pampanga.

Starting from the iyanski/betterlocalgov starter/reference, I evolved Better San Fernando around the city’s actual civic information, publication constraints, search, localization, mapping, and maintenance needs.

Public information existed. Finding it was the difficult part.

Useful information is spread across services, offices, project and procurement records, legislation, disclosures, and statistics. Residents should not need to know which office, report, or document contains an answer before they can find it.

What I built

Civic search

Search published civic information using familiar terms and aliases.

Services

Find requirements, responsible offices, and resident-facing guidance.

Projects & map

Browse project records and supporting evidence alongside city and barangay geography.

Government & transparency

Explore offices, contacts, legislation, public records, and statistics.

Publishing only what the evidence supports

Unknown data stays unknown. Coverage can be partial: missing facts are not inferred, and sourced fact stays distinct from interpretation. An absent record does not prove that an activity does not exist.

Research is reviewed before it becomes public application data. The frontend consumes reviewed, frontend-safe exports through validated, typed access; it never reads private or raw research directly.

  1. Official / public sources

    Attributable pages and records.

  2. Research & verification

    Check evidence and retain uncertainty.

  3. Publication review

    Approve what is safe to publish.

  4. Frontend-safe export

    Reviewed, generated civic data.

  5. Typed civic-data access

    Validate before application use.

  6. Resident-facing interface

    Present facts with sources and limits.

Key engineering decisions

Source-aware civic data

Reviewed public data passes through a typed access layer with Zod validation. Pages consume that layer instead of importing arbitrary research or generated files directly.

Search in the words residents use

MiniSearch and curated aliases connect office acronyms and government terminology to familiar English and Filipino phrases, so residents can search without knowing the official vocabulary.

English + Filipino, with source fidelity

i18next translates the interface while official names, source references, and source-derived records stay faithful to their evidence.

Open source by design

The public frontend is open source, with contribution guidance for interface, accessibility, search, documentation, and other improvements. Civic-data corrections are submitted as leads and reviewed against supporting sources before publication.