Petrographic Image Capture and Archiving Tool (PICAT):User Guide
...
Author:
...
W. Crawford, C. Bennight
...
Reviewer(s):
...
J. Beck
...
Management Approval (Name, Title, Date):
...
D.J. Houpt
...
Audience:
...
Scientists
...
Origination date:
...
08/24/10
...
Current version:
...
DRAFT (1) 09/06/10
...
Revised:
...
V1.1 | 1/6/2014 (IODP-II)
...
Domain:
...
Imaging
Introduction
This system was designed to digitally photograph Petrographic Thin Section samples, capturing the entire slide in an efficient manner in both cross-polarized and single (plane)-polarized states. Microscopes are commonly used for imaging thin sections, but they do not have a field of view wide enough to image the entire specimen. A whole specimen view is needed to provide a map (or guide) showing the relationship of the entire sample to specifically captured higher-detailed regions. The most common method of obtaining a full specimen image has been with the use of a modified flat bed or film scanner. Whereas these methods have been successful in some instances, they are cumbersome, slow, and tedious when the entire workflow process is considered.
The PICAT (Petrographic Image Capture and Archival Tool) provides an easy and versatile imaging process that captures a publication-quality image (8 x 10 inches at 300 DPI) within seconds rather than minutes. When coupled with a workflow-optimized software package, the time, effort, and training needed to capture thin section image data is significantly reduced. The live image displayed on a computer monitor instantly shows errors in exposure, focus, color balance, and cropping. The operator is confident the image is correct before rendering the sample to digital state.
Apparatus and Materials
Hardware
The PICAT thin section imager consists of the following hardware:
- Kaiser Camera Stand and Photo Table
- System-V RGB Light with OSRAM HLX 12V 100W Bulb
- Canon EOS 5D Mark II Camera
- Lenses
- Canon MP-E 65 mm 1x–5x Macro Lens
- Cannon EP 100 mm IS Macro Lens
- B&W 95 mm Diameter Linear Polarizing Glass Filter Element (2)
- Custom Filter Module with Friction Wheel
- Specimen Holders
- HP LP3065 Wide Gamut 30 inch LCD Monitor
- HP xw4400 PC Workstation
Camera
The camera for this system is a Canon 5D Mark II with video capability. The sensor is a CMOS full-frame sensor with a resolution of 21 megapixels. The camera produces "Live View" images that can be displayed on a tethered computer system. The system is also capable of 1920 x 1080 video. The camera system is considered a prosumer type model and therefore has simple settings such as the "green box," choices of program modes, or manual operation. Refer to the camera manual for more detailed information.
The camera is powered by an AC adaptor. Menu items and presets on the camera are as needed. Raw files plus a small JPEG file is the production setting for the camera at this time.
The camera colorspace is SRGB. As the Raw file the color space is assignable postprocessing and will be archived; the larger colorspace of Adobe 1998 will be added later. The camera provides the smaller JPEG file. This smaller file is used by the scientist for onboard use and the Web. SRGB colorspace is used for Web, JPEGs, and printing.
Lenses
This system uses two lenses.
- A 100 mm macro lens for images of the full thin section or smear slide. This pro-quality lens with auto-focus is recommended for production-type tasks such as recording an entire slide. This lens, coupled with the slide carrier, simplifies the task of image capture.
- The 65 mm macro lens used in this system is one of a kind in the industry. It is capable of 1x–5x magnification. This magnification refers to projection of the size of the image to the sensor plane. For example, an image of a dime is projected to the sensor at full size when the lens is set to 1x and focused at that point. At 5x the coin is projected at 5 times full size at the sensor plane. A total of 21 million pixels projected via a 30 inch monitor results in a magnification of 2500% at a setting of 1x when viewing the image at 100%. If the camera is set to capture at 5x, the effective magnification is 12,500%. This is variable to the output device and resolution of that device.
Imaging with such a sensor size and lens combination approaches the range and exceeds some low-end microscope/camera combinations. In addition to the field of view and ease of operation, this system has advantages over other current imaging systems.
Details about the camera operation and the software are available in the Canon 5D operations manual and disk provided with the system.
Filter Module and Friction Wheel
The filter module is the unique part of this system and is the only component that was custom designed and manufactured for this system. The entire module when assembled weighs about 10 lb.
Overview
Microscopes commonly spin or rotate the sample, allowing the viewer to explore the birefringence. In this system, spinning of the sample was not an option because the sample orientation and the camera sensor must remain fixed. Instead, a unique magnetic coupling linkage was designed to allow the filters to turn in unison, negating the need for a spinning image sensor. Having the filters turn synchronously while in a cross-polarized state allows control of orientation and precise cropping of the image.
This approach to viewing the birefringence and the ability to precisely choose the degrees of rotation to achieve specific visual states in select crystal structures within the sample is not possible with flatbed scanners or modified film scanners.
Another distinct advantage of this filter configuration is the ease of cleaning and minimizing the effect of dust and lint in the light path. Converse to film or flatbed scanners, the light path can be monitored for unwanted foreign matter. Because the filters lay far out of the field of focus, overlooked dust or lint is never recorded, resulting in a clean usable image that requires no clean-up postprocessing.
Description
The module consists of a top plate holding the analyzer filter (top filter), a stage with appropriate attachments to hold the thin section sample, and an additional plate to hold the polarizing filter. The specimen stage is bolted to a center mounting block, while the filter plates are attached in a manner that allows them to rotate in and out of the light path. Each of the filter plates houses a 95 mm polarizing filter within a rotating ring to allow rotational adjustment. In addition, a friction wheel-shaft-coupling allows both of the filters to turn in a synchronized manner. The top filter platform houses the filter ring, and its analyzer filter is recessed within that ring to achieve the lens barrel clearance required when certain lenses are used at maximum magnification.
The bottom filter ring platform and filter ring is configured differently to allow the rotation of the polarizing filter to the housing ring to achieve the cross-polarized state.
Specimen Holders
Currently there are two styles of holders: standard specimen carrier and X/Y style specimen holder. These holders are similar to what might be found in a Photography Darkroom Enlarger being used as a negative or slide holder.
Standard Specimen Carrier
The standard specimen holder has 2 rails on either side of the specimen stage that serve as sliders to center the slide under the center of the sensor on the camera. This assures ease of cropping and faster operations when multiple specimens are imaged in a short period of time. The standard specimen holder also ensures consistency in cropping and alignment of the image in the camera, eliminating the need to crop the image in postproduction. The standard specimen carriers hold 1 x 2 inch or 2 x 3 inch specimens.
X/Y Style
The X/Y specimen holder is used in the following circumstances:
- Specimens are not of the standard size.
- Higher magnifications are necessary.
- The image must be taken off dead center
The X/Y style specimen holder allows movement of the specimen through different areas of the field of view when using the higher magnification settings and lenses.
Software
The thin section imager system makes use of the following software:
- Cannon EOS Control Utility
- IODP In-house "Image Capture" software
- Adobe Bridge
- Adobe Photoshop and Camera Raw (in some alternate workflows)
Cannon EOS Control Utility
Available on request from the photographers, this is a Cannon-supplied utility that provides drivers and a software interface for tethering a camera to a computer. Note that this must be installed from original Cannon CDs, as the updates available on the Internet require that the software already be installed.
This utility allows full control and settings of the camera, though typically only the photographers will be involved in the more advanced and esoteric settings. This software is what defines the capture location of images (what directory they will be written to) and in our current configuration creates the date-based subdirectories as well.
Adobe Bridge
This is installed by default when Adobe PhotoShop is installed. This software is not required for the standard workflow and essentially serves as a branching point for those who wish to edit software directly in Photoshop or some other software before upload.
Adobe PhotoShop and Camera Raw
These packages are installed when the PhotoShop suite is installed. They are not needed in the standard workflow but may be used by the photographer and others for alternate or specialized workflows.
IODP ImageCapture software
This is an-in house software package that facilitates the transfer of images and metadata to the LIMS database, as well as manages naming and location of local files on the computer. The source code for this software is located at https://shiptest.ship.iodp.tamu.edu/svn/jr/NET/CloseupCapture.
It requires the .NET 4.0 runtime (Client Profile) to be installed on the computer before it can operate. It can be installed (via click once) from http://web.ship.iodp.tamu.edu/tasapps/closeup.
The software makes use of the following
...
System:
...
Keywords:
...
This system was designed to digitally photograph Petrographic Thin Section samples, capturing the entire slide in an efficient manner in both cross-polarized and single (plane)-polarized states. Microscopes are commonly used for imaging thin sections, but they do not have a field of view wide enough to image the entire specimen. A whole specimen view is needed to provide a map (or guide) showing the relationship of the entire sample to specifically captured higher-detailed regions. The most common method of obtaining a full specimen image has been with the use of a modified flat bed or film scanner. Whereas these methods have been successful in some instances, they are cumbersome, slow, and tedious when the entire workflow process is considered.
The PICAT (Petrographic Image Capture and Archival Tool) provides an easy and versatile imaging process that captures a publication-quality image (8 x 10 inches at 300 DPI) within seconds rather than minutes. When coupled with a workflow-optimized software package, the time, effort, and training needed to capture thin section image data is significantly reduced. The live image displayed on a computer monitor instantly shows errors in exposure, focus, color balance, and cropping. The operator is confident the image is correct before rendering the sample to digital state.
Apparatus and Materials
Hardware
The PICAT thin section imager consists of the following hardware:
- Kaiser Camera Stand and Photo Table
- System-V RGB Light with OSRAM HLX 12V 100W Bulb
- Canon EOS 5D Mark II Camera
- Lenses
- Canon MP-E 65 mm 1x–5x Macro Lens
- Cannon EP 100 mm IS Macro Lens
- B&W 95 mm Diameter Linear Polarizing Glass Filter Element (2)
- Custom Filter Module with Friction Wheel
- Specimen Holders
- HP LP3065 Wide Gamut 30 inch LCD Monitor
- HP xw4400 PC Workstation
Camera
The camera for this system is a Canon 5D Mark II with video capability. The sensor is a CMOS full-frame sensor with a resolution of 21 megapixels. The camera produces "Live View" images that can be displayed on a tethered computer system. The system is also capable of 1920 x 1080 video. The camera system is considered a prosumer type model and therefore has simple settings such as the "green box," choices of program modes, or manual operation. Refer to the camera manual for more detailed information.
The camera is powered by an AC adaptor. Menu items and presets on the camera are as needed. Raw files plus a small JPEG file is the production setting for the camera at this time.
The camera colorspace is SRGB. As the Raw file the color space is assignable postprocessing and will be archived; the larger colorspace of Adobe 1998 will be added later. The camera provides the smaller JPEG file. This smaller file is used by the scientist for onboard use and the Web. SRGB colorspace is used for Web, JPEGs, and printing.
Lenses
This system uses two lenses.
- A 100 mm macro lens for images of the full thin section or smear slide. This pro-quality lens with auto-focus is recommended for production-type tasks such as recording an entire slide. This lens, coupled with the slide carrier, simplifies the task of image capture.
- The 65 mm macro lens used in this system is one of a kind in the industry. It is capable of 1x–5x magnification. This magnification refers to projection of the size of the image to the sensor plane. For example, an image of a dime is projected to the sensor at full size when the lens is set to 1x and focused at that point. At 5x the coin is projected at 5 times full size at the sensor plane. A total of 21 million pixels projected via a 30 inch monitor results in a magnification of 2500% at a setting of 1x when viewing the image at 100%. If the camera is set to capture at 5x, the effective magnification is 12,500%. This is variable to the output device and resolution of that device.
Imaging with such a sensor size and lens combination approaches the range and exceeds some low-end microscope/camera combinations. In addition to the field of view and ease of operation, this system has advantages over other current imaging systems.
Details about the camera operation and the software are available in the Canon 5D operations manual and disk provided with the system.
Filter Module and Friction Wheel
The filter module is the unique part of this system and is the only component that was custom designed and manufactured for this system. The entire module when assembled weighs about 10 lb.
Overview
Microscopes commonly spin or rotate the sample, allowing the viewer to explore the birefringence. In this system, spinning of the sample was not an option because the sample orientation and the camera sensor must remain fixed. Instead, a unique magnetic coupling linkage was designed to allow the filters to turn in unison, negating the need for a spinning image sensor. Having the filters turn synchronously while in a cross-polarized state allows control of orientation and precise cropping of the image.
This approach to viewing the birefringence and the ability to precisely choose the degrees of rotation to achieve specific visual states in select crystal structures within the sample is not possible with flatbed scanners or modified film scanners.
Another distinct advantage of this filter configuration is the ease of cleaning and minimizing the effect of dust and lint in the light path. Converse to film or flatbed scanners, the light path can be monitored for unwanted foreign matter. Because the filters lay far out of the field of focus, overlooked dust or lint is never recorded, resulting in a clean usable image that requires no clean-up postprocessing.
Description
The module consists of a top plate holding the analyzer filter (top filter), a stage with appropriate attachments to hold the thin section sample, and an additional plate to hold the polarizing filter. The specimen stage is bolted to a center mounting block, while the filter plates are attached in a manner that allows them to rotate in and out of the light path. Each of the filter plates houses a 95 mm polarizing filter within a rotating ring to allow rotational adjustment. In addition, a friction wheel-shaft-coupling allows both of the filters to turn in a synchronized manner. The top filter platform houses the filter ring, and its analyzer filter is recessed within that ring to achieve the lens barrel clearance required when certain lenses are used at maximum magnification.
The bottom filter ring platform and filter ring is configured differently to allow the rotation of the polarizing filter to the housing ring to achieve the cross-polarized state.
Specimen Holders
Currently there are two styles of holders: standard specimen carrier and X/Y style specimen holder. These holders are similar to what might be found in a Photography Darkroom Enlarger being used as a negative or slide holder.
Standard Specimen Carrier
The standard specimen holder has 2 rails on either side of the specimen stage that serve as sliders to center the slide under the center of the sensor on the camera. This assures ease of cropping and faster operations when multiple specimens are imaged in a short period of time. The standard specimen holder also ensures consistency in cropping and alignment of the image in the camera, eliminating the need to crop the image in postproduction. The standard specimen carriers hold 1 x 2 inch or 2 x 3 inch specimens.
X/Y Style
The X/Y specimen holder is used in the following circumstances:
- Specimens are not of the standard size.
- Higher magnifications are necessary.
- The image must be taken off dead center
The X/Y style specimen holder allows movement of the specimen through different areas of the field of view when using the higher magnification settings and lenses.
Software
The thin section imager system makes use of the following software:
- Cannon EOS Control Utility
- IODP In-house "Image Capture" software
- Adobe Bridge
- Adobe Photoshop and Camera Raw (in some alternate workflows)
Cannon EOS Control Utility
Available on request from the photographers, this is a Cannon-supplied utility that provides drivers and a software interface for tethering a camera to a computer. Note that this must be installed from original Cannon CDs, as the updates available on the Internet require that the software already be installed.
This utility allows full control and settings of the camera, though typically only the photographers will be involved in the more advanced and esoteric settings. This software is what defines the capture location of images (what directory they will be written to) and in our current configuration creates the date-based subdirectories as well.
Adobe Bridge
This is installed by default when Adobe PhotoShop is installed. This software is not required for the standard workflow and essentially serves as a branching point for those who wish to edit software directly in Photoshop or some other software before upload.
Adobe PhotoShop and Camera Raw
These packages are installed when the PhotoShop suite is installed. They are not needed in the standard workflow but may be used by the photographer and others for alternate or specialized workflows.
IODP ImageCapture software
This is an-in house software package that facilitates the transfer of images and metadata to the LIMS database, as well as manages naming and location of local files on the computer. The source code for this software is located at https://shiptest.ship.iodp.tamu.edu/svn/jr/NET/CloseupCapture.
It requires the .NET 4.0 runtime (Client Profile) to be installed on the computer before it can operate. It can be installed (via click once) from http://web.ship.iodp.tamu.edu/tasapps/closeup.
The software makes use of the following Web services:
- Resteasy-lims-webservices
- Creates tests (TSIMAGE) and logs data and files to those tests
- Enumerates lists of samples based on expedition/site/hole/sampletype(s)
- Validates scanned in text_id's
- Image-tiling-services
- Triggers the automatic generation of a close-up image tileset when an image is uploaded to asman (image tileset as web/imagetiles/EXP???/thinsections/ )
...
1. Select the type of specimen holder (for instructions on changing to the X/Y stage holder see Hardware > Specimen Holders > > Installing the X/Y Style Holder).
...
3. Two polarization filter holders, one above the tray and one under it, are coupled by a magnetic linkage. The entire assembly can assembly can be rotated out of the way as needed. The filters can be rotated independently or together (the former by turning the polarizing [bottomthe polarizing [bottom] filter while preventing the filter holder from rotating, the latter by turning the white linkage knob).
...
11. The preview window can be ignored/closed without affecting anything. If Adobe Bridge is already loaded, its icon will flash in the the taskbar (burnt-orange square with the letters "Br"). If Bridge is not already loaded, it will open automatically after a few moments.
12. No action needs to be taken in Bridge at this point. Close/minimize Bridge at any time. The camera automatically creates and saves the saves the JPEG and RAW files.
Processing and Uploading the Image
...
4. Once a sample has been selected, the sample text_id field populates and a new label is generated in the top right that indicates the the new filename, based on the sample selected. If multiple pictures were taken of the same sample, the filename is appended with _2, _3, _4, etc., based on the number of previous images taken and processed. Fill out the rest of the values based on the conditions conditions when the image was taken. In the comments field, enter the description from the Thin Section Request form and the name of the requestor (e.g. "Fossiliferous limestone. Jane Doe.")
5. Click Upload to open a window indicating the upload status. When the upload process is finished another dialog box will appear appear indicating that the process is complete
...
6. Once uploaded, the selected image is removed from the pending uploads list and loaded into LIMS. Continue processing additional imagesadditional images.
7. After upload, the images are moved to the archive folder (at the same level as the capture folder). Under the archive folder are 3 3 subfolders:
- JPEG
- TIFF (tiffs are not generally created in the standard workflow)
- RAW
...
1. Rotate the camera height adjustment wheel to give at least 12 inches of clearance between the camera lens and the top filter filter assembly.
2. Lift the top filter assembly upward until it disengages from the stage plate under it. Keep the unit oriented in the normal position so filter so filter parts do not fall out.
3. Slide the specimen holder out and begin loosening the bolts holding in the slide rails on the right side. Remove the bottom two bolts two bolts and loosen the tip bolt.
4. Rotate the right rail out of the way
...
As stated earlier, the magnetic couplings are very powerful and exert a force in rotation equal to 5-inch-pounds. The 16 mm gap weakens that force in order ease the movement of the top and bottom filter stage plates in and out of the light path. This also serves to lessen the downward pull (top filter plate) and upward pull (bottom filter plate) that introduce a frictional force that is harmful to the free synchronous rotation of the filter holder rings.The "take home message" here is: assembly of the magnetic couplings with too small a gap is bad. Assembly of the lower magnetic coupling above the surface of the specimen plate is bad.to lessen the downward pull (top filter plate) and upward pull (bottom filter plate) that introduce a frictional force that is harmful to the free synchronous rotation of the filter holder rings.
The "take home message" here is: assembly of the magnetic couplings with too small a gap is bad. Assembly of the lower magnetic coupling above the surface of the specimen plate is bad.
Accessories
The light source for the PICAT is a color head from Kaiser. It has to be run with one of the transformers from Kaiser. A halogen bulb is situated inside the color head, that might burn out (see specs of the bulb below). Open the head box where the black cooling grid is screwed in with 2 screws, pull out the bulb and replace it.
Website for replacement parts: https://kaiserfotous.com/products/dark-room/
Color Head for Enlarger | Transformer with Voltage Stabilization | Transformer |
|---|---|---|
| CATALOG #: 204544 | CATALOG #: 204451 | CATALOG #: 204453 |
Equipped with dichroic interference filters, calibrated in desitometric units up to 180. The dials are indirectly illuminated. Continuously adjustable, illuminated density aperature up to 60 densitometric densities (= two aperature settings). Best possible light distribution due to special diffusor plate. Requires transformer 204451 or 204453 to operate. Items Include: | Output power: 100 W Dimensions: approx. 120 x 80 x 140 mm (4.7 x 3.1 x 5.5 in.) Available for 230 V, 240 V, and 120 V Fuse: 1,6 AT (230/240 V) / 2,5 AT (120 V) 4451: Transformer with starting-current limitation and electronic voltage stabilization. For compensation of voltage deviations (for constant color temperature). Input: 230 V, + 10%, -15%, 50 Hz Output: 11,5 V ± 1%, 50 Hz | Output power: 100 W Dimensions: approx. 120 x 80 x 140 mm (4.7 x 3.1 x 5.5 in.) Available for 230 V, 240 V, and 120 V Fuse: 1,6 AT (230/240 V) / 2,5 AT (120 V) 4453: without voltage stabilization Input: 230 V, 50 Hz Output: 12 V, 50 Hz |
|
|
|
|
|
|
LIMS Component Table
| ANALYSIS | TABLE | NAME | ABOUT TEXT |
| TSIMAGE | SAMPLE | Exp | Exp: expedition number |
| TSIMAGE | SAMPLE | Site | Site: site number |
| TSIMAGE | SAMPLE | Hole | Hole: hole number |
| TSIMAGE | SAMPLE | Core | Core: core number |
| TSIMAGE | SAMPLE | Type | Type: type indicates the coring tool used to recover the core (typical types are F, H, R, X). |
| TSIMAGE | SAMPLE | Sect | Sect: section number |
| TSIMAGE | SAMPLE | A/W | A/W: archive (A) or working (W) section half. |
| TSIMAGE | SAMPLE | text_id | Text_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples. |
| TSIMAGE | SAMPLE | sample_number | Sample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table. |
| TSIMAGE | SAMPLE | label_id | Label identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples. |
| TSIMAGE | SAMPLE | sample_name | Sample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter. |
| TSIMAGE | SAMPLE | x_sample_state | Sample state: Single-character identifier always set to "W" for samples; standards can vary. |
| TSIMAGE | SAMPLE | x_project | Project: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises |
| TSIMAGE | SAMPLE | x_capt_loc | Captured location: "captured location," this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2 |
| TSIMAGE | SAMPLE | location | Location: location that sample was taken; this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2 |
| TSIMAGE | SAMPLE | x_sampling_tool | Sampling tool: sampling tool used to take the sample (e.g., syringe, spatula) |
| TSIMAGE | SAMPLE | changed_by | Changed by: username of account used to make a change to a sample record |
| TSIMAGE | SAMPLE | changed_on | Changed on: date/time stamp for change made to a sample record |
| TSIMAGE | SAMPLE | sample_type | Sample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ) |
| TSIMAGE | SAMPLE | x_offset | Offset (m): top offset of sample from top of parent sample, expressed in meters. |
| TSIMAGE | SAMPLE | x_offset_cm | Offset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm) |
| TSIMAGE | SAMPLE | x_bottom_offset_cm | Bottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm) |
| TSIMAGE | SAMPLE | x_diameter | Diameter (cm): diameter of sample, usually applied only to CORE, SECT, SHLF, and WRND samples; however this field is null on both Exp. 390 and 393, so it is no longer populated by Sample Master |
| TSIMAGE | SAMPLE | x_orig_len | Original length (m): field for the original length of a sample; not always (or reliably) populated |
| TSIMAGE | SAMPLE | x_length | Length (m): field for the length of a sample [as entered upon creation] |
| TSIMAGE | SAMPLE | x_length_cm | Length (cm): field for the length of a sample. This is a calculated field (length, converted to cm). |
| TSIMAGE | SAMPLE | status | Status: single-character code for the current status of a sample (e.g., active, canceled) |
| TSIMAGE | SAMPLE | old_status | Old status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample |
| TSIMAGE | SAMPLE | original_sample | Original sample: field tying a sample below the CORE level to its parent HOLE sample |
| TSIMAGE | SAMPLE | parent_sample | Parent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR) |
| TSIMAGE | SAMPLE | standard | Standard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T) |
| TSIMAGE | SAMPLE | login_by | Login by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created]) |
| TSIMAGE | SAMPLE | login_date | Login date: creation date of the sample |
| TSIMAGE | SAMPLE | legacy | Legacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition |
| TSIMAGE | TEST | test changed_on | TEST changed on: date/time stamp for a change to a test record. |
| TSIMAGE | TEST | test status | TEST status: single-character code for the current status of a test (e.g., active, in process, canceled) |
| TSIMAGE | TEST | test old_status | TEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test |
| TSIMAGE | TEST | test test_number | TEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table. |
| TSIMAGE | TEST | test date_received | TEST date received: date/time stamp for the creation of the test record. |
| TSIMAGE | TEST | test instrument | TEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input) |
| TSIMAGE | TEST | test analysis | TEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table) |
| TSIMAGE | TEST | test x_project | TEST project: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises |
| TSIMAGE | TEST | test sample_number | TEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table |
| TSIMAGE | CALCULATED | Top depth CSF-A (m) | Top depth CSF-A (m): position of observation expressed relative to the top of the hole. |
| TSIMAGE | CALCULATED | Bottom depth CSF-A (m) | Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole. |
| TSIMAGE | CALCULATED | Top depth CSF-B (m) | Top depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user. |
| TSIMAGE | CALCULATED | Bottom depth CSF-B (m) | Bottom depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user. |
| TSIMAGE | RESULT | aperture | RESULT aperture: f-stop of the camera for this image (e.g., f/8) |
| TSIMAGE | RESULT | camera | RESULT camera: make and model number of the camera |
| TSIMAGE | RESULT | date_taken | RESULT date taken: date/time stamp the image was captured |
| TSIMAGE | RESULT | focal_length | RESULT focal length (mm): focal length of the camera |
| TSIMAGE | RESULT | iso | RESULT iso setting: ISO setting of the camera (e.g., ISO-4000) |
| TSIMAGE | RESULT | jpeg_asman_id | RESULT JPG image ASMAN_ID: serial number of the ASMAN link for the JPG/JPEG image |
| TSIMAGE | RESULT | jpeg_filename | RESULT JPG image filename: file name of the JPG/JPEG image |
| TSIMAGE | RESULT | macro | RESULT macro lens setting: multiplier from 1x to 5x if the macro lens is used (always 1x if standard lens) |
| TSIMAGE | RESULT | polarization | RESULT polarization: indicator for no polarization, single polarization, or cross polarization |
| TSIMAGE | RESULT | polarizationangle | RESULT polarization angle (deg.): angle of polarization (if measured; usually null) |
| TSIMAGE | RESULT | raw_asman_id | RESULT raw file ASMAN_ID: serial number of the ASMAN link for the raw (camera format) uploader file |
| TSIMAGE | RESULT | raw_filename | RESULT raw filename: file name for the raw (camera format) uploader file |
| TSIMAGE | RESULT | shutter_speed | RESULT shutter speed (s): shutter speed, usually expressed in a fraction of a second (e.g., 1/640 sec.) |
| TSIMAGE | SAMPLE | sample description | SAMPLE comment: contents of the SAMPLE.description field, usually shown on reports as "Sample comments" |
| TSIMAGE | TEST | test test_comment | TEST comment: contents of the TEST.comment field, usually shown on reports as "Test comments" |
| TSIMAGE | RESULT | result comments | RESULT comment: contents of a result parameter with name = "comment," usually shown on reports as "Result comments" |