Table: SVSCAN_IMAGES
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 32184
| Published / External
Created: 2016-04-08
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 27497
ID: 32184
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: SVSCAN_IMAGES |
---|---|
Short Name | SVSCAN_IMAGES |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Table containing images of historical cruise documents where the only records that exist are paper media. |
* Purpose | |
Notes |
Loaded by batch 8508, 04-08-2016 12:31 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | SVDBS |
» Description |
Table containing images of historical cruise documents where the only records that exist are paper media. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | SCANIMG_ID | NUMBER | Unique identification number of scanned image. |
100 | No | No | SCANMASTER_ID | NUMBER | Unique identification number of a record associated with scanned images in SVDBS.SVSCAN_IMAGES table |
100 | No | No | DOCTYPE | NUMBER | 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). |
100 | No | No | DOCNO | NUMBER | A number stamped on original document for file management purposes. |
100 | No | No | STA_NUM | VARCHAR2 | Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number. |
100 | No | No | STRATUM | VARCHAR2 | 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. |
100 | No | No | TOW_NUM | VARCHAR2 | Sequential number representing order in which station was selected within a stratum. |
100 | No | No | FILENAME | VARCHAR2 | Unique name of image file, including file extension. |
100 | No | No | IMGTYPE | VARCHAR2 | Type of graphic file of the image. |
100 | No | No | IMGDATE | DATE | Date document was scanned (MM/DD/YY HH:MI:SS). |
100 | No | No | PAGENO | NUMBER | Sequence generated number used for file management. |
100 | No | No | COMMENTS | VARCHAR2 | Comments related to scanned image in SVDBS.SVSCAN_IMAGES. |
100 | No | No | DOE | DATE | Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). |
100 | No | No | UOE | VARCHAR2 | The Oracle username of the individual who entered the new record. |
100 | No | No | DOC | DATE | Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) |
100 | No | No | UOC | VARCHAR2 | The Oracle username of the individual who changed the current record. |
Attribute Details
Attribute Name | SCANIMG_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Unique identification number of scanned image. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SCANMASTER_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Unique identification number of a record associated with scanned images in SVDBS.SVSCAN_IMAGES table |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOCTYPE |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
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). |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOCNO |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
A number stamped on original document for file management purposes. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STA_NUM |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STRATUM |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOW_NUM |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sequential number representing order in which station was selected within a stratum. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FILENAME |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 35 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique name of image file, including file extension. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | IMGTYPE |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of graphic file of the image. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | IMGDATE |
---|---|
Seq. Order | 10 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date document was scanned (MM/DD/YY HH:MI:SS). |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PAGENO |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Sequence generated number used for file management. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COMMENTS |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments related to scanned image in SVDBS.SVSCAN_IMAGES. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOE |
---|---|
Seq. Order | 13 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Oracle username of the individual who entered the new record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOC |
---|---|
Seq. Order | 15 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOC |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Oracle username of the individual who changed the current record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 32184 |
---|---|
Metadata Record Created By | Patricia L Jones |
Metadata Record Created | 2016-04-08 12:31+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2019-05-31 |
Owner Org | NEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2019-05-31 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-05-31 |
Tags |
---|