Sidewalk Management Database - Built by US Government | Demographics and Population Studies

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.17 MB
104974 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
);