Excerpts from Lazarus et al. (2014)
level 1
One worksheet per country per year.
Land use type footprints (rows) - production, imports, exports & consumption (columns)
Year[i]
| Land use type | Production | Import | Export | Consumption |
|---|---|---|---|---|
| Crop (ha) | ||||
| Grazing (ha) | ||||
| Fish (ha) | ||||
| Forest (ha) | ||||
| Built-up (ha) | ||||
| Carbon (ha) |
Tables
- total ef
- per capita ef
Layout: The summary worksheet contains three tables and two charts. The first two tables contain rows corresponding to each land use type, with columns giving the Ecological Footprints of production, imports, exports and consumption, as well as biocapacity. The last row of each table sums each column and calculates Footprint and biocapacity totals. The first of these tables lists total Footprint and biocapacity for each land use type, while the second reports a country’s Footprint and biocapacity per capita.
level 2
| Land use type | Production | Import | Export | Consumption |
|---|---|---|---|---|
| Crop_a (ha) | ||||
| Crop_b (ha) | ||||
| Crop_c (ha) | ||||
| Crop_d (ha) | ||||
| Crop_e (ha) | ||||
| Crop_f (ha) | ||||
| Crop (ha) |
Tables
- Crop
- Grazing
- Fish
- Forest
- Built-up
- Carbon
The structure of each of the six ef_ worksheets is very similar. Each worksheet reports the Footprint of production, imports, exports, and consumption for the different sub-components (product categories, or more specific input types) that make up each land use type. The final row in each table sums the Footprints of all sub-components to calculate a total Footprint for that land use type. These totals are used in the summary worksheet. To the right of the aggregated table is a graphical representation of the flows of data that comprise each row, and below the table is a chart illustrating the overall resource throughput of each land type.
level 3
In general, Level 3 worksheets convert tonnes of a product into the number of global hectares necessary to provide that product. Data used by Level 3 worksheets are usually drawn from Level 4 or 5 worksheets.
Most Level 3 worksheets begin with the name of the land use type they pertain to (e.g., forest), followed by the suffixes efp (for the Ecological Footprint of production), efi (for the Ecological Footprint of imports), or efe (for the Ecological Footprint of exports). For example, fossilefp, and bunker_efp report the Footprints of production for fossil fuel carbon and bunker fuels, respectively. These two Footprints of productions are summed in the Level 2 worksheet ef_carbon to obtain the total Footprint of production for the carbon Footprint.
| Land use type | A | B | C | D |
|---|---|---|---|---|
| Crop_a_prod (t) | ||||
| Crop_b_prod (t) | ||||
| Crop_c_prod (t) | ||||
| Crop_d_prod (t) | ||||
| Crop_e_prod (t) | ||||
| Crop_f_prod (t) | ||||
| Crop_prod (t) |
Tables
- Crop_import
- Crop_export
- Crop_consumption
- Crop_production
by
- Crop
- Grazing
- Fish
- Forest
Built-up
- Fossil
Bunker
Level 3 worksheets are described in more detail in the chapters associated with their respective land use types. The type of data contained in a Level 3 worksheet can be determined by its name.
level 4
Level 4 worksheets contain intermediate calculations necessary between the raw data and the calculation of the Ecological Footprint. Many Level 4 worksheets contain yield calculations, which often involve using extraction rates to convert from derived to primary product quantities.
level 5
Level 5 Worksheets contain the raw data that all higher level worksheets use in calculations. These worksheets typically contain data on production, imports, and exports in the units of the product (i.e., tonnes for crop products or heads for animals), sometimes with additional information on the area required to produce those goods.
Project ideas in relation to national footprint accounts
Structure - subsidization
Level 2 Level 3
Structure - signal-noise
Level 2 Level 3
Efficiency - socio-ecologicl drivers
Level 2
Scribbles on using national footprint accounts
- Structure:
Compare trends in structure of consumption 1) EF w/ standard methodology (1961-2008), 2) EF w. MRIO or bilateral trade information (1961-2008) and 3) Eora (1971-2010 and 1992-2008)
Assess signal and noise in these trends by comparing across methods. E.g. by looking at shared sign membership of long-term trends and the proportion of changes between years that share sign. Mathis, please add on methodological part within footprint methods.
Assess ecological, demographic, cultural, political and economic drivers of subsidization.
Assess ecological, demographic, cultural, political and economic drivers of self-supply.
Analyze b and c with regard to mean trends and case studies of outliers from mean trends (identify first-movers and “bad-boys” from outlier case studies)
- Extraction and consumption intensities
Temporal changes in within country environmental extraction intensity and social and economic consumption intensities. The cross-comparison of trends across social, economic and environmental satellite variables is an uncharted research queston.
Noise and signal: We will assess the robustness of extraction and consumption intensities with regard to the type of footprint. Again we will compare trends across three types of methods 1) EF w/ standard methodology (1961-2008), 2) EF w. MRIO or bilateral trade information (1961-2008) and 3) Eora (1971-2010 and 1992-2008)
Environmental intensity Which countries 1) sustain high levels of extraction with low impact on the enviroment and whch countries? Satellite variables: Living planet index, red list index land use change metrics.
Social and economic intensity Which countriies are most efficient in converting changes in consumption into social improvements and economic growth, respectively? Satellite variables: Income distribution, health and GDP related metrics.
National footprint accounts data for:
- Structure: Level 2 and 3 worksheets in order to distinguish between extraction and imports (as far as I can assess from reading Lazarus et al. 2014)
- Intensities: Level 2 and 3 worksheets in order to distinguish between extraction and imports (as far as I can assess from reading Lazarus et al. 2014)
Lazarus, Elias, Golnar Zokai, Michael Borucke, Dharashree Panda, Katsunori Iha, Juan Carlos Morales, Mathis Wackernagel, Alessandro Galli, and Naina Gupta. 2014. “Working Guidebook to the National Footprint Accounts: 2014 Edition.” Oakland, California: Global Footprint Network.
References
Lazarus, Elias, Golnar Zokai, Michael Borucke, Dharashree Panda, Katsunori Iha, Juan Carlos Morales, Mathis Wackernagel, Alessandro Galli, and Naina Gupta. 2014. “Working Guidebook to the National Footprint Accounts: 2014 Edition.” Oakland, California: Global Footprint Network.