Select to view content in your preferred language

Spatial Join cardinality relationships

866
4
07-17-2023 08:45 AM
Craig_Eissler_Iceman
Frequent Contributor

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!

 

0 Kudos
4 Replies
DanPatterson
MVP Esteemed Contributor

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.


... sort of retired...
0 Kudos
Craig_Eissler_Iceman
Frequent Contributor

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?

0 Kudos
DanPatterson
MVP Esteemed Contributor

as for M:1  think of points in polygon

          1:M  polygon contains points

          M:M  overlapping polygons with points therein


... sort of retired...
0 Kudos
Craig_Eissler_Iceman
Frequent Contributor

OK thanks for that tip.

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

0 Kudos