Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains data from B Mundy's file: EditedStomachContentData_PlusFish&Collection.xls. It contains 2,736 data records.

Description

This table contains data from B Mundy's file: EditedStomachContentData_PlusFish&Collection.xls. It contains 2,736 data records.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
VARCHAR2
Number assigned to each prey identified.
CONTROL
VARCHAR2
Sequential number assigned to each sample in the order in which it was processed; for data tracking purposes. XG=Xiphias gladius.
SAMPLE
VARCHAR2
Sample number, e.g., observer specimen number, observer's name, fish number.
TRIP
VARCHAR2
Trip identifier, e.g., observer trip number, commercial vessel name, NOAA R/V Townsend Cromwell cruise number.
SET_NUMBER
VARCHAR2
Set number.
PREY_SPECIES_NAME
VARCHAR2
Prey species name.
PREY_IDENTIFICATION
VARCHAR2
Prey Identification.
PREY_CONDITION_CODE
VARCHAR2
Code for the condition of the prey.
NUMBER_PREY
VARCHAR2
Number of prey items for this species.
WEIGHT_PREY
VARCHAR2
Weight of prey or total weight, in grams. Units for values are grams.
TOTAL_LENGTH
VARCHAR2
Total length, in millimeters. Field also contains a few Fork Length measurements. Units for values are millimeters.
STANDARD_LENGTH
VARCHAR2
Standard length, in millimeters. Units for values are millimeters.
CARAPACE_LENGTH
VARCHAR2
Carapace length, in millimeters. Units for values are millimeters.
MANTLE_LENGTH
VARCHAR2
Mantle length, in millimeters. Units for values are millimeters.
LENGTH_CONDITION_CODE
VARCHAR2
Code for condition of prey length.
PREY_COMMENTS
VARCHAR2
Prey comments.
EYETOFORK_LENGTH
VARCHAR2
Swordfish Eye to Fork Length, in centimeters. Units for values are centimeters.
SEX_CODE
VARCHAR2
Swordfish sex code.
YEAR
VARCHAR2
Year.
MONTH
VARCHAR2
Month.
LATITUDE
VARCHAR2
Latitude, in decimal degrees. Units for values are degrees.
LATITUDE_DIRECTION
VARCHAR2
Latitude direction (N/S).
LONGITUDE_360DEGREES
VARCHAR2
Longitude, in decimal degrees, 0-360. Units for values are degrees.
LONGITUDE
VARCHAR2
Longitude, in decimal degrees. Units for values are degrees.
LONGITUDE_DIRECTION
VARCHAR2
Longitude direction (E/W).
PHYLOSORT
VARCHAR2
For taxonomic sorting.

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: EDIT_SWO_STOMACH_FISH
Short Name: EDIT_SWO_STOMACH_FISH
Status: Completed
Abstract:

This table contains data from B Mundy's file: EditedStomachContentData_PlusFish&Collection.xls. It contains 2,736 data records.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

This table contains data from B Mundy's file: EditedStomachContentData_PlusFish&Collection.xls. It contains 2,736 data records.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID VARCHAR2 Number assigned to each prey identified.
100
CONTROL VARCHAR2 Sequential number assigned to each sample in the order in which it was processed; for data tracking purposes. XG=Xiphias gladius.
100
SAMPLE VARCHAR2 Sample number, e.g., observer specimen number, observer's name, fish number.
100
TRIP VARCHAR2 Trip identifier, e.g., observer trip number, commercial vessel name, NOAA R/V Townsend Cromwell cruise number.
100
SET_NUMBER VARCHAR2 Set number.
100
PREY_SPECIES_NAME VARCHAR2 Prey species name.
100
PREY_IDENTIFICATION VARCHAR2 Prey Identification.
100
PREY_CONDITION_CODE VARCHAR2 Code for the condition of the prey.
100
NUMBER_PREY VARCHAR2 Number of prey items for this species.
100
WEIGHT_PREY VARCHAR2 Weight of prey or total weight, in grams. Units for values are grams.
100
TOTAL_LENGTH VARCHAR2 Total length, in millimeters. Field also contains a few Fork Length measurements. Units for values are millimeters.
100
STANDARD_LENGTH VARCHAR2 Standard length, in millimeters. Units for values are millimeters.
100
CARAPACE_LENGTH VARCHAR2 Carapace length, in millimeters. Units for values are millimeters.
100
MANTLE_LENGTH VARCHAR2 Mantle length, in millimeters. Units for values are millimeters.
100
LENGTH_CONDITION_CODE VARCHAR2 Code for condition of prey length.
100
PREY_COMMENTS VARCHAR2 Prey comments.
100
EYETOFORK_LENGTH VARCHAR2 Swordfish Eye to Fork Length, in centimeters. Units for values are centimeters.
100
SEX_CODE VARCHAR2 Swordfish sex code.
100
YEAR VARCHAR2 Year.
100
MONTH VARCHAR2 Month.
100
LATITUDE VARCHAR2 Latitude, in decimal degrees. Units for values are degrees.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction (N/S).
100
LONGITUDE_360DEGREES VARCHAR2 Longitude, in decimal degrees, 0-360. Units for values are degrees.
100
LONGITUDE VARCHAR2 Longitude, in decimal degrees. Units for values are degrees.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction (E/W).
100
PHYLOSORT VARCHAR2 For taxonomic sorting.

Attribute Details

ID

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

Number assigned to each prey identified.

General Data Type: VARCHAR2

CONTROL

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

Sequential number assigned to each sample in the order in which it was processed; for data tracking purposes. XG=Xiphias gladius.

General Data Type: VARCHAR2

SAMPLE

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

Sample number, e.g., observer specimen number, observer's name, fish number.

General Data Type: VARCHAR2

TRIP

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

Trip identifier, e.g., observer trip number, commercial vessel name, NOAA R/V Townsend Cromwell cruise number.

General Data Type: VARCHAR2

SET_NUMBER

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

Set number.

General Data Type: VARCHAR2

PREY_SPECIES_NAME

CC ID: 817103
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 56
Required: No
Primary Key: No
Status: Active
Description:

Prey species name.

General Data Type: VARCHAR2

PREY_IDENTIFICATION

CC ID: 817104
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 46
Required: No
Primary Key: No
Status: Active
Description:

Prey Identification.

General Data Type: VARCHAR2

PREY_CONDITION_CODE

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

Code for the condition of the prey.

General Data Type: VARCHAR2

NUMBER_PREY

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

Number of prey items for this species.

General Data Type: VARCHAR2

WEIGHT_PREY

CC ID: 817107
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Weight of prey or total weight, in grams. Units for values are grams.

General Data Type: VARCHAR2
Unit of Measure: grams

TOTAL_LENGTH

CC ID: 817108
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Total length, in millimeters. Field also contains a few Fork Length measurements. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

STANDARD_LENGTH

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

Standard length, in millimeters. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

CARAPACE_LENGTH

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

Carapace length, in millimeters. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

MANTLE_LENGTH

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

Mantle length, in millimeters. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

LENGTH_CONDITION_CODE

CC ID: 817112
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for condition of prey length.

General Data Type: VARCHAR2

PREY_COMMENTS

CC ID: 817113
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 93
Required: No
Primary Key: No
Status: Active
Description:

Prey comments.

General Data Type: VARCHAR2

EYETOFORK_LENGTH

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

Swordfish Eye to Fork Length, in centimeters. Units for values are centimeters.

General Data Type: VARCHAR2
Unit of Measure: centimeters

SEX_CODE

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

Swordfish sex code.

General Data Type: VARCHAR2

YEAR

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

Year.

General Data Type: VARCHAR2

MONTH

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

Month.

General Data Type: VARCHAR2

LATITUDE

CC ID: 817118
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Latitude, in decimal degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_DIRECTION

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

Latitude direction (N/S).

General Data Type: VARCHAR2

LONGITUDE_360DEGREES

CC ID: 817120
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Longitude, in decimal degrees, 0-360. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE

CC ID: 817121
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Longitude, in decimal degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_DIRECTION

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

Longitude direction (E/W).

General Data Type: VARCHAR2

PHYLOSORT

CC ID: 817123
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

For taxonomic sorting.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 55423
GUID: gov.noaa.nmfs.inport:55423
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-01-31 22:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-11-04
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-11-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-11-04