Page Header 2.jpg (12270 bytes)
October 2004

GIS Saves Winston-Salem Time and Money

by Valerie Harper

A&A's Work Order Data Builder Tools allow for enhanced management of projects.In an effort to better manage approximately 188,592 water and sewer utility assets in the Winston-Salem and Forsyth County, NC service area, the City Information Technology Department decided to incorporate GIS mapping technologies with their existing Hansen work order management system.

Work order management systems help utility directors manage the operations of government, maintain public utility assets, and provide better customer service. These systems also help budget and track service costs from the planning stage through the life of an asset.

By creating and integrating water and sewer utility GIS mapping data layers into the Hansen system, the City/County Utility is now able to better track maintenance efforts and the associated crew and equipment costs. Key in this process was A&A’s lead programmer Steve Spillane, who developed an ArcGIS "Work Order Data Builder" extension.

This extension allows the GIS user to map and add specific information about a certain utility asset into a Geodatabase. The "Work Order Data Builder" tool can be used to build work order data for sidewalks, street segments, electric systems, or any other municipal asset. A&A’s Mark Wilson and Jason Lewis were able to digitize water & sewer mapping while using the pull down menus to populate the Hansen work order database with the new ArcGIS extension.

The new GIS-based digital mapping inventory will help the City/County officials better manage and track expenses they incur over the course of each fiscal year. Additionally, the City/County Utilities were able to save nearly 30 percent of projected costs by digitizing the mapping rather than using GPS location.

A&A’s GIS Director James Martin said, "We produced the foundation for a GIS based work order management product that was immediately useable in the Hansen system. Our ArcGIS Work Order Data Builder extension could be used to create mapping for any of the work order management programs with a spatial component, like Hansen."

For more information on cost effective GIS applications contact James Martin at martinj@andassoc.com or 800.438.0394. &


Focus on ESOP: Kelly Chapman


Kelly ChapmanKelly Chapman immediately recognized room for growth and potential when she was elected to the ESOP Advisory Committee in August 2003. During her six years at A&A, she has learned quite a bit about how and why things are done and hopes that her service on the ESOP committee will further expand her knowledge.

While on the ESOP committee, Kelly hopes to help reshape the committee image so that all A&A employees understand that the committee is a valuable asset and more than a suggestion box. Kelly said, "Having both the responsibility of representing my colleagues and the opportunity to share ideas with four other people who have the same goals and values that I have is satisfying. I feel lucky to be a part of such a supportive group."

Kelly looks forward to encouraging her coworkers to embrace their roles as employee- owners and the challenge of helping them understand that they do have a voice within the company.

While serving on the ESOP Committee and managing her responsibilities as Proposal Coordinator and Municipal Marketing Manager, Kelly is also working towards a degree in education, advancing her love for baseball, and hiking all over Southwest Virginia with her boyfriend, Kevin.

A&A Home Page

We need your feedback. Please send an email to anderson@andassoc.com

left arrow.jpg (8396 bytes)right arrow.jpg (8068 bytes)

[Browse Other Issues]       This page was last updated 10/05/04