Home Projects Traffic Analysis
🚗 Traffic Analysis Python Data Visualization 2018-2020 Dataset

Metro Manila Traffic Incidents Analysis

MMDA Alert Data (August 2018 - December 2020)

Comprehensive analysis of 17,000+ traffic incidents reported by MMDA examining accident hotspots, peak hours, vehicle types, and road safety patterns across Metro Manila's major roads.

17,312
Total Incidents
11,781
Vehicular Accidents
15
Hotspot Locations
16
Analysis Topics
Data Period
August 2018 - December 2020
Tech Stack
Python Pandas Chart.js HTML/CSS
Key Takeaways

Analysis of 17,312 MMDA-reported traffic incidents across Metro Manila reveals that vehicular accidents dominate at 68%, with clear hotspot locations and peak-hour patterns from 2018 to 2020.

  • Vehicular accidents account for 11,781 incidents (68% of all reported), making them the most common incident type on Metro Manila's national roads.
  • 15 major hotspot locations were identified along EDSA, C5, and other MMDA-jurisdiction roads with consistently high incident rates.
  • Rush hours (7-9 AM and 5-8 PM) show the highest concentration of incidents, with late-night weekend hours also showing elevated rates.
  • The COVID-19 pandemic in 2020 caused a significant drop in reported incidents, providing a natural experiment on traffic volume and safety.

Incident Statistics

Key metrics from MMDA traffic incident reports across Metro Manila's national roads.

Vehicular Accidents
Most common incident type reported
68% of all
Peak Year
2019 saw the highest incident count
10,111 incidents
Daily Average
Incidents per day (2019)
~28 per day
Most Affected
City with most incidents
Quezon City (50%)

Incident Type Distribution

Breakdown of reported incident categories

Yearly Trend

Incidents by year (2018-2020)

Geographic Distribution

Where do traffic incidents occur most frequently?

Incidents by City

Distribution across Metro Manila cities

City Distribution (Pie)

Percentage share by municipality

Quezon City

Highest
Total Incidents 8,725
Share of Total 50.4%
Key Roads EDSA, C5
Top Hotspot EDSA Shaw Tunnel

Makati City

High
Total Incidents 2,431
Share of Total 14.0%
Key Roads EDSA, Ayala
Top Hotspot EDSA Buendia

Accident-Prone Locations

The most dangerous spots on Metro Manila's roads.

Top 15 Incident Hotspots

Specific locations with highest incident counts

Detailed Hotspot Analysis

Road safety data for major incident locations

Location Incidents City Road Risk Level
EDSA Shaw Tunnel 306 Mandaluyong EDSA Critical
EDSA Guadalupe 285 Makati EDSA Critical
EDSA Megamall 235 Mandaluyong EDSA Critical
EDSA Buendia 227 Makati EDSA High
EDSA Main Ave 220 Quezon City EDSA High
C5 Lanuza 219 Pasig C5 High
EDSA Ortigas Flyover 205 Quezon City EDSA High
C5 Kalayaan 196 Makati C5 Moderate
EDSA Boni 193 Mandaluyong EDSA Moderate
EDSA Reliance 188 Mandaluyong EDSA Moderate

Temporal Patterns

When do traffic incidents occur most frequently?

Incidents by Hour of Day

Hourly distribution showing peak incident times

Morning Peak
7:00 AM has highest incidents
1,355 incidents
Rush Hour Window
6 AM - 10 AM accounts for major share
29% of total
Afternoon Peak
Secondary peak at 3 PM
1,118 incidents
Safest Hours
Midnight to 5 AM lowest incidents
~5% of total

Incidents by Day of Week

Weekly pattern of traffic incidents

Weekday vs Weekend

Comparing incident rates

Traffic Direction Analysis

Which direction of travel has more incidents?

Incidents by Direction

NB, SB, EB, WB distribution

Direction Analysis

Understanding directional patterns

Northbound (NB) 6,585 (38%)
Southbound (SB) 6,025 (35%)
Eastbound (EB) 2,024 (12%)
Westbound (WB) 1,815 (10%)

NB/SB dominance reflects EDSA's north-south orientation as Metro Manila's main artery.

Vehicles Involved in Incidents

What types of vehicles are most frequently involved?

Vehicle Types in Incidents

Frequency of vehicle involvement

Private Vehicles

High Risk
Cars/Sedans 6,709
SUVs 2,651
Vans 2,456
Motorcycles 3,577

Public Transport

Moderate
UV Express 4,532
Buses 3,130
Taxis 1,489
Jeepneys/PUJ 798

Traffic Impact Analysis

How do incidents affect traffic flow?

Lanes Blocked per Incident

Traffic disruption severity

Impact Summary

Traffic flow disruption analysis

1 Lane Blocked 15,021 (90%)
2 Lanes Blocked 1,590 (9.5%)
3+ Lanes Blocked 14 (0.1%)

90% of incidents block only 1 lane, indicating quick MMDA response minimizes traffic disruption.

Major Road Analysis

Comparing incident rates on EDSA, C5, and other major roads.

EDSA vs C5 Incidents

Metro Manila's two main arteries

EDSA Segment Analysis

Incidents along EDSA segments

EDSA Dominance
EDSA accounts for majority of incidents
~65% of total
C5 Share
Second major road corridor
~15% of total
Shaw-Guadalupe
Most dangerous EDSA stretch
591 incidents

Incident Categories Analysis

Breaking down incident types beyond vehicular accidents.

Top 10 Incident Categories

Detailed breakdown of incident types

Accidents

73%
Vehicular Accident 11,781
Multiple Collision 631
Self Accident 257

Stalled Vehicles

17%
Stalled Bus 865
Stalled Car 594
Stalled Truck 396

Pandemic Impact on Traffic Incidents

How lockdowns affected road safety in Metro Manila.

Monthly Incident Trend (2018-2020)

Note the dramatic drop during March 2020 lockdown

Pre-Pandemic (2019)

Normal
Total Incidents 10,111
Monthly Average 843
Daily Average 27.7

Pandemic Year (2020)

Reduced
Total Incidents 3,190
Change from 2019 -68%
ECQ Impact Near zero in April

Key Findings

Major insights from the traffic incident analysis.

EDSA Shaw Tunnel: #1 Hotspot

With 306 incidents, Shaw Tunnel is Metro Manila's most accident-prone location, likely due to merging traffic patterns.

Quezon City Dominates

50.4% of all incidents occur in QC, reflecting both EDSA and C5's significant portions running through the city.

Morning Rush is Deadliest

7-8 AM sees peak incidents with 2,627 combined, as commuters rush to work on congested roads.

Tuesday Most Dangerous

Tuesday has 22% more incidents than Sunday, showing weekday commute patterns significantly affect safety.

Cars Most Involved

Private cars/sedans appear in 6,709 incidents, followed by UV Express (4,532) and motorcycles (3,577).

Northbound Slightly Higher

NB incidents (38%) exceed SB (35%), possibly due to morning rush toward Manila CBD.

Minimal Multi-Lane Blocks

90% of incidents block only 1 lane, indicating MMDA's quick response and efficient clearance operations.

2019 Peak Year

10,111 incidents in 2019 (pre-pandemic) represents normal traffic conditions - ~28 incidents daily average.

COVID Reduced 68%

2020 saw dramatic 68% reduction in incidents due to ECQ/GCQ restrictions, proving traffic volume directly correlates to accidents.

Stalled Buses Common

865 stalled bus incidents suggest aging public transport fleet and need for better vehicle maintenance.

Data Source & Methodology

Understanding how this data was collected and analyzed.

Data Source

Origin MMDA Twitter
Collection Twitter API
Period Aug 2018 - Dec 2020
Parser Python (tweet2map)

Coverage

Total Records 17,312
With Coordinates ~99%
Road Coverage National roads
Variables 13 attributes
Limitations
Data covers only MMDA-jurisdiction roads (national roads like EDSA, C5). Local/barangay roads not included.
Data Gap
Early 2020 has some gaps due to pandemic disruptions and code upgrades by the researcher.
Analysis Tools
Chart.js for visualization, Python for data processing, CSS for responsive design.

Have Data But Need Help?

If you have raw data and want to transform it into meaningful insights like this analysis, I'd love to help! Whether it's business data, research datasets, or any information you want to visualize and understand better.

Have a dataset you'd like analyzed or need a mini AI project as a starter guide? Send me your suggestions!

Connect on LinkedIn Email Me Dev.to Articles 💬 Messenger