Table: GMRI_COD_RELEASE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34407 | Updated: August 9, 2022 | Published / External
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
CC ID: 345530
| 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
CC ID: 345541
| 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
CC ID: 345552
| 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
CC ID: 345557
| 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
CC ID: 345558
| 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
CC ID: 345559
| 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
CC ID: 345560
| 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
CC ID: 345561
| 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
CC ID: 345562
| 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
CC ID: 345531
| 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
CC ID: 345532
| 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
CC ID: 345533
| 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
CC ID: 345534
| 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
CC ID: 345535
| 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
CC ID: 345536
| 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
CC ID: 345537
| 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
CC ID: 345538
| 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
CC ID: 345539
| 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
CC ID: 345540
| 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
CC ID: 345542
| 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
CC ID: 345543
| 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
CC ID: 345544
| 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
CC ID: 345545
| 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
CC ID: 345546
| 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
CC ID: 345547
| 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
CC ID: 345548
| 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
CC ID: 345549
| 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
CC ID: 345550
| 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
CC ID: 345551
| 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
CC ID: 345553
| 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
CC ID: 345554
| 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
CC ID: 345555
| 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
CC ID: 345556
| 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 |