Great Lakes Landbird Monitoring Data Package By The Great Lakes Inventory And Monitoring Network
Department of the Interior
@usgov.doi_gov_great_lakes_landbird_monitoring_package_by_the_fb5c550d
Department of the Interior
@usgov.doi_gov_great_lakes_landbird_monitoring_package_by_the_fb5c550d
CREATE TABLE glkn_landbirds_2014_2023 (
"protocol" VARCHAR,
"eventyear" BIGINT,
"parkcode" VARCHAR,
"transect" VARCHAR,
"pointlocation" VARCHAR,
"date" TIMESTAMP,
"time" VARCHAR,
"windcode" VARCHAR,
"winddesc" VARCHAR,
"airtemperaturerecorded" BOOLEAN,
"airtemperature" VARCHAR,
"temperatureunitcode" VARCHAR,
"skycode" VARCHAR,
"skydesc" VARCHAR,
"backgroundnoisecode" VARCHAR,
"backgroundnoisedesc" VARCHAR,
"observercode" VARCHAR,
"timebincode" VARCHAR,
"timebindesc" VARCHAR,
"speciescode" VARCHAR,
"scientificname" VARCHAR,
"commonname" VARCHAR,
"spprefcode" VARCHAR,
"istargetspp" BOOLEAN,
"protectedstatus" VARCHAR,
"protectedstatuscomment" VARCHAR,
"numberindividuals" BIGINT,
"detectioncode" VARCHAR,
"detectiontype" VARCHAR,
"distancecode" VARCHAR,
"distancedesc" VARCHAR,
"detectionnotes" VARCHAR,
"surveynotes" VARCHAR,
"airtempflag" VARCHAR,
"windflag" VARCHAR,
"noiseflag" VARCHAR,
"skyflag" VARCHAR,
"timeflag" VARCHAR,
"consvpriority" VARCHAR
);
Anyone who has the link will be able to view this.