About this Dataset

Pacific Island Network Landbird Monitoring Dataset

Four Pacific Island Network parks were surveyed for landbirds and landbird habitat in order to provide information for monitoring long-term trends in forest bird distribution, density, and abundance. Hawaii Volcanoes National Park (HAVO) was surveyed in 2010, 2015/2016 and 2019/2020. Surveys were conducted in the National Park of American Samoa (NPSA) in 2011 and 2018, in Haleakala National Park (HALE) in 2012, 2017, and 2022, and in 2021, surveys began at Kalaupapa National Historical Park (KALA). The entire survey areas were surveyed using point-transect distance sampling to calculate estimates of bird abundance and densities. Canopy cover and composition was collected at the same survey area. In addition to the permanent survey transects from past landbird surveys in the survey areas, randomly generated point-transects were also surveyed, providing a split panel sampling design. This dataset contains the results of the landbird point count and habitat surveys for HAVO, NPSA, HALE, and KALA.
Organization: Department of the Interior
Last updated: 2023-08-30T17:10:45.024842
Tags: biota, birds, east-rift-zone, ecological-framework-biological-integrity-focal-species-or-communities-birds, forest-birds, hale, haleakala-national-park, havo, hawaii-volcanoes-national-park, honomalino, kahuku, kala, kalaupapa-national-historical-park, kau, kipahulu, landbirds, mauna-loa-south-flank, mauna-loa-strip, molokai, monitoring, national-park-of-american-samoa-national-park, northwest-kahuku, npsa, olaa, papa, point-counts, tau, tutuila, wildlife

Tables

Tbl Contacts

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_contacts

14.34 kB
30 rows
18 columns

CREATE TABLE tbl_contacts (
  "contact_id" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_init" VARCHAR,
  "obs_code" VARCHAR,
  "organization" VARCHAR,
  "position_title" VARCHAR,
  "address_type" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" DOUBLE,
  "country" VARCHAR,
  "email_address" VARCHAR,
  "work_phone" VARCHAR,
  "work_extension" VARCHAR,
  "contact_notes" VARCHAR
);

Tbl Detections

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_detections

1.26 MB
51,575 rows
4 columns

CREATE TABLE tbl_detections (
  "detection_id" VARCHAR,
  "observation_id" VARCHAR,
  "distance" DOUBLE,
  "detection" BIGINT
);

Tbl Event Details

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_event_details

130.25 kB
3,015 rows
16 columns

CREATE TABLE tbl_event_details (
  "event_details_id" VARCHAR,
  "event_id" VARCHAR,
  "cloud" BIGINT,
  "rain" BIGINT,
  "wind" BIGINT,
  "gust" BIGINT,
  "p1" BIGINT,
  "p2" BIGINT,
  "p3" BIGINT,
  "p4" BIGINT,
  "p5" BIGINT,
  "p6" BIGINT,
  "p7" BIGINT,
  "p8" BIGINT,
  "p9" BIGINT,
  "p10" BIGINT
);

Tbl Events

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_events

149.33 kB
3,025 rows
20 columns

CREATE TABLE tbl_events (
  "event_id" VARCHAR,
  "station_id" VARCHAR,
  "protocol_name" VARCHAR,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "repeat_sample" BIGINT,
  "habitat_date" TIMESTAMP,
  "event_notes" VARCHAR,
  "entered_by" VARCHAR,
  "entered_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "updated_date" TIMESTAMP,
  "verified" BIGINT,
  "verified_by" VARCHAR,
  "verified_date" TIMESTAMP,
  "certified" BIGINT,
  "certified_by" VARCHAR,
  "certified_date" TIMESTAMP,
  "qa_notes" VARCHAR
);

Tbl Habitat

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_habitat

117.1 kB
2,676 rows
8 columns

CREATE TABLE tbl_habitat (
  "habitat_id" VARCHAR,
  "event_id" VARCHAR,
  "canopy_cover" VARCHAR,
  "canopy_height" VARCHAR,
  "canopy_comp" VARCHAR,
  "understory_comp" VARCHAR,
  "noted_canopy_spp_common" VARCHAR,
  "noted_canopy_spp_scientific" VARCHAR
);

Tbl Locations

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_locations

4.36 kB
12 rows
4 columns

CREATE TABLE tbl_locations (
  "location_id" VARCHAR,
  "site_id" VARCHAR,
  "island" VARCHAR,
  "loc_name" VARCHAR
);

Tbl Observations

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_observations

335.64 kB
13,945 rows
3 columns

CREATE TABLE tbl_observations (
  "observation_id" VARCHAR,
  "event_id" VARCHAR,
  "species_id" VARCHAR
);

Tbl Plots

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_plots

65.79 kB
1,755 rows
11 columns

CREATE TABLE tbl_plots (
  "plot_id" VARCHAR,
  "station_id" VARCHAR,
  "slope" BIGINT,
  "slope_var" VARCHAR,
  "aspect" BIGINT,
  "aspect_var" VARCHAR,
  "topo_position" VARCHAR,
  "paved" BIGINT,
  "unpaved" BIGINT,
  "stream" BIGINT,
  "pool" BIGINT
);

Tbl Sites

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_sites

3.29 kB
4 rows
3 columns

CREATE TABLE tbl_sites (
  "site_id" VARCHAR,
  "unit_code" VARCHAR,
  "site_name" VARCHAR
);

Tbl Species Alternate Names

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_species_alternate_names

17.18 kB
313 rows
6 columns

CREATE TABLE tbl_species_alternate_names (
  "species_id" VARCHAR,
  "alternate_name" VARCHAR,
  "alternate_type" VARCHAR,
  "updated_date" TIMESTAMP,
  "update_by" VARCHAR,
  "update_notes" VARCHAR
);

Tbl Stations

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_stations

65.89 kB
1,734 rows
11 columns

CREATE TABLE tbl_stations (
  "station_id" VARCHAR,
  "transect_id" VARCHAR,
  "station" VARCHAR,
  "lat_final" DOUBLE,
  "lat_dir" VARCHAR,
  "long_final" DOUBLE,
  "long_dir" VARCHAR,
  "geo_datum" VARCHAR,
  "updated_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "updated_notes" VARCHAR
);

Tbl Transects

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tbl_transects

11.44 kB
160 rows
8 columns

CREATE TABLE tbl_transects (
  "transect_id" VARCHAR,
  "location_id" VARCHAR,
  "core_area" VARCHAR,
  "transect_type" VARCHAR,
  "transect" VARCHAR,
  "updated_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "updated_notes" VARCHAR
);

Tlu Species

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.tlu_species

30.47 kB
337 rows
10 columns

CREATE TABLE tlu_species (
  "species_id" VARCHAR,
  "family" VARCHAR,
  "scientific_name" VARCHAR,
  "common_name" VARCHAR,
  "species_code" VARCHAR,
  "source" VARCHAR,
  "te_status" VARCHAR,
  "habitat" VARCHAR,
  "bna_account" VARCHAR,
  "tsn" DOUBLE
);

Xref Event Contacts

@usgov.doi_gov_pacific_island_network_landbird_monitoring_9c701.xref_event_contacts

58.16 kB
3,772 rows
3 columns

CREATE TABLE xref_event_contacts (
  "event_id" VARCHAR,
  "contact_id" VARCHAR,
  "contact_role" VARCHAR
);