NCCN Landbird Monitoring Data Package, 2005-2023
Department of the Interior
@usgov.doi_gov_nccn_landbird_monitoring_data_package_2005_2023
Department of the Interior
@usgov.doi_gov_nccn_landbird_monitoring_data_package_2005_2023
CREATE TABLE nccn_landbird_habitat (
"park_code" VARCHAR,
"site_code" VARCHAR,
"location_code" VARCHAR,
"survey_date" TIMESTAMP,
"habitat_num" BIGINT,
"veg_type_code" VARCHAR,
"veg_type_desc" VARCHAR,
"is_forested" BOOLEAN,
"detection_class" VARCHAR,
"canopy_cover_pct" VARCHAR,
"canopy_cover_desc" VARCHAR,
"tree_size_class_cm" VARCHAR,
"tree_size_class_desc" VARCHAR
);
CREATE TABLE nccn_landbird_locations (
"park_code" VARCHAR,
"site_code" VARCHAR,
"location_code" VARCHAR,
"panel_type" VARCHAR,
"panel_name" DOUBLE,
"location_type" VARCHAR,
"location_status" VARCHAR,
"trail_or_road" VARCHAR,
"utm_east" BIGINT,
"utm_north" BIGINT,
"utm_zone" VARCHAR,
"utm_datum" VARCHAR,
"decimal_longitude" DOUBLE,
"decimal_latitude" DOUBLE,
"decimal_degrees_datum" VARCHAR,
"elevation_m" DOUBLE,
"slope_deg" DOUBLE,
"aspect_deg" DOUBLE,
"slope_deg_90mavg" DOUBLE,
"beers_90mavg" DOUBLE,
"established_date" TIMESTAMP,
"discontinued_date" TIMESTAMP
);
CREATE TABLE nccn_landbird_pointcounts (
"park_code" VARCHAR,
"site_code" VARCHAR,
"location_code" VARCHAR,
"survey_date" TIMESTAMP,
"survey_time" VARCHAR,
"time_zone" VARCHAR,
"noise_level" DOUBLE,
"noise_level_desc" VARCHAR,
"wind_cond" DOUBLE,
"wind_cond_desc" VARCHAR,
"precip_cond" DOUBLE,
"precip_cond_desc" VARCHAR,
"cloud_cover_pct" DOUBLE,
"species_code" VARCHAR,
"scientific_name" VARCHAR,
"common_name" VARCHAR,
"obs_distance_m" DOUBLE,
"seen_first" VARCHAR,
"int_0_3" VARCHAR,
"int_3_5" VARCHAR,
"int_5_7" VARCHAR,
"nearest_obs" VARCHAR,
"flyover" VARCHAR,
"group_size" BIGINT,
"observer" VARCHAR
);
Anyone who has the link will be able to view this.