Name: Encroachments And Defacements
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Encroachments And Defacements

Encroachments System tracks actions taken in response to 311 complaints, and inspections requested by property owners.
Organization: City of New York
Last updated: 2020-11-10T17:04:02.219668
Tags: defacement, encroachment, hiqa, inspection, nov, sidewalk, violation

Tables

Table 1

@usgov.city_of_new_york_encroachments_and_defacements.table_1

20.92 MB
1097474 rows
25 columns


CREATE TABLE table_1 (
  "complaintid" BIGINT,
  "srnumber" VARCHAR,
  "complainttype" VARCHAR,
  "borough" VARCHAR,
  "block" DOUBLE,
  "lot" DOUBLE,
  "number" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" VARCHAR,
  "unit" VARCHAR,
  "initialinspectiondate" VARCHAR,
  "initialinspectionresults" VARCHAR,
  "ordermailingdate" TIMESTAMP,
  "postinginspectiondate" DOUBLE,
  "followupinspectiondate" TIMESTAMP,
  "daysbetween" BIGINT,
  "closeddate" VARCHAR,
  "reinspectiondate" TIMESTAMP,
  "reinspectionresult" VARCHAR,
  "novnumber" DOUBLE,
  "novcode" VARCHAR,
  "novdate" TIMESTAMP,
  "novdescription" VARCHAR
);