Sierra Nevada Landbirds Fire Analysis Monitoring Data Package, 1999-2019
Department of the Interior
@usgov.doi_gov_sierra_nevada_landbirds_fire_analysis_monitori_efaed129
Department of the Interior
@usgov.doi_gov_sierra_nevada_landbirds_fire_analysis_monitori_efaed129
CREATE TABLE sien_landbirdsfireanalysis_covariates (
"dataset" VARCHAR,
"park_code" VARCHAR,
"event_year" BIGINT,
"transect" VARCHAR,
"station" VARCHAR,
"utme_nad83z11" BIGINT,
"utmn" BIGINT,
"dem_mu" DOUBLE,
"mfri_mu" DOUBLE,
"rdnbr1984_mu" BIGINT,
"rdnbr1985_mu" BIGINT,
"rdnbr1986_mu" BIGINT,
"rdnbr1987_mu" BIGINT,
"rdnbr1988_mu" BIGINT,
"rdnbr1989_mu" BIGINT,
"rdnbr1990_mu" BIGINT,
"rdnbr1991_mu" BIGINT,
"rdnbr1992_mu" BIGINT,
"rdnbr1993_mu" BIGINT,
"rdnbr1994_mu" BIGINT,
"rdnbr1995_mu" BIGINT,
"rdnbr1996_mu" BIGINT,
"rdnbr1997_mu" BIGINT,
"rdnbr1998_mu" BIGINT,
"rdnbr1999_mu" BIGINT,
"rdnbr2000_mu" BIGINT,
"rdnbr2001_mu" BIGINT,
"rdnbr2002_mu" BIGINT,
"rdnbr2003_mu" BIGINT,
"rdnbr2004_mu" BIGINT,
"rdnbr2005_mu" BIGINT,
"rdnbr2006_mu" BIGINT,
"rdnbr2007_mu" BIGINT,
"rdnbr2008_mu" BIGINT,
"rdnbr2009_mu" BIGINT,
"rdnbr2010_mu" BIGINT,
"rdnbr2011_mu" BIGINT,
"rdnbr2012_mu" BIGINT,
"rdnbr2013_mu" BIGINT,
"rdnbr2014_mu" BIGINT,
"rdnbr2015_mu" BIGINT,
"rdnbr2016_mu" BIGINT,
"rdnbr2017_mu" BIGINT,
"rdnbr2018_mu" BIGINT,
"treecc1999_mu" BIGINT,
"treecc2000_mu" BIGINT,
"treecc2001_mu" BIGINT,
"treecc2002_mu" BIGINT,
"treecc2003_mu" BIGINT,
"treecc2004_mu" BIGINT,
"treecc2005_mu" BIGINT,
"treecc2006_mu" BIGINT,
"treecc2007_mu" BIGINT,
"treecc2008_mu" BIGINT,
"treecc2009_mu" BIGINT,
"treecc2010_mu" BIGINT,
"treecc2011_mu" BIGINT,
"treecc2012_mu" BIGINT,
"treecc2013_mu" BIGINT,
"treecc2014_mu" BIGINT,
"treecc2015_mu" BIGINT,
"treecc2016_mu" BIGINT,
"treecc2017_mu" BIGINT,
"treecc2018_mu" BIGINT,
"treecc2019_mu" BIGINT,
"treesh1999_mu" BIGINT,
"treesh2000_mu" BIGINT,
"treesh2001_mu" BIGINT,
"treesh2002_mu" BIGINT,
"treesh2003_mu" BIGINT,
"treesh2004_mu" BIGINT,
"treesh2005_mu" BIGINT,
"treesh2006_mu" BIGINT,
"treesh2007_mu" BIGINT,
"treesh2008_mu" BIGINT,
"treesh2009_mu" BIGINT,
"treesh2010_mu" BIGINT,
"treesh2011_mu" BIGINT,
"treesh2012_mu" BIGINT,
"treesh2013_mu" BIGINT,
"treesh2014_mu" BIGINT,
"treesh2015_mu" BIGINT,
"treesh2016_mu" BIGINT,
"treesh2017_mu" BIGINT,
"treesh2018_mu" BIGINT,
"treesh2019_mu" BIGINT,
"ysf1984" DOUBLE,
"ysf1985" DOUBLE,
"ysf1986" DOUBLE,
"ysf1987" DOUBLE,
"ysf1988" DOUBLE,
"ysf1989" DOUBLE,
"ysf1990" DOUBLE,
"ysf1991" DOUBLE,
"ysf1992" DOUBLE,
"ysf1993" DOUBLE,
"ysf1994" DOUBLE,
"ysf1995" DOUBLE,
"ysf1996" DOUBLE,
"ysf1997" DOUBLE
);
CREATE TABLE sien_landbirdsfireanalysis_pointcounts (
"dataset" VARCHAR,
"park_code" VARCHAR,
"date_str" TIMESTAMP,
"event_year" BIGINT,
"month" BIGINT,
"doy" BIGINT,
"station" VARCHAR,
"transect" VARCHAR,
"species" VARCHAR,
"scientific_name" VARCHAR,
"common_name" VARCHAR,
"group_size" DOUBLE,
"distance_m" DOUBLE,
"y1" DOUBLE,
"y2" DOUBLE,
"y3" DOUBLE,
"minute" DOUBLE,
"noise_level" DOUBLE,
"observer" VARCHAR
);
Anyone who has the link will be able to view this.