4. Maps

4.1. Start with basic map of every facility’s location

First, move the latitude and longitude measures (the ones that’re part of the dataset, NOT the generated fields) up to dimensions. These columns are really geographic ID variables, so they’re dimensions. Create a new worksheet.

Then, put the latitude and longitude dimensions onto the Rows and Columns shelves. We'll also need to add Facility Name to Marks -> Detail for the facilities to show up.

We'll want to exclude those null values, as well.

4.2. Add color to distinguish between industry groups

Then, let’s drag the industry groups dimension to Mark Color, so that we can determine the facility type:

4.3. Add size to indicate total GHG emissions

Finally, drag the “reported CO2e emissions” measure to Mark Size. That’s a pretty cool graph. Can you describe what each point is? [placement = individual facility in database. Color = industry type. Mark size = amount of emissions]

This is a cool map, but what if we only want to view one industry type, or one state, or only facilities above X number of GHG emissions? We’d need to filter the data. Let’s start playing with the Filters shelf.

1.1. Add some filters, so we can look at only one industry, only one region, only one state. [7 minutes]

We’ll get this popup box, asking for our initial filter. Let’s go ahead and include everything, so the map won’t change at first.

First, let’s drag our Regions dimension to the Filters shelf:

This gives us a box on the right of the map that allows us to dynamically filter data.

Nothing has changed quite yet, we have one more step.

Now click on regions in the Filters shelf, and select “Show Filter”

We can also click on the drop-down arrow on that header to change how the filter is displayed. Let's change it to a dropdown menu (multiple selection):

Using the same procedure, add filters for “State” and “Industry Group”, and edit the State filter to “only show relevant values”. That means that, say only the Northwest region is chosen. Then, only states within that region will show up as options within the “state” filter.

We’ve finally got a good map to play with. And we can do things like look at the Power plant industry type, in the Southeast, in only Florida and South Carolina:

Next, we can start looking into power plants more closely.

SUBPAGES (10): 1. INTRODUCTION 2. CREATING 2-D GRAPHS 3. 3-D GRAPHS AND MORE! 4. MAPS 5. MERGE IN EIA POWER PLANT DATA 6. DOES THE AMOUNT OF ELECTRICITY GENERATED INFLUENCE GHG EMISSIONS? 7. CALCULATED FIELDS 7. CALCULATED FIELDS 8. TRI DATASET & TABLE CALCULATIONS 9. DASHBOARDS

Page updated

Report abuse