36837 Large Shoreline Debris Entity Published / External 32834 Shoreline surveys and removal of marine debris at Midway Atoll, Northwestern Hawaiian Islands from 2013 to 2018 Data Set Completed Entities for large debris data from the shoreline surveys Data Table Yes CRED_DEBRIS Materialized view containing large debris data from the shoreline surveys 1 MISSION_NAME VARCHAR2 50 No No Active Descriptive mission name VARCHAR2 2 MISSION_DESCRIPTION VARCHAR2 255 No No Active Description of notable aspects of mission Midway Marine Debris Removal: all shore-based mission at Midway Atoll NWHI Marine Debris Removal: Midway component to a ship-based NWHI debris mission VARCHAR2 5 WAYPOINT VARCHAR2 255 No No Active ID of waypoint taken by GPS to mark debris item VARCHAR2 6 LATITUDE NUMBER 22 No No 38 Active Latitude of debris item (unit = decimal degree in WGS 1984 Geographic Coordinate System) NUMBER 7 LONGITUDE NUMBER 22 No No Active Longitude of debris item (unit = decimal degree in WGS 1984 Geographic Coordinate System) NUMBER 8 ITEM_TYPE VARCHAR2 50 No No Active Type of large or notable debris recorded: NET, METAL, OTHER VARCHAR2 9 STATUS VARCHAR2 25 No No Active Status of debris when found STRANDED: on land BURIED: submerged underwater/partially buried VARCHAR2 10 WIDTH_M NUMBER 22 No No 38 Active Second longest measurement of this debris item (unit = meters) NUMBER 11 LENGTH_M NUMBER 22 No No Active Longest measurement of this debris item (unit = meters) NUMBER 12 TSUNAMI_RELATED NUMBER 22 No No 38 0 Active Indication of whether the debris item was visibly related to the Japanese tsunami of 2011 (1/yes, 0: no) NUMBER 14 DESCRIPTION VARCHAR2 255 No No Active Description of notable characteristics of debris item and indication of whether debris item was removed from shoreline VARCHAR2 15 START_DTM DATE 7 No No Active Start date and time of survey DATE 16 END_DTM DATE 7 No No Active End date and time of survey DATE 17 ISLAND_CODE VARCHAR2 3 No No Active 3 character island code MID: Midway Atoll VARCHAR2 18 SPECIFIC_LOCATION VARCHAR2 255 No No Active Island or sub-island name: Eastern Island, Sand Island, Spit Island. VARCHAR2 19 SHORELINE VARCHAR2 255 No No Active General location of survey area within the island or sub-island specified in the SPECIFIC_LOCATION column: North, South, East, West, Northeast, Northwest, Southeast, Southwest. 23 START_LATITUDE NUMBER 22 No No Active Beginning latitude of survey area from GPS unit (unit = decimal degree in WGS 1984 Geographic Coordinate System). Null if survey areas of Sand Island in Midway Atoll are not tracked. NUMBER 24 START_LONGITUDE NUMBER 22 No No 38 Active Beginning longitude of survey area from GPS unit (unit = decimal degree in WGS 1984 Geographic Coordinate System). Null if survey areas of Sand Island in Midway Atoll are not tracked. NUMBER 25 END_LATITUDE NUMBER 22 No No Active End latitude of survey area from GPS unit (unit = decimal degree in WGS 1984 Geographic Coordinate System). Null if survey areas of Sand Island in Midway Atoll are not tracked. NUMBER 26 END_LONGITUDE NUMBER 22 No No 38 Active End longitude of survey area from GPS unit (unit = decimal degree in WGS 1984 Geographic Coordinate System). Null if survey areas of Sand Island in Midway Atoll are not tracked. NUMBER 27 SHORELINE_WIDTH_M NUMBER 22 No No Active Average width of shoreline, from vegetation to high tide line (unit = meters). In 2013, the shoreline width was inconsistently collected (null if the data was not collected). NUMBER 28 LAST_SURVEY_DATE DATE 7 No No Active Date of last survey, if known. Inconsistently documented. DATE 29 STORM_ACTIVITY NUMBER 22 No No 1 0 Active Indication of whether a major storm has occurred since the last survey (1/ storm occurred; 0/no known storm). Inconsistently documented. NUMBER 30 STORM_DATE DATE 7 No No Active Date of most recent storm, if known. Inconsistently documented. DATE 31 STORM_DESCRIPTION VARCHAR2 255 No No Active Description of the major storm if STORM_ACTIVITY column is 1 (dates, names of storms, etc.). Inconsistently documented. VARCHAR2 32 CURRENT_WEATHER VARCHAR2 255 No No Active Brief weather observations. Inconsistently documented. VARCHAR2 34 NUM_PARTICIPANTS NUMBER 22 No No Active Total number of participants for the survey. NUMBER 37 TOTAL_WEIGHT_KG NUMBER 22 No No 38 Active Total weight of debris removed, may not be total of all tallied items (unit = kilograms). NUMBER 39 RADIATION_BASE NUMBER 22 No No 38 Active Radiation level of survey area, only measured for selected segment in 2013 (unit = rem). NUMBER 40 SEGMENT VARCHAR2 20 No No Active Segment ID of 300-meter segment along the shorelines of Eastern (EAS) and Spit (SPT) Islands on Midway Atoll. Survey areas of Sand Island (SAN) are often not tracked, and no ID is assigned. VARCHAR2 41 SURVEY_AREA NUMBER 22 No No 38 Active Area surveyed, derived by digitizing GPS tracks of survey area in ArcGIS 10.x (unit = square kilometers, WGS 1984 UTM Zone 1N). Null if survey areas of Sand Island in Midway Atoll are not tracked. NUMBER gov.noaa.nmfs.inport:36837 Annette DesRochers 2017-02-17T17:01:25 Michael Akridge 2024-03-13T19:23:40 2024-03-13 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-30 1 Year 2020-05-30