πŸ“Š Budget Visual Analysis

Interactive charts and visualizations of budget data

Loading budget data...

Total Budget Items

Loading...

Total Budget Value

Loading...

Total Departments

Loading...

Unique Agencies

Loading...

πŸ›°οΈ BICAM 2026

Jump to high-risk overlaps (resurrected + flagged) and transparency links.

πŸš€ Open Integrated Matrix β†’

πŸ—οΈ DPWH 2026

Detailed analysis, red flags, and cost anomalies.

πŸ“Š Open Dashboard β†’

πŸ”— Compare NEP with Budget Data

See how NEP allocations correlate with actual budget expenditures

πŸ“ˆ View NEP-Budget Correlation β†’

πŸ’° Compare Budget with Flood Control

See how budget allocations correlate with flood control projects

πŸ“Š View Budget-Flood Correlation β†’

πŸ—ΊοΈ Budget by Region Over Time

πŸ›οΈ Budget by Department

πŸ’° Expense Categories

πŸ“Š Top Agencies by Budget

πŸ“Š Budget Data Browser

Browse and sort budget data with pagination

Page 1 of 1
Loading budget data...

Contract Splitting Analysis

Detection of project clusters awarded to the same contractor, potentially split to bypass approval limits.
Priority is given to known candidates.

Cluster ID Contractor Count Total Amount Region Candidate? Action
Select the tab to load data...

πŸ” AI-Powered Budget Analysis

Advanced analysis with intelligent duplicate detection and anomaly identification

πŸ” Duplicate Detection Results

πŸ“Š Column-Level Analysis

πŸ” Column Duplicates Analysis

πŸ”„ Repeated Projects

DPWH projects in 2026 that also existed in previous years (2020-2025)

Note: Some matches may represent legitimate project phases or packages (e.g., Phase I, Phase II, Package 1, Package 2). Additionally, some projects may be repair and maintenance work on the same infrastructure, which is expected for ongoing road maintenance. Review matches carefully to distinguish between legitimate phases/maintenance and potential duplicate funding.

Loading repeated projects...

πŸ”„ Repeated Projects (Revised Names Only)

DPWH projects in 2026 matched using only revised_name field (not the original name). This shows the effect of using revised names for matching.

Note: This tab only shows projects where the revised_name field exists in the 2026 budget data. The matching is done against the historical project descriptions using the revised name.

Finding: Using revised names with chainage details reduces the number of detected resurrected projects by approximately 69% (from 7,948 to 2,436). This substantial drop suggests that adding specific station limits (chainage) effectively breaks the link to previous generic project descriptions, potentially obscuring the repetitive nature of these projects by treating them as unique locations.

Loading repeated projects (revised names only)...

πŸ“ Category Statistics

Average cost per kilometer and flagged cost by category and subcategory. Includes Bridges, Road Safety Facilities, Major Roads, and Minor Roads.

Note: Road classification (Major vs Minor) now relies on the location metadata captured for each project (e.g., inter-province trunk corridors automatically map to β€œMajor Roads”, while purely local alignments fall under β€œMinor Roads”). Without official documentation we still treat this as a heuristic rather than a legal designation, but the split is no longer driven by segment counts alone.

πŸ“Š Flagging Methodology:

Projects are flagged as outliers using a robust Median Absolute Deviation (MAD) analysis:

  • Threshold Formula: z = (x βˆ’ median) / (1.4826 Γ— MAD). Projects with z-scores above 1 are flagged.
  • Why MAD? MAD resists outliers, making thresholds more stable even when a few extreme values exist.
  • Per Category/Subcategory: Each bridge, road work type, or facility subtype gets its own median/MAD baseline.
  • Composite Projects: We still compute statistics on per-component averages, but compare the original cost/km against the MAD threshold.

This keeps comparisons fair: a cost that’s typical for one category might be an outlier in another.

Bridges Flagged Cost (2020-2026)

Year-on-year flagged cost totals for Bridges.

Road Safety Facilities Flagged Cost (2020-2026)

Year-on-year flagged cost totals for Road Safety Facilities.

Irrigation Works (NIA) Flagged Cost (2020-2026)

Year-on-year flagged cost totals for Irrigation Works (NIA).

Rockfall Netting Flagged Cost (2020-2026)

Year-on-year flagged cost totals for Rockfall Netting.

Schools Flagged Cost (2020-2026)

Year-on-year flagged cost totals for Schools.

Major Roads Flagged Cost (2020-2026)

Year-on-year flagged cost totals just for the Major Roads category.

Multi-Purpose Buildings Flagged Cost (2020-2026)

Year-on-year flagged cost totals for Multi-Purpose Buildings.

Category Subcategory/Work Type Avg Cost/km Cost to be Flagged Flagged Cost Flagged Count Total Count
Select a year to load category statistics

πŸ› οΈ Project Cost Analysis

Analyze infrastructure projects by calculating distance from chainage and cost per kilometer. View Major/Minor Roads, Bridges, Road Safety Facilities, Irrigation Works, Multi-Purpose Buildings, and Rockfall Netting side by side.

Loading road projects...

Note: This analysis includes infrastructure projects from 2026 budget amendments (with historical context where available). Projects are categorized into Major/Minor Roads, Bridges, Road Safety Facilities, Irrigation Works (NIA), Multi-Purpose Buildings, and Rockfall Netting. Composite projects are counted separately for each component and sorted by cost per kilometer (most expensive first).

πŸ“Š Project Statistics

Statistical analysis of cost per kilometer for major project categories, including roads, bridges, road safety facilities, irrigation works, multi-purpose buildings, and rockfall netting.

Loading road statistics...

πŸ›£οΈ Highway Reblocking Analysis

Analyze major highways (Maharlika, Andaya, etc.) by comparing cost per kilometer across segments. Visualize highway segments arranged by chainage position with color coding for cost anomalies.

Loading highway reblocking analysis...

Note: This analysis identifies major highways using keywords (highway, hiway, etc.) and chainage data. Projects are classified as new construction, repair, rehabilitation, or maintenance. Segments are arranged by chainage position with darker colors indicating higher costs per kilometer, especially when repairs exceed new construction costs.