Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Resource Assessment and Conservation Engineerin... > Shellfish Assessment Program > AFSC/RACE/SAP: Detailed Crab Data From NOAA Fis... >

EBSCRAB

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:23469 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	EBSCRAB
Short Name:	EBSCRAB
Status:	In Work
Abstract:	NA
Notes:	Loaded by FGDC Metadata Uploader, batch 5412, 02-26-2015 12:34

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CRAB
Description:	NA

Data Attributes

Attribute Summary

	Name	Type	Description
100	CRAB_ID	NUMBER	Unique number generated by Oracle that identifies each record in the CRAB.EBSCRAB table
100	HAULJOIN	NUMBER	NA
100	CRUISE	NUMBER	6-digit number assigned to each RACE survey cruise; first 4 digits identify cruise year
100	VESSEL	NUMBER	Numeric code assigned to each vessel participating in a RACE cruise (source: RACE ADP codebook)
100	HAUL	NUMBER	Number identifying a specific tow
100	STATION	Unknown	NA
100	SPECIES_CODE	NUMBER	5-digit number assigned to a species (source: RACE ADP codebook)
100	SPECIES_KFRC	NUMBER	Numeric code assigned to a species (source: NMFS Kodiak Shellfish Assessment Program)
100	SEX	VARCHAR2	1-digit numeric code assigned to a particular sex of crab
100	LENGTH	NUMBER	Carapace measurement, in millimeters, of king and hair crabs
100	WIDTH	NUMBER	Carapace measurement, in millimeters, of Chionoecetes and Dungeness crabs
100	SHELL_CONDITION	VARCHAR2	1-digit numeric code describing carapace condition of crab
100	EGG_COLOR	VARCHAR2	1-digit numeric code describing color of eggs in female crab
100	EGG_CONDITION	VARCHAR2	1-digit numeric code describing condition of eggs in female crab
100	CLUTCH_SIZE	VARCHAR2	1-digit numeric code describing fullness of clutch in female crab
100	WEIGHT	NUMBER	Weight, in grams, of individual crab
100	DISEASE_CODE	NUMBER	1-digit numeric code indicating presence of certain diseases in crab
100	DISEASE_DORSAL	NUMBER	If black mat disease is present, this 1-digit number describes percent of dorsal body surface covered by disease
100	DISEASE_VENTRAL	NUMBER	If black mat disease is present, this 1-digit number describes percent of ventral body surface covered by disease
100	DISEASE_LEGS	NUMBER	If black mat disease is present, this 1-digit number describes percent of leg surface covered by disease
100	SAMPLING_FACTOR	NUMBER	NA
100	CHELA_HEIGHT	NUMBER	Measurement, in millimeters, of height of right chela of crab
100	GIS_STATION	Unknown	NA
100	COMMENTS	Unknown	Any comments particular to that crab record or haul

Name

Type

Description

100

CRAB_ID

NUMBER

Unique number generated by Oracle that identifies each record in the CRAB.EBSCRAB table

100

HAULJOIN

NUMBER

100

CRUISE

NUMBER

6-digit number assigned to each RACE survey cruise; first 4 digits identify cruise year

100

VESSEL

NUMBER

Numeric code assigned to each vessel participating in a RACE cruise (source: RACE ADP codebook)

100

HAUL

NUMBER

Number identifying a specific tow

100

STATION

Unknown

100

SPECIES_CODE

NUMBER

5-digit number assigned to a species (source: RACE ADP codebook)

100

SPECIES_KFRC

NUMBER

Numeric code assigned to a species (source: NMFS Kodiak Shellfish Assessment Program)

100

SEX

VARCHAR2

1-digit numeric code assigned to a particular sex of crab

100

LENGTH

NUMBER

Carapace measurement, in millimeters, of king and hair crabs

100

WIDTH

NUMBER

Carapace measurement, in millimeters, of Chionoecetes and Dungeness crabs

100

SHELL_CONDITION

VARCHAR2

1-digit numeric code describing carapace condition of crab

100

EGG_COLOR

VARCHAR2

1-digit numeric code describing color of eggs in female crab

100

EGG_CONDITION

VARCHAR2

1-digit numeric code describing condition of eggs in female crab

100

CLUTCH_SIZE

VARCHAR2

1-digit numeric code describing fullness of clutch in female crab

100

WEIGHT

NUMBER

Weight, in grams, of individual crab

100

DISEASE_CODE

NUMBER

1-digit numeric code indicating presence of certain diseases in crab

100

DISEASE_DORSAL

NUMBER

If black mat disease is present, this 1-digit number describes percent of dorsal body surface covered by disease

100

DISEASE_VENTRAL

NUMBER

If black mat disease is present, this 1-digit number describes percent of ventral body surface covered by disease

100

DISEASE_LEGS

NUMBER

If black mat disease is present, this 1-digit number describes percent of leg surface covered by disease

100

SAMPLING_FACTOR

NUMBER

100

CHELA_HEIGHT

NUMBER

Measurement, in millimeters, of height of right chela of crab

100

GIS_STATION

Unknown

100

COMMENTS

Unknown

Any comments particular to that crab record or haul

Attribute Details

CRAB_ID

CC ID: 187834

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique number generated by Oracle that identifies each record in the CRAB.EBSCRAB table
Allowed Values:	NA - NA

HAULJOIN

CC ID: 187835

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	NA
Allowed Values:	NA - NA

CRUISE

CC ID: 187836

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	6-digit number assigned to each RACE survey cruise; first 4 digits identify cruise year
Allowed Values:	NA - NA

VESSEL

CC ID: 187837

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Numeric code assigned to each vessel participating in a RACE cruise (source: RACE ADP codebook)
Allowed Values:	NA - NA

HAUL

CC ID: 187838

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Number identifying a specific tow
Allowed Values:	NA - NA

STATION

CC ID: 187839

Data Storage Type:	Unknown
Required:	No
Primary Key:	No
Status:	Active
Description:	NA
Allowed Values:	unknown

SPECIES_CODE

CC ID: 187840

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	5-digit number assigned to a species (source: RACE ADP codebook)
Allowed Values:	NA - NA

SPECIES_KFRC

CC ID: 187841

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Numeric code assigned to a species (source: NMFS Kodiak Shellfish Assessment Program)
Allowed Values:	NA - NA

SEX

CC ID: 187842

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	1-digit numeric code assigned to a particular sex of crab
Allowed Values:	1, 2, 3, 4

LENGTH

CC ID: 187843

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Carapace measurement, in millimeters, of king and hair crabs
Allowed Values:	NA - NA

WIDTH

CC ID: 187844

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Carapace measurement, in millimeters, of Chionoecetes and Dungeness crabs
Allowed Values:	NA - NA

SHELL_CONDITION

CC ID: 187845

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	1-digit numeric code describing carapace condition of crab
Allowed Values:	0, 1, 2, 3, 4, 5, 9

EGG_COLOR

CC ID: 187846

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	1-digit numeric code describing color of eggs in female crab
Allowed Values:	0, 2, 3, 4, 5, 6, 7, 9

EGG_CONDITION

CC ID: 187847

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	1-digit numeric code describing condition of eggs in female crab
Allowed Values:	0, 1, 2, 3, 4, 9

CLUTCH_SIZE

CC ID: 187848

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	1-digit numeric code describing fullness of clutch in female crab
Allowed Values:	0, 1, 2, 3, 4, 5, 6, 9

WEIGHT

CC ID: 187849

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Weight, in grams, of individual crab
Allowed Values:	NA - NA

DISEASE_CODE

CC ID: 187850

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	1-digit numeric code indicating presence of certain diseases in crab
Allowed Values:	NA - NA

DISEASE_DORSAL

CC ID: 187851

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	If black mat disease is present, this 1-digit number describes percent of dorsal body surface covered by disease
Allowed Values:	NA - NA

DISEASE_VENTRAL

CC ID: 187852

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	If black mat disease is present, this 1-digit number describes percent of ventral body surface covered by disease
Allowed Values:	NA - NA

DISEASE_LEGS

CC ID: 187853

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	If black mat disease is present, this 1-digit number describes percent of leg surface covered by disease
Allowed Values:	NA - NA

SAMPLING_FACTOR

CC ID: 187854

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	NA
Allowed Values:	NA - NA

CHELA_HEIGHT

CC ID: 187855

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Measurement, in millimeters, of height of right chela of crab
Allowed Values:	NA - NA

GIS_STATION

CC ID: 187856

Data Storage Type:	Unknown
Required:	No
Primary Key:	No
Status:	Active
Description:	NA
Allowed Values:	unknown

COMMENTS

CC ID: 187857

Data Storage Type:	Unknown
Required:	No
Primary Key:	No
Status:	Active
Description:	Any comments particular to that crab record or haul
Allowed Values:	unknown

Catalog Details

Catalog Item ID:	23469
GUID:	gov.noaa.nmfs.inport:23469
Metadata Record Created By:	Nancy Roberson
Metadata Record Created:	2015-02-26 12:34+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2018-11-26
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2018-11-26
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2019-11-26