topic Spatial Join - One to Many - Need all duplicate records as individual line segments in Geoprocessing Questions

Spatial Join - One to Many - Need all duplicate records as individual line segments

sarahbergquist — Fri, 09 Apr 2010 22:31:36 GMT

I am trying to spatially join address point to tiger line files. I have tried using the spatial join tool with the setting of 'closest' to 50 feet of the road segment and the 'one to many' join operation. My result is all of the roads that are within a distance of the points but only one record for each road is created. Basically I need to have multiple road segments on top of each other containing all of the original attribute data of the address layer.

If anyone has any ideas, I would really appreciate it.

Thanks,
Sarah

Re: Spatial Join - One to Many - Need all duplicate records as individual line segmen

EduardoLópez_Gómez — Tue, 10 Apr 2012 10:25:42 GMT

Hi,

Make query table tool is able to perform this operation.

Regards,

Re: Spatial Join - One to Many - Need all duplicate records as individual line segmen

NobbirAhmed — Tue, 01 May 2012 15:40:12 GMT

... setting of 'closest' to 50 feet of the road .... but only one record for each road is created.

Closest always returns the closest, that is one, record. You can try using INTERSECT with a search radius.

Re: Spatial Join - One to Many - Need all duplicate records as individual line segmen

BinodAdhikari — Tue, 14 May 2013 20:57:57 GMT

If Closest always returns the closest then what's the point of One to Many relationship?

Re: Spatial Join - One to Many - Need all duplicate records as individual line segmen

NobbirAhmed — Tue, 14 May 2013 21:02:53 GMT

No purpose - even one to many is specified the tool will produce 1 record per match.

Re: Spatial Join - One to Many - Need all duplicate records as individual line segmen

RichardFairhurst — Tue, 14 May 2013 21:17:34 GMT

Closest always returns the closest, that is one, record. You can try using INTERSECT with a search radius.

This is what I do most often with Spatial Join and it works correctly to produce as many records as necessary to account for all matches within the specified radius.

Re: Spatial Join - One to Many - Need all duplicate records as individual line segmen

RichardFairhurst — Tue, 14 May 2013 21:27:14 GMT

If Closest always returns the closest then what's the point of One to Many relationship?

Its purpose is for Intersect primarily, where multiple records are created. Even with one-to-one and Intersect summaries of multiple records are produced rather than choosing a single record from the possible matches. The tool works with groups the way you would expect. If you had a group of individuals of different heights and I asked you for the height of the tallest you would report only one height value even if multiple people were that same height and at least one person in the group actually had to be that height. If I asked for the average height of the group you would give me one value regardless of the number of individuals in the group and whether that height matched any specific individual or not (intersect-one-to-one) and if I asked for the list of heights you would give me a list (intersect-one-to-many). The fact that one tool can be configured to answer each of these questions is actually very elegant.

If I asked you for the list of the tallest in a group (closest-one-to-many) and did not specify a range of tallness you would normally produce a list of the tallest person in each group. Technically you should list all individuals of a group that had the exact same height and were the tallest in the group, but it rarely happens in small groups (especially if the precision of the height measurements was extremely high).