As part of geographIT’s lead pipe solution, we develop a customized workflow process and associated tools to meet each client’s needs within their existing environment and available resources. Our services assist with identifying, capturing, analyzing, and reporting on lead service line data to meet upcoming EPA lead service line requirements. We begin by helping to build out the client’s inventory and determine an optimal approach to capture unknown material types in the data. We then create dashboards to help the client track progress, along with streamlining and automating EPA report creation and customer notification tasks.
Services/Deliverables
- Integration of existing data to identify service line materials
- Configuration of a public facing Survey123 application to assist in capturing customer service line data
- Development of a workflow process to update and maintain service line material data, including a QC database and automated process to merge existing data with production data that has been reviewed and approved
- Dashboard configuration to track lead and unknown material locations
- Configuration of web applications for use by office staff to update, filter, analyze, and export service line data, based on material type, age, and location
- Development of automated report process to meet EPA reporting requirements
Key Benefits
- Assistance with meeting EPA lead service reporting and customer notification requirements
- Improved service line GIS inventory
- Assistance with customer engagement and data collection
