Data Description: To reduce the expose to lead in drinking water, Greater Cincinnati Water Works (GCWW) has created a Lead Service Line Replacement Program (LSLRP). In October 2016, GCWW was directed by the City of Cincinnati Council, via Ordinance No. 326-2016, to take the appropriate steps to develop, fund, and implement a program to replace known lead service lines in the City, both on public and private property. Through another ordinance, Ordinance No. 185-2017, and effective July 28, 2017, lead service lines are prohibited in the GCWW system. Enforcement of this ban is being phased in over time.

The private-side work is then done by contractors or plumbers who are contracted with GCWW through the City's procurement process, either for a water main replacement project, or from a pre-qualified list established through the City's Request for Qualifications (RFQ) process. This dataset is the list of jobs from the pre-qualified list of plumbers established through the RFQ process.

Data Creation: This data set is the list of jobs from the pre-qualified list of plumbers established through the RFQ process.

Data Created By: GCWW

Refresh Frequency:

For more information on the GCWW Lead Service Line Replacement Program please visit the GCWW Lead Awareness site https://lead.mygcww.org. If you are a plumber and are interested in learning more about how you can get involved, please view the Plumber FAQ.

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this data set.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad