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