Tableau scatter plot

Here is an example of a Tableau scatter plot:

Data update 3: let's 'wrap' these puppies (kittens and other animals, too) up

This Datawrapper chart illustrates the central point of my final report.



There are a few questions that I cannot answer with my data, questions such as those surrounding the location of the lost animals. If I wanted to know which locations the most lost animals are found at, from which neighbourhood the most animals go missing, or any other questions involving location, I would not be able to do so. I would have to go in person, either to City Hall or the BC SPCA, and ask for that information, information that could very easily be turned into a dataset. City Hall and the BC SPCA are the two agencies that should have this information, as the dataset was supplied by the City of Vancouver on their website, and the BC SPCA has online pet registries and lost and found websites. A simple FOI or ATI request should be able to get this information. The location information can simply be added to the original dataset I have been using. "Location animal was last seen at" or "location animal was found" could be possible columns. The information could then be added in as longitude and latitude coordinates, and eventually made into a map displaying different location information about lost and found animals in Vancouver.

My first Tableau chart

This is my first Tableau chart:

This is a Fusion Table shape map

Data update 2: innovative website helps find missing animals

Opening lead sentence:

More lost animals in Vancouver have been found and matched ever since the BC SPCA launched their innovative online lost and found website in 2012.

Here is the raw data and a small slice from the data:

https://drive.google.com/file/d/0B8Ktg1j9HnnIYk5seGk4RG5heWM/view?usp=sharing

The spreadsheet shows all lost animals in the city of Vancouver since the year 1999, and is still being updated in 2016 (Note that the years 2007-2011 are incomplete). Since those five years are incomplete, I decided to start at 2012, and lo and behold, I was able to find an article that related directly to the year 2012 (I literally spent all week trying to find an article that would add additional context to any aspect of the spreadsheet whatsoever, as well as figure out what to include in the slice, and was actually freaking out that I wouldn't find an article or figure out a slice and would have to change databases, but thankfully it all worked out in the end). The slice contains the number of animals that were lost in 2012 up until mid-February of 2016, and categorizes them into found, lost, and matched columns. Using these numbers, I calculated the percentage of found and matched animals, and each year's percentage was higher than 2012's.    

Here is the original dataset:

http://data.vancouver.ca/datacatalogue/animalInventory.htm

Here is a news story that relates to the data:

http://www.surreyleader.com/community/137101758.html

This article is about the then new online lost and found website the BC SPCA launched in January of 2012. It outlines some of the key features of the website, such as the public being able to post their own photos and descriptions of lost and found animals directly on the website. This article is relevant to my data because ever since the website was launched in 2012, the percentage of lost animals being found and matched has gone up and has not been lower than the 2012 percentage. It is safe to say that the launch of the BC SPCA lost and found website has factored into more lost animals being found and matched over the past few years. 

Interactive Datawrapper chart

Here are some election results:

My first Datawrapper chart

Here is my first Datawrapper chart: 
That was my first Datawrapper chart.