In 2014, the City of Columbia, SC agreed to a $750M EPA wastewater consent decree. A Sewer Mapping Plan was mandated to document SOPs and map all manholes and pipes with attributes: material, age, size, invert, elevation, and slope. Other than traditional mechanisms such as survey, the City also utilized ongoing inspections, and institutional knowledge, but faced challenges to consolidate data within the EPA's 9-year deadline. This presentation will showcase the City's use of ArcGIS tools for tracking, quality control, and data management to map 1,100 miles of sewer infrastructure.