...
If working with other data, all you you have to make is that they have a depth column and a value column, and place the in the site folder.
Figure 3.1-1. Example of a site folder with correlation data, hole files for non-image data and hole folders for images.
Once you have imported these data, Correlator will display the directory shown in Fig. 3-2. The Correlator directory displays in the hierarchical order Site/Data type/Hole, sorted alphabetically at each level.
Figure 3-2. Data Manager view of the imported data.
...
When launching Correlator, you land on the Data Manager page. If you arrive there for the first time, you have only one function available:
...
As soon as the first data file is imported, Correlator creates a data directory for the site, using the site name from the data file, and the following data group folders:
- One folder for each imported data type. Within each data type, the imported data are represented by a line item for each hole.
- The Section Summaries folder described above, which needs one file and list item per hole.
- The Saved Tables folder where Correlator saves affine and splice tables for the site.
Here, the functions available at each directory level are summarized for general reference (Table 3.2-1).
Table 3.2-1. Summary of data management functions.
...
Function (Menu item)
...
Function description
...
Root level
...
Site level
...
Data group items
...
Data items
a number of data type folders that are explained in the Add new data section. An example corresponding the user directory example is shown in Fig. 3-2. The Correlator directory displays in the hierarchical order Site/Data type/Hole, sorted alphabetically at each level.
Figure 3.1-2. Data Manager view of the imported data.
About data types
Note that all data types that can be imported into Correlator are not managed equally:
- Regular data types in this example:
- MS STMSL
- MS WRMSL
- NaturalGamma
- Susceptibility
- Data types handled in special ways (see next section):
- Images
- Saved Tables
- Section Summaries
This is explained further in subsequent sections.
3.2. Summary of Data Manager functions
You can access numerous data management functions from context menus (right-click) at each directory level. Table 3-1 lists all the functions and tabulates the directory levels and data types where they are accessible. Figure 3-3 shows the corresponding menu windows.
Table 3.2-1. Summary of data management functions.
Function (menu item) | Function description | Root level - no data yet (Fig. 3.2-1a) | Site level - most used (Fig. 3.2-1b) | Non-image data type level (Fig. 3.2-1c) | Image data type level (Fig. 3.2-1d) | Saved Tables (Fig. 3.2-1e) | Site Summaries (Fig. 3.2-1f) |
Add new data | Import data from directory | YES | YES | YES | |||
Load | Load data for plotting in Display view. | YES | YES | YES | |||
Update | The specified file is re-imported and the information in Correlator is updated. | YES | YES | YES | |||
Delete | Remove from the Correlator database. | YES | YES | YES | |||
Disable/Enable | Disable or Enable (should read “Enabled” and “Disabled”) status determines whether the data are loaded and can be plotted in the Display view. | YES | YES | ||||
Export | Mainly used to generate affine and splice tables as CSV files that can be uploaded to LIMS. | YES | YES | ||||
View | Brings up a modal window with the data in a grid. | YES | |||||
Import affine table | Import a previously saved affine table so it could be re-applied to the data. | YES | |||||
Import splice table | Import a previously saved splice table so it could be re-applied to the data. | YES | |||||
Import legacy affine table | Only used if you want to apply an old affine table to the currently imported data. (You would need to know the difference...) | YES | |||||
Import Section Summary Files(s) | Only used if section summaries are not automatically loaded from Correlation Downloader target directory, which is the standard procedure now! | YES |
Figure 3.2-1: Context menus at different directory levels (see Table 3-1).
a b c
d e f
3.3. Add new data (non-image data types)
General case
To import new data files:
- If no data exist yet in the Correlator database, the Data Manager window is empty except for the Root item.
- Right-click on Root to get the single item on the menu, Add new data (Fig. 3.2-1a).
If non-image data exist in the directory, Correlator has created a directory with at least one Site folder.
Right-click on the top item on the menu, Add new data (Fig. 3.2-1b)
In either case, selecting Add new data opens a browser window (Fig. 3.3-1).
Browse to the data files in your directory -
...
Add new data
...
Import data from directory
...
YES
...
YES
...
YES
...
Load
...
Load data for plotting in Display view.
...
YES
...
YES
...
YES
...
Update
...
The specified file is re-imported and the information in Correlator is updated.
...
YES
...
YES
...
YES
...
Delete
...
Remove from the Correlator database.
...
YES
...
YES
...
YES
...
Disable/Enable
...
Disable or Enable (should read “Enabled” and “Disabled”) status determines whether the data are loaded and can be plotted in the Display view.
...
YES
...
YES
...
Export
...
Mainly used to generate affine and splice tables as CSV files that can be uploaded to LIMS.
...
YES
...
YES
...
View
...
Brings up a modal window with the data in a grid.
...
YES
3.3. Add new data
About data types
All data types that can be imported into Correlator are not managed equally:
- Regular data types in this example:
- MS STMSL
- MS WRMSL
- NaturalGamma
- Susceptibility
- Data types handled in special ways (see next section):
- Images
- Saved Tables
- Section Summaries
Add regular (non-image) correlation data
To import data files:
- Right-click on the top item in the Data Manager window and select Add new data.
- A browser window opens that allows you to browse to the data files in your directory of choice (
the path will stick for future imports and updates
).
Select a single file, or multiple files of the same data type (and the same format).
In the example in Fig. 3.
3-1,
the natural gamma ray data files for Holes 361-U1476A
, B and D are selected.
- A browser window opens that allows you to browse to the data files in your directory of choice (
The first 30 rows of data for each hole are displayed in the Generic Data tab (Fig. 3.3-2
-1).
For commonly used data types, all column headers and column data should be automatically and correctly populated.
If that is not the case, you get a warning and must specify at least the Depth and the Data columns using the correct selection from the column header context menu.
Click the Import button at the bottom right and the focus returns to the Data Manager tab where a data summary line is added
(Fig. 3.2-2).
Figure 3.23-1. The Import button opens in Generic Data window, where user may have to fill in the Data Type column by clicking on the header “Data Type” and selecting the appropriate item (in this case, Natural Gamma).
Figure 3.23-2. Upon importing data, line items for each data type and each hole are added in the Data Manager tab . Note the Saved Tables folder created for affine and splice tables later created. Also note the Section Summaries folder automatically created and populated with the section summaries from the LIMS registry (more on that below).
Special case: multiple files for the same data type
Correlator is trying to help you with file naming upon import. However, sometimes you may need to help Correlator learn the import data file, such as when you use correlation data from sources other than the JRSO Downloader app.
...
One of the primary objectives of stratigraphic correlation is to correlate section data from a new hole rapidly to the data from one or more previous holes to check if coring gaps in previous holes are recovered in the current hole. If coring gaps are not covered adequately due to the change in water depth (mostly due to tides, but also other environmental and operations factors), you want to provide relative coring offset (drill down interval) instructions to the drillers in near-real time.
...