Klamath Network Landbird Point Count Monitoring Data Package by US Government | Demographics and Population Studies

About this Dataset

Klamath Network Landbird Point Count Monitoring Data Package

This dataset contains monitoring data for land bird monitoring at park units within the Klamath Inventory and Monitoring Network (KLMN). Landbirds are an effective tool for monitoring because: (1) many species are easily and inexpensively detected, (2) standardized sampling protocols had already been developed, (3) landbird species respond to a wide variety of habitat conditions, and (4) measuring status and trends for many species with different ecological requirements can inform landscape scale conservation strategies.

The KLMN landbird protocol contributes to regional and continental bird monitoring and is integrated with an extensive regional bird monitoring network. This effort has yielded a substantial regional dataset with information about landbird distribution, population trends, and population demographics.

Data are collected on species, time, distance, detection method, and breeding status in variable circular plots as well as vegetation surveys including cover and height for trees and shrubs, snag counts, and tree size.
Organization: Department of the Interior
Last updated: 2024-03-09T08:58:44.200974
Tags: ecological-data, ecological-framework-biological-integrity-focal-species-or-communities-birds, ecological-monitoring, habitat, landbirds, long-term-monitoring, national-parks, point-counts, species-checklist, variable-circular-plots

Tables

Stations

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.stations

131.44 KB
7924 rows
20 columns


CREATE TABLE stations (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "route" VARCHAR,
  "station" VARCHAR,
  "utm_easting" BIGINT,
  "utm_northing" BIGINT,
  "coord_units" VARCHAR,
  "coord_system" VARCHAR,
  "utm_zone" VARCHAR,
  "datum" VARCHAR,
  "est_horizontal_error" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lat_long_projection" VARCHAR,
  "accuracy_notes" VARCHAR,
  "station_notes" VARCHAR,
  "elevation_m" VARCHAR,
  "aspect" VARCHAR,
  "slope_degrees" VARCHAR,
  "event_notes" VARCHAR
);

StationWeather

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.stationweather

48.61 KB
8017 rows
11 columns


CREATE TABLE stationweather (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "route" VARCHAR,
  "station" VARCHAR,
  "sample_date" TIMESTAMP,
  "temperature_deg_c" DOUBLE,
  "cloudcover_percent" BIGINT,
  "precipitation" VARCHAR,
  "wind" VARCHAR,
  "noise" VARCHAR,
  "notes" VARCHAR
);

PointCounts

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.pointcounts

627.13 KB
85074 rows
21 columns


CREATE TABLE pointcounts (
  "park_name" VARCHAR,
  "unit_code" VARCHAR,
  "route" VARCHAR,
  "station" VARCHAR,
  "sample_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "noise" VARCHAR,
  "time" VARCHAR,
  "distance_to_bird_m" DOUBLE,
  "scientific_name" VARCHAR,
  "common_name" VARCHAR,
  "species_code" VARCHAR,
  "detection_type" VARCHAR,
  "detection_habitat" VARCHAR,
  "previous_detection" VARCHAR,
  "number_detected" DOUBLE,
  "breeding_status" VARCHAR,
  "pointcount_notes" VARCHAR,
  "observation_notes" VARCHAR,
  "starttime_24hr" VARCHAR,
  "endtime_24hr" VARCHAR
);

Vegetation

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.vegetation

222.51 KB
7910 rows
65 columns


CREATE TABLE vegetation (
  "park_name" VARCHAR,
  "unit_code" VARCHAR,
  "route" VARCHAR,
  "station" VARCHAR,
  "sample_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "plot_split" VARCHAR,
  "plot_radius_m" BIGINT,
  "water_presence" VARCHAR,
  "burned" VARCHAR,
  "riparian_upland_veg" VARCHAR,
  "riparian_type" VARCHAR,
  "riparian_area_size" VARCHAR,
  "sitenotes" VARCHAR,
  "vegnotes" VARCHAR,
  "num_of_snags_5to14_9cmdbh" DOUBLE,
  "num_of_snags_15to27_9cm_dbh" DOUBLE,
  "num_of_snags_28to63_9cm_dbh" DOUBLE,
  "num_of_snags_64to101_9cm_dbh" DOUBLE,
  "num_of_snags_gt102cm_dbh" DOUBLE,
  "tree_layer_total_cover_percent" VARCHAR,
  "lower_tree_layer_ht_m" BIGINT,
  "lower_tree_layer_sp" VARCHAR,
  "upper_tree_layer_ht_m" BIGINT,
  "upper_tree_layer_sp" VARCHAR,
  "smallest_tree_dbh_cm" BIGINT,
  "smallest_tree_sp" VARCHAR,
  "largest_tree_dbh_cm" BIGINT,
  "largest_tree_sp" VARCHAR,
  "tree_sublayers_number" BIGINT,
  "shrub_layer_total_cover" VARCHAR,
  "lower_shrub_layer_ht_m" DOUBLE,
  "lower_shrub_layer_sp" VARCHAR,
  "upper_shrub_layer_ht_dm" DOUBLE,
  "upper_shrub_layer_sp" VARCHAR,
  "shrub_sublayers_number" BIGINT,
  "herb_layer_total_cover" VARCHAR,
  "moss_layer_total_cover" VARCHAR,
  "ht_upper_second_tree_layer_m" DOUBLE,
  "ht_upper_second_shrub_layer_dm" DOUBLE,
  "burntype1" VARCHAR,
  "burn_area1_percent" DOUBLE,
  "burntime1" VARCHAR,
  "burntype2" VARCHAR,
  "burn_area2_percent" DOUBLE,
  "burntime2" VARCHAR,
  "burntype3" VARCHAR,
  "burn_area3_percent" VARCHAR,
  "burntime3" VARCHAR,
  "disturb" VARCHAR,
  "disttype1" VARCHAR,
  "dist_area1_percent" DOUBLE,
  "disttime1" VARCHAR,
  "disttype2" VARCHAR,
  "dist_area2_percent" DOUBLE,
  "disttime2" VARCHAR,
  "disttype3" VARCHAR,
  "dist_area3_percent" DOUBLE,
  "disttime3" VARCHAR,
  "disttype4" VARCHAR,
  "dist_area4_percent" VARCHAR,
  "disttime4" VARCHAR,
  "disttype5" VARCHAR,
  "dist_area5_percent" VARCHAR,
  "disttime5" VARCHAR
);

Photos

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.photos

18.05 KB
344 rows
11 columns


CREATE TABLE photos (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "route" VARCHAR,
  "start_date" TIMESTAMP,
  "station" VARCHAR,
  "photograph_name" VARCHAR,
  "date_photo_taken" TIMESTAMP,
  "photo_description" VARCHAR,
  "utm_easting" BIGINT,
  "utm_northing" BIGINT,
  "datum" VARCHAR
);

Routes

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.routes

7.22 KB
149 rows
6 columns


CREATE TABLE routes (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "route" VARCHAR,
  "site_desc" VARCHAR,
  "date_monumented" TIMESTAMP,
  "route_description" VARCHAR
);

SpeciesChecklist

@usgov.doi_gov_klamath_network_landbird_point_count_monitoring_package.specieschecklist

96.47 KB
19440 rows
14 columns


CREATE TABLE specieschecklist (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "route" VARCHAR,
  "sampling_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "number_of_observers" DOUBLE,
  "survey_type" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "breeding_status" VARCHAR,
  "specieschecklist_notes" VARCHAR,
  "scientific_name" VARCHAR,
  "common_name" VARCHAR,
  "species_code" VARCHAR
);