Constituent requests for city services

Vacant Commercial Sales Determined to be Arms-Length and Verified by Assessor's Office Staff.

Allows home builders the opportunity to use authorized third-party inspectors to perform certain required inspections

Request for Service

Environmental complaints received by the Department of Environment (DOE) from January 1993 to December 31, 2011 and by the Department of Public Health (CDPH) since January 1, 2012. On January 1, 2012, the DOE was disbanded and all its inspection, permitting, and enforcement authorities were transferred to the CDPH. Data fields requiring description are detailed below. COMPLAINT ID: This is the unique identifier of the complaint incident. COMPLAINT TYPE: Specifies the type of complaint. CDPH complaint types are “Abandoned Site”, “Air Pollution Work Order”, “Asbestos Work Order”, “Construction and Demolition”, “Toxics Hazardous Materials Work Order”, ”Illegal Dumping Work Order”, “Noise Complaint”, “Permits Issued by DOE Work Order”, “Recycling Work Order”, “Service Stations/Storage Tanks Work Order”, “Vehicle Idling Work Order”, and “Water Pollution.” For consistency, historic DOE complaint types were renamed to match the most appropriate CDPH complaint type. DOE complaint types that had no matches are designated as “Other.” MAPPED LOCATION: Contains latitude/longitude coordinates of the site as determined through the Chicago Open Data Portal’s geocoding engine. In instances where the facility address is a range, the lower number (the value in the “Street Number From” column) is used for geocoding. For example, for the range address 1000-1005 S Wabash Ave, the Mapped Location would be the coordinates for 1000 S Wabash Ave. INSPECTOR: Contains the badge or ID number of the inspector or engineer who conducted the compliant inspection. COMPLAINT DATE: Date complaint was received by the department. COMPLAINT DETAIL: Brief description of the nature of the complaint. INSPECTION LOG: This is the inspector’s narrative log of the complaint inspection. DATA SOURCE: The city department that collected the data.

All open rodent baiting requests and rat complaints made to 311 and all requests completed since January 1, 2011. The Department of Streets & Sanitation investigates reported rat sightings. Alley conditions are examined. If any damaged carts are identified, Sanitation Ward Offices, which distribute the carts are notified. Rodenticide is placed in rat burrows to eradicate nests. 311 sometimes receives duplicate rat complaints and requests for rodent baiting. Requests that have been labeled as Duplicates are in the same geographic area and have been entered into 311’s Customer Service Requests (CSR) system at around the same time as a previous request. Duplicate reports/requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.

All Contact Management Cases with Call Type, Call Status, and Work Group fields, including Internal and External as of 1-1-2013 to present

Violations issued by the Department of Buildings in the City of Chicago from 2006 to the present. The dataset contains more than 1 million records/rows of data and cannot be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Wordpad, to view and search. Violations are always associated to an inspection and there can be multiple violation records to one(1) inspection record. Data fields requiring description are detailed below. VIOLATION DATE: The date the violation was cited. INSPECTION CATEGORY: Inspections are categorized by one of the following: COMPLAINT – Inspection is a result of a 311 Complaint PERIODIC – Inspection is a result of recurring inspection (typically on an annual cycle) PERMIT – Inspection is a result of a Permit REGISTRATION – Inspection is a result of a Registration (typically Vacant Building Registration) PROPERTY GROUP: Properties (lots) in the City of Chicago can typically have multiple point addresses, range addresses and buildings. Examples are corner lots, large lots, lots with front and rear buildings, etc.. As a result, inspections (and their associated violations), permits and complaints related to a single property could have different addresses. This problem can be reconciled by using Property Group. All point and range addresses for a property are assigned the same Property Group key. Data Owner: Buildings Time Period: January 1, 2006 to present Frequency: Data is updated daily Related Applications: Building Data Warehouse http://www.cityofchicago.org/city/en/depts/bldgs/provdrs/inspect/svcs/building_violationsonline.html

Vacant Buildings located throughout the City of Baltimore. To be updated twice a month, or as needed.

The location of buildings, inspections and violations that were issued by the San Francisco Department of Building Inspection (DBI), San Francisco Department of Health (SFDPH), and The San Francisco Fire Department (SFFD) for 1/2008 – 8/2013 for residential buildings in San Francisco. This dataset adheres to the House Facts Data Standard version 1.2 - which is a government open data standard that provides a uniform format for reporting governmental data on the regulation of health and safety laws for residential housing in a machine readable format. The specification links data to the residential building understanding that a single building may have multiple dwelling units and multiple owners. For more information about the standard, please see https://github.com/codeforamerica/housefacts_spec