Table: SFOQVR
Entity (ENT) | Greater Atlantic Regional Fisheries Office (GARFO)GUID: gov.noaa.nmfs.inport:11924 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Main Surf Clam/Ocean Quahog vessel logbook table.
DescriptionHolds data for SF/OQ vessel logbook records.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
VR_REC_ID
NUMBER |
Unique record identification number; generated by the system at data entry. |
DNUM
NUMBER |
Dealer permit number. |
NUM
NUMBER |
Vessel permit number. |
CD
DATE |
Catch date. |
LAT
VARCHAR2 |
Latitude degrees concatenated with latitude minutes. |
LON
VARCHAR2 |
Longitude degrees concatenated with longitude minutes. |
TAS
NUMBER |
Time at sea (tenths of hours). |
TF
NUMBER |
Time fished (tenths of hours). |
BUSH
NUMBER |
Number of bushels landed (32 cages = 1 bushel). |
DISP
NUMBER |
Percent of catch discarded by the vessel. |
ST
VARCHAR2 |
2 digit state code. Link to VTR.PORT.STATECD. |
PC
VARCHAR2 |
2 digit port code. Link to VTR.PORT.PORT2. |
CY
VARCHAR2 |
2 digit county code. Link to VTR.PORT.COUNTYCD. |
PR
NUMBER |
Price per bushel in dollars. |
ANUM
VARCHAR2 |
Allocation number. |
TRIP_NUM
NUMBER |
Trip number. Set automatically by application. User may override but not set directly. |
DE
DATE |
Date record was loaded into table. |
UE
VARCHAR2 |
User loading data into table. |
DC
DATE |
Date of most recent update(s) to record. |
UC
VARCHAR2 |
User making most recent update(s) to record. |
LORAN1
VARCHAR2 |
Loran bearing 1. |
LORAN2
VARCHAR2 |
Loran bearing 2. |
CHANGE
VARCHAR2 |
Change flag. T indicates user forced retention of previous trip number. |
CAREA
VARCHAR2 |
Calculated area. |
CLATDEG
VARCHAR2 |
Calculated latitude degrees. |
CLATMIN
VARCHAR2 |
Calculated latitude minutes. |
CLATSEC
VARCHAR2 |
Calculated latitude seconds. |
CLONDEG
VARCHAR2 |
Calculated longitude degrees. |
CLONMIN
VARCHAR2 |
Calculated longitude minutes. |
CLONSEC
VARCHAR2 |
Calculated longitude seconds. |
CFZONE
VARCHAR2 |
Calculated fishing zone. |
CQDSQ
VARCHAR2 |
Calculated quarter-degree square. |
CTNMS
VARCHAR2 |
Calculated ten minute square. |
CERRNO
NUMBER |
Calculated error code. Codes range from 1-12. |
Child Items
No Child Items for this record.
Contact Information
Point of Contact
James R St Cyr
james.stcyr@noaa.gov
978-281-9369
Metadata Contact
Alison Ferguson
alison.ferguson@noaa.gov
978-281-9209
Extents
1978 - Present
Beginning in 1978, participation in the surf clam fishery became conditional upon a set of requirements including detailed logbook reporting. In the early 1980's ocean quahog vessels became subject to the same detailed logbook reporting requirements.
Item Identification
Title: | Table: SFOQVR |
---|---|
Short Name: | SFOQVR |
Status: | Completed |
Abstract: |
Main Surf Clam/Ocean Quahog vessel logbook table. |
Purpose: |
Holds data for SF/OQ vessel logbook records. |
Notes: |
Loaded by batch 2887, 03-09-2012 12:19 |
Supplemental Information: |
Server: NERO Schema: SFCLAM Table: SFOQVR (Surf Clam-Ocean Quahog-Vessel Report) |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | individual transferable quota |
None | itq |
None | ocean quahog |
None | oq |
None | quota monitoring |
None | sc |
None | sc/oq |
None | surf clam |
None | surfclam |
None | vessel logbook reporting |
None | vessel reporting |
Temporal Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | 1978-present |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | atlantic |
None | connecticut |
None | ct |
None | de |
None | delaware |
None | gloucester |
None | ma |
None | maine |
None | maryland |
None | massachusetts |
None | md |
None | me |
None | ne |
None | nero |
None | new england |
None | new hampshire |
None | new jersey |
None | new york |
None | nj |
None | northeast |
None | ny |
None | rhode island |
None | ri |
None | va |
None | virginia |
Stratum Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | area |
None | gear |
None | species |
Physical Location
Organization: | Greater Atlantic Regional Fisheries Office |
---|---|
City: | Gloucester |
State/Province: | MA |
Country: | USA |
Location Description: |
Fisheries Data Services Division (FDSD) 55 Great Republic Drive |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | SFCLAM |
Description: |
Holds data for SF/OQ vessel logbook records. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
VR_REC_ID | NUMBER | Unique record identification number; generated by the system at data entry. | |
100
|
DNUM | NUMBER | Dealer permit number. | |
100
|
NUM | NUMBER | Vessel permit number. | |
100
|
CD | DATE | Catch date. | |
100
|
LAT | VARCHAR2 | Latitude degrees concatenated with latitude minutes. | |
100
|
LON | VARCHAR2 | Longitude degrees concatenated with longitude minutes. | |
100
|
TAS | NUMBER | Time at sea (tenths of hours). | |
100
|
TF | NUMBER | Time fished (tenths of hours). | |
100
|
BUSH | NUMBER | Number of bushels landed (32 cages = 1 bushel). | |
100
|
DISP | NUMBER | Percent of catch discarded by the vessel. | |
100
|
ST | VARCHAR2 | 2 digit state code. Link to VTR.PORT.STATECD. | |
100
|
PC | VARCHAR2 | 2 digit port code. Link to VTR.PORT.PORT2. | |
100
|
CY | VARCHAR2 | 2 digit county code. Link to VTR.PORT.COUNTYCD. | |
100
|
PR | NUMBER | Price per bushel in dollars. | |
100
|
ANUM | VARCHAR2 | Allocation number. | |
100
|
TRIP_NUM | NUMBER | Trip number. Set automatically by application. User may override but not set directly. | |
100
|
DE | DATE | Date record was loaded into table. | |
100
|
UE | VARCHAR2 | User loading data into table. | |
100
|
DC | DATE | Date of most recent update(s) to record. | |
100
|
UC | VARCHAR2 | User making most recent update(s) to record. | |
100
|
LORAN1 | VARCHAR2 | Loran bearing 1. | |
100
|
LORAN2 | VARCHAR2 | Loran bearing 2. | |
100
|
CHANGE | VARCHAR2 | Change flag. T indicates user forced retention of previous trip number. | |
100
|
CAREA | VARCHAR2 | Calculated area. | |
100
|
CLATDEG | VARCHAR2 | Calculated latitude degrees. | |
100
|
CLATMIN | VARCHAR2 | Calculated latitude minutes. | |
100
|
CLATSEC | VARCHAR2 | Calculated latitude seconds. | |
100
|
CLONDEG | VARCHAR2 | Calculated longitude degrees. | |
100
|
CLONMIN | VARCHAR2 | Calculated longitude minutes. | |
100
|
CLONSEC | VARCHAR2 | Calculated longitude seconds. | |
100
|
CFZONE | VARCHAR2 | Calculated fishing zone. | |
100
|
CQDSQ | VARCHAR2 | Calculated quarter-degree square. | |
100
|
CTNMS | VARCHAR2 | Calculated ten minute square. | |
100
|
CERRNO | NUMBER | Calculated error code. Codes range from 1-12. |
Attribute Details
VR_REC_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Unique record identification number; generated by the system at data entry. |
General Data Type: | NUMBER |
DNUM
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Dealer permit number. |
General Data Type: | NUMBER |
NUM
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Vessel permit number. |
General Data Type: | NUMBER |
CD
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Catch date. |
General Data Type: | DATE |
LAT
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees concatenated with latitude minutes. |
General Data Type: | VARCHAR2 |
LON
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees concatenated with longitude minutes. |
General Data Type: | VARCHAR2 |
TAS
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Time at sea (tenths of hours). |
General Data Type: | NUMBER |
TF
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Time fished (tenths of hours). |
General Data Type: | NUMBER |
BUSH
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of bushels landed (32 cages = 1 bushel). |
General Data Type: | NUMBER |
DISP
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
Percent of catch discarded by the vessel. |
General Data Type: | NUMBER |
ST
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2 digit state code. Link to VTR.PORT.STATECD. |
General Data Type: | VARCHAR2 |
PC
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2 digit port code. Link to VTR.PORT.PORT2. |
General Data Type: | VARCHAR2 |
CY
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2 digit county code. Link to VTR.PORT.COUNTYCD. |
General Data Type: | VARCHAR2 |
PR
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Price per bushel in dollars. |
General Data Type: | NUMBER |
ANUM
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Allocation number. |
General Data Type: | VARCHAR2 |
TRIP_NUM
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Trip number. Set automatically by application. User may override but not set directly. |
General Data Type: | NUMBER |
DE
Seq. Order: | 17 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date record was loaded into table. |
General Data Type: | DATE |
UE
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User loading data into table. |
General Data Type: | VARCHAR2 |
DC
Seq. Order: | 19 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of most recent update(s) to record. |
General Data Type: | DATE |
UC
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User making most recent update(s) to record. |
General Data Type: | VARCHAR2 |
LORAN1
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Loran bearing 1. |
General Data Type: | VARCHAR2 |
LORAN2
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Loran bearing 2. |
General Data Type: | VARCHAR2 |
CHANGE
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Change flag. T indicates user forced retention of previous trip number. |
General Data Type: | VARCHAR2 |
CAREA
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated area. |
General Data Type: | VARCHAR2 |
CLATDEG
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated latitude degrees. |
General Data Type: | VARCHAR2 |
CLATMIN
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated latitude minutes. |
General Data Type: | VARCHAR2 |
CLATSEC
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated latitude seconds. |
General Data Type: | VARCHAR2 |
CLONDEG
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated longitude degrees. |
General Data Type: | VARCHAR2 |
CLONMIN
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated longitude minutes. |
General Data Type: | VARCHAR2 |
CLONSEC
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated longitude seconds. |
General Data Type: | VARCHAR2 |
CFZONE
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated fishing zone. |
General Data Type: | VARCHAR2 |
CQDSQ
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated quarter-degree square. |
General Data Type: | VARCHAR2 |
CTNMS
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated ten minute square. |
General Data Type: | VARCHAR2 |
CERRNO
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Calculated error code. Codes range from 1-12. |
General Data Type: | NUMBER |
Support Roles
Metadata Contact
Date Effective From: | 2010-01-01 |
---|---|
Date Effective To: | |
Contact (Person): | Ferguson, Alison |
Address: |
55 Great Republic Drive Gloucester, MA 01930 United States |
Email Address: | alison.ferguson@noaa.gov |
Phone: | 978-281-9209 |
Fax: | 978-281-9161 |
Point of Contact
Date Effective From: | 2010-01-01 |
---|---|
Date Effective To: | |
Contact (Person): | St Cyr, James R |
Address: |
55 Great Republic Drive Gloucester, MA 01930 USA |
Email Address: | james.stcyr@noaa.gov |
Phone: | 978-281-9369 |
Extents
Extent Group 1
Extent Group 1 / Time Frame 1
Time Frame Type: | Continuing |
---|---|
Start: | 1978 |
Description: |
Beginning in 1978, participation in the surf clam fishery became conditional upon a set of requirements including detailed logbook reporting. In the early 1980's ocean quahog vessels became subject to the same detailed logbook reporting requirements. |
Access Information
Security Class: | Confidential |
---|---|
Security Classification System: |
Vessel trip reports are considered to be business confidential and may not be released without signed approval of the permit holder on record for the time period requested. |
Data Access Policy: |
Access to VTR data is governed by 50CFR600 - Confidentiality of Information. Access by state fishery management agency staff and Fisheries Management Council staff may be allowed through Memorandum of Understanding that are signed by the NE Regional Administrator and Directors of the State Agency or Councils that describe the need and uses of the data and list the individuals who will have access to the data. Contractors may be granted access provided they are working under contract to NOAA or a cooperating partner (state, Council, Commission) on a specific project under the oversight of a partner. |
Data Access Procedure: |
Contact POC to request access. |
Data Access Constraints: |
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel. The APSD Data Request staff are the POC for non-disclosure forms. |
Data Use Constraints: |
Access to individual reports is restricted to NOAA employees and our partners who have signed non-disclosure agreements. Summary data may be made available based on the "rule of 3", i.e., there must be at least three entities included in a summary for the summary information to be made publically available. Data may be made available if there is no information included that could uniquely link the information to an individual entity (person, vessel operating unit, business, etc.). Individually identifiable information may not be released without written authorization from the provider or by court order. |
Metadata Use Constraints: |
There are no constraints on the use of the metadata associated with this program. |
Catalog Details
Catalog Item ID: | 11924 |
---|---|
GUID: | gov.noaa.nmfs.inport:11924 |
Metadata Record Created By: | Patrick R Rohan |
Metadata Record Created: | 2012-03-09 12:19+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-02-25 |
Owner Org: | GARFO |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-02-25 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-02-25 |