NYC Sidewalk Management Database: Repairs and Inspections

The dataset tracks sidewalk and curb repairs performed under New York City Department of Transportation (NYC DOT) contracts or privately, with the most recent platform update noted as May 2026. It is used to organize inspections, violations, and repair statuses across the city. Columns suggest it records repair costs, dimensions, and the involvement of street trees in sidewalk defects.

Use Cases

• Analyzing repair costs and areas by contract using TotalCostToConstruct and TotalSQFTSidewalkRepaired.
• Assessing the impact of street trees on sidewalk defects using ATDByStreetTree, PortionofDefectByStreetTree, and NoneofDefectByStreetTree.
• Tracking repair timelines and contractor performance using DOT_CONTSTRUCT_DATE, DBO_Date, and CONTRACT.
• Calculating total linear feet of curb repaired across projects using TotalLFCurbRepaired.

Strengths

• Cross-platform presence on Socrata and Data.gov indicates official use and importance.
• Specific columns for financial and physical dimensions (e.g., TotalCostToConstruct, TotalSQFTSidewalkRepaired) allow for quantitative analysis.
• Includes fields to isolate repairs related to street trees (e.g., TotalSQFTSDWRepairedStreetTreeOnly), enabling focused environmental impact studies.

Limitations

• Key metadata is missing or conflicting: row counts, dataset size, and license information are not provided on any platform.
• The 'last updated' dates conflict between sources (Socrata shows May 2026, Data.gov shows April 2026), casting doubt on temporal accuracy.
• The Data.gov source lists column names as 'unknown', reducing the completeness of available schema information.

Provenance

Source

City of New York, Department of Transportation (NYC DOT)

Collection Method

Likely collected through NYC DOT's Sidewalk Management System tracking inspections, violations, and repair contracts.

Freshness

2026-05-29 12:00:12 (from Socrata)

Geography

New York City