Public Right-of-Way Use Permits - Historical
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | hwmb-iu8j |
| Name | Public Right-of-Way Use Permits - Historical |
| Attribution | City of Chicago |
| Category | Transportation |
| Tags | permits, historical |
| Created | 2012-03-30T19:38:09Z |
| Publication Date | 2014-06-05T18:12:27Z |
Description
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.
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | =========== | ========================= | ========================= | ============= | ============= |
| No | | id | ID | text | text |
| Yes | series tag | permit_number | PERMIT NUMBER | text | text |
| Yes | series tag | permit_type_code | PERMIT TYPE CODE | text | text |
| Yes | series tag | permit_type_description | PERMIT TYPE DESCRIPTION | text | text |
| Yes | series tag | company | COMPANY | text | text |
| No | | address | ADDRESS | text | text |
| Yes | series tag | location_details | LOCATION DETAILS | text | text |
| Yes | time | effective_date | EFFECTIVE DATE | calendar_date | calendar_date |
| No | | expiration_date | EXPIRATION DATE | calendar_date | calendar_date |
| Yes | series tag | permit_status_code | PERMIT STATUS CODE | text | text |
| Yes | series tag | permit_status_description | PERMIT STATUS DESCRIPTION | text | text |
| No | | last_modified_date | LAST MODIFIED DATE | calendar_date | calendar_date |
| No | | latitude | LATITUDE | number | number |
| No | | longitude | LONGITUDE | number | number |
| Yes | series tag | location | LOCATION | text | text |
Time Field
Value = effective_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss
Series Fields
Excluded Fields = id,address,expiration_date,last_modified_date,latitude,longitude
Data Commands
series e:hwmb-iu8j d:2011-01-04T00:00:00.000Z t:permit_number=777358687 t:permit_status_code=IEXPIRE t:permit_type_description="Street Opening (Curb Lane, Parkway, Sidewalk)" t:location=(41.99340537374761,-87.66051935979738) t:company="PEOPLES GAS LIGHT & COKE CO" t:permit_type_code=PKCSOPEN t:permit_status_description=Expired m:row_number.hwmb-iu8j=1
series e:hwmb-iu8j d:2011-01-04T00:00:00.000Z t:permit_number=777358687 t:permit_status_code=IEXPIRE t:permit_type_description="Street Opening (Curb Lane, Parkway, Sidewalk)" t:location=(41.993674733493634,-87.66023318180571) t:company="PEOPLES GAS LIGHT & COKE CO" t:permit_type_code=PKCSOPEN t:permit_status_description=Expired m:row_number.hwmb-iu8j=2
series e:hwmb-iu8j d:2011-01-04T00:00:00.000Z t:permit_number=777358699 t:permit_status_code=IEXPIRE t:permit_type_description="Street Opening (Curb Lane, Parkway, Sidewalk)" t:location=(42.01219414595151,-87.67471606126013) t:company="PEOPLES GAS LIGHT & COKE CO" t:permit_type_code=PKCSOPEN t:location_details="AMENDED ON JAN 31, 2011 TO EXTEND TO FEB 28, 2011" t:permit_status_description=Expired m:row_number.hwmb-iu8j=3
Meta Commands
metric m:row_number.hwmb-iu8j p:long l:"Row Number"
entity e:hwmb-iu8j l:"Public Right-of-Way Use Permits - Historical" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/hwmb-iu8j
property e:hwmb-iu8j t:meta.view v:id=hwmb-iu8j v:category=Transportation v:attributionLink=http://www.cityofchicago.org/content/city/en/depts/cdot/provdrs/permit/svcs/public_right_of_wayusepermit.html v:averageRating=0 v:name="Public Right-of-Way Use Permits - Historical" v:attribution="City of Chicago"
property e:hwmb-iu8j t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false
property e:hwmb-iu8j t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false
Top Records
| id | permit_number | permit_type_code | permit_type_description | company | address | location_details | effective_date | expiration_date | permit_status_code | permit_status_description | last_modified_date | latitude | longitude | location |
| ============================== | ============= | ================ | ============================================= | =========================== | ==================== | ================================================================= | =================== | =================== | ================== | ========================= | =================== | ================== | ================== | ======================================= |
| 518323496651832349695183235031 | 777358687 | PKCSOPEN | Street Opening (Curb Lane, Parkway, Sidewalk) | PEOPLES GAS LIGHT & COKE CO | 6136-6146 N BROADWAY | | 2011-01-04T00:00:00 | 2011-01-31T00:00:00 | IEXPIRE | Expired | 2011-01-04T15:59:26 | 41.99340537374761 | -87.66051935979738 | (41.99340537374761,-87.66051935979738) |
| 518323496651832349695183235045 | 777358687 | PKCSOPEN | Street Opening (Curb Lane, Parkway, Sidewalk) | PEOPLES GAS LIGHT & COKE CO | 6147-6155 N BROADWAY | | 2011-01-04T00:00:00 | 2011-01-31T00:00:00 | IEXPIRE | Expired | 2011-01-04T15:59:26 | 41.993674733493634 | -87.66023318180571 | (41.993674733493634,-87.66023318180571) |
| 518323507751832350845183235146 | 777358699 | PKCSOPEN | Street Opening (Curb Lane, Parkway, Sidewalk) | PEOPLES GAS LIGHT & COKE CO | 7124-7199 N CLARK ST | AMENDED ON JAN 31, 2011 TO EXTEND TO FEB 28, 2011 | 2011-01-04T00:00:00 | 2011-02-28T00:00:00 | IEXPIRE | Expired | 2011-01-31T11:12:10 | 42.01219414595151 | -87.67471606126013 | (42.01219414595151,-87.67471606126013) |
| 518448863551844886745184488831 | 781973067 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#9222639 | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T11:51:26 | | | |
| 518448912651844891435184489211 | 781973144 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#4006009M | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T11:57:56 | | | |
| 518448936351844894245184489488 | 781973182 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#1106418Q | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T12:00:57 | | | |
| 518448953851844896715184489768 | 781973221 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#2076292Q | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T12:04:35 | | | |
| 518448992651844899395184489972 | 781973271 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#2006542Q | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T12:09:22 | | | |
| 518449011251844901175184490157 | 781973308 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#4202021 | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T12:12:30 | | | |
| 518449027651844902795184490347 | 781973322 | VEHPARWC | Parking of Vehicles Citywide (Annual) | SBC ILLINOIS | | 2011 PARK WORK VEHICLES WORK TO BE PERFORMED BY AT&T VEH#2030838 | 2011-01-01T00:00:00 | 2011-12-31T00:00:00 | IEXPIRE | Expired | 2010-11-15T12:14:56 | | | |