GIS - Digitizing utility service connections

Project Details

The project involved the digitization of utility service connections, including water, sewer, and storm services, within the city’s ArcGIS geodatabase. This included integrating utility connection data with parcel information and enhancing the database with attributes such as pipe depth, diameter, and length. The goal was to transfer historical service data from physical records to a comprehensive GIS system, ensuring a complete and accurate digital record of the city’s utility network.

Client: A department of the municipality focusing on innovation, strategy, and intergovernmental relations.

Sector: Public Utilities

Sub Sector: Utility Services Management

Services:

Dedicated GIS team services
Data Integration
GIS Database Management
Utility Network Digitization

Solution:

Augmented ArcGIS geodatabase with utility service connections
Mapped connections to parcels
Added detailed attributes to the database
Transferred historical data to GIS

Location: Canada

Technology and Software:
ArcGIS was used for geospatial management and mapping, while SQL was employed for querying and verifying attribute data.

Digitizing utility service connections

People:
GIS-Point assembled a highly skilled team consisting of 10 GIS specialists, 2 quality controllers, and a project manager. The project was meticulously planned and segmented into weekly phases to ensure completion within one month. Each phase was carefully scheduled, and the client was provided with regular updates on progress, encountered challenges, and implemented solutions. The team maintained continuous communication to address and resolve any issues promptly. The project was executed with rigorous quality control, ensuring a 100% quality standard and timely delivery.

Process & Challenges

Process:
The project involved several technical steps to transition from analog to digital data and ensure the accuracy of the utility network database:

Data Preparation and Digitization: Augmented the existing ArcGIS geodatabase by linking utility service connections (water, sewer, storm) to residential parcels. Integrated scanned engineering documentation and systematically transferred historical paper records into digital formats, mapping them to the appropriate parcels within the geodatabase.
Attribute Enrichment: Updated the geodatabase with detailed attributes for each utility connection, including pipe depth, diameter, and length. This required careful extraction and input of data from engineering documents.
Topological Validation: Performed comprehensive topological checks to ensure data integrity and accuracy, verifying spatial relationships and connections within the utility network to identify and correct inconsistencies.
Quality Assurance: Implemented rigorous quality control measures, including validation of data accuracy and completeness through systematic checks. All topological and attribute data was verified to meet project standards.

The process resulted in a high-quality digital utility network with accurate attributes and validated spatial relationships.

Challenges:
The project encountered several challenges, including the integration of historical data from paper records spanning from the 1900s to the present. This data presented difficulties due to varying units of measurement and technical details. Ensuring the accuracy and completeness of utility connections was complex given the large volume of data involved. Additionally, managing and processing extensive datasets required meticulous attention to maintain the integrity of the utility network information.

Result

A fully digitized utility network database for the city, including all necessary topological checks. The project successfully transferred historical data to the GIS system, creating a robust digital record-keeping system for future utility management and planning.

Our Team

Ievgen Lavrishko

CEO & Owner

Khrystyna Bochko

HR Generalist

Alevtyna Kostianchuk

Senior Project Manager

Andriiana Pavlyshyn

Head of Business Development

Roman Nahaiovskyi

Project Manager

Maria Kizim

Lead Generation Specialist

Ivanna Soltys

Tender Manager

Navigating Our Impressive GIS Portfolio

GIS Analysis for Determining Optimal Locations for Wind Farms

Location:

Australia

As part of the project, we developed KML files to depict various constraints within the study area. Moreover, we produced wind speed images using data from the global wind atlas.
Automatic tree recognition from orthophotos

Location:

Germany

Automatic Tree Recognition with ArcGIS Pro is a project that aims to develop and implement an algorithm for automatic recognition of tree species based on remote sensing data.
Fulfillment of government orders to create and update databases

Location:

Poland

The databases are created and updated by vectorizing existing raster data (topographic maps), orthophotomaps and processing geodetic files and land documentation (by coordinates and sketches).
Geospatial Analysis and Image Processing

Location:

Poland

Editing the automatically generated database of motorways, bridges and roads.
Precision 2D Vector Map Creating at 1500 Scale

Location:

Latvia

Precision 2D Vector Map Creating at 1500 Scale