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

About this Dataset

Sidewalk Management Database - Violations

Sidewalk Management System is used to track and organize inspections, volitions and the status of New York City sidewalks. Identifies a Notice of Violation has been issued for a sidewalk defect.
For more information please visit NYC DOT website: www.nyc.gov/sidewalks
Organization: City of New York
Last updated: 2025-01-31T22:59:02.701200
Tags: inspection, repinspection, sidewalk, sidewalk-management-database, tree, violations

Tables

Table 1

@usgov.city_of_new_york_sidewalk_management_database_violations.table_1

13.91 MB
305574 rows
27 columns


CREATE TABLE table_1 (
  "broken" VARCHAR,
  "cb" BIGINT,
  "certi_date" VARCHAR,
  "contract" VARCHAR,
  "entrydate" VARCHAR,
  "flag" VARCHAR,
  "frstname" VARCHAR,
  "grace_pd" BIGINT,
  "hardware" VARCHAR,
  "house_num" VARCHAR,
  "integrity" VARCHAR,
  "onfrtocode" VARCHAR,
  "onstname" VARCHAR,
  "other_def" VARCHAR,
  "patchwork" VARCHAR,
  "post_date" VARCHAR,
  "slope" VARCHAR,
  "sq_feet" DOUBLE,
  "sw_missing" VARCHAR,
  "swv_number" BIGINT,
  "tostname" VARCHAR,
  "trip_haz" VARCHAR,
  "undermined" VARCHAR,
  "vdismissdate" VARCHAR,
  "violationid" BIGINT,
  "vissuedate" TIMESTAMP,
  "bblid" BIGINT
);