Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

NA

Description

NA

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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

Rubric Score Primary Key? 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

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