RockWorks/2002 Revision History
2002/Q2
(4/1/02-6/31/02)
Bug Fix (06/23/02/MIW): Fixed the problem with missing column titles when importing Excel data into the Geological Utilities.
- Uploaded 06/17/02 -
New Feature (06/12/02/JPR): A new program called "ASCII" has been added to the File/Import/Boreholes menu. This program is used to import the data from one or more tab-delimited ASCII files into borehole files (*.bh) that are compatible with the RockWorks Borehole Manager program. In addition, to borehole data, the program can also import other data such as the project dimensions, lithology tables, stratigraphy tables, column titles, etc. The basic idea is to create a means for importing everything about a project from some other application such as a corporate database. The menu options are described as follows;
| ASCII Import Menu Options | |
| Input Files | The program has the ability to import data from a single tab-delimited ASCII file or from multiple files grouped by data type (e.g. all location data in one file, all lithology data in another file, etc.) |
| Single File | All data for all borehole(s) is stored within one tab-delimited ASCII file. Data types are delimited by XML style flags (e.g. <FRACTURES> & </FRACTURES>). The data within these "flags" are referred to a "blocks". |
| File Name | Name of single file that contains all data for all borehole(s). |
| Multiple Files | Data for all borehole(s) is stored within multiple tab-delimited ASCII files. Each file contains a particular type of data for all of the boreholes. These data types and the naming requirements are listed within the table titled "ASCII Export File Names". |
| Output Directory | Folder in which multiple tab-delimited ASCII files are stored. |
| Root Name | Each file must have a unique, "hardwired" name that will be be preceded by the "Root Name". For example, if the Root Name is set to "PROJECT_1", the downhole fracture data must be stored within a file titled "PROJECT_1_FRACTURES.TXT". |
| Input Format | Miscellaneous output options. |
| Skip Column Titles | If activated when reading from a single file, the first line of each data block (the title line) will be skipped. If activated when reading from multiple files, the first line of each file (the title line) will be skipped. |
| Decimal Places | It is possible to define the number of decimals places that are used when saving real numbers. |
| Horizontal Units | Decimal places within easting and northings. Note: This setting does not apply to longitude and latitude - they are "hardwired" at six decimal places. This setting is also used for the x and y values (if they are being used). |
| Vertical Units | Decimal places within downhole distances (depths). This setting is also used for the "z" values (if they are being used). |
| I-Data Units | Decimal places used when saving downhole interval-based data (e.g. geochemistry). |
| P-Data Units | Decimal places used when saving downhole point-based data (e.g. geophysics). |
| Items To Import | It is possible to control what type of data will be imported from the ASCII file(s). |
| Project Dimensions | Project dimensions. This data will replace the settings within the View/Project menu. |
| Lithology Table | This data will replace the items within the current Lithology table. |
| Stratigraphy Table | This data will replace the items within the current Stratigraphy table. |
| I-Data Titles | Geochemistry tab column titles. Note: I-Data titles must be imported if I-Data is being imported. Otherwise, the program will use the default I-Data titles. |
| P-Data Titles | Geophysics tab column titles. Note: P-Data titles must be imported if P-Data is being imported. Otherwise, the program will used the default P-Data titles. |
| Locations | All data to be stored within the Locations tab. Note: The Location data MUST be imported. It is the "key" upon which all of the other data sets are based. |
| Orientations | All data to be stored within the Orientation tab. |
| Lithology | All data to be stored within the Lithology tab. |
| Stratigraphy | All data to be stored within the Stratigraphy tab. |
| I-Data | All data to be stored within the Geochemistry tab. Note: The sampling intervals need not be the same for different data sets. For example, Benzene could be sampled at the following depths: 0-1, 1-2, 2-3, etc, while PCB's could be sampled like this; 1.1-1.6, 2.2-2.8, etc. RockWorks will build an I-Data sheet that respects these different sampling intervals while sill presenting the data in a tabular view. Note: If I-Data is being imported, the I-Data Titles must also be included. Otherwise, the program will use the default I-Data titles. |
| P-Data | All data to be stored within the Geophysics tab. Note: The sampling intervals need not be the same for different data sets. For example, Gamma could be sampled at 0.5 foot intervals while resistivity could be sampled at 0.25 foot intervals. RockWorks will build a P-Data sheet that respects these different sampling intervals while sill presenting the data in a tabular view. Note: If P-Data is being imported, the P-Data Titles must also be included. Otherwise, the program will used the default P-Data titles. |
| Fractures | All data to be stored within the Fractures tab. |
| Aquifers | All data to be stored within the Water Levels tab. |
| Symbols | All data to be stored within the Symbols tab. |
| Patterns | All data to be stored within the Patterns tab. |
| Comments | All comment data to be stored within the Locations tab. |
| Overwite Options | Borehole data that is imported via this program will replace any existing files with the same designated borehole IDs. NOTE: This means that an existing borehole file will be erased and replaced with the data from the import file. This program will not selectively add or replace data from within an existing borehole file. |
| Skip Existing Files | If a BH file with the same ID already exists, it will be left intact and the program will not import the associated borehole data. |
| Replace Without Warning | If a BH file with the same ID already exists, it will be deleted and replaced with the new data. There will be no warnings. |
| Replace With Warning | If a BH file with the same ID already exists, the user will be given the opportunity to select whether or not the old file should be replaced. |
| Create New File Name | If a BH file with the same ID already exists, the program will leave the old file intact and create a new file by adding a "_1" extension to the file name. For example, if a file called "DH-22.BH" already exists, the program will save the new data within a file called "DH_22_1.BH". |
|
Sample ASCII Input File |
| <DIMENSIONS> X-Min X-Max X-Spacing Y-Min Y-Max Y-Spacing Z-Min Z-Max Z-Spacing 0.000 100.0 10.0 0.000 100.0 10.0 0.0 100.0 10.0 </DIMENSIONS> <LITH_UNITS> Name Pattern Size Background Foreground Percent Density G-Value Asphalt 39 2.00 0 8388863 95 0.20000 1.00000 Clay 5 3.00 65280 33023 70 0.30000 2.00000 Sand 39 2.00 12566463 255 100 0.40000 3.00000 </LITH_UNITS> <STRAT_UNITS> Name Pattern Size Background Foreground Percent Density G-Value Vadose Zone 76 2.00 65280 0 100 0.20000 2.00000 Aquifer-1 2 3.00 65535 0 100 0.30000 3.00000 Aquitard-1 4 3.00 32512 16777215 100 0.10000 4.00000 </STRAT_UNITS> <I-DATA_TITLES> Benzene Toluene TCE </I-DATA_TITLES> <P-DATA_TITLES> Gamma Resistivity Caliper </P-DATA_TITLES> <LOCATIONS> Bore File Enabled Range Township Section Legal Longitude Latitude Easting Northing Elevation TD Symbol Color DH-1 DH-1 TRUE 1 1 1 NW4/SW4 -125.3423 44.53234 1505.00 54535.12 4543.4 202 255 0 DH-2 DH-2 TRUE 1 1 2 SW4/NW4 -125.2334 45.48394 2102.23 43453.43 4654.8 210 121 0 DH-3 DH-3 TRUE 1 1 3 SE4/SE4 -125.6543 44.53245 3245.25 32342.12 4021.6 157 44 453 </LOCATIONS> <ORIENTATION> Bore Depth Bearing Inclination DH-2 0.00 90.00 -90.00 DH-3 0.00 135.00 -45.00 DH-7 0.00 270.00 -90.00 </ORIENTATION> <LITHOLOGY> Bore Depth-1 Depth-2 Lithology DH-1 0.00 1.00 Crud DH-1 1.00 2.60 Concrete DH-1 2.60 3.00 Limestone </LITHOLOGY> <STRATIGRAPHY> Bore Depth-1 Depth-2 Stratigraphy DH-1 0.00 9.60 Vadose Zone DH-1 9.60 11.10 Aquifer-1 DH-1 11.10 17.90 Aquitard-1 </STRATIGRAPHY> <I-DATA> Bore Type Depth-1 Depth-2 Value DH-1 Benzene 0.00 0.50 0.000 DH-2 Toluene 5.2 5.6 12.56 DH-4 PCB 11.50 12.00 0.180 </I-DATA> <P-DATA> Bore Type Depth Value DH-1 Gamma 0 0.090 DH-1 Resistivity 1.0 0.240 DH-3 Neutron 23.40 0.240 </P-DATA> <FRACTURES> Bore Depth Direction DipAngle Color Radius Aperture DH-1 5.00 10.00 5.00 255 10.00 10.00 </FRACTURES> <AQUIFERS> Bore Date Depth-1 Depth-2 DH-1 1/1/01 8.00 12.00 DH-1 2/2/01 10.00 12.00 DH-2 3/3/01 14.00 18.00 </AQUIFERS> <SYMBOLS> Bore Depth Symbol Color Caption DH-1 15.50 44 32512 Pump DH-2 11.50 25 255 Sample 278-331 </SYMBOLS> <PATTERNS> Bore Depth-1 Depth-2 Pattern Density Background Foreground Caption DH-1 0.00 9.00 8 3.00 32639 16777215 Casing DH-1 9.00 12.00 8 3.00 16711680 16777215 Screen DH-2 12.00 17.00 8 3.00 32639 16777215 Casing </PATTERNS> <COMMENTS> Bore Comment DH-4 Drilled on 9/12/98. </COMMENTS> |
Please see the following description of the new export routines for more information.
New Feature (06/12/02/JPR): A new program called "ASCII" has been added to the File/Export/Boreholes menu. This program is used to export the data from one or more borehole files into one or more ASCII (text) files. In addition, to borehole data, the program can also export other data such as the project dimensions, lithology table, stratigraphy table, column titles, etc. The basic idea is to create a means for exporting everything about a project to some other application. The menu options are described as follows;
| ASCII Export Menu Options | |
| Export Options | The program has the ability to export all enabled boreholes or just the currently highlighted borehole. |
| All Enabled Logs | Program will export data for all borehole that have are "checked". |
| Selected Logs | Program will export data only for currently highlighted borehole. |
| Output Files | The program has the ability to export all of the data into a single ASCII file or into multiple files grouped by data type (e.g. all location data in one file, all lithology data in another file, etc.) |
| Single File | All data for all borehole(s) will be stored within one ASCII file. Data types are delimited by XML style flags (e.g. <FRACTURES> & </FRACTURES>). The data within these "flags" are referred to a "blocks". |
| File Name | Name of single file in which to store all data for all borehole(s). |
| Multiple Files | Data for all borehole(s) will be stored within multiple ASCII files. Each file contains a particular type of data for all of the boreholes. These data types are listed within the table titled "ASCII Export File Names". |
| Output Directory | Folder in which ASCII files will be stored. |
| Root Name | Each file will have a unique, "hardwired" name that will be be preceded by the "Root Name". For example, if the Root Name is set to "PROJECT_1", the downhole fracture data will be stored within a file titled "PROJECT_1_FRACTURES.TXT". |
| Output Format | Miscellaneous output options. |
| Delimiter Code | This is the ASCII character that is used to separate the items within the output files. Examples: 9 = tab, 32 = space, etc. It is STRONGLY recommended that the default (9) be used for all exports. |
| Decimal Places | It is possible to define the number of decimals places that are used when saving real numbers within the ASCII files. |
| Horizontal Units | Decimal places within easting and northings. Note: This setting does not apply to longitude and latitude - they are "hardwired" at six decimal places. This setting is also used for the x and y values (if they are being used). |
| Vertical Units | Decimal places within downhole distances (depths). This setting is also used for the "z" values (if they are being used). |
| I-Data Units | Decimal places used when saving downhole interval-based data (e.g. geochemistry). |
| P-Data Units | Decimal places used when saving downhole point-based data (e.g. geophysics). |
| Include Column Titles | If activated when saving to a single file, each data block will start with a line that lists the column titles. If activated when saving to multiple files, the first line of each file will contain the column titles. |
| Include XYZ Data | If activated, down hole data will include additional columns of data listing the xyz coordinates for the associated data elements. Data that is sampled on an interval basis (e.g. lithology, stratigraphy, i-data, p-data, etc.) will include two sets of xyz coordinates; one for the top of the interval, and one for the base of the interval. |
| Items To Export | It is possible to control what type of data will be exported to the ASCII file(s). |
| Project Dimensions | Project dimensions. Defined within the View/Project menu. |
| Lithology Table | All data stored within the Lithology table. |
| Stratigraphy Table | All data stored within the Stratigraphy table. |
| I-Data Titles | Geochemistry tab column titles. |
| P-Data Titles | Geophysics tab column titles. |
| Locations | All data stored within the Locations tab (except comments). |
| Orientations | All data stored within the Orientation tab. |
| Lithology | All data stored within the Lithology tab. |
| Stratigraphy | All data stored within the Stratigraphy tab. |
| I-Data | All data stored within the Geochemistry tab. |
| P-Data | All data stored within the Geophysics tab. |
| Fractures | All data stored within the Fractures tab. |
| Aquifers | All data stored within the Water Levels tab. |
| Symbols | All data stored within the Symbols tab. |
| Patterns | All data stored within the Patterns tab. |
| Comments | All comment data stored within the Locations tab. |
| View in Editor | Upon completion of the export, RockWorks will load the output file(s) into the default Windows text editor (e.g. NotePad). |
| ASCII Export File Names ("r_" indicates the user-supplied "Root Name") |
|
| r_AQUIFERS.TXT | All data stored within the Water Levels tab. |
| r_COMMENTS.TXT | All comment data stored within the Locations tab. |
| r_DIMENSIONS.TXT | Project dimensions. Defined within the View/Project menu. |
| r_FRACTURES.TXT | All data stored within the Fractures tab. |
| r_I-DATA.TXT | All data stored within the Geochemistry tab. |
| r_I-DATA_TITLES.TXT | Geochemistry tab column titles. |
| r_LITH_UNITS.TXT | All data stored within the Lithology table. |
| r_LITHOLOGY.TXT | All data stored within the Lithology tab. |
| r_LOCATIONS.TXT | All data stored within the Locations tab. |
| r_ORIENTATION.TXT | All data stored within the Orientation tab (except comments).. |
| r_P-DATA.TXT | All data stored within the Geophysics tab. |
| r_P-DATA_TITLES.TXT | Geophysics tab column titles. |
| r_PATTERNS.TXT | All data stored within the Patterns tab. |
| r_STRAT_UNITS.TXT | All data stored within the Stratigraphy table. |
| r_STRATIGRAPHY.TXT | All data stored within the Stratigraphy tab. |
| r_SYMBOLS.TXT | All data stored within the Symbols tab. |
Note: Geochemical data and geochemical column titles are referred to as "I-Data" (for "Interval Data"). This represents the first step in a transition that towards removing the term "geochemistry" from RockWorks and replacing it with this new, quasi-generic term. Why? The geochemical analytical and visualization tools within RockWorks apply equally well to any downhole quantitative data that is sampled on an interval basis (e.g. shrinkage, porosity, BTUs, etc.). Many users were reluctant to enter their non-geochemical, interval-based quantitative data into the geochemical tab, so we're migrating to this nomenclature in an effort to make the program more generic.
Cosmetic (06/12/02/JPR): The File/Import/Export menus now list sub-options that define if the data is to be import/exported to/from the Borehole Manager or the Geological Utility datasheet.
New Feature (05/15/02/JPR): It is now possible to leave either the depth-to-top (d1) or depth-to-base (d2) fields blank when entering stratigraphic information within the Borehole Manager Stratigraphy tab. The programs that use stratigraphic data have been modified as follows;
New Feature (05/14/02/JPR): A new program titled "Stratigraphy" has been added to the Borehole-Manager/File/Import/Utilities-Datasheet submenu. This program is designed to be used AFTER data has been exported and modified via the new Borehole-Manager/File/Export/To-Utilities-Datasheet program.
Note:
- This program is NOT designed for entering data. Instead, it is designed to be used in conjunction with the new Borehole-Manager/File/Export/To-Utilities-Datasheet program. A typical scenario might go like this; The user exports stratigraphic top and bottom elevations from the Borehole Manager to the Utilities datasheet. Next, the user manipulates the stratigraphic elevations (not the easting, northing, elevation, or symbol data) and/or uses various programs within the Utilities menus to process this data. Then, the user may wish to import these modified elevations back into the Borehole Manager (which will convert them back to depths).
- Referenced borehole files must already exist within the Borehole Manager.
- The datasheet must contain the following data columns in the following order;
- ID
- Easting
- Northing
- Elevation
- Symbol
- Formation-1 Top
- Formation-1 Base
- etc.
- The tops and bases for the stratigraphic units are listed as elevations - not depths.
- This program assumes that all holes are vertical. Otherwise, it's conceptually impossible to list stratigraphic contacts in a datasheet format.
- New borehole files will be created for rows that are added to Utilities datasheet. The file names will be constructed by adding a ".bh" suffix to the borehole ID.
New Feature (05/14/02/JPR): A new program titled "All Stratigraphy Data" has been added to the Borehole-Manager/File/Export/To-Utilities-Datasheet submenu.
This program will convert all of the stratigraphic tops and bottom information from depths to elevations (based on the collar elevation).
Note: The tops and bases for the stratigraphic units are listed as elevations - not depths.
Note: This program assumes that all holes are vertical. Otherwise, it's conceptually impossible to list stratigraphic contacts in a datasheet format.
Bug Fix (05/14/02/MIW): Patterns are now correctly clipped for the WMF and EMF exports from RockPlot/2D.
Bug Fix (05/14/02/MIW): The Grid, Model and Iso-Surface options within RockPlot/3D now handle smaller G-Ranges.
Bug Fix (05/14/02/MIW): The Utilities/Stereo program now plots points even if no valid data is in the "Rakes" column. The previous version would not plot the points if there was no data in the rakes column - even if the rakes weren't being used.
Improvement (05/14/02/MIW): The Utilities/LandMap program now bases the label dimension on the map width.
Bug Fix (05/14/02/MIW): The DXF importer within RockPlot/2D now uses the correct origin (11,21) and alignment (10,20) coordinates within the TEXT and MTEXT commands.
New Feature (05/14/02/JPR): A new program titled "Limit" has been added to the Utilities/Grid/Filter menu.
This program can either;
New Feature (05/10/02/JPR): The Stratigraphy/Structural-Elevations/2-Dimensional & 3-Dimensional program menus now allow the user to create models that represent either the top of the base of the stratigraphic units. The previous version was limited to just the top of a formation.
New Feature (05/10/02/JPR): The Stratigraphy/Stratigraphic Thicknesses programs (Two-Dimensional-Isopach & 3-Dimensional) now allow the user to specify which stratigraphic top defines the top of the isopach volume as well the stratigraphic base that defines the base of the isopach volume. Please note that the title, colors and density conversion factors are based on the unit that is chosen as defining the stratigraphic top.
Improvement (05/08/02/JPR): The stratigraphic "onlap" capability has been enhanced as follows; The subface of any unit is set to the same elevation as the superface of the underlying unit. This eliminates gaps as shown within the following diagram. It also means that the depth-to-base data for all stratigraphic units within the borehole manager (except the lowest unit) are ignored when the onlap feature is activated.
New Feature (05/08/02/JPR): A new program called "G-Filter" has been added to the Utilities/Solid/Filter/Grid-Filters menu. This program may be used to redefine the nodes within a solid model based on a surface model based on the following menu options;
One possible application for this utility is the creation of stratigraphic block models from scratch. For example, let's say that you initialize a new model by assigning all of the voxels a value of -32000. Next, we take a grid model called "Precambrian" and assign all of the voxels.below that surface to one. Then, we assign all of the values below the next surface (Ordovician) that are less than -31,000 to two. And so on ...
Bug Fix (05/08/02/JPR): The Export program within the Borehole Manager Hydrology menu now properly exports data if the "depth" setting is used. The previous version would download the elevation data unless the depth setting was selected again (i.e. wrong the first time, right the second time).
New Feature (05/08/02/JPR): The Borehole Manager hydrology programs (Profile, Plan, Fence, Model, & Export) now include options for searching the data based on user-specified date and time ranges. The date and time formats will automatically adjust to US or European formats based on the Windows regional settings.
Improvement (05/08/02/JPR): The maximum number of columns within the Borehole Manager geochemistry tab has been increased from 25 to 250.
Improvement (05/08/02/JPR): The Borehole Manager formerly stored the downhole geochemistry and geophysical column titles within an ASCII file called "ColTitles.txt". This file was stored within the project folder. This new version stores the geochemistry column titles within a file called "Chem_Titles.txt" while the geophysical column titles are now stored within a file called "Elog_Titles.txt". The program will automatically convert the old ColTitles.txt into the new files and then delete the ColTitles.txt file.
Bug Fix (05/08/02/JPR): Changes within the Borehole Manager geochemistry and geophysical column titles are now reflected immediately within the application submenus (e.g. selecting the track within the Geochemistry/Model menu.
Bug Fix (05/08/02/JPR): The fence diagram program now correctly "remember" the panel positions. A very recent, unreleased version introduced a new bug that caused the program to always plot the old fence position.
New Feature (05/08/02/MIW): The LogPlot->RockWorks/2002 program now includes a ability to import 1 (Multi-)Histogram table data without interpolation. It will use the first LP table with a selected column. There will also be a warning before processing. This stand-alone program may be downloaded from the RockWare web site.
Bug Fix (05/08/02/MIW): Geochemistry/Model/Inverse-Distance-Weighting: Power of the distance was being calculated with an exponent that was 1 power smaller than that specified by user. Example: Exponent set to 3 actually was being calculated to 2.
Bug Fix (05/07/02/MIW): Inverse distance no longer produces strange results when working with data sets in which the eastings and northings are expressed as decimal degrees.
Bug Fix (04/29/02/MIW): RockPlot3D printouts no longer display too much reflection when printing with directional lighting.
Bug Fix (04/29/02/MIW): RockPlot3D no longer plots reflections on the opposite side for well cylinders.
Bug Fix (04/29/02/MIW): The hole-to-hole section program now uses consistent scaling factors if the database does not include lithology or stratigraphy data (e.g. geophysical data only).
Bug Fix (04/29/02/MIW): The RockPlot3D DXF import program now properly reads verticies with negative values.
Bug Fix (04/29/02/MIW): The RockPlot3D slice position label accuracy has been improved.
Bug Fix (04/29/02/MIW): The location of slices for IsoSurfaces and SolidModels within RockPlot3D are now calculated correctly.
Improvement (4/4/02/MIW): Fixed a number of issues within RockPlot;
Bug Fix (04/04/02/MIW): Fixed symbol rotation within the following programs;
Improvement (04/04/02/MIW): The Stratigraphy Model program generates a fatal error if a stratigraphic unit is missing.
Bug Fix (04/02/02/MIW): The distance-to-point gridding algorithm now creates the grid model.:
Bug Fix (04/02/02/MIW): The Directional Weighting gridding algorithm no longer issues an error if the weighting coefficient is not an integer.
Bug Fix (04/02/02/MIW): Filled triangles are now properly scaled when exporting DXF files.
Bug Fix (04/02/02/MIW): Text is now properly scaled when exporting DXF files.
Bug Fix (04/02/02/MIW): The Borehole Manager now sets the correct list checkboxes when building the list of enabled/disabled boreholes.
Bug Fix (04/02/02/MIW): The Well_Map program now sets the correct coordinates of the background bitmap
Improvement (04/02/02/MIW): The Aquifer map program now allows the user to plot a bitmap in the background.
Bug Fix (04/02/02/MIW): RockPlot3D: Cones were being drawn reversed with the top where the base should be and the base where the top should be.
Bug Fix (04/02/02/MIW): Fixed the RockPlot2D / Utilities / Annotate setting for the Axis Titles font size which was being ignored. (Title size was being read from the Tick-Marks / Labels size setting.) True also of the Border options within the Mapping tools, etc.