32184 SVSCAN_IMAGES Entity Published / External 27497 Historical Survey Data Archive Data Set Completed Table containing images of historical cruise documents where the only records that exist are paper media. Loaded by batch 8508, 04-08-2016 12:31 Data Table Yes SVDBS Table containing images of historical cruise documents where the only records that exist are paper media. 1 SCANIMG_ID NUMBER 22 Yes Yes 9 0 Active Unique identification number of scanned image. NUMBER 2 SCANMASTER_ID NUMBER 22 No No 9 0 Active Unique identification number of a record associated with scanned images in SVDBS.SVSCAN_IMAGES table NUMBER 3 DOCTYPE NUMBER 22 No No 5 0 Active Coding system (values 1 to 12) to reflect a category of document images. 1 = ORIGINAL DATA SHEETS (original trawl logs containing specific information and catch composition; length frequency sheets associated with species caught at a station; any type of information associated with a particular station) 2= SAILING ORDERS/INSTRUCTIONS (sailing orders; cruise instructions; cruise announcements) 3=CRUISE RESULTS (cruise results prepared by chief scientist; general post cruise information; published articles concerning a cruise) 4=TEMP/HYDRO LOGS (oceanographic logs; salinity logs; wind logs; loran logs; card 5 station index logs) 5= CRUISE TRACKS (graphic overview of where stations were occupied; hand-drawings of various station locations) 6= CRUISE NOTES/COMMENTS (cruise comments/field notes; mathematical calculations/simple statistical analyses; scientific reports for cruise; hatchling logs; gear and equipment drawings; Hardy plankton recording logs; drift bottle data logs; high speed plankton sampler logs; tagging records) 7= PRESS RELEASES (agency press releases; newspaper articles concerning a specific cruise) 8= SPECIES SUMMARIES (single species data summaries) 9= ANCILLARY STATION (anecdotal information; non-relevant cruise notes; personal logs/letters; general memos; journal articles related to more than one cruise; status of the stocks summaries; biographical information; daily messages) 10= CRUISE PROBLEM SHEETS (statements related to specific cruise problems or changes made to master data) 11= STRATA TOW SHEETS (station, haul and gear information sorted by sequential station number and sequential stratum-tow order) 12= FISHERMEN REPORTS (fishermen reports (beginning in 1972) provide station and catch information on a per cruise basis). NUMBER 4 DOCNO NUMBER 22 No No 5 0 Active A number stamped on original document for file management purposes. NUMBER 5 STA_NUM VARCHAR2 5 No No Active Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number. VARCHAR2 6 STRATUM VARCHAR2 5 No No Active A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352. VARCHAR2 7 TOW_NUM VARCHAR2 5 No No Active Sequential number representing order in which station was selected within a stratum. VARCHAR2 8 FILENAME VARCHAR2 35 No No Active Unique name of image file, including file extension. VARCHAR2 9 IMGTYPE VARCHAR2 5 No No Active Type of graphic file of the image. VARCHAR2 10 IMGDATE DATE 7 No No Active Date document was scanned (MM/DD/YY HH:MI:SS). DATE 11 PAGENO NUMBER 22 No No 5 0 Active Sequence generated number used for file management. NUMBER 12 COMMENTS VARCHAR2 50 No No Active Comments related to scanned image in SVDBS.SVSCAN_IMAGES. VARCHAR2 13 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 14 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 15 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) DATE 16 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 gov.noaa.nmfs.inport:32184 Patricia Jones 2016-04-08T12:31:45 SysAdmin InPortAdmin 2022-08-09T17:11:14 2019-05-31 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 2019-05-31 1 Year 2020-05-31