sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 5022 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
17753 Emissions - Land Use: Burning - Biomass 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "Greenhouse Gas (GHG) emissions from burning of biomass consist of methane and nitrous oxide gases from biomass combustion of forest land cover classes \u2018Humid and Tropical Forest\u2019 and \u2018Other Forests\u2019, and of methane, nitrous oxide, and carbon dioxide gases from combustion of organic soils.   Annual burned area for each Item disseminated (\u201cHumid Tropical Forest\u201d; \u201cOther forest\u201d; and \u201cOrganic soils\u201d) is derived from the new NASA Moderate Resolution Imaging Spectroradiometer (MODIS) MCD64A1 Collection 6 (Giglio et al., 2018). The MCD64A1 Version 6 Burned Area data product is a monthly, global gridded 500m product containing per-pixel burned-area and quality information. Fire data are encoded in a single data layer as the ordinal day of the calendar year on which the burn occurred, with values assigned to unburned land pixels and additional special values reserved for missing data and water grid cells.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "FAOSTAT Emissions data are computed based on a number of source data, including:   - Burned areas from MODIS MCD64A1 Collection 6 (Giglio et al., 2018);    - Fuel biomass consumption values from IPCC, 2006: Vol.4, Ch. 2, Tab. 2.4.(http://www.ipcc-nggip.iges.or.jp/public/2006gl/pdf/4_Volume4/V4_02_Ch2_Generic.pdf); and from   - IPCC. 2013. Supplement to the 2006 IPCC Guidelines for National Greenhouse Gas Inventories: Wetlands. Hiraishi T., Krug T., Tanabe K., Srivastava N., Baasansuren J., Fukuda M., Troxler TG (Eds). IPCC/TFI. Available at: http://www.ipcc-nggip.iges.or.jp/public/wetlands/;  - Emission factors for vegetation from IPCC, 2006: Vol.4, Ch. 2, Tab. 2.5.(http://www.ipcc-nggip.iges.or.jp/public/2006gl/pdf/4_Volume4/V4_02_Ch2_Generic.pdf);  - Peatland emission factors from van der Werf et al. 2010, tab. 5 (http://www.atmos-chem-phys.net/10/11707/2010/acp-10-11707-2010.html);  - Climatic zoning from FAO. 2012. Global ecological zones for FAO forest reporting: 2010 Update. Forest Resources Assessment Working Paper 179. FAO, Rome, Italy. http://www.fao.org/docrep/017/ap861e/ap861e00.pdf used to assign biomass consumption values for forest types; and from  - IPCC Climatic Zones, Joint Research Centre of the European Commission: https://esdac.jrc.ec.europa.eu/projects/renewable-energy-directive used to assign biomass consumption values for organic soils;  - Map of histosols from the Harmonized World Soil Database (FAO et al., 2012) (http://webarchive.iiasa.ac.at/Research/LUC/External-World-soil-database/HTML/)."
}
 2020-02-14 02:25:55 2020-02-14 02:25:55 Emissions - Land Use: Burning - Biomass 5022 Greenhouse Gas (GHG) emissions from burning of biomass consist of methane and nitrous oxide gases from biomass combustion of forest land cover classes ‘Humid and Tropical Forest’ and ‘Other Forests’, and of methane, nitrous oxide, and carbon dioxide gases from combustion of organic soils. Annual burned area for each Item disseminated (“Humid Tropical Forest”; “Other forest”; and “Organic soils”) is derived from the new NASA Moderate Resolution Imaging Spectroradiometer (MODIS) MCD64A1 Collection 6 (Giglio et al., 2018). The MCD64A1 Version 6 Burned Area data product is a monthly, global gridded 500m product containing per-pixel burned-area and quality information. Fire data are encoded in a single data layer as the ordinal day of the calendar year on which the burn occurred, with values assigned to unburned land pixels and additional special values reserved for missing data and water grid cells. http://www.fao.org/faostat/en/?#data/ Food and Agriculture Organization of the United Nations (FAO) (2020)

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");