36873 VS_BENT_TDS Entity Published / External 35618 Pacific Reef Assessment and Monitoring Program: Towed-diver Surveys of Benthic Habitat, Key Benthic Species, including Marine Debris Sightings, of the U.S. Pacific Reefs from 2000 to 2012 Data Set Completed CREP Benthic Towed-Diver Survey spatial view Loaded by batch 9510, 11-21-2016 14:37 Data View Yes GISDAT Benthic towed-diver survey spatial view 1 ROUNDID NUMBER 22 Yes No 28 0 Active Unique Identifier for ROUND record 2 MISSIONID VARCHAR2 30 Yes No Active Mission Identifier 3 REGION_NAME VARCHAR2 30 No No Active One of the five Pacific Island regions CRED surveys 4 ISLAND NVARCHAR2 150 No No Active Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record 5 LATITUDE NUMBER 22 No No 28 8 Active Latitude in decimal degrees, WGS84, for the given island 6 LONGITUDE NUMBER 22 No No 28 8 Active Longitude in decimal degrees, WGS84 for the given island 7 OBS_YEAR NUMBER 22 Yes No 38 0 Active Year the survey was conducted 8 DIVEID NUMBER 22 No No Active Unique ID representing year, month, day, tow # of day 9 SEGMENTID NUMBER 22 No No Active Unique ID representing year, month, day, tow # of day, segment # 10 DATE_ DATE 7 Yes No Active Date of the Tow survey 11 REEF_ZONE NVARCHAR2 150 Yes No Active The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified). Forereef: The sloping bottom underlying the wave break zone, extending seaward from the reef crest. Comprehensive surveys of forereef habitats remain the priority for towed-diver operations. Backreef: The shallow strip of reef sheltered from breaking waves by the reef crest, situated between the reef crest and the lagoon floor. Lagoon: The zone sheltered from the waves by the reef crest, and separated from the reef crest by the back reef. Usually deeper than the back reef and covered in unconsolidated sediment, this term describes both an atoll's interior and the expanse situated between the back reef and shore of any islands present. Unspecified: these are other areas surveyed using towed-diver methods, which include: Bank: A submerged platform reef, often occurring either as an isolated feature atop a seamount or as a plateau situated between the fore reef and a deeper slope. These areas are no longer actively targeted, with Pathfinder Reef (MARAMP 2007, CNMI) and Tutuila (ASRAMP 2010; exploratory) represents the last banks actively surveyed. Channel: A submerged transition between forereef and backreef zones created by a gap in the reef crest. Divers should avoid using channels to transition from forereef to backreef habitats (i.e. stick with one or the other). In addition, divers should make a note in the ¿Comments¿ section whenever crossing a channel along a forereef/backreef survey. 12 METHODCODE NVARCHAR2 30 No No Active Survey method used 13 NO_OBS NUMBER 22 No No 38 0 Active No data recorded for a towed-diver survey due to diver recall, hazardous conditions, depth, etc. 14 DIVER1 NVARCHAR2 150 Yes No Active Initials of fish diver 15 DIVER2 NVARCHAR2 150 No No Active Initials of benthic diver 16 TOWKEY NUMBER 22 Yes No 38 0 Active Towkey for the given towed diver survey fish observation 17 SEGMENT NUMBER 22 No No 5 0 Active Segments represent 5-minute increments; there are 10 segments per tow. 18 DEPTH NUMBER 22 No No Active Mean Depth (in meters) of the towed-diver segment 19 DEPTH_SD NUMBER 22 No No Active Standard deviation of depth of the towed-diver segment 20 TEMPERATURE NUMBER 22 No No 38 Active Temperature of the Towed Diver Survey 21 TEMPERATURE_SD NUMBER 22 No No 38 Active Standard deviation of temperature of the Towed Diver Survey 22 STARTLOCALTIME DATE 7 No No Active Local start time of the Towed Diver Survey 23 ENDLOCALTIME DATE 7 No No Active Local end time of the Towed Diver Survey 24 CENTROIDLAT NUMBER 22 No No 38 8 Active Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment 25 CENTROIDLON NUMBER 22 No No 38 8 Active Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment 26 PROJECTEDLENGTH NUMBER 22 No No 38 8 Active Length of tow segment (meters). Calculated from tow tracks using GIS 27 DOMINANT_HABITAT NVARCHAR2 15 No No Active Dominant Habitat 28 DOMINANT_HABITAT_DESC NVARCHAR2 150 No No Active Dominant Habitat description 29 COMPLEXITY NVARCHAR2 9 No No Active Complexity 30 LIVE_CORAL_MID NUMBER 22 No No 28 8 Active Live coral mid-point 31 DEAD_CORAL_MID NUMBER 22 No No 28 8 Active Dead coral mid-point 32 SOFT_CORAL_MID NUMBER 22 No No 28 8 Active Soft coral mid-point 33 SAND_MID NUMBER 22 No No 28 8 Active Sand mid-point 34 RUBBLE_MID NUMBER 22 No No 28 8 Active Rubble mid-point 35 PAVE_MID NUMBER 22 No No 28 8 Active Pavement mid-point 36 STRESSED_CORAL_MID NUMBER 22 No No 28 8 Active Stressed coral mid-point 37 ROCK_MID NUMBER 22 No No 28 8 Active Rock mid-point 38 ALGAE_MID NUMBER 22 No No 28 8 Active Algae mid-point 39 MACROALGAE_MID NUMBER 22 No No 28 8 Active Macro algae mid-point 40 CORALLINE_MID NUMBER 22 No No 28 8 Active Coralline algae mid-point 41 CROWN_OF_THORN NUMBER 22 No No 5 0 Active Acanthaster planci. Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 42 URCHIN NUMBER 22 No No 28 8 Active Number of urchins observed 43 BORING_URCHIN NUMBER 22 No No 5 0 Active "Boring" sea urchins (e.g. Echinostrephus, Echinometra). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 44 FREE_URCHIN NUMBER 22 No No 5 0 Active "Free" sea urchins (e.g. Tripneustes, Diadema). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 45 SEA_CUCUMBER NUMBER 22 No No 28 8 Active Number of sea cucumbers observed 46 GIANT_CLAM NUMBER 22 No No 5 0 Active Giant clams (Tridacna sp.). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 47 PEARL_OYSTER NUMBER 22 No No 28 8 Active Number of pearl oysters observed 48 LOBSTER NUMBER 22 No No 28 8 Active Number of lobsters observed 49 OCTOPUS NUMBER 22 No No 28 8 Active Number of octopuses observed 50 NET_LINE NUMBER 22 No No 5 0 Active Derelict fishing gear of any type (e.g. monofilament line, fishing nets or fragments of fishing nets, etc.) 51 MUNITION NUMBER 22 No No 5 0 Active Munitions/unexploded ordinance 52 WRECK NUMBER 22 No No 5 0 Active Shipwrecks 53 MANMADE_OBJECT NUMBER 22 No No 5 0 Active Man-made objects, whether of nautical or terrestrial origins (e.g. anchors/discarded mooring, tires, corrugated tin roofing). It is important to note that marine debris observations do not include highly mobile marine debris (e.g. bottles, cans, plastic bags, etc.) 54 MANMADE_NOTE NVARCHAR2 255 No No Active Manmade Note gov.noaa.nmfs.inport:36873 Troy Kanemura 2017-02-22T17:11:12 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-06-27 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 2017-06-27 1 Year 2018-06-27