1503
SC/OQ Vessel Database
SC/OQ Vessel Database
Data Set
Published / External
1428
Surfclam/Ocean Quahog (SC/OQ) Logbook
Project
In Work
2013
Data tables holding information for the Surf Clam/Ocean Quahog vessel and dealer/processor logbooks (negative and positive), as well as individual tag information and ranges of tag numbers.
To hold data for the commerical harvest, catch, and effort for the Surfclam & Ocean Quahog ITQ fisheries.
Multi-year data sets for 2003 - present.
Theme
ITQ
Theme
OQ
Theme
Ocean Quahog
Theme
Quota Monitoring
Theme
SC
Theme
SC/OQ
Theme
Surf Clam
Theme
Surfclam
Theme
Vessel Reporting
Theme
individual transferable quota
Theme
vessel logbook reporting
Temporal
1978-present
Spatial
Atlantic
Spatial
CT
Spatial
Connecticut
Spatial
DE
Spatial
Delaware
Spatial
Gloucester
Spatial
MA
Spatial
MD
Spatial
ME
Spatial
Maine
Spatial
Maryland
Spatial
Massachusetts
Spatial
NE
Spatial
NERO
Spatial
NH
Spatial
NJ
Spatial
NY
Spatial
New England
Spatial
New Hampshire
Spatial
New Jersey
Spatial
New York
Spatial
Northeast
Spatial
RI
Spatial
Rhode Island
Spatial
VA
Spatial
Virginia
Spatial
northeast atlantic
Spatial
northwest atlantic
Stratum
Area
Stratum
Gear
Stratum
Species
Greater Atlantic Regional Fisheries Office
Gloucester
MA
USA
Fisheries Data Services Division (FDSD)
55 Great Republic Drive
Data Set
Database
Weekly
Table (digital)
Not Applicable
Not Applicable
Not Applicable
11920
Table: PRTAGI
PRTAGI
Published / External
Completed
Main database for storing individual Surf Clam/Ocean Quahog dealer/processor tag numbers.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: PRTAGI (Processor Report-Tag-Individual)
Data Table
Yes
SFCLAM
Holds individual Surf Clam/Ocean Quahog dealer/processor tag numbers.
1
PR_TAGI_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
PR_REC_ID
NUMBER
22
No
No
6
0
Active
Foreign key. Link to SFOQPR.
NUMBER
3
TAGNUM
NUMBER
22
Yes
No
8
0
Active
Individual tag number.
NUMBER
4
DE
DATE
7
No
No
Active
Date record was loaded into table.
DATE
5
UE
VARCHAR2
30
No
No
Active
User loading data into table.
VARCHAR2
6
DC
DATE
7
No
No
Active
Date of most recent update(s) to record.
DATE
7
UC
VARCHAR2
30
No
No
Active
User making most recent update(s) to record.
VARCHAR2
11921
Table: PRTAGR
PRTAGR
Published / External
Completed
Main database for storing ranges of Surf Clam/Ocean Quahog dealer/processor tag numbers.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: PRTAGR (Processor Report-Tag-Range)
Data Table
Yes
SFCLAM
Holds ranges of Surf Clam/Ocean Quahog dealer/processor tag numbers.
1
PR_TAGR_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
PR_REC_ID
NUMBER
22
No
No
6
0
Active
Foreign key. Link to SFOQPR.
NUMBER
3
BEGTAG
NUMBER
22
Yes
No
8
0
Active
First tag number in series.
NUMBER
4
ENDTAG
NUMBER
22
Yes
No
8
0
Active
Last tag number in series.
NUMBER
5
DE
DATE
7
No
No
Active
Date record was loaded into table.
DATE
6
UE
VARCHAR2
30
No
No
Active
User loading data into table.
VARCHAR2
7
DC
DATE
7
No
No
Active
Date of most recent update(s) to record.
DATE
8
UC
VARCHAR2
30
No
No
Active
User making most recent update(s) to record.
VARCHAR2
11922
Table: SFOQNR
SFOQNR
Published / External
Completed
Main Surf Clam/Ocean Quahog dealer/processor negative report information table.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: SFOQNR (Surf Clam-Ocean Quahog-Negative Report)
Data Table
Yes
SFCLAM
Holds data for SF/OQ dealer/processor logbook negative records.
1
NR_REC_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
NUM
NUMBER
22
Yes
No
6
0
Active
Vessel permit number.
NUMBER
3
CD
DATE
7
Yes
No
Active
Week ending date of reporting week. Weeks run Sunday to Saturday.
DATE
4
DE
DATE
7
No
No
Active
Date record was loaded into table.
DATE
5
UE
VARCHAR2
15
No
No
Active
User loading data into table.
VARCHAR2
6
DC
DATE
7
No
No
Active
Date of most recent update(s) to record.
DATE
7
UC
VARCHAR2
15
No
No
Active
User making most recent update(s) to record.
VARCHAR2
11923
Table: SFOQPR
SFOQPR
Published / External
Completed
Main Surf Clam/Ocean Quahog dealer/processor report information table.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: SFOQPR (Surf Clam-Ocean Quahog-Processor Report)
Data Table
Yes
SFCLAM
Holds data for SF/OQ dealer/processor logbook main records.
1
PR_REC_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
DNUM
NUMBER
22
No
No
5
0
Active
Dealer permit number.
NUMBER
3
NUM
NUMBER
22
No
No
6
0
Active
Vessel permit number.
NUMBER
4
PD
DATE
7
No
No
Active
Purchase date.
DATE
5
ST
VARCHAR2
2
No
No
Active
2 digit state code. Link to VTR.PORT.STATECD.
VARCHAR2
6
PC
VARCHAR2
2
No
No
Active
2 digit port code. Link to VTR.PORT.PORT2.
VARCHAR2
7
CY
VARCHAR2
2
No
No
Active
2 digit county code. Link to VTR.PORT.COUNTYCD.
VARCHAR2
8
CAT
NUMBER
22
No
No
1
0
Active
Category of catch. Surf Clam=1; Ocean Quahog=6.
NUMBER
9
BUSH
NUMBER
22
No
No
4
0
Active
Number of bushels landed (32 cages = 1 bushel).
NUMBER
10
PRICE
NUMBER
22
No
No
4
2
Active
Price per bushel in dollars.
NUMBER
11
DE
DATE
7
No
No
Active
Date record was loaded into table.
DATE
12
UE
VARCHAR2
15
No
No
Active
User loading data into table.
VARCHAR2
13
DC
DATE
7
No
No
Active
Date of most recent update(s) to record.
DATE
14
UC
VARCHAR2
15
No
No
Active
User making most recent update(s) to record.
VARCHAR2
15
COMMENTS
VARCHAR2
300
No
No
Active
Comments.
VARCHAR2
16
DELETED
VARCHAR2
1
No
No
Active
Not Used.
VARCHAR2
17
LOADSOURCE
VARCHAR2
1
No
No
Active
U for Upload.
VARCHAR2
11924
Table: SFOQVR
SFOQVR
Published / External
Completed
Main Surf Clam/Ocean Quahog vessel logbook table.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: SFOQVR (Surf Clam-Ocean Quahog-Vessel Report)
Data Table
Yes
SFCLAM
Holds data for SF/OQ vessel logbook records.
1
VR_REC_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
DNUM
NUMBER
22
No
No
5
0
Active
Dealer permit number.
NUMBER
3
NUM
NUMBER
22
No
No
6
0
Active
Vessel permit number.
NUMBER
4
CD
DATE
7
No
No
Active
Catch date.
DATE
5
LAT
VARCHAR2
5
No
No
Active
Latitude degrees concatenated with latitude minutes.
VARCHAR2
6
LON
VARCHAR2
5
No
No
Active
Longitude degrees concatenated with longitude minutes.
VARCHAR2
7
TAS
NUMBER
22
No
No
4
1
Active
Time at sea (tenths of hours).
NUMBER
8
TF
NUMBER
22
No
No
4
1
Active
Time fished (tenths of hours).
NUMBER
9
BUSH
NUMBER
22
No
No
4
0
Active
Number of bushels landed (32 cages = 1 bushel).
NUMBER
10
DISP
NUMBER
22
No
No
3
1
Active
Percent of catch discarded by the vessel.
NUMBER
11
ST
VARCHAR2
2
No
No
Active
2 digit state code. Link to VTR.PORT.STATECD.
VARCHAR2
12
PC
VARCHAR2
2
No
No
Active
2 digit port code. Link to VTR.PORT.PORT2.
VARCHAR2
13
CY
VARCHAR2
2
No
No
Active
2 digit county code. Link to VTR.PORT.COUNTYCD.
VARCHAR2
14
PR
NUMBER
22
No
No
5
2
Active
Price per bushel in dollars.
NUMBER
15
ANUM
VARCHAR2
4
No
No
Active
Allocation number.
VARCHAR2
16
TRIP_NUM
NUMBER
22
No
No
6
0
Active
Trip number. Set automatically by application. User may override but not set directly.
NUMBER
17
DE
DATE
7
No
No
Active
Date record was loaded into table.
DATE
18
UE
VARCHAR2
15
No
No
Active
User loading data into table.
VARCHAR2
19
DC
DATE
7
No
No
Active
Date of most recent update(s) to record.
DATE
20
UC
VARCHAR2
15
No
No
Active
User making most recent update(s) to record.
VARCHAR2
21
LORAN1
VARCHAR2
5
No
No
Active
Loran bearing 1.
VARCHAR2
22
LORAN2
VARCHAR2
5
No
No
Active
Loran bearing 2.
VARCHAR2
23
CHANGE
VARCHAR2
1
No
No
Active
Change flag. T indicates user forced retention of previous trip number.
VARCHAR2
24
CAREA
VARCHAR2
3
No
No
Active
Calculated area.
VARCHAR2
25
CLATDEG
VARCHAR2
2
No
No
Active
Calculated latitude degrees.
VARCHAR2
26
CLATMIN
VARCHAR2
2
No
No
Active
Calculated latitude minutes.
VARCHAR2
27
CLATSEC
VARCHAR2
2
No
No
Active
Calculated latitude seconds.
VARCHAR2
28
CLONDEG
VARCHAR2
2
No
No
Active
Calculated longitude degrees.
VARCHAR2
29
CLONMIN
VARCHAR2
2
No
No
Active
Calculated longitude minutes.
VARCHAR2
30
CLONSEC
VARCHAR2
2
No
No
Active
Calculated longitude seconds.
VARCHAR2
31
CFZONE
VARCHAR2
1
No
No
Active
Calculated fishing zone.
VARCHAR2
32
CQDSQ
VARCHAR2
5
No
No
Active
Calculated quarter-degree square.
VARCHAR2
33
CTNMS
VARCHAR2
6
No
No
Active
Calculated ten minute square.
VARCHAR2
34
CERRNO
NUMBER
22
No
No
3
0
Active
Calculated error code. Codes range from 1-12.
NUMBER
11925
Table: VRTAGI
VRTAGI
Published / External
Completed
Main database for storing individual Surf Clam/Ocean Quahog vessel tag numbers.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: VRTAGI (Vessel Report-Tag-Individual)
Data Table
Yes
SFCLAM
Holds individual Surf Clam/Ocean Quahog vessel tag numbers.
1
VR_TAGI_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
VR_REC_ID
NUMBER
22
No
No
6
0
Active
Foreign key. Link to SFOQVR.
NUMBER
3
TAGNUM
NUMBER
22
Yes
No
8
0
Active
Individual tag number.
NUMBER
11926
Table: VRTAGR
VRTAGR
Published / External
Completed
Main database for storing ranges of Surf Clam/Ocean Quahog vessel tag numbers.
Loaded by batch 2887, 03-09-2012 12:19
Server: NERO
Schema: SFCLAM
Table: VRTAGR (Vessel Report-Tag-Range)
Data Table
Yes
SFCLAM
Holds ranges of Surf Clam/Ocean Quahog vessel tag numbers.
1
VR_TAGR_ID
NUMBER
22
Yes
Yes
6
0
Active
Unique record identification number; generated by the system at data entry.
NUMBER
2
VR_REC_ID
NUMBER
22
No
No
6
0
Active
Foreign key. Link to SFOQVR.
NUMBER
3
BEGTAG
NUMBER
22
Yes
No
8
0
Active
First tag number in series.
NUMBER
4
ENDTAG
NUMBER
22
Yes
No
8
0
Active
Last tag number in series.
NUMBER
Data Steward
2010
Person
St Cyr, James R
james.stcyr@noaa.gov
55 Great Republic Drive
Gloucester
MA
01930
USA
978-281-9369
Distributor
2010
Organization
Greater Atlantic Regional Fisheries Office
GARFO
55 Great Republic Drive
Gloucester
MA
01930
USA
(978)281-9300
8:00 a.m. - 4:30 EST
Metadata Contact
2010
Person
Washick, Denise A
denise.washick@noaa.gov
55 Great Republic Drive
Gloucester
MA
01930
USA
978-675-2197
Point of Contact
2010
Person
Goodale, Hannah F
hannah.f.goodale@noaa.gov
55 Great Republic Drive
Gloucester
MA
01930
USA
978-281-9101
Generally from the US/Canadian maritime boundary south to the Virginia/North Carolina maritime boundary, seaward to the perimeter of the EEZ (200 miles from shore).
Continuing
1978
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.
Sensitive
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.
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.
Contact POC to request access.
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.
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.
There are no constraints on the use of the metadata associated with this program.
http://www.nero.noaa.gov/nero/regs/infodocs/SCOQInfoSheet.pdf
Other
Surfclam/Ocean Quahog overview.
http://www.nero.noaa.gov/ro/fso/reports/SurfclamOceanQuahog/c.htm
Other
Surfclam/Ocean Quahog/Maine Mahogany Quahog Annual Reports.
http://www.nmfs.noaa.gov/sfa/domes_fish/catchshare/docs/surfclam_oceanquahog.pdf
Other
Surfclam/Ocean Quahog ITQ.
Relational database.
Vessel logbook data can be considered representative of all self reported vessel data in the NERO.
The Vessel Trip Reports are submitted by vessel operators and thus contain self reported data. The information in these reports is compared against the information in other data systems.
Vessel reported data is routinely audited for completeness. Vessel reports missing obvious data fields are sent back to vessel owners.
GARFO has established an "industry data investigation" (IDI) team whose responsibility is to investigate and correct data errors on GARFO's critical datasets including vessel trip reports, dealer reports, and various associated fishing activity reports, including VMS reports. QC on these datasets is performed regularly since data is securely displayed on various web portals to its owners. JIRA is the tool used for tracking quality control.
Yes
Unknown
Yes
Yes
Not needed
1 week
NCEI-MD
6 months
Access to this data is tightly controlled. Most access is read-only. Write access is given only after data owners have authorized (accompanied by a signed NDA), and data is usually edited via an access controlled application. Data is QAQC'd on a regular basis by authorized personnel, and backed up both to disk and tape on a daily basis.
Paper logbooks are submitted to staff at GARFO and subsequent data entry is completed with a custom web application. Electronic submissions will soon be allowed.
N/A
1
N/A
Organization
Greater Atlantic Regional Fisheries Office
GARFO
55 Great Republic Drive
Gloucester
MA
01930
USA
(978)281-9300
8:00 a.m. - 4:30 EST
N/A
11920
Entity
Table: PRTAGI
11921
Entity
Table: PRTAGR
11922
Entity
Table: SFOQNR
11923
Entity
Table: SFOQPR
11924
Entity
Table: SFOQVR
11925
Entity
Table: VRTAGI
11926
Entity
Table: VRTAGR
gov.noaa.nmfs.inport:1503
Tom Fletcher
2006-05-15T10:17:22
SysAdmin InPortAdmin
2022-08-09T17:10:58
2016-02-25
Greater Atlantic Regional Fisheries Office
GARFO
55 Great Republic Drive
Gloucester
MA
01930
USA
(978)281-9300
8:00 a.m. - 4:30 EST
1001
Public
No
2016-02-25
1 Year
2017-02-25