Transferring Borehole Locations to the Utilities Datasheet

RockWorks | Borehole Manager | File |
Transfer | Locations -> Utilities Datasheet

This program will populate the current datasheet in the RockWorks Utilities with Location table data for selected boreholes in the current project. All required fields (Collar Coordinates tab) will transfer; you can define which of the Other Coords fields, if any, will be passed to the datasheet. The datasheet will be built with a specific column order.  Enabled boreholes will be flagged with "True" in the output Enabled column; disabled boreholes will be flagged "False". Field names and units will transfer to the datasheet's column headings.

Menu Options
Step-by-Step Summary

Menu Options

• Borehole Include Options: Choose one of the following:
  • Current: Click in this radio button to transfer the location data for only the currently selected borehole to the Utilities datasheet.
  • Enabled Only: Choose this option to transfer to the location data for only the currently enabled boreholes to the Utilities datasheet.
  • All (Enabled + Disable): Choose this option to transfer to the Uitlities datasheet the location data for all holes in the Borehole Manager.
• Other Coordinate Projection Fields to Transfer: These settings allow you to include data from the Other Coords tab in the transfer, in addition to the standard data from the Collar Coordinates tab. Choose none/any/all of the following:
  • Local Coordinates: Check this option to transfer the data stored in the Local fields.
  • Longitude/Latitude: Check this option to transfer the data stored in the Lon/Lat fields.
  • PLSS: Check this option to transfer the data stored in the PLSS fields.
  • State Plane: Check this option to transfer the data stored in the State Plane fields.
• Transfer the Coordinates at Total Depth: Check this box to have RockWorks compute the XYZ coordinates at the TD of the borehole, and include them in the transfer to the Utilities datasheet.
  
  

Step-by-Step Summary

1. Access the RockWorks Borehole Manager program tab. 
2. Open the project containing the data to be transferred, if necessary. 
3. Choose the File | Transfer | Locations  -> Utilities Datasheet menu option. 
4. Set up the transfer settings, described above.
5. Click the Process button to continue.
   
   The program will read the Location table's Collar Coordinates fields for the selected boreholes and copy this information to columns in the RockWorks Utilities datasheet. That datasheet will be brought to the front. Exported fields include borehole name, enabled status, easting, northing, surface elevation, collar elevation, total depth, Google Earth Icon, and well symbol. Any additional fields in the database's Other Coords fields which you've requested will be listed to the right of these standard fields. Column titles and units will be included.
   
   
6. Save the datasheet in the RockWorks Utilities window, if desired, using the File | Save option.  These datasheets are stored as .rwDat files. 
   

Tips 

• Use the RockWorks Utilities Map | EZ-Map or Map | Grid-Based Map tools to create point maps or 2D / 3D contour maps of the surface elevations.
• Use the Map | Line Map program to create a map with surface and TD symbols, connected with a line.
• If you make editing changes you can transfer the data back to the Borehole Manager Location tabs using the Utilities | File | Transfer | Locations -> Borehole Manager tool.  
  
  

RockWare home page