Central Contra Costa Sanitary District

CCCSD needed to clean up and transform the data model of their sanitary sewer GIS into the Esri Local Government Information Model.

The team has used FME for years to migrate data between systems and perform data quality control. Years of various systems had created a wide array of attributes, mini line segments, and sewer main features that were stored n:1. In adopting the new data model, they used FME to create workflows that simplified their model of sewer pipes and their associated attributes and migrate it to their new data model without losing any information.

CCCSD views FME as an integral part of their data migration process. The pre-built tools in the visual interface and the flexibility to join them to create custom transformations saves the team time, and allows them to automate their data transformation processes.

Central Contra Costa Sanitary District (CCCSD) provides wastewater collection and treatment services to approximately 471,000 people in the eastern part of the San Francisco Bay Area, California, USA.

“CCCSD has been using FME for more than 15 years to solve a variety of spatial and non-spatial data transformation and automation problems. In this case, it helped us to simplify our sanitary sewer network to align with our CMMS and CCTV systems.” -- Carl Von Stetten, CCCSD