Dataset: (from assignment 2)
The Planetary Exploration Budget Dataset
(https://www.planetary.org/space-policy/planetary-exploration-budget-dataset)

Precondition:

1: Learning

The Planetary Exploration Budget Dataset, prepared by the Planetary Society, enables direct comparisons between past and current planetary exploration efforts by the United States. The problem is that each individual American has a different opinion on how space exploration furthers the cause of science. And those personal opinions may differ drastically from shifting national priorities. The visualization allows a user to compare spending by mission, by year or decade, by destination and by launch costs to get a feel for how their tax dollars were being spent on space exploration. The main hypothesis is even though the Moon has been the stated goal of human spaceflight, it’s really Mars that dominates the planetary desires of the United States which sets the stage for landing humans.

2: Winnowing

Some of the raw data in the dataset include subsets to help explore

  • Mission costs
  • Funding by destination
  • Budget history (by year or decade)
  • Major program costs

The Planetary Society prepared the data using actual NASA budgets from 1960 to 2020. (https://www.planetary.org/space-policy/planetary-exploration-budget-dataset) Unfortunately, one of the drawbacks to the data, is that during the late 1990s into the early 2000s, NASA integrated management of the entire science mission, including astrophysics, space physics, planetary science and Earth science. This resulted in a loss of granularity and transparency into the individual programs. According to the Planetary Society website, reconstruction of the planetary science budgets has been filled in during this period but I wonder at the bias introduced when combing documents that are not part of the public record. Was the reviewer more interested in looking at lunar science as opposed to small body research. Also, in 2004, NASA shifted to a full-cost accounting method for its projects. This results in a more accurate view of budgets per project but compared to past data, it looks inflated. Still to explore the idea of how shifting national priorities affected funding choices, it is useful to include overall mission costs, funding by destination and how they fit into major program budgets. Also, to provide a general overview, including the budget histories on a decadal basis is useful. This visualization will rely primarily on decadal budget and funding by destination.

Core:

  • 3: Discover
    • what task
      • tree
    • when task
      • select
      • aggregate
  • sketch


    4. Design: Create a sketch of your initial prototype. Note that this sketch can be drawn from your work either in Assignment 2 or in the source article, but should include some design iteration to support your target tasks. Add brief design justifications and discussions of the trade-offs of key design choices in the sketch, being sure the discussion is closely tied to your target tasks. Make sure to include a copy of the sketch in your write-up.

Second diagram above (at left): Using the tasks of what and when, the second prototype allows users to travel along the timeline (1950-2020) and see when missions were sent to Moon, Mars, Venus, Mercury, the outer planets and beyond. The timeline also shows the proportions of the budget devoted to the destination. If the question to be answered that Mars has always been the main driver of the US planetary science program, this visual should help guide that story.

One of the key tradeoffs of the mission chart is crowding. This was done to fit the data into a single screen. Without the planet icons, crowding is minimized but I think the icons give more guidance than simple node indications. 

  1. Implement: Implement your design as a more polished digital or physical data representation. You can use any tool of your choosing, but if you elect to use a WYSIWYG tool like Tableau or Excel, please incorporate design choices beyond the defaults provided by the tool. Note how you’ve implemented your solution, how it addresses your core tasks, and include at least one image of the visualization in the write-up. 

Tasks:

  • Added icons to make the tree map a little more interesting
  • Separated missions (more winnowing and filtering of the dataset) in an attempt to show true increase of missions to destinations over the years.
  • Still have not figured out how to make it interactive on a timeline.

  • Readjusted the data to show “What” and “When” a little more literally in the dataset. I thought it would be easier to handle and make interactive.

d3 version of bubble chart – could not quite figure out (yet) how to animate this over time. So I created an animated GIF to show it.

 

 

Deploy: Use your visualization with your target data to conduct the tasks you outlined in Step 3. Note your observations about the data gained through these tasks. 

    • To accomplish my goal of adding a timeline, I thought that the data would need to be massaged a bit more into a json structure as follows. This allowed, in my mind, a way of creating the timeline and stepping through each year showing cumulative missions and funding. I was not able to implement this data structure in a working version however.
    • It would be a more dynamic visualization to not only add the timeline functionality but also to add a bit of physics in the form of simulation forces. But not necessary for overall story.
{
      "year": "1960",
    {
      "children": [
        { "destination": "Moon", "missions:" 0, "funding": 256.9773, "cumFunding": 256.9773, "cumMissions": 0  },
        { "destination": "Mars", "missions:" 0, "funding": 0, "cumFunding": 0, "cumMissions": 0  },
        { "destination": "Venus", "missions:" 0, "funding": 0, "cumFunding": 0, "cumMissions": 0  },
        { "destination": "Mercury", "missions:" 0, "funding": 0, "cumFunding": 0, "cumMissions": 0    },
        { "destination": "Outer Planets", "missions:" 0, "funding": 0, "cumFunding": 0, "cumMissions": 0    },
        { "destination": "Small Bodies", "missions:" 0, "funding": 0, "cumFunding": 0, "cumMissions": 0    },
      ]
    },
    "year": "1961",
    {
      "children": [
      { "destination": "Moon", "missions:" 2, "funding": 664.113  },
      { "destination": "Mars", "missions:" 0, "funding": 0 },
      { "destination": "Venus", "missions:" 0, "funding": 0 },
      { "destination": "Mercury", "missions:" 0, "funding": 0  },
      { "destination": "Outer Planets", "missions:" 0, "funding": 0  },
      { "destination": "Small Bodies", "missions:" 0, "funding": 0  },
    ]
}
}
  • 7. Iterate: Note at least one new task you’d conduct now that you’ve had a chance to investigate your dataset. Describe how you would change your solution to accommodate that task. 
    • It would be interesting to explore “How” or “Why” task as related to decadal goals. One way to explore the decadal goals would be to do some extended research (they are not part of the original dataset) to determine what goals were laid out by the planetary science community

 

Analysis: Once you’ve completed your core phase, you can reflect on designing your tool. We’ll skip the write phase since you’re already doing it in creating your write-up!

  • 8. Reflect, Pt 1: Describe what your solution tells you about your target problem. Note that you will do this with your domain expert hat on.
    • The target problem is determining if Mars has always been the true standout and goal of the US planetary science program. While exploring the dataset (over each year), it’s clear that once Apollo 11 visited the Moon for the first time in 1969, funding for the Moon stagnated for a time. Mars became the new destination for planetary exploration. For a time, research into Venus was a steady commodity but I suspect that once it was found that Venus’ atmosphere was a hot, dry runaway greenhouse instead of a oceanic, jungle planet interest in the planet waned. It will be interesting to see if the new theories about possible life in the atmosphere of Venus will boost funding in that direction. 
  • 9. Reflect, Pt2: Describe what your solution tells you about designing visualizations for your target problem. Note that you will do this with your designer hat on.
    • From a design standpoint, overall, exploring this dataset over time is a key feature. both visualizations can be tied together; one showing number and kind of missions, the other showing funding. Drilling into the destinations seems to give some insight into how important one planet is over another. I think it might be interesting to create  a visualization that broke out orbiters and landers. Mainly this would allow stakeholders to see a cost differentiation between the two. I hypothesize that landers are more expensive because of the added technical challenges and hardware.