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

 

A huge drainage mapping project increases the value of stormwater infrastructure.

By John Hannel

Sidebar

Getting GASB

Hamilton County Surveyor Kenton Ward remembers when he first started at the county in 1977. Most of the land was Indiana farm fields with a few subdivisions here and there. Homes cost well under $100,000. The population was about 70,000.

Miles of regulated drains were about 600, the records and maps of which were painstakingly kept on paper.

Regulated drains are a big deal in Indiana, a state where water is abundant. From Lake Michigan to the Ohio River and all of the bodies of water in between, the Hoosier State rarely sees a shortage of this resource. The issue of how to manage it has been the subject of debate since settlers first started making their way west across the United States.

Various acts by Congress and the State of Indiana more than a century ago established regulated drains mainly as a way to make more land suitable for farming purposes. Under current law, county drainage boards, of which the county surveyor is a member, oversee agricultural field tiles, urban storm sewer closed drains, and open drains/ditches. In Hamilton County, the drainage board also oversees drains within some of the municipalities, including drains that were once in unincorporated township areas but became part of a municipality through annexation. The drainage board also has the power to ensure new drains are built as needed.

Through the late 1970s, the 1980s, and into the early 1990s, Hamilton County continued to meticulously maintain paper records and maps of its regulated drains. “We had so much data, if someone needed information, I might spend an hour digging through just one file drawer,” Ward says.

The oldest known map of Hamilton County, circa 1866

But this sleepy county directly north of Indianapolis was about to be jarred awake by an influx of new citizens wanting to build new homes and new businesses. The county’s population, which had been growing steadily through the decades, was about to sharply spike. Landowners would want to know what they could do and couldn’t do in terms of development and drainage—and they’d want to know faster than paper records could provide.

Hamilton County Project Manager Suzie Mills remembers it was almost like a light switch went on. “Right about the mid-1990s, the boom started.”

It hasn’t abated. Today, Hamilton County is the fastest growing county in Indiana and the 16th fastest growing in the United States, according to the US Census Bureau. The population is 231,760. From 1990 to 2000, 73,804 people moved into the county—a 68% population increase. The county has the highest per-capita income in the state. Fashionable Hamilton County cities like Carmel and Fishers are among the addresses of choice in the Indianapolis metro region, with home prices pushing half a million dollars and more not uncommon.

Files and stacks of maps and other data used in the conversion effort

The number of regulated drainage miles that the county tracks and maintains today is 1,145 and counting—almost double the 600 miles maintained back in 1977. “In 1995, we inspected eight subdivisions. In 2004, we inspected 89,” Mills notes.

Near the beginning of the boom, the county invested in the development of a geographic information system (GIS) and started to digitally map data. But for stormwater features, a huge gap existed between what was digitized starting in 1996 and all of those meticulously maintained paper records and maps, some dating as far back as the 1800s.

“Large parts of our stormwater GIS features didn’t have historical data, and nothing had been done with all of the development maps,” says Mills. “We were so busy with growth, it was all we could do just to input basic new stuff as it came in.”

Meanwhile, new government mandates were looming on the horizon: the National Pollutant Discharge Elimination System (NPDES) and Governmental Accounting Standards Board (GASB) Statement 34, mandates that have now become a part of every stormwater manager’s vernacular—mandates that would require better, faster record-keeping and analysis.

Just 1/20th of the drainage files reviewed for this mapping effort and converted to digital format

It was time to upgrade the stormwater GIS layers, and that meant going through the multitudes of drainage files. Because of the huge amount of development in the county, this effort required not only reviewing each record, but also, for each area, identifying the drainage records that were the most current.

The most time-consuming part of this effort was to compile all of these records and input only the most current into the GIS. Many information resources were used to accomplish this goal, including multiple years of orthophotography, surveyors’ notes, platted subdivision documents, the tremendous number of drainage records, and even field verification when necessary.

With this effort, Hamilton County would become among the first in the nation to GIS-map its regulated drains to a level of detail that also included field tiles—something most communities don’t put into a GIS because usually no paper records exist of field tiles. Hamilton County’s years of thorough record-keeping down to field-tile detail put the county in the unusual position of being able to digitally map every regulated drain.

For any community on the cusp or in the midst of a growth spurt, Hamilton County’s experience in building the new GIS—the lessons learned and the benefits gained—offers good perspective.

Building the New Stormwater GIS Layers
To understand how far the county has come in building its data, it’s important to know how it all began. The task of keeping drainage records belonged to Indiana’s circuit courts and the commissioners’ court for more than a century. Even today, it’s common in Indiana to refer to a regulated drain as a court ditch or a legal ditch. Most drains were constructed in the late 19th and early 20th centuries. Handwritten drainage records and maps were bound in big books and stored on shelves. Among them were drain construction books, drain repair books, circuit court record books, and commissioners’ court records.

Hamilton County Surveyor Kent Ward and Project Manager Suzie Mills using the GIS

Indiana passed the Drainage Code in the 1960s, and authority for drainage passed to county drainage boards, of which the county surveyor is the technical advisor and a non-voting member.

About this time, the Hamilton County Surveyor’s Office started making Mylar maps of the regulated drains and compiling them in “greenbook” summaries, an indexing system that correlated each drain to its legal description.

It was the most recent greenbook summary that the county handed to Woolpert Inc., its civil engineering consultant, and said, “Here’s where and what we think things are. Verify it.” So, armed with the list, by name, of the more than 350 known regulated drains, as well as the current stormwater GIS layers, the Woolpert team dived into a pool of paper stored at the county and began the verification process.

Thorpe Creek Stormwater Phase II outfalls. Click here for larger view

“It was a huge undertaking—rarely do you see that quantity of paper, that level of detail in record-keeping. But we had to go through everything—see how everything fit together—to understand where everything stood today,” says Jared Livingston, one of the Woolpert managers assigned to the task.

Because of the quantity of the data, the team determined the best option was to do all review and digitizing onsite at the county. Livingston and Jonathan Hull, a Woolpert GIS analyst, moved into the surveyor’s office full-time for about a year, clocking about 4,000 hours reviewing thousands of paper records and maps and orthophotos, deeming what data were necessary for field verification, what maps should be digitized, and what records should be scanned and saved as PDF files for archival and public-access purposes.

One of the pipe outfalls that was mapped as part of continuing NPDES requirements. The color of the discharge indicates evidence of an illicit connection.

They poured through the multitudes of historical and contemporary data—the books on the shelves and the newer data stuffed into rows of filing cabinets that snaked around cubicles in the surveyor’s office.

They reviewed multiple years’ worth of orthophotos; the county had flown orthos about every other year since 1996. The reasons for reviewing each year’s worth of orthos were big and small. Often, orthos from one year showed farm fields; two years later, the subsequent orthos showed subdivisions. “The landscape had completely changed in just two years’ time and, with it, the regulated drains,” Livingston says. Sometimes, the review indicated something as small as a car covering up a street drain, but then the subsequent ortho would reveal the drain.

A screen shot of the stormwater GIS and the county CMMS (used to calculate GASB values and store asset information outside of the GIS).

Ultimately, the data deemed valid and current for each drain were updated in the GIS, and the originals were boxed and moved to a secure spot with controlled but easy access for authorized personnel. The bulk of the paper was moved into “dead-file” storage after scanning. Scanned files were stored appropriately. Items that still were valid were stored and linked back to the GIS and corresponding drain feature. Items that were no longer relevant were digitally archived.

With GASB and NPDES in mind, Woolpert performed the following for each drainage facility:

  • Attributed all existing drainage graphics and input any newly found facilities (including improvements made to the drain)
  • Inventoried all paper documents for tiles, storm drains, and open ditches and gave a total length for each type
  •  Provided an average cost per foot for each type of drain
  • Calculated the historical cost based on the above-gathered information and the graduated tables supplied in the county’s work order/asset management database (not including the improvement footage, which was calculated by recorded installation costs)
  • Ascertained the age of the primary drainage facility
  • Listed all improvements to the drainage facility, the cost, age, total length, and value
  • Calculated a total value for the drainage facility (historical value plus sum of all improvements)

As part of this data-compilation process, the team also converted regulated drainage easements into the GIS. The county knew it would be important not only to know where these easements existed but also to recognize and report on their value, as assets, in the GASB valuation process. However, because development had so radically changed the landscape and the drains, it was more logical to input the easement features on the heels of completing the actual drainage layers—in other words, to input the easement features in the GIS, the most accurate and current map.

In the end, the team had physically researched every regulated drain and easement within the county to ensure its currency and accuracy. Old paper records had proved so complete that only eight drains, out of 365, were newly identified in the field.

Accurate, Accessible Repository
Data were combined to produce a single stormwater GIS, a database capable of supporting asset management, maintenance, and more.

 “I have complete confidence in the GIS. When I go into it, I know this is the single most accurate repository of our data,” Mills says.

Now, anyone—whether a county employee, a resident, or a developer—can view, download, and use the data. GIS stormwater layers and other data reside in the “map room” on Hamilton County’s Web site (www.co.hamilton.in.us). Drawings of each regulated drain are available, as are documents of record for each drain, scanned and saved as a PDF file. Documents include:

  • Legal descriptions
  • Surveyors’ reports
  • As-builts/record drawings
  • Field reports
  • Bond information

“We had a lot of data, and we had to make choices about what to keep digitally and what to let go of,” Mills says. “The process didn’t just force us to look at the past; it also forced us to consider the future: What kind of data could we realistically maintain as the county continued to develop?”

As a result of this process, the county came to several conclusions:

  1. Less is more; track only what you can easily maintain, what is truly of value, and do it well.
    “Every day, we’re bombarded with more information—plans, maps, reports. It’s one thing to want all information that’s available and another thing to deal with maintaining it,” Mills says. “So, when you’re designing a GIS, and everyone’s throwing in their ‘wish lists,’ consider that in three short years or less, a lot of the data will be out of date. Is it worth it, for example, to record a bunch of attributes that won’t even be accurate in a few years?”
  2. Document as you go; make GIS a part of the workflow.Now that existing regulated drains are completely digitized, the county has built into its workflow requirements that any changes or additions to the drainage system are immediately input into the GIS instead of backlogged on paper.
  3. Collaborate with all communities involved. Hamilton County maintains regulated drains outside and inside municipal limits. The cities within the county are responsible for maintaining their own drains and, as a result, the entities still must be able to speak the same basic technical language. They formed HagTag (Hamilton County Local Government GIS Technical Advisory Group), an informal group of GIS leaders who develop methods, procedures, and workflows to share, maintain, and use the geographic information in more efficient and mutually beneficial ways. “Expanding the use of geographic information increases its accuracy and value,” Mills says.
  4. Establish easy-to-follow digital submission standards for developers. To make GIS part of the workflow, the county and the cities collaborated to require that all engineering documents be submitted digitally starting in 2005. The governments worked together to develop a few simple standards that were easy to follow and easy to enforce. “We avoided requiring the documents to be submitted in a specific kind of software,” Mills explains. “We stuck with good-old-fashioned ‘keep it simple.’” Standards include that files are in .dxf format; offer separate layers for structures, pipes, annotation, etc., with a logical description for each layer and the ability to turn each layer on/off; and reference the Indiana State Plane Coordinate System.

GASB Statement 34
By design, the new and updated stormwater layers in the GIS are helping Hamilton County meet GASB Statement 34 requirements. The Statement 34 rule, released in 1999, radically changed the way government financial statements are organized and presented by moving all governmental accounting toward a business accounting model. The law mandates that counties reporting revenues exceeding $10 million annually must report their entire infrastructure on the county’s Comprehensive Annual Financial Report (CAFR) supplied to the state. The CAFR requires that the county give information for each drainage facility: age, historical cost, improvement costs, improvement age, the useful life for the drainage facility, and respective improvements.

Without a GIS, meeting GASB’s requirements is a less accurate, more painful process. “A lot of governments make a ‘best guess’ about the amount, condition, and value of their infrastructure,” Livingston says. “Unfortunately, that method almost never does true justice to an organization’s balance sheets.”

With its new GIS, Hamilton County’s balance sheet looks more like a business, which, in turn, drives up its bond rating, enabling the county to make more capital improvements. The county can easily calculate, report, and leverage the value of its infrastructure.

The county’s GIS drives a customized GASB tab in POSSE, the county’s customized CMMS (computerized maintenance and permit management system), eliminating the need to separately input infrastructure values into a spreadsheet, a task that could take at least a couple of days. Linking the GASB tab directly to the maintenance and permit management system ensures the most accurate values, because POSSE is updated more frequently than the GIS layers. “We just go to our GASB tab and, with the click of a button, can calculate GASB reporting in a few minutes’ time. No more guessing the value of our infrastructure. Now, we know, and we know fast,” Mills says.

Based on the new stormwater GIS layers, the county saw a net gain of almost $208 million in GASB Statement 34 reported value of drainage assets in 2004 versus in 2003 (when the county did not have these stormwater GIS assets firmly in place). In terms of easement assets alone, values jumped to $159.8 million in 2004 from $10.4 million in 2003.

NPDES
The new GIS is also helping address overall water-quality issues, including meeting NPDES requirements such as detecting and eliminating illicit pollutant discharges and controlling runoff.  

Hamilton County, IN, headquarters
Stormwater layers (rural tiles) along with parcel, contour, and ortho layers. Click here for larger view

“What I like about the GIS is it enables us to have a complete picture of the watershed. Before, we’d have to pull out four or five Mylar maps. Now, we can easily see how doing something in one area will have an impact on a surrounding area,” Ward says. “We can manage all the variables and come up with the best solution for our citizens and the development community, and for meeting government requirements.”

Tasks such as these occur daily at the surveyor’s office. What once took hours with paper records now takes minutes with the GIS layers.

As part of continuing NPDES efforts, the county recently conducted a pilot project of outfall mapping along three creeks—about 3% of the county—in order to locate and attribute county stream inflows and develop a baseline of GIS data to support dry-weather screening requirements.

Woolpert flew a LiDAR (light detection and ranging) mission in 2005 and also captured new orthos at 6-inch-pixel resolution in order to create new floodplain maps.

The LiDAR and ortho data, their planimetrics, and stormwater GIS data were loaded onto pentop computers—along with the county’s existing assessment base map layers—which were used by Woolpert field crews who walked the county waterways, verifying locations and attributes using Woolpert’s SmartSurveyor software in conjunction with global positioning system satellite surveying technology.

Although NPDES requires pipes 12 inches or greater in diameter to be mapped in the next five years, it was decided that all outfalls in the pilot area would be captured regardless of pipe size. The work also included identifying flow and taking photos of the outfalls. GIS analysts then “scrubbed” the incoming data, correcting any errors. The project helped establish a method for future outfall mapping of the remaining 215-plus miles of streams in Hamilton County.

Conclusion
Hamilton County’s vision and progressive approach to stormwater GIS development resulted in a comprehensive information resource. The county’s strategy of including in the GIS only the information that can be easily maintained—while storing additional information in an external database that can be linked back to the GIS—has yielded an easily sustainable GIS. This built-in “future flexibility” means that as the county grows and infrastructure increases, the inputting, tracking, and maintaining of these assets—and meeting government mandates such as NPDES and GASB—is a repeatable and documented process.

John Hannel is a project manager in Woolpert Inc.’s Indianapolis, IN, office.

 

SW May/June 2006


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

Distributed Energy | Erosion Control | lGrading & Excavation Contractor
MSW Management | Onsite Water Treatment | Water Efficiency
StormCon | ForesterPress | Forester Media

© FORESTER MEDIA, INC.