About this Dataset

Sidewalk Management Database - All Tree Damage (ATD)

Sidewalk Management System is used to track and organize inspections, volitions and the status of New York City sidewalks.
Tracks properties where all sidewalk defects on the taxlot are due to trees/tree roots (All Tree Defects - ATD)
For more information please visit NYC DOT website: www.nyc.gov/sidewalks
Organization: City of New York
Last updated: 2025-01-31T23:04:46.397222
Tags: inspection, repinspection, sidewalk, sidewalk-management-database, tree, violations

Tables

Table 1

@usgov.city_of_new_york_sidewalk_management_database_all_tree_643e050a.table_1

501.1 kB
12,971 rows
13 columns

CREATE TABLE table_1 (
  "atdid" BIGINT,
  "atd_number" VARCHAR,
  "bblid" BIGINT,
  "violationid" DOUBLE,
  "inspectionid" DOUBLE,
  "reinspectionid" DOUBLE,
  "inspect_date" TIMESTAMP,
  "atdissuedate" TIMESTAMP,
  "cb" DOUBLE,
  "house_num" VARCHAR,
  "onstname" VARCHAR,
  "atddismissed" VARCHAR,
  "atddismissedon" VARCHAR
);