VizWiz

Launch, grow, and unlock your career in data
Showing posts with label pollution. Show all posts

May 27, 2019

#MakeoverMonday: What has happened since people started paying attention to climate change?

No comments
For week 22, Eva chose a topic that she and I are both very passionate about...climate change.


What works well?

  • Using a line chart over time helps show the trends
  • Including a slider filter for the user to zoom in on a specific period

What could be improved?
  • Using dotted lines indicates there are breaks in the timeline, but there aren't. Therefore, a solid line should be used.
  • The labels on the ends of the lines hide the data.
  • It could use an impactful title and subtitle. Though I suppose this is just a report, not analysis.

What I did

I created a map to ensure that the country names were correct. When I did this, I then saw that there were lots of aggregations of countries.  For some reason, the income level categories captured my attention so I filtered down to just those items.

The years 2015-2018 were include and didn't have any values. I filtered those out. There were years when no data was captured for some countries. I filtered those out.

I plotted the data as a line chart and created a calculation to show the change vs. the first year for each country. I noticed that there was a spike in CO₂ per capita in 1973 for high income countries. This reminded me of the oil crisis of 1973, but that wouldn't have anything to do with carbon emissions I wouldn't think.

That got me thinking about climate change in general. I entered "when did people start paying attention to climate change" into Google and the first search result was an article from National Geographic titled "Climate Change First Became News 30 Years Ago. Why Haven’t We Fixed It?"

This particular line was what I was looking for: "The Intergovernmental Panel on Climate Change was established in late 1988..."

So, back to the data I went and I filtered the data to 1988-2014 and compared every subsequent year to 1988 in order to see how much things have changed since climate change started garnering some attention. I expected high income countries to have ever increasing CO₂ per capita. I was wrong.

It turns out that the middle income countries have had the largest change in CO₂ per capita. So that became the focus of this analysis.

March 30, 2019

Groundwater Contamination and Cow Poo: A Major Contributor to Global Warming

No comments
This is a project I've been working on for a while now, mostly because time has not permitted me to finish it and I've had other "issues" to deal with. I've been doing lots of research about global warming, water contamination and whether or not the two are related.

While watching a documentary, they mentioned how methane from cows (i.e., cow farts) are a major contributor to the greenhouse gasses and how cow manure is a major source of nitrate released into groundwater used for drinking. Fortunately, there is tons of data available, the primary source being the Environmental Protection Agency (EPA).

I wanted to understand the geographical distribution of three factors:

  1. The percentage of each State with high groundwater nitrate concentrations.
  2. The total area (square miles) of each State with high groundwater nitrate concentrations.
  3. Where the cow crap comes from that pollutes groundwater used for drinking.

I decided to create a map for each of these topics, as a scrolling story, with three actions you can take to help reduce the impact of cow manure pollution. We all want safe drinking water after all.

June 19, 2017

Makeover Monday: Is America Improving Its Ozone Air Quality?

2 comments
Eva and I are hosting another BrightTalk webinar this Friday titled "Visualizing Smart Cities: How Data can help shape our communities". This is part of an Internet of Things week for BrightTalk so when deciding what data set to pick for this week, I got to thinking about air quality sensors. A quick google search turned up a treasure trove of data on the EPA website. Thanks for my friends over at Exasol, I was able to create a place for all of us to play with all 202 million hourly measurements. If you want to play with the live connection to all 202M records, you will need a login which you can create via this registration if you do not already have one.

The EPA website also contained some basic reporting, which is the focus for this week's makeover.


What works well?

  • Simple layout. It's easy to see you have days within months going left to right and years going down.
  • Colors match the official EPA colors for the AQI categories
  • Including the ranges we know what constitutes a good reading vs. a bad reading
  • The title tells me what I'm looking. Including the date range is a nice touch too.
  • Using a strip plot along with the colors helps reveal seasonal patterns
  • Including the source in the footer

What could be improved?

  • Make the colors color-blind friendly
  • It's difficult to see how a month has changed across the years.
  • I can't hover to see the values.
  • It says each “tile” represents one day of the year and is color-coded based on the AQI level for that day, but I think it's actually showing the max measurement for each day. It should be more clear what they are representing.
  • There's very little context. How does one county compare to others? How does one county compare to the national average? 

What were my goals?

  • Last year I challenged The Data Duo to visualise an almost identical data set. Pooja created a pretty amazing viz (of course), so I wanted to pick some parts off of it. Particularly, the State selectors on each site and the dot plot.
  • I wanted to understand how each month changed across the years, which is pretty much exactly what a cycle plot was created for. I used a trend line instead of an average though because that seemed to show the patterns better.
  • I wanted to add context for comparisons to the national average and to the state average (which appears when you click on a state).
  • I wanted to use color-blind friendly colors.
  • I wanted a small sparkline-type chart to show how things have changed since 1990.

With these goals in mind, here is my Makeover Monday week 25 submission. Click on the image for the interactive version.

October 5, 2009

Follow up: Evolution of the Ozone Hole

1 comment
You know, I really love it when people discuss issues and share solutions. Joe Mako and I had a great discussion on my last two posts regarding the most effective visual representation of the ozone hole over time. Joe create an OUTSTANDING representation of the data using floating bars.



Joe created this visual using Tableau. I had not seen anyone do this in Tableau before. I had thought about doing stacked bars and making the lower of the two bars white, but this is way better. Joe has also provided the Tableau Packaged Workbook. I have posted this on a Google Group that I just created.

Thanks Joe! Excellent work!

Size Evolution of the Ozone Hole

2 comments
Joe Mako left a comment on my previous post critiquing the use of bubbles to represent the size evolution of the ozone hole. I agree with what Joe said: "a bar or line would have been better." The only problem with using a line is that there is not a consistent time measure (1996 throws it off...yes I know, a minor issue).

So I recreated the data with two bar charts. (1) Representing the actual values and (2) the change from the previous measure. I like (1) better. How about you?

October 4, 2009

Quick, help save the bubbles

1 comment
Someone, please help explain this to me. There is no legend to reference the colors, the data, nothing.

Why 1996 instead of 1995? What do the numbers represent? What do the colors signify? Why is the last bubble green instead of hot pink?

If the dark grey in the middle four circles represents the ozone hole and the total size of the circle is earth (which I can only assume), then I think it's a poor representation of the problem. Is the ozone layer really that huge? No, it's not.

Please someone, save me! No wait, don't save me, save the bubbles!