Geotech wants you to be successful working with our company and software. Towards that goal, we provide comprehensive documentation and a set of topics with frequently asked questions (FAQ) and their answers to help you.
There are several components to getting help with Enviro Data. One way to learn more about the software, and for guidance in using specific features of the program, is to consult the documentation provided in searchable digital format as part of the software installation from the Main Menu. To view general help for Access, click on the question mark on the menu at the top right of the screen.
Frequently Asked Questions
To start, expand the topic you would like to learn more about by clicking on it.
Types of licenses
Enviro Data is licensed either Single Use or Concurrent Use. Single use is for one user and computer. Concurrent Use can be installed on as many computers as you wish, and as many people can use it at once as licenses you have purchased. This is true of both the full software and the Viewer Only. Enviro Spase is currently licensed only for Single Use. All licenses are perpetual.
How to get a trial
Geotech will be glad to provide you with a free trial of the software. We strongly recommend that you allow us to provide a web demonstration of the software prior to your trial, so you will get the most of your time while you are going through the trial. For more information on a free trial, visit our Download Information Form.
What the trial does
The Enviro Data trial is a full, working version of the software. You will be provided with a code that will enable it to work for thirty days.
Geotech’s Maintenance program is governed by the terms of our Enviro Software License and Maintenance Agreement.
What version of Access is required?
While Geotech recommends using Microsoft Office 2010 or later (including Office 365), Enviro Data works with Microsoft Access 2003 through 2016. You will need one license of Microsoft Access (or Office Professional) for each desktop installation of Enviro Data. Both Microsoft and Geotech recommend using the 32-bit and not the 64-bit version of Access.
Why shouldn't I use 64-bit version of Office?
While Enviro Data will run in 64-bit Access, some features, such as the Tree View, the internal map, and the secured version of the Viewer, will not work. Enviro Data will fully support both 32-bit and 64-bit Office starting with the next major release of Enviro Data. Please contact Geotech if you feel you need to run current version of Enviro Data in 64-bit Office.
Will Enviro Data run on a Macintosh?
Boot Camp from Apple allows you to install Windows alongside OS X on your Mac. You can then run Office and Enviro Data under Windows. Only one operating system can be running at a time, so you’ll have to restart your Mac to switch between OS X and Windows.
No records returned
This usually means that the selection criteria you have entered on the Select Data form did not result in any data being retrieved. Try changing your criteria.
Using the Enviro Data internal map
This feature allows you to display simple dot maps in Enviro Data without needing a separate mapping program. You will need a vector base map (such as a CAD drawing or a ShapeFile) and optionally a bitmap image. These should be entered on the Sites form for each site for which you want to make a map. You will also need coordinates in the Stations table that match those of the base map. Then select data for one parameter, click on Map at the bottom, answer the questions on the next two forms, and your map will be displayed.
How to store geological data
There are two ways to store geologic data in Enviro Data. You can assign geology and lithology to each physical sample. This makes it easy to tie the geology to field and lab data. Or, you can store formation “tops” by location independent of the samples. This probably better represents the actual site geology.
Install the Enviro Data program by running the EnviroData2012Setup.exe (or whatever name you received) that you obtained from Geotech. If you are evaluating Enviro Data, you can contact Geotech for a code to extend your evaluation from 7 to 30 days for no charge. During the install, a sample database called EnvDData2012.mdb is copied into the program folder. Enviro Data connects to this database by default when it is first opened, if you have accepted the default program paths during installation. If you have installed the program and sample database in a different folder, you will need to locate the settings file and the database file. Contact Geotech if you have any trouble with this.
You might want to modify the contents of the lookup tables, also called valid value lists, to suit your project. You can view the existing values, and modify them as necessary. When you create a new database, the lookup tables are brought into the new database from the database you were attached to when you created the new one. For your first database, the lookup tables will be from the sample database provided with the software (EnvDData2012.mdb). As you create more databases for different types of projects, these lookup tables can evolve. For each new database, you should use an existing database that will have the most similar lookup table contents, and use that to create the new one.
1. Click Maintain Database in the Your Projects section on the right side of the EDITOR MENU.
2. Click on Lookups Report, and print it if you wish. Then close the report, and the MAINTAIN DATABASE form.
3. On the EDITOR MENU, click on Manage Lookups. This screen shows the lookups that you can change.
4. Click on one of the buttons, such as Sample Matrix, to open the editing form. Modify the values as necessary, and then close the form.
Sites and Stations
The data hierarchy in Enviro Data has four major tables, Sites (projects or facilities), Stations (locations of samples or observations, such as soil borings or monitoring wells), Samples, and Analyses. Enviro Data uses a database feature called Referential Integrity to protect your data, and that means that the hierarchy is strictly enforced. So to add Stations, Samples, and Analyses, you will need to have at least one Site. Here's how to do that.
1. On the EDITOR MENU, click on Enter and Edit Data.
2. Then click Sites. Enter a Site Name and State at the top of the SITES form. All other fields are optional. Click Done on the upper right of the screen when finished.
3. The next data element to enter is Stations. You can type them in, as you did Sites, but often it's easier to import them, especially if you already have them in digital form.
4. Using the template ImportStation2012.xls, create an Excel sheet with your station information. ImportStationExample2012.xls is an example of a compete stations import file. These two files are placed in the Enviro\Edata2012 folder in Windows Explorer when Enviro Data is installed.
Importing Lab and Field Data
The last two data levels in Enviro Data are Samples and Analyses, and they generally are imported together. This section tells you how to do this.
1. Using one of the DTS format files, such as DTSFormat2012.xls, as a template, create an Excel sheet with your samples and results information. SuccessfulImport2012.xls is an example that you can consult when populating your own import files. These files are located in the Enviro\Edata2012 folder in your directory. Notes: All lookup code columns with red captions must be populated. You may use “z” as a default code for lookups (SampleTypeCode, etc.) SampleTop, SampleBottom, DuplicateSample and Superseded can be left blank or default to zero. If you have digital data in a columnar format, but different from one of the Enviro Data DTS formats, you can use the User-Defined Excel option in the Import Wizard. Contact Geotech if you need help with that.
2. After constructing your import file, click on Import Data on the EDITOR MENU.
3. Select the File Type and Format that matches your import file format.
4. Click Select at the right of the File Path and Name text box. Navigate to the file you made and click Open.
5. Click Finish.
6. The HELP MATCH STATIONS form may open if there’s a discrepancy in spelling Station names. You can use the dropdown on the right to find the correct station, or click Add Station to add a new station, if needed. After matching stations click Finish.
7. Another help screen for matching or adding new parameters may appear.
8. And one for matching reporting units, and perhaps others. When all is correct the import will run to completion.
Data Review and Validation
Enviro Data has a number of tools for reviewing and validating your data, up to and including calculation support for EPA CLP Level III data validation. Contact Geotech for more information.
Enviro Spase is provided under a perpetual, Single-Use license, for installation on one computer for one user.
What version of ArcGIS is required?
Enviro Spase will run ArcGIS 9.X through 10.4.X. A new version of Enviro Spase is currently in development that will support ArcGIS 10.5.x.
Toolbar Icons Missing
When the Enviro Spase toolbar is displayed, but the icons are replaced by red circles, that means that the ESRI Visual Basic extension has not been installed. Contact ESRI for the VBA setup program, if you don’t have one, and for an authorization code.
Client cloud implementation
Enviro Data has more implementation options than any comparable system. And now you can take the power of Enviro Data and run it in the cloud. Using the robust Microsoft Windows Azure, Geotech can help you set up your whole database system in the cloud. You get all the benefits of Enviro Data, along with all the benefits of a cloud implementation. This means that you don’t have to install any software or data locally, with no need to deal with servers, your IT department, or other hassles. You can provide access to the software and data to others, without having to worry about distance, connection speeds, and so on. Your Enviro Data databases can be in Access or SQL server, depending on your needs.
Geotech cloud implementation
Your Enviro Data cloud implementation can be either on a cloud site under your name, or Geotech can own and manage the cloud site. In either case Geotech can help you set it up and start using it.
Geotech provides both training specific to our commercial software, and also general training to the environmental industry on environmental data management concepts and practices. Although Geotech's software is easy to use, we do strongly recommend training for first time users. These services can be obtained directly from Geotech. Training can also be very helpful for those wishing to perform their own customization work. Training classes can be presented at your location, Geotech's office in Colorado, or via web presentation. Our industry training is offered in conjunction with various conventions and conferences.
Geotech can provide data loading services for our clients, starting with either hard-copy or digital data in a variety of formats, and resulting in a coherent, accurate data set. One example is a data conversion that we did for a medium-sized consulting company on an aging in-house database that was poorly designed and not a good fit to the company's business needs. Geotech migrated 20,000 records, overcoming a poor data normalization design in the process, in less than a day. On another, much large project, we migrated over twenty years of data for a major steel plant, over two million records, from two larger databases and hundreds of lab files into one consistent database in a week and a half.
Enviro Data and Enviro Spase are intended to be flexible and configurable to handle most any data you need to manage. However, if you need something special, Geotech can customize the Enviro software to meet your company's specific business needs for managing your data. Our staff and consultants can provide a variety of programming and other software services. Because of our extensive experience in working with databases to manage spatial (map) and other data, we will design/redesign your company's data so you can better manage and access it spatially.
Geotech Computer Systems, Inc. was established in 1986 by noted industry author Dr. David Rich. Focused on markets such as environmental, mining, oil and gas, agriculture, weather, and others, we have become an industry leader in the application of computer technology. With a strong commitment to the environment and public safety, Geotech has worked with many companies and organizations to maintain not only a healthier place to live, but also a safer environment. Geotech has satisfied a variety of client needs on large and small projects involving software and services. Geotech is located in Centennial, Colorado, and we are a privately held woman-owned small business. Our clients include industrial, consulting, and government organizations; most of which are in the U.S. but include dozens of countries, and range from the largest corporations to one-person shops. Our specialty is software development related to data management, mapping and graphics, and we sell commercial software for managing, displaying, and reporting environmental quality data. Our commercial software, Enviro Data & Enviro Spase, provide off-the-shelf functionality for multiple industries, and also provide a starting point for building semi-custom or custom applications for specific database needs involving environmental quality data and maps. Enviro Data & Enviro Spase are used for tracking and reporting soil, water, air and other data for industrial and other sites. We use tools like Microsoft Access, Visual Basic, SQL Server, Oracle, and others to satisfy specific client business needs. Designed to easily overcome and avoid common problems, Geotech has created a streamlined, more efficient process of data management and offers a variety of implementation options which easily places client data at their fingertips. Our clients routinely praise us for our cost-effective service and excellent technical support. Geotech is interested in learning more about your company, and would be glad to discuss your database, GIS, and other software needs.
Why are Enviro Data and Geotech the best?
• Enviro Data is easy to learn and use. The menu-driven interface, and automation of many import and retrieval processes, makes it easy for the software to be used by project staff that may not be database experts. This is particularly apparent when comparing Enviro Data to other environmental data management products.
• It is efficient. It is not unusual for clients to report time savings of up to 50% on data management tasks relative to the way they have done it in the past. They also report an increase in output quality due to more automated handling of the data.
• It protects your data. The program is based on a fourth normal form database design, with built-in referential integrity checks, preventing orphan records and other common data problems. It also has mandatory automated consistency checks with correction assistance so the data brought into the database is the highest quality.
• It is powerful. The software has evolved significantly through 15 years of daily use by many clients on a wide variety of projects, resulting in over 500 specific features. Yet the user interface hides much of the complexity, so you can use only the parts you need.
• It is affordable. The cost for the software and services is less than competing products, and is generally less than the operating overhead of many in-house systems.
• It is scalable. Enviro Data is the only software of its type that scales easily from small projects in Microsoft Access to large projects with millions of records in Microsoft SQL Server or Oracle.
• It is open. Enviro Data is provided with open source code and the ability to modify software objects, so your power users can make changes as necessary to satisfy project needs. And because you have complete control over lookup table values, it can easily handle a wide variety of data types - radioactivity, organics, metals, biology, geology, etc.
• It’s tried and true. Clients have been using Enviro Data on all types of projects on a daily basis for more than 20 years. While every project is different, most of the common issues in managing project data have been encountered before and resolved, based on project staff feedback.
• You get the help you need. Geotech’s support is described as the best in the business by clients familiar with our support staff and that of other solutions.
What are the system requirements for the Enviro Software?
Enviro Data client
Microsoft Access: Version 2003-2016, 32-bit (including Office 365)
Processor: 2 gigahertz (GHz) or faster x86- or x64-bit processor
Memory (RAM): 4 gigabytes (GB) RAM
Hard disk: 3.0 gigabytes (GB) available
Display: 1024 x 576 or higher resolution monitor
Operating system: Windows 7 or newer
SQL Server back-end
Processor: x64 Processor: 2 GHz
Memory: 4 gigabytes (GB) RAM
Hard disk: 6 gigabytes (GB) available
Display: Super-VGA (800x600) or higher resolution monitor
Operating system: Windows 8 or newer, or Server 2012 or newer
ArcGIS: Version 10.0 - 10.4
Processor: 2.2 gigahertz (GHz) or faster x86- or x64-bit processor with SSE2 extensions
Memory (RAM): 4 gigabytes (GB) RAM
Hard disk: 1.6 gigabytes (GB) available
Display: 1024 x 768 or higher resolution monitor
Operating system: Windows 7 or newer