Item Identification

Title: Large Debris Entities from Shoreline Surveys
Short Name: Large Shoreline Debris
Status: Completed
Abstract:

Entities for large debris data from the shoreline surveys

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CRED_DEBRIS
Description:

Materialized view containing large debris data from the shoreline surveys

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
MISSION_NAME VARCHAR2 Descriptive mission name
100
MISSION_DESCRIPTION VARCHAR2 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
100
WAYPOINT VARCHAR2 ID of waypoint taken by GPS to mark debris item
100
LATITUDE NUMBER Latitude of debris item (unit = decimal degree in WGS 1984 Geographic Coordinate System)
100
LONGITUDE NUMBER Longitude of debris item (unit = decimal degree in WGS 1984 Geographic Coordinate System)
100
ITEM_TYPE VARCHAR2 Type of large or notable debris recorded: NET, METAL, OTHER
100
STATUS VARCHAR2 Status of debris when found STRANDED: on land BURIED: submerged underwater/partially buried
100
WIDTH_M NUMBER Second longest measurement of this debris item (unit = meters)
100
LENGTH_M NUMBER Longest measurement of this debris item (unit = meters)
100
TSUNAMI_RELATED NUMBER Indication of whether the debris item was visibly related to the Japanese tsunami of 2011 (1/yes, 0: no)
100
DESCRIPTION VARCHAR2 Description of notable characteristics of debris item and indication of whether debris item was removed from shoreline
100
START_DTM DATE Start date and time of survey
100
END_DTM DATE End date and time of survey
100
ISLAND_CODE VARCHAR2 3 character island code MID: Midway Atoll
100
SPECIFIC_LOCATION VARCHAR2 Island or sub-island name: Eastern Island, Sand Island, Spit Island.
100
SHORELINE VARCHAR2 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.
100
START_LATITUDE NUMBER 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.
100
START_LONGITUDE NUMBER 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.
100
END_LATITUDE NUMBER 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.
100
END_LONGITUDE NUMBER 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.
100
SHORELINE_WIDTH_M NUMBER 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).
100
LAST_SURVEY_DATE DATE Date of last survey, if known. Inconsistently documented.
100
STORM_ACTIVITY NUMBER Indication of whether a major storm has occurred since the last survey (1/ storm occurred; 0/no known storm). Inconsistently documented.
100
STORM_DATE DATE Date of most recent storm, if known. Inconsistently documented.
100
STORM_DESCRIPTION VARCHAR2 Description of the major storm if STORM_ACTIVITY column is 1 (dates, names of storms, etc.). Inconsistently documented.
100
CURRENT_WEATHER VARCHAR2 Brief weather observations. Inconsistently documented.
100
NUM_PARTICIPANTS NUMBER Total number of participants for the survey.
100
TOTAL_WEIGHT_KG NUMBER Total weight of debris removed, may not be total of all tallied items (unit = kilograms).
100
RADIATION_BASE NUMBER Radiation level of survey area, only measured for selected segment in 2013 (unit = rem).
100
SEGMENT VARCHAR2 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.
100
SURVEY_AREA NUMBER 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.

Attribute Details

MISSION_NAME

CC ID: 381952
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Descriptive mission name

General Data Type: VARCHAR2

MISSION_DESCRIPTION

CC ID: 381963
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

WAYPOINT

CC ID: 381988
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

ID of waypoint taken by GPS to mark debris item

General Data Type: VARCHAR2

LATITUDE

CC ID: 381989
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Latitude of debris item

(unit = decimal degree in WGS 1984 Geographic Coordinate System)

General Data Type: NUMBER

LONGITUDE

CC ID: 381990
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude of debris item

(unit = decimal degree in WGS 1984 Geographic Coordinate System)

General Data Type: NUMBER

ITEM_TYPE

CC ID: 381991
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Type of large or notable debris recorded: NET, METAL, OTHER

General Data Type: VARCHAR2

STATUS

CC ID: 381992
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Status of debris when found

STRANDED: on land

BURIED: submerged underwater/partially buried

General Data Type: VARCHAR2

WIDTH_M

CC ID: 381953
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Second longest measurement of this debris item (unit = meters)

General Data Type: NUMBER

LENGTH_M

CC ID: 381954
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longest measurement of this debris item

(unit = meters)

General Data Type: NUMBER

TSUNAMI_RELATED

CC ID: 381955
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Indication of whether the debris item was visibly related to the Japanese tsunami of 2011 (1/yes, 0: no)

General Data Type: NUMBER

DESCRIPTION

CC ID: 381957
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Description of notable characteristics of debris item and indication of whether debris item was removed from shoreline

General Data Type: VARCHAR2

START_DTM

CC ID: 381958
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Start date and time of survey

General Data Type: DATE

END_DTM

CC ID: 381959
Seq. Order: 16
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

End date and time of survey

General Data Type: DATE

ISLAND_CODE

CC ID: 381960
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

3 character island code

MID: Midway Atoll

General Data Type: VARCHAR2

SPECIFIC_LOCATION

CC ID: 381961
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Island or sub-island name: Eastern Island, Sand Island, Spit Island.

General Data Type: VARCHAR2

SHORELINE

CC ID: 839034
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

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.

START_LATITUDE

CC ID: 381967
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

START_LONGITUDE

CC ID: 381968
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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.

General Data Type: NUMBER

END_LATITUDE

CC ID: 381969
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

END_LONGITUDE

CC ID: 381970
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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.

General Data Type: NUMBER

SHORELINE_WIDTH_M

CC ID: 381971
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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).

General Data Type: NUMBER

LAST_SURVEY_DATE

CC ID: 381972
Seq. Order: 28
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of last survey, if known. Inconsistently documented.

General Data Type: DATE

STORM_ACTIVITY

CC ID: 381973
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Indication of whether a major storm has occurred since the last survey (1/ storm occurred; 0/no known storm). Inconsistently documented.

General Data Type: NUMBER

STORM_DATE

CC ID: 381975
Seq. Order: 30
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of most recent storm, if known. Inconsistently documented.

General Data Type: DATE

STORM_DESCRIPTION

CC ID: 381976
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Description of the major storm if STORM_ACTIVITY column is 1 (dates, names of storms, etc.). Inconsistently documented.

General Data Type: VARCHAR2

CURRENT_WEATHER

CC ID: 381977
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Brief weather observations. Inconsistently documented.

General Data Type: VARCHAR2

NUM_PARTICIPANTS

CC ID: 381979
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total number of participants for the survey.

General Data Type: NUMBER

TOTAL_WEIGHT_KG

CC ID: 381982
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total weight of debris removed, may not be total of all tallied items (unit = kilograms).

General Data Type: NUMBER

RADIATION_BASE

CC ID: 381984
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Radiation level of survey area, only measured for selected segment in 2013 (unit = rem).

General Data Type: NUMBER

SEGMENT

CC ID: 381986
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

SURVEY_AREA

CC ID: 381987
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 36837
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2017-02-17 17:01+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2019-06-06 23:38+0000
Metadata Record Published: 2019-05-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-30