45799 V0_CORAL_OBS_A Entity Published / External 10512 Pacific Reef Assessment and Monitoring Program: Belt Transect Surveys of Corals at U.S. Pacific Reefs from 2002 to 2007 (uneven size-class bins) Data Set Completed Coral belt observations (2002 - 2007) Data View Yes GISDAT Coral belt observations (2002 - 2007) 1 ROUNDID NUMBER 22 Yes No 28 0 Active Unique Identifier for MISSION 2 MISSIONID VARCHAR2 30 Yes No Active Mission Identifier 4 REGION_NAME VARCHAR2 30 No No Active The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. 5 ISLAND NVARCHAR2 150 No No Active Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). 6 ISLANDCODE NVARCHAR2 15 No No Active 3-letter code for ISLAND. 7 SITE NVARCHAR2 150 Yes No Active The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number. 8 LATITUDE NUMBER 22 No No 38 Active Latitude in decimal degrees, WGS84, for the given SITE. 9 LONGITUDE NUMBER 22 No No Active Longitude in decimal degrees, WGS84 for the given SITE. 11 REEF_ZONE NVARCHAR2 150 No No Active The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). 12 DEPTH_BIN NVARCHAR2 60 No No Active Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m 14 SITEVISITID NUMBER 22 Yes No Active Unique identifier created each time a SITE is surveyed on a DATE_. 15 DATE_ DATE 7 Yes No Active Local date the survey was conducted. 18 OBS_YEAR NUMBER 22 No No Active 4-digit year the survey was conducted (DATE_). 23 DIVER NVARCHAR2 150 Yes No Active Initials of diver conducting survey 24 BELTTRANSECTRUN NUMBER 22 Yes No 38 0 Active Unique identifier for TRANSECT 25 METHODNAME NVARCHAR2 150 Yes No Active References the coral belt survey method: method A. 26 TRANSECT NUMBER 22 Yes No 38 0 Active Transect number surveyed at a site. During the early, exploratory years, number of transects surveyd at a site varied between 1 and 4, depending on region and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. 28 TRANWIDTH NUMBER 22 No No 38 8 Active Transect width in meters. Varied between 1 m and 2 m depending on survey year, region, and specific mission objectives. In areas like the Northwestern Hawaiian Islands where coral colony density was low, a 2-m belt was implemented. 29 TRANLENGTH NUMBER 22 No No 28 8 Active Transect length in meters. Varied between 8 m and 75 m depending on survey year, region, weather, and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. 32 TAXONCODE NVARCHAR2 150 No No Active 4-letter taxon code for TAXONNAME 34 SIZECLASS TEXT 50 No No Active Colony size binned into 1 of 7 categories (0-5 cm; 5–10 cm; 10-20 cm; 20-40 cm; 40-80 cm; 80-160 cm; or 160 cm). 35 COUNT NUMBER No No Active Number of colonies of a specific taxon belonging to a specific size class 47 TAXONNAME NVARCHAR2 765 No No Active Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). 48 PHYLUM VARCHAR2 255 No No Active Taxonomic classification: Phylum of observed organism (TAXONNAME). 49 CLASS NVARCHAR2 60 No No Active Taxonomic classification: Class of observed organism (TAXONNAME). 50 S_ORDER VARCHAR2 255 No No Active Taxonomic classification: Order of observed organism (TAXONNAME). 51 FAMILY VARCHAR2 255 No No Active Taxonomic classification: Family of observed organism (TAXONNAME). 53 GENUS NVARCHAR2 300 No No Active Taxonomic classification: Genus name of observed organism (TAXONNAME). 54 SCIENTIFIC_NAME VARCHAR2 255 No No Active Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). 55 RANK VARCHAR2 20 No No Active Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species) 56 APHIAID VARCHAR2 20 No No Active Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS. gov.noaa.nmfs.inport:45799 Troy Kanemura 2017-04-19T15:28:07 SysAdmin InPortAdmin 2022-08-09T17:11:20 2019-05-31 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2019-05-31 1 Year 2020-05-31