About this Dataset

Sidewalk Management Database - Inspection

Sidewalk Management System is used to track and organize inspections, volitions and the status of New York City sidewalks Identifies locations where DOT inspectors performed sidewalk inspections for defects.
For more information please visit NYC DOT website: www.nyc.gov/sidewalks
Organization: City of New York
Last updated: 2025-01-31T23:01:50.059168
Tags: inspection, repinspection, sidewalk, sidewalk-management-database, tree, violations

Tables

Table 1

@usgov.city_of_new_york_sidewalk_management_database_inspection.table_1

4.02 MB
381,274 rows
17 columns

CREATE TABLE table_1 (
  "inspection_id" BIGINT,
  "no_violation_found" VARCHAR,
  "city_do_it" VARCHAR,
  "owner_will_do_it" VARCHAR,
  "capital_project_conflict_flag" VARCHAR,
  "capital_project_conflict_s" VARCHAR  -- Capital Project Conflict(s),
  "cancel" VARCHAR,
  "inspection_date" VARCHAR,
  "is_311_inspection" VARCHAR,
  "material_id" DOUBLE,
  "pickup_sidewalk" VARCHAR,
  "curb311" VARCHAR,
  "pickup_curb" VARCHAR,
  "other" VARCHAR,
  "correspondence" VARCHAR,
  "damage_id" BIGINT,
  "damage_type_code" VARCHAR
);