|
System uses go
beyond stormwater to include water and sanitary sewer.
By Mark Kollitz, Sean
Martin, and John Hannel

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 citys Public
Works Department is having its own celebration of sorts: the recent
launch of a geographic information system (GIS) of the citys
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. Charless 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 citys 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
citys 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.
Heres how GIS was
built.
Getting Started
The City of St. Charleson
the edge of metropolitan St. Louis but really a city unto itselfhas
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 citys 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 networksomething the city did not havein 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 GISs 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 filesincluding subdivision maps, vintage maps (maps
from the original section of town, circa 1800s), street maps, and
existing water-sewer-storm system mapsto 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
citys infrastructure using the SmartSurveyor software on rugged
pen-based field computers integrated with Trimbles 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 citys 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,
Woolperts 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 outfallwhat 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 citys 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 FEMAs 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 citys annual street maintenance
project.
Conclusion
NPDES Phase II may have
jump-started the City of St. Charles GIS, but its uses go
beyond the mandates requirements to meet a variety of needs
across the citys 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
|