AnsweredAssumed Answered

How do I find which assets don't have an inspection yet?

Question asked by alina.taus on Dec 26, 2018

I have a web map setup for hydrant inspections. I would like to come up with a solution for identifying which hydrants have not been inspected yet. I can do this in ArcMap using relates but I want to give other non-GIS people the ability to answer this questions quickly. Ideally it would be a 'button' that they could click on in a web map/web app and they would get a list of assets that are still due for inspection. So far I've looked at the various widgets in Web App Builder and the Perform Analysis tools available in the Web Map, but nothing seems to work. The closest I've come to finding something was by using the "Join Features Tool" under Perform Analysis--> Summarize Data in the Web Map. I can join the most current inspections to the hydrants using my unique ID field, but only the matching records are kept in the resulting layer. If I could keep all the records, then I could use a filter to get all the unmatched records (ie., the hydrants without an inspection). The nice thing I'm reading about the "Join Feature" tool is that the resulting layer can be saved as a hosted feature layer which would then allow the data to stay up-to-date without having to re-run the analysis.  My first questions is, is there a way to set the Join Feature tool to keep all the records in the resulting layer? What other options do I have for accomplishing this?

 

Thank you!

Outcomes