topic Re: Spatial Join cardinality relationships in ArcGIS Pro Questions

Spatial Join cardinality relationships

Craig_Eissler_Iceman — Mon, 17 Jul 2023 15:45:49 GMT

There are two Spatial Join tools: Data Management version and Analysis version.

1. Regardless of the above tool used, is a One-to-Many, Many-to-One, or Many-to-Many situation with my data all considered a "One-to-Many" cardinality relationship with a Spatial Join? ...seems that way to me

2. That said, I know I can specify this in Analysis tool version. But, is there a reason why I cannot in the Data Management tool version?

Thanks!

Re: Spatial Join cardinality relationships

DanPatterson — Mon, 17 Jul 2023 18:32:34 GMT

Add Spatial Join (Data Management)—ArcGIS Pro | Documentation

it only says...

join_operation
(Optional)
This parameter is not supported. All joins will be performed as a one-to-one join. If you are using positional arguments in Python, use a None type, an empty string ("" or ''), or the JOIN_ONE_TO_ONE keyword.

To achieve a one-to-many join when the output is created in an output feature class, use the Spatial Join tool.

Re: Spatial Join cardinality relationships

Craig_Eissler_Iceman — Mon, 17 Jul 2023 19:30:33 GMT

OK Dan, thanks for answering Question #2.

What about Question #1; I know there is a difference in an Attribute Join, but is there really a difference in a Spatial Join? ...I ask because some data I'm using looks more like a M:1 or M:M, not a 1:M?

Re: Spatial Join cardinality relationships

DanPatterson — Mon, 17 Jul 2023 19:36:47 GMT

as for M:1 think of points in polygon

1:M polygon contains points

M:M overlapping polygons with points therein

Re: Spatial Join cardinality relationships

Craig_Eissler_Iceman — Mon, 17 Jul 2023 19:44:58 GMT

OK thanks for that tip.

So the tool just classifies all three as 1:M for some reason?