Our users (not GIS professionals, but ordinary users) constantly need to link spreadsheets/csv to standard geographies of the organization - in our case Building footprints, POI, Parcels, etc in order to map/visualize the data. Commonly, it's to color-code building footprints, or categorize POIs.
I'd like the ability in a hosted feature layer settings tab to mark it as a standard geography layer and establish the primary key field.
The expectation is that when a user adds their spreadsheet/csv to AGOL, the upload process will prompt present an option to use an organization standard geography layer (building footprints, parcel, etc) to map it.
When the user selects a standard geography layer, it will then prompt for the primary key to use. The upload process then performs the analysis and returns number of matches and whether to proceed with an inner or outer join. The result is a new layer owned by that user with the join (1:1) or related table (one-to-many) of the data they uploaded.
User's could then directly add this new layer to the Map Viewer and begin to style the layer.
Joins are such a common need for analysis that there should be an expedited method to help users achieve this functionality. This is a quality of life enhancement request.
