Frequently Asked Questions
Click on the individual FAQs below to get more information.
We sell both a single-seat license tied to a particular computer and a floating license that limits the maximum number of concurrent users. In either case, the license is a perpetual license.
Purchase of the EnviroInsite license entitles you to free access to bug-fixes, releases, and major upgrades for one year from the date of purchase. Email email@example.com for instructions to download a release of EnviroInsite.
Yes, for one year from the date of purchase. You may continue to receive technical support by purchasing a maintenance agreement or on a fee-for-service basis.
If I purchase EnviroInsite with EQuIS K’Nect can I connect with EarthSoft EQuIS databases without a license from EarthSoft?
No, you must have an EarthSoft ACAL license to connect to an EQuIS database. More information from firstname.lastname@example.org.
You can transfer EnviroInsite between computers, however we like to make sure that the license has been removed from the first computer before providing an activation code on the new computer. To transfer licenses, first run EnviroInsite on the old computer and select Help – Transfer License. Record the transfer code and send that with your request to email@example.com. You’ll receive in short order instructions to install and activate on the new computer.
Yes. Send your request to firstname.lastname@example.org. Be sure to include the name of your business or organization where you will be using the program. The trial will work for 30 days and is fully functional.
The trial version is the same as the release version of the program. It simply needs to have the license activated in order to continue to use it beyond the initial 30 days. To do so, start EnviroInsite and select Help – Activate. Then click on Get Code. This should generate an email with a random System Id associated with your computer. Complete the information in the email and send it to email@example.com. We will process that email request and send you an activation code along with more information as to how enter the code.
A tutorial document, tutorial.pdf is installed at Documents\My EnviroInsite Work\Tutorial. when you install EnviroInsite. The tutorial provides step-by-step instructions for using the fundamental features in EnviroInsite. The data files associated with the tutorial are included in the same folder. You may also want to consult the EnviroInsite Help file for information on particular features. On-site training may also be arranged on request. Email firstname.lastname@example.org for more information.
Subscribe to the EnviroInsite group at LinkedIn or friend the EnviroInsite page at Facebook. We also maintain an email contact list. If you wish to be on our contact list then send a request to email@example.com.
The EnviroInsite document file (with an extension of vizx or xml) is designed to regenerate your project graphics. The file contains references to your data, CAD, and image files that would need to be transferred along with the document in order to share your project with a coworker. To facilitate sharing files, EnviroInsite has a Zip Project function that can be accessed by selecting File -> Zip Project. This will zip the document itsel and all other related files to a single zip file that can be shared with a co-worker. On the receiving end, they should unzip the file to their project folder and then open the vizx or document file. EnviroInsite will automatically find the associated files and generate the document graphics.
Frequently you may want to constrain the area being contoured to something less than the default area. There are two ways to constrain the area. The first is to reduce the grid dimensions. Go to the Grid tab of the contour object and click on Draw Grid and then click on two points to set the corner points of the contour grid. The other method is by drawing a polygon around the area to be contoured. To do so, go to the Grid tab of the contour object and place a check at Limit Contour. Then click on Draw polyline and click on points to define the constraining polygon.
Kriging, inverse distance, and natural neighbor.
The approach is similar to that of plan-view contours. The data is queried, values are interpolated onto a grid and then the contours are generated. The interpolation step is fully three-dimensional so it is not necessarily limited to points within some particular distance from the x-section.
We’ve seen this before. Turns out that the ordinary kriging algorithm can result in negative weights that may result in interpolated values overshooting or undershooting the maximum or minimum of the original data. This may result in contoured values greater or less than you might have expected. We’ve added a switch that does not allow the interpolated data to fall outside the limits of your original data. This is activated from the Clip to Data Limit check box in the kriging options of the plan view contour object.
The sample logs are installed at Documents\My EnviroInsite Work\Boring Log Templates. First look at the pdf files that come with the installed templates and select the one that is closest to the end-product that you want to achieve. Next copy the folder associated with that template to a project folder. To load the template, start EnviroInsite and open the boring log data file by selecting File – Open Database and selecting the file. Once it’s opened and validated then select Boring Logs from the Tasks Pane at the right-hand side of the EnviroInsite window. Select Plot – Logs from Template and select the template and the wells to be plotted. This will create the log using the sample data. You can swap in your own data to plot logs for your wells or boreholes. You can also modify the template by double-clicking on the log object in the Plot Control tree on the left-hand side of the program. This will open the log design window. You can add or delete fields, move objects around, and swap in your own corporate logo. Save out the modified template by selecting Template – Save As and selecting a new template name.
How do I change the axis scale in order to expand or contract the size of the boring log on the printed page?
Double-click on the boring log icon in the plot control tree to the left of the main window to open the boring log design view. Then change the value of World Length per Page Inch. Increasing the value will contract the log and reducing the value will expand it over more pages.
You need to be sure to identify the data source for the depth to water. To do so, open the boring log design window by double-clicing in on the log object in the plot control tree on the left of the EnviroInsite window. Then select Edit – Options and select the Options tab. Then go to the Depth to Water data field drop-down and select the field from the Wells table that you’re using to represent “Depth to Water”.
Hatch fill areas are used both to indicate the annulus well fill material and natural soils. Most frequently, the cause of these areas being plotting as solid colors in spite of you having selected a hatch fill is that the hatch scale has not been set correctly.
You can set the individual hatch scales by selecting the material within the Fill Style tab of either the well construction or downhole fill object and setting the hatch scale there. The hatch scale provides the dimensions for which patterns are repeated so if you have 30 feet of log on a page for instance you may want to set the hatch scale to 2. This will most likely take some trial and error to get it to appear as you like.
When you see this error it means that the database driver is finding something in your Excel spreadsheet to the right of your actual data columns that’s making it think you have more fields defined than you actually intended. Sometimes it can be something innocent like the assignment of Formatting properties to cells where there’s no data. The way to fix this problem is to open the spreadsheet in Excel. Then go to each sheet and unhide the columns to the right of your data. Next highlight all the columns to the right of your data columns and select Clear – Clear All. It’s in the Home Tab’s Editing Panel in MS Excel.
Why do I get the error message Data source name not found and no default driver specified when I connect to our Excel database?
It’s likely one of two things. (1) You don’t have MS Office on your computer, in which case you should install the MS Access Database Engine 2010 Redistributable. Here’s a link: http://www.microsoft.com/en-us/download/details.aspx?id=13255 (2) You installed the 64-bit version of EnviroInsite, but have the 32-bit version of MS Office installed. If that’s the case then uninstall EnviroInsite and reinstall the 32-bit version.
Typically this error occurs when you select too many locations after you click the List button in the query tab. It’s a limitation inherent to the database driver that is used to read Excel files. To get around this problem, try removing all of the selected locations and see if you can get it to work. If it does then try to build a query without specifically selecting so many individual wells. As an alternative, you may be able to use the wildcards in the well or screen name or select by location, elevation, or depth. Don’t forget that if you don’t select any locations from the list that that is equivalent to selecting all of them.
Why do I get the error message Unable to cast object of type ‘System.Double’ to type ‘System.String’ when I select wells from the List?
This error occurs if you’ve entered a numeric value in a column where EnviroInsite is expecting to see a non-numeric text string. Check your data file for numeric values in data fields that should contain non-numeric text strings? Typically we see this error occurring most frequently in the Well, Screen, Media, and Fraction fields. If you insist on using a numeric value then be sure to preface it with a single apostrophe, which Excel will interpret as indicating that the cell contents are to be treated like a text string.
First change the Easting and Northing column headers (if you’re working in Excel) or field names (if you’re working in Access) to Longitude and Latitude. Then enter the coordinates, being sure to enter the longitude as positive in the eastern direction. That means that longitude values in the United States should be negative values. Next open EnviroInsite and select View – Options. Decide whether you want the coordinates to be plotted out in UTM – metric, state plane – feet, or state plane – metric units and make your selection. Now connect to your database. The UTM or state plane zones will be automatically set based on the coordinates in your file.
How does EI handle a non detect value? Should we be putting a number in the Value column corresponding to the detection limit?
It’s advisable to put a number in the Value field even if the reported result is a non-detect. A number of the functions need the Value field to be populated, such as plotting pie charts, radial diagrams, stiff diagrams, contours, etc. Standards are also compared against whatever number you put in the Values column so you need to think about that as well if you’re going to be generating a plot where standards are going to be flagged. Mostly people either put a zero in the value field or some fraction of the detection limit. It all depends on your objectives.
You may want to think about populating the Formatted Value field if there is some particular way in which you want the values to be presented in either the data tables or posted value plots. The Formatted Value field is used in the data tables if it happens to be populated. There happens to be a note about it at the EnviroInsite LinkedIn group about how EnviroInsite handles non-detects in data tables. You might want to read it. Here’s the link: How-does-EI-handle-non-detects
Data in the Borings table typically relate the field notes from the geologist that logged the hole. They are frequently detailed and describe multiple soil units that are at field scale might be considered to be portions of a single hydrogeologic unit. The Stratigraphy table contains an interpreted description of the hydrogeologic units. 3d geologic models, 3d fence diagrams and 2d geologic models on profiles are all generated using Stratigraphy data. EnviroInsite, at present, does not generate plots that correlate units between data compiled in the Borings table.
This is best explained by a set of simple examples.
1. Not allowed because of the repetition of sand as the first and third unit:
2. Not allowed due to inconsistencies in strata order:
|sand 1||sand 1|
3. This is allowed to represent the pinching out of the clay layer in BH2:
|sand 1||sand 1|
Viewing Bing Maps in EnviroInsite allows you to view aerial photos that you’re used to seeing at Microsoft’s Bing Maps. Before you can start viewing these aerial photos in EI you will need to obtain a MapSavvy activation code from OnTerra Systems. The cost is presently $5 per month. Here’s a link to their web page: http://www.onterrasystems.com/web-mapping-mapsavvy/. Once you get the activation code you should start up EnviroInsite and select Insert – Bing Maps. This will bring up a dialog box with a text box for you to edit the MapSavvy activation code. That’s all there is to it. The maps will plot in the coordinate system selected under View – Options. The choices are UTM – metric, USA State Plane – metric, and USA State Plane – feet.
ESRI Shapefiles, AutoCAD DWG, DXF, or DWF, and MicroStation DGN. You can load these files by selecting Insert -> CAD or Insert -> ShapeFile
PNG, TIF, JPG, BMP, and GIF. You can load these files by selecting Insert -> Image. If you have a world file associated with the image file then it will be automatically georeferenced. If not then you can edit the inserted image and click on the georeference button to georeference the image based on known coordinates for two points.
Yes we do. Select Insert -> Web Map Service and select from the pre-selected services or enter your own. Then select from the available list of layers and objects for your selected services. The maps will plot using the coordinate transformation selected at View -> Options. You may elect to use either UTM – metric, State Plane – feet, or State Plane – metric. Be sure to select the transformation and the appropriate zone before loading the Web Map Service map.
Use EnviroInsite to:
I Have a:
You should Install:
|Access only EQuIS data files||32-bit computer||32-bit|
|Access only EQuIS data files||64-bit computer||64-bit|
|Access native EQuIS data files and EnviroInsite data files||32-bit MS Office||32-bit only or both 32-bit and 64-bit|
|Access native EQuIS data files and EnviroInsite data files||64-bit MS Office||64-bit|
EnviroInsite reads the value of dt_facility.coord_type_code to determine which location value should be used from dt_coordinates. If you have entered geographic coordinates (latitude – longitude) and placed a check in the EQuIS options dialog box indicating that is the case then the coordinates will automatically be converted either US State Plane or to UTM. Be sure in that case to place a check in the EQuIS options dialog box indicating the values are lat-long and select whether you want State Plane or UTM in the View-Options dialog box before connecting to the data file.
The concentration units are selected from the first instance of the analyte and media matching your selection in rt_mth_anl_group_member. The program will first look to reporting_units in this table and if not populated it will use the value in default_units. These values can be set by creating analyte groups in EQuIS. If no units are found using this approach then the program will create a query that binds dt_sample, dt_result, dt_test, and rt_analyte and select the first instance where the chemical name and media match the values of rt_analyte.chemical_name and dt_sample.matrix_code. If found it will then use the value in dt_result.result_unit.
EnviroInsite checks the value of dt_result.detect_flag to know if a result is a non-detect. If the value is set to “N” or “n” then the value is flagged as a non-detect. For those instances where the program needs a numeric value (such as pie charts, time-history charts, stiff diagrams, classed post plots) then it will multiply the detection limit by a user-specified non-detect multiplier. The non-detect multiplier is set in the Data Mapping tab of the EQuIS options dialog box. For instances where the program is posting a value (such as data tables) then it will post the value as a less-than sign appended by the detection limit. The value of the detection limit is the first non-null value from dt_result.reporting_detection_limit, dt_result.method_detection_limit, and dt_result.quantitation_limit.
As mentioned above, EnviroInsite loads the detection limit from the first non-null value of dt_result.reporting_detection_limit, dt_result.method_detection_limit, and dt_result.quantitation_limit. If these are all null (ie., not populated) then EnviroInsite will assume that the detection limit is zero.
EnviroInsite uses the same functions for evaluation of water levels as the Water Levels report in EnviroInsite. The parameters for the water level evaluation are specified in the EQuIS Options dialog box. For more information on the calculation procedures and parameters please consult the EarthSoft documentation.
EnviroInsite uses the value in dt_lithology.material_name for all plots of Boring data in EnviroInsite. These are used in the full page boring log plots and in any plot called by selecting the menu item Plot -> Boring. The field used for plots of Stratigraphy data is selected by the user in the Mapping tab of the EQuIS options dialog box. Stratigraphy data is used to denote hydrogeologic units and are used in any plot that is started by selecting the menu item Plot -> Stratigraphy. By default, the program will use the contents of dt_lithology.geo_unit_code_1 for Stratigraphy data, although the user may also elect to use geo_unit_code_2, geo_unit_code_3, geo_unit_code_4, or geo_unit_code_5.
EnviroInsite requires the equivalent weights to be entered for any one of these plots. These are loaded into rt_analyte_detail.equivalent_weight. Our convention is that the equivalent weight of anions are entered with a negative value and the equivalent weight of cations are entered with a positive value. Be sure to enter these in units that are consistent with the units of the analytes to be plotted. In some cases you may also find that you are able to start the plots, but no results are appearing in your diagrams. Be sure that there are concentration values specified for all of the anions/cations that you have selected to appear in your plot.
What fields are used for the downhole data that appear as geophysics plot in strip logs, boring logs and x-section profile plots?
The data values for these plots are stored in dt_downhole_point_data.depth and dt_downhole_point_data.param_value. Be sure that you have an associated record in dt_coordinate and dt_location. Since there are no depth units in dt_downhole_point_data, EnviroInsite assumes that these are in the same depth coordinates as specified in dt_facility and therefore plots the values without applying any unit conversion to the depth values.