ARTICLE

So You Have GIS Data, Now What

Now that you have collected GIS data, what can you do with it? 

Origin Design worked with the City of Peosta, Iowa to answer that question. The project included a three-phase approach to utilize GIS data for the City’s stormwater projects.

Phase I

Phase I of the project included the asset inventory, data collection, and GIS database management for all stormwater pipes and structures within city limits. During this phase, data related to location, size, material, and rim and invert elevation is collected and stored in a GIS database. For municipalities with existing GIS databases, Phase I may incorporate updates to the database or the municipality may move directly to Phase II.

Phase II

Phase II is the analysis phase of the project, consisting of pipe and structure condition assessments and stormwater system modeling. Condition assessments are performed for each pipe and structure in the system. Pipe assessments involve videos and reports for each pipe, resulting in a rating which designates a recommended replacement timeline (e.g., 0-1 years, > 20 years). Stormwater structures are assessed in a similar way, but with photos instead of videos.

The next step is to import the GIS data collected in Phase I into a stormwater model. Most modeling software coordinates well with GIS data files, making it easy to build a system network ready for analysis. The analysis can look at several different storm events for various types of designs, such as roadway design, water quality design, detention, and more. The model is built either for current land use, future anticipated growth, or both. Once the network, storm event, and land use are ready, the model is run and calibrated using many known factors, including locations of known flooding provided by residents or the City’s Public Works Department. The model is able to determine which pipes or structures are undersized and where flooding is occurring for existing and future conditions.

Phase III

Phase III offers solutions to the issues uncovered in Phase II. The data obtained during the condition assessment is used to list and prioritize all pipes and structures in the analysis area for repair or replacement. With input from the City, prioritization is based on criteria such as the condition ratings, flooding locations, undersized pipes, location in relation to other pipes with poor ratings, proximity to future projects, etc.

The next step in Phase III is incorporating this information into the Capital Improvement Plan (CIP). The plan includes the pipes and stormwater structures requiring repair or replacement in the near future, as determined during the prioritization stage. Repair or replacement options may consist of trenchless lining, spot repair, or full replacement. The CIP will also use the model developed in Phase II to determine which pipes need to be upsized for existing or future land use or identify areas that may benefit from detention. The goal is to find the most economical solution that also protects residents and the environment. In addition, the CIP may include more programmatic changes, such as the implementation or updates of stormwater ordinances, implementation of stream buffer regulations for water quality, or suggestions for cities to purchase inundated parcels to create wetlands or natural areas which can be used for water quality improvement, detention, or educational experiences for students or residents.

Partial map showing overall pipe ratings.
Partial map showing overall pipe ratings.

To come full circle, the results from Phases II and III can be added back into the GIS database. From the condition assessment, the condition ratings can be added to the database so it can easily be queried to establish how many pipes need to be replaced in the next 5 years. Flow rates or undersized pipes can also be noted in the GIS database, based on results of the model. The photos, videos, and reports can be linked to each pipe or structure so any city employee can click on a pipe, see the rating, and bring up the inspection report or video. This is helpful for instances in which a resident call and complains about flooding at their house. Someone at the City can quickly find the pipe in front of the house and may discover that the pipe has roots growing into it which block flow, or that the model shows the pipe is undersized. The City can cut the roots out of the pipe, make a note in GIS, and monitor the area during the next storm to ensure the issue has been resolved. If the pipe was undersized, the city can check if, or when, the pipe is slated to be upsized.

The repair or replacement timelines determined during Phase III prioritization can be added to GIS for a visual reminder. GIS can also be used to create exhibits for the CIP, as well as for materials for presentations or brochures for the public. As pipes or structures are replaced or repaired, the GIS database can be updated to show the new sizes or materials, as well as the install date. That way, the city can be sure their system map is up to date to make it easier for maintenance crews, assist with NPDES permitting, better serve residents, and more.

Government Engineering Land Development Municipal
WORKING ON TOMORROW
CONTACT US

Do you want to learn more about GIS? We can help.

Follow our journey.

Take a look inside our Corporate Headquarters located on Lower Main in Dubuque, Iowa! Prior to our move in August of 2021, Origin's Architects designed a collaborative and creative space for our employees and clients! Learn more about the remodel here.

#origindesign #creatingabettertomorrow #itstartshere

We're stopping by the Iowa League of Cities Conference in Cedar Rapids, Iowa, next week! Stop by Booth 118 on September 20 & 21 to chat with some of our #origincrew about how we're creating a better tomorrow!

#origindesign #workingontomorrow #itstartshere

#workingontomorrow Check out the new Fayette County Maintenance Facility we recently completed! Origin Design partnered with Fayette County Engineers to design a new modern maintenance facility and we think it turned out pretty great! Check out the project profile to learn more!

#origindesign #creatingabettertomorrow

#yourfuturestartshere We're looking for a Senior Structural Engineer to join our #origincrew! Are you or someone you know looking for a new opportunity in the A/E Industry? Check out our careers page to find out more and apply now!

#origindesign #hiring #workingontomorrow

Today is the day! Stop by Booth 25 at the ISAC Annual Conference today to learn more about Origin Design's Services! Julie Neebel and Courtney Wand can't wait to see you there!

#workingontomorrow #origindesign #itstartshere

We're stopping by the ISAC Annual Conference next week! Stop by Booth 25 to chat with Julie Neebel and Courtney Wand to learn more about what Origin can do for you!

#origindesign #creatingabettertomorrow #itstartshere

#workingontomorrow Check out these completed photos of Comiskey Park in Dubuque, IA! We were so excited to partner with Saiki Design, the City of Dubuque Leisure Services and Portzen Construction on this project to provide the community with a vibrant new place to play!

Photos Courtesy of City of Dubuque.

#origindesign #landdevelopment #itstartshere #connectionstartshere

Come join our #origincrew! We're looking for Architects, Engineers & Land Surveyors with a passion for creating a better tomorrow in the communities we serve! Think we may be the right fit? Check out our careers page & apply now!

#hiring #architects #engineers #landsurveyors #origindesign

Happy 5th Anniversary, Codi Putnam! We're so lucky to have you on our #origincrew! We can't wait to see what you accomplish in the next 5 years!

#origindesign #workingontomorrow #itstartshere #5yearanniversary

#yourfuturestartshere We're hiring a Professional Land Surveyor to join our #origincrew! Learn more and apply now!

#origindesign #workingontomorrow #hiring #landsurvey

#workingontomorrow Check out these photos of Holy Ghost Early Childhood Center in Dubuque, IA. Origin Design Architects collaborated with Holy Family Catholic Schools on this renovation project!

#origindesign #creatingabettertomorrow #itstartshere #architecture

Gabe Bonn is officially a licensed surveyor in Wisconsin! Join us in congratulating Gabe on this awesome achievement!

#origindesign #workingontomorrow #itstartshere

See all posts