search

jsoma / data-studio-projects

12 stars 18 forks source link

I speak for the trees #292

Open vpenney opened 6 years ago

vpenney commented 6 years ago

Please complete all of the following sections, or the ghost of Joseph Pulitzer will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1

Pitch

I'm going to analyze NYC's street tree data from the 1995, 2005, and 2015 censuses to see how tree health has changed, which trees are most popular by borough, and anything else I can find. Most densely-treed areas? All of the trees have species, health, and geocoordinate data, so there's a lot to look at.

Summary

Delete this line and summarize your project here (drag and drop images to add them - PDFs won't work, screenshots or png exports are good)

Details

Possible headline(s): Which NYC borough would the Lorax like best?

Data set(s): 1995 2005 2015

Code repository: https://github.com/vpenney/data-studio/tree/master/code/06-nyc-trees

Possible problems/fears/questions:

Work so far

So far, just a couple quick bar charts that I'll need to put on the same scale and plot together:

screen shot 2018-08-14 at 9 53 37 pm screen shot 2018-08-14 at 9 53 29 pm screen shot 2018-08-14 at 9 53 22 pm

Also, something weird happened in 2005. I'll need to check all of that data.

Checklist

This checklist must be completed before you submit your draft.

sarahslo commented 6 years ago

Here's what I'd like to see. Can you normalize the data and show us the number of trees per 10,000 people in each borough? then, can you calculate the change between 1995 and 2015? (final-initial)/initial*100

vpenney commented 6 years ago

Update

trees-per-person

I started with trees per 100 people, but I'm having a hard time finding an interesting way to visualize that data.

Any changes in direction or topic?

No changes so far, just working on the best ways to make the information seem interesting.

Problems/Questions

Infographic type things that look cool? I might use area to show the change in number of trees over time.

Checklist

vpenney commented 6 years ago

Final

Project visuals/text

Percentage change in trees, 1995 to 2015, per borough: tree-percent-change

Trees per 100 people, per borough trees-per-person

Tree species in NYC nyc-tree-species

Details

Headline: In 20 years, NYC added 166,799 trees

Published website version: https://vpenney.github.io/nyc-street-trees/

Code repository: https://github.com/vpenney/data-studio/tree/master/code/06-nyc-trees

Final data set(s): The datasets were too large to upload, but they can be found here: https://data.cityofnewyork.us/Environment/1995-Street-Tree-Census/kyad-zm4j https://data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/uvpi-gqnh

What did you find to be the most difficult part of this project?

Finding a non-bar chart way to visualize trees per people. I gave it a shot.

Are you satisfied with what you produced? Is there anything you would like to change or improve?

Mostly! I wish I had more time to build an interactive map with the data and look at where trees are healthy and sick to see if there are trends.

Checklist

sarahslo commented 6 years ago

Ok one nit, ARROWS point toward the data, NOT the annotation!! I thought the normalized tree approach was fine, tbh. But super cute attempt with the loraxes. Never seen that.

Another thing to have maybe done was to divide trees by landmass...but hey, you've got them by people so I buy it.

I'm glad to see this analysis done. If you took it further I would suggest adding pictures of the trees with the pie chart, because while I'm sure I've looked at these trees I have no idea their names.