26983 SF Combined GPS, Temperature/Depth, and Effort (GTE) Data Set Published / External 23136 Northeast Cooperative Research Program (NCRP) Project Completed Temperature, depth(TD), GPS and haul by haul effort and catch data are collected during normal fishing activity of commercial fishing vessels participating in the NEFSC Cooperative Research Study Fleet (SF) program. The GTE (GPS, Temperature/Depth, and Effort) procedure joins the temperature depth (TD), GPS and effort level electonic logbook data into one combined data set. This data set is then loaded and reviewed in an application for quality and is edited and coded appropriately. All sound data resulting from this review is moved to 'GTE_JOIN' table. In addition, a summary table 'GTE_EFFORTS' is maintained which, include calculations for various effort level statistics on the joined data such as, but not limited to, effort duration, distance towed, min, max, and average depth. Joins the Temperature Depth (TD), GPS and Effort Level Electonic Logbook data into one combined dataset. The GTE dataset can be used to validate and improve oceaongraphic models as well as be used with catch data to analyse how TD temporarily and spaitially influence catch. The GTE data is housed and managed using various support tables in the NEFSC Oracle database. An event code table 'GTE_CODES' defines the data quality issues encountered when GPS data is joined with TD and Effort data. Theme Cooperative Research Theme Depth Theme Fishery Dependent Data Theme Fishery Dependent Effort Theme GPS polling Theme Study Fleet Program Theme Temperature Theme Temperature/Depth Temporal continuing Spatial Georges Bank Spatial Gulf of Maine Spatial Mid-Atlantic Spatial Northwest Atlantic Spatial Southern New England Stratum benthic Stratum demersal Stratum pelagic NEFSC Woods Hole Lab Woods Hole MA USA Data Set Oracle Database Continually Table (digital) Various Fishing Vessel GPS Units, Aqualogger 530 Temperature Depth probes, Star-Oddi DST Centi Temperature Depth Probes, Vemco Temperarure Depth Probes, Dell laptops with various models and operating systems running Northeast Fisheries Sceince Center Fisheries Logbook Data Recording Software (FLDRS) Fishing gear, Fishing vessel Otter trawl door, scallop dredge, gillnet, longline 34624 GTE_CODES Published / External Completed Description of all the codes used in the GTE data editing process. Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Description of all the codes used in the GTE data editing process. 1 GTE_CODE VARCHAR2 5 Yes Yes Active A unqiue identifier of a data quality issue. VARCHAR2 2 GTE_CODE_LEVEL VARCHAR2 2 Yes No Active A code that signifies the severity of data issue/error encountered; fatal=F informative=I VARCHAR2 3 GTE_CODE_DESCR VARCHAR2 255 Yes No Active A description of each code used in the data editing process. VARCHAR2 34625 GTE_EDITING_LIST Published / External Completed Communicates effort editing issues among users of the SF GTE application Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Communicates effort editing issues among users of the SF GTE application 1 TRIP_ID NUMBER 22 Yes No 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 3 No No Active Unique identifier representing an effort documented in a trip VARCHAR2 3 EFFORT_STATUS VARCHAR2 2 Yes No Active Event codes used to track effort status in edtiing process VARCHAR2 4 DATA_ISSUE VARCHAR2 255 Yes No Active Data quality issue(s) that exist for a specific effort VARCHAR2 5 DATA_ACTION VARCHAR2 255 No No Active Action needed/taken to resolve the issue VARCHAR2 6 RESOLVED NUMBER 22 Yes No 1 0 Active Denotes whether or not the documented issue has been resolved; Yes=1 No=0 NUMBER 7 USER_ISSUE VARCHAR2 15 Yes No Active The ID of the user who documented the issue; supporting table NERS.SF_USERS VARCHAR2 8 USER_ACTION VARCHAR2 15 No No Active The ID of the USER who recognized/resolved issue; supporting table NERS.SF_USERS VARCHAR2 34626 GTE_EFFORTS Published / External Completed Summary statistics for each complete effort contained in NERS.GTE_JOIN Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Summary statistics for each complete effort contained in NERS.GTE_JOIN 1 TRIP_ID NUMBER 22 Yes Yes 38 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 4 Yes Yes Active Unique identifier representing an effort documented in a trip VARCHAR2 3 TOTAL_NUM_RECORDS NUMBER 22 No No 4 0 Active Total number of records for an effort NUMBER 4 PERCENT_RECORDS_MATCH NUMBER 22 No No 3 0 Active Percentage of the total number of records where there is a valid TD-GPS match NUMBER 5 START_HAUL_DATE_GMT DATE 7 No No Active Date and time in Greenwich Mean Time of the start of the effort based data corrected in GTE processing DATE 6 END_HAUL_DATE_GMT DATE 7 No No Active Date and time in Greenwich Mean Time of the end of the effort based data corrected in GTE processing DATE 7 CALC_DUR_HR NUMBER 22 No No 4 2 Active Duration of the effort in hours NUMBER 8 CALC_DIST_NM NUMBER 22 No No 5 2 Active Total distance towed in nautical miles NUMBER 9 MIN_TEMP_C NUMBER 22 No No 4 2 Active Min temperature in Celsius NUMBER 10 MEAN_TEMP_C NUMBER 22 No No 4 2 Active Mean temperature in Celsius NUMBER 11 MAX_TEMP_C NUMBER 22 No No 4 2 Active Max temperature in Celsius NUMBER 12 TEMP_VARIANCE NUMBER 22 No No 4 2 Active Temperature variance value NUMBER 13 TEMP_DEVIATION NUMBER 22 No No 4 2 Active Standard deviation of temperature NUMBER 14 MIN_DPTH_M NUMBER 22 No No 5 2 Active Min depth in meters NUMBER 15 MEAN_DPTH_M NUMBER 22 No No 5 2 Active Mean depth in meters NUMBER 16 MAX_DPTH_M NUMBER 22 No No 5 2 Active Max depth in meters NUMBER 17 DPTH_VARIANCE NUMBER 22 No No 6 2 Active Depth variance value NUMBER 18 DPTH_DEVIATION NUMBER 22 No No 5 2 Active Standard deviation of depth NUMBER 19 MIN_SPD_NMPH NUMBER 22 No No 4 2 Active Min vessel speed in nautical miles per hour NUMBER 20 MEAN_SPD_NMPH NUMBER 22 No No 4 2 Active Mean vessel speed in nautical miles per hour NUMBER 21 MAX_SPD_NMPH NUMBER 22 No No 4 2 Active Max vessel speed in nautical miles per hour NUMBER 22 SPD_VARIANCE NUMBER 22 No No 4 2 Active Speed variance value NUMBER 23 SPD_DEVIATION NUMBER 22 No No 4 2 Active Standard deviation of speed NUMBER 24 GTE_CODE VARCHAR2 30 No No Active GTE codes for the effort; supporting table NERS.GTE_CODES VARCHAR2 25 GEAR_CODE VARCHAR2 6 No No Active ACCSP Gear type code; supporting table FVTR.FVTR_GEAR_CODES VARCHAR2 34627 GTE_JOIN Published / External Completed Data from sucessfully joined and edited efforts Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Data from sucessfully joined and edited efforts 1 TRIP_ID NUMBER 22 Yes No 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 VP_NUM NUMBER 22 No No 38 Active Federal vessel permit number NUMBER 3 PROBE_LOG_ID NUMBER 22 Yes Yes 38 Active Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG NUMBER 4 EFFORT_NUM VARCHAR2 4 Yes No Active Unique identifier representing an effort documented in a trip based data corrected in GTE processing VARCHAR2 5 TD_DATETIME DATE 7 Yes Yes Active Date and time in Greenwich Mean Time from a single TD probe reading DATE 6 TEMP NUMBER 22 No No 38 Active Temperature (Celisus) from a single TD probe reading NUMBER 7 GEAR_DEPTH NUMBER 22 No No 38 Active Gear depth (meters) from a single TD probe reading NUMBER 8 GPS_DATETIME DATE 7 No No Active Date and time in Greenwich Mean Time from a single GPS reading DATE 9 LATITUDE NUMBER 22 No No 12 6 Active Latitude value from a single GPS reading NUMBER 10 LONGITUDE NUMBER 22 No No 12 6 Active Longitude value from a single GPS reading NUMBER 11 COURSE_TRUE NUMBER 22 No No 6 2 Active Heading (degrees) from a single GPS reading NUMBER 12 BOT_DEPTH_M NUMBER 22 No No 6 1 Active Depth sounder reading (meters) NUMBER 13 TOW_EVENT_CODE VARCHAR2 30 No No Active Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES VARCHAR2 34628 GTE_JOIN_AUDIT Published / External Completed Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI 1 TRIP_ID NUMBER 22 Yes No 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 VP_NUM NUMBER 22 No No 38 Active Federal vessel permit number NUMBER 3 PROBE_LOG_ID NUMBER 22 No No 38 Active Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG NUMBER 4 EFFORT_NUM VARCHAR2 4 No No Active Unique identifier representing an effort documented in a trip VARCHAR2 5 EFFORT_NUM_CORRECTION VARCHAR2 4 No No Active Documents the adjusted start and end times for an effort VARCHAR2 6 TD_DATETIME DATE 7 Yes No Active Date and time in Greenwich Mean Time from a single TD probe reading DATE 7 TEMP NUMBER 22 No No 38 Active Temperature (Celisus) from a single TD probe reading NUMBER 8 GEAR_DEPTH NUMBER 22 No No 38 Active Gear depth (meters) from a single TD probe reading NUMBER 9 GPS_DATETIME DATE 7 No No Active Date and time in Greenwich Mean Time from a single GPS reading DATE 10 LATITUDE NUMBER 22 No No 12 6 Active Latitude value from a single GPS reading NUMBER 11 LONGITUDE NUMBER 22 No No 12 6 Active Longitude value from a single GPS reading NUMBER 12 SPEED_KNOTS NUMBER 22 No No 6 2 Active Speed of the vessel from a single GPS reading NUMBER 13 COURSE_TRUE NUMBER 22 No No 6 2 Active Heading (degrees) from a single GPS reading NUMBER 14 BOT_DEPTH_M NUMBER 22 No No 6 1 Active Depth sounder reading (meters) NUMBER 15 RATE_OF_CHANGE NUMBER 22 No No 6 2 Active Calculates rate of changes in gear depth to identify the possible start or end of an effort NUMBER 16 LEAD_RATE NUMBER 22 No No 6 2 Active Calculates rate of changes in gear depth to identify the possible start or end of an effort NUMBER 17 RN NUMBER 22 No No 38 Active A SQL generated row number for the joined data NUMBER 18 EFFORT_TYPE VARCHAR2 10 No No Active Identifies possible start or end effort events based on the values in the RATE_OF_CHANGE and LEAD_RATE columns VARCHAR2 19 TOW_EVENT_CODE VARCHAR2 30 No No Active Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES VARCHAR2 34629 GTE_LOAD_HISTORY Published / External Completed Tracks a trip/effort through the data editing process, providing data quality information at each step Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Tracks a trip/effort through the data editing process, providing data quality information at each step 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 4 Yes Yes Active Unique identifier representing an effort documented in a trip VARCHAR2 3 POPULATE_TABLE_CODE VARCHAR2 15 Yes No Active Code identifying results from GTE join procedure; supporting table NERS.GTE_CODES VARCHAR2 NERS.GTE_CODES 4 POPULATE_TABLE_DATE DATE 7 Yes No Active Date the GTE join procedure was run DATE 5 POPULATE_TABLE_USER VARCHAR2 20 Yes No Active Staff member that ran the GTE join procedure; supporting table NERS.SF_USERS VARCHAR2 6 EFFORT_CORR_CODE VARCHAR2 30 No No Active Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES VARCHAR2 7 EFFORT_CORR_DATE DATE 7 No No Active Date of latest change to record. DATE 8 EFFORT_CORR_USER VARCHAR2 20 No No Active Staff member that performed the editing; supporting table NERS.SF_USERS VARCHAR2 9 USE_CODE VARCHAR2 3 No No Active Code used to describe the appropriate analytical usage based on the quality of the data; supporting table NERS.GTE_CODES VARCHAR2 NERS.GTE_CODES 10 DATA_MOVED VARCHAR2 1 Yes No Active A yes (Y) or no (N) field stating whether or not editing was completed and data moved to the final NERS.GTE_JOIN table VARCHAR2 11 MOVE_DATE DATE 7 No No Active Date the finalized data was moved DATE 12 MOVE_USER VARCHAR2 20 No No Active Staff member that moved the data; supporting table NERS.SF_USERS VARCHAR2 13 COMMENTS VARCHAR2 255 No No Active Additional information VARCHAR2 14 EFFORT_SUMMARY VARCHAR2 1 Yes No Active States whether or not summary statistics were generated for the effort in NERS.GTE_EFFORTS; Yes (Y) or no (N) VARCHAR2 15 SUMMARY_DATE DATE 7 No No Active Date the effort summary procedure was performed DATE 16 SUMMARY_USER VARCHAR2 30 No No Active Staff member that ran the effort summary procedure; supporting table NERS.SF_USERS VARCHAR2 34630 GTE_TRIPS Published / External Completed Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip Loaded by batch 9251, 09-01-2016 15:48 Data Table Yes NERS Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip 1 TRIP_ID NUMBER 22 Yes Yes 38 Active Unique trip identifier generated in FLDRS software NUMBER 2 LOAD_STATUS NUMBER 22 Yes No 38 Active Current status of the trip in the editing process; supporting table NERS.GTE_CODES NUMBER 3 COMMENTS VARCHAR2 255 No No Active Trip level comments VARCHAR2 Data Steward 2011 Person Morin, Michael D mike.morin@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3278 401-782-3292 Distributor 2011 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Metadata Contact 2015 Person Burchard, Katie A katie.burchard@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3251 401-782-3292 Originator 2011 Person Morin, Michael D mike.morin@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3278 401-782-3292 Originator 2011 Person Burchard, Katie A katie.burchard@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3251 401-782-3292 Point of Contact 2011 Person Burchard, Katie A katie.burchard@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3251 401-782-3292 -76.31 -66 43.995833 35.554722 Continuing 2006-09-20 The first Study Fleet effort that was sucessfully joined to TD and GPS data occurred on September 20, 2006. Sensitive Formal data request form is filled out and sent to Point of Contact, reviewed with Cooperative Research Program Branch Chief for approval. If approved, data request form is signed, returned and archived. NEFSC Data Access Constraint: If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access. Oracle database on centralized data management system Data quality documented in tables reference GTE_Code column in GTE_Efforts Table with code description in GTE_CODES support table. All effort where a join to TD and GPS was attempted is documented in GTE_LOAD_HISTORY. This table documents weather the join was successful or not and if not the possible reason why. This table has a supporting table "GTE_CODES" An application is used to review, edit and code data quality issues. The codes are documented under the GTE_Code column in GTE_Efforts . Reference support table GTE_CODES. Yes Unknown Yes Yes 3-6 months Not applicable Other Unknown NEFSC DMS protection plan (Scheduled backups and remote storage backups) Data collection using Dell laptops with various models and operating systems running Northeast Fisheries Sceince Center Fisheries Logbook Data Recording Software (FLDRS). FVTR VERS tables, NERS TD tables and NERS GPS Polling tables are joined. 34624 Entity 34625 Entity 34626 Entity 34627 Entity 34628 Entity 34629 Entity 34630 Entity gov.noaa.nmfs.inport:26983 Patricia Jones 2015-09-16T14:49:53 SysAdmin InPortAdmin 2026-03-04T19:17:17 2016-09-01 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No No 2016-09-01 1 Year 2017-09-01