topic Re: Joining points to segments more computationaly effieciently? in Spatial Statistics Questions

Joining points to segments more computationaly effieciently?

BachirHamadeh — Mon, 15 Aug 2016 11:14:53 GMT

I have over two million crashes located as points through GPS coordinates in the state of Pennsylvania. I also have over a hundread thousand road segments in the state and would like to know the number of crashes per segment. I am right clicking the segment feature class and using join with the point feature class and choisibg summarize sum to do this. I did the analysis on a single county and it worked except when i extrapolated the time to do this for the entire state, i came out with several several weeks with non-stop processing. Is there any way I can process this faster without reducing the number of segments i am merging the crashes to?

Re: Joining points to segments more computationaly effieciently?

NeilAyres — Mon, 15 Aug 2016 12:03:46 GMT

See my comment on your other thread.

Re: Joining points to segments more computationaly effieciently?

DanPatterson_Retired — Mon, 15 Aug 2016 12:28:48 GMT

Yes

Neil... where is the other thread, ... don't want to duplicate answers

Re: Joining points to segments more computationaly effieciently?

NeilAyres — Mon, 15 Aug 2016 14:04:58 GMT

Dan,

sorry but the author has posted this twice, the other one is in Managing Data.

Don't know how to cross link the 2.

Re: Joining points to segments more computationaly effieciently?

RebeccaStrauch__GISP — Mon, 15 Aug 2016 15:55:42 GMT

Neil Ayres‌ Easiest way to mention a cross post is just to mention it is a duplicate hse and include the link to the other (or whichever already has comment(s)/answer) e.g.

https://community.esri.com/thread/181427-spatial-join-more-time-effeciently

To post and include two locations, it's a s easy as use the at and space/place name, eg

https://community.esri.com/community/gis/managing-data?sr=search&searchId=30e83fec-1fb8-46e6-aa64-097ffcee28a8&searchIndex=0‌

The original posted has the option of deleting this thread and adding this space https://community.esri.com/community/gis/analysis/spatial-statistics?sr=search&searchId=8e90ea5c-1a4b-4a96-bf29-683efe000b72&searchIndex=0 to the other thread...to keep it in one

Just an fyi for future.

Re: Joining points to segments more computationaly effieciently?

DanPatterson_Retired — Mon, 15 Aug 2016 16:49:01 GMT

Your point pattern is important, if it is a spatial join (ie you have the coordinates of the incidents) then you need to perform some sort of spatial aggregation first. If the coordinates were duplicates, then you could summarize that way. If the locations are dispersed along a road stretch, then you could use an aggregate points using either the polygon or its centroid prior to a spatial join.

There are many other options, but your task is to aggregate either/or/both sets of data. Comparing every point to every segment in the standard interface (even with its underlying optimizations) is a waste of time and won't reveal any more information in most instances.