PROJECT SUMMARY

AEP’s River Engineering and Technical Services Section identified various areas within their organization where they needed support to migrate both spatial and non-spatial data into consistent data models, as well as evaluate incoming spatial data deliverables provided by their consultants. The purpose of such work is to facilitate greater use of enterprise database systems and web mapping applications internal to AEP.

OUR ROLE

With personnel with more than 40 years of combined experience, Matrix Solutions Inc. translated various standalone flood hazard and inundation map products and spatial datasets into standard data models, and reviewed spatial data products provided by other consultants. Matrix helped solve technical problems related to the following scopes:

• Flood Hazard Spatial Data Centralization, Review, and Harmonization
  • Develop and implement a quality control approach to translate spatial data for ~25 Flood Hazard Identification Program (FHIP) studies into a consistent data model
• Third Party Spatial Data Review of Open Water and Ice Jam Inundation Mapping and Flood Hazard Mapping for New Provincial River Hazard Studies.
  • Assess interpolation of modelled water level elevation surfaces
  • Assess inundation and hazard delineation for topological consistency
  • Data review of reported water levels to ensure consistency
  • Review spatial data products to ensure inundation datasets meet Terms of Reference (TOR) requirements
• FIDO Geo-referencing and Web Services Interoperability Support
  • Develop and apply standard geo-referencing approach for records from a non-spatial, legacy database
• High Water Mark Database Support
  • Provided data transcription, data quality control, and georeferencing services for AEP’s historical high water mark report documentation

CHALLENGES

Contending with current, historical, and legacy spatial and aspatial data products has a variety of challenges. Maintaining the integrity of such data and not editing it, while trying to fit the data into a structured data model, was a big challenge. Our approach to tackle this challenge was frequent communication, consult with the client to ensure scope alignment, and escalate technical issues pertaining to the data when necessary.

OUTCOME

We provided AEP with historical data products that are consumable through enterprise data systems. We also ensured that newly created spatial and aspatial data products adhere to a structured data model standard.