Tag Archives: asset management
Here at Esri, we always try to help one another out. Well the Local Government team asked if we could expand the functionality of the Attribute Assistant and make a series of construction tools to help with address data management workflows; and we obliged. We came up with some pretty cool new rules for the attribute assistant and some interesting construction tools that will be used to streamline address maintenance workflows. Even though these have been designed for managing address information, you may find them very helpful. Let’s first take a look at these new attribute assistant rules.
The first rule we needed to create was CASCADE_ATTRIBUTE. This rule will allow you to make a change to an attribute in a table or layer and push that new attribute value to every feature that contains the value. So in the address world, we have implemented a Master Street Name table. Say a road was renamed, we can go into the table, change the road name, and the rule will open up the Road Centerline layer and make that change to every road with the old name, then open up the Site Address Point Layer and update the road name as well. Pretty cool, huh?
The second rule we created was VALIDATE_ATTRIBUTE_LOOKUP. This rule will validate an attribute change against a look up table or layer. Let’s look out how you would use this in address land. If I created a new road and I want to make sure the road name matches a road in the Master Street Name table, I can set this rule up to monitor my Street Name field and check that value against the Master Street Name table. The cool thing about this rule is all I have to do is enter a piece of the road information. If it finds more than one record in the street name table, it presents a prompt, where you can select any of the matching values. How is that for data validation?
I also mentioned we are working on some new construction tools. These are still in development, but here is what we are working towards. One tool will allow the user to click a reference point, in our case, an address point that represents the location on the centerline of which the address is derived, create this point if it does not exist, then create a series of site address points with information from that reference point or the centerline underneath it. So basically, you can create a series of points all with information from source point. The second is a tool to draw a new road and split any intersecting roads and prorate their address information.
If you want to try the new rules out, as well as a few other enhancements, we have posted a beta of the tools on the forum.
Mike from the Water Team
What keeps water, wastewater and stormwater utility GIS professionals up at night? Could be doubts about your system architecture or capacity, might be fears about data backups and recovery, maybe your backlog of unprocessed as-builts. A common concern we are hearing right now from the user community is about being sure that your data is good enough to meet the needs of your utility. This is driving more water utilities to focus on quality assurance (QA) and quality control (QC).
Across the industry water utilities are expanding their GIS quality control procedures or implementing formalized quality control if they don’t have any in place. Water utilities are also reviewing their existing GIS implementation and workflows for ways to increase quality assurance. At some water utilities these changes are coming out the GIS department, driven by proactive GIS managers and staff. At other utilities these changes are coming top down from utility management that recognize GIS data now runs throughout their utility like a steel thread or from the IT department as it assess the state of all utility digital data.
But haven’t we always been concerned about data quality?
No doubt, if you’ve seen Esri present on water, wastewater or stormwater utility GIS over the past year you’ve probably heard us talk about how GIS fits into the “business patterns” of a water utility. We’ve gotten tremendously positive feedback from the water utility community that this framework helps people understand how GIS supports their mission as a utility. We’ve also heard from GIS professionals that this is a very useful framework t to educate their colleagues about the current and potential future contributions of GIS at their utility.
We thought it would be helpful to take some time to review these patterns as we will continue to build upon these concepts in 2011 with the Water Utility Resource Center.
This graphic shows 5 common “business patterns” of a water utility – Asset Management, Planning and Analysis, Field Mobility, Operational Awareness and Stakeholder Engagement. Just about all of the activities of a water utility fall within one or cross multiple of these business patterns
Let’s review these 5 common water utility business patterns and how GIS supports them.
The Asset Management Business Pattern
All utilities engage in some form of “asset management”. Increasingly utilities are creating formalized “asset management programs”. Even without a formal asset management program (and a program in this case doesn’t imply a software program, it means an organizational initiative) many utilities have informal workflows and procedures that guide decision making around managing assets. So from a hunch about what assets need to be replaced or maintained to hard scientific evidence, utilities are constantly making decisions about their assets.
The cornerstone of effective asset management at utilities is good asset information. Whether a utility has a formal asset management program or an informal one, decisions require some level of information about assets – from knowledge in a worker’s head to information in a computerized system.
GIS supports the Asset Management pattern of water utilities through being the authoritative system to store, manage and maintain accurate asset records that are able to be shared utility wide. Simply put, GIS manages asset information.
It’s important to note that it’s common at water utilities for the complete information about an asset to be stored in multiple systems. For example, GIS stores the location, connectivity to other assets and basic descriptive information (material, diameter, install date, operational status, etc) about an asset, a workorder management system (also called EAM or CMMS) may store extended information about the work history for an asset, a financial system may store depreciation and valuation information for assets, a customer information system may store complaints about the function of an asset, etc. Optimally there is integration among all of the systems that store information about an asset and the ability for utility staff to access data stored across multiple systems enabling a comprehensive view of the location, connectivity, status, history and description of an asset.
Going Beyond Managing Asset Information with GIS
In the early years of water utility GIS, the bulk of GIS activity for water utilities was focused on creating and maintaining GIS data about assets and that data was used to make maps. GIS was usually the domain of a few folks in the utility that were tasked with continually updating data to support the creation of paper maps for the field and the office.
Over the years, many utilities have evolved their GIS to much more than just a siloed system to manage asset data to make maps. Around the industry utilities realized that their GIS contained a treasure trove of information that could be shared across the entire organization and used to support many of the information needs of the utility. No doubt, utilities can significantly increase their return on investment in GIS by sharing it around the entire utility and using it to support multiple business patterns.
Planning and Analysis
Historically, when a utility had asset data in GIS, it was a natural evolution to begin using that data to support the planning needs of the utility through spatial analysis.
Water utilities plan for the future and use some form of data analysis to do this. There are normally 2 very distinct types of planning water utilities do – short term planning and long term planning. Short term planning at a water utility is typically focused on creating and optimizing reactive and proactive work orders. Long term water utility planning typically focuses on capital improvement planning and future utility network expansion projects.
GIS supports water utility planning and analysis by transforming asset and operational data into actionable information. So far we’ve focused on asset data; operational data for water utilities is customer complaints, service requests, historic work order locations, etc. Crossing the Asset Management business pattern we described above and the Planning and Analysis pattern encompasses what many in water utility industry consider define as a utility asset management program.
For short term planning, GIS is typically used to support creating and optimizing work orders. Answering questions such as what is the best route to accomplish my daily work tasks and where can I do some proactive work in close proximity to assets that need reactive work. GIS is also used to understand what assets you should do proactive work on and when you should do it. An example is answering questions about which sewer pipes take flow from restaurants that are frequent grease trap violators resulting in the need for pipes to be cleaned more often to prevent fat, oil and grease build up from causing a blockage and overflow.
For long term planning, asset data, performance data and GIS analysis is used to help utilities understand how their utility networks are performing. Then to identify the best replacement and rehabilitation projects to undertake and to estimate project costs to support project evaluation and budgeting. For example, water utilities use repeatable geoprocessing models that take into account many weighted factors to rate their assets on condition, reliability, criticality, performance, etc. This information is then used to help guide where to best spend capital dollars to maximize the value of investments in a utility’s assets. For main extensions; land records, demographic projections and proposed development plans are often used to help guide long term system expansion plans.
Water, wastewater and stormwater utilities have mobile workers that are out in the field for the majority of their work days. In small utilities mobile workers may have many responsibilities such as meter reading, customer service, installs, maintenance, repair work, CCTV, hydrant flushing, valve exercising, etc and in large utilities mobile workers may be specialized.
Mobile field workers at water utilities need information that is current, optimized for their needs to help them carry out their work and delivered in an easy to use format. Mobile field workers also generate much information that needs to be passed back into the office and managed in enterprise business systems.
The field mobility business patterns includes both work the field crews are performing as well as the processes used in the office to support and manage field crews. There is recognition across the industry that field work is a large part of water utility operating budget and for many utilities there is not enough field crew labor available to meet the needs of the utility. Water utilities are always looking for ways to decrease the time it takes to share information bi-directionally with the field and increase the reliability and accuracy of data coming back from the field. The mobile nature of field crews, the many tasks a field crew may carry out during a given day and the limited exposure by some field personnel to technology present a challenge to utilities that need to reduce field operations costs and increase efficiency.
Water utility field staff are among the most map centric people you will encounter. They think of their work world in terms of map book sheets. So for GIS, the Field Mobility business pattern is about providing water utility field crews with maps and map centric applications that can be rapidly updated and are easy to use. GIS also supports the Field Mobility business pattern by enabling field crews to capture GIS data in the field and efficiently pass it back into the office.
Some utilities choose to create paper or electronic field maps books out of their GIS. Other utilities are deploying mobile GIS applications for field crews that act as an interactive version of the traditional utility map book and also provide decision support and data capture tools. Whether delivering paper maps or interactive mapping applications to the field, GIS is supporting the needs of utility field workers as well as those in the office that need to share information with the field.
Talk to a manager or executive director at a utility about their information needs and most often they will say something along the lines of “I need to know what is happing around the entire utility at any given time”. They need to be operationally aware.
The Operational Awareness business pattern is about having an understanding of the current state of operations at a water utility, so this is a real time or near real time understanding of how assets, utility networks and personnel are performing and how they are affecting each other. Being operationally aware empowers water utility managers to confidently make decisions based on accurate and up to date information.
GIS supports utility operational awareness by enabling utilities to have a web map based view into the current state of operations. We’ve heard over and over from water utility managers that a map based view into their organization is the easiest way for them to understand at a glance what is currently happening at their utility. An interactive map is also an easy way for utilities to take information from multiple business systems and present it through a common application.
What do water utility managers want on their interactive maps? Most want their utility networks overlaid with locations of recent callers, new service requests, open workorders, out of service customers, crew locations, limited SCADA information, recent sewer over flows, planned capital projects, etc. They would also like to be presented with KPIs and metrics derived spatially, utilize heat maps to spot trends, be able to see historic operational data on demand and be able to zoom far enough in to see all of their utility assets in detail as necessary.
Thinking about data that utility managers need to be operationally aware brings about an important point. Much of that data comes from other enterprise business systems used at utilities and can be spatially enabled by a GIS so it is placed on the map.
Water utilities have many external stakeholders such as customers, elected officials, regulatory agencies, other utilities in their service area, etc. The Stakeholder Engagement business pattern encapsulates how utilities interact with external entities that are affected by the utility.
Across the industry, the trend is for water utilities to more proactively engage with stakeholders through public outreach programs, providing more transparency while delivering information in a way that minimizes the possibility of misinterpretation. Modern water utilities recognize they need to utilize the internet and social media to communicate with their stakeholders. Presenting up to date information via interactive maps is a powerful medium to communicate with the technology savvy stakeholder.
Utilities use GIS to support Stakeholder Engagement by creating and delivering static and interactive maps. For years GIS has been used by utilities to make maps that were submitted either electronically or as a hardcopy for regulatory agencies. Utilities have also used GIS to make static maps available as an image file or PDFs on their websites. Now utilities are creating public facing web mapping applications for their stakeholders to support things like customer self service, capital project coordination, service interruption incident management and transparency into utility performance.
We hope that you’ve found this exploration of how a pattern based framework for how GIS supports the needs of water utility useful. As always, if you have any comments on this blog please share them.
The water utility industry is increasingly recognizing GIS as an authoritative repository of utility asset information that can be shared around the entire utility and can spatially enable other utility business systems. As a result water, wastewater and stormwater utilities are increasing focused on GIS data accuracy. More specifically water utilities need to ensure that their GIS data is positionally accurate (in the right place), descriptively accurate (describes the asset appropriately) and temporally accurate (up to date).
On February 15th Esri’s Water Practice and the Data Reviewer team will be offering a free webinar to discuss how water utilities can leverage the ArcGIS Data Reviewer as well as core ArcGIS functionality and the Water Utility Resource Center Templates to create and safeguard accurate asset data. You can sign up for the webinar here:
The recording of the November 16 2010 ArcGIS 10 Water Utility Template Updates Webcast is can be viewed here:
As was requested during the webcast, we’ll be posting the most popular questions we received and answer to the blog shortly.
We’d like to also take this opportunity to thank everyone who participated in the live webcast and remind you to fill out the post webcast survey email. Feedback from the water, wastewater and stormwater GIS user community directly drives our actions.
On November 16th at 1:00 PM EST we’ll be giving a
webcast that explores the ArcGIS 10 updates to the Water Utility
Templates. You can sign up for the
webcast here: http://events.esri.com/info/index.cfm?fuseaction=showSeminar&shownumber=14102
During the hour long webcast, we’ll be focusing on changes
between the 9.3.1 versions of the Templates and the ArcGIS 10 Templates, highlighting
some of the new functionality of ArcGIS 10 that we are leveraging with the
Templates, talking about installation and configuration of the Templates and
demonstrating the Templates in action.
For those who are unfamiliar with the Water Utility Templates,
they are free downloadable configurations of ArcGIS for use in the water,
wastewater and stormwater industries. So
even if you aren’t using the Water Utilities Templates now, this webcast will
give you an overview of what they are, how they can benefit you and how you can
configure them for your organization.
We’ve created a LinkedIn Group for the Esri Mid-Atlantic Water/Wastewater Special Interest Group so we can share more details about our first meeting and answer any questions. Here is a link to the group – http://linkd.in/bum9lz
Going forward we’ll be using this LinkedIn group to plan future SIG meetings and hope it becomes a useful forum for water, wastewater and stormwater ArcGIS users in the Mid-Atlantic region.
As we’ve previously announced, the SIG’s first meeting is at the ESRI Mid-Atlantic User Group Conference December 1st in Philadelphia, PA. More information about the MUG Conference and the SIG can be found here – http://bit.ly/bZGvCX
We’d also like to announce that we’ve selected our first user presentation for the December 1st SIG meeting. Joe Spollen will be presenting on “A Day in the Life of a Water Company GIS Analyst”. During this presentation Joe will share his experience using ArcGIS Desktop and Server applications at a large private water utility to maintain water distribution system data, create and share maps, support capital planning and other common daily tasks for water utility GIS users.
We’ll be sharing more of the agenda as we confirm other user presentations.
The trend in the water and sewer industry is for utilities to capture and maintain in GIS more detailed information about their utility networks at a higher level of precision.
Yet most water utilities are still trying to display all of this increasingly detailed data using the same paper map products they’ve historically used, particularly for use in the field.
Simply put – it ain’t easy to get all of the data in your geodatabase onto paper field maps using the same scale and map grid that your utility has always used. Continue reading
We recorded a quick video to show you some of the enhancements with the templates at ArcGIS 10. Here is one we are working on now. If you have any other suggestions, please let us know.
One of my favorite topics of discussion is the relationship between GIS and enterprise asset management and in particular Enterprise Asset Management (EAM) Systems. This discussion happens with increasing regularity as most water utilities now have multiple computerized systems that store information about their assets and GIS is part of their system of record for asset information.
Breaking down silos of information
If you think about it, for years utilities have had pieces of information about their assets in multiple places. For example paper as-builts (or perhaps even linens or mylars) describing what was constructed (or should have been constructed), maybe old project records with financial information that describe what it cost to put assets into operation, in other places paper work orders that described the level of effort to keep assets functioning. You could rightfully call these silos of information – they all may be describing the same asset, with different primary pieces of information (and most likely some overlapping and contradictory information) and perhaps at different times in an asset’s life-cycle. There was no interconnection between these information sources and often no senses of which was one was more correct or authoritative.
We’ve now moved into an era where most utilities have taken advantage of information technology (in some form) to store and maintain their information. Instead of manual drafted paper maps utilities use GIS, instead of handwritten ledgers to track payments utilities use billing systems, etc. Common IT systems used at water utilities are billing, financial, workorder (CMMS), GIS, SCADA, CIS, LIMS, etc.
Utilities still have pieces of information about their assets in multiple systems, but now they are computerized systems. This means it’s still possible to have different descriptive information about an assets, costs associated with an asset, performance of an asset (perhaps describe by SCADA data or indicated by customer complaints) in multiple systems and that data may conflict. So it continues to be a struggle for many utilities that still have to go to multiple systems to get a complete understand of their assets and it may also be a struggle to know what is authoritative information when data in multiple systems conflict.
Some utilities are overcoming these challenges by specifying how their enterprise IT systems must work together. This often takes the form of identifying where data is at a utility, how it’s maintained and then determining how systems should integrate with each other to share information and what systems are the “system of record” meaning they own the data. It’s important to note that you may have multiple systems working together (properly integrated) that form your system of record. So the “system of record” determination may happen on a field by field basis.
Enterprise Asset Management
The interesting thing about enterprise asset management is that it’s both a concept and now the name of a class of software commonly used at utilities and facilities. A few years ago a trend started in the utility and facility industry where vendors of workorder and CMMS (computerized maintenance management systems) began to refer to themselves as “Enterprise Asset Management Systems”, reflecting that the systems that create workorders and manage maintenance tasks (both planned and unplanned) rightfully should participate in the enterprise IT environment. But this has also added to a lot of confusion about how assets are really stored and managed in the enterprise IT environment at most utilities. While now called EAM systems, workorders and maintenance tasks are only part of what a utility needs to truly manage their assets.
From our experience with large water and sewer utilizes, enterprise asset management is something that is only achievable with multiple systems at a utility that are properly integrated. After speaking with many utilities big and small, it seems like what utilities want for enterprise asset management is the use of integrated information from multiple systems to enable a utility to best manage their assets. It’s the best data from each system to describe what an asset is, how it affects others related things (customers, service levels, other assets in your network), what its condition is, maintenance history, cost to build, cost to maintain, criticality, etc. That data should be maintained in a way that it’s created or maintained one time and then stored in the appropriate system in a way that’s transparent to users. So enterprise asset management as a concept is really the ability to access and use the right pieces of information (and that information needs to be descriptively and temporally accurate and authoritative) from enterprise IT systems at a water utility.
GIS, Enterprise Asset Management and EAM Systems
So how does GIS play a role in enterprise asset management? Spatial location is typically the one common aspect among all of the data at a water utility. We can understand the relationship between customers and distribution or collection system assets by their spatial location and interconnection. A map is often the easiest way for humans to aggregate many sources of data together to visualize them all and understand how they affect each other. When we spatially enable our utility data we can then use the analytical power of GIS to gain a better understanding of how our assets are performing and how they affect our level of service and our customers. From years of working with utilities, we’ve seen GIS consistently be the gateway where large amounts of asset data enter a utility and where its basic characteristics (location, size, installation date, material, etc) is maintained. So maps from GIS are the place to visualize, analyze and explore many pieces of asset related data and also enable you to propose ways to manage your assets better (maintenance, rehabilitation or replacement) and understand the impact.
Interestingly, when you look at how modern EAM systems (workorder & CMMS) are implemented at water utilities, they almost always have a GIS integration component that includes a toolbar in desktop GIS to keep assets in sync between the GIS and the EAM and also uses server based GIS to give a spatial view of assets and workorders to utility staff that are dispatching and managing workorders. So the way EAM systems are integrated with GIS underscores the concept that enterprise asset management is about utilizing the best information from each system that stores data about assets.
Want to share your experience or thoughts on this? Feel free to post a comment.