The Borehole Well Data interface allows the user loads the borehole lithology dataset for the area of interest. There are four ways to do this:
1 - by extracting data from the MAGNET Data Center
2 - by uploading a borehole lithology shapefile
3 - by uploading a borehole lithology text file
4 - by clicking on the map and manually inputting borehole elevations, thickness and material ID (see Add Well below).
Once successfully extracted/uploaded, the complete lithology dataset (all wells, all depth intervals) will be shown in the data table (see more below).
Draw TP Area to extract borehole data from data center
Select this option to draw a zone on the Map Display for extracting borehole data from the MAGNET Data Center. The current data coverage includes the states of Michigan and Ohio (USA), but additional layers are available on M4W DataNET.After you select this option, the cursor becomes a '+' (crosshair or large plus sign). Single clicks of the mouse are used to place vertices; the edges of the zone (polgon) are shown as purple line segments. Click 'SaveShape' to finalize the zone (Conceptual Model Tools > SaveShape). The Status Bar at the top of the IGW-NET Modeling Environment will give updates as the data extraction occurs. When it is finished,the extracted data will be loaded into the Data Table.
NOTE: users may select the data from the table and copy & paste it into a text editor so that the data (.txt file) can be loaded at a future time using the 'Load Borehole Data' option (see below).
Data from shape file (zip)
Lithology data stored as shapefiles can be uploaded as a single .zip file containing the .shp and other associated files: .shx, .prj, and .dbf.After clicking this button, check the box next to 'Import', and then click Import to browse to and select the .zip file containing the shapefiles. (If you have already uploaded the file, click 'Use Uploaded File' to find the filename from the list of uploaded files.) Hit Apply once the shapefile is finished uploading. The shapefile will be processed on the IGW-NET server into a format suitable for TP modeling. Once the processing is sucessfully completed, the data will be shown in the Data Table (see Data Table Format below). The .dbf file should contain the following fields/column headers:
• WellID - well ID (multiple rows will share the same ID - see next subsection).
• Lithmat - lithology material description of the borehole interval
• Elev - top elevation of the borehole interval
• Thickness - thickness of the boreholeinterval
Rows and Borehole Intervals
The minimum number of rows needed for a given borehole is equal to the number of intervals plus one (Num_rows = num_intervals + 1). For example, if only one material description covers the entire borehole, the 1st row should use the top elevation of the interval as the Elev value, and the 2nd row should use the bottom elevation of the interval as the Elev value. The first row will use the actual interval thickness as the Thickness value; the 2nd row will use a thickness of zero. The material description in each row would be the same. If there are two well intervals, the 1st and 2nd rows would contain top elevation information and actual thickness values; the 3rd row would have a thickness of zero and the elevation would be the bottom elevation of the 2nd (bottommost) borehole interval. The 2nd and 3rd rows would have the same Lithmat entry. And so on...Lithmat Descriptions
All of the lithologic material descriptions contained in the .dbf file should be consistent with the conventional material name system used in the default Category Mapping File if the default Category Mapping File is used (see the TP Model Data Options Help Page). Users can create their own "shorthand" or abbreviated descriptions and Category Mapping File as long as they 'match' in both the .dbf and Category Mapping files.Load Borehole Data
This option allows users to directly load processed borehole well data (.zip to .txt file) into the data table. Typically, once the .zip file is properly processed, a user will select and copy & paste the text from the data table into a text editor and save the .txt file for loading at a later time. Users can create their own .txt file that can be loaded directly, but they must use the expected format (see Data Table Format).ShowOnMap
Once borehole well data have been successfully added to the data table, click the 'ShowOnMap' button add markers to the Map Display at the locations of the boreholes. Clicking a borehole marker will launch a Borehole Information Table for the borehole.Add Well
This option allows the users to use the cursor to add a borehole to the Map Display in the appropriate location. Each time you add a point, two row entries are added to the table, so that the top elevation of the interval can be defined in the 1st row, and the bottom elevation in the 2nd row. Additional rows can be added if there are more than one interval with material descriptions (see Rows and Well Intervals above).You need to click this button each time you want to add a data point.
Data Table Format
Borehole well data presented in the data table includes six fields (seperated by commas) for each row entry:• Name - processed borehole well ID
• X - longitude of borehole
• Y - latitude of borehole
• Z - elevation of borehole interval (top elevation or bottom elevation, depending on position in sequence of rows describing a borehole); units = meters
• SoilID - number corresponding to a material type, as defined in the Category Mapping File (e.g., AQ=1, MAQ=2, etc.)
• HGUID - same as SoilID
• HorizonID - same as SoilID
• Thickness - thickness of the ; units=meters. Thickness is zero for the bottommost row representing a borehole (see above).