People's Budget Portal
An independent civic transparency tool that makes the City of San Jose del Monte's public financial data — budget, contracts, and infrastructure projects — easy to explore in one place. All data comes from official Philippine open data portals and is updated automatically.
Pages
What each section of the portal covers and where the data comes from.
Data Sources
All data is sourced from official Philippine government portals or independent aggregators that index them.
The national agency that collects and publishes LGU fiscal data. Annual Statement of Receipts & Expenditures (SRE) covers income, expenditures, Special Education Fund (SEF), and Local Disaster Risk Reduction and Management Fund (LDRRMF).
The official registry for all Philippine government procurement. Every contract awarded by CSJDM agencies must be posted here by law. This portal shows all contracts where the procuring entity is a CSJDM agency.
DPWH's public tracking system for infrastructure projects. Contains project descriptions, contract amounts, location, and physical progress. Filtered to projects in San Jose del Monte, Bulacan.
An independent open-data aggregator that indexes PhilGEPS and DPWH data into a fast Meilisearch API. This portal queries BetterGov for live procurement and project data, falling back to a cached Neon database when the live API is unavailable.
How Data Flows
The portal uses two data paths depending on the data type.
Fetched from the BetterGov Meilisearch API on every page load and cached for 1 hour via ISR. If the live API is unavailable, the portal automatically falls back to a snapshot stored in the Neon database. Cron jobs run hourly to keep the cached snapshot fresh.
Imported manually from BLGF's annual Excel files using a import:blgf script that parses and upserts CSJDM rows into the Neon database. BLGF typically publishes the prior fiscal year's data around mid-year. After each import, update the BLGF_IMPORT_DATE environment variable.
Tech Stack
Technologies used to build and run the portal.
Environment Variables
Copy .env.example to .env.local and fill in the values below.
| Variable | Required | Description |
|---|---|---|
DATABASE_URL | Yes | Neon Postgres connection string. Get from console.neon.tech. |
CRON_SECRET | Yes | Secret used to authenticate Vercel cron job requests. Generate with: openssl rand -hex 32 |
BETTERGOV_MEILISEARCH_KEY | Yes | Read-only API key for the BetterGov Meilisearch index. Get from data.bettergov.ph. |
BLGF_IMPORT_DATE | Yes | Date of the last successful BLGF data import in YYYY-MM-DD format. Update after running import:blgf. |
RESEND_API_KEY | No | Resend API key for sending contact form submissions. Get from resend.com/api-keys. |
CONTACT_EMAIL_TO | No | Email address that receives contact form submissions. |
DATABASE_URLRequiredNeon Postgres connection string. Get from console.neon.tech.
CRON_SECRETRequiredSecret used to authenticate Vercel cron job requests. Generate with: openssl rand -hex 32
BETTERGOV_MEILISEARCH_KEYRequiredRead-only API key for the BetterGov Meilisearch index. Get from data.bettergov.ph.
BLGF_IMPORT_DATERequiredDate of the last successful BLGF data import in YYYY-MM-DD format. Update after running import:blgf.
RESEND_API_KEYOptionalResend API key for sending contact form submissions. Get from resend.com/api-keys.
CONTACT_EMAIL_TOOptionalEmail address that receives contact form submissions.
FAQ
Common questions about the portal.
No. This is an independent civic project. It is not affiliated with, endorsed by, or connected to the City Government of CSJDM, any of its offices, or any elected official.
Procurement and infrastructure project data is refreshed hourly from BetterGov.ph. Budget (income and expenditure) data is updated annually after the BLGF publishes new data, typically mid-year for the prior fiscal year. The Accountability page is updated manually.
Budget data comes from BLGF's LGU Fiscal Data portal where you can download the original Excel files. Procurement data is available at PhilGEPS, and infrastructure project data at the DPWH website.
Please . Include the page, the figure in question, and a link to the correct source if you have one. Verified errors are corrected promptly.
Yes. The portal is open-source and available on GitHub.
Disclaimer
Last updated: June 2026
This site is a citizen-built transparency tool. It is not affiliated with, endorsed by, or connected to the City Government of San Jose del Monte, Bulacan, any of its offices, or any elected official. It does not represent the position of any government agency.
Budget figures are sourced from the BLGF LGU Fiscal Data portal. Procurement and contract data come from PhilGEPS via BetterGov.ph. Infrastructure project data comes from the DPWH Infrastructure Transparency Dataset, also via BetterGov.ph.
While every effort is made to present data accurately, figures are reproduced from public sources and may contain errors present in those original records. Computed values (totals, per-capita figures, year-on-year changes) are derived automatically and may not match official government summaries. Do not use this site as a substitute for official government data when making legal, financial, or policy decisions.
The findings on the Accountability page are based on cross-referencing public data with published news reports. All narratives are sourced and linked. Estimates (e.g., water tanker costs, household counts) are drawn from published reports and noted as such — they are not independently audited.
This site is provided as-is, without any warranty of completeness, accuracy, or fitness for a particular purpose. The maintainer is not liable for decisions made based on data presented here.