Latest Contributions by TomDeWitte

By Tom DeWitte, Kevin Ruggiero, Mike Hirschheimer Part 1 of 5 Where am I and where are the buried pipes, conductors, and cables? These are the questions every utility field worker asks every hour of every day they are in the field doing their jobs. These questions are asked whether it is a blue-sky working day or storm clouds are overhead and Mother Nature has decided to rearrange everything on the ground. When Mother Nature decides to rearrange things, what was a safe, quiet, and orderly community can be turned into something unrecognizable. Cellular networks can be knocked offline. All landmarks of location can be moved or wiped out. During these disaster events, utility field workers are part of the first responders to arrive onsite. These folks need a reliable source of information that is available to them when external communication such as cellular networks are not. Each utility maintains a mapping system which enables them to keep track of where their water, gas, electric, cable, and communication assets are located. At most utilities, the mapping system is a geographic information system (GIS) by the name of ArcGIS. So, how do these utilities keep their field workers informed with this asset location information when they are unable to communicate back to the utility data center?                -The answer is offline map areas. Offline Map Areas Offline map areas provide the ability to maintain a copy of your mapping data on your mobile device (phone, tablet, laptop). This capability of ArcGIS allows Esri-based mobile applications such as ArcGIS Field Maps to access this locally stored data and present it to the utility field worker even when all communication networks are down. This capability of ArcGIS can be extended to foreign crews and the devices they bring with them. A simple email can not only thank them for assisting with the event, but also provide instructions to download the application, log into the local utility’ ArcGIS Portal, and download the required offline map area(s) for the region they have been assigned to assist.  All of this can be completed in a few minutes before they enter the disaster zone. Data to Take Offline The data to be taken offline can be grouped into four categories: Network, Landbase, Field Collected Data, and Basemap. Each of these categories is comprised of many data layers and tables. Network: This is the utility’ inventory of pipes, conductors, cables and all connecting assets and structural assets which comprise the network. For ArcGIS implementations at a utility this will increasingly be organized with the Utility Network Management capabilities. Landbase: This is the utility-maintained set of referential data such as utility boundaries, governmental boundaries, property boundaries, and street curb edges. Field Collected Data: This is the set of layers that utility field workers will add to and update with the information they collect. Examples of this type of data are damage assessments, meter outage status, and inspections.  Basemap: This data layer provides the transportation network (streets, rail, and pedestrian) as well as parks, buildings, and in some locations even sidewalks and trees. To get these datasets into the hands of the utility field worker requires four primary steps. These steps are preparing the data, publishing the data, creating offline map areas, and deploying it to the mobile device.   Preparing the Data When preparing the data, it is important to understand that these four categories do not have to reside in the same data repository. Each can reference a separate data repository.  For example, your network data will most likely be stored in an Enterprise Geodatabase running inside of a relational database such as Oracle or SQL Server. But your field collected data could be a set of hosted feature layers and tables, which are stored in the Portal’s PostgreSQL database. Your landbase could be a separate relational database, or the same database as your network.  Most data are not fully configured to support the offline map area workflow. The data will likely need to be modified. The purpose of this modification is to support the tracking of changes to the data. Changes are tracked to enable the ArcGIS system to know what records have changed since the last time a user’s mobile device was synchronized to send and receive updates.   Publishing the Data To get the data from the office data repositories to the hundreds or thousands of mobile devices used by a utility’s field workers requires the communication capabilities of web services. There are multiple types of web services available with ArcGIS. Not all web service types available in ArcGIS support the exporting of data to an offline map area. The four types of ArcGIS web services which do support exporting data to an offline map area are feature service, hosted feature service, vector tile service, and image tile service. Of these four types, only the feature service and hosted feature service support delta synchronization data exchange with the offline map areas. The other two service types, vector tile service and image tile service, only support exporting data to the offline map area. They do not support synchronization.   When publishing multiple data repositories, each repository must be published as a separate service. For our four categories of data, each will be published as a separate service. The publishing of the basemap is a special situation. These Esri-curated layers provide beautiful cartography and impressive spatial accuracy. But only a special subset of basemaps allow inclusion in offline map areas. These are a special subset of the basemaps published by ArcGIS Online. Of that subset, only the vector tile services meet the geographic extent and scale resolution needs of utilities. A listing of Esri provided vector basemaps which support usage with offline map areas is available with this link.  Creating Offline Map Areas With the data now published it is time to create a web map which defines how the data is to be presented to the utility field worker. Once the web map is defined with its layer scale constraints, symbology, searches, bookmarks, and smart form configurations, it is ready to create the offline map areas. Each offline map area is an extraction of the web map defined data, for a specified geographic extent. A utility’s region or operating area is a natural subdivision of the utility’s full territory to define the geographic extent of each offline map area. This extraction of the data is stored with Portal. Each service in the web map will create a separate SQLite database, and the basemap will be written to a vector tile package. When the offline map area is initially defined a scheduled task will regularly update the portal’s stored copy of the data with changes made to the core data repositories. NOTE: A single web map can support up to 16 offline map areas. If more offline map areas are required, simply copy the original web map then define additional offline map areas. Deploying to the Mobile Device With the offline map areas created, it is now time to deploy to the utility field workers. This is where supporting foreign crews with the utility information they need to understand where the utility infrastructure was before the disaster event becomes much simpler. A free download of the ArcGIS Field Maps application from the Google Play, Amazon Store, or Apple Store gets the mobile software onto their phone or tablet. An email to the foreign utility worker with a login and password to the ArcGIS Portal hosting the offline map areas will give the utility field worker secure access to the asset data they need. Once logged into the ArcGIS Field Maps application, the utility field workers and the foreign utility workers will see the groups and content the GIS/IT department has approved them to access. Within this group will be the web map and its listing of defined offline map areas. A simple tap on the download icon will initiate the download of the offline map areas the worker needs.   Once downloaded the offline map areas will display the total storage space required on the device, as well as the date when the offline map area was last synchronized.   Asset Location and Information Always Available With the offline map areas downloaded to the mobile device, your utility field workers and foreign utility workers will always have the information they need. Whether it is a blue-sky day or a disaster event your field workers will never be without the information they need to perform their tasks safely, accurately, and efficiently. About this Blog Series This initial blog article provides an overview of the value and key steps to deploying offline map areas.  In future blog articles we will dive deeper into the details of how offline map areas work, and the specific decisions an administrator will need to make during deployment. The second blog article will provide details on how to prepare the data for offline usage and synchronization. The third blog article will provide details and options for publishing the selected data repositories. The fourth blog article will provide details on the creation of offline map areas, how they are stored and managed in the portal environment. The fifth and final blog article will provide details on the deployment and management of offline map areas for a large mobile workforce. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions.       ... View more

  By Tom DeWitte and Tom Coolidge The hands-on work of constructing, maintaining, and operating utility networks happens away from the office in the field. That’s why so much GIS development effort is focused on assuring workers have reliable access to the GIS capabilities they need wherever they are in their utility’s service territory. Technology is key to ever-improving mobile GIS capabilities, and fortunately technology is a never tiring march into the future. Consistently this march has helped to make our lives better. Some of us have seen the idea of the TV remote evolve from our dad’s telling us “hey Tom change the TV channel to 4”. Then we got off the couch, walked to the TV and turned a dial to change the channel to 4. Over time this evolved to TV remote control devices with lots of buttons that most people did not fully understand how to fully use but allowed us to stay on the couch and change the channel to 4.  Today, the remote has few buttons, and we can talk to it and say, “I want to watch channel 4.” And the TV “magically” changes to channel 4. There is a pattern to how technology evolves to solve a problem. The initial solution often is a little complicated. Then successive evolutions of that solution become increasingly intuitive and easy to use. That pattern is evident at utilities across the world. Paper forms were initially replaced with digital forms that looked like the paper form. Those forms are now being replaced with smart forms that are more intuitive, easier to use and quicker to complete. Viewing a map in the field has similarly evolved from a static paper document to an interactive map in an application with lots of buttons, to today’s smart device mobile maps. Available on Smart Devices This new generation of mobile map viewers runs on Apple, Android, and Microsoft smart devices (phones, tablets, and laptops). These mobile map viewers, such as ArcGIS Field Maps, follow the design pattern best practices of the device operating system.  This means they have very few buttons and use the iconography of the operating system. If you already know how to use the email and text messaging applications on the device, you have completed the first portion of your training. Location Aware For well over 100 years, utility workers would look at a paper map and the first question they would ask is: where am I located on this map? Later, they would look at a mobile map on a first-generation mobile application which was likely running on a non-location aware device and ask the same question. None of the many buttons on that legacy application could help them.  Now, with location aware smart devices, the answer is shown automatically. A blue dot displays your location on the screen and the map is automatically centered to your location. You do not even have time to ask the question.  Ever been caught in the middle of a field or subdivision wondering which direction is the utility asset you are looking for? When using a location aware device with a mobile map application, the application will point you in the correct direction. Real-Time Collaboration Today’s mobile devices enable real-time collaboration with other mobile devices. This comes in handy when you are using text messaging to arrange dinner plans with the entire family while finishing up a day at work. In the utility space similar real-time collaboration scenarios exist, such as an outage event. In an outage event the status of the customer’s connection is changing in real time as other utility workers are repairing parts of the pipe or wire network. The benefits of this are obvious for worker safety and productivity.  What may not be as obvious is that most legacy mobile map applications only worked offline and were unable to communicate in real-time. ArcGIS Field Maps recently enhanced its capabilities so that when the device is connected to the network a simple tap on the screen will open the connected version of the map enabling real-time communication. Workers in the field now have the same map, whether offline or online. High Quality Basemaps In the paper map world, you got one basemap. It was a simple basemap that if you were lucky included curb lines, parcel lot lines and some street names. In the first generation of mobile maps this single basemap was duplicated. Workers in the field had the same content, but with the ability to pan and zoom across multiple map sheets.   In the smart device generation of mobile applications, these basemaps offer a seamless map for the entire planet. Instead of one basemap, you can now have over a dozen basemaps at your disposal when connected to the network. This includes imagery and cartographic maps with color schemes optimized for a variety of situations.  These basemaps now include building footprints, and in some locations even sidewalks and trees. Easy to Use If the marketing department were asked to come up with a slogan for a typical first-generation mobile map, it might be: We have a button for that. The header of the application was full of dozens of buttons. Today’s smart device mobile map viewers, such as ArcGIS Field Maps use context driven logic to simplify the application to a few buttons. In context driven logic applications a specific capability is not exposed until the user selects a feature which can use it. An example of this is the compass tool. It does not display until the user selects a feature such as a valve or regulator station to which that user wishes to be directed. Easy to Find First-generation mobile maps would provide a dropdown menu of predefined searches for the field user to select from. This worked if the field user never needed to ask a question that the administrator did not anticipate when initially setting up the mobile application. Today’s smart device mobile map viewers use single line searches, like the ones we use every day in our personal lives when searching and shopping on the internet. In these modern applications the field user only needs to enter the address, assetID, or station name.   Simply type in the name, address, or AssetID and the search engine returns all items which match. Select the desired search return item from the list and the map zooms to the location of the result. Aware of Surroundings The ability to leverage location also includes the ability to proactively warn utility field workers when they are approaching a known safety hazard. Common hazards that utilities track include dangerous animals and violent customers. When this capability is used on a smart device, ArcGIS Field Maps will connect to the devices notification system and issue notification alerts of the approaching hazard.   The March of Technology Continues This pattern of technology evolution continues to simplify and improve the safety and efficiency of utility field workers. Smart device mobile map viewers are the latest generation. But they will eventually be replaced by the next generation which will likely be 3D enabled and use augmented reality. And in time that generation of mobile map viewers will be replaced by an even more advanced and easy to use generation of mobile map viewers. The march of technology continues. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

Improving Field Worker Safety with Geofences By Tom Coolidge and Tom DeWitte If we were betting men, we suspect most everyone reading this blog would readily recall the centuries-old saying that begins, “An ounce of prevention…” That saying, of course, was uttered in 1736 by Benjamin Franklin. In full, the saying is “an ounce of prevention is worth a pound of cure.” The meaning is simple. It is usually far easier to stop something bad from happening in the first place than it is to repair the damage afterwards. ArcGIS today provides gas utilities and pipelines a powerful, yet easy to easy to use, capability to put that saying into practice in a way that can significantly benefit field workers. Sadly, there are too many real cases to emphasize the point. Take dog bites for example. Multiple news reports through the years talk about utility field workers being bitten by dogs as they go about their work. While most do not result in serious injury, some do. We recall one just last year when a utility field worker needed to be airlifted to a nearby hospital after being mauled. Looking at the news articles publicly available and doing some quick back of the envelope estimations, it is possible the number of times utility field workers are attacked by an animal of one kind, or another tops a thousand annually! But it’s just not just animals. There also are occasions when a utility field worker is assaulted by a human. These instances can be incredibly dangerous, too. Instances of verbal threats and physical assaults against utility field workers are not as uncommon as we would wish them to be. Its Dangerous Out There The fact is, maintaining our utility infrastructure can be a dangerous job. To reduce these dangers, utilities go to great effort to keep track of locations of previous dog attacks, property owner threats, assaults, and other known dangers. This information is typically stored in a company’s Customer Information System (CIS), or in a simple spreadsheet. Unfortunately, that information is not always relayed to the field workers before they arrive at a location with a history of danger.   How many of these incidents could be mitigated or even avoided if the utility field worker was consistently notified whenever they came within proximity of a known hazard? Danger Approaching Notifying a utility field worker that they are approaching a known danger is a geospatial problem. This makes it a problem that can be solved with a location aware mobile device such as a smartphone or tablet, and a mobile mapping application such as ArcGIS Field Maps.  ArcGIS Field Maps can use the new geofencing capability to notify the utility worker as they approach the known hazard. When the mobile device carried by the utility worker comes within the defined geofence distance a message is sent to the mobile device’s notification system. The mobile device’s notification system can vibrate, make noise, and display a message on the display screen to inform the user that they are approaching a known danger. Regardless of whether the utility field worker has been dispatched to a location with a known hazard, or the danger is at the neighboring address, the utility field worker will always be notified when they come in close proximity to the known hazard. Geofencing Known Hazards Geofencing is a recent enhancement to ArcGIS Field Maps. This new capability can be applied to any point, line, or polygon layer in the web map. The features within that layer are configured with a buffer distance. The buffer distance defines the geographical fence around each feature in the layer. This Field Maps capability is unique in that it is a completely client-side geofencing and notification system. That means it will work when the device is connected to the network, and it will also work when the device is not connected to the network. With the deployment of this capability utility workers can always be made aware of known hazards. Nearing a Known Hazard What happens when the utility field worker approaches a known hazard? For most utility field workers, they will feel their mobile device vibrating. Depending on their configuration of notifications, the vibration will be followed by a noise.  When they pull the mobile device out of their pocket or pouch, they will see the notification informing them of the known hazard they are approaching. These notifications can be tailored to different levels of threat and can be configured to include information from the known hazard record, such as customer name and address. Communicating Knowledge Maintaining our infrastructure is a job with many dangers. A lack of communication of known information should never be the root cause of an incident. In this day of everyone having a mobile device, isn’t it time to deploy an ounce of prevention to improve your organization’s safety record? PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

Staying Safe When it Really Matters By Tom Coolidge and Tom DeWitte On rare occasions natural gas from a leaking pipe accumulates inside a building. Gas-filled buildings are known as “Gas-Filled Occupancies” or GFOs for short. GFOs pose an obviously high level of risk due to the potential of an explosion if the accumulation ignites. The question needing answered by first responders and all in proximity to the building is just how far away from a GFO do they need to be to be safe? And the natural follow-on question is how can first responders best be aware of that answer during their emergency activity? In terms of existing industry practice, there is no one industry-standard answer to those questions. Each gas utility determines its own policy and practice based on its own unique circumstances and environment. Callers reporting an odor of gas sometimes are told to move outside at least 330 feet away, while others are told to move some other given distance based upon the gas utility’s own criteria or to an unspecified “safe location.” Gas utilities now can better answer those questions for themselves thanks to an initiative of the American Gas Association (AGA). The AGA’s Gas-Filled Occupancy Task Force that was initiated by the AGA Safety and Occupational Health Committee evaluated a decade of GFO explosions to examine the risk relationship between the GFO explosion location and the location of resulting fatalities or injuries. The criticality of GIS as a tool for first responders and all involved in GFO incidents jumped off the pages to me as I read the Task Force’s recent “Gas-Filled Occupancies – Emergency Response” technical paper. Reading the AGA paper also reminded me of one of my favorite IMGIS 2021 Conference presentations that focused on the use of GIS in GFO response situations. The research done by the Task Force found that there were 78 fatalities and approximately 350 reported injuries as a result of a GFO explosion between 2010 and 2020. Not surprisingly, in general, the further a person is away from a GFO explosion, the safer they are. It was concluded that utility worker and fire department fatalities typically occurred within 50 to 100 ft of structure. Most injuries related to a GFO explosion typically were within 100 to 200 ft of the structure and could be characterized as typically minor. If you haven’t already, I strongly encourage you to read the Task Force technical paper. It is really good work on a topic of obvious importance! The AGA Task Force work is specific to GFOs. Among previous guidance referenced by gas utilities is another that is more general. That reference is found in the U. S. Department of Transportation Emergency Response Guidebook. The guidebook specifies there should be a 100-meter (330 feet) evacuation distance from a natural gas leak in an open area. Given the Task Force’s findings, one approach we expect to see more of is the designation of different zones based on specified distances from a building. The zone closest to the GFO being the highest risk zone, the one furthest away the lowest. This is where a modern GIS can play a significant role. GIS can present all responders and those supporting them with a common operating picture indicating both levels of risk within a certain distance of a building and the location of pipe network components that can isolate the area to make the building – and them - safe. An early example of this approach was highlighted at Esri’s 2021 IMGIS Conference in a presentation titled “How close is too Close?” by Lindsay Dreckman of the Metropolitan Utilities District of Omaha, Nebraska (M.U.D.). Based on the work done by the Task Force, M.U.D. knew the distances from GFO incidents where most fatalities and injuries occurred. M.U.D.’s goal number one was to create a tool to generate three safety zones. Looking at the M.U.D. GFO emergency response policy, those zones include Exclusion, Hazardous, and Risk-Reduction. The Exclusion Zone is from the building’s exterior wall to 100 ft and where zero of our personnel are permitted to access. From 100-200ft is the Hazardous Zone, where work can occur but only after coordination with the public safety incident command. And from 200-330ft is the Risk-Reduction Zone, where we can establish a command post but with protection from a potential explosion. It is important to remember that this is an emergency event. Field crews and first responders need both an immediate visual aid and an automated warning to inform them of these safety zones. A mobile application with an interactive map, such as ArcGIS Field Maps is ideal for this need.  Here is an example highlighting that capability. When this mobile application is loaded onto the field technicians’ phone, or tablet, they will have a mobile device that informs them of these risks. This is possible because today’s mobile devices are location aware. The map can display their location with imagery of the area and the safety zones overlayed. Recent enhancements to ArcGIS Field Maps now enable client side notifications based on that mobile device location awareness.  This is called geofencing.  With geofencing the same field technician can have their mobile device vibrate, make sounds and have a banner notification appear on the mobile device when they approach the safety zones. This client side notification is unique because it works regardless of the phone connection to the network. All in all, it turns out that the AGA Task Force now gives gas utilities an extremely valuable reference to inform their decision-making on GFO response policies and practices. And, not surprisingly, location is key. That puts GIS at the heart of improving safety in a fast-evolving and understandably hectic time of emergency response. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more

Automation with Lookup Tables Part 3 0f 5 By Tom DeWitte and Tom Coolidge Our first blog of this series provided an overview of the steps a utility can take to improve the productivity of the utility field worker. If you missed it, you can access it here. The second blog of this series explained how barcodes can help to automate field data collection. If you missed it, you can access it here. In this blog article, we will dig into the second method in automating field data collection. The second method for making life easier for the utility field worker is to deploy a configuration of ArcGIS Field Maps that uses lookup tables to auto-populate what the organization already knows about the asset or data collection activity. As noted in the first blog article, this is the second of four methods to automate field data collection. Minimize manual data entry Auto-populate what is already known Leverage sensors on your mobile device Use geography Solving the Steel Issue Within pipe utility organizations, automating the documentation of steel pipe construction has been a challenge. Unlike plastic pipe, valves, and fittings, there is no industry adopted barcoding standard for steel.  The polyethylene pipe and component manufacturers have adopted the ASTM F2897 barcode standard. But steel has not done so. For many pipe utility organizations, documenting steel pipe construction is a very manual process. It requires the utility field worker to: Obtain the manufacturer paperwork or a copy of manufacturer paperwork to acquire the information about the steel components. Read through the many pages of documentation to find the desired information. Manually enter the retrieved information into the mobile application. Now leave the truck, walk to the construction trench, or direct bore and capture GNSS coordinates of steel components. Return to the truck to retrieve the information for the next unique steel component. Repeat process for each unique steel pipe, steel valve, and steel fitting. Automating the documentation of steel construction requires a different method to streamline data entry. Lookup tables can be that method. What are Lookup Tables Lookup tables are Esri geodatabase tables. The purpose of these tables is to store information that the organization already knows about the specifications of the pipe segment or pipe component prior to construction. In the design and cost estimation phase of a project, this information is often referred to as compatible units. To avoid complications with using these geodatabase tables to auto-populate an asset’s record, the lookup table should be a schema duplicate of the featureclass it is supporting. For example, there should be a separate asset catalog table for just the pipe data.  This geodatabase table would be a schema duplicate of the PipelineLine featureclass in the gas and pipeline industry data model, UPDM.                 Pipe Asset Catalog – PipelineLine schema                 Device Asset Catalog – PipelineDevice schema                 Fitting Asset Catalog – PipelineJunction schema   Auto-Populating what is known When addressing the steel construction documentation issue, these lookup tables contain the information the pipe utility organization knows about the steel pipe or component prior to construction. This is typically more information than is provided by the plastic barcodes. For steel this includes knowing the additional pipe characteristics for Barlow’s equation, such as Specified Minimum Yield Strength (SMYS), outside diameter and design factors. These tables can also contain other steel pipe or component characteristics, such as coating type, and pipe specification. These asset catalog tables are pre-populated with the known information. This pre-population occurs prior to the project entering the construction phase. At many gas and pipeline organizations, this list does not change dramatically between projects. Gas and pipeline organizations have codes and standards that they follow, and a select number of vendors from whom they purchase pipe and pipe components. Deploying the Automation Deploying a technology which is continually, and aggressively enhancing its capabilities, such as ArcGIS, means that sometimes there are different deployment patterns for ArcGIS Field Maps with a certain version of ArcGIS Enterprise versus ArcGIS Field Maps with ArcGIS Online. For ArcGIS Enterprise 10.9.1, the ability to use form calculations in Field Maps did not exist when Enterprise was released in December of 2021. For this environment you will need to use geodatabase attribute rules for the automation.  For this article we will focus on the use of ArcGIS Field Map form calculations, as that provides a consistent capability for an ArcGIS Online deployment and an ArcGIS Enterprise version 11.0 deployment. A key benefit of using ArcGIS Field Map form calculations is that they work in both a connected and disconnected network environment. Step 1: Create asset catalog tables. When duplicating the schema of your system of record layers, it is useful to use the Featureclass to XML Workspace tool available in ArcGIS Pro. This preserves the coded value domains assigned to the data fields. Step 2: Add the data field AssetCatalogID to both the asset catalog table and the asset layer The AssetCatalogID field should be a short integer field to eliminate the issue of trailing and leading spaces when querying the table for the record. Step 3: Populate the asset catalog tables with asset information. Step 4: For each asset layer to query the asset catalog tables, create a coded value domain with a listing of all asset catalog entries. The code of the coded value domain will be used to query the asset catalog record containing the utility known information about the asset. Asset Layer assetcatalogid = asset catalog table assetcatalogid This coded value domain needs to be assigned to the “assetcatalogid” field which was added to the asset layer in step 2. The description of this coded value domain will be what field users see when selecting an asset catalog item to describe the newly constructed asset When working with a subtype heavy asset layer such as PipelineJunction (enterprise) has a separate subtype for each type of fitting. A separate coded value domain should be used for each subtype (ie. type of fitting). This shortens the picklist presented to the field user. These different coded value domains can still query the same asset catalog table. Step 5: Assign the arcade script to query asset catalog table The last piece of this configuration of Field Maps is to use the ArcGIS Field Maps web application to assign a form expression to the asset layer field to be automated. In this example that will be the manufacturer field. Here is an example of the form calculation to assign to manufacturer: //Form Calculation:  Pipe_Barcode_Manufacturer //Description: Read the BARCODE, then decode and populate the MANUFACTURER value from the BARCODE value //Description: If an ASSETCATALOG value is entered, query the AssetCatalog Pipes table to retrieve MANUFACTURER value. //Field:  MANUFACTURER //Edit scenario 1: A barcode has been entered if ($feature.barcode != null)     return mid($feature.barcode,0,2) //Edit scenario 2: No barcode, no Asset Catalog entry   else if ($feature.assetcatalog == null)    return ($feature.manufacturer) //Edit scenario 3: No barcode, AssetCatalog value has been entered var assetcatalogId = $feature.assetcatalog; if (assetcatalogId == null) {     return; } //Query assetcatalog table to retrieve MANUFACTURER values var cuTable = FeatureSetByName($map, "AssetCatalog Pipes", ['manufacturer'], false);   //Filter the selected Assetcatalog table records based on assetcatalogid value //Use the first record returned from the query var cuAttribute = First(Filter(cuTable, 'assetcatalog  = @assetcatalogId')); if (cuAttribute == null) {     return; } else {     return cuAttribute.manufacturer     } With the asset catalog tables deployed and the form expression in place to query the table, this automation is ready to put in the hands of your field users. Going to the Field The user experience is very intuitive for the field user. Simply tap on the Asset Catalog data field.  This will open the coded value domain list.  The field user taps on the desired type of asset to select from the list. Once selected, the form expressions will immediately initiate. This will populate the edit form with the asset catalog table retrieved data. With the steel asset data retrieved and populated, the field user can focus on completing the rest of the edit form. Automating Data Entry The gas and pipeline industry has long struggled with how to automate the documentation of new steel pipe construction. Lookup tables in ArcGIS Field Maps is one approach to solving this inefficiency and additional cost. Using lookup tables is a very straight forward method for automating data entry by field users. This method of automation is applicable to many instances where field users are being asked to enter information that the organization already knows. About This Blog Series This blog article is the third in a series of five blog articles. Upcoming blogs will continue explaining in greater detail how to configure the Esri ArcGIS Field Maps mobile application to deploy these examples. 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 style file contains the latest version of the symbols designed for deployment with the Utility and Pipeline Data Model (UPDM). These symbols are synchronized to UPDM 2021 and it's asset group and asset type unique value combinations. ... View more

IT Needs Steel Toed Boots   By Tom DeWitte and Tom Coolidge What is it like to be a field worker at a utility? Given that over 70% of a utility’s organization is either directly supporting field workers or physically spends their day in the field, this is a question to which all utility staff need to know the answer. When engineers and information technology (IT) professionals put on their hard hats and strap on their steel toed boots to head to the field what will they find? An incompatible mix of old and new. The New In the field they will find field workers using new advanced Bluetooth-enabled mobile sensors such as GNSS receivers, electro-magnetic locating devices, and methane gas detectors. They also will find personal phones with built-in cameras, compasses, and location capabilities. The Old The output of those communication-enabled devices will be written down on paper. If paper is not available, it will be written on the back of the worker’s hand. The camera photos of inspections and assets will be emailed to their work email or someone in the office. The emailed data will then be manually associated to the inspection or asset it is documenting. Field Work is Digital Work Today’s mobile sensors, when combined with a nearby mobile device and the correct mobile GIS application on the mobile device, create a wonderful opportunity to transform tasks and workflows performed in the field. This transformation can overcome, if not eliminate, the inefficiency inherent in today’s incompatible workflows. The communication capable mobile sensors have been or will soon be deployed at most utilities through simple replacement of hardware.  The deployment of mobile devices and mobile GIS applications to consume the mobile sensor data to complete the field work transformation to digital work is very much a work in progress. This is where many utility IT departments are struggling. This is where steel toed boots are required. Work Happens Out of the Truck Getting IT into their steel toed boots and out into the field is a critical step. Spending time in the field is needed to secure the foundational understanding that work happens out of the truck. Field work is not a laptop on the hood of a pickup! Field work is a locator walking a city block to mark the next phase of a telecommunication direct bore project. Digital field work is recognizing that besides spray painting the ground to locate the buried pipe, photos and videos need to be taken, with GPS coordinates where possible, to accurately document where the locate marks were placed. Field work is using a methane gas detection sensor to crisscross someone’s front yard to locate a gas leak.  Digital field work is having each individual barhole methane reading automatically combined with a GNSS receiver defined location and transmitted directly to the GIS system to auto-populate the gas leak report. Field work is wandering around an area trying to remember where a gas valve is located so you can use a paper form to document a valve inspection to assess its condition. Digital field work is using your mobile device’s built-in compass with your mobile GIS application to direct you to the valve, then complete a digital form and use the mobile device’s camera to take a photo of the valve to document its current condition. The mobile GIS application completes this task by having that photo automatically associated to the asset record and transmitted to the GIS system. None of these field work tasks occur in or near the truck. All these tasks involve the field worker in motion to complete the task.           It’s Stuck in the Truck In the late 1990s and early 2000s, ruggedized laptops started to show up in utility vehicles.  For safety purposes these laptops were and still are predominantly mounted into the truck dashboard.  This is great for field tasks such as completing timesheets, receiving, and viewing work orders, driving navigation assistance, and map viewing. Truck-mounted laptops struggle to add value to the digital work tasks which occur outside of the truck. This is especially true for workflows which use mobile sensors. Bluetooth communication is limited to a range of about 30 feet in the best of conditions. Imagine how a customer would feel if a utility worker drove their truck onto their yard so the methane gas mobile sensor can be in range to transmit its readings to the truck mounted laptop. Mobile Devices for Mobile Tasks The hard truth is that to achieve the promised dream of improved productivity and data quality that is supposed to come with a digital transformation, you need a mobile device such as a tablet or phone for mobile tasks. Digging deeper into what it takes to achieve the digital transformation dream is a mobile GIS application which can easily integrate with the mobile sensors. The digital transformation premise is based on the idea that information is captured once. No repeats. Writing field collected data down on paper or the back of your hand so it can be transposed into a device in the truck will not achieve the promised productivity. Mobile tasks require nearby mobile devices running mobile GIS applications. Mobile Apps for Capturing Mobile Sensor Data It is the mobile GIS application running natively on the mobile tablet or phone which enables the “capture once” mission of digital transformation. It is the mobile GIS application which combines the GNSS receiver Bluetooth data feed with the mobile device’s compass that points the way for the field worker to find the buried valve. It is the mobile GIS application which receives the locating estimated depth, coordinate location, photos, and video, then transmits them directly to the GIS. It is the mobile GIS application which combines methane gas detection measurements with GNSS receiver location and completes the digital leak report form, then transmits it directly to the GIS system. It is the mobile GIS application running on the mobile device which allows the field worker to capture the location of the newly installed pipe segment using a sub-foot GNSS receiver Bluetooth data feed while walking along the trench or direct bore path. Since humans currently only have two arms and two hands, none of these examples is going to be accomplished with a ruggedized laptop. If one hand is supporting the laptop and the other hand is holding the mobile sensor, whose hand is doing the typing? There is a reason why mobile tablets and mobile phones with touch screens are the platform of choice for mobile GIS applications. IT to the Field When engineers and IT professionals’ dust off their hard hats and pull their steel toed boots out of the back of the closet to head to the field is when the digital transformation dream will accelerate for field workers. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions ... View more

Scanning and Decoding Barcodes Part 2 of 5 By Tom DeWitte and Tom Coolidge Our first blog of this series provided an overview of the steps a utility can take to improve the productivity of the utility field worker. If you missed it, you can access it here. In this blog article, we will dig into the first step in automating field data collection. The first step in making life easier for the utility field worker is to deploy a configuration of ArcGIS Field Maps that minimizes the amount of manual data entry they must perform. As noted in the previous blog article, this is the first of four steps to automating field data collection. Minimize manual data entry Auto-populate what is already known Leverage sensors on your mobile device Use geography The use of barcodes to automate data entry is one method to minimize manual data entry. Barcodes Barcodes are currently used for many purposes across utility industries. Most utility field workers will have a barcode on their employee badge. This barcode encodes the unique identification of the employee. Another common use is to barcode machinery. This barcode encodes the manufacturer information about the device. Then there is the use of barcoding assets. In the natural gas industry, barcodes are applied to the plastic pipe, plastic device, or plastic fitting by the manufacturer. In industries that do not have a barcode industry standard, there are utility companies which are placing their own barcodes onto assets as they enter the warehouse. Barcodes are on many assets today, and soon seemingly will be everywhere. Simply having a barcode does not directly equate to productivity gains for the utility field worker. There needs to be a companion capability. This companion capability includes electronically capturing the barcode, and software to decode the barcode, then auto-populate the information directly to the asset record. Without this companion capability the utility field worker will have to manually read the 16-character case sensitive text string and without error manually enter it into the asset record. Manually entering barcodes is slow, prone to error, and a frustrating experience for field workers. Scanning the Barcode Two predominant methods for electronically capturing a barcode are optical and infrared scanning. Optical scanners are the camera built into your mobile device. Infrared scanners are external devices which Bluetooth connect to your mobile device. ArcGIS Field Maps supports both methods. If interested in using a handheld infrared barcode scanner, the Bluetooth device needs to support the keyboard wedge method for integration with ArcGIS Field Maps. Regardless of barcode scanning method, when ArcGIS Field Maps electronically captures a barcode the designated text field in your form will be automatically populated. There is no manual data entry. With the barcode now electronically captured and stored in the BARCODE field, software needs to be employed to decode the barcode value and auto-populate the appropriate data fields. Decoding the Barcode In many examples this decoding of the barcode can be accomplished with a small set of Arcade scripts. Each attribute which will be auto populated from the information encoded in the barcode will have an Arcade script. Deploying the Automation The method used to embed the software capability to decode the barcode in ArcGIS Field Maps is done through configuration. The Field Maps Web Application provides the administration environment to perform this configuration. The web application is used to define the Arcade script and the ability to apply this script to the table field. Each field to receive information from the decoded barcode values will have its own Arcade script. Field User Experience With these scripts now configured into the editing behavior of the layer, the automation is in place for the utility field worker to utilize. For the utility field worker, the field data collection is very simple. Open ArcGIS Field Maps and select the web map designated for the specific data collection task. Now you are ready to collect. The collection process with barcodes is to select the item to be collected and capture the barcode. The ArcGIS Field Maps application will automatically run the Arcade scripts immediately after the BARCODE field is populated. This allows the utility field worker to immediately be able to review the decoded content and verify it matches what was installed. As the above screenshot shows, a total of 8 data fields were automatically populated from information embedded in the BARCODE field. Including the BARCODE field, a single barcode scan results in nine data fields being populated with no user typing. Automating Data Entry The use of barcodes is only one example of how ArcGIS Field Maps can be used to free your utility field workers from manual data entry. Other opportunities to improve the productivity of utility field workers include:                 -auto-population of the date/time when the collection was performed                 -auto-population of who performed the data collection                 -auto-calculation and population of a pipe’s volume and surface area                 -auto-population of the projectID based on the asset’s location intersecting a project polygon                 -auto-population of the nearest address, based on the asset’s location These are just a few examples of how the automation capabilities in ArcGIS Field Maps can be used to improve the productivity of the utility field worker. About This Blog Series This blog article is the second in a series of five blog articles. Upcoming blogs will continue explaining in greater detail how to configure the Esri ArcGIS Field Maps mobile application to deploy these examples. PLEASE NOTE: The postings on this site are our own and don’t necessarily represent Esri’s position, strategies, or opinions. ... View more