Joining table to layer by parcel ID in ArcGIS Online without using Join Features (1 million records)

Question

Hello,

I would like to ask if there is any alternative in ArcGIS Online to perform a join without using the Join Features tool, since it consumes credits and we have one million records.

Our goal is to join a field containing pixel values, using agricultural parcel identifiers, to a Living Atlas parcels layer that also includes these identifiers. We want to do this in ArcGIS Online, not in ArcGIS Pro, and without creating a join.

We understand that ArcGIS Pro has greater analytical capabilities and does not consume credits, but we are specifically looking for alternatives to achieve this directly in ArcGIS Online.

Thank you in advance for any guidance.

Have a great day,

Pilar

Pili · Answer

Interesting... do u have an example (ivented) how it would be?

JonathanMcD · Answer

Depending on what you or a user wants to see, you could use Arcade to "join" the features and display results in the pop-up.

joyoung_kerrvilletx · Answer

It is not possible to create a join in ArcGIS Online through the UI without using the Join Features tool. The current options are to use ArcGIS Pro to publish the layers with a relationship class defined or to use the REST API to create a relationship between two layers that are in the same feature service.

I posted an ArcGIS Idea about this topic a few years ago for ArcGIS Enterprise and it is "Under Consideration". https://community.esri.com/t5/arcgis-enterprise-ideas/ability-to-create-and-manage-relationship-classes/idi-p/1008648