About this Dataset

Transportation Department Permits

Applications to the Chicago Department of Transportation for permits under its jurisdiction, which typically are permits to block or otherwise affect public streets in some way. Because all permits start as applications, this dataset also serves as a list of permits granted. See more information about CDOT permits at http://www.cityofchicago.org/city/en/depts/cdot/provdrs/construction_information/svcs/online-permit-portal.html.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:14.655118
Tags: permits, streets, transportation

Tables

Table 1

@usgov.city_of_chicago_transportation_department_permits.table_1

197.76 MB
2087830 rows
47 columns


CREATE TABLE table_1 (
  "uniquekey" BIGINT,
  "applicationnumber" VARCHAR,
  "applicationtype" VARCHAR,
  "applicationdescription" VARCHAR,
  "worktype" VARCHAR,
  "worktypedescription" VARCHAR,
  "applicationstatus" VARCHAR,
  "currentmilestone" VARCHAR,
  "applicationstartdate" VARCHAR,
  "applicationenddate" VARCHAR,
  "applicationprocesseddate" VARCHAR,
  "applicationissueddate" TIMESTAMP,
  "applicationfinalizeddate" TIMESTAMP,
  "applicationexpiredate" VARCHAR,
  "applicationname" VARCHAR,
  "comments" VARCHAR,
  "totalfees" DOUBLE,
  "waivedfees" DOUBLE,
  "primarycontactlast" VARCHAR,
  "primarycontactfirst" VARCHAR,
  "primarycontactmiddle" VARCHAR,
  "primarycontactstreet" VARCHAR,
  "primarycontactstreet2" VARCHAR,
  "primarycontactcity" VARCHAR,
  "primarycontactstate" VARCHAR,
  "primarycontactzip" VARCHAR,
  "emergencycontactname" VARCHAR,
  "lastinspectionnumber" DOUBLE,
  "lastinspectiontype" VARCHAR,
  "lastinsptypedescr" VARCHAR,
  "lastinspectiondate" TIMESTAMP,
  "lastinspectionresult" VARCHAR,
  "streetnumberfrom" DOUBLE,
  "streetnumberto" DOUBLE,
  "direction" VARCHAR,
  "streetname" VARCHAR,
  "suffix" VARCHAR,
  "placement" VARCHAR,
  "streetclosure" VARCHAR,
  "detail" VARCHAR,
  "parkingmeterpostingorbagging" VARCHAR,
  "ward" DOUBLE,
  "xcoordinate" DOUBLE,
  "ycoordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);