Using the tables above, any number of queries can be conducted to provide views that can be used to create C Tech data files in a nearly automatic fashion. Below are five queries used to create chemistry, geology (.geo) and pre-geology files and another 6 queries representing the six surfaces of a geology-multi-file (.gmf).
IMPORTANT NOTE: When designing a query it is CRITICALLY important to always include non-detects in the chemistry files. If you create a chemistry file that consists exclusively of samples above some threshold, this will result in a plume that is dramatically larger than it should be. EVS provides the tools to display only detects if that is desired. Be sure to ALWAYS include all measured samples especially non-detects.
The design of the query to build the chemistry (.csv) file with Z coordinate information as depth is shown below. Note that Depth is computed as Top-Z. If Depth were the data in one of the table fields, it could be used directly. Similarly if depth was in the table, Elevation could be computes as Top-Depth.
The design of the query to build the chemistry (.csv) file with Z coordinate information as elevation is shown below.
Due to the number of columns, the query design to build the .geo file seems the most complex. However, because the data in the tables was appropriately formatted, the query is quite simple.
Similarly the queries to build pre-geology files are rather straightforward. The first one below is the simplest form where the third column (field) is elevation.
The figures below show two of the six query designs used to create the views that comprise a five layer (six surfaces) .gmf file.
