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