Project Profile

Artesian Water Company GIS Implementation

Client:
Artesian Water Company

Location:
Newark, Delaware

Artesian Water Company (AWC), the utility subsidiary of Artesian Resources (NSDQ:ARTNA.O), is the oldest and largest public water utility in the state of Delaware.  In operation since 1905, AWC distributes and sells water to residential, commercial, industrial, governmental, municipal, and utility customers throughout the state.

AWC contracted with Timmons Group in 2005 to design, develop, and implement an ESRI ArcGIS-based Enterprise Geographic Information System (GIS).  The scope of the implementation includes business process analysis and improvement of facility mapping and asset management related activities; water and sewer data model development and database design (SQL Server); water and sewer facility GIS data migration, conversion, and spatial adjustment (AutoCAD to ArcGIS); software installation, configuration, and end-user training; custom data maintenance and viewing application design, development and configuration; and hydraulic model integration, calibration and analysis.  Additionally, AWC has asked Timmons Group to facilitate the integration of the water and sewer GIS databases with the existing Peoplesoft ERP business application.  Finally, Timmons Group also assisted in the solicitation, evaluation, and selection of an EAM solution targeted to replace the company’s existing Hansen solution.

Prior to the GIS implementation, AWC was maintaining all of their as-built and facility mapping data within the AutoCAD desktop environment.  The Enterprise ArcGIS solution will result in the migration of all map maintenance functions to the ESRI GIS application suite, using web services as much as possible.

The Business Process Analysis and Improvement workshops conducted at the outset of this project established the foundation of the numerous inter-related system design and implementation tasks including data modeling, application development, water model development, and training.  Additionally, the newly established business processes and work flows, drove the selection of a new commercial off-the-shelf (COTS) EAM\CMMS package.  Through detailed review and analysis of several CMMS software applications, facilitated by Timmons Group, AWC selected Datastream 7i as their new EAMS.

Timmons Group Services:

• Business Process Analysis and Improvements
  
• Enterprise Asset Management System (EAMS) Review and Selection
  
• Data Model Development
  
• Planimetric Data Development
  
• Data Migration, Conversion, and Spatial Adjustment of AutoCAD Source Data
  
• Quality Control
  
• Custom Desktop Data Maintenance Application Development
  
• End User Training
  
• WaterGEMS-GIS Hydraulic Model Integration, Creation, Calibration, and Analysis
  
• Datastream 7i EAMS Implementation Management, Installation, and Configuration Services

Project Profile

Enterprise Asset/Work Order Management System

Client:
City of Richmond, Virginia Department of Public Works

Location:
Richmond, Virginia

Timmons Group is currently implementing a GIS-based Enterprise Asset/Work Order Management System for the City of Richmond, Virginia Department of Public Works (DPW).  The DPW has undertaken this project to integrate a variety of disparate legacy applications as well as improve its daily operating efficiencies and increase its level of service to customers.  This project will also establish a comprehensive inventory of all public works assets and will achieve American Public Works Association (APWA) accreditation for public works best management practices.

Scope of Services

Requirements Analysis & System Design

Conduct a series of implementation planning workshops for the purpose of defining critical success factors, work processes, data needs, work order/service order protocols, reporting requirements, etc.

Existing Data Analysis

Review and analyze each of the existing data sets that will need to be integrated with the new asset/work order management system including pavement distress data, stormwater system condition assessments and various other paper work order and permit documents.

Database Design

Develop the customized UNITRANS and Cityworks (CMMS) database design required to support linear referencing and asset/work order management activities within the City’s existing ArcGIS geodatabase.

Legacy Application Discovery & Interface Design & Implementation

Perform a detailed review of the multiple legacy applications (Permitting, Payroll, Finance, Central Address Database, CMRS, etc.) that the planned asset management system will be expected to either replace or interface with as part of the overall enterprise implementation.  

The results of this effort will yield a Functional Requirements Document (FRD) capable of supporting the development of the required application interfaces (customized programming).

Base Implementation

Install, configure, tune, test, load, etc. the base asset/work order management software packages (Cityworks) throughout the department.

Asset Capture

Deploy state-of-the-art van-based image capture and terrestrial photogrammetry techniques to locate all of DPW’s above ground assets visible within the public right-of-way of an approximately 1,000 road network.  

A variety of point and linear assets will be captured on digital images, extracted to sub-meter accuracy, integrated with the existing base GIS data sets and loaded into the GIS and asset management software applications.

Point Features:

• Bridges
• Crosswalks
  
• Drainage structures
  
• Traffic signs
  
• Pavement markings
  
• Utility poles
  
• Parking meters
  
• Speed humps
  
• Railroad crossings
  
• Fire hydrants
  
• Manholes
  
• Valves
  
• Street trees

Linear Features: 

• Surface type (pavement management)
  
• Median type
  
• Traffic direction  
  
• Speed limit zones
  
• School zones   
  
• Shoulders   
  
• Curbs   
  
• Ditches   
  
• Guardrails   
  
• Sidewalks   
  
• Pavement striping
  
  

 

Project Profile

Dominion Joint-Use Inventory Survey

Client:
Dominion Resources, Inc.

Location:
Statewide, Virginia

An expansive project lasting nearly three years. Timmons Group provided GPS, GIS and consulting services to field locate and verify Dominion’s pole inventory and joint-use pole ownership in all common Dominion and Verizon service areas. Included in the survey were 625,000 Dominion-owned poles, 130,000 Verizon joint-use poles, for a combined total of approximately 330,000 joint
-use power/telephone poles.

As a data collection application and quality-control measure, Timmons Group created an ArcGIS-based “joint-use collection tool” whereby surveyors performed in-field adjustment of GPS located poles to Dominion’s GIS Landbase.

Deliverables

• GIS and associated databases were provided to Dominion and Verizon on a weekly basis and were subject to stringent quality assurance standards for attribute and pole count accuracy.
• GPS field location of Dominion poles/Verizon joint-use poles within the Verizon services area overlap
  
• Adjusted ESRI shapefiles of Dominion pole locations relative to Dominion’s GIS Landbase
  
• “Joint-use collection tool” application development
  
• Technical reports and documentation to support verification and inventorying activities

Technologies Used

• ArcGIS
  
• Trimble SDK Tools
  
• Trimble PathFinder Office
  
• Trimble PathFinder GPS Systems