About this Dataset

Public Right-of-Way Use Permits - Historical

As described in http://bit.ly/cdotpermitspost, the function of this dataset was replaced by https://data.cityofchicago.org/d/pubx-yq2d on 12/7/2015. This dataset is historical-only.

The Chicago Department of Transportation (CDOT) reviews applications for permits for the temporary use of the public way for construction projects, parades, festivals, block parties, athletic events, etc.This dataset includes permits applied for, issued, amended and expired with permit start dates beginning January 1, 2011. Note a permit may be amended if any details are changed after the initial issuance. For more information about Public Right-of-Way Use Permits, go to http://bit.ly/15ypkkL.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:59.499150
Tags: historical, permits

Tables

Table 1

@usgov.city_of_chicago_public_right_of_way_use_permits_historical.table_1

90.35 MB
1082526 rows
15 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "permit_number" BIGINT,
  "permit_type_code" VARCHAR,
  "permit_type_description" VARCHAR,
  "company" VARCHAR,
  "address" VARCHAR,
  "location_details" VARCHAR,
  "effective_date" VARCHAR,
  "expiration_date" VARCHAR,
  "permit_status_code" VARCHAR,
  "permit_status_description" VARCHAR,
  "last_modified_date" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);