Price of Recommended Fruit/Vegetable Consumption, 2010

Screen Shot 2015-04-28 at 3.23.05 PM

Interactive version: http://s2tephen.github.io/qfahpd/map/

This map takes the two data sets we worked with previously — the Quarterly Food-at-Home Price Database (for the small multiples of fruit/vegetable prices) and the Thrifty Food Plan (for the SNAPables data sculpture) — and attempts to synthesize them to tell a single data story. In our presentation of the food price data, one of the criticisms we received was that price per 100g of food was not an intuitive way to think about food consumption. The Thrifty Food Plan, the bare minimum of an adequate diet (and the basis for calculating SNAP benefits), actually includes the breakdowns of its market baskets by weight (pounds). This meant that we could actually calculate the real price of the Thrifty Food Plan around the United States, factoring in regional price differences.

Most of our time was spent cleaning and synthesizing multiple data sets, so once again we only had time to focus on the fruit/vegetable food group. However, the next step for this map would be to calculate the combined price of all food groups (i.e. the entire Thrifty Food Plan market basket) and compare this to the SNAP amount. This is because the cost of the Thrifty Food Plan is based on the assumption of uniform food prices across the nation — however, as the Quarterly Food-at-Home Price Database shows, this is simply not the case. We could then identify which regions’ SNAP benefits may be over- and underestimated.

As such, the audience for this graphic would be the researchers and policymakers responsible for creating the Thrifty Food Plan and setting the SNAP benefits. The goal of the combined map would be to advocate for a new SNAP benefit methodology, based on actual local food prices. For this iteration, we only included data for those from age 19-50, but one could imagine an even more interactive version of this graphic, where someone might specify their age/sex and weekly spending on food — the map could show them the weekly required spending for an adequate healthy diet, allowing them to compare those numbers.

In terms of data visualization, this choropleth was created in D3.js/TopoJSON and uses quantile classification to subdivide the different weekly spending amounts on fruit and vegetables. ColorBrewer was used to generate the colors, but the large area of yellow is kind of hard to see (perhaps we could have used a different color ramp or adjusted the classification buckets to improve this). Furthermore, the map would be a lot more readable (i.e. as a static graphic) with a legend — as it is currently, you only get a broad comparative view of the country and can only really zoom in on actual prices if you use the interactive version. Another minor thing is, because the data is regional and not at the county-level, having each county as an individual entity is kind of useless (the counties don’t conform to traditional political boundaries, so this was the best we could do). The other question is whether a map is actually the most appropriate visualization method — even if there are significant differences in food prices based on geography, we might need to make some hypotheses or incorporate additional data sets to explain how geography might be affecting variation in prices.

Mapping Artists Around the World

Artists in Tate's Collection by Country of Birth

*this embed isn’t working well so go here to view its full interactivity!

For this assignment, we used Tableau to map where artists in the Tate collection were born. First, we made maps that show in which countries artists were born in by century (1500s, 1600s, 1700s, 1800s, and 1900s). Scrolling through these maps reveals how the scope of what the Tate collects changes over time: while art works by artists born in the 1500s and 1600s are limited to Europe, we see that the Tate represents artists born in the 1700s from the U.S., Canada, and Russia; that artists from the southern hemisphere begin to emerge in the 1800s; and that artists born in the 1900s represent countries from all over the world and from every continent. A final chloropleth map shows artists born in all centuries. The darker countries indicates those with more artists represented (the United Kingdom, unsurprisingly, is the most represented country in Tate’s collection); the lighter ones might only have a handful of artists in the collection.

Goals

Our goal is to give a macro-view of what is in the Tate’s collection. Often, when people are visiting museums, they focus on one object at a time; a visualization likes this can help visitors understand the larger scope of what a collection represents. Another goal is to reveal how a museum like the Tate represents the world and what biases they have toward certain geographic areas. Most of their holdings stem from the Western world (especially the United Kingdom and the United States), but we do see that more modern and contemporary art has begun to accept artists from all over the world.

Audience

People who are interested in art and artists. Visitors to the Tate (many of them international) might be interested in seeing if their country is represented in the collection.

Next steps?

We brainstormed other maps that we could undertake with our data sets but unfortunately did not have the time to fully clean the data, run scripts, and make new maps. On a very basic level, it would be great if the labels could allow you to dig into artists names per country (and possibly link you to information about them). It would be interesting to write some code that would allow users to type where they were born and be given an artist born close to them. Considering our team’s interest in analyzing color in works of art, we were thinking of finding the average or most dominant color per country and making a map that represents countries by these colors.

Mapping the SNAP-friendly Stores in Somerville

Deborah, Tuyen, Hayley

Following up with our data sculpture, we wanted to see where the retail stores that accept the SNAP are located in the two-dimensional map. We were curious to compare this 2D mapping to the 3D data sculpture: which visualization would feel more trustworthy and give more “authority” to our data and story? which one would more effectively represent the scarcity of the farmer’s markets?

Audience
So, the intended audience of the following map was ourselves. It was created to help us understand the strength and weakness of visualizations in 2D and 3D.

Data & Filtering
We first downloaded the USDA data that contain the list of retail stores which accept SNAP in MA. We then filtered the data to get the lists of stores with the Somerville’s zipcode: 02143, 02144 and 02145. Here is the link to our filtered data. Unlike our data sculpture for which we categorized the stores into four groups (Grocery store, Supermarket, Superstore and Farmer’s market), this time we divided the stores into just two categories: farmer’s market and non-farmer’s market. Non-farmer’s market category includes grocery stores, supermarkets and superstores.  We made this decision in order to highlight the scarcity of the farmer’s markets (that accept SNAP), relatively to the number of other retail stores.

Here is the link to the same map of SNAP-friendly stores in Somerville.

SNAP-friendly stores in Somerville, MA
SNAP-friendly stores in Somerville, MA

Although this 2D map lost the physicality of the balloon sculpture and the audience did not have a chance to feel the physical challenge of reaching/searching for the farmer’s markets, we found the exploration option using the side pane quite useful. We were able to click on the name on the side pane (that lists all mapped stores by its type), and the map would adjust the center of the view according to the location of the store; it felt as if we are looking around even though the degree was limited. Searching through the long list of non-farmer’s markets in the pane also allowed us to experience how rare the farmer’s markets with SNAP are. We had to scroll down multiple times to encounter a farmer’s market.

Choropleth Maps: US Agriculture and Drought

Ceri Riley and Val Healy

For our map project, we decided to make several small choropleth maps to illustrate where selected foods are grown and compare them to where drought is located. Unfortunately, Google Fusion Tables maps do not allow for changes in color, so all of our maps are green, though we would, if allowed, choose to use brown for the farmed animal maps, green for the crop maps, and red for the drought map.

These maps were produced using 2013 USDA Datasets on Cash Receipts for crops and averaged 2013 Weekly Drought Data. Drought conditions have since become more serious, but the data on agricultural production by state is only confirmed through 2013 so we chose to focus on this year.

Cattle and CalvesHogsBroilersRiceWheatCornD0-D4D4

Here are links to the maps for interactivity:

Agriculture: Cattle and calvesHogsBroilersRiceWheatCorn

Drought: D0-D4D4

As you can see, there is a moderate amount of drought throughout the central/western part of the United States, with the most severe drought focused in the midwest around Nebraska.

The majority of the cattle industry is located in a region where there are more serious levels of drought, while chickens (the ‘broilers’ map) are located further East. Cattle farming also requires more water than chicken farming, though, so perhaps this correlation is partially due to the large water footprint that feeding/watering cattle leaves.

Rice, wheat, and corn are three of the most prevalent grains in the United States, and the maps show areas where the drought regions overlap with the agricultural regions in addition to states that were relatively unaffected by drought. This allows an audience to explore different states’ contribution to US agriculture, beyond what is normally reported in mass media (recently, California agriculture). For example, the more serious drought in California might affect 26% of the rice crops, but 41% of rice is also grown in Arkansas. However, a lot of the states that grow corn are also affected by some level of drought.

Audience

Our audience is those who wish to see which types of crops or animal agriculture might be most affected by drought.

Goals

Our goal for this project is primarily internal; we wanted to make these maps to aid us in finding areas of food production most affected by drought. We hope we can use information gleaned from this small project in our final project, as our datasets covered more information than shown here.

In addition, these maps could demonstrate that there are significant levels of drought and crop production in the United States outside of California, even though most of the media focus is on the one state.

Small multiple choropleths – income and obesity

MergedChoro2

You can see the choropleths here as well.

NOTE: We inverted the axis on the median income map because we wanted to make use of the people’s tendency to associate red with danger. Had we not inverted the axis, the wealthiest states would be dark red, which may be confusing (we hope that the inverted axis is less confusing than the dark red on wealthy states would have been).

Audience

General public, especially people from middle-class or rich households.

Goals

While other sources have pointed out the link between obesity and poverty, we wanted to see it for ourselves and illustrate it geographically using multiple metrics.

The maps are geared towards people from middle-class or rich households, because they may not be aware of this connection.

We aim to show that the poorest states are also the ones most prone to obesity. In addition, we aim to identify the states in which the poverty/obesity link is most severe. To do this, we generated a number of choropleths and presented them in the “small multiple” style.

Extra

We also tried making some cartograms, but they were a bit confusing to read. Here’s what they looked like.

cartograms