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?
Best,
Derek
Solved! Go to Solution.
Are you looking to cluster on location only, or are you looking to group by vehicle, speed, time, etc? Please be more specific with what factors affect the clustering. If you could share some sanitized sample data as well, that would be great.
@Srehul - Any thoughts on that please? thanks
Attached is an expanded sample workflow. The groupings happen based on proximity, and can be adjusted based on the number of groups you want to return and the grouping seed. The clusters are pretty huge right now due to the limited size of the sample, but some playing around should dial it in to what you need. Let me know if this is the direction you're looking to go in.
It's an Alteryx version error. I'm running 11.3.2.29874. I think you need to update to the most recent version.
Hi @sriniprad08,
It looks like you need to install the predictive tools. Launch Alteryx, select Options -> Download Predictive Tools.