Export T-Data

RockWorks | Borehole Manager | File | Export | T-Data

This program will export to a variety of formats (RwDat, CSV (Excel), Text, RTF, and Shape) the borehole ID, T-data interval depths (top, base, middle), XYZ coordinates for the intervals (top, base, middle), date, and "G" value for the interval, for a selected T-Data track, for selected boreholes. This can be used to verify data stored in the database, or to model the data in another program.

Menu Options
Step-by-Step Summary

Menu Options

• Spatial Filter: Insert a check in this box at the top of the program window to activate a data filter based on spatial coordinates. Click this button to enter the filter settings. Click the Return to Previous Menu button when you are done entering the filter settings. (More info)
• 
  
• Time Filter: Insert a check in this box at the top of the program window to filter the data based on date/time. Click this button to enter the filter settings. Click the Return to Previous Menu button when you are done entering the filter settings. (More info.)
• 
  
• Boreholes to Include: Click this tab to define which holes to include in the export.
  • All boreholes (enabled and disabled): Click in this button if the selected T-Data in ALL boreholes in the current project should be exported.
  • Only Enabled Boreholes: Click in this button if only the data in the enabled (checked) boreholes are to be exported.
  • Currently Highlighted Borehole (Single Borehole): Choose this option to export the T-Data for the current borehole only.
    • Current Borehole Name: This will default to the currently-selected borehole in the Borehole Manager. Click the down-arrow to the right to select a different borehole name from the displayed list.
    • 
      
• T-Data Track
  • Track: Select the track or column in the Time Intervals (T-Data) tables containing the data values (G values) to be exported.
  • G-Value Filter: Check this box to establish a data filter based on the measured values. Click this tab to establish the filter parameters. (More info)
  • Resample: Check this box to resample the data at regularly-spaced intervals. Click this tab to select the resampling options. (More info)
    Note: The Resampling option will be automatically disabled if anything other than "All Samples" (below) is selected.
  • 
    
• Data Type: Click this tab to define what T-Data values to export.
  • All Samples: Choose this for all T-Data measurements for the selected track and the selected boreholes to be exported.
  • Lowest Value in Each Borehole: Only the single, lowest T-Data value for the selected track for each borehole is to be recorded in the output file.
  • Highest Value in Each Borehole: Only the single, highest T-Data value for the selected track for each borehole will be recorded to the output file.
  • Sum Of All Values in Each Borehole: Output the sum of all values for the selected track for each requested borehole to the exported file. For non-vertical boreholes, the xyz coordinates for this point will correspond with the midpoint of the last (lowest) T-Data interval in the borehole.
  • Average T-Data Value for Each Borehole: The average of all of the values for the selected track for each requested borehole will be recorded in the output file. For non-vertical boreholes, the xyz coordinates for this point will correspond with the midpoint of the last (lowest) T-Data interval in the borehole.
  • 
    
• Output Options
  Click this tab to define the output format(s) for the exported data. You can select multiple options.
  • RwDat (RockWorks): Check this option for the T-Data to be exported to a RockWorks datasheet (.RwDat) format. (More info)
  • CSV (Excel): Check this option for the T-Data to be exported to a CSV file format for use in Excel. (More info)
  • TXT (Notepad): Check this option for the T-Data to be exported to a text (.txt) format. (More info)
  • RTF (Word): Check this option for the T-Data to be exported to an RTF file format for use in Word. (More info)
  • 
    
  • SHP (ArcMap): Check this option for the T-Data to be exported to a Shapefile format. Click on this tab to set up the Shapefile options.
    • Output (Shape) File:: Click to the right to type in a name to assign the Shapefile to be created. The exporter will also create the accompanying .SHX and .DBF files.
    • Null Value: If any of your borehole T-Data are missing the depth to top or base for the interval, RockWorks will store a null value for that depth. Use this prompt to define the null value to be used, such as "-999".
    • Output Type
      • Polylines: Choose this output style if you wish to see the data as polylines.
      • Points (midpoint): Choose this output style to see the data as points. Compare the images below; the left image represents lithology data displayed as polylines in ArcScene. The right image represents lithology midpoints (on top of lithology polylines for reference).

    • 

Step-by-Step Summary

1. Access the RockWorks Borehole Manager program tab.
2. Be sure there is T-Data listed for one or more boreholes.
3. Be sure the boreholes to be processed (if more than one) are shown as Enabled in the borehole listing.
4. Select the File | Export | T-Data menu option.
5. Enter the requested menu settings, described above.
6. Click the Continue button to proceed.

The program will extract the selected data from the database, and record the borehole ID, T-data interval depths (top, base, middle), XYZ coordinates for the intervals (top, base, middle), dates, and "G" value for each interval in the requested output file(s).

See also

• Adding this program to your Playlist
• Adding this program to your Favorites
• Save/load/view menu settings
• 
  

Back to Export Data 

RockWare home page