Geospatial ETL Consultant
Abstract: The Region of Niagara, Ontario needed to automate their current labor-intensive data integration process to maintain an up-to-date single model of water/wastewater infrastructure across all the municipalities.
By leveraging FME, tools were developed allowing for the integration of GIS data from different formats, with different attribute schemas and data quality. Reports are produced detailing attribute, geometry and topology errors, which are used to improve the data quality over time. A modular approach was used in the solution design, so that the system can easily adapt in the future to more data formats, validations and outputs.
Bio: Allison is a Consultant at Consortech Solutions inc, where she specializes in GIS and ETL Processes (Extract, Transform and Loading data). She has been working in the GIS profession for over 6 years and holds a Post-Graduate Certificate in GIS at Algonquin College, as well as a Bachelors of Arts in Geography (Urban Systems) from McGill University. Allison teaches, consults, and develops data integration solutions with Safe Software's FME Desktop and Server.
6300 Auteuil Avenue, Suite 505
Canada J4Z 3P2