Abstract

Datasets That Enable the Plan: Storm Water Project Tracking II
Track: Water, Wastewater, and Stormwater
Author(s): Brian McMahan, Amy Rockwell

In a utility focused on customer service, maintaining and improving a seamless project tracking system that distributes knowledge to the enterprise in a timely manner is a key business requirement. This system has evolved from an Excel workbook which created simple datasets to a custom SQL based application with an Access front-end. SQL scripts pull data nightly from a customer service database located on an oracle server to populate the tracking system. Included in this customer service data is the Parcel ID, when populated into the system is associated with it's proper x,y coordinate and can be spatially represented. Among the tasks, it is used to track project locations, costs, types of work, associate project photos, assists in answering City Council inquiries, inventory collection verification and staff productivity. Yearly, the system is utilized to prepare GASB 34 Asset Tracking Reports, determine trends in land development, forecast staffing and contract resources.

Brian McMahan
City of Charlotte Storm Water Services
600 East Fourth Street
Charlotte , North Carolina 28202
United States
Phone: 704-336-7035
Fax: 704-336-6586
E-mail: bmcmahan@ci.charlotte.nc.us

Amy Rockwell
City of Charlotte Storm Water Services
600 East Fourth Street
Charlotte , North Carolina 28202
United States
Phone: 704-336-5779
Fax: 704-336-6586
E-mail: amyrockwell@ci.charlotte.nc.us