Stuart Lynn

Make insightful dot density visualizations in CARTO!

This map shows the ethnic diversity of the US by showing one point for every 100 people of a given ethnicity. It was inspired by this [map] created by the cooper center.

To make the map we used data from the census along with a method called dot density. For each census block group we know from the census the number of people who reported themselves as Asian, Black, White and Hispanic of Latino. This allows us to make chlropleth maps in the same way you are probably used to showing each ethnicity. For example here is a map showing the counts of people who indicated they are Black on the census:

What if we want to show all the ethnicities on the same map? What if we wanted to have a map that gets much closer to conveying the number of people who are reporting in the census along with their make up? Well thats when dot density can be useful. By using this following PLPGSQL function, which you can add to you own account simply by copying and pasting it in to the SQL panel on CARTO, we can turn geometries and counts in to points in those geometries.

We can run this function for each ethnic group in our dataset as so:

This will return a table of points, one for every 100 people in the census tagged by their etnhnic group. The result (after some considerable computation time) is this map, which conveys the shear number of people in the census along with who the diversity of ethnic groups across the US.

It took quite a while on one of our largest plans to make the dot density for the entire US so we recommend you use this method for smaller areas where it can still be really powerful!

How people get to work?

Of course you aren’t limited to just making dot density maps of ethnic groups. You can use any data that is a number count of people in a geometry. For example Daniel McGlone over at Azavea produced this blog post about using the same function to map out how people in Phillidelphia

We hope this has given you some ideas for how to apply the Dot Density method to your own maps. If you make one share it with us on twitter or post in the comments.

Happy Mapping.

Related Posts

Ready to optimize your territories with Location Intelligence?

Close circle icon

Contact us

Please fill out the below form and we'll be in touch real soon.