Friends or Foes: NYC Squirrels vs NYC Rats

For our penultimate day of dashboard week we were provided with an adorable dataset about NYC squirrel sightings. It immediately reminded me of another dataset I had worked with– NYC rate sightings. A questions came to mind:


Do the two creatures overlap or keep to separate quarters? 

For this dashboard I wanted to visualise where squirrels and rats are most sighted and how much overlap there is between the two. 

In Alteryx I used the spatial tools to get centroids of every sighting as well as the spatial match tool to see where rats and squirrels overlapped and where they didn’t. Here is the final dashboard:

Author:
Salome Grasland
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab