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?