Question

Silly question, but how do you join one to many in a spatial format?

  • 14 June 2021
  • 1 reply
  • 8 views
M

I have a list of permits joined to address points. About 100k points after that join. I want to join those 100k to the parcels which have about 40k so there would be some parcels that are 'stacked' and have 5 rows. I'm trying SpatialFilter, SpatialRelator and PointOnAreaOverlayer and not having any luck. I'm using 2021.0 desktop.

1 reply

virtualcitymatt
Rank
Userlevel 4
Badge +26

What you need to do is use the list option (on the areas) when merging attributes when using the PointOnAreaOverlayer. You can then use a ListExploder which will create one feature for each element in the list.

 

Example

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.