article · ~4 min · live data

Philadelphia's illegal-dumping hot spots, by zip code

In 2024, residents filed 0 illegal-dumping reports across 0 Philadelphia zip codes. They were not evenly distributed.

Illegal dumping is one of the categories the City of Philadelphia tracks in 311. Anyone can file a report; the city assigns it to a sanitation crew. In 2024, 0 dumping incidents were reported across 0 zip codes — but the top 0 alone accounted for 0 of those.

The bar chart above shows the 0 loudest zip codes. The map below widens the lens to every zip that filed at least one report in 2024. Darker fill means more reports; hover any polygon for the exact count.

Drill into the underlying data on the dataset page — the same curated views or the SQL playground will let you slice it however you want — by category, by date, by neighborhood.

Data Sources

Primary dataset: Philadelphia 311 service-and-information requests (public_cases_fc) via phl.carto.com. Filtered to service_name = 'Illegal Dumping', 2024 only. Fetched at runtime through the Cloudflare Worker proxy.

Queries: dumpingByZipSql(2024) for the top-0 bar chart, dumpingAllZipsSql(2024) for the choropleth, and dumpingByDowForZipSql(2024, '') for the day-of-week breakdown of the leader. Defined in src/lib/data/datasets/philly-311.ts.

Methodology & caveats: The curated views and the SQL playground let you slice the same data by category, date, or neighborhood. "Sunday trough" / "weekday peak" comparisons use the same per-zip day-of-week roll-up returned by the third query above. Neighborhood-name annotations for are intentional navigation cues; no neighborhood-attribute fields are joined into the queries.