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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Entities for large debris data from the shoreline surveys
DescriptionMaterialized view containing large debris data from the shoreline surveys
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
MISSION_NAME
VARCHAR2 |
Descriptive mission name |
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 |
WAYPOINT
VARCHAR2 |
ID of waypoint taken by GPS to mark debris item |
LATITUDE
NUMBER |
Latitude of debris item (unit = decimal degree in WGS 1984 Geographic Coordinate System) |
LONGITUDE
NUMBER |
Longitude of debris item (unit = decimal degree in WGS 1984 Geographic Coordinate System) |
ITEM_TYPE
VARCHAR2 |
Type of large or notable debris recorded: NET, METAL, OTHER |
STATUS
VARCHAR2 |
Status of debris when found STRANDED: on land BURIED: submerged underwater/partially buried |
WIDTH_M
NUMBER |
Second longest measurement of this debris item (unit = meters) |
LENGTH_M
NUMBER |
Longest measurement of this debris item (unit = meters) |
TSUNAMI_RELATED
NUMBER |
Indication of whether the debris item was visibly related to the Japanese tsunami of 2011 (1/yes, 0: no) |
DESCRIPTION
VARCHAR2 |
Description of notable characteristics of debris item and indication of whether debris item was removed from shoreline |
START_DTM
DATE |
Start date and time of survey |
END_DTM
DATE |
End date and time of survey |
ISLAND_CODE
VARCHAR2 |
3 character island code MID: Midway Atoll |
SPECIFIC_LOCATION
VARCHAR2 |
Island or sub-island name: Eastern Island, Sand Island, Spit Island. |
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. |
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. |
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. |
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. |
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. |
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). |
LAST_SURVEY_DATE
DATE |
Date of last survey, if known. Inconsistently documented. |
STORM_ACTIVITY
NUMBER |
Indication of whether a major storm has occurred since the last survey (1/ storm occurred; 0/no known storm). Inconsistently documented. |
STORM_DATE
DATE |
Date of most recent storm, if known. Inconsistently documented. |
STORM_DESCRIPTION
VARCHAR2 |
Description of the major storm if STORM_ACTIVITY column is 1 (dates, names of storms, etc.). Inconsistently documented. |
CURRENT_WEATHER
VARCHAR2 |
Brief weather observations. Inconsistently documented. |
NUM_PARTICIPANTS
NUMBER |
Total number of participants for the survey. |
TOTAL_WEIGHT_KG
NUMBER |
Total weight of debris removed, may not be total of all tallied items (unit = kilograms). |
RADIATION_BASE
NUMBER |
Radiation level of survey area, only measured for selected segment in 2013 (unit = rem). |
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. |
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. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
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 |