Table: GMRI_COD_RELEASE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34407 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags.
DescriptionSpecific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RELEASE_ID
NUMBER |
Unique ID – identifies a specific haul |
TRIP_ID
NUMBER |
Identifies trip associated with this haul - from COD_TRIP data table |
FISH_LENGTH_UNIT_ID
NUMBER |
Identifies measurement units used (inches or centimeters) – from COD_UNIT LUT |
HAUL_NUMBER
NUMBER |
Haul number entered by user |
START_LONGITUDE
FLOAT |
Starting longitude of haul (redacted) |
START_LATITUDE
FLOAT |
Starting latitude of haul (redacted) |
END_LONGITUDE
FLOAT |
Ending longitude of haul (redacted) |
END_LATITUDE
FLOAT |
Ending latitude of haul (redacted) |
START_LORAN1
FLOAT |
Starting LORAN 1 coordinate (redacted) |
START_LORAN2
FLOAT |
Starting LORAN 2 coordinate (redacted) |
END_LORAN1
FLOAT |
Ending LORAN 1 coordinate (redacted) |
END_LORAN2
FLOAT |
Ending LORAN 2 coordinate (redacted) |
START_DATE
DATE |
Date haul began |
END_DATE
DATE |
Date haul ended |
START_DEPTH
FLOAT |
Depth of haul at beginning |
END_DEPTH
FLOAT |
Depth of haul at the end |
TEMP_SURFACE
FLOAT |
Surface water temperature |
TEMP_BOTTOM
FLOAT |
Bottom water temperature |
CHECKING_SPAWN
NUMBER |
0= Tagger is not checking for spawn 1= Tagger is checking for spawn |
TAGGER
VARCHAR2 |
Tagger'’s name |
USER_COMMENT
VARCHAR2 |
Miscellaneous comments |
DATE_UNCERTAIN
NUMBER |
0= Date is accurate 1= Date is uncertain 2= Date is REALLY uncertain |
LOCATION_UNCERTAIN
NUMBER |
0= Location coordinates are accurate 1= Location coordinates are estimated |
COUNT_SIZE_UNKNOWN
NUMBER |
Total number of fish of unknown size - Calculated during trip approval |
COUNT_SIZE_VSMALL
NUMBER |
Total number of very small fish (0-30 cm) Calculated during trip approval |
COUNT_SIZE_SMALL
NUMBER |
Total number of small fish (30-50 cm) Calculated during trip approval |
COUNT_SIZE_MEDIUM
NUMBER |
Total number of medium fish (50-80 cm) Calculated during trip approval |
COUNT_SIZE_LARGE
NUMBER |
Total number of large fish (80+ cm) Calculated during trip approval |
COUNT_EGGS
NUMBER |
Total number of fish with eggs Calculated during trip approval |
COUNT_MILT
NUMBER |
Total number of fish with milt Calculated during trip approval |
CLOSURE_AREA_ID
NUMBER |
Identifies groundfish closure area where haul took place (if applicable) – from COD_CLOSURE_AREA LUT |
COUNT_TAGGED
NUMBER |
Number of fish tagged per haul |
COUNT_NONTAGGED
NUMBER |
Number of fish assigned a non-tag ID per haul (e.g. poor condition, undersized fish) |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: GMRI_COD_RELEASE |
---|---|
Short Name: | GMRI_COD_RELEASE |
Status: | Completed |
Abstract: |
Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags. |
Notes: |
Loaded by batch 9211, 08-23-2016 14:45 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CO_OP_RESEARCH |
Description: |
Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RELEASE_ID | NUMBER | Unique ID – identifies a specific haul | |
100
|
TRIP_ID | NUMBER | Identifies trip associated with this haul - from COD_TRIP data table | |
100
|
FISH_LENGTH_UNIT_ID | NUMBER | Identifies measurement units used (inches or centimeters) – from COD_UNIT LUT | |
100
|
HAUL_NUMBER | NUMBER | Haul number entered by user | |
100
|
START_LONGITUDE | FLOAT | Starting longitude of haul (redacted) | |
100
|
START_LATITUDE | FLOAT | Starting latitude of haul (redacted) | |
100
|
END_LONGITUDE | FLOAT | Ending longitude of haul (redacted) | |
100
|
END_LATITUDE | FLOAT | Ending latitude of haul (redacted) | |
100
|
START_LORAN1 | FLOAT | Starting LORAN 1 coordinate (redacted) | |
100
|
START_LORAN2 | FLOAT | Starting LORAN 2 coordinate (redacted) | |
100
|
END_LORAN1 | FLOAT | Ending LORAN 1 coordinate (redacted) | |
100
|
END_LORAN2 | FLOAT | Ending LORAN 2 coordinate (redacted) | |
100
|
START_DATE | DATE | Date haul began | |
100
|
END_DATE | DATE | Date haul ended | |
100
|
START_DEPTH | FLOAT | Depth of haul at beginning | |
100
|
END_DEPTH | FLOAT | Depth of haul at the end | |
100
|
TEMP_SURFACE | FLOAT | Surface water temperature | |
100
|
TEMP_BOTTOM | FLOAT | Bottom water temperature | |
100
|
CHECKING_SPAWN | NUMBER | 0= Tagger is not checking for spawn 1= Tagger is checking for spawn | |
100
|
TAGGER | VARCHAR2 | Tagger'’s name | |
100
|
USER_COMMENT | VARCHAR2 | Miscellaneous comments | |
100
|
DATE_UNCERTAIN | NUMBER | 0= Date is accurate 1= Date is uncertain 2= Date is REALLY uncertain | |
100
|
LOCATION_UNCERTAIN | NUMBER | 0= Location coordinates are accurate 1= Location coordinates are estimated | |
100
|
COUNT_SIZE_UNKNOWN | NUMBER | Total number of fish of unknown size - Calculated during trip approval | |
100
|
COUNT_SIZE_VSMALL | NUMBER | Total number of very small fish (0-30 cm) Calculated during trip approval | |
100
|
COUNT_SIZE_SMALL | NUMBER | Total number of small fish (30-50 cm) Calculated during trip approval | |
100
|
COUNT_SIZE_MEDIUM | NUMBER | Total number of medium fish (50-80 cm) Calculated during trip approval | |
100
|
COUNT_SIZE_LARGE | NUMBER | Total number of large fish (80+ cm) Calculated during trip approval | |
100
|
COUNT_EGGS | NUMBER | Total number of fish with eggs Calculated during trip approval | |
100
|
COUNT_MILT | NUMBER | Total number of fish with milt Calculated during trip approval | |
100
|
CLOSURE_AREA_ID | NUMBER | Identifies groundfish closure area where haul took place (if applicable) – from COD_CLOSURE_AREA LUT | |
100
|
COUNT_TAGGED | NUMBER | Number of fish tagged per haul | |
100
|
COUNT_NONTAGGED | NUMBER | Number of fish assigned a non-tag ID per haul (e.g. poor condition, undersized fish) |
Attribute Details
RELEASE_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Unique ID – identifies a specific haul |
General Data Type: | NUMBER |
TRIP_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Identifies trip associated with this haul - from COD_TRIP data table |
General Data Type: | NUMBER |
FISH_LENGTH_UNIT_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Identifies measurement units used (inches or centimeters) – from COD_UNIT LUT |
General Data Type: | NUMBER |
HAUL_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Haul number entered by user |
General Data Type: | NUMBER |
START_LONGITUDE
Seq. Order: | 5 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Starting longitude of haul (redacted) |
General Data Type: | FLOAT |
START_LATITUDE
Seq. Order: | 6 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Starting latitude of haul (redacted) |
General Data Type: | FLOAT |
END_LONGITUDE
Seq. Order: | 7 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Ending longitude of haul (redacted) |
General Data Type: | FLOAT |
END_LATITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Ending latitude of haul (redacted) |
General Data Type: | FLOAT |
START_LORAN1
Seq. Order: | 9 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Starting LORAN 1 coordinate (redacted) |
General Data Type: | FLOAT |
START_LORAN2
Seq. Order: | 10 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Starting LORAN 2 coordinate (redacted) |
General Data Type: | FLOAT |
END_LORAN1
Seq. Order: | 11 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Ending LORAN 1 coordinate (redacted) |
General Data Type: | FLOAT |
END_LORAN2
Seq. Order: | 12 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Ending LORAN 2 coordinate (redacted) |
General Data Type: | FLOAT |
START_DATE
Seq. Order: | 13 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date haul began |
General Data Type: | DATE |
END_DATE
Seq. Order: | 14 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date haul ended |
General Data Type: | DATE |
START_DEPTH
Seq. Order: | 15 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Depth of haul at beginning |
General Data Type: | FLOAT |
END_DEPTH
Seq. Order: | 16 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Depth of haul at the end |
General Data Type: | FLOAT |
TEMP_SURFACE
Seq. Order: | 17 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Surface water temperature |
General Data Type: | FLOAT |
TEMP_BOTTOM
Seq. Order: | 18 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Bottom water temperature |
General Data Type: | FLOAT |
CHECKING_SPAWN
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
0= Tagger is not checking for spawn 1= Tagger is checking for spawn |
General Data Type: | NUMBER |
TAGGER
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tagger'’s name |
General Data Type: | VARCHAR2 |
USER_COMMENT
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1020 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Miscellaneous comments |
General Data Type: | VARCHAR2 |
DATE_UNCERTAIN
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
0= Date is accurate 1= Date is uncertain 2= Date is REALLY uncertain |
General Data Type: | NUMBER |
LOCATION_UNCERTAIN
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
0= Location coordinates are accurate 1= Location coordinates are estimated |
General Data Type: | NUMBER |
COUNT_SIZE_UNKNOWN
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of fish of unknown size - Calculated during trip approval |
General Data Type: | NUMBER |
COUNT_SIZE_VSMALL
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of very small fish (0-30 cm) Calculated during trip approval |
General Data Type: | NUMBER |
COUNT_SIZE_SMALL
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of small fish (30-50 cm) Calculated during trip approval |
General Data Type: | NUMBER |
COUNT_SIZE_MEDIUM
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of medium fish (50-80 cm) Calculated during trip approval |
General Data Type: | NUMBER |
COUNT_SIZE_LARGE
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of large fish (80+ cm) Calculated during trip approval |
General Data Type: | NUMBER |
COUNT_EGGS
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of fish with eggs Calculated during trip approval |
General Data Type: | NUMBER |
COUNT_MILT
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of fish with milt Calculated during trip approval |
General Data Type: | NUMBER |
CLOSURE_AREA_ID
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Identifies groundfish closure area where haul took place (if applicable) – from COD_CLOSURE_AREA LUT |
General Data Type: | NUMBER |
COUNT_TAGGED
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fish tagged per haul |
General Data Type: | NUMBER |
COUNT_NONTAGGED
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fish assigned a non-tag ID per haul (e.g. poor condition, undersized fish) |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 34407 |
---|---|
GUID: | gov.noaa.nmfs.inport:34407 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-08-23 14:45+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-02-24 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-02-24 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-02-24 |