47680 V0_BENT_LPI Entity Published / External 25349 Environmental Monitoring of Coral Bleaching and Disease in the Hawaiian Islands: assessment of coral reef communities in Hawaii, Maui, and Oahu of the Main Hawaiian Islands from March 8, 2010 to November 8, 2011 using the Line-point Intercept (LPI) method Data Set Completed LPI foundational view Data View Yes GISDAT LPI foundational view 1 OBJECTID NUMBER 22 Yes No 0 Active Unique identifier for benthic LPI observations. 2 ROUNDID NUMBER 22 Yes No 28 0 Active Unique identifier for MISSIONID. 3 MISSIONID VARCHAR2 30 Yes No Active Mission identifier. 5 REGION_NAME VARCHAR2 30 No No Active The name of the Pacific Islands Region where the surveys were conducted. 6 ISLAND NVARCHAR2 765 No No Active The name of the island or atoll in the REGION_NAME where the surveys were conducted. 7 SITEVISITID NUMBER 22 Yes No Active Unique identifier created each time a SITE is surveyed on a DATE_ 8 SITE NVARCHAR2 150 No No Active The name of the location where the survey was conducted. Combines a 3-letter ISLAND code with a site number. 9 LATITUDE NUMBER 22 No No Active Latitude in decimal degrees, WGS84, for SITE surveyed. There are 8 sites where the latitude and longitude were not captured: MAI-906, MAI-908, MAI-910, MAI-913, MAI-920, MAI-921, OAH-904, and OAH-905. 10 LONGITUDE NUMBER 22 No No Active Longitude in decimal degrees, WGS84 for the SITE surveyed. There are 8 sites where the latitude and longitude were not captured: MAI-906, MAI-908, MAI-910, MAI-913, MAI-920, MAI-921, OAH-904, and OAH-905. 11 LOCATION TEXT No No Active Descriptive location for survey SITE. 15 DATE_ DATE 7 Yes No Active Date the survey was conducted. 16 OBS_YEAR NUMBER 22 No No Active Year the survey was conducted. 17 LPITRANSECTRUN NUMBER 22 Yes No 28 0 Active Unique sample identifier. 18 DIVER NVARCHAR2 150 Yes No Active Initials of diver that conducted the survey. 19 MINDEPTH NUMBER 22 No No 28 0 Active Minimum survey transect depth in feet. 20 MAXDEPTH NUMBER 22 No No 28 0 Active Maximum survey transect depth in feet. 21 METHODCODE NVARCHAR2 18 Yes No Active The numeric code for the survey method used to conduct the survey. 30 = Line Point Intercept method version c, LPI survey conducted at 50-cm intervals. 32 = Line Point Intercept method version d, LPI survey conducted at 25-cm intervals. 23 TRANNUM NUMBER 22 Yes No 28 0 Active The transect number (1 or 2). 24 LPI_SEG NVARCHAR2 15 No No Active Distance along the transect between 0 and 25 m where the intercept/point lies. 25 BENTHICCODE NVARCHAR2 15 Yes No Active The LPI-specific code for the BENTHICNAME identified during LPI surveys. 26 FAMILY VARCHAR2 255 No No Active Family taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service. 27 GENUS VARCHAR2 255 No No Active GENUS taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service. 28 CATEGORY_GENUS NVARCHAR2 150 Yes No Active The LPI-specific category genus for BENTHICNAME. 29 BENTHICNAME NVARCHAR2 165 Yes No Active The LPI-specific benthic name to the lowest taxonomic level possible for the benthic element identified during LPI surveys. 30 BENTHICCATEGORY NVARCHAR2 12 Yes No Active The LPI-specific benthic category code for the benthic element identified during LPI surveys. 31 COMMON_NAME NVARCHAR2 60 Yes No Active The LPI-specific BENTHICCATEGORY name for the benthic element identified during LPI surveys. 32 COUNT NUMBER 22 Yes No 28 0 Active The observation count for the benthic element identified. gov.noaa.nmfs.inport:47680 Troy Kanemura 2017-10-27T21:41:13 SysAdmin InPortAdmin 2022-08-09T17:11:04 2017-12-14 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-12-14 1 Year 2018-12-14