Select to view content in your preferred language

Spatial Join — "One-to-one (tiebreaker field)" join operation

961
2
08-26-2024 10:49 AM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

ArcGIS Pro 2.9.5; File Geodatabase

I want to do a spatial join between a point FC and a polygon FC. I want the relationship to be one-to-one: the number of points in the input should be the same as the number of points in the output.

When a point intersects multiple polygons, I want to break the tie using a RANK field in the polygon FC. The highest-ranked polygon would be used in the spatial join. A rank of 1 is high.

Details: For each point, get value from intersecting polygon — How to rank/prioritize overlapping polygons to...

It's my understanding there aren’t any OOTB geoprocessing tools that can do that. Could this functionality be added, such as adding a "Join one to one (tiebreaker field)" option to the Join Operation parameter in the Spatial Join tool? And also add a Rank Field parameter and an Order (ascending/descending) parameter?

Bud_0-1724694304081.png

It'd be similar to the One-to-first join — Control what related record gets used idea, except this join is spatial, not tabular.

2 Comments
JonathanNeal

@Bud At the moment, this requires two tools:
1. Sort (Data Management)—ArcGIS Pro | Documentation using the Join Features input using the desired field.

2. Then Run Spatial Join.  default will be to use ObjectId's which the output from Sort will have ordered by the field.

 

Bud
by

I submitted this documentation feedback for the Spatial Join tool.

When the Join Operation parameter is set to "Join one to one", yet the spatial relationship of the underlying data is one-to-many (i.e. one point intersects multiple overlapping polygons), then the tool will use the related polygon on the many side that has the lowest ObjectID.

Please explain that behaviour in the docs so that other people know, and so they can use it to their advantage.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/spatial-join.htm

Related: Consistent one-to-one/one-to-first wording in GP tools