Borehole Manager | Edit | Update Symbols
Use this program to read a selected field in the database's Location table and update the symbol design for the current/active/all boreholes based on the content of a Well Status reference table. While this is typically used to assign a specific map symbol for wells based on their status ("Oil Well" or "Abandoned"), this can also be used to assign symbols based on any other information - lease name, sub-site, etc.
! This tool requires that your project database has a field in the Location table which contains information on which the symbol assignment can be based. For simplicity's sake we will refer to this field as the Well Status Field. See Setting Up Optional Fields for Borehole Locations for information about how to add or display fields in the Location table.
! This tool also requires that you have defined the relationship between the Well Status Field data entry and the symbol design in the Well Status Table.
Feature Level: RockWorks Basic and higher
Menu Options
Step-by-Step Summary
- Well Status Field Name: Click on this item to select the name of the field in the project's Location table which contains the information to be used to define the symbol style.
For example, if you had added a field to the Location table named Status, you would pick that field name from the pop-up list.
- If Term Not Found: Use these settings to tell the program what to do if the content of the Well Status field isn't defined in the Well Status table.
- Do Nothing: If RockWorks does not find a match for the borehole's Status information in the Well Status table, then the symbol will not be changed.
For example, if the Status field for the borehole contains the characters "Oil-Well" but only the terms "Oil" and "Oil Well" are in the Well Status table (e.g. no match), then the symbol will not be updated.
- Set to Default Symbol: If RockWorks does not find a match for the borehole's Status information in the Well Status table, it will re-assign the symbol to the symbol you choose here.
- Symbol: Click on the picture of the symbol to select the symbol and color to be used for the mis-matched holes.
- Include Options: Use these settings to choose whether the symbol-update process is to be applied to...
- Current: The currently-selected borehole. The default name will be shown here; you can click on the name to choose a different well name.
- Enabled Only: The enabled holes only.
- All (Enabled + Disabled): All holes.
Follow these steps to update the borehole symbols using this tool.
- Access the Borehole Manager program tab.
- If necessary, check the Well Status table to be sure your well status terms are defined, and that they are associated with the desired symbols.
- If necessary, check your project data to be sure that the well status terms are listed for the applicable boreholes.
! Tip: Use the Borehole Manager's File | Locations -> Datasheet menu option to transfer your borehole location fields to the RockWorks datasheet. There, you can quickly view and edit the data. You can transfer the modified data back to the database using the datasheet File | Transfer | Locations -> Borehole Manager menu option.
- Backup your database (recommended) using the File | Backup Database menu option.
- When you are ready to run the symbol update, select the Edit | Update Symbol Based on Status menu option.
- Establish the requested menu options as described above, and click Continue.
For each requested borehole, RockWorks will look at the term listed in the selected Location field, see if it is listed in the Well Status lookup table, and if so, assign the borehole the indicated symbol style and color. Any boreholes for which the term is not listed in the lookup table, the program will either do nothing or assign a default symbol style, as instructed.
When the process is complete, you will be returned to the main menu.
RockWare home page