Latest Contributions by TomDeWitte

Thru 2021 the Esri Gas team worked with multiple natural gas organizations to help them deploy ArcGIS Field Maps to construction crews. This effort builds on the Tracking and Traceability capabilities such as GPS, Laser Range Finder, and barcode scanner integration accomplished prior to 2021. The 2021 effort resulted in many enhancements to automating the construction documentation process. A few of these enhancements include: Realtime decoding of the barcode Compatible unit table lookup for non-barcoded plastic and steel assets Automatic assignment of Construction Project ID to collected assets Automatic assignment of PressureTestID to all tested assets This video demonstrates how a configuration of ArcGIS Field Maps can be used to address the mobile as-builting needs of gas organizations. ... View more

District Energy Banner.png By Tom DeWitte and Tom Coolidge Last month, Esri released an updated version of the District Energy Data Model. This release continues Esri’s practice of maintaining a template data model ready “out-of-the-box” to manage district cooling, district heating, and steam data within an Esri geodatabase. Why District Energy Data Model The goal of the Esri District Energy Data Model is to make it easier, quicker, and more cost-effective for district heating, district cooling, and steam utilities to implement the ArcGIS platform. Esri accomplishes this by freely providing a data model that takes full advantage of the capabilities of the geodatabase. The data model is created and tested with ArcGIS products to ensure that it works. This significantly reduces the complexity, time, and cost to implement a spatially enabled district energy data repository. District Energy Enterprise Data Management For many district energy utility enterprises, deploying the ArcGIS platform that leverages the concepts of a service-oriented web gis is more than loading the district energy data model into an enterprise geodatabase. It requires additional steps such as creating an ArcGIS Pro map configured for publishing the data model and publishing of the Pro map to create the required map and feature services. To help simplify these additional steps performed with the industry data model, Esri has embedded the data model into a new ArcGIS for district energy solution.  The new solution is called District Energy Utility Network Foundation. This solution provides the data model, sample data, and an ArcGIS Pro project configured with tasks and performance optimized maps. You can access this solution from the Esri ArcGIS for District Energy solution site. A data dictionary for this data model is available online. Best Practice Use of ArcGIS This updated version of the District Energy data model is configured to take advantage of the latest capabilities provided by the ArcGIS technology. This includes recent enhancements such as contingent values, attribute rules, and the utility network. In this data model you will find contingent value configurations to restrict the valid types of pipe insulation and pipe material based on whether the pipe transits steam, condensate, heated water, or chilled water. Included are many attribute rules to automate attribute population as well as provide data quality checks. This data model includes utility network subnetwork configurations for defining pressure zones, circulation areas, leak detection zones, cathodic protection zones, and energy zones. And let’s not forget the thousands of connectivity, containment, and association rules of the utility network. Embeds Industry Business Rules Business rules are a great way to share industry knowledge. Sometimes it is simple, such as ensuring that the maximum operating temperature is greater than the standard operating temperature, or that the in-service date occurred after the date of installation. Others are more complicated, such as knowing when to create a containment association between two assets.  Thanks to the combined knowledge of many persons across the industry, these business rule examples and many more are included with this data model. Modeling Flow thru your Pipe Network Modeling flow thru pipe.png District energy systems often have a dual set of pipes in a single trench. One flows from the energy facility to the customer, the other flows from the customer back to the energy facility. This makes modeling flow through a district energy pipe system unique among the pipe utilities. This data model supports the dynamic tracing of water flow, heat flow, cathodic electric flow, and leak detection circuits across the dual pipe network. A Foundation to Build Upon The official name of this first district energy solution is District Energy Utility Network Foundation. The name was intentional as this spatially-enabled data management solution is the foundation from which many more district energy solutions can be added. With this foundation, district energy organizations can provide analytics, visualization, and data collection solution to their users. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

UPDM Cover image.png Utility and Pipeline Data Model 2021 is Released By Tom DeWitte and Tom Coolidge Esri’s Utility and Pipeline Data Model (UPDM) 2021 is available now. This release continues Esri’s practice of maintaining a template data model ready “out-of-the-box” to manage natural gas and hazardous liquid pipe system data within an Esri geodatabase. This release includes enhancements to keep up with changes in industry practice, regulatory requirements, and previous implementation feedback. Gas and Pipeline Enterprise Data Management For many gas utility and pipeline enterprises, deploying the ArcGIS platform is more than simply loading the UPDM 2021 data model into an enterprise geodatabase. That’s because ArcGIS leverages the concepts of a service-oriented web GIS. It requires additional steps, such as creating an ArcGIS Pro map configured for publishing the data model, publishing of the Pro map to create the required map and feature services and, perhaps, configuring a location referencing system. To help simplify these additional steps performed with UPDM 2021, Esri has embedded UPDM 2021 into a newly renamed ArcGIS for Gas solution. The new solution is called Gas and Pipeline Referencing Utility Network Foundation. This solution provides UPDM 2021, sample data, and an ArcGIS Pro project configured with tasks and performance optimized maps. You can access this solution from the Esri ArcGIS for Gas solution site. A full data dictionary of UPDM 2021 is available online. A change log documenting the full list of changes incorporated into UPDM 2021 is also available online. Enhancements for Managing Cathodic Protection Interest in leveraging ArcGIS to manage Cathodic Protection (CP) data has grown significantly over the last few years. Recent implementations have shown an interest in modeling a more detailed representation of CP systems. With UPDM 2021, our industry data model now includes models for managing the following CP assets: Linear Anode AC Mitigation Wire Decoupler Grounding Point Cathodic Assembly Grounding Mat Feedback from Pipeline Implementations Pipeline implementations of UPDM have been many and varied. These previous implementations have resulted in feedback that has resulted in dozens of adjustments to improve how we model pipeline assets. Two specific enhancements based on previous implementations to highlight are the defining of the attributes “odorized” and “piggable” as Utility Network Network Attributes. Having “odorized” and “piggable” as Network Attributes provides additional capabilities for leveraging tracing. Tracing is the ability to understand how the components of a pipe system are connected, and how the gas and hazardous liquids flow through the pipe system. With this new template configuration, pipeline operators can trace across their pipe system and see where the “piggable” portion stops when it reaches an asset which is tagged as not piggable. Similarly, planners and engineers can trace to see what portion of their pipe system is “odorized.”                    Feedback from Gas Utility Implementations Previous implementations of UPDM in Gas Utilities have also resulted in feedback to help fine-tune the gas and pipeline industry data model. Some of these adjustments include improved modeling of relief valves, flanges, and taps to name a few. Other enhancements include adjustments to the Utility Network rulebase. What is UPDM UPDM is a geodatabase data model template for operators of pipe networks in the gas and hazardous liquids industries. UPDM is a moderately normalized data model that explicitly represents each physical component of a gas pipe network from the wellhead to the customer meter, or a hazardous liquids pipe network from the wellhead to the terminal or delivery point, in a single database table object.     pipe system.png UPDM is the only industry model which can manage a single representation of the entire pipe system.  For many companies around the world this single data repository aligns well with enterprise practices to vertically integrate business processes and operations.  Why UPDM The goal of the Esri UPDM is to make it easier, quicker, and more cost-effective for pipeline operators and gas utilities to implement the ArcGIS platform. The Esri UPDM accomplishes this by freely providing a data model that takes full advantage of the capabilities of the geodatabase. The data model is created and tested with ArcGIS products to ensure that it works. This significantly reduces the complexity, time, and cost to implement a spatially enabled hazardous liquid or gas pipe system data repository. Looking Forward to UPDM 2022 A wise man once said “change is the only constant.” This is a great quote when thinking about UPDM going forward. The Esri development team will continue to enhance the capabilities of ArcGIS. Industry will continue to evolve its practices. To continue adjusting to industry practices and incorporating new ArcGIS capabilities, UPDM will continue to evolve.  This evolution will help assure gas utilities and pipeline operators that their GIS industry-specific data model is current with their needs. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions.       ... View more

Methane Emission Banner.png   By Tom DeWitte and Tom Coolidge The natural gas industry’s drive to a lower or net zero carbon footprint is focused on actions that generally can be organized in three groups: (1) reducing methane emissions from operations, (2) reducing methane emissions from customer consumption, and (3) embracing new sources and uses of alternative lower carbon fuels. This blog focuses on a key activity central to reducing methane emissions from operations – finding and fixing leaks. Managing methane emissions is without a doubt as critical a set of tasks as any every natural gas pipe organization performs.  For the owners and operators of the pipe networks which transport this critical energy source, managing methane emissions starts with surveillance programs to identify leaks. Class 1 leaks are immediately fixed. But low-level leaks are studied via engineering analysis to rank the risk and consequence of those leaks. Once analyzed, construction activities can be scheduled to repair the identified and qualified leaks. This very straightforward set of tasks to “find the leak” and to “fix the leak” have been going on for decades. So, what’s new in the world of methane emission reduction? What’s new for methane emission reduction is the availability of new sensor platforms to “find the leak”. Many Platforms for Detecting Methane Finding the leak has long been a human-intensive process of walking the pipe network. While walking, field technicians will carry methane emission detectors. Once a leak is found, a gas leak report is created to document the location, quantity, and likely source of the leak. Then came the ability to mount methane sensors on cars and trucks. These vehicles could cover more miles of pipe than the walkers. Advancements by manufacturers of these devices have further enhanced these vehicle- mounted sensors to better estimate the location of the source of the leak. These potential leaks are then investigated by field technicians to verify and complete the gas leak report. Sensor Platforms.png   More recently, methane emission sensors have been mounted on aerial platforms ranging from drones to helicopters to planes. In addition to aerial mounted sensors, there are now satellites circling our planet in low earth orbit with methane sensors. These satellite-based sensors sell their data and analytics, providing gas pipe operators with yet another capability to survey the pipe network and “find the leak”. Still Need Those Humans These newer tools to surveil the pipe network do not replace the regulatory requirements of Leak Survey. But they do provide a new affordable capability for higher frequency monitoring. Then when a methane emission is detected, a field technician can be sent out to the emission area to validate the sensor reading and fill out the gas leak report with the details needed for the organization to “fix the Leak”. As powerful as these additional methane detections are, humans are still required to verify and document every leak. Need a Common Repository Adding additional platforms of methane detection opens new opportunities to reduce methane emissions.  It also creates a new, but manageable, data management issue. With these new sensor platforms to identify potential methane emissions, a common data management system is needed to capture, track, and document the status of these potential leaks. With location being critical to each potential leak, A geographical information system (GIS) is the best data management system for aggregating and managing this information. Sensor Platforms 2.png   Critical Information for Gas Pipe System Management Combining the information from these many methane detection platforms into a single data management system is not the finish line.  It is at best mid span. This data still needs to flow into analytical programs such as DIMP and TIMP. This data still needs to be monitored with dashboards, summarized with reports, and communicated to gas executives, regulators, and the public. This data needs to flow to construction and mobile viewing devices enabling the gas organization to “fix the Leak”. That is the finish line. Sensor Platforms 3.png The natural gas industry is enjoying a technological revolution. New technologies are continuously being applied to better solve gas industry problems.  And the gas industry is embracing and implementing these new capabilities at a faster pace than ever before.  Placing your GIS at the center of your methane emission management ensures the data collected by all these new sensor platform technologies is fully leveraged throughout your gas organization. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

PipeRiskAnalysis_Banner.jpg By Tom DeWitte and Tom Coolidge What keeps pipe network utility executives up at night? One common cause is the worry about the consequences of a failure that results in negative impacts to people, property, or the environment. One-way utilities pro-actively seek to pre-empt pipe network failures is investment in repairing or replacing those parts of their network thought most likely to possibly fail. Every year utilities determine which sections of their pipe system will be replaced as part of their capital construction budget. How do utilities know which sections of the pipe system need to be replaced? What are the criteria that should be used to identify and prioritize the sections of pipe for replacement? To many pipe engineers, the answer is to perform a pipe risk analysis. Pipe risk analysis is a method of identifying criteria which will be used to rank which sections of pipe should be replaced. These criteria are quantified and weighted against each other using an equation to tally the total risk score for each section of pipe. What criteria do you use to measure risk? When dealing with pressurized pipe systems, such as natural gas, hazardous liquids, district energy, and water the initial criteria list typically starts with these items:                 -pipe material                 -pipe age                 -pipe installation method                 -pipe insulation/coating materials                 -leak history These items are valid criteria that contribute to the likelihood a pipe system may fail. These types of data are easy to put into a spreadsheet and tabulate. But none of these measures the consequence of those failures and the risk to the organization. Understanding the risk to the organization can only be accomplished by including a measurement of the consequences. Understanding Risk to the Organization Risk to the organization is typically summarized as a cost, with the unit of measure being monetary ($). This cost is much more than simply the expense to the utility to have the construction group replace the identified deficient section of pipe.  When a pipe section fails, it impacts the people and facilities near the location of failure. This consequence cost to the organization often greatly exceeds the cost to replace.  The recent situation of Pacific Gas & Electric declaring bankruptcy after the involvement of its electric transmission lines in forest fires is the exclamation point example.  Every pipe utility industry has multiple examples they can point to which validate that the consequence cost of a failure greatly exceeds the cost to replace. Property damage, loss of life, loss of business revenue, civil lawsuits, and government regulatory fines are just of few of the consequences of failure and its resultant cost to the organization. To measure the risk to the organization, we need spatial tools   Pipe Risk analysis.png   Quantifying the consequence of failure begins with understanding “where.”                 -Where are the properties and facilities nearby pipe segments?                 -Where are the persons who reside or congregate near the pipe segments?                 -Who are the customers downstream of the pipe segment who will be impacted by the failure? Understanding the relationship between your pipe sections in relation to critical facilities, persons, and customers, requires spatially aware-analysis tools. Spatially aware tools, such as those provided with Esri’s ArcGIS products, enable pipe utilities to identify, aggregate, calculate, and quantify these consequences. Understanding Who is Nearby Every person who resides or congregates near a pipe section is at risk of being impacted by the failure of that pipe section. As stated previously, this is key to quantifying the overall risk to the organization. Spatial analysis methods, such as buffer, can define the area near the pipe segment to look for persons and places of gathering. UnderstandingWHO_Nearby.png More advanced spatial analysis methods, such as least cost path analysis, enable pipe utilities to identify the direction in which spilled liquids will flow. Once these spatial areas near the pipe segment are identified, it is a simple intersect analysis against data sets which identify the number and type of persons who reside or congregate within the now identified areas of impact. Pipeline_Spill_Area.jpg  With this analysis capability, pipe utility organizations can quantify the consequence of the failure of a pipe segment to persons. Understanding What is Nearby The cost to the pipe organization of the failure of a pipe section includes not only the impacted persons, but also the impacted facilities. Having your own facilities damaged is bad enough, but also having to pay to repair the facilities of other utilities can be much more expensive. Understanding the consequence of failure to facilities goes beyond electric, telecommunications, and other pipe utilities, it includes transportation network systems such as road and railroad. No pipe utility wants to be the one that caused a major road route to be closed due to the damage caused by the pipe section failure. UnderstandingWhat_Nearby.png The same ArcGIS analysis tools used to identify persons impacted by a pipe section failure (Buffer, Least Cost Path, Intersect, Identity) are the tools used to identify and quantify what facilities are impacted.   This understanding of the consequence of failure to nearby facilities further clarifies the true risk to the organization. But there is still one more critical consequence to be understood and quantified.  That is the consequence to the pipe utilities customers who are downstream of the pipe section which has failed. Understanding Customers Downstream When a pipe section fails, customers downstream of that point of failure will be without the transported commodity until repairs are completed.  This means that natural gas and district heating customers could be without heating in the middle of a winter deep freeze. District cooling customers could be without air conditioning during a summer heat wave. Both consequences of failure can literally result in death to customers. Programmatically understanding and quantifying the impact to a pipe utility’s customers requires a different set of spatial analysis tools. These different spatially aware analysis tools need to understand how the pipe network of pipes, valves, and fittings connect to create a pipe network. Only when a software application understands how a commodity flows through the pipe network can the analysis quantify the consequence of failure to the customers. Understadning_Who_Is_Impacted.png This pipe network aware tool which is critical to measuring the consequence of failure to customers is the downstream trace.  The downstream trace is a configuration of the Trace tool provided with ArcGIS Utility Network. With this type of spatially aware analysis, it is now possible to quantify how many critical facilities such as hospitals, senior living complexes, refineries, power generation plants, and major manufacturing facilities are impacted by the failure of a pipe section. It’s a Spatial Thing Understanding the total risk to a pipe organization requires spatial awareness.  This spatial awareness empowers pipe organizations to improve their capital improvement plans. Engineers leveraging spatially aware tools such as those provided with ArcGIS can quantify the multiplier impact consequences have on threats of failure. Knowing how your customers will be impacted by a pipe section failure is another type of spatial analysis that is also key to measuring risk to the organization. As you can see, pipe risk analysis is spatial. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions.     ... View more

Part 4 of 4 By Tom DeWitte and Tom Coolidge Talking to someone about Tracking and Traceability is typically a discussion centered on a checklist of functional capabilities. Although this is a very important discussion to have, too often the discussion ends when the checklist of desired functionality ends. What is missing is the discussion of how much productivity can the organization gain by replacing legacy processes with a digital process. The discussion of how much productivity can be gained is the base question that every field user, supervisor, and executive should be asking.  The measurement of productivity will be different for each of these gas organization personas.  The field user for example, measures productivity based on time.  How fast can I capture the required information, so I can move on to the next task? The manager has a broader view of the workflow. This person realizes that documenting new construction is a multiple-person activity, involving both field and office staff.  From the manager’s perspective, a measure of productivity would be how fast can the information get from the field construction group, through an office-based quality review and approval process, then posted back out to the entire organization. The executive understands both productivity measurements and adds in the financial cost to the organization. The executive wants to make sure the overall workflow does not include redundant data entry, and has a low IT cost of ownership, as these require the involvement of additional employees. Automating the Field Task The field user responsible for documenting the new pipe construction is always in a hurry to move on to the next task.  Therefore, spending time entering information into the mobile application is not on their top ten list of things they enjoy doing.  This is where ArcGIS, with its attribute rule ability to automate data entry for users of the ArcGIS Field Maps mobile application, can significantly reduce manual data entry. In previous blogs we have presented examples of how attributes rules can decode scanned barcodes and automatically populate the derived data fields. This automation has been extended to handle situations where there are no barcodes. This situation occurs with steel pipe/components and plastic pipe/components where the barcode is unreadable. In this situation, attribute rules are used to auto-populate many data fields by asking the field user to select a value from a picklist on a single data field. The attribute rule then reads a lookup table to retrieve the selected component information and auto-populate the derived data fields. The use of attribute rules for automation can also be used to automatically populate information without the field user entering any information.  A good example is the automatic population of construction project information. Construction projects tend to have a name and a uniqueID.  These construction UniqueIDs and names are the digital glue which link all the field collected data together. With an ArcGIS-based solution, this tagging of assets, pressure tests, exposed pipe inspections, and the many other construction documents is automatic. A configuration of relationship classes and attribute rules is used to free the field user from having to enter this information. Reducing Time to Post State regulators are increasingly pushing gas organizations to reduce the time it takes an organization to post construction changes to field users such as locators.  The simple reason for this push is to improve safety for the field workers and the community to which they provide service. The legacy paper based as-builting workflow is a process that commonly measures itself in weeks, and sometimes months.  A lot of excavation can occur in this lengthy duration between when the construction is completed and when updated documentation is available to field staff to be aware of this new construction. Companies that have migrated to a digital field as-builting workflow are seeing their overall construction to posting times reduced from months/weeks to days.  For example, Spire Energy out of St Louis, MO, has been using ArcGIS mobile apps for capturing their construction changes for many years. Over that time their time to post has decreased from weeks to less than 8 days. And it is still decreasing! Eliminating Redundancy How did companies like Spire Energy reduce their construction to posting time down to less than 8 days?  The answer is that they eliminated a fundamental redundancy in the workflow.  Paper based as-builting has a built-in very expensive duplication.  That duplication is the redline documentation in the field of the construction changes, and then having an office person read, interpret, and recreate the documentation in the final as-built documentation system. Part 4 paper workflow.png With a digital field as-built workflow, this redundancy is eliminated. The field worker can configure ArcGIS Field Maps to integrate with other field devices, such as GNSS receivers, laser range finders, and the mobile device’s native camera for barcode scanning. These integrations allow the field user to digitally capture the new construction data and have this data sent directly to the ArcGIS data repository upon submittal. Part 4 digital workflow.png The office worker is no longer recreating the field collected construction data.  Instead, they verify the completeness and quality of the data, then post it for access by the entire organization’s users.  Low IT Cost of Ownership Often hidden in the as-builting workflow is the time required to get the documentation from the field to the office and after posting, back to the field. In the legacy paper-based redline as-built workflow, the hidden cost is the time for the construction packet to get to the office. In the digital as-built workflow, there is another hidden cost.  That is the IT environment required to get the data from the field to the office. Some digital as-builting solutions require that the data must pass through multiple data environments. Those multiple data environment solutions often add another hidden cost. This undesirable hidden cost is the need for IT to create and maintain extraction, translation, and load (ETL) processes to get the data through these multiple data environments and into the hands of the office staff. Part 4 digital multi-DB flow.png The ArcGIS platform eliminates this inefficient hidden IT cost of ownership. With the ArcGIS mobile application, ArcGIS Field Maps, the field collected data is transmitted directly to the ArcGIS data store. There are no duplicate data stores, no expensive ETL process. Part 4 - ArcGIS digital data flow.png As you can see, the choices a gas organization makes in determining how to digitally document new construction can result in a significant difference in time and cost. Selecting a solution which is functionally complete, and automates much of the data entry, results in field staff completing documentation faster. Selecting a solution which is functionally complete, and eliminates duplicate data entry, results in significantly faster workflows, such as documented by the existing ArcGIS implementation at Spire Energy. Selecting a solution which is functionally complete, and eliminates hidden IT administration, results in a lower cost to IT administration.   The ArcGIS platform with its ArcGIS Field Maps mobile application is the unique solution configurable to provide the functionality and productivity field users, managers, and executives are looking for. If you are interested in deploying this configuration of ArcGIS Field Maps, we have posted all the scripts, data model templates and instructions for this digital field as-builting solution. You can download this configuration from the Esri Community site for free. Here is the link. This blog article is the fourth in a series of four blogs articles explaining how to deploy ArcGIS Field Maps for Digital Field As-builting.  If you missed our previous blog articles on digital field as-builting, here are the links to those articles. Part 1: Digital Field As-Builting with ArcGIS Part 2: Digital Field as-Builting with ArcGIS: No barcode No Problem Part 3: Digital Field As Builting with ArcGIS: Pressure Tests PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

Part 3 of 4  By Tom DeWitte and Tom Coolidge Digitally transforming the gas and pipeline industry construction packet initially has been focused on digitally transforming the redlined paper maps into digital data. Most of the initial Tracking and Traceability solutions on the market have been almost exclusively focused on this part of the construction packet.  What about the rest of the construction packet? A pipe construction packet contains more than marked-up paper maps. It contains pressure test results, exposed pipe inspections, checklists, daily reports, and more.  What about digitally transforming those documents? In this blog article we will discuss how to configure and automate the data capture of the pressure test.  Pressure test documentation has historically been a critical piece of information that too often is relegated to the bottom of the document pile, filed at the back of the cabinet, boxed, warehoused, and eventually misplaced never to be found again. If you are responsible for managing or determining a pressure zone’s maximum allowable operating pressure (MAOP), then this frustrating reality most likely results in a palm slap to your forehead. A key benefit of digitally transforming the documentation of pressure tests is that this information is immediately tied to the tested assets. As a related record to the asset, it is a simple click to retrieve this information. No more searching through warehoused boxes of documents to find this critical information. What is a Pressure Test? Pressure testing is an industry standard practice. The purpose is to identify issues which would result in system failure and the release of gas prior to natural gas flowing through these new assets. Simply put, it is to insure the newly installed components are part of a safe and reliable pipe system.   The physical action of performing a pressure test is not complicated.  You insert an inert substance, such as air or water, into the newly installed portion of the pipe system. The new subsystem is then pressurized to the desired test pressure. Once pressurized, the subsystem is then monitored for a specified duration to verify the pipes, valves, and fittings are holding pressure and not leaking. The final step is to document the test to persist this important information for future analysis and engineering of the pipe system. Historical Issues Documenting a pressure test has two primary components.  The results of the test itself, and the identification of which pipe system components were tested. Historically this was all done on paper. It was time consuming. Field crews had to sketch the portion tested and identify the components which were included in the tested subsystem. Not only was this prone to error and data omission issues, it was redundant data documentation. Field crews were being asked to redraw the new pipe system for the pressure test after separately drawing those components for the redline as-built documentation. Early attempts to convert the paper documentation into digital documentation often focused on eliminating the redundant sketch creation. For example, one legacy solution asked the field user to manually click on each unique asset which participated in the pressure test.  This eliminated the redundant creation of the sketch, but at a cost of significant loss of productivity.  Imagine how long it would take you on your phone, tablet, or laptop to manually select every fitting, valve, and pipe segment for the pressure tested subsystem.  This could easily include over 100 unique items.  This legacy digital approach, in addition to taking more time to complete, was still prone to data omission issues.  Easier, Faster, and More Accurate This industry problem of how to efficiently and accurately document pressure tests is a great example where a spatially aware mobile software application can uniquely solve this problem.  There is a solution that provides the field user with an easier process for documenting pressure tests in a manner which is faster and more accurate. So, what exactly is the secret sauce that a geospatial mobile solution can provide?   The answer is polygons. Our Secret Sauce A geospatially aware mobile application, such as ArcGIS Field Maps, understands which of the newly installed pipe segments, valves, and fittings are contained within a polygon’s extent.  This geospatial understanding eliminates the need for a field user to manually select the pipe system components.   Using a polygon to represent the pressure test extent simplifies the documentation of the pressure test down to two steps. Step 1: Draw a polygon around the components of the pipe system which were tested. parrt 3_Pressure Test Area.png Step 2: Document the results of the test itself. parrt 3_Pressure Test form.png The two key configurations to ArcGIS Field Maps to enable this automation is the polygon layer and an attribute rule. The Pressure Test Polygon The pressure test polygon feature is the persisted record of the pressure test.  It is enabled with attachments to allow photos of the pressure test wheel to be stored as part of the pressure test record.  The specific information a utility wishes to capture about the pressure test, duration, pipe test medium, who performed the test, etc., is the schema of the polygon. This polygon pressure test record fully captures where, when, who, how, and what was tested. Documenting Pressure Test Results For most utilities, defining the schema is a onetime process of converting the questions on the paper pressure test form into a digital smart form. The schema can include picklists, default values, and date pickers to eliminate typos and speed-up the data entry process. Part 3 Pressure Test Picklist.png Persisting Link Between Asset and Test A key part of the automation of the pressure test is to tag all newly installed assets which were tested.  This is where an attribute rule is implemented. The attribute rule will compare the extent of the polygon against the pipe system components which were documented as the initial part of the digital field as-builting workflow. Here is the attribute rule arcade script to automate the assigning of the pressure test id for the staging line featureclass. //Rule Name:  StagingPressureTest_PressureTestID_StagingLine //Description: Push StagingPressureTest attributes to StagingLines //Type: Calculation //Subtype:  All //Field:  pipetestpressure //Editable:  checked (true) //Trigger:  Insert, Update //Error Code:  7 //Error Message:  Couldn't push StagingPressureTest attributes to StagingLines //Evaluate from application evaluation:  checked (true) // Get pressure test id from the polygon feature var retVal =  $feature['pipetestpressure']; var pressureTestId = $feature['PressureTestID']; var feature_set = FeatureSetByName($datastore, 'StagingLine', ['OBJECTID'], false); // Find line features that intersect the polygon var intersected_features = Intersects($feature, feature_set); //If need to exclude certain types of features tweak the next line and change the "for" loop to use: filtered_features //var filtered_features = Filter(intersected_Features, 'assetgroup not in (10, 12)') //add features to the update dictionary var updates = []; var i = 0; for (var feat in intersected_features) {     updates[i++] = {'objectid': feat.objectid,                     'attributes':  {                         'PRESSURETESTID': $feature.pressureTestID                     }                 } } //return the dictionary return {     'result': retVal,     'edit': [{         'className': 'StagingLine',         'updates': updates               }] } This attribute rule is automatically initiated as soon as the field user submits the pressure test polygon. Part 3 Pressure Test ID.png Geospatially Aware Mobile Applications This configuration of ArcGIS Field Maps shows how the needs of documenting pipe construction information, such as a pressure test can be uniquely addressed. Geospatially aware mobile applications provide the secret sauce for automating the documentation with the ease of use and productivity field users are looking for.   It is also important to note that automating the tagging of the pressure tested assets with the pressure test unique ID improves data quality. This mobile application writing of the pressure test ID onto each of the assets, means that this critical data will no longer be lost to the stack of boxes in the warehouse. If you are interested in deploying this configuration of ArcGIS Field Maps, we have posted all the scripts, data model templates, and instructions for this pressure test configuration and the entire digital field as-builting solution. You can download this configuration from the Esri Community site for free. Here is the link.This blog article is the third in a series of four blogs articles explaining how to deploy ArcGIS Field Maps for Digital Field As-builting.  If you missed our previous blog articles on digital field as-builting, here are the links to those articles. Part 1: Digital Field As-Builting with ArcGIS Part 2: Digital Field as-Builting with ArcGIS: No barcode No Problem Next blog article will continue leveraging the productivity enhancer geospatial awareness.  Blog #4 will divulge the secret sauce of configuration and automation for managing the construction project, and how to automatically link all construction project digital documentation together. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

The attached  zip file contains the template for ArcGIS for Digital As-Builting.  This is an advanced configuration of ArcGIS Field Maps for the purpose of enabling field crews to digitally capture new pipe construction documentation. The capabilities configured into ArcGIS Field Maps are the following: Decoding the ASTM F2897 barcode and auto-populating the derived attribute fields Feature templates for automating non-barcoded asset attribution such as steel pipes Automatically assigning Project information to each asset Automatically assigning Pressure Test ID to each pressure tested asset The purpose of these configured capabilities is to streamline the field data capture process, by automating the population of much of the UPDM 2020 data fields describing the asset and required for accommodation of the Tracking and Traceability guidelines. ... View more

Part 2 of 4   By Tom DeWitte and Tom Coolidge Our first blog of this series provided an overview of how ArcGIS Field Maps is the secret sauce for a cost-effective digital field as-builting solution. This is a solution that integrates with a high accuracy GPS antenna and a mobile computing device. If you missed it, you can access it here.. In this blog article, we will divulge how to configure and automate asset data capture.  This is a configuration of ArcGIS Field Maps which can be applied to the documentation of both plastic and steel assets across the gas pipe network. Pipe organizations need to maintain an ever-increasing amount of information about the assets they install into the pipe network.  No longer is it good enough to only know the material, size, and installation date. Today’s data management, integrity management, cathodic protection sizing, and hydraulic modeling systems need to know more. Historically the solution to capturing this additional information has been to simply ask field crews and office mappers to manually enter more information.  This is not exactly the ideal solution for an organization that needs to operate efficiently. Digitally capturing the geospatial location and characteristics of an asset with sub-foot spatial accuracy and high data quality attribution requires a software application that is capable of a diverse set of data capture methods which all work in a similar workflow. The gas industry is unique across the utility spectrum due to it having industry standards which only apply to a portion of the pipe network. When installing plastic pipe, there is the ASTM F2897 barcode standard. When working with steel pipe, there is no industry barcode format. In a single workday it is not unrealistic to expect that a field crew could be documenting installed plastic pipe with barcode, installed plastic pipe with unreadable barcodes, and steel pipe with no barcodes. Part 2 Different Data Capture situations.png The gas and pipeline construction industry therefore needs a single application with an easy to use interface which is capable of automated data capture for these different situations. Capturing Plastic ASTM F2897 Barcodes ArcGIS Field Maps is a mobile application which has seen several enhancements to specifically address the needs of the gas and pipeline industry. This includes the ability to use the mobile device’s camera to easily capture the ASTM F2897 barcode.  Part 2 ASTM F2897 barcode example.png Simply point the mobile devices built-in camera at the barcode. As soon as the Field Maps application can successfully read the barcode, it will automatically write the barcode to the designated field.  You do not even need to click the photo button! The second ArcGIS Field Maps enhancement was to be able to run arcade scripts in the pop-up configuration. This allows the barcode information to be immediately decoded and presented to the user. This real-time decoding of the ASTM barcode data even works when the mobile device running ArcGIS Field Maps is not connected to the network. This ArcGIS configuration for capturing newly installed plastic pipe and plastic components includes server-based scripts called attribute rules to automatically populate the plastic pipe/component data fields.  No manual entry of pipe or component characteristics is necessary. For more on the specifics of this part of the ArcGIS Field Maps configuration, please see the following previously published article; Tracking and Traceability 2019 – Part 2. Capturing Steel Asset Characteristics When installing steel pipe or steel components, a different approach is required. Currently there is no industry barcoding standard for steel. So, how can field users avoid manually entering every unique characteristic? The short answer is to give the field user a list of asset configurations to choose from. This configuration list represents the valid list of sizes, models, and manufacturers the gas organization uses as part of its standards for current pipe system construction. Legacy company configurations, which are no longer used, need not apply.  We only want a list of valid configurations for today’s company compliant pipes and components. Part2_Configuration_Picklist_for_Distribution.png The field user selects the desired configuration from the picklist. ArcGIS Field maps will then read the characteristics of that asset from the look-up table and automatically write the information to the newly installed asset’s data fields. There is no manual entry for the field user. It is a simple matter of selecting a configuration from a picklist. The software will do the rest. Implementing this capability not only addresses the issue of how to enable field users to quickly and accurately document the characteristics of newly installed steel pipe or a steel component, this same configuration can be used for situations where the plastic barcode is unreadable due to being smeared, scratched, or otherwise obscured. To deploy this part of the solution requires the following:                -Picklists (Subtype specific coded value domains)                -Lookup tables containing the characteristics of a specific configuration                -Scripts (Attribute rules) to automatically populate the asset’s data field with the configuration characteristics Need a List The picklist is defined with subtype specific coded value domains. This simplifies the field user experience by shortening the list of configurations to those which apply to a specific type of asset. Service Pipe, Distribution Pipe, Couplings, Elbows, and Controllable Valves are each separate coded value domains. Part2_Configuration_Subtype_Domains.png The domain is defined as a field type of short integer. The short integer value is the primary key to the configuration lookup table.  The coded domain description is the text which you want the field user to see in the picklist. Part2_Distribution_Configuration_CodedDomain.png Configuration Look-Up tables With the subtype specific coded value domain now defined, there needs to be a source which contains the characteristics (pipe diameter, material, manufacturer, wall thickness, etc) for each configuration. This lookup table is a standard geodatabase table. It must reside in the same enterprise geodatabase as the staging layers which will store the field captured assets. Part2_ConfigurationTable_example.png To simplify the integration with the staging featureclasses and the final production featureclasses, the schema of this table should match the data fields into which this information will be inserted. Automated Data Entry Attribute rules are the scripts which provide the automation logic to read the user specified configuration value. The selected configuration code value is then used to query the configuration table to retrieve the asset’s characteristic information. With the asset characteristic information retrieved, it can then be written to the appropriate data fields of the same record from which the user selected a configuration type. //Rule Name:  StagingPipelineLine_Configuration //Description: Set multiple fields based on Configuration value //Subtype:  All //Field:  Leave blank.  Setting multiple fields. //Editable:  unchecked (false) //Trigger:  Insert, Update //Error Code:  72 //Error Message:  Couldn't set values based on ConfigurationID //Evaluate from application evaluation:  checked (true)   //Get Configuration ID value var configurationId = $feature.configuration; if (configurationId == null) {     return; } // If update operation, only fire if configuration value changed if ($editcontext.editType == 'UPDATE'){     if ($originalFeature.configuration == $feature.configuration) {         return;     } } //Query Configuration_Lines table for configuration var cuTable = FeatureSetByName($datastore, 'Configuration_Lines', [‘assettype’,'nominaldiameter','manufacturer','pipespecification','pipegrade','wallthickness','outsidediameter','primarycoatingtype','seamtype’], false); //Use the first record returned from the query var cuAttribute = First(Filter(cuTable, 'configuration  = @configurationId')); if (cuAttribute == null) {     return; } else {     return {         'result': {             'attributes': {                 'assettype': cuAttribute.assettype,                 'nominaldiameter' : cuAttribute.nominaldiameter,                 'manufacturer' : cuAttribute.manufacturer,                 'pipespecification' : cuAttribute.pipespecification,                 'pipegrade' : cuAttribute.pipegrade,                 'wallthickness' : cuAttribute.wallthickness,                 'outsidediameter' : cuAttribute.outsidediameter,                 'primarycoatingtype' : cuAttribute.primarycoatingtype,                 'seamtype' : cuAttribute.seamtype             }         }     }; } When these three configurations are added to ArcGIS Field Maps, the field user experience is simplified. The user selects the configuration from the picklist, such as 4” Steel by J-M Manufacturing. Part2_Selected_configuration_FieldMaps.png The software runs the script, which retrieves the configuration information from the look-up table, and inserts it into the new record. Part2_Submitted_Configuration_FieldMaps.png The pipe record now has its characteristics automatically populated.  No barcode, no problem. Documenting New Construction Requires Adaptability This ability to use the advanced configuration capabilities of ArcGIS to address the issue of how to capture pipes/components with no barcodes demonstrates how important adaptability is to a digital field as-builting solution.  Just like gas and pipeline industry field crews are constantly adapting to unexpected issues during construction, a digital field as-builting solution needs to provide a wide range of data capture capabilities to overcome unexpected construction documentation issues. The adaptability of ArcGIS Field Maps extends beyond the previously described ability to scan plastic ASTM F2897 barcodes, and to select a pre-defined configuration from a picklist when no barcodes are available. It includes the ability to copy the information from a previously placed and documented asset. Lastly, there is always the ability to manually enter the asset characteristics.  Even in this last option, there are still picklists to help the field user to quickly and accurately enter this information. Part 2 Different Data Capture Methods.png This blog article is the second in a series of four blogs articles explaining how to deploy ArcGIS Field Maps for Digital Field As-builting.  Next blog article will divulge the secret sauce of configuration and automation for simplifying the documentation of pressure tests. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions.   ... View more