Inspection Workflows Part 1: Building & Publishing Related Tables

[@hidekonagatanifeitoza3626]

this is the best video I've seen. Very clear instructions and easy to understand. Thank you Eric for great help for so many ESRI users!

[@fuddog]

This is exactly what I needed. Could Eric just be on "amazing informative videos" duty from now on? Thank you for this information!

[@bobsage]

I 100% agree!

[@SameSchmidtDiffDay]

Hi Eric - your videos are FANTASIC! can you please share the settings to make it so they can ONLY do inspections and not add more hydrants?

[@markyoung5828]

Straight to the point, clear instructions - great video - thank you

[@mhmurdock83]

Thanks Eric this series helped a ton! keep up the good work

[@janeahi3990]

Thank you. Can this be done the same way with a live layer? For example. We have a hydrant feature layer (hydrant master) that is live and can be seen by all personnel. I want to be able to have a feature layer (hydrant inspection) that sits behind the live feature layer (hydrant master) that I can collect information on. However I also want this feature layer (hydrant inspection) to update when the hydrant master layer is updated.

[@michellecaron7541]

Hello Eric, I just discovered these videos... I will be able to climb the level of my organization! If I have a table that is already linked to my layer, what should I do?

[@thatch-0]

When I go to add GlobalID from Pro into my table fields, the data type Global ID does not show as an option like it did in this example. Is there another way to add a Global ID field?

[@randyharris7354]

Great video!! Thanks!!!!!!!

[@krystal4750]

How would i go about adding existing data?

[@HaKaNOGUZ]

Thank you for great videos Eric but you have not uploaded any videos since 2021. I'd love to see you posting new videos regarding ArcGIS Online and ArcGIS Pro.

[@suzy17ish]

Great Work for coming up with this series👌👌

[@laytongardner3191]

Can I create multiple tables and link all of them? Instead of hydrants, I'm going to have business points to do inspections. The type of business will determine the form needed to use, so I need to input multiple tables/inspection data.

[@joshb8916]

Should the GUID field auto-populate with the parents layers GlobalID field?

[@ericwagner5794]

Hi Josh B! The GUID field will initially be blank when you first build the related table. Even after you build the relationship class and publish it to ArcGIS Online, it will still be blank. As you complete inspections in the field, a new row will be added to the related table for each inspection submitted. When the new row is created at the time of inspection, the GlobalID is pulled from the parent feature (hydrants in my video) and automatically added to the related table's GUID field. This links the records from the related table to the features in the parent layer. If the GUID field values are blank, then you most likely missed a step in ArcGIS Pro to build the relationship class.

[@TyroilSmoochieWallace]

@@ericwagner5794 Hi Eric. Might be a silly question...but in your example...if the GUID field in the table is being populated from the GlobalID from the parent feature class, why does the related table also need to have a GlobalID field? I'm tracking on everything else except that part. Thanks!

[@ericwagner5794]

Hey Steve! Not silly at all! Great question! The inspection table’s GlobalID field is technically not necessary for having a related table in web maps, Field Maps or ArcGIS Pro. As you suggested, you could just have the GlobalID in the hydrant layer and the GUID in the inspection table… but one of my later videos shows how to (Optionally) incorporate Survey123 into this inspection workflow. And Survey123 requires that all datasets/tables used have a GlobalID field. Adding the GlibalID now in ArcGIS Pro is much easier to do at the beginning rather than than later on. Just planning ahead. Hope that helps!

[@dwaynemorgan5378]

I am experiencing a difficulty with the GUID field. It not appearing as an option for Origin Foreign Key.

[@kriswebber676]

Me too has anyone explained how to fix this?

[@ericwagner5794]

Hi Dwayne! Have you set the following: Origin Table: Hydrants Destination Table: HydrantInspections Origin Primary Key: GlobalID Those are the settings you should have in place. If the Origin Primary key isn't set to GlobalID, that can create issues. I just tested in ArcGIS Pro 2.9 and got the expected results.

[@dwaynemorgan5378]

@@ericwagner5794 I found out what was the problem. I had to add a new global key because the previous one was missing some data from some of the fields. Thank you for following up with your response, most appreciated.

[@lynnnguyen6167]

This is a great video with a brand new related table! How can i published related tables with existing records which have its own primary key to ArcGIS Server?

[@joshk2301]

Hi Eric, I think I know the answer to this but can the relationships be created in ArcGIS Online or does it need to be completed in ArcGIS Pro?

[@ericwagner5794]

Hi Josh, the short answer is yes, you need ArcGIS Pro to build a relationship class. Relationship classes cannot be built from scratch in ArcGIS Online. This also requires an ArcGIS Pro Standard License. However, there are other options for those out there with only a Basic License or those who only have ArcGIS Online User Types… keep reading! For users that only have an ArcGIS Pro Basic License or users that want to build new workflows quickly, ArcGIS Online does have templates that can be deployed by anyone with a Creator or GIS Professional User Type in ArcGIS Online.* Do the following: (1) In ArcGIS Online, go to the "Contents" tab. (2) Click "New item". (3) Click "Feature layer". (4) Then choose your template of interest. Most templates (but not all) that have "inspection" in their name, will come with a related table ready to go. Some examples include: Valve Exercising, Backflow Inspection, Inlet Inspection, Manhole Inspection, Water Quality Inspection, etc. Once the feature layer template is deployed, you can add/remove fields as needed, add the layer/table to maps, share it, etc. and treat it like any other layer in your organization. I actually had a customer that wanted to do levee inspections with a related table, but he only had a Basic License. So, he deployed the Backflow Inspection template, removed all of the attribute fields that it came with it and then added the attributes he wanted. It was a great little work around to build a relationship class with nothing but ArcGIS Online. It's a long answer, but maybe this helps you or others who may stumble upon this video and its comments! *If you have an ArcGIS Pro Basic License, then it came with a Creator User Type for ArcGIS Online. So every organization has access to these templates!

[@joshk2301]

@@ericwagner5794 Thank you so much for your comprehensive response. That might be a great option in building a POC for me (which might lead to a Pro licence).

[@joshk2301]

Hi@@ericwagner5794, in terms of work management and field staff receiving a list of tasks (I am thinking of pushing work order tasks to ArcGIS from an EAM), is there a way for this to be achieved within Field Maps? I read somewhere about some further integration between Work Force and Field Maps but noticed that the latest Android release for me is from 2017. Are you able to point me towards any resources that might help me develop a proof of concept? Really appreciate your help. Josh

[@ericwagner5794]

@@joshk2301 Hi Josh, the short answer is yes! ArcGIS does integrate with many EAMs, CMMSs, SCADA systems, etc. This is a great way to geographically visualize your assets and work history on a map. I have seen this done with Field Maps and Workforce (FYI: Workforce will be integrated with Field Maps in the coming months, this is currently in beta… no ETA yet).

[@ericwagner5794]

What it really comes down to is what business systems you have. Some EAMs integrate with ArcGIS Online, some integrate with ArcGIS Enterprise.* Some integrate with both, and some EAMs don’t directly integrate at all. A direct integration is preferred, this allows information to be shared back and forth between your EAM and GIS in real-time. However, if you have a business system that doesn't directly integrate with ArcGIS, you still have options. The most common means of sharing data between the two systems is an Extract, Transform, and Load (ETL) that pushes data back and forth between your GIS and EAM daily to keep the two system in sync. This usually requires some coding. In short, integration is possible, but it depends on how you implement GIS (ArcGIS Online versus ArcGIS Enterprise) and which EAM your using. I think those governing bodies, utilities, and other organizations (big and small) that tie their business systems to GIS greatly increase the value of the technology they've deployed. My honest recommendation: reach out to your Esri account team. You should have an account manager and solution engineer that you can lean on. Although I'm no longer a Solution Engineer, my job was to listen to a customer's needs and offer the best strategy for utilities to move forward. They can offer you advice about how to tie business systems together. Also, they can provide demos to you, your managers, and staff to show what's possible. Finally, they also have knowledge of our partner network; many Esri partners specialize in helping to integrate business systems. At the risk of sounding sales-y, working with your account team is free! We like to see our customers be successful! If you need help finding your account team feel free to connect/message me on Linkedin. I can help make a connection. Also, KZbin won't let me share links to case studies and resources. Again, feel free to connect and I can send some resources. *ArcGIS Online is a cloud-based system, hosted by Esri, for the sharing of maps, apps, and data through the web. All of my KZbin videos are created using ArcGIS Online. ArcGIS Enterprise is similar to ArcGIS Online, but it runs on your organization's own servers (or cloud instances like Azure or AWS). ArcGIS Enterprise offers many benefits not available in ArcGIS Online. Most notable to this thread, ArcGIS Enterprise uses an RDBMS (SQL, Postgres, Oracle, etc.) to store your GIS data. If your other business systems (EAM, billing, CMMS, etc.) are using an RDBMS, then the systems can be tied together to visualize your business data with GIS.

[@elzerogis193]

Thank you pro

[@savagecabbage895]

Ngā mihi kia koe !