Table: FOREIGN_CRAB_MATURITY
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 9563
| Published / External
Created: 2009-06-29
|
Last Modified: 2022-08-09
Parent: AFSC/FMA/North Pacific Observer Foreign Fishing
Data Set (DS) | ID: 9556
Data Set (DS) | ID: 9556
ID: 9563
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | Table: FOREIGN_CRAB_MATURITY |
|---|---|
| Short Name | FOREIGN_CRAB_MATURITY |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981. |
| * Purpose | |
| Notes |
Loaded by batch 2364, 06-29-2009 18:15 |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data Table |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | NORPAC |
| » Description |
This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981. |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | No | CRUISE | NUMBER | A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
| 100 | Yes | No | VESSEL | VARCHAR2 | A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. |
| 100 | Yes | No | DT | DATE | Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). |
| 100 | Yes | No | YEAR | NUMBER | A four-digit number identifying the year in which the gear retrieval of the haul began. |
| 100 | Yes | No | HAUL | NUMBER | A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days. |
| 100 | Yes | No | SPECIES | NUMBER | A three-digit numeric code representing a marine species. |
| 100 | Yes | No | SEX | VARCHAR2 | A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. |
| 100 | Yes | No | CARAPACE_LENGTH | NUMBER | Observed length (cm) of the carapace of the specimen. |
| 100 | No | No | CHELA_HEIGHT | NUMBER | Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface. |
| 100 | No | No | FEMALE_CRAB_MATURITY | NUMBER | A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases. |
| 100 | No | No | FILENAME | VARCHAR2 | The original filename on the Burroughs computer system from which this data record came. |
| 100 | Yes | No | HAUL_JOIN | NUMBER | An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table. |
| 100 | Yes | Yes | PK_FCM | NUMBER | For internall use only. |
Attribute Details
| Attribute Name | CRUISE |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations |
NORPAC.FOREIGN_FISHING_OPERATI |
| Derivation | |
| Validation Rules |
| Attribute Name | VESSEL |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations |
Refers to more than one entity |
| Derivation | |
| Validation Rules |
| Attribute Name | DT |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). |
| General Data Type | DATE |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | YEAR |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
A four-digit number identifying the year in which the gear retrieval of the haul began. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HAUL |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SPECIES |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
A three-digit numeric code representing a marine species. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations |
NORPAC.DOMESTIC_SPECIES |
| Derivation | |
| Validation Rules |
| Attribute Name | SEX |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CARAPACE_LENGTH |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Observed length (cm) of the carapace of the specimen. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CHELA_HEIGHT |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FEMALE_CRAB_MATURITY |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | 0 |
| Status | Active |
| Description |
A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations |
NORPAC.FOREIGN_CRAB_MATURITY_C |
| Derivation | |
| Validation Rules |
| Attribute Name | FILENAME |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | VARCHAR2 |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The original filename on the Burroughs computer system from which this data record came. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HAUL_JOIN |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 6 |
| Scale | 0 |
| Status | Active |
| Description |
An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations |
NORPAC.FOREIGN_HAUL |
| Derivation | |
| Validation Rules |
| Attribute Name | PK_FCM |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | Yes |
| Precision | 6 |
| Scale | 0 |
| Status | Active |
| Description |
For internall use only. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 9563 |
|---|---|
| Metadata Record Created By | Doug Turnbull |
| Metadata Record Created | 2009-06-29 18:15+0000 |
| Metadata Record Last Modified By | SysAdmin InPortAdmin |
| » Metadata Record Last Modified | 2022-08-09 17:11+0000 |
| Metadata Record Published | 2016-05-18 |
| Owner Org | AFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2016-05-18 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2017-05-18 |
| Tags |
|---|