Wednesday, April 3, 2013

Toronto Licensed Cats & Dogs 2012 Data Visualization

It's raining cats and dogs! No, I lied, it's not.

But I wanted to do so more data viz and work with some more open data.

So for this quick plot I present, Cat and Dog Licenses in the City of Toronto for 2012, visualized!



Above in the top pane is the number of licensed cats and dogs per postal code (or Forward Sortation Area, FSA). I really would like to have produced a filled map (chloropleth) with the different postal code areas, however Tableau unfortunately does not have Canadian postal code boundaries, just lat/lon and getting geographic data in is a bit of an arduous process.

I needed something to plot given that I just had counts of cat and dog licenses per FSA, so threw up a scatter and there is amazing correlation! Surprise, surprise - this is just the third variable, and I bet that if you found a map of (human) population density by postal code you'd see why the two quantities are so closely related. Or perhaps not - this is just my assumption - maybe some areas of the GTA are better about getting their pets licensed or have more cats and dogs. Interesting food for thought.


Above is the number of licenses per breed type. Note that the scale is logarithmic for both as the "hairs" (domestic shorthair, domestic mediumhair and domestic longhair) dominate for cats and I wanted to keep the two graphs consistent.

The graphs are searchable by keyword, try it out!

Also I find it shocking that the second most popular breed of dog was Shih Tzu and the fourth most type of cat was Siamese - really?

Resources

Toronto Licensed Cat & Dog Reports (at Toronto Open Data Portal)

Toronto Animal Services
http://www.toronto.ca/animal_services/

2 comments:

  1. I just did something slightly different with the same data set. IMO it was crucial to take FSA populations into account. http://amansourati.wordpress.com/2013/07/08/toronto-dogs-and-cats/

    ReplyDelete
  2. Hey Alex - I totally agree and note this as such. If you look at any population density graph of Toronto you can see it looks similar (e.g. http://www.statcan.gc.ca/pub/85-561-m/2009018/m001_en.gif) - I just wanted to quickly do some more mapping with Tableau.

    Cool maps that you have produced! Looks like more (licensed) dog ownership per capita on the upper west end?

    ReplyDelete