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 = 5196 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
17926 Crowther et al. (2015). Mapping tree density at scale. Nature. 
{
    "link": "https://www.nature.com/articles/nature14967",
    "retrievedDate": "13th October 2020",
    "additionalInfo": "The authors used 429,775 ground-sourced measurements of tree density from every continent on Earth except Antarctica to generate a global map of forest trees.\n\nThey define a tree as a plant with woody stems larger than 10 cm diameter at breast height (DBH).\n\nTree density (per square kilometer and per capita) were calculated by the authors based on population and land area data sourced from the World Bank for 2014.",
    "dataPublishedBy": "Crowther, T. W., Glick, H. B., Covey, K. R., Bettigole, C., Maynard, D. S., Thomas, S. M., ... & Tuanmu, M. N. (2015). Mapping tree density at a global scale. Nature, 525(7568), 201-205."
}
 2020-10-13 05:44:37 2020-10-13 05:44:37 Tree density (Crowther et al. 2015) 5196 The authors used 429,775 ground-sourced measurements of tree density from every continent on Earth except Antarctica to generate a global map of forest trees. They define a tree as a plant with woody stems larger than 10 cm diameter at breast height (DBH). Tree density (per square kilometer and per capita) were calculated by the authors based on population and land area data sourced from the World Bank for 2014. https://www.nature.com/articles/nature14967 Crowther, T. W., Glick, H. B., Covey, K. R., Bettigole, C., Maynard, D. S., Thomas, S. M., ... & Tuanmu, M. N. (2015). Mapping tree density at a global scale. Nature, 525(7568), 201-205.

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");