Exporting P-Data a Text File

RockWorks | Borehole Manager | File |
Export | P-Data | P-Data -> TXT

This program will export to a text file the borehole ID, depths, XYZ coordinates, and "G" value for a selected P-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

• Logs: Expand this heading as necessary to select the boreholes whose P-Data is to be exported.
  • Single Borehole: Click in this radio button to export the data for a single borehole only.
    • Log ID: Click here to select from a drop-down list the name of the borehole whose data is to be exported.
  • All Enabled Boreholes: Click in this radio button if all boreholes that are currently enabled in the Borehole Manager are to be included in the export.
• Track: Click on this item to select the track or column in the Points (P-Data) tables containing the data values (G values) to be exported to the XYZG file.  Expand this heading to access the data filtering options.
  • Spatial (XYZ) Filtering: Insert a check in this box to activate a data filter based on spatial coordinates. Expand this heading to establish the filter settings. 
  • Filter Based on G-Values: Activate this option to establish a data filter based on the measured values, and expand the heading to establish the filter parameters.  (More.)
  • Resample at Regularly-Spaced Intervals: Check this box to resample the data.  (More.)
    Note: The Resampling option will be automatically disabled if anything other than "All Samples" (below) is selected.
  • Create Filter / Sampling Report: If you've selected any filter/resampling options, this tool will create a summary report of the results. (More.)
• Items to Include: Use these options to define what P-Data values to export:
  • All Samples: Choose this for all P-Data measurements for the selected track and the selected wells to be exported to the XYZG file.
  • Lowest P-Data Value in Each Borehole:  Only the single, lowest P-Data value for the selected track for each borehole is to be recorded for the well in the output file.
  • Highest P-Data Value in Each Borehole:  Only the single, highest P-Data value for the selected track for each borehole will be recorded to the output file.
  • Sum Of All P-Data Values in Each Borehole:  Output the sum of all values for the selected track for each borehole to the exported file.  For non-vertical boreholes, the xyz coordinates for this point will correspond with the last (lowest) P-data point in the borehole.
  • Average P-Data Value for Each Borehole:  The average of all of the values for the selected track for each borehole will be recorded in the output file.  For non-vertical boreholes, the xyz coordinates for this point will correspond with the last (lowest) P-data point in the borehole.
• ASCII (Text) File: Use these settings to define the text file details.
  • Output File: Click on this item to type in a name to assign the exported text file. The usual file name extension is ".txt".
  • Delimiter: Click on the button to the right to choose the character(s) which wil be used to separate the columns in the output file (tab, space, comma, etc.).
  • Include Column Titles: Check this box if the first row in the output file should contain the column titles.
  • View in Editor:  Insert a check here if the above-named file, once created, should be loaded automatically into the RockWorks text editor.
    
    

Step-by-Step Summary

1. Access the RockWorks Borehole Manager program tab.
2. Be sure there is P-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 | T-Data -> TXT program option.
5. Enter the requested menu settings, described above.
6. Click the Process button to continue.

The program will extract the selected data from the database, and record the borehole ID, depths, XYZ coordinates, and "G" value in the output file. If requested the data will be displayed in the RockWorks editor window.
 

Sample Output

ID     Depth  Easting    Northing     Elev     G (Gamma)
DH-01  132.0  652,967.0  5,535,293.0  1,445.0  90.0
DH-02  240.0  653,252.4  5,535,554.0  1,398.3  99.9
DH-03  171.0  652,899.0  5,535,620.0  1,471.0  95.2
DH-04  229.0  653,238.0  5,535,293.0  1,303.0  99.2
DH-05  151.0  653,051.1  5,535,349.9  1,371.9  97.1
DH-06  230.0  653,103.0  5,535,162.0  1,327.0  99.7
DH-07  213.0  653,374.0  5,535,424.0  1,332.0  99.8
DH-08  195.0  653,103.0  5,535,685.0  1,342.0  99.8
DH-09  176.0  652,831.0  5,535,424.0  1,470.0  96.6

See also

• Exporting P-Data to the Utilities Datasheet
• Exporting P-Data to CSV
• Exporting P-Data to Shapefiles
  
  

Back to Exporting Data 

RockWare home page