Create a spatial filter in Map Viewer? Or symbolize based on common attribute in separate table?

[hoddinottc]

Is there any way to apply a spatial filter in AGOL Map Viewer?

I need to be able to display only the points that are within a polygon boundary.
But I also need to have those points joined to separate (not related) table (the attributes in the table will be used to symbolize the layer and in pop-ups). The table needs to be separate so another person can update the table but NOT have access to the main feature layer.
And I need to the points to stay "live", or auto-update regularly.

I know I can filter by a polygon area when creating a view layer. And I can create a joined view layer. But I need to do both!

Is there any way to do this in Arcade? Or some other way I haven't thought of yet?

It seems like this capability should exist...

Or is there a way to utililize Python and Notebooks to help accomplish this? (I have no experience with Notebooks and a little with Python but I'd like to learn!)

[JonathanMcD]

Going to try and pick this apart. I'll probably get most of it wrong too 🙂

I'm assuming the reason you want to show points within a boundary is the editor only has responsibility for that area, and you may have multiple editors across multiple areas?

I'm also assuming the point layer is of fixed points that will not have any geometry or editable changes, and that the table (assuming you are actually meaning a table) holds the editable data for those fixed points?

Ok symbology, and this irks me no end and I really wish ESRI would implement this into Arcade, you can't access a table (related or not) to symbolise a layer without creating a joined view. Of course, in a pop-up, you can create "symbolised" indicators for related records or matching from a table, but not for symbology

So, the editor, I'm not sure why you don't just create a custom map for their needs where they see their area of interest, including the points and, with a bit of setup, enable and disable the fields they have access to edit via a form in the map. It would mean you're not having to manage an unrelated non-spatial table for a set of spatial points. If it's data quality you're worried about, just ensure use of coded domains where possible.

I've a few people with this sort of setup, they only have 2 fields to edit. 

Also, when you mention "edit the table" is this adding records to the table, or just editing existing attribute values? If it's the former, you may wish to create that related table.