ArcGIS Online Relate (one to many)

Question

I am trying to create a relate in ArcGIS Online. I have a layer of streets (600) and one of accidents (40'000). It should be one (street) to many (accidents). The streets have a unique ID and some of the accidents also have this ID on which the relate should be based. Any tips?

MiguelParedes · Answer

Greetings @DeepSeaMapping

In addition to my earlier post, yesterday, whilst doing some testing I found that the capability to join features is also available in the Map Viewer.  Here is an excellent bit of documentation explaining how this works: Join Features (Map Viewer).

I hope the above is of further help.

RodellZorilla · Answer

Hello, I believe you can now create a view of a joined feature layers, see the "Create a joined hosted feature layer view" section here: https://doc.arcgis.com/en/arcgis-online/manage-data/create-hosted-views.htm

Go to the overview page of your "Streets" layer --> Click "Create View Layer" --> Choose "Joined view layer" and set-up your parameters per the instructions. Since you have to join both layers using a field with unique fields, you may need to clean-up you "Accidents" layer by spatial join or a similar process.

MiguelParedes · Answer

Greetings @DeepSeaMapping

You should be able to do it using Map Viewer Classic > Perform Analysis > Sumarize Data > Join Features. Please, have a look at the following; Does Map Viewer Classic in ArcGIS Online support joins and relates?

Hope the above is of help.