Enterprise GIS Solutions

Implementation of an ArcFM based enterprise GIS solution for a small municipal-owned electric utility including configuration, development, data migration and training. This project involved the migration of CAD data, spreadsheets and Access databases into a single enterprise geodatabase that provides access to the geometric network to trace electrical flow as well as a repository of information on all utility assets – poles, streetlights, transformers, conductor, cable, switches, civil structures and customer information. The information is made available to field staff, office workers and management through robust desktop tools, simplified web based applications and mobile devices in the field.

Projects for engineering firm in support of municipalities in East and West Kootenay – Trail, Kimberley and Cranbrook – using tools such as HEC-RAS and HEC-HMS. This involved developing terrain information by integrating CAD, DEM and LiDAR data into seamless elevation models as well as the creation of other hydrological information such as stream banks, centerlines and cross sections into formats and data structures required to support the engineering modelling applications. The results of the engineering models were brought back into the GIS to develop client presentation materials for visualizing the project area and key items such as inundation, water velocities or other analyzed parameters.

Implementation of core Esri technology and extension of Esri solution templates for the management of water and wastewater assets for a municipal government. This project included enterprise geodatabase design, data migration from CAD and database formats, data review and cleanup along with application development of tools for managing as-built documents and exporting data back into CAD from the Esri solution.

Custom ArcGIS Geoprocessing add-ins were created for tracking retirements and field abandonments and importing CCTV data collected to allow users to view condition information collected in the field and access images and video files from the GIS.

Utilizing Esri server and development tools, a web mapping application was created by extending the Esri Web App Builder solution with custom themes and widgets based on well designed and implemented data management solutions to provide users with access to spatial information, provide custom parcel reports and link to documents stored on the corporate network as well as to georeferenced infrastructure as-builts PDF libraries. This involved developing REST services (map services and geoprocessing services) that were managed through an ArcGIS portal site and integrated into an HTML5 Esri Web application with custom templates and widgets implemented to meet the client’s business need to find and access information to manage their municipality.

Coordination with municipal business units – Public Works, Information T, Engineering, Planning and Land Use – on developing geospatial capacity within the organization to transition from legacy database and mapping solutions into an enterprise class GIS solution. This involved coordinating working groups and steering committees, developing business requirement, project scopes and definitions to meet the business needs of the organization. A holistic approach was used that included supporting and training users and helping the organization to implement business workflows that made the GIS technology investments successful as well as designing and implementing server, web, mobile and desktop esri GIS technology to enable the organization to modernize their geospatial infrastructure.