311 OPCD Calls — Complete Data Analysis Report
City of New Orleans · Orleans Parish Communications District · 2012–Present
📊 Dataset: 2jgv-pqrq · data.nola.gov 📅 January 2012 – June 2026 🗃️ 1,003,064 total records 📍 95.9% GPS coverage 🔬 Analysis: June 2026
Table of Contents
01Dataset Overview
02Data Quality & Bad Data
03Complaint Volume Analysis
04Category Breakdown
05Department Performance
06The Resolution Time Scandal
07Council District Equity Analysis
08Yearly Trends (Post-2020)
09Baseline Department Grades
10Implications for NOLAServeUS
Section 01
Dataset Overview
What this data is, where it comes from, and what it covers

The City of New Orleans 311 OPCD Calls dataset represents every service request filed with the City of New Orleans 311 Call Center from its opening in January 2012 through the present day. In late 2018, operations transferred to the Orleans Parish Communications District (OPCD), which runs the system 24 hours a day. The dataset is published publicly on data.nola.gov under dataset ID 2jgv-pqrq and updated continuously.

This analysis was conducted as part of the NOLAServeUS platform development — a civic accountability platform for New Orleans residents. The goal: understand the existing 311 system's performance, identify patterns of service failure, establish baseline accountability metrics, and validate the need for community-verified resolution tracking.

1,003,064
Total Records
Jan 2012 – Jun 2026
74,305
Currently Pending
Unresolved open complaints
95.9%
GPS Coverage
962,183 valid coordinates
5
Council Districts
A, B, C, D, E
Data SourcePublicly available at data.nola.gov via the Socrata Open Data API (SODA). Query endpoint: https://data.nola.gov/resource/2jgv-pqrq.json — no authentication required for read access.
Complaint Status Distribution
Overall open vs. closed — all 14 years
92.6% Closed
928,759
Closed (92.6%)
74,305
Pending (7.4%)
GPS Coordinate Coverage
Records with valid map coordinates
95.9% Valid GPS
962,183
Valid GPS (95.9%)
40,881
Missing (4.1%)
Section 02
Data Quality & Bad Data
Understanding what's reliable and what to exclude from analysis

Before drawing conclusions, it is essential to understand this dataset's quality issues. Three distinct categories were identified: clean records, logical duplicates, and corrupted date records from the 2018 system migration.

1,003,064
Unique Records
Zero technical duplicates
88,495
Logical Duplicates
Same address + type + day
290,737
Bad Date Records
2018 migration corruption
712,327
Clean Records
Used for performance metrics
Data Quality Breakdown — 1,003,064 Total Records
What portion of the dataset is usable for each type of analysis
Clean Records
712,327  (71%)
Bad Date Records
290,737  (29%)
Logical Duplicates
88,495  (8.8%)
Missing GPS
40,881  (4.1%)
⚠️ The 2018 Migration Issue — 290,737 Corrupted RecordsWhen the 311 call center transferred from the City to OPCD in late 2018, approximately 290,737 records received corrupted date fields — the date_closed value was recorded as occurring BEFORE date_created. The worst case shows a complaint "closed" 2,474 days before it was filed. These records have valid GPS and status fields but cannot be used for response time calculations. All performance metrics in this report exclude records where response time falls outside 0–730 days.
📋 Logical Duplicates — 88,495 RecordsEvery record has a unique service request number (zero technical duplicates), but 88,495 records share the same street address, request type, and creation date as another record. These represent multiple residents reporting the same physical issue separately. This inflates the city's complaint count by approximately 8.8% and directly validates the NOLAServeUS upvote system — allowing residents to co-sign existing reports rather than file duplicates.
-- Identify bad data: impossible response times (2018 migration artifact)
SELECT COUNT(*) FROM nola_311_staging
WHERE (TO_DATE(date_closed,'MM/DD/YYYY') - TO_DATE(date_created,'MM/DD/YYYY')) < 0;
-- Result: 290,737 records

-- Safe filter applied to ALL performance queries in this report
WHERE (TO_DATE(date_closed,'MM/DD/YYYY') - TO_DATE(date_created,'MM/DD/YYYY')) BETWEEN 0 AND 730
Section 03
Complaint Volume Analysis
How 311 call volume has changed over time

The 2018 OPCD migration corrupted date_created fields on hundreds of thousands of records, wiping all pre-2019 year data. The 2019 bucket shows 392,355 records — not actual 2019 volume, but the accumulated total of all those corrupted historical records. Clean comparable annual data begins in 2020.

Annual Complaint Volume — 2020 to 2025
Post-migration clean data only  ·  Values above bars show actual complaint count  ·  *2025 is partial year through June
105k 80k 55k 25k 0
78,816
2020
96,574
2021
104,368 ▲
2022
98,445
2023
99,630
2024
88,784*
2025*
Annual total complaints
Peak year 2022
2025 partial year
Why only 2020–2025 is shownThe 2018 OPCD migration corrupted date_created on hundreds of thousands of records. The 2019 bucket (392,355) absorbed all those migrated historical records and is not representative of actual 2019 volume. Pre-2020 annual data cannot be reliably reconstructed from this dataset.
Complaints by Council District
Total volume 2012–2026 · All statuses
B — Uptown
153,686
A — Mid-City
148,108
D — Tremé
141,559
E — NO East
119,421
C — Algiers
111,290
Unresolved Rate by District
% of complaints still pending · Higher = worse
C — Algiers
11.6%
D — Tremé
11.6%
E — NO East
10.0%
B — Uptown
9.9%
A — Mid-City
9.6%
📍 District E Volume GapDistrict E (New Orleans East / Lower 9th Ward) shows the lowest total complaint volume at 119,421 — significantly below District B's 153,686 despite covering a large geographic area with dense population. This likely reflects a digital access and awareness gap rather than fewer actual problems. NOLAServeUS's mobile-first approach and community organizer network specifically close this gap.
Section 04
Category Breakdown
What New Orleans residents are actually complaining about

Trash and recycling complaints dominate the 311 system at 46.4% of all calls — nearly half of every complaint filed since 2012. This is approximately 90 complaints every single day for 14 years straight. The city picks it up. Residents dump again. Nothing changes. No department can resolve a behavior problem — which is exactly why NOLAServeUS builds community ownership alongside complaint tracking.

Complaint Volume by Category — Top 15 Request Types (2012–2026)
Total records all statuses
Trash/Recycling
465,230  (46.4%)
Property Maintenance
97,835  (9.8%)
Abandoned Vehicles
90,775  (9.0%)
Roads/Drainage
63,314  (6.3%)
Traffic Signals/Signs/Lights
58,269  (5.8%)
Streetlights
36,030  (3.6%)
Parks & Parkways
31,100  (3.1%)
Roads and Streets
28,623  (2.9%)
Drainage
27,552  (2.7%)
Street & Traffic Signs
10,562  (1.1%)
Graffiti Removal ⚠️
553  (0.06%)
🚨 The Sanitation Volume Crisis — 90 Complaints Every Day for 14 Years465,230 trash and recycling complaints since 2012. Sanitation resolves 98.7% of them — they are the best-performing department in the city. But the volume never decreases. The average resolution time is 50 days with a 7-day median. "Closed" simply means the city marked it done — there is no photo verification, no resident confirmation. The same spots get dumped on repeatedly. Community ownership through NOLAServeUS breaks this cycle.
🔍 Graffiti — 553 Reports in 14 Years, 51% Unresolved, 284-Day AverageDespite being highly visible, graffiti generated only 553 complaints through 311 — massively underreported because residents have no confidence anything will happen. When they do report it, 51% is never resolved and the average resolution time is 284 days. NOLAServeUS tracking graffiti as a dedicated category with photo evidence and a 14-day SLA is genuinely additive to the existing system.
NOLAServeUS → 311 Category Mapping
NOLAServeUS Category311 Equivalent311 Volume
Pothole / road damage
Roads/Drainage + Roads and Streets
91,937
Street light out
Streetlights + Traffic Signals/Signs
94,299
Flooding / drainage + Sewer
Drainage
27,552
Illegal dumping + Excessive litter
Trash/Recycling
465,230
Abandoned vehicle
Abandoned Vehicles
90,775
Blight + Commercial nuisance
Property Maintenance
97,835
Parks / green space
Parks & Parkways
31,100
Graffiti
Graffiti Removal
553 ⚠️
Section 05
Department Performance
How each city department handles its complaint workload

Performance varies dramatically across departments. The Department of Sanitation handles nearly half of all 311 volume and resolves 98.7% of complaints. At the other extreme, the Utility Company Collective resolves fewer than 6% of complaints routed to it, and the Sewerage & Water Board leaves over a third of all water and drainage complaints unresolved.

🚨 Critical Caveat — "Closed" Does Not Mean FixedIn the 311 system, "Closed" means the city marked the ticket closed — not that the problem was actually resolved. A complaint marked "Closed" could mean the work was done, or a supervisor batch-closed old tickets, or the complaint was routed to a department and marked received. There is zero community verification. No resolution photo required. No resident confirmation. The city grades itself. NOLAServeUS introduces community-verified resolution for the first time — residents confirm work was actually done before it counts toward a department's grade.
Unresolved Rate by Department
% still open · Lower is better
Utility Co.
94.8%
S&W Board
37.5%
Code Enf.
14.3%
Safety & Permits
13.4%
Public Works
12.2%
Parks & Pkwy
8.8%
Health Dept
5.9%
Sanitation
1.2%
Mosquito Ctrl
0.5%
Total Complaint Volume by Department
All records 2012–2026
Sanitation
463,255
Public Works
319,682
Code Enf.
103,896
Parks & Pkwy
30,588
Safety & Permits
16,893
Mosquito Ctrl
11,982
Health Dept
6,852
S&W Board
6,742
DepartmentTotalOpen% UnresolvedBaseline Grade
Department of Sanitation463,2555,7211.2%A
Mosquito, Termite & Rodent Control11,982550.5%A
Health Department6,8524075.9%B
Department of Parks & Parkway30,5882,6838.8%B-
Safety and Permits16,8932,25713.4%C+
Department of Public Works319,68238,95712.2%C-
Department of Code Enforcement103,89614,82314.3%D+
Sewerage & Water Board6,7422,53037.5%D
Utility Company Collective2,2112,09594.8%F
⚠️ Public Works — 38,957 Open ComplaintsThe largest raw backlog of any department — nearly 39,000 unresolved complaints covering potholes, road damage, traffic signals, street signs, and streetlights. With average resolution times of 134–175 days and NOLAServeUS SLAs requiring 7–48 hours for safety-critical issues, this department faces the most immediate accountability pressure at launch.
Section 06
The Resolution Time Scandal
How long residents actually wait vs. how long they should wait

The most alarming finding is not how many complaints go unresolved — it's how long the ones that eventually get "resolved" take to close. These are 14-year system-wide averages on clean data. They are not outliers.

525
days avg. to close a traffic signal complaint
301
days avg. to close a streetlight complaint
289
days avg. to close a drainage complaint
Average Days to Resolve by Category — Clean Data Only (0–730 day valid response times)
Excludes 290,737 records with corrupted dates from 2018 migration
Traffic Signals
525 days
Street & Traffic Signs
431 days
Streetlights
301 days
Drainage
289 days
Parks & Grass Service
183 days
Roads and Streets
134 days
Health Related
124 days
Tree Service
116 days
Healthy Homes
15 days
311 Actual Performance vs. NOLAServeUS Target SLAs
Category311 Avg (Actual)NOLAServeUS Target
Broken / damaged traffic signal
525 days
2 days
Missing / damaged signage
431 days
7 days
Street light out
301 days
7 days
Flooding / drainage
289 days
2 days
Sewer / manhole issue
289 days
2 days
Pothole / road damage
134 days
14 days
Blight / vacant property
122–141 days
30 days
Parks / green space
115 days
14 days
Illegal dumping / litter
50 days
7–14 days
⚠️ Safety-Critical FailuresA broken traffic signal averaging 525 days to resolve is a public safety crisis. A missing stop sign averaging 431 days to replace puts drivers and pedestrians at risk every single day. These are not edge cases — they are system-wide 14-year averages. They represent the clearest possible case for why an independent accountability platform like NOLAServeUS is necessary.
SELECT request_type, COUNT(*) as total,
ROUND(AVG(TO_DATE(date_closed,'MM/DD/YYYY') - TO_DATE(date_created,'MM/DD/YYYY'))::numeric,1) as avg_days
FROM nola_311_staging
WHERE (TO_DATE(date_closed,'MM/DD/YYYY') - TO_DATE(date_created,'MM/DD/YYYY')) BETWEEN 0 AND 730
GROUP BY request_type HAVING COUNT(*) > 500 ORDER BY avg_days DESC;
Section 07
Council District Equity Analysis
Are all neighborhoods served equally by city departments?

Districts C and D show the highest percentage of unresolved complaints at 11.6% each. But the most revealing finding is not the overall district rate — it's the performance of specific departments within specific districts. The Sewerage & Water Board's failure rate in District E reaches 46% — nearly half of all flooding and drainage complaints in New Orleans East are never resolved.

DistrictUnresolved RateAvg DaysMedianOpen
C — Algiers / West Bank
11.6%
87 days
15 days
12,895
D — Tremé / 7th Ward
11.6%
82 days
9 days
16,356
E — New Orleans East
10.0%
53 days
5 days
11,946
B — Uptown / Central City
9.9%
91 days
18 days
15,261
A — Lakeview / Mid-City
9.6%
95 days
23 days
14,271
Sewerage & Water Board Unresolved Rate by District
The department responsible for flooding and drainage shows dramatic geographic inequity
E — New Orleans East
46.0% unresolved
B — Uptown
43.3% unresolved
C — Algiers
39.5% unresolved
D — Tremé
38.3% unresolved
A — Mid-City
29.6% unresolved
🚨 Sewerage & Water Board Equity Crisis — District E at 46% UnresolvedIn a city that sits below sea level, where flooding is a life-safety issue, this disparity is a fundamental inequity. District E is a community still recovering from Hurricane Katrina. Nearly half of every flooding and drainage complaint filed in New Orleans East is never resolved — and average resolution times for those that eventually close reach 194 days.
Trash/Recycling by District — Volume & Response Time
465,230 total trash complaints · *District E's 25.3-day average requires scrutiny — see note below
A — Lakeview / Mid-City
83,951 complaints · 62.2 day avg
B — Uptown / Central City
78,038 complaints · 68.3 day avg
E — New Orleans East ⚠️
71,831 complaints · 25.3 day avg*
D — Tremé / Gentilly
71,000 complaints · 42.1 day avg
C — Algiers / West Bank
57,056 complaints · 50.9 day avg
* District E's 25.3-day trash average requires scrutinyDistrict E gets worse service from every other department — 46% S&WB unresolved, 26.2% Code Enforcement unresolved. A 25-day trash resolution average that is less than half of District B's 68 days is inconsistent with every other service metric in the district. The more likely explanation: residents in New Orleans East are less likely to follow up on complaints or dispute closures, so tickets get administratively closed faster without work being verified. NOLAServeUS community-verified resolution will reveal the truth.
DistrictDepartmentTotalUnresolved% OpenAvg Days
AUtility Company Collective54851493.8%63
ASewerage & Water Board2,19865129.6%264
BSewerage & Water Board1,52566143.3%169
BDept. of Code Enforcement10,7242,58124.1%141
CSewerage & Water Board1,04341239.5%246
DSewerage & Water Board1,30750138.3%199
DDept. of Code Enforcement15,8314,08525.8%122
ESewerage & Water Board65830346.0%194
EDept. of Code Enforcement14,5763,81226.2%118
EDept. of Public Works25,6295,87422.9%148
Section 08
Yearly Trends — Post-2020 Clean Data
Which complaint types are growing, declining, or disappearing?

Reliable trend analysis is only possible from 2020 onward. The clean data reveals important patterns: Trash/Recycling peaked in 2022 at 57,993 and is slowly declining. The Roads/Drainage category was quietly retired by the city after 2022. And Code Enforcement's open rate swung from 50% in 2020 to near-zero in 2021–2023 — then crashed back to 57.6% in 2024 — the clearest evidence yet that "Closed" in the 311 system means nothing without independent verification.

Code Enforcement Open Rate 2020–2025
Real data — batch closures visible in 2021–2023
60% 40% 20% 5% 0% 50.0% 0.4%⚠ 0.2%⚠ 0.1%⚠ 57.6%▲ 35.1% 2020 2021 2022 2023 2024 2025*
S&WB Open Rate by District 2020–2025
District E consistently highest — no improvement
55% 45% 35% 25% 15% Dist E 46% Dist B 43% Dist A 30% 2020 2024 2025*
⚠️ Code Enforcement Batch Closures — The Verification Problem at its Most ExtremeCode Enforcement shows 50% open in 2020 → near-zero (0.1–0.4%) in 2021–2023 → 57.6% in 2024. Near-zero open rates across three consecutive years is not genuine performance improvement — it is someone administratively batch-closing thousands of unresolved tickets. The 2024 rebound to 57.6% reveals those tickets were never actually resolved. This is the self-grading problem in its starkest form.
Category202020212022202320242025*Trend
Trash/Recycling37,66053,44357,99355,40153,20250,248↑ Peak 2022, slowly declining
Property Maintenance/Blight7,3998,2507,9346,2646,8855,432↓ Declining since 2021
Abandoned Vehicles6,9827,3418,4838,6557,8097,604↑ Peak 2023, now declining
Roads/Drainage7,0226,272916275133⚠️ Category quietly retired by city
Drainage9333,0083,9133,0065,3453,131↑ Growing — absorbed Roads/Drainage
Code Enforcement open rate50.0%0.4% ⚠0.2% ⚠0.1% ⚠57.6% ▲35.1%⚠️ Batch closures 2021–23
📋 What "Stable Data" MeansOnly records from 2020 onward with response times between 0 and 730 days are used for trend analysis. Volume counts use all records with valid date fields. Roads/Drainage disappearing after 2022 is a city categorization change — not a reduction in actual road problems.
Section 09
Baseline Department Grades
Historical performance grades to anchor the NOLAServeUS grading system at launch

Based on 12+ years of 311 data, each department receives a historical baseline grade. These will appear on the NOLAServeUS homepage at launch as "Historical Performance" indicators — giving the platform immediate credibility before a single NOLAServeUS report is filed.

A
Department of Sanitation
1.2% unresolved
A
Mosquito, Termite & Rodent Control
0.5% unresolved
B
Health Department
5.9% unresolved
B-
Dept. of Parks & Parkways
8.8% unresolved
C+
Safety and Permits
13.4% unresolved
C-
Dept. of Public Works
12.2% · 38,957 open
D+
Dept. of Code Enforcement
14.3% unresolved
D
Sewerage & Water Board
37.5% unresolved
💡 How These Grades Were CalculatedHistorical baseline grades are derived from the unresolved complaint percentage (primary factor), weighted by the severity of categories handled and complaint volume. These are self-reported figures from the 311 system and have not been independently verified — which is precisely what NOLAServeUS's community-verified resolution system will change. Utility Company Collective is excluded from grading as utilities are outside NOLAServeUS's scope.
Section 10
Implications for NOLAServeUS
What this data means for the platform's design, launch, and public narrative

This analysis validates every core design decision in NOLAServeUS and provides the factual foundation for grant applications, press outreach, and community organizing. The 311 system has operated for 14 years, accepted 1,003,064 service requests, and produced these results.

Pre-populated
Map at Launch
74,305 pending complaints with GPS ready day one
Baseline
Dept. Grades
Historical A–F grades from 14 years of data
88,495
Duplicates Prevented
Validates the community upvote system
46%
S&WB Unresolved
District E — immediate community priority
✅ Grant Application Opening Paragraph — Ready to Use"The City of New Orleans 311 system has accepted 1,003,064 service requests since 2012. Nearly half — 465,230 complaints — were about trash and illegal dumping. That is 90 complaints every single day for 14 years. The city picks it up. Residents dump again. Nothing changes. Meanwhile, broken traffic signals take 525 days to repair, and drainage complaints in New Orleans East are never resolved 46% of the time. And when the city marks a complaint 'resolved,' there is no photo, no resident confirmation, no community verification — the city grades itself. NOLAServeUS changes all of this."
The Accountability Gap — 311 Actual vs. NOLAServeUS Target Resolution Times
How far current city performance falls below what residents deserve
311 Actual (avg days)
NOLAServeUS Target (days)
Traffic Signal   311: 525 days  →  NOLAServeUS: 2 days
Streetlight   311: 301 days  →  NOLAServeUS: 7 days
Drainage   311: 289 days  →  NOLAServeUS: 2 days
Road Damage   311: 134 days  →  NOLAServeUS: 14 days
🗺️ 311 Data Integration StrategyNOLAServeUS will use the Socrata open data API (data.nola.gov/resource/2jgv-pqrq.json) for two purposes: (1) Pre-populating the public map with 74,305 currently pending 311 complaints at platform launch; (2) Duplicate detection at report submission — checking whether an existing 311 complaint already covers the issue. Write access to post reports directly into 311 is a Phase 2 goal pending partnership with DataDriven NOLA at data@nola.gov.
311 OPCD Data Analysis Report · RENIOR Development Firm LLC
Data source: City of New Orleans Open Data Portal · data.nola.gov · Dataset 2jgv-pqrq
Analysis: June 2026 · Metrics exclude 290,737 records corrupted in 2018 OPCD migration