About this Dataset

Pacific Island Network Benthic Marine Community And Marine Fish Monitoring Data Package 2006 - 2023

The Benthic Marine Communities Monitoring Protocol is implemented in four parks in the Pacific and addresses two monitoring questions: What are the changes over time in the composition (e.g., species or assemblage) and physical structure (rugosity) of the coral reef benthos? And what are the changes over time in settlement, growth, survival, and health of targe coral assemblages, species, or individuals? Note: Growth and survival data has not been collected due to lack of resources to do so. The Marine Fish Monitoring Protocol is conducted in the same parks and sampling location sites, and addresses one monitoring question: What are the long-term trends in the numerical density, biomass, and size of reef fishes? Sampling location sites were randomly selected on hard substrata in an isobath between the 10- and 20-meter depths. This data package contains data collected for these two protocols.
Organization: Department of the Interior
Last updated: 2025-07-13T14:44:37.058107
Tags: algae, american-samoa, benthic, biology, biota, corals, fishes, guam, hardbottom, hawaii, invertebrates, kaho, kala, kalaupapa-national-historical-park, kaloko-honokhau-national-historical-park, molokai, monitoring, national-park-of-american-samoa-national-park, npsa, oceans, ofu, substrate, tutuila, wapa, war-in-the-pacific-national-historical-park

Tables

PACN Marine Benthic Cover Data

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_benthic_cover_data

10.18 MB
2420050 rows
27 columns


CREATE TABLE pacn_marine_benthic_cover_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_loctype" VARCHAR,
  "custom_locname" VARCHAR,
  "custom_labelname" VARCHAR,
  "decimallatitude" VARCHAR,
  "decimallongitude" VARCHAR,
  "eventdate" TIMESTAMP,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "custom_frameider" VARCHAR,
  "custom_frame" BIGINT,
  "custom_diseasebleaching" VARCHAR,
  "custom_severity" VARCHAR,
  "custom_pointnumber" BIGINT,
  "custom_x" VARCHAR,
  "custom_y" VARCHAR,
  "scientificname" VARCHAR,
  "custom_bleaching" VARCHAR,
  "custom_bleachingcat" VARCHAR,
  "custom_benthiccertified" BIGINT,
  "custom_benthiccertifiedby" VARCHAR,
  "custom_benthiccertifieddate" VARCHAR,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Marine Contacts Lookup

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_contacts_lookup

3.88 KB
33 rows
3 columns


CREATE TABLE pacn_marine_contacts_lookup (
  "recordedby" VARCHAR,
  "custom_organization" VARCHAR,
  "dynamicproperties" VARCHAR
);

PACN Marine Fish Data

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_fish_data

309.7 KB
69868 rows
25 columns


CREATE TABLE pacn_marine_fish_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_loctype" VARCHAR,
  "custom_locname" BIGINT,
  "custom_labelname" VARCHAR,
  "decimallatitude" VARCHAR,
  "decimallongitude" VARCHAR,
  "eventdate" TIMESTAMP,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "scientificname" VARCHAR,
  "individualcount" BIGINT,
  "occurrencestatus" VARCHAR,
  "dynamicproperties" VARCHAR,
  "measurementtype" VARCHAR,
  "measurementvalue" BIGINT,
  "measurementunit" VARCHAR,
  "occurenceremarks" VARCHAR,
  "custom_fishcertified" BIGINT,
  "custom_fishcertifiedby" VARCHAR,
  "custom_fishcertifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Marine Rugosity

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_rugosity

69.37 KB
1388 rows
15 columns


CREATE TABLE pacn_marine_rugosity (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_loctype" VARCHAR,
  "custom_locname" VARCHAR,
  "custom_labelname" VARCHAR,
  "decimallatitude" VARCHAR,
  "decimallongitude" VARCHAR,
  "eventdate" TIMESTAMP,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Marine Settlement

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_settlement

42.27 KB
3303 rows
28 columns


CREATE TABLE pacn_marine_settlement (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_loctype" VARCHAR,
  "custom_locname" BIGINT,
  "custom_labelname" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "eventdate" TIMESTAMP,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "custom_cra" BIGINT,
  "custom_platenumber" BIGINT,
  "custom_retrievedplatepairdate" TIMESTAMP,
  "custom_durationindays" BIGINT,
  "custom_surface" VARCHAR,
  "custom_orientation" VARCHAR,
  "scientificname" VARCHAR,
  "custom_genuscode" VARCHAR,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_settcertified" BIGINT,
  "custom_settcertifiedby" VARCHAR,
  "custom_settcertifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Marine Taxon Lookup

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_taxon_lookup

70.82 KB
840 rows
23 columns


CREATE TABLE pacn_marine_taxon_lookup (
  "acceptednameusageid" VARCHAR,
  "type" VARCHAR,
  "settlement" BIGINT,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "specificepithet" VARCHAR,
  "scientificname" VARCHAR,
  "taxonrank" VARCHAR,
  "scientificnameauthorship" VARCHAR,
  "custom_targetspecies" VARCHAR,
  "vernacularname" VARCHAR,
  "custom_trophic" VARCHAR,
  "custom_consumer" VARCHAR,
  "custom_endemic" VARCHAR,
  "custom_mobility" VARCHAR,
  "custom_statusesa" VARCHAR,
  "taxonremarks" VARCHAR,
  "modified" VARCHAR,
  "custom_modifiedby" VARCHAR
);

PACN Marine Transects

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_14a168dd.pacn_marine_transects

51.29 KB
870 rows
21 columns


CREATE TABLE pacn_marine_transects (
  "samplingprotocol" VARCHAR,
  "custom_establishedyear" BIGINT,
  "islandgroup" VARCHAR,
  "island" VARCHAR,
  "custom_unitcode" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_subunit" VARCHAR,
  "custom_loctype" VARCHAR,
  "custom_locname" VARCHAR,
  "custom_labelname" VARCHAR,
  "decimallatitude" VARCHAR,
  "decimallongitude" VARCHAR,
  "geodeticdatum" VARCHAR,
  "custom_mgmt" VARCHAR,
  "custom_habitat" VARCHAR,
  "custom_subhabitat" VARCHAR,
  "custom_bearing" VARCHAR,
  "minimumdepthinmeters" VARCHAR,
  "maximumdepthinmeters" VARCHAR,
  "locationremarks" VARCHAR,
  "locationid" VARCHAR
);