About this Dataset

Street Construction Permits (2022-Present)

DOT issues over 150 different types of sidewalk and roadway construction permits to utilities, contractors, government agencies and homeowners. Permits cover activities such as street openings, sidewalk construction and installing canopies over sidewalks. The core permit data, including permittee, type of permit, date issued, location. Street Construction Permits 2013-2021: https://data.cityofnewyork.us/Transportation/Street-Construction-Permits-2013-2021-/c9sj-fmsg
Organization: City of New York
Last updated: 2020-11-10T17:05:27.445799
Tags: construction, cut, mosaics, nycstreets, ocmc, permit, street-work

Tables

Table 1

@usgov.city_of_new_york_street_construction_permits.table_1

180.73 MB
2,994,405 rows
37 columns

CREATE TABLE table_1 (
  "permitnumber" VARCHAR,
  "applicationtrackingid" DOUBLE,
  "sequencenumber" DOUBLE,
  "applicationtypeshortdesc" VARCHAR,
  "permitstatusid" VARCHAR,
  "permitstatusshortdesc" VARCHAR,
  "permitseriesid" BIGINT,
  "permitseriesshortdesc" VARCHAR,
  "permittypeid" VARCHAR,
  "permittypedesc" VARCHAR,
  "permitnumberofzones" DOUBLE,
  "permitlinearfeet" DOUBLE,
  "permittotalsqfeet" DOUBLE,
  "permitestimatednumberofcuts" DOUBLE,
  "equipmenttypedesc" VARCHAR,
  "numberofcontainers" DOUBLE,
  "numberofminicontainers" DOUBLE,
  "specificstipulations" VARCHAR,
  "previouspermitnumber" VARCHAR,
  "nextpermitnumber" VARCHAR,
  "emergencyissuedate" VARCHAR,
  "permitissuedate" VARCHAR,
  "issuedworkstartdate" VARCHAR,
  "issuedworkenddate" VARCHAR,
  "boroughname" VARCHAR,
  "permithousenumber" VARCHAR,
  "onstreetname" VARCHAR,
  "fromstreetname" VARCHAR,
  "tostreetname" VARCHAR,
  "permitteename" VARCHAR,
  "permitpurposecomments" VARCHAR,
  "permitlocationcomments" VARCHAR,
  "pavementshortdesc" VARCHAR,
  "sidewalkshortdesc" VARCHAR,
  "createdon" VARCHAR,
  "modifiedon" VARCHAR,
  "oftcode" VARCHAR
);