About this Dataset

Street Construction Inspections And Corrective Action Requests

DOT's Highway Inspection & Quality Assurance (HIQA) enforces the laws and rules that govern the way utilities, plumbers, contractors, other governmental agencies, and property owners perform work on the City's sidewalks, roadways and highways. DOT's inspectors also review work sites for compliance with permit stipulations, and issue violations when they find non-compliance with the laws and rules.
Organization: City of New York
Last updated: 2020-11-10T17:06:21.815497
Tags: car, corrective-action, dash, hiqa, inspection, nov, violation

Tables

Table 1

@usgov.city_of_new_york_street_construction_inspections_and_c_5556cf2f.table_1

935.91 MB
11028476 rows
27 columns


CREATE TABLE table_1 (
  "inspectionid" BIGINT,
  "permitnumber" VARCHAR,
  "permitteename" VARCHAR,
  "permittype" VARCHAR,
  "onstreetname" VARCHAR,
  "fromstreetname" VARCHAR,
  "tostreetname" VARCHAR,
  "specificlocation" VARCHAR,
  "inspectiontype" VARCHAR,
  "inspectiondate" VARCHAR,
  "inspectionresulttype" VARCHAR,
  "inspectionremarks" VARCHAR,
  "carnumber" DOUBLE,
  "defectivecuts" DOUBLE,
  "feetfromcrossstreet" DOUBLE,
  "feetfromcurb" DOUBLE,
  "carcomments" VARCHAR,
  "laneofcut" VARCHAR,
  "trafficflow" VARCHAR,
  "crossstreetname" VARCHAR,
  "curbstreetname" VARCHAR,
  "novnumber" DOUBLE,
  "novcode" VARCHAR,
  "novcodedescription" VARCHAR,
  "detailsofviolation" VARCHAR,
  "createdon" VARCHAR,
  "modifiedon" VARCHAR
);