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 - All Tree Damage (ATD)

j6v2-6uxqTransportation13 columns
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. Tracks properties where all sidewalk defects on the tax lot are due to trees/tree roots (All Tree Defects - ATD) For more information please visit NYC DOT website: www.nyc.gov/sidewalks
View on NYC Open Data↗

Quality

A90.4 / 100

From a 500-row sample across 10 columns.

completeness90/ 25% weight
consistency65/ 20% weight
accuracy99/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Sidewalk Management Database - Violations0.61
    joins onbblidhouse_numcb+2
  • Street Resurfacing Schedule0.36
  • Protected Streets Block (Dataset)0.33
  • TLC New Driver Application Status0.33
  • Street Closures due to Construction Activities by Intersection0.32
  • Routes0.32
  • Open Restaurants Inspections (Historical)0.31

Sample rows

atdidatd_numberbblidviolationidatdissuedatecbhouse_numonstnameatddismissed
1ATD-1-1760491960222019-10-05T00:00:00.0007153WEST 91 STREETNo
2ATD-1-2742831959882019-10-05T00:00:00.000735WEST 95 STREET

Columns

13 queryable · 13 profiled

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

FieldTypeDescriptionNullValues
atdidintegerA system generated numerical value assigned to each ATD entry. A sequential count on the number of entries in the database.0%234
atd_numbertextA combination of the ATD Suffix (A system generated numerical value assigned to each ATD by borough) and borough code.0%ATD-1-10ATD-1-100ATD-1-101
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%759894260560257189
violationidintegerA sequential count for the sidewalk violations.57%

Query this from your own app

GET /api/datasets/j6v2-6uxq
GET /api/datasets/j6v2-6uxq/quality
GET /api/datasets/j6v2-6uxq/related
GET /api/columns?dataset=j6v2-6uxq
  • Street Closures due to Construction Activities by Block0.31
    • No
    3ATD-1-31369922000132020-06-01T00:00:00.000855MARBLE HILL AVENUENo
    4ATD-1-41369571999562020-07-20T00:00:00.000820FT CHARLES PLACENo
    5ATD-1-5786132026222020-06-01T00:00:00.0007342WEST 84 STREETNo
    6ATD-1-6786142026552020-06-01T00:00:00.0007344WEST 84 STREETNo
    7ATD-1-7916522027622020-06-01T00:00:00.000848EAST 64 STREETNo
    8ATD-1-8918032049632020-06-01T00:00:00.000858AEAST 66 STREETNo
    9ATD-1-9917692049092020-06-01T00:00:00.000864EAST 66 STREETNo
    10ATD-1-10243352051752020-06-01T00:00:00.000218WEST 9 STREETNo
    28500834837960
    inspectionidintegerUnique five digit numerical ID used to track inspection records.43%397498897189189
    reinspectionidintegerSix digit identifier to uniquely identify the inspector for the reinspection.98%310593241032412
    inspect_datedatetimeThe date the sidewalk inspection was performed.41%2023-05-19T00:00:00.0002023-08-16T00:00:00.0002023-05-22T00:00:00.000
    atdissuedatedatetimeThe date an ATD was determined based on an inspection.0%2020-08-13T00:00:00.0002020-08-12T00:00:00.0002020-08-20T00:00:00.000
    cbcategoricalThe New York City Community Board number.0%12116of 19
    house_numtextThe house number of the address where the violation was issued.0%155527
    onstnametextThe street name where the ATD was found.0%JEFFERSON AVE.45TH ST.46TH ST.
    atddismissedcategoricalThe all tree damage on the sidewalk was resolved.0%NoYesof 2
    atddismissedondatetimeThe date the violation was resolved.97%2021-11-15T09:55:29.0002021-11-15T09:57:13.0002021-11-15T10:51:54.000