Environmental Data in Data Library

maria_lucas

January 06, 2021 19:42

INTRODUCTION

In the Data Library, we have Environmental data for each Industry going back to 2001. This way users can quickly look at Industry changes by Environmental pollutant and Year for a region using the Dashboard or Explore.

OVERVIEW

IMPLAN’s environmental data consist of ratios representing physical emissions or inputs per dollar of Industry Output, with the physical unit depending on the particular pollutant or input under consideration. IMPLAN’s environmental coefficients or ratios, came from the EPA’s Environmentally-Extended Input-Output model (EEIO) data (version 1.1). While the ratios are Industry-specific, the EPA data have somewhat less Industry-specificity than the IMPLAN data, such that some EPA ratios are mapped to more than one IMPLAN Industry; in other words, some IMPLAN Industries have the same environmental ratios. These ratios can be applied to the IMPLAN modeling system in order to gain insight into the environmental impacts associated with economic impact scenarios.

The coefficients do not double count in that they do not include the emissions associated with the upstream industries/suppliers. For example, the emissions associated with the automobile manufacturing Industry do not include emissions associated with the production of car parts or other inputs produced by other Industries; the emissions associated with producing those inputs would be accounted for in the coefficients for those suppliers’ respective Industries. Basically, the emissions associated with the tire production or the manufacturing of headlights are not included.

Any emissions generated directly by households - for example, emissions generated by households’ burning of wood in a wood-fired stove in the home - are not included in the EPA dataset. Therefore, they are not accounted for in the IMPLAN emissions data set. What this means is that all induced emissions in IMPLAN stem from household purchases of energy and of goods and services, all of which require energy to produce and thus create emissions. Any additional emissions generated directly by the household, those not associated with a purchase of energy, goods, or services, will not be accounted for.

Below is the list of the eight major groups of environmental data, termed satellite accounts. Each satellite account has a number of more-detailed “tags” that represent more specific types within the broader group. Also listed are the numbers of tags in each group and a few examples of each. Please note that the tag counts for water use and land use are misleading, as those two categories include the sector name in the tag, so the true count of tags in those categories is lower than stated here. The data is also slightly unclear regarding water. It appears as its own satellite account, Water Use, and a category, water. In the data for water, users will see two categories: resource and water. When the category is a "resource" this represents water usage. When it is "water" it represents releases of water back to a water source like a lake. To get the net water usage, users will need to subtract one from the other.

The satellite accounts are:

Criteria Pollutants
- 268 tags
- Examples: Nitrogen Oxides, Chromium III, Cellosolve Solvent
Greenhouse Gas Emissions
- 15 tags
- Examples: CO2, N2O, CH4, CF4
Land Use
- 260 tags
- Examples: Urban Land, Urban Transportation, Rural Transportation, Coal Exploration Licenses
Mineral Use
- 48 tags
- Examples: Boron, Gypsum, Salt
Nitrogen and Phosphorus Release to Water
- 2 tags
- Includes: N and P
Pesticide Emissions
- 1,002 tags
- Examples: Spirodiclofen/air, Norflurazon/water, Fluxapyroxad/groundwater
Toxic Chemical Releases
- 413 tags
- Examples: 1,2-Dichloropropane, 1,2-Phenylenediamine, 1,3-Butadiene
Water Use
- 281 tags
- Examples: Alpacas; On-farm surface source, Alpacas; surface water, Aquaculture; groundwater

Industries will be missing a Value per dollar of Industry Output where the EPA value is zero or indistinguishable from zero in a given satellite.

DASHBOARD

This Dashboard includes three tiles:

Year over Year is a line chart showing the Environmental Unit Values of the filtered Satellite Account over Data Years for the filter Region(s).
County View is a map chart of Environment Unit Values of the filtered Satellite Account by Five Digit Fips (this is the county code Looker uses to map the data).
Environmental is a table chart of the Environmental Unit Values of the filtered Satellite Account and the total Output by Industry for the filtered Region(s).

When viewing a Dashboard, use the filters to change the data points displayed. Filter options include:

Data Year: most recent Data Year by default in County View and Commodity Table tiles. All available Data Years are displayed in the Year over Year tile (filter does not apply to this tile).
- Note, Environmental Unit Value data is produced by applying the environmental units per Output ratios to each Data Year of Industry Output data.
State: by default Georgia, North Carolina, and South Carolina
County: no county filter is set by default
Aggregation: Aggregation level of Industries by default is the unaggregated 546 scheme
Industry; no industry filter is set by default
Satellite Account: by default Greenhouse Gasses (GHG)
Category: no category filter is set by default
Tag: no tag filter is set by default

The Dashboard actions in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Tile actions (a series of three vertical dots that appears in the upper right of a tile when hovering over it with a cursor) for the option to download the data within that tile. Select Explore from here within the Tile actions to access more data query options. Exploring from the Dashboard allows users to dig into the data starting from the settings within the Dashboard tile.

EXPLORE

Explore the Environmental Data by selecting Environmental from the Explore dropdown menu, or by selecting Explore from here from an Environmental Data Dashboard Tile or Look.

By default in Explore, a filter is set for the most recent Data Year. It is recommended to always either filter or pivot on Data Year. Otherwise, data measures will be summed over Data Years. The default Aggregation Scheme Param is 546 Unaggregated. Industry Dimensions will be available in the 546 Industry scheme with this setting.

FILTER-ONLY FIELDS

AGGREGATION SCHEME PARAM

The aggregation filter provides the option to view data by Industry at one of the following levels of granularity:

546 Unaggregated: most granular. Data is available for each IMPLAN Industry according to the most recent 546 Industry Scheme.
IMPLAN 2 Digit NAICS 546: Data is aggregated for Industries corresponding to each 2 Digit NAICS.
IMPLAN 3 Digit NAICS 546: Data is aggregated for Industries corresponding to each 3 Digit NAICS.

Download the 2022 aggregated NAICS to IMPLAN 546 Industries bridge for details.

DIMENSIONS

Select a Dimension to include as a column with all Dimension possibilities.

Click Filter on a Dimension to specify which Dimension possibilities appear in the data query.

Click Pivot on a Dimension to transpose the Dimension rows into columns.

Dimensions	Details
County	All U.S. counties are possible Dimensions. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.
Data Year	All IMPLAN Data Years are possible Dimensions.
Environment Category	The following are possible Dimensions: Air Resource Soil Water
Environment Name	All detailed Environment Names are possible Dimensions. (Offers more detailed breakdown of Environment Satellites)
Environment Satellite	The following are possible Dimensions: Criteria Pollutants Greenhouse Gas Emissions Land Use Mineral Use Nitrogen and Phosphorus Release to Water Pesticide Emissions Toxic Chemical Releases Water Use
Environment Tag	All Environment Tags are possible Dimensions. (Offers more detailed breakdown of Environment Satellites)
Environment Unit	The following are possible Dimensions: Kg m2a m3 All unit values are measures of mass in kilograms (kg) except for Land Use unit values and Water Use unit values. Land Use measures area in square meters per year (m2a), and Water Use measures volume in cubic meters (m3).
Five Digit Fips	A Five Digit Fips is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit Fips codes are possible Dimensions. This Dimension is used to map the data in the County View Map Chart found on the Dashboard. A list of FIPS codes can be found at the following link: https://www.census.gov/library/reference/code-lists/ansi.html#top
Industry	All 546 IMPLAN Industries are possible Dimensions. This Dimension lists Industries as the Industry Code (number) hyphen Industry Description (name).
Industry Code	All 546 IMPLAN Industry Codes (numbers) are possible Dimensions.
Industry Description	All 546 IMPLAN Industry Descriptions (names) are possible Dimensions.
Region	All 50 States plus the District of Columbia are possible Dimensions. Pivoting or selecting Region will display filtered states when filtering on state and will display filtered counties when filtering on county.
State	All 50 States plus the District of Columbia are possible Dimensions.

MEASURES

Measures are displayed based on Dimension settings. Select a Measure to include as a column in the data query.

Measures	Details
Nominal Output	Total Industry Output in nominal, unadjusted dollars (Dollar Year = Data Year)
Unit Value	Environment Unit Value (i.e. 1,000,000 kg of Greenhouse Gases)
Value per $ Output	Ratio of physical environment unit value per dollar of Output Output times Value per Output produces the Unit Value Measure (Some industries will be missing a Value per $ Output in each satellite)