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.
I'd like to share how I generated a simple density map using the Make Grid tool.
In this case, I used one of the free shapefiles available through Portland Maps Open Data (it looks better if you have a single cohesive area you are plotting, but free is free!)
First, aggregate all polygons into one using a Summarizetool and then divide it into a grid. For this example, I chose a 500x500 foot grid. Then use a spatial match to overlay the original shapes and their data with the grids. Use a second summarize tool to count the number of parcels (or units, or buildings, or whatever you choose) within each grid. Then let the Reporting tools do the rest! In this case, I used the legend splitter and builder to create a custom legend that converts the values to parcels per square mile.
I've attached the workflow, and the data are available from the link provided within.
Hi @myastarling, I am seeing an error in the Overlay tool - "A field cannot be overlayed on top of itself." Can you describe what your use of that tool should do? Also, I had to unclick "Clip to Polygons" in the Make Grid tool, possibly because of a change of default between Alteryx versions.
I'm just seeing this now -- life happened and had to step away from Alteryx Community :( So I don't know what's going on with the original workflow I posted. I replaced it with text input with the two required fields, but different data source and it is working for me. Try this out and let me know if this works.
yeah, I chose that one because it's a smaller file to convert to text entry (only 136 kb). Here is the workflow using the same data source as the first one. I don't know what was causing the error you are seeing though.