27317 SF Biological Sampling Data Data Set Published / External 23136 Northeast Cooperative Research Program (NCRP) Project Completed Northeast Cooperative Research Study Fleet (SF) Program partners with a subset of commercial fishermen to collect high quality, high resolution, haul by haul self-reported fishing data. SF staff routinely sails with program participants in order to collect independent catch weight measurements to compare to the Captains’ kept and discard records for verification.The SF Program creates a unique opportunity for the collection of biological data as well as biological samples both by vessel operators and by SF staff. Participant vessels are able to provide biological data and fish to the NEFSC for use in research relevant to species stock assessments and a better understanding of fish biology. Commercial fishermen have the ability to provide samples during periods of time when traditional sample sources are unavailable (i.e., periods when NEFSC bottom trawl surveys are not operating, periods of species closures, specific needs with respect to species presence at certain times of the year and/or in specific locations, etc.) and they can also provide additional information with regards to their encountered catch (i.e., length frequencies, sex ratios, etc.). Monitor and verify participants catch estimation of discard species. Collect biological data during periods of time when traditional sample sources are unavailable to fill in data gaps. The Biological data is housed and managed using 22 tables in the NEFSC Oracle database. Related table names begin with 'SF_BIOSAMP' Theme Cooperative Research Theme Study Fleet Program Theme age Theme biological data Theme catch estimation Theme depth Theme fishery dependent data Theme length Theme length frequency Theme maturity Theme sex Theme sex frequency Theme temperature Temporal continuous 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), various spring and dial scales for measuring fish weight. Fishing gear, Fishing vessel Otter trawl door, scallop dredge, gillnet, longline 34603 SF_BIOSAMP_AGE_TYPES Published / External Completed Types of samples used for aging Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Types of samples used for aging 1 AGE_SAMPLE_TYPE VARCHAR2 3 Yes Yes Active Unique age sample type identifier VARCHAR2 2 AGE_SAMPLE_DESCR VARCHAR2 250 Yes No Active A description of the type of sample used for aging VARCHAR2 34604 SF_BIOSAMP_BIOSAMPLE Published / External Completed Biosample data Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Biosample data 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 5 Yes No Active Trip effort Number where sample was collected VARCHAR2 3 START_HAUL_DATE_GMT DATE 7 Yes No Active Start of haul date in Greenwich Mean Time DATE 4 STAT_AREA_CODE VARCHAR2 3 Yes No Active Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS VARCHAR2 5 FISH_ID NUMBER 22 Yes Yes 3 0 Active Individual fish ID for sample NUMBER 6 SPECIES_ITIS VARCHAR2 11 Yes No Active Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES VARCHAR2 7 MARKET_CODE VARCHAR2 2 Yes No Active ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES VARCHAR2 8 GRADE_CODE VARCHAR2 2 Yes No Active ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES VARCHAR2 9 DISPOSITION_CODE VARCHAR2 3 Yes No Active ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS VARCHAR2 NERS.FVTR_DISPOSITIONS 10 LENGTH_TYPE VARCHAR2 2 Yes No Active Type of length collected; support table NERS.SF_BIOSAMP_LENGTH_TYPES VARCHAR2 NERS.SF_BIOSAMP_LENGTH_TYPES 11 LENGTH_CM NUMBER 22 No No 6 1 Active Length in centimeters NUMBER 12 WEIGHT_TYPE VARCHAR2 3 Yes No Active Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES VARCHAR2 NERS.SF_BIOSAMP_WEIGHT_TYPES 13 WEIGHT_KG NUMBER 22 No No 10 4 Active Weight in kilograms NUMBER 14 SEX_CODE NUMBER 22 Yes No 2 0 Active Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES NUMBER NERS.SF_BIOSAMP_SEX_CODES 15 MATURITY_CODE VARCHAR2 1 Yes No Active Reproductive maturity of species; support table NERS.SF_BIOSAMP_MATURITY_CODES VARCHAR2 NERS.SF_BIOSAMP_MATURITY_CODES 16 AGE_SAMPLE_TYPE VARCHAR2 3 Yes No Active Type of age sample collected; support table NERS_BIOSAMP_AGE_TYPES VARCHAR2 NERS.SF_BIOSAMP_AGE_TYPES 17 COMMENTS VARCHAR2 250 No No Active Additional information VARCHAR2 18 RECORDER VARCHAR2 20 Yes No Active Staff member who collected sample VARCHAR2 34605 SF_BIOSAMP_BIOSAMPLE_AGE Published / External Completed Biosample age data Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Biosample age data 1 AGE_SAMPLE_ID VARCHAR2 14 Yes Yes Active Unique age sample identifier VARCHAR2 2 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER NERS.SF_BIOSAMP_BIOSAMPLE 3 FISH_ID NUMBER 22 Yes No 3 0 Active Unigue fish identifier per trip NUMBER NERS.SF_BIOSAMP_BIOSAMPLE 4 READER VARCHAR2 20 No No Active Staff member who determined age VARCHAR2 5 AGE NUMBER 22 No No 3 0 Active Determined age in years NUMBER 6 ENTERED_BY VARCHAR2 20 No No Active Staff member who made the database entry VARCHAR2 7 DATE_ENTERED DATE 7 No No Active Date data was entered DATE 34606 SF_BIOSAMP_BIOSAMPLE_EXT Published / External Completed Specialized data collected on biosamples Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Specialized data collected on biosamples 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 FISH_ID NUMBER 22 Yes Yes 3 0 Active Unique fish identifier per trip NUMBER 3 BIOSAMPLE_TYPE VARCHAR2 3 Yes Yes Active Type of biological sample collected; supporting table NERS.SF_BIOSAMP_BIOSAMP_TYPES VARCHAR2 NERS.SF_BIOSAMP_BIOSAMPLE_TYPE 4 BIOSAMPLE_VALUE VARCHAR2 30 Yes No Active Sample value VARCHAR2 5 BIOSAMPLE_ID VARCHAR2 30 Yes Yes Active Unique sample identifier VARCHAR2 6 COMMENTS VARCHAR2 250 No No Active Additional information VARCHAR2 34607 SF_BIOSAMP_BIOSAMPLE_TYPES Published / External Completed Details for biosample data types Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Details for biosample data types 1 BIOSAMPLE_TYPE VARCHAR2 3 Yes Yes Active Unique biosample type identifier VARCHAR2 2 BIOSAMPLE_TYPE_DESCR VARCHAR2 250 Yes No Active Description of the type of biosample collected VARCHAR2 3 BIOSAMPLE_DATA_FORMAT VARCHAR2 10 Yes No Active Oracle database data format VARCHAR2 4 BIOSAMPLE_DATA_LENGTH NUMBER 22 Yes No 3 0 Active Number of characters allowed during data entry NUMBER 5 BIOSAMPLE_DATA_PRECISION NUMBER 22 No No 2 0 Active Number of digits allowed after the decimal point NUMBER 6 BIOSAMPLE_SAMPLE_ID_REQ NUMBER 22 Yes No 1 0 Active Indicatition of whether a samle id is required yes=1 no=0 NUMBER 7 BIOSAMPLE_DATA_TYPE_REF NUMBER 22 Yes No 38 Active Biosample data type, support table NERS.SF_BIOSAMP_DATA_TYPES NUMBER NERS.SF_BIOSAMP_DATA_TYPES 34608 SF_BIOSAMP_CATCH_EST Published / External Completed Biosample data for Study Fleet catch estimation project Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Biosample data for Study Fleet catch estimation project 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 5 Yes Yes Active Trip effort number where sample was collected VARCHAR2 3 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES VARCHAR2 4 GRADE_CODE VARCHAR2 2 Yes Yes Active ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES VARCHAR2 5 MARKET_CODE VARCHAR2 2 Yes Yes Active ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES VARCHAR2 6 DISPOSITION_CODE VARCHAR2 3 Yes Yes Active ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS VARCHAR2 NERS.FVTR_DISPOSITIONS 7 UOM VARCHAR2 2 Yes Yes Active Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE VARCHAR2 8 CATCH_AMOUNT NUMBER 22 Yes No 9 1 Active Estimated catch amount NUMBER 9 WEIGHT_TYPE_CODE VARCHAR2 2 Yes No Active Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES VARCHAR2 NERS.SF_BIOSAMP_WEIGHT_TYPES 10 COMMENTS VARCHAR2 250 No No Active Additional information VARCHAR2 11 RECORDER VARCHAR2 20 Yes No Active Technician who collected sample VARCHAR2 12 START_HAUL_DATE_GMT DATE 7 Yes No Active Start of haul date in Greenwich Mean Time DATE 34609 SF_BIOSAMP_CATCH_TYPES Published / External Completed Allowed ways to which the catch can be retained for research Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Allowed ways to which the catch can be retained for research 1 CATCH_TYPE_CODE NUMBER 22 Yes Yes 38 Active Unique catch type identifier NUMBER 2 CATCH_TYPE_DESCR VARCHAR2 255 Yes No Active The allowed ways to which the catch can be retained for research VARCHAR2 3 CATCH_TYPE_DESCR_SHORT VARCHAR2 30 Yes No Active Short description of the ways to which the catch can be retained for research VARCHAR2 34610 SF_BIOSAMP_DATA_TYPES Published / External Completed Types of biosample data collected as part of the Study Fleet Program Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Types of biosample data collected as part of the Study Fleet Program 1 DATA_TYPE NUMBER 22 Yes Yes 38 Active Unique biosample data type identifier NUMBER 2 DATA_TYPE_DESCR VARCHAR2 30 Yes No Active Biosample data type collected VARCHAR2 3 DESCR_SHORT VARCHAR2 15 Yes No Active Short description of data type VARCHAR2 34611 SF_BIOSAMP_LENGTH_FREQ Published / External Completed Biosample length frequency data Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Biosample length frequency data 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 5 Yes Yes Active Trip effort number where sample was collected VARCHAR2 3 DISPOSITION_CODE VARCHAR2 3 Yes Yes Active ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS VARCHAR2 NERS.FVTR_DISPOSITIONS 4 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES VARCHAR2 5 LENGTH_CM NUMBER 22 Yes Yes 6 1 Active Length in centimeters NUMBER 6 COUNT NUMBER 22 Yes No 38 Active Number of individuals at length NUMBER 7 LENGTH_TYPE VARCHAR2 2 Yes No Active Type of length measurement used; supporting table NERS.SF_BIOSAMP_LENGHT_TYPES VARCHAR2 NERS.SF_BIOSAMP_LENGTH_TYPES 8 RECORDER VARCHAR2 20 Yes No Active Staff member who collected sample VARCHAR2 9 STAT_AREA VARCHAR2 3 Yes No Active Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS VARCHAR2 10 START_HAUL_DATE_GMT DATE 7 Yes No Active Start haul date in Greenwich Mean Time DATE 11 SEX_CODE NUMBER 22 Yes Yes 38 Active Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES NUMBER NERS.SF_BIOSAMP_SEX_CODES 12 COMMENTS VARCHAR2 250 No No Active Additional information VARCHAR2 34612 SF_BIOSAMP_LENGTH_TYPES Published / External Completed Types of length measurments used in data collection Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Types of length measurments used in data collection 1 LENGTH_TYPE VARCHAR2 2 Yes Yes Active Unique length type identifier VARCHAR2 2 LENGTH_TYPE_DESCR VARCHAR2 250 Yes No Active Type of length measurement used VARCHAR2 34613 SF_BIOSAMP_LENWGT_CONV Published / External Completed Biosample length weight conversion data Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Biosample length weight conversion data 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 5 Yes No Active Trip effort number where sample was collected VARCHAR2 3 STAT_AREA VARCHAR2 3 Yes No Active Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS VARCHAR2 4 FISH_ID NUMBER 22 Yes Yes 3 0 Active Unigue fish identifier per trip NUMBER 5 SPECIES_ITIS VARCHAR2 11 Yes No Active Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES VARCHAR2 6 DISPOSITION_CODE VARCHAR2 3 Yes No Active ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS VARCHAR2 NERS.FVTR_DISPOSITIONS 7 GRADE_CODE_1 VARCHAR2 2 Yes No Active Initial ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES VARCHAR2 8 MARKET_CODE_1 VARCHAR2 2 Yes No Active Initial ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES VARCHAR2 9 LENGTH_CM_1 NUMBER 22 No No 6 1 Active Initial length of sample in centimeters NUMBER 10 LENGTH_TYPE_1 VARCHAR2 2 No No Active Initial length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES VARCHAR2 NERS.SF_BIOSAMP_LENGTH_TYPES 11 WEIGHT_KG_1 NUMBER 22 No No 10 4 Active Initial weight of sample in kilograms NUMBER 12 WEIGHT_TYPE_1 VARCHAR2 3 No No Active Initial Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES VARCHAR2 NERS.SF_BIOSAMP_WEIGHT_TYPES 13 GRADE_CODE_2 VARCHAR2 2 Yes No Active Secondary ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES VARCHAR2 14 MARKET_CODE_2 VARCHAR2 2 Yes No Active Secondary ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES VARCHAR2 15 LENGTH_CM_2 NUMBER 22 No No 6 1 Active Secondary length of sample in centimeters NUMBER 16 LENGTH_TYPE_2 VARCHAR2 2 No No Active Secondary length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES VARCHAR2 NERS.SF_BIOSAMP_LENGTH_TYPES 17 WEIGHT_KG_2 NUMBER 22 No No 10 4 Active Secondary weight of sample in kilograms NUMBER 18 WEIGHT_TYPE_2 VARCHAR2 3 No No Active Secondary Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES VARCHAR2 NERS.SF_BIOSAMP_WEIGHT_TYPES 19 RECORDER VARCHAR2 20 Yes No Active Staff member who collected sample VARCHAR2 20 START_HAUL_DATE_GMT DATE 7 No No Active Start haul date in Greenwich Mean Time DATE 21 COMMENTS VARCHAR2 250 No No Active Additional information VARCHAR2 34614 SF_BIOSAMP_MATURITY_CODES Published / External Completed Types of maturity stages used in data collection Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Types of maturity stages used in data collection 1 MATURITY_CODE VARCHAR2 2 Yes Yes Active Unique maturity code identifier VARCHAR2 2 MATURITY_DESCR VARCHAR2 250 Yes No Active Types of maturity stages used in data collection VARCHAR2 34615 SF_BIOSAMP_PROGRAM_CODES Published / External Completed Study Fleet biosample progam projects Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Study Fleet biosample progam projects 1 PROGRAM_CODE NUMBER 22 Yes Yes 3 0 Active Unique biosample program project code identifier NUMBER 2 PROGRAM_DESCR VARCHAR2 255 Yes No Active Project description VARCHAR2 3 PROG_DESC_SHORT VARCHAR2 30 Yes No Active Project title VARCHAR2 34616 SF_BIOSAMP_QTY_TYPES Published / External Completed Quantity types used in data collection Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Quantity types used in data collection 1 QTY_TYPE_CODE NUMBER 22 Yes Yes 2 0 Active Unique quantity type identifier NUMBER 2 QTY_TYPE_DESCR VARCHAR2 30 Yes No Active Quanitity type; weight=1 animals=2 VARCHAR2 34617 SF_BIOSAMP_REQUEST_SAMPLES Published / External Completed Data collected for biosample requests Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Data collected for biosample requests 1 SBR_REQUEST_ID VARCHAR2 15 Yes Yes Active Unique biosample request identification number VARCHAR2 2 PROGRAM_CODE NUMBER 22 Yes Yes 3 0 Active Biosample program project code;supporting table NERS.SF_BIOSAMP_PROGRAM_CODES NUMBER 3 TOTE_ID VARCHAR2 5 Yes Yes Active Tote identifier where sample was stored VARCHAR2 4 TRANSFER_BIN VARCHAR2 5 No No Active Bin identifier sample was transported in VARCHAR2 5 ELB_EFFORT_NUM VARCHAR2 5 Yes No Active Trip effort number where sample was collected VARCHAR2 6 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES VARCHAR2 7 MARKET_CODE VARCHAR2 2 Yes Yes Active ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES VARCHAR2 8 GRADE_CODE VARCHAR2 2 Yes Yes Active ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES VARCHAR2 9 DISPOSITION_CODE VARCHAR2 3 Yes Yes Active ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS VARCHAR2 10 WEIGHT_LBS NUMBER 22 Yes No 5 1 Active Weight of sample in pounds NUMBER 11 WEIGHT_TYPE VARCHAR2 2 Yes No Active Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES VARCHAR2 12 MARKET_PRICE_LB NUMBER 22 No No 7 2 Active Price paid per pound for sample NUMBER 13 COMMENTS VARCHAR2 250 No No Active Additional information VARCHAR2 14 SF_SAMPLE_COLLECTOR VARCHAR2 20 Yes No Active Staff member who collected sample VARCHAR2 15 UOE VARCHAR2 20 Yes No Active Staff member who issued BSR request VARCHAR2 16 DOE DATE 7 Yes No Active Date of entry into database DATE 17 CATCH_TYPE_CODE NUMBER 22 Yes Yes 38 Active The allowed ways to which the catch can be retained for research; support table NERS.SF_BIOSAMP_CATCH_TYPES NUMBER 18 SAMPLE_COUNT NUMBER 22 Yes No 38 Active Number of individuals purchased in sample NUMBER 34618 SF_BIOSAMP_SEX_CODES Published / External Completed Sex types used in data collection Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Sex types used in data collection 1 SEX_CODE NUMBER 22 Yes Yes 2 0 Active Unique Sex type identifier NUMBER 2 SEX_DESCR VARCHAR2 250 Yes No Active Sex type of species collected VARCHAR2 34619 SF_BIOSAMP_SEX_FREQ Published / External Completed Biosample sex frequency data Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Biosample sex frequency data 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier generated in FLDRS software NUMBER 2 EFFORT_NUM VARCHAR2 5 Yes Yes Active Trip Effort where sample was collected VARCHAR2 3 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES VARCHAR2 4 GRADE_CODE VARCHAR2 2 Yes Yes Active ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES VARCHAR2 5 MARKET_CODE VARCHAR2 2 Yes Yes Active ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES VARCHAR2 6 DISPOSITION_CODE VARCHAR2 3 Yes Yes Active ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS VARCHAR2 NERS.FVTR_DISPOSITIONS 7 SEX_CODE NUMBER 22 Yes Yes 38 Active Sex type of species collected; supporting table NERS.SF_BIOSAMP_SEX_CODES NUMBER NERS.SF_BIOSAMP_SEX_CODES 8 COUNT NUMBER 22 Yes No 38 Active Number of individuals in sex type NUMBER 9 RECORDER VARCHAR2 20 Yes No Active Staff member who recorded data VARCHAR2 10 START_HAUL_DATE_GMT DATE 7 Yes No Active Start haul date in Greenwich Mean Time DATE 11 COMMENTS VARCHAR2 255 No No Active Additional information VARCHAR2 12 STAT_AREA VARCHAR2 3 Yes No Active Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS VARCHAR2 34620 SF_BIOSAMP_TRIP_TYPES Published / External Completed Types of trip samples are collected on Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Types of trip samples are collected on 1 TRIP_TYPE_CODE NUMBER 22 Yes Yes 2 0 Active Unique trip type identifier NUMBER 2 TRIP_TYPE VARCHAR2 30 Yes No Active Trip type name VARCHAR2 3 TRIP_TYPE_DESCR VARCHAR2 255 Yes No Active Type of trip sample collected on VARCHAR2 4 TRIP_TYPE_SHORT VARCHAR2 10 Yes No Active Trip type short description VARCHAR2 34621 SF_BIOSAMP_WEIGHT_TYPES Published / External Completed Methods used to weigh samples Loaded by batch 9250, 09-01-2016 14:18 Data Table Yes NERS Methods used to weigh samples 1 WEIGHT_TYPE VARCHAR2 2 Yes Yes Active Unique weight type identifier VARCHAR2 2 WEIGHT_TYPE_DESCR VARCHAR2 250 Yes No Active Method used to weigh sample VARCHAR2 3 WEIGHT_DESCR_SHORT VARCHAR2 30 No No Active Short description for methods used to weigh sample 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 -75.201667 -67.983333 44.005 35.554722 Continuing 2007-03-24 The first Study Fleet trip where catch estimation and/or biosampling occurred on sailed on March 24, 2007. 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 Certain biological values such as lengths and weights are written at sea and later entered into an application where it is uploaded to the database. This allows for the possibility of transcribing errors. Taking the weight of fish at sea is difficult due to the unstable environemnt on a vessel. There fore weight is accurate to the nearest tenth place. Post-trip analytical adjustments can be made to correct for any bias relative to the Captains’ reported landing weight from dealer reports. In order to conduct analyses on the discard estimates customary information on the precision and bias of the Captains’ estimated weights is needed. Study Fleet staff routinely sails with program participants in order to collect independent catch weight measurements to compare to the Captains’ kept and discard records for verification. Yes Unknown Yes Yes 1-3 months Not applicable Other Unknown NEFSC DMS protection plan (Scheduled backups and remote storage backups) Dell laptops with various models and operating systems running Northeast Fisheries Science Center Fisheries Logbook Data Recording Software (FLDRS). FVTR VERS tables. 34603 Entity 34604 Entity 34605 Entity 34606 Entity 34607 Entity 34608 Entity 34609 Entity 34610 Entity 34611 Entity 34612 Entity 34613 Entity 34614 Entity 34615 Entity 34616 Entity 34617 Entity 34618 Entity 34619 Entity 34620 Entity 34621 Entity gov.noaa.nmfs.inport:27317 Patricia Jones 2015-09-21T10:12:37 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