Table: ALS_USVI_LANDING_ALL
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 37464
| Published / External
Created: 2017-03-28
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 1920
ID: 37464
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: ALS_USVI_LANDING_ALL |
---|---|
Short Name | ALS_USVI_LANDING_ALL |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table represents the entire set of commercial landings from the USVI. It is a combination of 4 tables. From most historical to most recent they are: 1. ALS.USVI_STT_GEAR_FORM_LANDINGS (1 and 2 are concurrent and represent historical 'gear-based' forms: 1. for St. Thomas and 2. for St. Croix. These forms were used from July 1974 until June 1999. They lack species information except for conch and spiny lobster. This table is a compilation of all gear-based forms submitted. Forms were typically submitted as excel speadsheets on a yearly basis. 2. ALS.USVI_STX_GEAR_FORM_LANDINGS (see description in (1)). 3. ALS.USVI_SPECIES_GROUPS_FORMS_ALL: These forms were in use from July 1995 through June of 2011. There is some overlap with the gear-based forms from July 1995 - June 1999. The forms are 'species-based' or more properly, 'family-based' as they primarily represent family taxa such as 'Groupers', 'Snappers', 'Grunts', etc. The family definitions were not previously available in the gear-based forms as already noted, except for conch and spiny lobster. 4. JBENNETT.EXTRACT_FROM_CCL_USVI: The Caribbean Commercial Landings (CCL) logbook forms came into use in July 2011. These include information as to the actual species (ex. Silk Snapper as opposed to 'Snappers'). They also include improved effort information. There were slight changes in the forms from then until now, but the data set remained basically the same. The ALS_USVI_LANDINGS_ALL table re-formats the historical data to fit in as much as possible with the current data; however, there is discontinuity regarding species information as already noted. Remember that most actual species codes go back only to July 2011. Prior to that the coding was for species groups, and before that only finfish, lobster, conch. Please bear these things in mind when accessing the data. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | Commercial Landings |
None | fish |
None | Fisheries |
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | 1974 |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | Carribbean |
None | EEZ |
None | Puerto Rico |
None | territorial waters |
None | Virgin Islands |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | area |
None | Catch |
None | fishing gear |
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 | JBENNETT |
» Description |
Provided in the abstract. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | TRIP_ID | VARCHAR2 | The ID number of the trip. The original ID from the trip is prefixed with the island and form type along with the trip id existing in the original table (example: 'STT_GEAR'||TRIM(TO_CHAR(ID,'99999999') using the trip_id the original record from the USVI-submitted file can be accessed in the column 'original_record_id' in the original tables which are combined in the oracle tables ALS.USVI_ST*_gear_form_landings, ALS.USVI_SPECIES_GROUP_FORMS_ALL, and jbennett.EXTRACT_FROM_CCL_USVI. Both island groups are processed the same way. |
100 | No | No | TRIP_YEAR | VARCHAR2 | The year the catch was landed. |
100 | No | No | TRIP_MONTH | VARCHAR2 | The month the catch was landed. |
100 | No | No | TRIP_DAY | VARCHAR2 | The calendar day the trip landed. |
100 | No | No | VESSEL_CD | VARCHAR2 | The state (territorial) id or the USCG id of the fishing craft. |
100 | No | No | FISHER_PERMIT | VARCHAR2 | The territorial permit (license) number of the fisher. This is island-dependent. |
100 | No | No | FISHER_FIRST_NAME | VARCHAR2 | The first name of the fisher. |
100 | No | No | FISHER_LAST_NAME | VARCHAR2 | The last name of the fisher. |
100 | No | No | TRIP_TICKET_NUMBER | VARCHAR2 | The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered. |
100 | No | No | TIP_INTERVIEW_TAKEN | VARCHAR2 | Indicates whether or not a dockside sample was taken for this trip. |
100 | No | No | TIP_INTERVIEW_NUMBER | NUMBER | If a dockside sample was taken what was the interview number of the sample. This column is designed to be filled in manually. It is currently not in use. |
100 | No | No | DAY_OR_NIGHT | VARCHAR2 | Did the majority of the fishing take place at night or during the day? |
100 | No | No | FEDERAL_OR_STATE_WATERS | VARCHAR2 | If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters trip. |
100 | No | No | CHARTER_TRIP | VARCHAR2 | Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips. |
100 | No | No | NUM_PARTNERS_OR_HELPERS | VARCHAR2 | Number of fishers and/or helpers on board besides the primary fisher. |
100 | No | No | IS_CATCH_SPLIT | VARCHAR2 | Was part of the catch from this trip recorded on another fisher's report? |
100 | No | No | ISLAND | VARCHAR2 | The island or island group where the catch was landed. |
100 | No | No | LANDING_AREA_COUNTY | VARCHAR2 | The Island (not a county) where the catch was landed. |
100 | No | No | LANDING_AREA_NAME | VARCHAR2 | The name of the location where the catch was landed. |
100 | No | No | TOTAL_TRIP_POUNDS | NUMBER | The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped not summed. |
100 | No | No | TOTAL_TRAPS_IN_WATER | NUMBER | The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable. |
100 | No | No | RECORD_STATUS | VARCHAR2 | Is trip completely entered? |
100 | No | No | AREA_CD1 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD2 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD3 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD4 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD5 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD6 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD7 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD8 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD9 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | AREA_CD10 | VARCHAR2 | Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip. |
100 | No | No | FAD_CD | VARCHAR2 | The USVI code for the Fish Attraction Device (if any) fished. |
100 | No | No | HOURS_FISHED | NUMBER | Hours actively fishing on the fishing grounds. |
100 | No | No | DEPTH | NUMBER | The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom). |
100 | No | No | DEPTH_UOM | VARCHAR2 | Designates the bottom depth units in feet or fathoms. |
100 | No | No | TRAP_SOAK_TIME_HRS | NUMBER | Hours traps were soaking on the fishing ground prior to haul. |
100 | No | No | GEAR_TYPE_NM | VARCHAR2 | Name of the general gear type. Traps, Hook and Line, Nets, or DIving. |
100 | No | No | GEAR_NM | VARCHAR2 | The specific gear name. |
100 | No | No | GEAR_QTY_OLD | VARCHAR2 | Gear quantities from the historical gear based forms for fish and lobster traps. |
100 | No | No | GEAR_QTY2 | VARCHAR2 | A null field. |
100 | No | No | GEAR_QTY3 | VARCHAR2 | A null field |
100 | No | No | GEAR_QTY__UOM | VARCHAR2 | a null field |
100 | No | No | SPECIES_FAMILY_CD | VARCHAR2 | The general code for the fish family if the catch is at species, genus, or family level. |
100 | No | No | SPECIES_CD | VARCHAR2 | The species code. Species codes for most species are not in the data until July 2011 when the latest version of the log report forms came out. Prior to that the forms showed mostly families or more general groupings. |
100 | No | No | SPECIES_NM | VARCHAR2 | The species name. Not at species level for most species until July 2011 when new forms were introduced. |
100 | No | No | POUNDS_LANDED | NUMBER | The pounds of catch landed. |
100 | No | No | POUNDS_CONDITION | VARCHAR2 | Refers to condition of landing. Whole, gutted,etc. Only available after July 2011. |
100 | No | No | FORM_TYPE | VARCHAR2 | The form type. Reporting forms have changed over the years. |
100 | No | No | DISCARD_FISH_LIVE_CNT | NUMBER | Sum of numbers (not pounds) of discarded fish (live). Available since 2003. |
100 | No | No | DISCARD_FISH_DEAD_CNT | NUMBER | Sum of numbers (not pounds) of discarded fish (dead). Available since 2003. |
100 | No | No | DISCARD_LOBSTER_LIVE_CNT | NUMBER | Sum of numbers (not pounds) of discarded lobster (live). Available since 2003. |
100 | No | No | DISCARD_LOBSTER_DEAD_CNT | NUMBER | Sum of numbers (not pounds) of discarded lobster (dead). Available since 2003. |
100 | No | No | SOURCE_FILE | VARCHAR2 | The original submission file name (typically in Excel format). |
100 | No | No | ORIGINAL_DATE | VARCHAR2 | The original date on which the source file was submitted. |
100 | No | No | FISHING_YEAR | VARCHAR2 | The license fishing year from July 1 - June 30 |
100 | No | No | SPECIES_GRADE | VARCHAR2 | For the historical gear-based forms the species grades are: SNAPPER-GROUPER, NOT SNAPPER-GROUPER, UNCLASSIFIED, and BAITFISH. For the historical species group-based forms the species grades are: BAITFISH, PELAGIC, RELEASED, and UNCLASSIFIED. |
100 | No | No | GEAR1_NAME | VARCHAR2 | Primary Gear used in the species group-based reporting forms. |
100 | No | No | GEAR1_NUM | VARCHAR2 | Quantity of primary gear used in the species group-based reporting forms. |
100 | No | No | GEAR2_NAME | VARCHAR2 | Secondary gear used in the historical species group-based reporting forms. |
100 | No | No | GEAR2_NUM | VARCHAR2 | Quantity of secondary gear used in the historical species group-based reporting forms. |
100 | No | No | LINES_CNT | NUMBER | From the historical species group-based forms and the more recent CCL forms. The number of total number of lines fished |
100 | No | No | HOOKS_PER_LINE_CNT | NUMBER | Average number of hooks per line. Only available on the recent CCL forms. |
100 | No | No | FAD_NUM | VARCHAR2 | The number of the Fish Attractant Device fished. Only from the more recent forms after July 2011. |
100 | No | No | LOBSTER_TRAPS_HAULED | NUMBER | The number of Lobster Traps hauled for the trip. Available on historical gear-based forms from 1995-1998 and on more recent CCL forms from JUly 2011 and more recent. |
100 | No | No | FISH_TRAPS_HAULED | NUMBER | The number of fish traps hauled for the trip. Available from the historical gear-based forms from 1990-1999 and from the recent CCL forms from JUly 2011 and more recent. |
100 | No | No | FISH_TRAPS_HOURS_SOAKED | NUMBER | The hours the fish traps soaked on the fishing grounds from set to haul. Only from the more recent forms July 2011 and more recent. |
100 | No | No | LOBSTER_TRAPS_DAYS_SOAKED | NUMBER | Lobster traps days soaked from set to haul. Only from July 2011 and more recent. |
100 | No | No | FISH_TRAPS_DAYS_SOAKED | NUMBER | FIsh trap days soaked from set to haul. only from July 2011 and more recent. |
100 | No | No | NET_LENGTH | NUMBER | Net length in feet or fathoms from July 2011 and more recent |
100 | No | No | MESH_IN | NUMBER | Diagonal Net mesh size in inches. July 2011 and more recent. |
100 | No | No | NET_CNT | NUMBER | Number of nets. From species group-based forms 1995-June 2011 and CCL forms July 2011 and more recent. |
100 | No | No | LENGTH_UOM | VARCHAR2 | The net length unit of measure (feet or fathoms). |
100 | No | No | DIVERS_CNT | NUMBER | The total number of divers. From historical species group-based forms 1996-June 2011 and from CCL forms July 2011 and more recent. |
100 | No | No | DIVES_CNT | NUMBER | Total number of dives. July 2011 and more recent. |
100 | No | No | IS_SCUBA | VARCHAR2 | Were dives made using SCUBA? |
100 | No | No | REGION_PERMIT_NUM_PARTNER1 | VARCHAR2 | Permit Number of fishing partner 1 (if applicable). July 2011 and more recent. |
100 | No | No | FISHER_FIRST_NM_PARTNER1 | VARCHAR2 | First name of fishing partner 1 (if applicable). July 2011 and more recent. |
100 | No | No | FISHER_LAST_NM_PARTNER1 | VARCHAR2 | Last Name of fishing partner 1 (if applicable). July 2011 and more recent. |
100 | No | No | REGION_PERMIT_NUM_PARTNER2 | VARCHAR2 | Permit Number of fishing partner 2 (if applicable). July 2011 and more recent. |
100 | No | No | FISHER_FIRST_NM_PARTNER2 | VARCHAR2 | First name of fishing partner 2 (if applicable). July 2011 and more recent. |
100 | No | No | FISHER_LAST_NM_PARTNER2 | VARCHAR2 | Last name of fishing partner 2 (if applicable). July 2011 and more recent. |
100 | No | No | LOGBOOK_RECEIVED_DT | DATE | Date the logbook report was received by the USVI DFW. 2012 and more recent. |
100 | No | No | FAD_NM | VARCHAR2 | Name of fish attractant device fished on. July 2011 and more recent. |
100 | No | No | BOTTOM_DEPTH_MIN | NUMBER | Minimum bottom depth fished during trip |
100 | No | No | BOTTOM_DEPTH_MAX | NUMBER | Maximum bottom depth fished during trip |
100 | No | No | TOTAL_LOBSTER_TRAPS_IN_WATER | NUMBER | Total number of lobster traps soaking at the time of trip. Include the traps hauled. |
100 | No | No | TOTAL_FISH_TRAPS_IN_WATER | NUMBER | Total fish traps soaking at the time of trip. Include traps hauled. |
100 | No | No | DISCARD_SPECIES_CD | VARCHAR2 | species codes for species discarded on trip (only recent data). |
100 | No | No | DISCARDED_CNT | NUMBER | Number of species discarded on trip. Only in recent data. |
100 | No | No | SEQUENCE_NUM | NUMBER | Created to assist in duplicate data resolution. Only for recent... |
100 | No | No | TOTAL_TRAPS_HAULED | NUMBER | The total number of traps hauled for the trip (both fish and lobster). Available for all years in the data set. |
100 | No | No | TRIP_MAY_BE_DUPLICATE | VARCHAR2 | This trip has been identified as a possible duplicate in the data set. |
100 | No | No | LANDING_DATE | DATE | The landing date (all years) of the trip. |
100 | No | No | FMU | VARCHAR2 | The FIsheries Management UNit |
100 | No | No | ACL_UNIT | VARCHAR2 | The ACL (Allowable Catch Limit) unit for the species |
100 | No | No | FAMILY | VARCHAR2 | The common name for the species family |
100 | No | No | EXTRACT_DATE_FOR_THIS_TABLE | DATE | The date that these data were extracted from the data set. Right now extracts are done bi-weekly. |
Attribute Details
Attribute Name | TRIP_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The ID number of the trip. The original ID from the trip is prefixed with the island and form type along with the trip id existing in the original table (example: 'STT_GEAR'||TRIM(TO_CHAR(ID,'99999999') using the trip_id the original record from the USVI-submitted file can be accessed in the column 'original_record_id' in the original tables which are combined in the oracle tables ALS.USVI_ST*_gear_form_landings, ALS.USVI_SPECIES_GROUP_FORMS_ALL, and jbennett.EXTRACT_FROM_CCL_USVI. Both island groups are processed the same way. |
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_YEAR |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The year the catch was landed. |
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_MONTH |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The month the catch was landed. |
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_DAY |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The calendar day the trip landed. |
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 | VESSEL_CD |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The state (territorial) id or the USCG id of the fishing craft. |
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 | FISHER_PERMIT |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The territorial permit (license) number of the fisher. This is island-dependent. |
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 | FISHER_FIRST_NAME |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The first name of the fisher. |
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 | FISHER_LAST_NAME |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The last name of the fisher. |
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_TICKET_NUMBER |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered. |
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 | TIP_INTERVIEW_TAKEN |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether or not a dockside sample was taken for this 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 | TIP_INTERVIEW_NUMBER |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If a dockside sample was taken what was the interview number of the sample. This column is designed to be filled in manually. It is currently not in use. |
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 | DAY_OR_NIGHT |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Did the majority of the fishing take place at night or during the day? |
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 | FEDERAL_OR_STATE_WATERS |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters 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 | CHARTER_TRIP |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips. |
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 | NUM_PARTNERS_OR_HELPERS |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of fishers and/or helpers on board besides the primary fisher. |
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 | IS_CATCH_SPLIT |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was part of the catch from this trip recorded on another fisher's report? |
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 | ISLAND |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The island or island group where the catch was landed. |
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 | LANDING_AREA_COUNTY |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Island (not a county) where the catch was landed. |
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 | LANDING_AREA_NAME |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the location where the catch was landed. |
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 | TOTAL_TRIP_POUNDS |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped not summed. |
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 | TOTAL_TRAPS_IN_WATER |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable. |
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 | RECORD_STATUS |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is trip completely entered? |
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 | AREA_CD1 |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD2 |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD3 |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD4 |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD5 |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD6 |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD7 |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD8 |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD9 |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | AREA_CD10 |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal 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 | FAD_CD |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The USVI code for the Fish Attraction Device (if any) fished. |
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 | HOURS_FISHED |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hours actively fishing on the fishing grounds. |
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 | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom). |
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 | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Designates the bottom depth units in feet or fathoms. |
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 | TRAP_SOAK_TIME_HRS |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hours traps were soaking on the fishing ground prior to haul. |
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 | GEAR_TYPE_NM |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the general gear type. Traps, Hook and Line, Nets, or DIving. |
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_NM |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The specific gear name. |
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_QTY_OLD |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gear quantities from the historical gear based forms for fish and lobster traps. |
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_QTY2 |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Inactive |
Description |
A null field. |
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_QTY3 |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Inactive |
Description |
A null field |
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_QTY__UOM |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Inactive |
Description |
a null field |
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_FAMILY_CD |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The general code for the fish family if the catch is at species, genus, or family level. |
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_CD |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The species code. Species codes for most species are not in the data until July 2011 when the latest version of the log report forms came out. Prior to that the forms showed mostly families or more general groupings. |
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_NM |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The species name. Not at species level for most species until July 2011 when new forms were introduced. |
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 | POUNDS_LANDED |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The pounds of catch landed. |
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 | POUNDS_CONDITION |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Refers to condition of landing. Whole, gutted,etc. Only available after July 2011. |
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 | FORM_TYPE |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The form type. Reporting forms have changed over the years. |
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 | DISCARD_FISH_LIVE_CNT |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded fish (live). Available since 2003. |
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 | DISCARD_FISH_DEAD_CNT |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded fish (dead). Available since 2003. |
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 | DISCARD_LOBSTER_LIVE_CNT |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded lobster (live). Available since 2003. |
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 | DISCARD_LOBSTER_DEAD_CNT |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sum of numbers (not pounds) of discarded lobster (dead). Available since 2003. |
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 | SOURCE_FILE |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The original submission file name (typically in Excel format). |
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 | ORIGINAL_DATE |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The original date on which the source file was submitted. |
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 | FISHING_YEAR |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The license fishing year from July 1 - June 30 |
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_GRADE |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
For the historical gear-based forms the species grades are: SNAPPER-GROUPER, NOT SNAPPER-GROUPER, UNCLASSIFIED, and BAITFISH. For the historical species group-based forms the species grades are: BAITFISH, PELAGIC, RELEASED, and UNCLASSIFIED. |
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 | GEAR1_NAME |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary Gear used in the species group-based reporting forms. |
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 | GEAR1_NUM |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Quantity of primary gear used in the species group-based reporting forms. |
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 | GEAR2_NAME |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Secondary gear used in the historical species group-based reporting forms. |
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 | GEAR2_NUM |
---|---|
Seq. Order | 61 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Quantity of secondary gear used in the historical species group-based reporting forms. |
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 | LINES_CNT |
---|---|
Seq. Order | 62 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
From the historical species group-based forms and the more recent CCL forms. The number of total number of lines fished |
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 | HOOKS_PER_LINE_CNT |
---|---|
Seq. Order | 63 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average number of hooks per line. Only available on the recent CCL forms. |
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 | FAD_NUM |
---|---|
Seq. Order | 64 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of the Fish Attractant Device fished. Only from the more recent forms after July 2011. |
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 | LOBSTER_TRAPS_HAULED |
---|---|
Seq. Order | 65 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of Lobster Traps hauled for the trip. Available on historical gear-based forms from 1995-1998 and on more recent CCL forms from JUly 2011 and more recent. |
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 | FISH_TRAPS_HAULED |
---|---|
Seq. Order | 66 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of fish traps hauled for the trip. Available from the historical gear-based forms from 1990-1999 and from the recent CCL forms from JUly 2011 and more recent. |
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 | FISH_TRAPS_HOURS_SOAKED |
---|---|
Seq. Order | 67 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The hours the fish traps soaked on the fishing grounds from set to haul. Only from the more recent forms July 2011 and more recent. |
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 | LOBSTER_TRAPS_DAYS_SOAKED |
---|---|
Seq. Order | 68 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Lobster traps days soaked from set to haul. Only from July 2011 and more recent. |
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 | FISH_TRAPS_DAYS_SOAKED |
---|---|
Seq. Order | 69 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
FIsh trap days soaked from set to haul. only from July 2011 and more recent. |
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 | NET_LENGTH |
---|---|
Seq. Order | 70 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Net length in feet or fathoms from July 2011 and more recent |
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 | MESH_IN |
---|---|
Seq. Order | 71 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Diagonal Net mesh size in inches. July 2011 and more recent. |
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 | NET_CNT |
---|---|
Seq. Order | 72 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of nets. From species group-based forms 1995-June 2011 and CCL forms July 2011 and more recent. |
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 | LENGTH_UOM |
---|---|
Seq. Order | 73 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The net length unit of measure (feet or fathoms). |
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 | DIVERS_CNT |
---|---|
Seq. Order | 74 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of divers. From historical species group-based forms 1996-June 2011 and from CCL forms July 2011 and more recent. |
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 | DIVES_CNT |
---|---|
Seq. Order | 75 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total number of dives. July 2011 and more recent. |
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 | IS_SCUBA |
---|---|
Seq. Order | 76 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Were dives made using SCUBA? |
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 | REGION_PERMIT_NUM_PARTNER1 |
---|---|
Seq. Order | 77 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Permit Number of fishing partner 1 (if applicable). July 2011 and more recent. |
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 | FISHER_FIRST_NM_PARTNER1 |
---|---|
Seq. Order | 78 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First name of fishing partner 1 (if applicable). July 2011 and more recent. |
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 | FISHER_LAST_NM_PARTNER1 |
---|---|
Seq. Order | 79 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last Name of fishing partner 1 (if applicable). July 2011 and more recent. |
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 | REGION_PERMIT_NUM_PARTNER2 |
---|---|
Seq. Order | 80 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Permit Number of fishing partner 2 (if applicable). July 2011 and more recent. |
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 | FISHER_FIRST_NM_PARTNER2 |
---|---|
Seq. Order | 81 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First name of fishing partner 2 (if applicable). July 2011 and more recent. |
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 | FISHER_LAST_NM_PARTNER2 |
---|---|
Seq. Order | 82 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last name of fishing partner 2 (if applicable). July 2011 and more recent. |
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 | LOGBOOK_RECEIVED_DT |
---|---|
Seq. Order | 83 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the logbook report was received by the USVI DFW. 2012 and more recent. |
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 | FAD_NM |
---|---|
Seq. Order | 84 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fish attractant device fished on. July 2011 and more recent. |
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 | BOTTOM_DEPTH_MIN |
---|---|
Seq. Order | 85 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum bottom depth fished during trip |
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 | BOTTOM_DEPTH_MAX |
---|---|
Seq. Order | 86 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum bottom depth fished during trip |
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 | TOTAL_LOBSTER_TRAPS_IN_WATER |
---|---|
Seq. Order | 87 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total number of lobster traps soaking at the time of trip. Include the traps hauled. |
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 | TOTAL_FISH_TRAPS_IN_WATER |
---|---|
Seq. Order | 88 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total fish traps soaking at the time of trip. Include traps hauled. |
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 | DISCARD_SPECIES_CD |
---|---|
Seq. Order | 89 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
species codes for species discarded on trip (only recent data). |
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 | DISCARDED_CNT |
---|---|
Seq. Order | 90 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of species discarded on trip. Only in recent data. |
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 | SEQUENCE_NUM |
---|---|
Seq. Order | 91 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Created to assist in duplicate data resolution. Only for recent... |
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 | TOTAL_TRAPS_HAULED |
---|---|
Seq. Order | 92 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of traps hauled for the trip (both fish and lobster). Available for all years in the data set. |
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 | TRIP_MAY_BE_DUPLICATE |
---|---|
Seq. Order | 93 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
This trip has been identified as a possible duplicate in the data set. |
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 | LANDING_DATE |
---|---|
Seq. Order | 94 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The landing date (all years) of the trip. |
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 | FMU |
---|---|
Seq. Order | 95 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The FIsheries Management UNit |
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 | ACL_UNIT |
---|---|
Seq. Order | 96 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The ACL (Allowable Catch Limit) unit for the species |
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 | FAMILY |
---|---|
Seq. Order | 97 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The common name for the species family |
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 | EXTRACT_DATE_FOR_THIS_TABLE |
---|---|
Seq. Order | 98 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date that these data were extracted from the data set. Right now extracts are done bi-weekly. |
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 | |
---|---|
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 | 37464 |
---|---|
Metadata Record Created By | Joshua Bennett |
Metadata Record Created | 2017-03-28 10:27+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2021-05-06 |
Owner Org | SEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-05-06 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-06 |
Tags |
---|