Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Sidewalk Management Database - Built

ugc8-s3f6Transportation14 columns
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. Tracks the repairs that were performed via NYC DOT's Prior Notice Sidewalk Repair contracts and on properties that were repaired privately or by other organizations. For more information please visit NYC DOT website: www.nyc.gov/sidewalks
View on NYC Open Data↗

Quality

C73.3 / 100

From a 500-row sample across 14 columns.

completeness25/ 25% weight
consistency68/ 20% weight
accuracy92/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Sidewalk Management Database - All Tree Damage (ATD)0.66
    joins onbblid
  • Sidewalk Management Database - Inspection0.63
  • Sidewalk Management Database - ReInspection0.61
  • Sidewalk Management Database - Violations0.59
    joins onbblidcontract
  • Street Resurfacing Schedule0.35
  • TLC New Driver Application Status0.32
  • Open Restaurants Inspections (Historical)

Sample rows

bbliddot_contstruct_datecontractdbodbo_date
7240022022-03-22T00:00:00.000HWS2020Q2——
7262502021-11-03T00:00:00.000HWS2020Q1——
7500402022-03-22T00:00:00.000HWS2020Q2——
7578852022-03-21T00:00:00.000HWS2020Q2—

Columns

14 queryable · 14 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
bblidintegerThe ID number assigned to a Borough-Block-Lot (BBL) value in the Lotinfo table; BBLID is an identifier for a BBL and should not be interpreted as the BBL itself.0%147077163585475040
dot_contstruct_datedatetimeThe last time the taxlot was repaired via a Prior Notice Sidewalk Repair contract.39%1998-09-15T00:00:00.0001993-01-01T00:00:00.0001998-06-15T00:00:00.000
dbocategoricalSidewalk repair was performed by a contractor/private entity other than a Prior Notice Sidewalk Repair contract.5%NoYesof 2
dbo_datedatetimeThe date the taxlot was found to DBO.81%

Query this from your own app

GET /api/datasets/ugc8-s3f6
GET /api/datasets/ugc8-s3f6/quality
GET /api/datasets/ugc8-s3f6/related
GET /api/columns?dataset=ugc8-s3f6
0.31
  • Routes0.31
    • —
    7580052021-10-18T00:00:00.000HWS2020Q1——
    7580932021-10-18T00:00:00.000HWS2020Q1——
    825496——Yes2014-12-18T00:00:00.000
    4245462012-03-30T00:00:00.000HWS2011KNo—
    7778882022-10-12T00:00:00.000HWS2020Q1——
    2232472004-06-18T00:00:00.000HWS2003XNo—
    2010-06-01T00:00:00.0002013-12-01T00:00:00.0002014-12-13T00:00:00.000
    contracttextThis field identifies the Prior Notice contract number for performed sidewalk repairs.50%HWS2016K2HWS2016K1HWS2002KR
    atdbystreettreecategoricalIdentifies that all sidewalk defects repaired that were caused by a City tree96%NoYesof 2
    portionofdefectbystreettreecategoricalIdentifies that a portion of sidewalk defects repaired were caused by a City tree.96%NoYesof 2
    noneofdefectbystreettreecategoricalIdentifies that a City tree did not cause sidewalk defects at the lot that was repaired.96%NoYesof 2
    totalsqftsidewalkrepairedintegerTotal Sq. Ft. of sidewalk repaired at taxlot96%0100190
    totallfcurbrepairedintegerTotal linear foot of curb repaired at taxlot96%0.02025
    totalcosttoconstructfloatTotal cost to the City to repair the taxlot96%0.018504620
    totalsqftsdwrepairedstreintegerTotal Sq. Ft. of sidewalk repaired where defects were caused by trees96%010050
    totallfcurbrepairedstreefloatTotal linear foot of sidewalk repaired where defects were caused by trees96%02010
    totalcostofrepairstreettfloatTotal cost to the City to repair defects caused by trees96%0.01850925