Safe Drinking Water Facilities Information System for Pennsylvania 2018 - Current Environmental Protection

Safe Drinking Water Information System (SDWIS) is EPA’s national database that manages and collects public water system information from states, including reports of drinking water standard violations, reporting and monitoring violations, and other basic information. The data derived in the State of Pennsylvania is published and searchable online on the www.pa.gov website. This set contains the Water System Facility data, which will be updated annually for the prior calendar year in the first Quarter of the following year.

Beach Lab Data

The Chicago Park District collects and analyzes water samples from beaches along Chicago’s Lake Michigan lakefront. The Chicago Park District partners with the University of Illinois at Chicago Department of Public Health Laboratory to analyze water samples using a new DNA testing method called Rapid Testing Method (qPCR analysis) which tests for Enterococci in order to monitor swimming safety. The rapid testing method (qPCR analysis) is a new method that measures levels of pathogenic DNA in beach water. Unlike the culture based test that requires up to 24 hours of processing, the new rapid testing method requires a 4-5 hours for results. The Chicago Park District can use results of the rapid test to notify the public when levels exceed UPEPA recommended levels, which is 1000* CCE. When DNA bacteria levels exceed 1000 CCE, a yellow swim advisory flag is implemented. For more information please refer to the USEPA Recreational Water Quality Criteria (http://water.epa.gov/scitech/swguidance/standards/criteria/health/recreation). Historically, the Chicago Park District used the culture based analysis method and statistical prediction models to monitor beach water quality. The culture based method tests for Escherichia coli (E. coli) bacteria which is an indicator species for the presence of disease-causing bacteria, viruses, and protozoans that may pose health risks to the public. This method requires 18-24 hours of processing to receive results. The Chicago Park District would use results of the culture based method to notify the public when levels exceed UPEPA recommended levels, which is 235* CFU. When bacteria levels exceed 235 CFU, a yellow swim advisory flag was implemented. This standard is still used at most beaches throughout the Great Lakes region. For more information please refer to the USEPA Recreational Water Quality Criteria. The statistical prediction model forecasted real-time Escherichia coli (E. coli) bacteria levels present in the water. The Chicago Park District (CPD) in partnership with the US Geological Survey, developed statistical prediction models by using weather data pulled from CPD buoys (https://data.cityofchicago.org/d/qmqz-2xku) and weather stations (https://data.cityofchicago.org/d/k7hf-8y75). The Chicago Park District would use results of the predictive model to notify the public when bacteria levels would exceed 235 CFU. When bacteria levels exceed 235 CFU, a yellow swim advisory flag was implemented. * The unit of measurement for Escherichia coli is Colony Forming Units (CFU) per 100 milliliters of water. (Culture Based Method / Statistical Prediction Model) *The unit of measuring DNA is Enterococci Calibrator Cell Equivalents (CCE) per 100 milliliters of water. (Rapid Testing Analysis)

MUNICIPAL_BOUNDARY

OLAS Population-based Water Stress and Risk Dataset for Latin America and the Caribbean

LAC is the most water-rich region in the world by most metrics; however, water resource distribution throughout the region does not correspond demand. To understand water risk throughout the region, this dataset provides population and land area estimates for factors related to water risk, allowing users to explore vulnerability throughout the region to multiple dimensions of water risk. This dataset contains estimates of populations living in areas of water stress and risk in 27 countries in Latin America and the Caribbean (LAC) at the municipal level. The dataset contains categories of 18 factors related to water risk and 39 indices of water risk and population estimates within each with aggregations possible at the basin, state, country, and regional level. The population data used to generate this dataset were obtained from the WorldPop project 2020 UN-adjusted population projections, while estimates of water stress and risk come from WRI’s Aqueduct 3.0 Water Risk Framework. Municipal administrative boundaries are from the Database of Global Administrative Areas (GADM). For more information on the methodology users are invited to read IADB Technical Note IDB-TN-2411: “Scarcity in the Land of Plenty”, and WRIs “Aqueduct 3.0: Updated Decision-relevant Global Water Risk Indicators”. | https://www.wri.org/data/aqueduct-global-maps-30-data | | https://www.worldpop.org/ | | https://gadm.org/ |

Assessor [Archived 05-31-2023] - Parcel Universe

A complete, historic universe of Cook County parcels with attached geographic, governmental, and spatial data. When working with Parcel Index Numbers (PINs) make sure to zero-pad them to 14 digits. Some datasets may lose leading zeros for PINs when downloaded. Additional notes:<ul><li>Data is attached via spatial join (st_contains) to each parcel's centroid.</li> <li>Centroids are based on <a href="https://datacatalog.cookcountyil.gov/Property-Taxation/ccgisdata-Parcel-2021/77tz-riq7">Cook County parcel shapefiles</a>.</li> <li>Older properties may be missing coordinates and thus also missing attached spatial data (usually they are missing a parcel boundary in the shapefile).</li> <li>Newer properties may be missing a mailing or property address, as they need to be assigned one by the postal service.</li> <li>Attached spatial data does NOT go all the way back to 1999. It is only available for more recent years, primarily those after 2012.</li> <li>The universe contains data for the current tax year, which may not be complete or final. PINs can still be added and removed to the universe up until the Board of Review closes appeals.</li> <li>Data will be updated monthly.</li> <li>Rowcount and characteristics for a given year are final once the Assessor <a href="https://www.cookcountyassessor.com/assessment-calendar-and-deadlines">has certified the assessment roll</a> for all townships.</li> <li>Depending on the time of year, some third-party and internal data will be missing for the most recent year. Assessments mailed this year represent values from last year, so this isn't an issue. By the time the Data Department models values for this year, those data will have populated.</li> <li>Current property class codes, their levels of assessment, and descriptions can be found <a href="https://prodassets.cookcountyassessor.com/s3fs-public/form_documents/classcode.pdf">on the Assessor's website</a>. Note that class codes details can change across time.</li> <li>Due to decrepencies between the systems used by the Assessor and Clerk's offices, <i>tax_district_code</i> is not currently up-to-date in this table.</li></ul> For more information on the sourcing of attached data and the preparation of this dataset, see the <a href="https://gitlab.com/ccao-data-science---modeling/data-architecture">Assessor's data architecture repo</a> on GitLab. <a href="https://datacatalog.cookcountyil.gov/stories/s/i22y-9sd2">Read about the Assessor's 2022 Open Data Refresh.</a>