Baselight
Sign In

Klamath Network Landbird Banding Data Package 2008-2024

Department of the Interior

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024

Loading...
Loading...

About this Dataset

Klamath Network Landbird Banding Data Package 2008-2024

This dataset contains monitoring data for land bird banding at park units within the Klamath Inventory and Monitoring Network (KLMN). Landbirds were selected as a focus group for bird monitoring in the KLMN because they provide cost-effective information about ecological conditions of interest and they are well represented in the major terrestrial habitats in the parks. This dataset will provide park managers with data and information that can be utilized to help better address landbird status and trends. Starting in 2008, two types of monitoring data have been collected 1) point counts, and 2) banding. Point counts occur in all KLMN parks with 2 parks sampled per year. Banding is done at ORCA and occurs every year. Data are also collected on habitat. Klamath Inventory and Monitoring Networks 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.
Organization: Department of the Interior
Last updated: 2025-05-23T06:19:55.501030
Tags: banding, ecological-data, ecological-monitoring, landbirds, long-term-monitoring, mist-net, national-parks, species-checklist, vegetation

Tables

PointCts

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.pointcts
  • 18.64 KB
  • 297 rows
  • 20 columns
Loading... 

CREATE TABLE pointcts (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "noise" VARCHAR,
  "time" VARCHAR,
  "distance_to_bird_m" DOUBLE,
  "current_sp_code" VARCHAR,
  "current_sci_name" VARCHAR,
  "common_name" VARCHAR,
  "detection_type" VARCHAR,
  "detection_habitat" VARCHAR,
  "previous_detection" VARCHAR,
  "number_detected" DOUBLE,
  "breeding" VARCHAR,
  "pointcount_notes" VARCHAR,
  "starttime_24hr" VARCHAR,
  "endtime_24hr" VARCHAR,
  "protectedstatus" VARCHAR
);

VegComp

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.vegcomp
  • 25.1 KB
  • 855 rows
  • 23 columns
Loading... 

CREATE TABLE vegcomp (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "current_sci_name" VARCHAR,
  "common_name" VARCHAR,
  "percent_cover_1st_tree_layer" VARCHAR,
  "percent_cover_2nd_tree_layer" VARCHAR,
  "percent_cover_3rd_tree_layer" BIGINT,
  "percent_cover_4th_tree_layer" BIGINT,
  "percent_cover_5th_tree_layer" BIGINT,
  "percent_cover_6th_tree_layer" BIGINT,
  "percent_cover_1st_shrub_layer" VARCHAR,
  "percent_cover_2nd_shrub_layer" VARCHAR,
  "percent_cover_3rd_shrub_layer" BIGINT,
  "percent_cover_4th_shrub_layer" BIGINT,
  "percent_cover_5th_shrub_layer" BIGINT,
  "percent_cover_6th_shrub_layer" BIGINT,
  "percent_cover_1st_herb_layer" VARCHAR,
  "percent_cover_2nd_herb_layer" BIGINT,
  "percent_cover_1st_moss_layer" VARCHAR,
  "percent_cover_2nd_moss_layer" BIGINT
);

AreaSearch

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.areasearch
  • 51.66 KB
  • 4731 rows
  • 16 columns
Loading... 

CREATE TABLE areasearch (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "start_time" BIGINT,
  "duration_minutes" BIGINT,
  "current_sp_code" VARCHAR,
  "current_sci_name" VARCHAR,
  "common_name" VARCHAR,
  "detection_type" VARCHAR,
  "totalnumberofbirds" BIGINT,
  "search_area" VARCHAR,
  "breeding" VARCHAR,
  "notes" VARCHAR,
  "protectedstatus" VARCHAR
);

Bands

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.bands
  • 211.53 KB
  • 4731 rows
  • 68 columns
Loading... 

CREATE TABLE bands (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "bandsize" VARCHAR,
  "bandcode" VARCHAR,
  "band_number" BIGINT,
  "current_sp_code" VARCHAR,
  "current_sci_name" VARCHAR,
  "common_name" VARCHAR,
  "age" VARCHAR,
  "howspecieswasaged1" VARCHAR,
  "howspecieswasaged2" VARCHAR,
  "sex" VARCHAR,
  "howsexwasdetermined1" VARCHAR,
  "howsexwasdetermined2" VARCHAR,
  "skull" VARCHAR,
  "cloacal_protuberance" VARCHAR,
  "brood_patch" VARCHAR,
  "fat_category" VARCHAR,
  "bodymolt" VARCHAR,
  "flightfeather_molt" VARCHAR,
  "flightfeather_wear" VARCHAR,
  "juvenile_plumage" VARCHAR,
  "molt_limit1" VARCHAR,
  "molt_limit2" VARCHAR,
  "wingchord_mm" BIGINT,
  "weight_g" DOUBLE,
  "status" VARCHAR,
  "capture_time" BIGINT,
  "oldband" DOUBLE,
  "upper_part_color" VARCHAR,
  "under_part_color" VARCHAR,
  "throat_color" VARCHAR,
  "chin_color" VARCHAR,
  "leg_color1" VARCHAR,
  "leg_color2" VARCHAR,
  "eye_ring_shape1" VARCHAR,
  "eye_ring_shape2" VARCHAR,
  "eye_ring_color1" VARCHAR,
  "eye_ring_color2" VARCHAR,
  "basemandiblecolor" VARCHAR,
  "tipmandiblecolor" VARCHAR,
  "culmenlength_mm" DOUBLE,
  "billwidth_mm" DOUBLE,
  "longest_primary_secondary_mm" DOUBLE,
  "longest_primary_mm" DOUBLE,
  "p6_p10_length_mm" DOUBLE,
  "p9_p5_length_mm" DOUBLE,
  "p10_p5_length_mm" VARCHAR,
  "p10_p4_length_mm" DOUBLE,
  "prim6_feather_emarginated" VARCHAR,
  "taillength_mm" DOUBLE,
  "wingtailinteger_mm" DOUBLE,
  "r6_r1_length_mm" DOUBLE,
  "rectrices_outerweb" DOUBLE,
  "clipped_rectrices_feather" VARCHAR,
  "billlength_w_grooves_percent" DOUBLE,
  "inside_r2_feather_emarginated" VARCHAR,
  "outside_r2_feather_emarginated" VARCHAR,
  "r5_feather_width_mm" DOUBLE,
  "notes" VARCHAR,
  "protectedstatus" VARCHAR,
  "adjunctposition_wrp" VARCHAR,
  "n_1_position_wrp_code" VARCHAR,
  "n_2_position_wrp_code" VARCHAR,
  "n_3_position_wrp_code" VARCHAR
);

PointCtWeather

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.pointctweather
  • 8.39 KB
  • 28 rows
  • 11 columns
Loading... 

CREATE TABLE pointctweather (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "temperature_degrees_c" BIGINT,
  "cloudcover_percent" BIGINT,
  "precipitation" VARCHAR,
  "wind" VARCHAR,
  "noise" VARCHAR,
  "weathertime" VARCHAR
);

AreaWeather

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.areaweather
  • 12.26 KB
  • 1163 rows
  • 9 columns
Loading... 

CREATE TABLE areaweather (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "temperature_degrees_c" BIGINT,
  "cloudcover_percent" BIGINT,
  "precipitation" VARCHAR,
  "wind" VARCHAR
);

Sites Locations

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.sites_locations
  • 8.16 KB
  • 22 rows
  • 11 columns
Loading... 

CREATE TABLE sites_locations (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "survey_type" VARCHAR,
  "utm_easting" DOUBLE,
  "utm_northing" DOUBLE,
  "coord_units" VARCHAR,
  "coord_system" VARCHAR,
  "utm_zone" VARCHAR,
  "datum" VARCHAR,
  "location_notes" VARCHAR
);

Table 8

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.table_8
  • 47.39 KB
  • 84 rows
  • 64 columns
Loading... 

CREATE TABLE table_8 (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_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" BIGINT,
  "num_of_snags_15to27_9cm_dbh" BIGINT,
  "num_of_snags_28to63_9cm_dbh" BIGINT,
  "num_of_snags_64to101_9cm_dbh" BIGINT,
  "num_of_snags_gt102cm_dbh" BIGINT,
  "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" VARCHAR,
  "burntime1" VARCHAR,
  "burntype2" VARCHAR,
  "burn_area2_percent" VARCHAR,
  "burntime2" VARCHAR,
  "burntype3" VARCHAR,
  "burn_area3_percent" VARCHAR,
  "burntime3" VARCHAR,
  "disturb" VARCHAR,
  "disttype1" VARCHAR,
  "dist_area1_percent" VARCHAR,
  "disttime1" VARCHAR,
  "disttype2" VARCHAR,
  "dist_area2_percent" VARCHAR,
  "disttime2" VARCHAR,
  "disttype3" VARCHAR,
  "dist_area3_percent" VARCHAR,
  "disttime3" VARCHAR,
  "disttype4" VARCHAR,
  "dist_area4_percent" VARCHAR,
  "disttime4" VARCHAR,
  "disttype5" VARCHAR,
  "dist_area5_percent" VARCHAR,
  "disttime5" VARCHAR
);

Nets

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.nets
  • 61.9 KB
  • 2360 rows
  • 39 columns
Loading... 

CREATE TABLE nets (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "net_locations" VARCHAR,
  "hour_opened" DOUBLE,
  "minute_opened" DOUBLE,
  "hour_closed" DOUBLE,
  "minute_closed" DOUBLE,
  "numberofhours_netopened" DOUBLE,
  "totalnumberofhours_netsopened" DOUBLE,
  "numberbirdsrecaptured" DOUBLE,
  "numberbirdsnewcaptures" DOUBLE,
  "numberbirdsunbanded" DOUBLE,
  "totalnumberofbirdscaptured" DOUBLE,
  "totalnumberofspecies" DOUBLE,
  "totalofareasearchesdone" DOUBLE,
  "timenetopened" DOUBLE,
  "timenetclosed" DOUBLE,
  "cloudcover_timeopened" DOUBLE,
  "precip_atnetopentime" VARCHAR,
  "temperature_atnetopentime" DOUBLE,
  "wind_atnetopentime" VARCHAR,
  "cloudcover_midsample" DOUBLE,
  "precip_atmidsample" VARCHAR,
  "temperature_atmidsample" DOUBLE,
  "wind_atmidsample" VARCHAR,
  "cloudcover_timeclosed" DOUBLE,
  "precip_atnetclosetime" VARCHAR,
  "temperature_atnetclosetime" DOUBLE,
  "wind_atnetclosetime" VARCHAR,
  "numberofstressedbirds" DOUBLE,
  "numberofinjuredbirds" DOUBLE,
  "numberofbirdmortalities" DOUBLE,
  "net_effort_notes" VARCHAR,
  "n_10_day" DOUBLE,
  "week" DOUBLE,
  "number_of_nets" DOUBLE
);

SpeciesChecklist

@usgov.doi_gov_klamath_network_landbird_banding_data_package_2008_2024.specieschecklist
  • 45.43 KB
  • 4222 rows
  • 13 columns
Loading... 

CREATE TABLE specieschecklist (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "start_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "breeding" VARCHAR,
  "tally" DOUBLE,
  "sp_checklist_notes" VARCHAR,
  "protectedstatus" VARCHAR,
  "current_sp_code" VARCHAR,
  "current_sci_name" VARCHAR,
  "common_name" VARCHAR
);

Share link

Anyone who has the link will be able to view this.