BC Hydro Distribution – GIS Mapping and Data Conversion

  • Underhill - BC Hydro

  • J. Dyke reviewing BC Hydro data on an IBM workstation.

  • BC Hydro GFIS Project

  • IBM DASD (Direct Access Storage Device) controller and tape drives in the computer room of UGSL Vernon, BC

  • Technicians "scrubbing" maps prior to digitizing.

  • BC Hydro GIFS - Work in Progress

  • Working with Data

  • Working with data BC Hydro GFIS

  • IBM 4381 mainframe running Geographic Facilities Information System (GFIS) software.

  • BC Hydro GFIS

  • Computer work BC Hydro GFIS

  • N. Sommers and C. Mashon examining a plotted BC Hydro facet (map).

  • Discussing work at the office

  • Underhill team working on the BC Hydro GFIS project

  • GFIS project

  • Team Meeting - Underhill GFIS project

  • BC Hydro GFIS Project

  • Underhill Team in the office

  • Happy team members on the Underhill team

Date
About This Project

Since 1958, Underhill has completed over 1,000 projects for BC Hydro and its predecessor the BC Electric Co., in the fields of engineering, surveying, mapping, GIS, software development, and facilities management.

Facilities Mapping and Data Conversion of Existing Electrical Distribution Records

In 1991, Underhill Geographic Systems Ltd. (UGSL) was successful in obtaining a major portion of BC Hydro’s initial GeoFacilities Information System (GFIS) conversion project. This project was described in the industry as one of the most aggressive conversion projects ever undertaken. Hydro’s conversion schedule called for the entire system to be converted in two years … which is two to five times faster than other GIS conversion projects of similar size and scope. [60]

BC Hydro serves 1.4 million customers in a territory that covers more than 72,000 square kilometres (45,000 sq. mi.). The project included conversion of overhead and underground primary and secondary electrical facility information, and digital land base development. Also involved on the Underhill team were Kilborn Engineering Ltd. of Vancouver, B.C., and GeoTechnology International (GTI) of Denver, Colorado. Note: as of 2011, GTI was acquired by Intelligraphics International, which was acquired by Analytical Surveys, Inc. (ASI), which was acquired by RAMTeCH Corp.

UGSL was awarded the Lower Mainland (Metro Vancouver) and Vancouver Island divisions of the project. These areas cover the two largest metropolitan centres in the province: Vancouver and Victoria. Over 1.5 million overhead and underground electrical facilities and their attributes, on some 5,500 map sheets, were converted during this project. BC Hydro’s accuracy requirements were 100% for the digital model and 99% with respect to the source documents. UGSL met or exceeded these requirements in all returns. This project represented UGSL’s first IBM GFIS contract.

To meet the project schedule and achieve the rigid accuracy standards, UGSL developed a methodology which utilized, in-house developed, specialized digitizing and quality control software.

The electrical facilities digitizing was carried out in the IBM GFIS environment on a dozen PS/2 workstations powered by an IBM 4381 dual processor mainframe computer. Working around the clock up to three shifts per day were required at the peak of production.

The land features were digitized by Kilborn Engineering, in Intergraph MicroStation PC. The land data were merged with the electrical data after translation from Intergraph to IBM GFIS. This custom translator was written by UGSL. This method, executed by a qualified staff trained by our in-house program, enabled us to complete the project successfully.

Subsequent to the completion of the initial project, UGSL was awarded further conversion work in Vancouver. BC Hydro had originally planned to do this work in-house, due to the complexity and density of the facilities. UGSL’s performance in the initial GFIS contract gave BC Hydro the confidence that Underhill could complete this area.

Read the full GIS World article B.C. Hydro Automates a Province.

Field Inventory of Overhead Electrical Facilities in the Lower Mainland

In conjunction with the original BC Hydro GFIS conversion contract, UGSL was successful in 1990 in obtaining a contract to produce a field inventory of the overhead distribution system in the Lower Mainland of B.C. This project involved:

  • Preparation of field inventory documentation
  • Training of approximately 25 people (including 6 of Hydro’s own staff) in field inventory procedures
  • Development of field computer data collection software for automated attribute data collection and validation
  • Development of software for the management, audit, digital QA and editing of field collected data
  • Field mapping of 184,435 poles and associated conductors, and devices in Coquitlam, Maple Ridge, Surrey, Delta, Langley, Richmond, North Vancouver, West Vancouver, Vancouver, Abbotsford and Mission

Read our paper Automated Field Inventory for GIS Data Conversion, presented at CISM/ACSG’92.

Digital Pole Inventory System – Joint Use Administration

The Joint Use Administration (JUA) is a partnership between BC Hydro and BC Tel for the joint management of some 800,000 power poles throughout BC.

Upon seeing UGSL’s automated data collection for electrical field inventory, the JUA contracted UGSL in 1991 to develop a similar system for inventory for Joint Use information. A first-generation system utilizing Covalis Micro-Technology MC-V hand-held data collectors was implemented. The system allowed for the extraction of pole data records from Hydro’s IBM DB/2 database, editing of the records in the field, and posting of the data back to DB/2. The system also included a notebook-based file management system to interface the mainframe and handheld worlds.

Conversion of Existing Electrical Distribution Records, General Work Order Conversion, Field Inventory

In May of 1993 UGSL obtained follow-on work for update, conversion and field inventory of a number of areas not converted in the initial GFIS project. More specifically this work included:

  • General work order updates in the Lower Mainland
  • Conversion of overhead and underground facilities
  • Field inventory in Golden and Revelstoke, BC
  • Conversion of overhead and underground facilities in Lillooet, and Cache Creek, BC

GFIS to EGIS Conversion Work for Distribution GIS

Once BC Hydro field crews had reconciled its customer and distribution GIS databases using Underhill’s electrical GIS technology Distribution Circuit Builder—called Copan FM–Electric—it needed help in cleaning up the data migrated from it’s IBM GFIS GIS.

See our BC Hydro – Customized Field Mapping and Editing Software project.

Underhill was contracted, in 2001, to provide GIS/CAD operators as part of the migration of their existing GFIS GIS data to their new Smallworld-based Enterprise GIS (EGIS). Underhill operators worked within the BC Hydro office in Burnaby. In all, five Underhill employees worked on the conversion of UDD and DOD sheets in GE Smallworld.