Large Debris Entities from Shoreline Surveys
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36837 | Updated: March 13, 2024 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |
---|---|
GUID: | gov.noaa.nmfs.inport:36837 |
Metadata Record Created By: | Annette M DesRochers |
Metadata Record Created: | 2017-02-17 17:01+0000 |
Metadata Record Last Modified By: | Michael W Akridge |
Metadata Record Last Modified: | 2024-03-13 19:23+0000 |
Metadata Record Published: | 2024-03-13 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-05-30 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-05-30 |