33302 OBMSZ Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Gillnet Meshsize Data Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Gillnet Meshsize Data 1 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 2 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 3 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 4 TRIPID VARCHAR2 6 No No Active May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. VARCHAR2 5 LINK1 VARCHAR2 15 No No Active 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. VARCHAR2 6 LINK4 VARCHAR2 17 No No Active Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. VARCHAR2 7 NUMNETS NUMBER 22 No No 3 0 Active Number of individual nets at mesh size. Collected for ASM where applicable. NUMBER 8 MESHSIZE NUMBER 22 No No 4 2 Active GGG: Mesh size INCHES obtained by using calipers on stretched net,or from Captain. OBMSZ: New in 2001. NUMBER 9 ACTEST VARCHAR2 1 No No Active Indicator of whether the mesh size was an actual or estimated measurement. 1 - actual, 2 = estimate, 0 = unknown. Collected for ASM where applicable. VARCHAR2 10 MSZCOMMENTS VARCHAR2 250 No No Active Additional information regarding mesh size. Collected for ASM where applicable. VARCHAR2 gov.noaa.nmfs.inport:33302 Patricia Jones 2016-07-06T08:23:40 SysAdmin InPortAdmin 2022-08-09T17:11:11 2016-07-28 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 2016-07-28 1 Year 2017-07-28