cityofchicago/cdph-environmental-hold-on-cityissued-permits-and-6gqn-e2ij
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

CDPH Environmental Hold on City-Issued Permits and LUST NFR

This dataset contains environmental holds placed by the Department of Environment (DOE) up to December 31, 2011 and by the Department of Public Health (CDPH) post December 31, 2011 on construction-related permits issued by the City of Chicago. On January 1, 2012, the DOE was disbanded and all its inspection, permitting, and enforcement authorities were transferred to the CDPH. This dataset also contains No Further Remediation Letters (NFRs) received by the DOE or the CDPH for properties that have been cleaned up under the Illinois Environmental Protections Agency’s (IEPA) Leaking Underground Storage Tank (LUST) program. Throrium holds in this dataset ends November 15, 2016.

Data fields requiring description are detailed below.

APPLICATION ID: Unique identifier of record.

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.

TYPE: Specifies the type of permit hold placed on a property or the hold released on an individual permit. HIGHWAY AUTHORITY AGREEMENT is a permit hold placed on construction projects in the public right-of-way at certain locations in the City of Chicago. Refer to http://tinyurl.com/bn3grwt for more information. A THORIUM PERMIT HOLD is a permit hold placed on select properties in the Streeterville area for thorium contamination. Refer to http://tinyurl.com/d6wth39 . A THORIUM PERMIT HOLD RELEASE indicates that an applicant has complied with the necessary requirements and the Thorium Permit Hold has been lifted on the permit application. An NFR LUST is not a permit hold but the property may have certain land use restrictions or requirements (i.e. institutional or engineering controls) to prevent or minimize exposure of contaminants that may still be present at the property.

DATE: Date the record was entered into the database.

COMMENT: Comments relating to the hold or release.

DATA SOURCE: The city department that placed or released the hold.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/cdph-environmental-hold-on-cityissued-permits-and-6gqn-e2ij\".\"cdph_environmental_hold_on_cityissued_permits_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • cdph_environmental_hold_on_cityissued_permits_and