NYC Sidewalk Violations Database with Defect and Location Details

Sidewalk Management System tracks inspections and violations for New York City sidewalks. The dataset includes columns for specific defect types like TRIP_HAZ and BROKEN, location identifiers like BBLID and ONSTNAME, and violation process dates like POST_DATE and VIssueDate. It is hosted by data.cityofnewyork.us and was last updated on 2026-04-03.

Use Cases

• Predict violation issuance (VIssueDate) based on defect types (TRIP_HAZ, BROKEN, SW_MISSING) and location (BBLID, CB) using classification models.
• Analyze seasonal or temporal trends in sidewalk inspections by aggregating data using EntryDate and POST_DATE.
• Cluster neighborhoods (CB) based on common violation types (OTHER_DEF, PATCHWORK) and violation status (FLAG, VDismissDate) for targeted maintenance planning.
• Forecast repair timelines by modeling the relationship between defect severity (columns suggest various defects), square footage (SQ_FEET), and certification date (CERTI_DATE).

Strengths

• Dataset provides 27 distinct columns covering defect types, location, and violation process details.
• Data is sourced from an official city platform (data.cityofnewyork.us) for NYC sidewalk management.
• Available in multiple machine-readable formats including CSV, JSON, XML, and RDF.

Limitations

• Row count and total dataset size are unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality and completeness require manual inspection after download.
• License and author information are unknown, which may affect usage rights.

Provenance

Source

data.cityofnewyork.us

Collection Method

Likely collected through official New York City Department of Transportation (DOT) sidewalk inspection and violation processes.

Freshness

Last updated 2026-04-03 12:04:22; freshness should be verified.

Geography

New York City, based on description and column names like CB (Community Board) and NYC DOT reference.