Back to Stormwater Home Page
  Finally a high-quality publication, exclusively for surface water-quality professionals
  All of our current editorial content is available for you to read at no cost. Back issues are also available.
  A limited number of complimentary subcriptions are available for surface water quality professionals.  Subscribe today --- FREE!
  Check out the latest news on surface water quality and stormwater management.
  Take a look at what Stormwater-related  events are happening - make sure to list your own - FREE!
  Alphabetical listing of Stormwater-related terms, abbreviations & commonly used phrases. Help us keep this current
  Talk to us, to other storm water managers + engineers, contractors, whomever. Here's your  soap box. current regs got you down? Express yourself!
  We're building an on-line image library for everyone to view. If you've got stormwater-related images, share them with us.
  Reach more buyers --- and reach them faster --- by advertising in Stormwater, the Journal for Surface Quality Professionals  and on stormh2o.com!
  Do you have a question? Want to suggest an article topic? Here's how to get in touch with us.
  If you're looking for something that relates to surface water quality management, look here first
  Give us your email address so we can supply you with updates regarding this site and STORMWATER magazine (we proise not to let anyone else have it)
  Check your local weather forecast - find a consultant in your area - meet our staff - view industry links - find or announce a job ...
 
Search the Buyers Guide

 

Don't miss StormCon

Stormwater Management

Field Manual on BMPS

 

 

 

 

 

 

 

 

 

Create a link on your website

 

 

 

Subscribe

 

 

 

 

 

 

 

 

 

 

Top

 

 

 

 

 

 

 

 

 

 

 

Top

 

 

 

 

 

 

 

 

 

 

 

Top

 

 

 

 

 

 

 

 

 

 

 

Top

 

   
Stormwater Logo


Features

 

NPDES Jump Starts a GIS for the City of St. Charles

System uses go beyond stormwater to include water and sanitary sewer.

By Mark Kollitz, Sean Martin, and John Hannel

Sidebar
Data Maintenance:
A Critical Element of a GIS

Maps have historic significance for the City of St. Charles, MO. This city on the banks of the Missouri River was the 1804 launching point for the Lewis and Clark expedition and mapping of the American West and Northwest. In 2004, that moment in history celebrated its bicentennial.

The city’s Public Works Department is having its own celebration of sorts: the recent launch of a geographic information system (GIS) of the city’s water, sanitary sewer, and stormwater systems. More than just a pretty map, GIS is helping the city meet National Pollutant Discharge Elimination System (NPDES) Phase II requirements. Indeed, NPDES jump-started St. Charles’s quest to inventory stormwater infrastructure and build GIS. City leaders decided it would be cost-effective to do the same simultaneously for the water and sanitary sewer systems. As a result, the city’s GIS uses go beyond NPDES requirements and into the realm of better infrastructure management, modeling, and planning for all three utility systems.

To build the water-sewer-storm GIS, project activities included:

  • Establishing a constant and historically accurate geodetic control network using an innovative height modernization (HM) technique
  • Developing accurate, high-resolution digital orthophotography of the city
  • Conducting a topographic survey of the city using Light Detection Imaging and Ranging (LiDAR)
  • Conducting the global positioning system (GPS)–enhanced field inventory of the city’s water, sewer, and stormwater infrastructure
  • Bringing these data sources together to populate the information in GIS
  • Supplementing GIS with additional source information and input from various city departments

Approximately 20,000 structures were inventoried among the water, sewer, and stormwater systems. The city now has an accurate record of not only where structures are located, but also sizes of structures, top and flow-line elevations, and other data. Eventually, the city will connect the data to a computerized maintenance management system.

Here’s how GIS was built.

Getting Started

The City of St. Charles—on the edge of metropolitan St. Louis but really a city unto itself—has seen tremendous growth in recent years. Today, the population is more than 62,000 over a land area of 26.5 square miles. The city is drained by two main creeks, Sandfort Creek and Cole Creek, which convey stormwater generally north to the Mississippi River, and three unnamed tributaries that convey stormwater generally east to the Missouri River. The terrain ranges from hilly in some areas to bottom lands that are prone to flooding: Many will remember the Great Flood of 1993, when the Mississippi and Missouri rivers surged to levels not seen in more than 150 years.

With population growth and development, the city has faced the challenge of maintaining records for its water-sewer-storm infrastructure. The city had limited mapping of these systems, some of which were decades old. The City of St. Charles selected Woolpert LLP, a civil engineering firm with headquarters in Dayton, OH, and an office in St. Louis, to assist with bringing the city’s water, sewer, and stormwater maps into the twenty-first century.

The project started in January 2003 with Woolpert recommending the HM project, which would use GPS surveying system technology to capture both horizontal and vertical controls. The city was the first in Missouri to use GPS to develop the vertical component of monuments using National Geodetic Survey HM specifications. The project provided the city with a geodetic control network—something the city did not have—in half the time of conventional leveling. The method saved the city between $50,000 and $75,000 over conventional leveling.

St. Charles now has consistent control citywide. The data are available for public and governmental use. In addition, the city now requires any new development be tied to the control network to allow for easier inclusion in GIS.

Next, Woolpert took black-and-white aerial photos in February 2003 and March 2003 to take advantage of optimum visibility. The resulting orthophotos serve as coverages (a backdrop) for GIS, enabling better addressing of properties, and also provide a better overall picture of the city in terms of developed and undeveloped areas, which aids in designing and planning.

An additional aerial survey was performed using LiDAR to collect the vertical component of water and stormwater structures at an accuracy level of plus or minus 6 inches. Using the LiDAR data, Woolpert later populated the GIS’s water and stormwater point data with the z-elevation (vertical) attribution. The LiDAR data in GIS enabled creation of planimetric maps consisting of hydrology features with direction of flow. From these maps, digital terrain models (DTMs) can be created for hydraulic and hydrologic modeling.

Finally, before field data collection, Woolpert scanned source material and city-supplied land-base files—including subdivision maps, vintage maps (maps from the original section of town, circa 1800s), street maps, and existing water-sewer-storm system maps—to digitize the utility systems’ known structures. The converted data were delivered to the survey team in shapefiles and then imported into SmartSurveyor, a mobile mapping system that enables GPS crews to map water-sewer-storm systems and apply attributes in the field in a single sweep. These data gave surveyors a starting point as they began to locate structures.

Conducting the Field Survey and Building the GIS

The City of St. Charles's stormwater system overlaid on the Triangular Irregular Network and digital orthophotography

Field data collection began with a 0.5-square-mile pilot area in March 2003 before going citywide in April 2003 to 26.5 square miles. Woolpert surveyed the city’s infrastructure using the SmartSurveyor software on rugged pen-based field computers integrated with Trimble’s real-time kinematic (RTK) and real-time differential (RTD) GPS technology.

RTD was chosen for the water and stormwater systems because it would provide the x and y coordinates at meter-level accuracy, which was accurate enough for the city’s purposes and more cost-effective than the sub-meter-level accuracy of RTK. Additionally, the vertical component for water and stormwater had been obtained via the earlier LiDAR mission. However, Woolpert used RTK for sanitary structures, obtaining x, y, and z coordinates at centimeter-level accuracy to achieve highly accurate data. The city intends to use the sanitary system data for an ongoing wastewater study, which will involve hydraulic modeling.

One surveyor measures a culvert and another uses SmartSurveyor software to feed the attribute information into the GIS.

The city determined what attributes to populate in GIS based on budget. For the full conversion project, the features that were converted included:

Water System
Water main valves’ x and y coordinates were collected in the field; however, diameters were populated from paper source documents or assumed from the diameter of the main. The valve type also was populated from paper source documents.

Hydrant attributes were collected in the field, including x and y coordinates, inventory status (found/not found), condition comments, rotation (valve open/close direction), age, and manufacturer. The paper source of hydrants (where original information came from, whether map or as-built) was input in the office.

Water main features were not field collected; all attribute information originated from paper source documents, including diameter, material, type, source, condition comments, and rotation.

Water fittings’ location and attribute information came from paper source documents.

Sanitary Sewer System
For the mains, the diameter, material, in depth, out depth, condition comments, and additional notes were field-collected. For the structures, the x and y coordinates were field-collected, originally with RTD GPS; these points were given to field surveyors, who did a second pass, this time performing RTK GPS to obtain highly accurate x, y, and z coordinates.

Stormwater System
For the mains, stormwater outfalls, and stormwater management structures, the diameter, material, comments, and notes were field-collected. For the structures, the x and y coordinates, material, structure depth, condition comments, and notes were field collected.

Quality Assurance and Quality Control

Once data were collected, Woolpert’s GIS analysts performed a combination of manual (visual) and programmatic reviews of the field structure locations, attribution, and system connectivity.

The field structure reviews were performed by comparing the structure placement against the newly flown orthophotos and digital structure data placed before field collection to help evaluate whether GPS or digitized (manually placed) field locations were within the permitted tolerance ranges, and also to confirm that no structures had been missed or could not be found in the field.

When GIS staff had completed their reviews, reports were forwarded to the applicable field manager. The field managers took GIS-reviewed reports and would

  • Revisit areas in question
  • Verify and validate “odd” situations
  • Ensure that the GPS signal (the location) was accurate
  • Re-measure or re-inventory where necessary

At this stage, field managers also queried the data for connectivity and condition-assessment issues indicated by field crews and worked to resolve these problems.

Once the field manager was satisfied with the results of the automated review, the orthophoto review, and connectivity and condition-assessment reviews, the revised data was re-forwarded to the GIS staff. At this point, GIS took “ownership” of the dataset. Any digital revisions to the database were done strictly by GIS staff and required the authorization of the field manager or city project manager.

GIS staff would run additional quality-assurance and quality-control checks, including but not limited to:

  • Running programs to check for voids in, correctness of, and presence of conflicting data
  • Referencing orthophotos to check if the open and closed systems were connected and to verify they were flowing in the same direction
  • Running a program to check for negative slopes in pipes
  • Capturing screen shots of anything that did not make sense and sending the screen shot plus a report to the applicable field manager for verification
    Additional steps that Woolpert took:
  • Creating “business rules” that resulted in complete and useful data, including when to assume structures were based on “unique” or “common” situations, and performing data enhancements such as using the LiDAR data to populate the z-elevation of storm and water structures
  • Designing the geodatabase with attribution that identified the source (subdivision map, system map, field collected, assumed, etc.) and GPS status (RTD, RTK, not found, unobtainable, etc.) of each piece of GIS information
  • Including an “invert elevation” on the sanitary sewer and stormwater structures and then supplying a piece of code that recalculates the value if either the rim elevation or the structure depth is modified
  • Developing a set of data-submittal standards for the city, which the city published for use by contractors submitting as-builts (records drawings)
  • Training St. Charles employees (both group and individual training) on ESRI GIS software using their data and computers
  • Hosting and maintaining data once the project was completed (see the sidebar on GIS data maintenance)

Putting GIS to Work

GIS is being used to meet NPDES Phase II requirements, for better records and infrastructure management, to comply with new state requirements, for Federal Emergency Management Agency (FEMA) purposes, and to streamline a variety of tasks as described below.

An ArcMap screenshot of the City of St. Charles's stormwater system and parcel boundaries overlaid on the Triangular Irregular Network that was derived from LIDAR. Click here for larger view.

Meeting Applicable Control Measures Set Forth by the NPDES Phase II Mandate
GIS-generated maps are being used to quickly locate outfalls and perform dry-weather testing to detect illicit connections and discharges. Each year for the next four years, the city will monitor 25% of the outfalls identified during the dry-weather pre-screening that have non-stormwater discharges, and will identify and eliminate the source, if possible. GIS will be updated with information about each outfall—what was found, how the situation was remedied
and when, etc. After the four-year cycle, the city will begin to re-inspect the outfalls.

Additionally, GIS is being used as a tool in reviewing development plans, including stormwater collection and detention/retention systems. It is also used to map locations of stormwater complaints and sanitary backups. Analyzing the geographic locations aids in identifying capacity or maintenance issues with the collection system.

In the future, GIS will be used to create a computer model of the stormwater-collection system to evaluate impacts of proposed developments and identify capacity issues/problems. It will also be used to track the permitting and maintenance of stormwater detention/retention facilities.

Enabling Better Infrastructure and Records Management
Rapid population growth in the 1990s outpaced staff resources to maintain the paper maps. With GIS, maintenance of the infrastructure maps will be made easier and more accurate. As new developments and public works projects are completed, the utilities will be survey-located using the geodetic control network. The as-built (records drawings) locations will be digitized in either a GIS or CAD file, which can be incorporated directly in the city’s overall GIS.

Enabling Utility-Locate Services
In 2003, the State of Missouri began requiring all cities to provide utility-locate services. Because St. Charles’ utility maps were out of date and incomplete, it was imperative to create an up-to-date map of all the city utilities. With GIS, utilities can be easily found and marked in the field, and utility location maps can be supplied to those requesting them. 

Providing Data for FEMA’s Use
Although not a planned purpose of the project, one of the benefits was that the survey control network, orthophotography, and topography data were given to FEMA to assist the agency in its ongoing project to develop up-to-date digital flood insurance rate maps.

Providing Evidence in Property Condemnation Cases
Property appraisal values are stored in GIS. When a property is condemned, the Public Works Department can produce a map that color-codes the appraised values for similar properties. This approach has yielded effective results in condemnation hearings for defending the fair market price offered for property rights.

Developing a Sanitary Collection System Model
The model will be used to evaluate sewer improvements that may need to be made to facilitate development and redevelopment, to identify system bottlenecks, to identify areas of inflow and infiltration so corrective actions can be planned and implemented, and to simulate the affectsof new development or redevelopment on the collection system.

Inventorying the Condition of Public Streets
These data are used to develop a list of streets that need to be rehabilitated as part of the city’s annual street maintenance project.

Conclusion

NPDES Phase II may have jump-started the City of St. Charles’ GIS, but its uses go beyond the mandate’s requirements to meet a variety of needs across the city’s water-sewer-storm systems. From better records management and utility maintenance to modeling and planning efforts, the citizens of St. Charles will be better served by this highly sophisticated map.
 
Mark Kollitz, P.E., is group manager for Water Management with Woolpert LLP in St. Louis, MO. Sean Martin is a project manager with the City of St. Charles, MO. John Hannel is a GIS project manager with Woolpert LLP in Indianapolis, IN.

SW November/December 2004


 

Home + About + Subscribe + News + Calendar + Glossary
Talk + Images + Advertise + Contact Us + Search + Register + Services

Distributed Energy | Erosion Control Magazine | MSW Management Magazine
Grading & Excavation Contractor | StormCon | ForesterPress | Forester Media

© 2000 - 2004 FORESTER MEDIA, INC.