I think the most interesting part was the last map, which the practicalities of constructing was completely glossed over.
It was nice seeing how these stats can be calculated in sql, but this analysis would be beat by a few pivot tables in excel.
Excel can even draw a map to go along (although not as pretty)
Neat. Thanks!
The author writes a significant amount about their workstation, and how cleaning up the geometry can be helpful when accessing it remotely over S3.
The dataset is a 8,000 row spreadsheet.
My advice when working with such a small dataset is not to overthink it.