topic Attribute and Spatial Joins - Which One? in ArcGIS Pro Questions

Attribute and Spatial Joins - Which One?

GRmapper — Tue, 22 Feb 2022 19:07:30 GMT

Hello

Within ARCGIS Pro I have a layer (Locations) and a standalone table (Crime Data).

The Locations feature has an x,y coordinate while the standalone table does not. The rows in the Crime_Data table share the exact Town_Name and location as in the Locations layer but without an x,y coordinate pair.

Is there a way to add/append the two rows from the Crime_Data table up into the Locations layer so that layer would grow to include all three rows, x,y coordinates, location name and crime type?

That way if I wanted to see all locations with Thefts I'd get back Clearfield and if I wanted to see all locations with Property crime I'd get back Clearfield. I have really simplified my data/table example but I would have many locations in reality.

Thanks,

Re: Attribute and Spatial Joins - Which One?

DanPatterson — Tue, 22 Feb 2022 19:45:15 GMT

attribute join... a many to one, however, I would keep the attributes separate and join when needed since having a whole load of records associated with a point isn't going to useful on a daily basis

Re: Attribute and Spatial Joins - Which One?

GRmapper — Tue, 22 Feb 2022 20:35:39 GMT

Thanks Dan,
I just looked into your approach. You’re correct but does that hold true in that I’m trying to join many Crime-Data location rows WITHOUT point geometry to one Location WITH a point geometry? I only see a one to many and not many to one option.
Does that seem right?
Thanks again,
GR

Re: Attribute and Spatial Joins - Which One?

DanPatterson — Tue, 22 Feb 2022 22:13:59 GMT

one point to many records (relate) Add Relate (Data Management)—ArcGIS Pro | Documentation

The order of inputs