Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to perform unsupervised Spatial Clustering of Polylines

chrismoshier
5 - Atom

I'm trying to group polylines (running routes) based on their similarity - any guidance on the best tool and starting point?

 

Specifically, I have 600 or so running routes, each with a spatial object and total distance.

 

I'd like to group routes based on the most common tracks that I run.

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora

Hi @chrismoshier 

Could you describe what you think as "similar"?

 

chrismoshier
5 - Atom

Thanks for the quick reply. Here's an example of 6 routes in Chicago. They're all a little bit similar, but only 4 and 5 are "similar" based on the actual distance, the starting/ending point, and the actual route.

 

 

Picture2.png

Yoshiro_Fujimori
15 - Aurora

Thank you for the information.

 

I am not an expert of Clustering at all,

but I guess the issue is how to apply K-Centroid Cluster Analysis tool in Predictive Grouping to your case.

 

If you are not familiar to this tool, check the interactive lesson;

https://community.alteryx.com/t5/Interactive-Lessons/Clustering-in-Designer/ta-p/679556

 

The problem is that the tool accepts only numeric fields as the input data field (not spatial objects).

So one idea is that you input the following fields to the tool and see if it works.

ST_CentroidX([startPoint])

ST_CentroidY([startPoint])

ST_CentroidX([endPoint])

ST_CentroidY([endPoint])

ST_Length([route],"Mi")

 

You may want to add the data features, say 

ST_NumPoints([route])

ST_CentroidX([route])

ST_CentroidY([route])

ST_MaxX([route])

ST_MaxY([route])

ST_MinX([route])

ST_MinY([route])

 

If you want more, you may want to add

1st quarter point

Halfway point

3rd quarter point etc.

(But it may require a little more efforts of working on Spatial tools. I would not deep dive it for now.)

 

I hope this helps. Good luck.

Labels