This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Does anyone have any ideas on how to create groups or clusters for spatial points? I have about 1,200 points positioned globally and I need to group the ones that close to each other. The only information in the table is a unique ID and lat/lon coordinates.
I was thinking of creating 20 or 30 mile voronoi rings then combining the spatial trade area to create a single group. Then use Find Nearest to assign points that are within 2 or 3 miles of a trade area. That should help with the stranglers. Problem is in areas where the sites are really dense. Ex NYC. The group can get really large almost cover half the Northeast.
The whole process needs be automated, as new points are added daily. Any ideas?
What you could do is to define a grid system, and then any grid with more than a certain density, the definition of close is "within 1 mile", and when the density is lower, then use a far broader tolerance (like for Alaska or northern Europe).
From there, you just change the centroid to a trade area using this distance tolerance, and merge overlapping regions together.
Yes, I did @SeanAdams. Thanks for the help. I ended up running the K-means and then creating a 30 mile buffer around the centroid of the k-means grouping (Client was demanding 30 mile buffers). Locations that fell outside of the 30 minute buffer were assigned their own cluster. Thanks again for the help.
Thank you so much for posting this. I have close to 2 TB of data with Lat and Long information with Timestamp for every second. something like this for eg in the attached format. So when i plot these points on US map i would like to have cluster points which are close to each other with large cluster having bigger size etc..