nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Spatial joining multiple points to a line

Surya_Vaidy

Hello!

I am attempting to spatial join multiple points representing snowplows to roads in hopes to calculate the frequency of plowing services along certain roads. However, my attempts at joining haven't worked out. I've been using "one to one" joining, but should I be using "one to many" joining? Furthermore, not all the points generated from my data line up exactly with roads. Is "within a distance of" the optimal match option for the join, or is there another option that is perhaps better?

Thank you!

Find more posts tagged with

Accepted answers

Robert LeClair

Surya - the Spatial Join geoprocessing tool does have a "within a distance" match option parameter that you could use in your analysis. Depending on how you set up the spatial join you could do a one to many parameter. One road segment to many snowplows as it were.

All comments

BarryFosberg

I have a similar , thogh slight diffreent problem.

Bottom line first:

I need to join points to lines, and sum on 1 of the attributes of the points. I am running ArcPro 3.1.3 WIth among aother Spatial Analyst.

Details:

I have 2457 points, each weighted (count of events), whole numbers from 1 to 8. I have over 256K road segments (line feature).

I want to join the points to the nearest line segement, and know the sum of the events. The out put should never be more than 2457 rows, and am totally certain it should be more like 2300 rows. The statistices (Chart Properties) for the events cannot exceed 3630.

For example one street segment might have 5 points on or near it, but the sum of events at those 5 points is 10. The join count should be 5 and the sum of the events is 10.

Almost all of the street segements will have null join counts. I do not need to keep all targets (Street Lengths).

After numerous runs, uing Closest, Closest Geodisik amd a a number of variations of intersect, with "within a search distance" from 5 to 100 feet and while using field mapping (or not) to sum on the count field, I have nothing reliable. Sum of the event vary from almot 500 too many, to about 500 too few. row couns vary from about 1200 to about 2300.

Suggestions?

JayantaPoddar

It is a common problem where the points might not be intersecting with the line. In this scenario, "WITHIN A DISTANCE OF" with a required threshold distance should work.

ONE_TO_ONE relationship should be fine, if you are looking for the count (unless you are looking for multiple copies of the target feature).

Surya_Vaidy

Thank you very much!

Robert LeClair

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.