About this Dataset

Sidewalk Management Database - Built

Sidewalk Management System is used to track and organize inspections, volitions 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
Organization: City of New York
Last updated: 2025-01-31T23:09:02.498967
Tags: inspection, repinspection, sidewalk, sidewalk-management-database, tree, violations

Tables

Table 1

@usgov.city_of_new_york_sidewalk_management_database_built.table_1

1.22 MB
104,974 rows
14 columns

CREATE TABLE table_1 (
  "bblid" BIGINT,
  "dot_contstruct_date" TIMESTAMP,
  "dbo" VARCHAR,
  "dbo_date" TIMESTAMP,
  "contract" VARCHAR,
  "atdbystreettree" VARCHAR,
  "portionofdefectbystreettree" VARCHAR,
  "noneofdefectbystreettree" VARCHAR,
  "totalsqftsidewalkrepaired" DOUBLE,
  "totallfcurbrepaired" DOUBLE,
  "totalcosttoconstruct" DOUBLE,
  "totalsqftsdwrepairedstreettreeonly" DOUBLE,
  "totallfcurbrepairedstreettreeonly" DOUBLE,
  "totalcostofrepairstreettreeonly" DOUBLE
);