Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Swordfish Stomach Content Data, 1989-2000 >

EDIT_SWO_STOMACH_FISH

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:55423  |  Updated: August 9, 2022  |  Published / External 
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