GCWW Private-Side One-off Lead Service Line Replacements

data.cincinnati-oh.gov | Last Updated 13 Aug 2020

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

Tags: lead, gcww, service line, private

This dataset has the following 10 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
ADDRESSaddresstextProperty that is requesting quotes for the replacement of the private-side lead service line.
SELECTED_PLUMBERselected_plumbertextPlumber that was selected to complete the replacement of the private-side lead service line.
AMOUNTamountnumberThe total cost of replacing the lead service line, includes right-of-way and private-side amount.
STATUSstatustextProvides the status of the quote request process from Pending Quote to Notice to Proceed Sent.
EMERGENCYemergencytextEmergency quote request will be expedited through the process, usually due to a service line leak.
REPLACEMENTreplacementtextPart of a service line is owned by GCWW and the other part is owned by the customer. If the entire service line is lead then a full replacement will be completed. If only the customer side is lead then a partial replacement will be completed.
QUOTE_DEADLINEquote_deadlinetextThis is the date that quotes are due back by the plumbers.
NOTICE_TO_PROCEEDnotice_to_proceedtextThis is the date that the plumber received the notice to proceed.
ADMIN_AREAadmin_areatextThe property address above resides in this neighborhood.
MUNICIPALITYmunicipalitytextThe property address above resides in one of the following areas; Cincinnati, Hamilton County Incorporated, Hamilton County Unincorporated, Outside Hamilton County.