Applications to the Chicago Department of Transportation for permits under its jurisdiction where the work type is "Filming." These permits 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.
This dataset has the following 43 columns:
Column Name | API Column Name | Data Type | Description |
---|---|---|---|
APPLICATIONNUMBER | applicationnumber | text | Unique number for the application that becomes the permit number when issued. |
APPLICATIONTYPE | applicationtype | text | Code for the type of permit. Permits may be categorized further by the WORKTYPE. |
APPLICATIONDESCRIPTION | applicationdescription | text | Type of permit. |
WORKTYPE | worktype | text | Code for the sub-category, if any, of the permit application. Only one work type per application is allowed. |
WORKTYPEDESCRIPTION | worktypedescription | text | Sub-category, if any, of the permit application. Only one work type per application is allowed. |
APPLICATIONSTATUS | applicationstatus | text | Overall status of the application. Typically open during the application process and issued, then closed once the permit has expired. |
CURRENTMILESTONE | currentmilestone | text | The current step in the permitting life cycle. |
APPLICATIONSTARTDATE | applicationstartdate | calendar_date | Permit start date. Most often requested by the applicant but could be updated as the permit is reviewed by CDOT. |
APPLICATIONENDDATE | applicationenddate | calendar_date | Permit End date. Most often requested by the applicant but could be updated as the permit is reviewed by CDOT. |
APPLICATIONPROCESSEDDATE | applicationprocesseddate | calendar_date | This is the date when the permit reaches the review milestone, means the date CDOT began reviewing the application. |
APPLICATIONISSUEDDATE | applicationissueddate | calendar_date | Date the permit was issued by CDOT. Set once all the reviews, fees, etc. are paid (where applicable). |
APPLICATIONFINALIZEDDATE | applicationfinalizeddate | calendar_date | Date the permit was closed (either after the permit has expired plus a grace period or after an inspector marks the work complete). |
APPLICATIONEXPIREDATE | applicationexpiredate | calendar_date | Date the permit will expire (typically same as permit end date). Applicant may ask for date extensions where the end date is updated and will be reflected here once re-approved by CDOT. |
APPLICATIONNAME | applicationname | text | Applicants can put a project name on their applications in this field. For converted data 1/1/2013 to 11/13/2015, the old permit number will be placed in this field. |
COMMENTS | comments | text | Applicants can place a description of the work here. |
TOTALFEES | totalfees | number | Total permit fees for this permit calculated based on the work being carried out and location. See fee schedule for further information, available on the CDOT permit portal, http://www.cityofchicago.org/city/en/depts/cdot/provdrs/construction_information/svcs/online-permit-portal.html. |
WAIVEDFEES | waivedfees | number | If any fees were waived for this permit, the amount waived will be here. Possible reasons for waived fees include city contracts, city departments, ordinances, and franchise agreements with the City. |
PRIMARYCONTACTLAST | primarycontactlast | text | The last name of the primary applicant for the permit. If an employee applied on behalf of a company, the company name will appear. |
PRIMARYCONTACTFIRST | primarycontactfirst | text | First name of the primary applicant, if not a company. |
PRIMARYCONTACTMIDDLE | primarycontactmiddle | text | Middle initial of the primary applicant, if not a company. |
PRIMARYCONTACTSTREET | primarycontactstreet | text | Street address of the primary applicant. |
PRIMARYCONTACTSTREET2 | primarycontactstreet2 | text | Street address 2nd line of the primary applicant. |
PRIMARYCONTACTCITY | primarycontactcity | text | City of the primary applicant. |
PRIMARYCONTACTSTATE | primarycontactstate | text | State of the primary applicant. |
PRIMARYCONTACTZIP | primarycontactzip | text | ZIP Code of the primary applicant. |
EMERGENCYCONTACTNAME | emergencycontactname | text | Person to contact in an emergency as listed by the applicant during the permit application process. |
LASTINSPECTIONNUMBER | lastinspectionnumber | number | Once a permit is issued, typically an inspection is created for CDOT Inspectors to use onsite. Once an inspection is completed, another inspection may be generated or if the work is finished, the permit is closed. This is the number of the last inspection. |
LASTINSPECTIONTYPE | lastinspectiontype | text | Code for the type of inspection generated for the issued permit. Typically this will match the type of permit although special inspection types are available for stop work. |
LASTINSPTYPEDESCR | lastinsptypedescr | text | Description of the last inspection completed against this permit. |
LASTINSPECTIONDATE | lastinspectiondate | calendar_date | Date of the last inspection. |
LASTINSPECTIONRESULT | lastinspectionresult | text | The result of the last inspection, if completed. |
STREETNUMBERFROM | streetnumberfrom | number | The start of the address range for the permit location. For multiple locations on a permit, there will be multiple rows in the dataset. |
STREETNUMBERTO | streetnumberto | number | The end of the address range for the permit location. For multiple locations on a permit, there will be multiple rows in the dataset. |
DIRECTION | direction | text | The street direction for the permit location. For multiple locations on a permit, there will be multiple rows in the dataset. |
STREETNAME | streetname | text | The street name for the permit location. For multiple locations on a permit, there will be multiple rows in the dataset. |
SUFFIX | suffix | text | The street name suffix for the permit location. For multiple locations on a permit, there will be multiple rows in the dataset. |
PLACEMENT | placement | text | Additional information about the permit location. This column may also include detour information. |
STREETCLOSURE | streetclosure | text | Type of street closure, if any, associated with the location. |
DETAIL | detail | text | Detail information about the permit application. |
PARKINGMETERPOSTINGORBAGGING | parkingmeterpostingorbagging | text | Indicates if any parking meter bagging or posting of no parking signs is requested on the permit application. |
LATITUDE | latitude | number | Latitude of the start of the address range. |
LONGITUDE | longitude | number | Longitude of the start of the address range. |
LOCATION | location | location | Location of the start of the address range. |