topic Re: GIS in Water/Wastewater Treatment Plants in Water Utilities Questions

GIS in Water/Wastewater Treatment Plants

TimHayes — Mon, 27 Aug 2012 17:24:18 GMT

I work at a large Wastewater Treatment Plant. We have constructed a Geodatabase for all our Plant's Piping, Valves, Manholes, and other assets (including Electrical and Fiber Optic). Our Plant staff routinely use our ArcGIS Server Map Viewer (constructed in Flex), for example, to locate Piping and Isolation Valves which can be done in a matter of seconds. Whereas before GIS, the staff had to scounge and pile through dozens of drawings to locate what they need which sometimes took hours or days. Thanks to GIS we now know where all our buried utilities are located in a very specific sense instead of the general area. To date we have 78 piping systems, hundreds of miles of piping (above ground, buried, in tunnels, and basements), 1,200 isolation valves, 300 manholes, etc... in our Plant GIS.

Are there other Water or Wastewater Treatment Plants that use GIS? please share your stories/experiences. Why did you choose to use GIS? Why are you not using GIS? What barriers have you or do you expect to encounter? How are you using GIS?

NOTE: This is not GIS for distribution/collection systems, this discussion pertains specifically to GIS inside Water/Wastewater Treatment Plants.

Re: GIS in Water/Wastewater Treatment Plants

Anonymous User — Thu, 30 Aug 2012 14:00:10 GMT

Tim,

I'd like to discuss this in further detail if you have some time. A number of our clients want to take this step, but aren't quite sure how to go about this process.

When you get a chance, send me an e-mail.

Seth, Sr. Account Executive
sjohnstone@esri.com

Re: GIS in Water/Wastewater Treatment Plants

Mai_PhuongAnh — Tue, 02 Oct 2012 03:10:34 GMT

Our company also works in the field of water treatment, we are specialized in water treatment.I am also exploring the application of GIS in water treatment, operation how
Can anyone show me more?
Thank you

Re: GIS in Water/Wastewater Treatment Plants

michaelcollins1 — Tue, 02 Oct 2012 11:17:19 GMT

Check this out, the world's first Information Utility.

http://www.ssmic.com/index.cfm

Paul Beach (GISP - Manager - Community Geomatics Centre) gave a talk at the Centre of Geographic Sciences while I was there, sounds like a good place to start.

Re: GIS in Water/Wastewater Treatment Plants

ReneRubalcava — Tue, 02 Oct 2012 21:14:04 GMT

I'd love to hear more about the labor involved in the work you had to do for a project like this.

We plan on doing this with our plants at some point, but we just don't have the staff to process design drawings to GIS, even for our smallest plant.

Re: GIS in Water/Wastewater Treatment Plants

Mai_PhuongAnh — Wed, 03 Oct 2012 01:18:43 GMT

In fact that our company often carry out small projects due to the limited capacity, we now want to explore the application of GIS in the field of water treatment to prepare bidding for larger projects requiring more experience

Re: GIS in Water/Wastewater Treatment Plants

TimHayes — Wed, 03 Oct 2012 14:51:27 GMT

I'd love to hear more about the labor involved in the work you had to do for a project like this.

We plan on doing this with our plants at some point, but we just don't have the staff to process design drawings to GIS, even for our smallest plant.

You state exactly the problem most or all Plants have regarding getting their infrastructure into GIS, let me expand on this, based on my experience in meeting with dozens of Plant staff across the US over the past 4 years.

What are the barriers to Plants in getting their infrastructure into GIS?
- Lack of staff.
- No one qualified to use GIS. Most Plants remain focused on Operations and Maintenance. Some have moved to Asset Management, but without the GIS side.
- Lack of visionary leadership to hire, train, retain GIS staff. Most Plants operate in a very traditional sense where you have Operators, Maintenance Technicians, and a few Engineers only. It is very difficult to change a cultural mindset to accept GIS.
- Lack of time to review/convert their drawings.
- Thinking that Asset Management is GIS; not true. Our Plant's GIS is separate from our Asset Management System. However, we have it linked to several Feature Classes, but not all of them. Our Plant staff routinely use our Flex Map Viewer (that the GIS Team built for free) to view piping maps and valve locations among others. Our CMMS is only accessed for work orders, but many times they just need to see what is where and what it is connected to. This is where GIS comes in to use outside the CMMS. GIS-Asset Management-CMMS are all complementary.

What approach did we take for our Plant?
- Hire dedicated staff, we have a GIS Team of two people. Full-Time. This is all we do. We are under the Maintenance Division and report to the Division Manager. (Note: we do not oversee our Asset Management System or CMMS, this is another group, all we do is GIS)
-As with most GIS professionals, they possess little or no knowledge about Wastewater Treatment Plant Operations. We had to learn from scratch, took us about 2 years to become proficient to the level of a Grade 1 Wastewater Treatment Plant Operator. We were mentored by our Senior Operators and did a lot of walking around and reading. Only then did we feel comfortable in knowing how to apply GIS to a Plant.
- You cannot take the approach of "just scan all the drawings in, convert them to GIS, and you are done", this is a common approach with Distribution/Collection Systems. To build a successful Plant GIS, you must do this, and learn about your Plant by talking to people and walking around. We call this approach "going Plant walkabout". Each one is unique, and a lot of the infrastucture is not in drawings. Expect GIS to be a critical part of the Plant like Operations, Maintenance, SCADA, Engineering, etc..
- You cannot expect to hire a consultant, have them do all your work, then after they walk away, who is going to maintain this massive GIS? At our Plant, we have 62 Feature Classes, 12,000 Records, 10gb of GIS data residing in our GIS; including several in-Plant Hydraulic Models. We make daily changes to the data based on our findings in the field. This is not something that can be maintained by a consultant and then "walked away" from when the work is done.
- Limit the use of consultants, we went through 3 consulting firms who were of limited or no benefit to us. GIS consultants may know their distribution/collection system GIS, but they know little or nothing about Plant GIS. This posed such a problem for us that we made the decision to do all the work ourselves with our GIS Team.

BOTTOM LINE:

- 2 people Full-Time, 4 years and counting. At our Plant, GIS is here to stay. We have achieved a level of data quality now where we are able to move into hydraulic modeling and electrical system modeling.
- Drawing conversion to GIS took 1 person, a full year to complete, 40-50hrs per week.
- We have spent $50,000 on GIS consultants with no plans to spend any more.
- For a GIS person, depending on the size of your Plant, expect at least 1-2 years of learning the various systems and how the Plant operates. It is more than just learning how the water/wastewater is treated. You must learn about the dozens of processes that allow it to reach that point of treatment.
- Expect to get "dirty", we spend 60% of our time outside the office in the field. You cannot be a "desk jockey" or "business casual" type person for this sort of project.
- If you are so inclined to embark on this sort of endeavor, I highly recommend you read "Wastewater Treatment Engineering" by Metcalf & Eddy.
- Finally, expect a huge challenge. I have been in GIS for 20+ years and this is the most complex, challenging, and enjoyable project I have ever embarked upon.

I need to note that our Operators, Maintenance staff, and senior managers all see a tremendous value in adopting GIS. They are very happy with the results and are keen to take advantage of GIS further. According to them, it is well worth the investment.

Re: GIS in Water/Wastewater Treatment Plants

JaromHlebasko — Fri, 05 Oct 2012 22:30:00 GMT

From what I can read, you know your systems inside and out. Would you ever consider sharing your geodatabase schema or data dictionary to provide a relevant example of how you accomplished this mind-boggling task? I am always looking for ways to improve our GIS infrastructure and would love to see a working model.

Thank you for your time!

Jarom

Re: GIS in Water/Wastewater Treatment Plants

JoshuaDamron — Mon, 08 Oct 2012 15:22:46 GMT

Wolsely,
Your post peaks the interest of a lot of public works & sewer district folks. The insight you give to the level of dedication required to �??manage a plant right�?� is impressive. Sounds like you work with a great organization, Many of us find it difficult to change upper managements perspective of GIS from a mapping system to a "how we do our daily work" management system. I would parrot ramon�??s interest in a geodatabase schema.

Your post is of immediate interest to me as I�??ve just received CAD dwgs for my City�??s shiny new $+30 million wastewater treatment plant/reclamation facility and I am putting together a plan to make the most use of the CAD work. Up till now our GIS has been entirely focused on distributions/collections for W/SS/SD. Our GIS has effectively mapped everything up to the treatment plants, from there our water & wastewater treatment facilities have consisted of a single named point in the GIS. Mapping out a treatment plant is a new world to construct and I have the opportunity to do it right. Of course I have to figure out what that means. You mention an engineering book as reference, are there any other resources that you utilized in building your GIS model?

You mention that you can't "just take the drawings and stick them in the GIS", I agree entirely. I have a hard time picking the Plant Operators brains to figure out what functionality the GIS offers that they would use daily to make it more that just a mapping program. Could you give some insight into what functions you have designed into your GIS to make their daily tasks easier so they buy into it?

Most of us in the GIS world have a hard time moving away from using GIS as a mapping program. Moving my focus from a broad collections system where everything is either at the surface or underground, I�??m not sure how to approach the many elevations encountered with a treatment facility. As you know there�??s piping above ground, below ground, in buildings and crisscrossing each other in every way in between (the attachments show some of these issues). How do you illustrate all of that to keep track of it let alone make it so operations crews can view it and make sense of it? Do you have different feature classes that you show/hide for different elevations? Did you somehow create cross section views? If nothing more I would love to see some screen shots of how you brought all of this together.

Another issue is the level of detail. Since building GIS for a facility is a very micro view of our infrastructure some people seem to think that it should be shown in greater detail. How did you decide what level of detail to go into? When it comes to many things like pumps and blowers, it seems to me that I would draw them simply as a point or polygon. However at different scales each has its benefits (If I�??m looking at the actual blower room a polygon shows the area/volume of the room taken up vs looking at the whole treatment facility a polygon will disappear and a point makes sense. In my experience duplicating features between feature classes is not a standard practice. In your experience have you had to store the same structure in two feature classes for the visual aide benefits? Another aspect of this issue is that Operations is wanting me to draw things with the line work detail like they show on the plans for things like pumps and blowers, which since I have the CAD I can do with only a bit of work but I don't think it is realistic to go into such detail (see attached for examples).

How did you balance between what attribute data is stored in the GIS vs your asset management system? Next fiscal year we will be moving to an asset management system and when it comes to some of the nitty gritty structures of a treatment plant I�??m not sure what to expect to be handled by a asset management system vs GIS. Any insights into this are aprpacieted.

Have you found it worth while to track pipe fittings?

Lots of questions. Again, any thoughts you would like to share would be greatly appreciated.

-Joshua

Re: GIS in Water/Wastewater Treatment Plants

TimHayes — Thu, 11 Oct 2012 02:04:22 GMT

From what I can read, you know your systems inside and out. Would you ever consider sharing your geodatabase schema or data dictionary to provide a relevant example of how you accomplished this mind-boggling task? I am always looking for ways to improve our GIS infrastructure and would love to see a working model.

Thank you for your time!

Jarom

Yes, I am working with ESRI to get our Data Dictionary/Schema/Data Model posted to their site. I expect to have something posted to the ESRI site within 3 months. We just completed our migration from a File Geodatabase to SQL Server Express 2008 R2. With 10.1, this migration was made a lot less painful.

Re: GIS in Water/Wastewater Treatment Plants

TimHayes — Thu, 11 Oct 2012 03:02:56 GMT

Joshua,

I have endeavored to answer your questions as best I can.

I am working with ESRI to have our Wastewater Treatment Plant Geodatabase Schema posted to the ESRI site within 3 months.

You're fortunate to have a new Plant, our Plant, the San Jose/Santa Clara Water Pollution Control Plant, was built in 1956 with many additions/subtractions since that time. Yes, you do have the opportunity to do it right. Your Plant is new with, I assume, good documentation on what is where and what is what on the drawings. For references, all we used when we started was Wastewater Treatment Engineering by Metcalf & Eddy. I am also considering taking the Wastewater Treatment Operators Certificate Program at California State University �?? Sacramento. It�??s online. You will need to do a lot of talking with your Plant�??s Operators and Maintenance people when you start a Plant GIS project. We also became certified as Utility Locators and in Geophysical Subsurface Utility Locating, in addition to taking an online course in Subsurface Utilities Engineering.

Our primary focus when we were transferred out of our Distribution/Collection System, into our Plant, was, �??find where all our buried utilities are located inside the Plant and put them into a GIS�?�. This was our focus for about 3 years. We managed to identify all that is buried where, with the exception of electrical (60% complete so far); irrigation (10% complete so far); and Cathodic Protection (5% complete so far). Everything else from our 70 + piping systems in use or abandoned is now in our GIS database. We followed ASCE 38-02 Subsurface Utility Engineering Guidelines for this project.

Results: first, our Plant staff can now go to our ArcGIS Server 10.1 Flex Map Viewer and see all the piping (buried or otherwise), duct banks, isolation valves, planimetry (structures, tanks, buildings, tunnels, etc�?�) overlain on a 3in res digital color aerial photo (our basemap). Whenever a pipe leaks or they need to find a valve, the first place they go is to our MapViewer to see what could be leaking and where the isolation valve is located. Given that it is in 2D, no 3D or isometric views, we have a field in our Pipes Feature Class for pipe location (buried, tunnel, crawlspace, building, above ground, underwater, covered trench, etc�?�). 3D GIS is still not there yet for inside Plant use. Second, we implemented a Plant Subsurface Utilities Management Program which includes the GIS staff doing the USA work inside the Plant and using Ground Penetrating Radar (GPR) to find our buried utilities. Third, we instituted a �??Call When You Dig, but only if you find something�?� program. Whenever they are digging a hole or trench and find a pipe, duct bank, conduit, wire, etc�?�they call the GIS Team. We go out there with our Trimble GeoXH 6000 which includes a built-in camera, take a photo and GPS point for what they found. We now have 4,000 GPS locations inside our Plant of identified exposed buried utilities. Now they almost know what is buried where before they do any digging. Fourth, we found an old utility trailer in our �??Boneyard�?�, outfitted it as our field truck (a.k.a. �??The Batmobile�?�), with a cool racing striped paint job thanks to our Plant�??s Paint Shop, and we pull it with our electric cart. It has all our supplies. Those seeing the plethora of tools/technologies that we use working in the field provides us with a degree of �??street-cred�?� among our Operations & Maintenance staff. Plus I always tell our O&M people that it is my job to make your job easier and less stressful!

In our GIS, it also includes Pumps, Heat Exchangers, and Fittings for those piping systems where we plan on developing hydraulic models. All the other piping systems include pipes, all sources, sinks, and isolation valves. This is so we know at the very least where it goes, what it feeds, and if we isolate a certain segment, what will be isolated downstream.

Balancing Asset Management with GIS for inside Plant; we learned some hard lessons on this one. We do not include pipes, there are just too many pipes inside a Plant, and the 2D view of GIS makes it a mess to work with in terms of work order management. We only include certain point features; Electrical Manholes where PM�??s are performed on the Sump Pumps, and Backflow Preventors where PM�??s are also performed upon. Whenever GIS and CMMS reaches the point of 3D or isometric viewing for pipes and pipe racks which is needed for inside Plant application, we will then consider whether to include pipes and other feature classes.

Note that we use InforEAM 8.5 for our Asset Management Program with no plans to change to another software. Our current software more than meets our needs.

ESRI provides a lot of free software/tools/scripts with the release of 10.1. We found that 2 licenses for ArcGIS 10.1 Advanced, 1 for ArcGIS Server 10.1 Advanced, ArcSDE 10.1, and SQL Server Express 2008 R2, more than meets the GIS software/database needs for our Plant GIS. SQL Server was free! the Flex Map Viewer was built by me for free! all with info found on the ESRI site. There was no need to spend hundreds of thousands of dollars to build a Plant GIS.

Today, I just ordered two licenses for InfoWater for ArcGIS Suite to use for our hydraulic models (this will also help us model Pump Control Settings and other requirements of our systems without having to try it in the field first).

We are working on a "Tunnel View" application to use with ArcGIS, sort of like Google's Street View, except showing the pipes in our basements, buildings, etc... In addition there is some discussion of us purchasing a GPS-enabled UAV ("Drone") to allow us to take our own georeferenced aerial photos on our 5 square miles of Plant Property.

It sounds like you have a lot questions and ideas. E-mail me at timothy.hayes@sanjoseca.gov so we can discuss in more detail.

Tim Hayes
GIS Manager
San Jose/Santa Clara Water Pollution Control Plant
and South Bay Water Recycling Program
San Jose, CA

Re: GIS in Water/Wastewater Treatment Plants

TimHayes — Wed, 12 Mar 2014 10:15:44 GMT

Thanks for sharing your experience with us.I want to know that what kind of water treatment you used on your plant????

I work at a wastewater treatment plant that treats sewage. We are not a water treatment plant as we do not treat drinking water. We treat our wastewater to the advanced tertiary level before releasing it.

Re: GIS in Water/Wastewater Treatment Plants

SecuredAcqua — Tue, 23 Sep 2014 05:03:07 GMT

Water treatment plants are of various types like mineral water turnkey projects, mineral water ISI & non-ISI projects, quality control laboratory, packaging machineries, industrial ro system, institutional plant, demineralization plant, water softening plant, pharmaceuticals plants, dialysis plant, jar washing machines, pouch packing machines, rinsing, filling & capping machine, bottle MFG blow molding, gas filling & sealing machine, soda soft drink plant, water purification treatment plant and spare parts etc.

As per your suitability, you can choose from above said product. But while taking investment decision, you have take into consideration various factors. Among these factors, the most crucial factors which affects your investment decision is the amount of risk you can bear. The more is the risk tolerance ability, the more fruitful is your investment decision. The other important factor is your return needs whether you want income or growth. If you want only present income your investment will not be beneficial in terms of long range benefits. On the other hand if you prefer growth, you have to take risk for present income, but with more multiplicative long term benefits.

The crucial factor is the tax burden. Some items carry more tax burden while other may receives subsidies or may carry less tax burden. The investment need is important factor as to what you need at the maturity of your investment. While taking your investment decision, you must consult some experienced person in water purification sector, who can tell you in practical way which water treatment plant could suits your need. So we can say that investment decision is affected by various factors as we have discussed above and if these measures are kept in mind your investment would definitely brings fruitful results in terms of long terms growth, present income and more beneficial business expanding opportunities at reasonable prices but not by sacrificing its quality.

Re: GIS in Water/Wastewater Treatment Plants

RaynerHoward — Mon, 11 Jul 2016 15:43:29 GMT

Tim,

Were you able to post your Data Dictionary/Schema/Data model to ESRI's website? I found an ESRI data model but it is from 2008:

http://downloads2.esri.com/support/TechArticles/Water_Utilities_Data_Model.pdf

Haven't been able to locate your submission. We are gearing up to map a local wastewater treatment plant's electrical system (transformers, generators, pull boxes, switchgears, power poles, power lines, etc.) and would appreciate any information or insight you could provide.

Thanks.

Rayner

Re: GIS in Water/Wastewater Treatment Plants

JohnSchweisinger — Mon, 11 Jul 2016 18:37:02 GMT

One of the Products/Services our company provides is a GIS Field Audit of Assets using GPS. Were you creating these systems using real world locations?