Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Regional Cod Tagging Program >

Table: GMRI_COD_RELEASE

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34407 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags.

Description

Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags.

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)

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)

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

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 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.

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)

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

RELEASE_ID

TRIP_ID

FISH_LENGTH_UNIT_ID

HAUL_NUMBER

START_LONGITUDE

START_LATITUDE

END_LONGITUDE

END_LATITUDE

START_LORAN1

START_LORAN2

END_LORAN1

END_LORAN2

START_DATE

END_DATE

START_DEPTH

END_DEPTH

TEMP_SURFACE

TEMP_BOTTOM

CHECKING_SPAWN

TAGGER

USER_COMMENT

DATE_UNCERTAIN

LOCATION_UNCERTAIN

COUNT_SIZE_UNKNOWN

COUNT_SIZE_VSMALL

COUNT_SIZE_SMALL

COUNT_SIZE_MEDIUM

COUNT_SIZE_LARGE

COUNT_EGGS

COUNT_MILT

CLOSURE_AREA_ID

COUNT_TAGGED

COUNT_NONTAGGED

Catalog Details