Flood Control Projects

📊 Visual 🗺️ Heatmap 📋 Table 📍 Proximity 👥 Contractors 🕸️ Contractors Web

Total Projects

Total Cost

Unique Contractors

💰 Compare Budget with Flood Control

See how budget allocations correlate with flood control projects

📊 View Budget-Flood Correlation →

🌉 Compare Flood with DIME Infrastructure

Analyze overlap between flood control and infrastructure projects

🏗️ View Flood-DIME Correlation →

📊 Contractor-District Correlation

Statistical analysis of concentration patterns between contractors and districts

🎯 View Statistical Analysis →

🏆 Top Districts by Number of Projects

Total Districts: -

Leading District: - with - projects

Page 1 of 1

Contractor Project Distribution (Standard Deviation Analysis)

Average Projects per Contractor: -

Standard Deviation: -

Contractors Beyond 3 SD: - (Highly Unusual)

Contractor Project Distribution (Scatter Plot Analysis)

Each point represents one contractor

Color coding: Green (normal), Yellow/Orange (suspicious), Red/Purple/Pink (outliers)

Circle size: Larger circles indicate higher total contract cost per contractor

Hover over points to see contractor details

Most Expensive Projects

Types of Work

Projects by Year

💰 Total Budget by Year

Total Budget: ₱0

Average per Project: ₱0

Highest Year: -

Projects Heat Map by Province (Click to view detailed map)

📋 Project Table View

🚩 Red Flag Legend

Chop-chop — projects that are artificially segmented into phases.
Siyam-siyam — projects with unreasonably prolonged implementation.
Doppelganger — projects that are suspiciously similar in cost and/or duration.
Ghost projects — projects that might be non-existent.

📊 Sort by:

Project	Region	Year	Type	Flags	Cost	Contractor
⟳ Loading data...

Showing 0 of 0 projects

Page 1

📍 Proximity Analysis: Same Amount, Close Location

Projects with identical contract amounts located within 1km of each other. Each pair has the exact same cost and is geographically close, which may warrant investigation.

🎯 Badge Legend

💀 CRITICAL - Impossible patterns

🔥 HIGH - Strong suspicion

⚠️ MEDIUM - Needs investigation

Diff Desc - Different descriptions

Diff Contractor - Different contractors

Diff Year - Different years

Same Contractor - Same contractor

Same Year - Same year

Exact Coords - Exact same coordinates

5 Zeros - 5 consecutive zeros

6+ Zeros - 6+ consecutive zeros

Multi-Phase - Multi-phase project

Up/Downstream - Upstream/downstream

Left/Right - Left/right banks

🚨 Suspicion Levels: Each pair is automatically scored based on how suspicious the pattern is:

💀 CRITICAL (Red):
- Only year differs with everything else identical - strong indicator of copy-paste error
- Same amount to the centavo across different years - virtually impossible as material prices/inflation change yearly
- Perfectly round amounts (₱96,500,000.00) at exact same location - highly suspicious template/placeholder
- Amounts ending with 6+ consecutive zeros (₱96,500,000.000000) - extremely suspicious rounding
🔥 HIGH (Orange):
- Same amount to the centavo at exact coordinates, same year
- Identical project description, contractor, and location - likely duplicate entry
- Amounts ending with 5 consecutive zeros - suspicious rounding pattern
MEDIUM (Yellow): Same exact location (0km) but with some differences - requires investigation
Low (White): Close proximity but clear differences in project details

🔵 Multi-Component Detection: Suspicion is lowered by one level (e.g., VERY HIGH → HIGH) if detected:

Multi-Phase: "Phase I", "Phase 2", etc. in both descriptions
Up/Downstream: "Upstream" or "Downstream" in both descriptions
Left/Right: "Left bank/side" or "Right bank/side" in both descriptions

Important: Even for legitimate multi-component projects, identical amounts remain suspicious as each component should have different scope/costs.

💡 Critical Insight: A properly scoped construction project should ALWAYS have centavos due to:

Material costs that don't divide evenly
Labor calculations with time fractions
Tax calculations creating decimals
Engineering estimates with precision

Therefore:

Identical amounts to the centavo across different years = highly suspicious copy-paste
Perfectly round amounts (₱96,500,000.00) at exact same location = highly suspicious template/placeholder
Amounts ending with 6+ zeros (₱96,500,000.000000) = suspicious rounding patterns
The ONLY legitimate round amounts would be budget templates, not actual project costs

Total Pairs Found

Exact Location Pairs

Avg Distance

#	Distance	Red Flags	Project 1	Project 2
Loading proximity data...

👥 Contractor Analysis

Analyze contractor performance, project counts, and spending patterns

Total Contractors

Top Contractor

Avg Projects/Contractor

Avg Cost/Project

Search:

Sort by:

Contractor Name	SEC Status	Projects	Total Cost	Avg Cost/Project	Suspicion Score
📊 Loading contractor data...

0 of 0 contractors

🕸️ Joint Venture Network

Visualize relationships between companies through joint ventures. Each connection represents a shared project.

Total JVs

Unique Companies

Total JV Value

Avg JV Value

Search Company:

Show Labels

Legend:

Company (Few JVs)

Company (3-4 JVs)

Company (5-9 JVs)

Company (10+ JVs)

Joint Venture Project

JV Connection

⚠️ Similar Names

Note: Node size = total contract value. Hover over nodes/lines for details. Click and drag to explore. Dashed red lines indicate potentially same company with different names.