Create polygons around points with similar density

Question

I have lat/long data that are used to create points on a map. I want to create polygons around groups of these points based on density. So in my poorly color-coded drawn example below, I have 4 different areas that I would want polygons around. The red and black have similar densities, but they are separated due to the null area (less dense) between them, so they would have separate polygons. As an added bonus, I would like to limit the number of points in each polygon to a set amount as well. This doesn't have to be perfect. It would be fine if the red black and purple ended up in 1 polygon. I have been toying around with making grids and then trying to group the grids together, but still haven't quite got there.

AZuc · Answer

@rtlane ,

Take a look at this workflow. It hasn't reached the same result you expect, but it includes some concepts like clustering lat/lon and using a macro to aggregate the areas.

Playing with the number of clusters and the buffer area will let you to different results. You can also think about rewriting the macro to try a totally different criteria to join the small areas.

I hope it helps

Density Aggregate Area.yxzp

rtlane · Answer

Here you go. The points are the sample data and the final polygons would be the expected output.

Final Polygons.yxdb

Points.yxdb

AZuc · Answer

@rtlane , could you provide some sample data and the expected result on the data?

Also, take a look at this link https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Dot-Density-Macro/ta-p/1266