TRIP_DATA
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 35896
| Published / External
Created: 2016-12-07
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 26273
ID: 35896
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | TRIP_DATA |
---|---|
Short Name | TRIP_DATA |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES. |
* Purpose | |
Notes | |
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 | |
» Description |
This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | FISH_ID_CODE | VARCHAR2 | Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE |
100 | No | No | TRIP_IDENTIFIER_BARCODE | VARCHAR2 | Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES. |
100 | Yes | No | SPECIES_ITIS | VARCHAR2 | Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES |
100 | No | No | START_SET_DATE_GMT | DATE | Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort |
100 | No | No | START_SET_LAT | NUMBER | Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) |
100 | No | No | START_SET_LON | NUMBER | Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) |
100 | No | No | END_SET_DATE_GMT | DATE | Datetime (UTC) when setting of the gear has stopped and the gear begins to fish |
100 | No | No | END_SET_LAT | NUMBER | Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) |
100 | No | No | END_SET_LON | NUMBER | Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) |
100 | No | No | START_HAUL_DATE_GMT | DATE | Datetime (UTC) when fishing stops and hauling the gear starts |
100 | No | No | START_HAUL_LAT | NUMBER | Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) |
100 | No | No | START_HAUL_LON | NUMBER | Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) |
100 | No | No | END_HAUL_DATE_GMT | DATE | Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel |
100 | No | No | END_HAUL_LAT | NUMBER | Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) |
100 | No | No | END_HAUL_LON | NUMBER | Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) |
100 | No | No | DEPTH | NUMBER | Fishing depth of the gear |
100 | No | No | DEPTH_UOM | VARCHAR2 | Unit of measure for DEPTH |
100 | No | No | TEMP | NUMBER | Not used |
100 | Yes | No | FA_AREA_CODE | VARCHAR2 | ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table. |
100 | Yes | No | FA_SUB_AREA_CODE | VARCHAR2 | ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table. |
100 | Yes | No | SBR_REQUEST_ID | VARCHAR2 | Unique biosample request identification number |
100 | No | No | LINK | VARCHAR2 | Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE. |
100 | No | No | FVTR_TRIP_ID | NUMBER | Unique trip identifier generated in FLDRS software |
100 | Yes | No | ELB_EFFORT_NUM | VARCHAR2 | Unique effort identifier within a trip |
100 | No | No | TRIP_ID | NUMBER | Unique trip identifier generated in FLDRS software |
100 | No | No | EFFORT_NUM | VARCHAR2 | Unique effort identifier within a trip |
100 | No | No | CALC_DUR_HR | DATE | Duration of the effort in hours |
100 | No | No | CALC_DIST_NM | NUMBER | Total distance towed in nautical miles |
100 | No | No | MIN_TEMP_C | NUMBER | Min temperature in Celsius |
100 | No | No | MEAN_TEMP_C | NUMBER | Mean temperature in Celsius |
100 | No | No | MAX_TEMP_C | NUMBER | Max temperature in Celsius |
100 | No | No | MIN_DPTH_M | NUMBER | Min depth in meters |
100 | No | No | MEAN_DPTH_M | NUMBER | Mean depth in meters |
100 | No | No | MAX_DPTH_M | NUMBER | Max depth in meters |
100 | No | No | MIN_SPD_NMPH | NUMBER | Min vessel speed in nautical miles per hour |
100 | No | No | MEAN_SPD_NMPH | NUMBER | Mean vessel speed in nautical miles per hour |
100 | No | No | MAX_SPD_NMPH | NUMBER | Max vessel speed in nautical miles per hour |
100 | No | No | GTE_CODE | VARCHAR2 | GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES |
100 | No | No | GEAR_CODE | VARCHAR2 | Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets |
Attribute Details
Attribute Name | FISH_ID_CODE |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE |
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 | TRIP_IDENTIFIER_BARCODE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES. |
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 | SPECIES_ITIS |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 11 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES |
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 | START_SET_DATE_GMT |
---|---|
Seq. Order | 51 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort |
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 | START_SET_LAT |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 6 |
Status | Active |
Description |
Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) |
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 | START_SET_LON |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 6 |
Status | Active |
Description |
Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) |
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 | END_SET_DATE_GMT |
---|---|
Seq. Order | 54 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when setting of the gear has stopped and the gear begins to fish |
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 | END_SET_LAT |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | 6 |
Status | Active |
Description |
Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) |
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 | END_SET_LON |
---|---|
Seq. Order | 56 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 6 |
Status | Active |
Description |
Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) |
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 | START_HAUL_DATE_GMT |
---|---|
Seq. Order | 57 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when fishing stops and hauling the gear starts |
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 | START_HAUL_LAT |
---|---|
Seq. Order | 58 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | 6 |
Status | Active |
Description |
Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) |
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 | START_HAUL_LON |
---|---|
Seq. Order | 59 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 6 |
Status | Active |
Description |
Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) |
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 | END_HAUL_DATE_GMT |
---|---|
Seq. Order | 60 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel |
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 | END_HAUL_LAT |
---|---|
Seq. Order | 61 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | 6 |
Status | Active |
Description |
Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) |
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 | END_HAUL_LON |
---|---|
Seq. Order | 62 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 6 |
Status | Active |
Description |
Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) |
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 | DEPTH |
---|---|
Seq. Order | 63 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Fishing depth of the gear |
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 | DEPTH_UOM |
---|---|
Seq. Order | 64 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure for DEPTH |
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 | TEMP |
---|---|
Seq. Order | 65 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | 2 |
Status | Active |
Description |
Not used |
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 | FA_AREA_CODE |
---|---|
Seq. Order | 66 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table. |
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 | FA_SUB_AREA_CODE |
---|---|
Seq. Order | 67 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table. |
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 | SBR_REQUEST_ID |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique biosample request identification 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 | |
Derivation | |
Validation Rules |
Attribute Name | LINK |
---|---|
Seq. Order | 69 |
Data Storage Type | VARCHAR2 |
Max Length | 21 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE. |
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 | FVTR_TRIP_ID |
---|---|
Seq. Order | 70 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 14 |
Scale | 0 |
Status | Active |
Description |
Unique trip identifier generated in FLDRS software |
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 | ELB_EFFORT_NUM |
---|---|
Seq. Order | 71 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique effort identifier within a trip |
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 | TRIP_ID |
---|---|
Seq. Order | 72 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Unique trip identifier generated in FLDRS software |
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 | EFFORT_NUM |
---|---|
Seq. Order | 73 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique effort identifier within a trip |
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 | CALC_DUR_HR |
---|---|
Seq. Order | 74 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Duration of the effort in hours |
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 | CALC_DIST_NM |
---|---|
Seq. Order | 75 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 2 |
Status | Active |
Description |
Total distance towed in nautical miles |
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 | MIN_TEMP_C |
---|---|
Seq. Order | 76 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Min temperature in Celsius |
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 | MEAN_TEMP_C |
---|---|
Seq. Order | 77 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Mean temperature in Celsius |
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 | MAX_TEMP_C |
---|---|
Seq. Order | 78 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Max temperature in Celsius |
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 | MIN_DPTH_M |
---|---|
Seq. Order | 79 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 2 |
Status | Active |
Description |
Min depth in meters |
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 | MEAN_DPTH_M |
---|---|
Seq. Order | 80 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 2 |
Status | Active |
Description |
Mean depth in meters |
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 | MAX_DPTH_M |
---|---|
Seq. Order | 81 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 2 |
Status | Active |
Description |
Max depth in meters |
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 | MIN_SPD_NMPH |
---|---|
Seq. Order | 82 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Min vessel speed in nautical miles per hour |
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 | MEAN_SPD_NMPH |
---|---|
Seq. Order | 83 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Mean vessel speed in nautical miles per hour |
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 | MAX_SPD_NMPH |
---|---|
Seq. Order | 84 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 2 |
Status | Active |
Description |
Max vessel speed in nautical miles per hour |
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 | GTE_CODE |
---|---|
Seq. Order | 85 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES |
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 | GEAR_CODE |
---|---|
Seq. Order | 86 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets |
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 | |
---|---|
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
* » 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 | 35896 |
---|---|
Metadata Record Created By | Patricia L Jones |
Metadata Record Created | 2016-12-07 13:28+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-12-07 |
Owner Org | NEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-12-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-12-07 |
Tags |
---|