Flood Control Projects

📊 Visual 📋 Table 📍 Proximity 👥 Contractors 🕸️ Contractors Web 🏛️ SEC

Total Projects

Total Cost

Unique Contractors

Top Contractors

Projects Heat Map (Click to view detailed map)

Contractor Project Distribution (Standard Deviation Analysis)

Average Projects per Contractor: -

Standard Deviation: -

Contractors Beyond 3 SD: - (Highly Unusual)

Types of Work

Most Expensive Projects

Projects by Year

💰 Total Budget by Year

Total Budget: ₱0

Average per Project: ₱0

Highest Year: -

📋 Project Table View

📊 Sort by:

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

Showing 0 of 0 projects

Page 1

Source: Department of Public Works and Highways (DPWH) Flood Control Information System
Total Projects: 9,855 flood control projects nationwide
Data Range: 2016-2024 infrastructure projects

📍 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

6 Zeros - 6 consecutive zeros

7+ Zeros - 7+ 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 7+ consecutive zeros (₱96,500,000.0000000) - 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 6 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.

Source: Department of Public Works and Highways (DPWH) Flood Control Information System
Joint Ventures: 386 identified partnerships (12.87% of all projects)
Analysis: Companies connected through joint venture relationships

🏛️ SEC Data Analysis

Analyze contractor SEC registration data and identify contractors without SEC information

Total Contractors

Total SEC Records

Without SEC Data

Coverage Rate

⚠️ Contractors Without SEC Data

Source: Department of Public Works and Highways (DPWH) Flood Control Information System, Securities and Exchange Commission (SEC) Philippines
Total Projects: 9,855 flood control projects nationwide
Data Range: 2016-2024 infrastructure projects