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-09-28T23:10:17.436693
Tags: algae, american-samoa, benthic, biology, biota, corals, ecological-framework-biological-integrity-focal-species-or-communities-fishes, ecological-framework-biological-integrity-focal-species-or-communities-marine-communities, ecological-framework-biological-integrity-focal-species-or-communities-marine-invertebrates, 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_53decb97.pacn_marine_benthic_cover_data

10.48 MB
2,420,050 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" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Marine Contacts Lookup

@usgov.doi_gov_pacific_island_network_benthic_marine_communit_53decb97.pacn_marine_contacts_lookup

3.97 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_53decb97.pacn_marine_fish_data

317.92 kB
69,866 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_53decb97.pacn_marine_rugosity

71.85 kB
1,388 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_53decb97.pacn_marine_settlement

43.34 kB
3,303 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_53decb97.pacn_marine_taxon_lookup

72.49 kB
839 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_53decb97.pacn_marine_transects

52.52 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
);