12/29/13 - Geotech Participates in Many Trade Shows and Professional Meetings
Mike, Geotech’s Sales Director, attended the RMAEP (Rocky Mountain Assoc. of Env. Professionals) annual trade show, Envirofest, this quarter. Geotech had a sponsor table again this year. The event was held at the new History Colorado building, and some of the speaker topics were: Key Elements of the Voluntary Cleanup Program; Summit Lake Park Wetlands; and Recent Changes to Oil and Gas Regulations through the eyes of Industry and Local Government. Envirofest is an opportunity for environmental professionals to learn and network with environmental and engineering organizations and consulting firms, government agencies, and academic institutions. Tours of the Colorado History Exhibits were also given during the evening.
Geotech once again attended the Annual International Conference on Soils, Sediments, Water and Energy, presented by the AEHS Foundation, and hosted at the University of Massachusetts, Amherst, MA. This show is traditionally held in October, a beautiful time of year to be visiting New England. Dave, Geotech’s President, gave a talk this year titled "Gathering, Managing, and Displaying Soil Data Using Automated Tools", and shared a booth with others in the Remediation Partners organization. There were many Workshops, Platform Sessions and Poster Sessions throughout the 4-day trade show, and many current and potential clients said hello to Dave at the Geotech booth.
In November, Mike attended the RMAEP November meeting, which was held at the Test America Laboratories in Arvada, CO. The topic for this evening was "Colorado Flood Response and Recovery Panel", and some of the speakers included Julie Cozad, Deputy Operations Manager/Land Planning Manager at Tetra Tech, and Martha Rudolph, Director of Environmental Programs for the State of Colorado and former Executive Director of CDPHE. Many different perspectives were presented at this meeting, including community members directly affected by the floods, land use professionals, regulatory challenges, and industry response. It was a thought-provoking evening.
Also in November, Dave attended the 20th Annual IPEC (International Petroleum Environmental Conference) Trade Show, sponsored by the University of Tulsa, and held in San Antonio, TX this year. Dave gave a talk titled "Data Management for the New and Expected Baseline Sampling Rules", and also had a booth at this year’s show. The theme of this year’s show was "Environmental Issues and Solutions in Exploration, Production, Refining and Distribution of Petroleum". Some of the highlights of the show were: Environmental Issues in US Shale Plays, Horizontal Drilling and Remediation Wells, Fracking and Environmental Issues, and Produced Water Treatment and Management Strategies. In his few spare moments at this show, Dave was able to enjoy the warm Fall weather in Texas, and visit with his sister who lives in Austin and teaches at the University of Texas, Austin.
Rounding out 2013, Dave and Mike attended the RMAEP Holiday Party on December 12, at Lodo’s Bar & Grill in downtown Denver. The theme of this event was Casino Night, and Mike actually won FREE attendance at the next two RMAEP events! Many Geotech friends and business associates attended this Holiday Party, and of course, the food and atmosphere were very festive. A good time was had by all.
12/11/13 - Updated Validation Tool
Geotech is preparing a new release of Enviro Data, tentatively called Version 2012 D. One of the changes is a big upgrade to the Validation tool. While the calculations are pretty much the same as we have had for years, the user interface has been rewritten to make it easier to use, and provide more flexibility in selecting and configuring calculations. It will also include many new report formats, most of which are based on suggestions by our chemist clients. Here is one example:
12/9/13 - New Quick List feature
While Enviro Data is the best project database around, we are also seeing our users apply Enviro Data to much larger data sets, in some cases approaching 10 million records, using SQL Server or Oracle. The time required to retrieve a large number of records was impacting their workflow. For example, using the existing List feature to display 283,000 records took over 30 minutes. So we added a new feature called Quick List, as shown in the following figure:
It uses a different data retrieval approach, and is much faster. When we ran a Quick List, it took 4 seconds for the first records to appear, and 54 seconds to display them all.
If you are building large databases, this feature is for you. We are now implementing this new technology approach to speed up other output options as well.
11/25/13 - Updated Validation Tool
Based on feedback from several users, Geotech is updating the user interface for the Validation tool that is part of the Enviro Data Editor. One of the updated screens is shown in the following picture. It shows the interface for the user to select the tests to be run, and the reports to be generated.
11/19/13 - New Clients This Quarter
Geotech is happy to announce that we added four new clients to our growing list of Enviro software users this quarter. The first client is a very large environmental company, with offices around the world. The Lakewood, CO office purchased the Enviro software to use on a project for the Colorado Dept. of Public Health. This project was using a competing environmental database management software package, which did not work, and so our client replaced it with the Enviro software. Our second new client this quarter is a company of consulting scientists and engineers, with six offices in Montana and Idaho. This client also switched from the same large environmental database management system, which failed, to Enviro Data. Based in Minnesota, our third new client this month is an environmental services company focused on site investigations, munitions cleanup, hazardous waste management, and industrial cleaning and emergency spill response. The final new Enviro software user this quarter is a small environmental consulting company headquarted in Alabama, and the software is being used to assist a Tribal Nation in managing their environmental data. We welcome all our new users.
11/2/13 - Geotech Thanks Long Time Enviro Data Users
Geotech ran some statistics on its client user-base recently, and confirmed that we have over 30 clients that have been using the Enviro software, and Geotech’s services, for five to sixteen years. These satisfied customers include: U.S. Government Agencies; small, medium and large environmental companies; State Public Health environmental agencies; laboratories; county governments; Canadian airports; Canadian pulp and paper mills; large oil & gas E&P companies; Indian tribal nations; an Argentinian environmental company; and oil & gas refineries, to name a few. Geotech also has many clients that have started using the Enviro software within the last one to five years. We are very grateful to all of our loyal users, and hope to continue serving their environmental database management needs for many more years to come. Thank you for your continued business!
11/2/13 - Awesome Tech Support
Since 1986, Geotech has been providing top notch databases and services to the environmental industry. With a strong emphasis on client satisfaction, Geotech has been said by some to have the best support in the industry. Whether you’re just starting with the Enviro Data system, needing a way to organize historical data, or just need a little consulting, Geotech is always here to help.
See what clients are saying about Geotech:
"Everything is going well with Enviro Data. At this point, things are running smoothly; I’d like to let you know that Geotech tech support is very helpful when I have problems. They respond to my requests for help quickly and I find them to be good teachers." Database Administrator, environmental company
"The one issue I had a few weeks back, Geotech tech support promptly resolved for us." Project Geologist, environmental company
"The program is working fine for us and we’ve been very happy with the tech support that we get from Geotech when day-to-day questions come up." Project Scientist, large consulting company
10/30/13 - Praise for Enviro Data from China
In 2012, Geotech was contacted by a very bright graduate student at the Chinese Academy of Sciences, Zhiyu Li. He was looking for a dissertation topic for his thesis, so Dave Rich, Geotech’s President, and Chris Watson, one of Geotech’s consultants, spent quite a bit of time talking to Zhiyu, and decided that he could help us with the recent modifications to Enviro Spase, and use this as the topic of his thesis. Working closely with Chris, Zhiyu helped modify and test Enviro Spase, and identified and corrected some minor bugs. A year and a half later, Zhiyu has completed his thesis, and will be defending it this June. It was a pleasure to work with Zhiyu, and we found him to be very talented, diligent, and easy to work with. Zhiyu also worked with Enviro Data as part of this project. His comment about Enviro Data was, “…Enviro Data is the most sophisticated, powerful and professional software based on Microsoft Access I have ever seen.”
10/17/13 - FREE case of Sequum wine with Enviro Data purchase
For decades Enviro Data has been used for environmental projects around the world. From site assessment to cleanup, Enviro Data has proven to be one of the greatest tools anyone can have when facing any Phase 2 investigation. What most folks don’t know is that Enviro Data is so versatile, it can be used for much more than typical environmental data. Enviro Data is used by one of our clients, Paul Skinner, in California to track lab and field data for soil chemistry for growing grapes. Along with weather data from the real time sensors he installed, our client tracks disease models to determine how much to spray the plants that day. The wine he produces, Sequum, is phenomenal, and ranked one of the best by wine critic, Steve Heimhoff, and while you can’t taste the data structure in every sip, Enviro Data is a significant contributor to its excellent quality. To learn more about the wine made with Enviro Data, visit www.sequum.com/new/index.php. Find out how Enviro Data can be used to solve your specific problems at www.geotech.com. Some restrictions apply to this special offer.
10/12/13 - Ten New Clients
Geotech is proud to announce that we added ten new clients to the list of satisfied Enviro Data users in the fourth quarter of 2013. We began the Fall by selling the Enviro software to an employee-owned corporation, founded in 1946, with over 200 employees, and offices in six states. Our second new client of the quarter owns one of the highest-grade silver mines in Canada, and is using Enviro Data to manage data from their production. Our third client is an Indian Nation in the Northwest U.S., using the software to remediate soil and water on some of their tribal land. The next purchase was by an environmental consulting firm in the Rocky Mountain region that provides services such as geologic and hydrologic studies, management of water resources, environmental compliance and many others. Our fifth new Enviro Data corporate user is a gold producer largely based in Nevada. Next on the list of new Enviro software users is a Texas-based corporation with seven offices in the US and two offices in Europe, and they’re using the software to perform analyses that demonstrate the long-term safety of mining, oil and gas, and radioactive waste operations. This quarter we also added a Florida County Stormwater Management group, whose major goal is to resolve current runoff control issues and prevent new ones from occurring. Our eighth new client this quarter is an independent consulting firm that offers services in hydrology and geochemistry, primarily to the mining sector. Our next new client to purchase Enviro Data is the Kansas office of a large employee-owned firm of consulting engineers and scientists. Their New Hampshire office purchased the software several years ago. And our last new client of the quarter was founded in 1994, has over 175 employees, and is an industry leader in engineering and remediation services for radioactive, hazardous, toxic, and MEC/UXO sites. We are pleased to welcome all our new clients to the long and growing list of satisfied Enviro software users!
10/10/13 - The database you can taste
For decades Enviro Data has been used for environmental projects around the world. From site assessment to cleanup, Enviro Data has proven one of the greatest tools one can have when facing any Phase 2 investigation. What most folks don’t know is that Enviro Data is so versatile, that it can be used for so much more than typical environmental data. Enviro Data is used by one of our clients in California to track lab and field data for soil chemistry to grow grapes. Along with weather data from the real time sensors he installed, our client tracks disease models to determine how much to spray the plants that day. The wine he makes, Sequum, is delicious, and while you can’t taste the data structure in every sip, Enviro Data is a significant contributor to its excellent quality. To learn more about the wine made with Enviro Data, visit www.sequum.com/new/index.php. Find out how Enviro Data can be used to solve your specific problems at www.geotech.com.
9/21/13 - Geotech Attends Fall AEHS Conference
Dr. Dave, Geotech’s President, will be representing Geotech at the University of Massachusetts AEHS (Association for Environmental Health and Sciences Foundation) conference again this year. He will be giving a talk titled,"Using Technology Tools to Increase Remediation Project Efficiency". We invite you to attend Dave’s presentation, and bring all your environmental questions with you.
Geotech is part of the Remediation Partners (a group of environmentally related companies) and will be sharing a booth at this conference with several of the companies in this group: Defiant Technologies, GZA GeoEnvironmental, C3 Environmental, Terra Systems, and MECX. Our booth number at the conference this year is B1, and we encourage you to come and learn more about all of our environmental technology tools. Hope to see you there!
9/6/13 - Warning about SQL 2012
We all live on the Microsoft software treadmill. The latest issue we have been working with is the transition from Microsoft SQL Server 2008 to 2012. In this change, Microsoft has significantly changed how triggers and identity fields work, among other things. And, unfortunately, the Microsoft wizards for upsizing an Access database and converting a SQL database from 2008 to 2012 don’t work very well, or at least haven’t worked well for us. What this means for Enviro Data users is that if you are thinking about converting from Access to SQL Server 2012, or SQL Server 2008 to 2012, the conversion will take more planning than it took to convert to SQL 2008. Please contact Geotech if you are considering either of these upgrades.
7/18/13 - Dave Rich to present at IPEC
7/3/13 - Windows 8 Shortcuts
As soon as you become familiar with a software program, a new and improved version is released. Microsoft Windows is a prime example of this. It seems that with popular software like Windows, the vendor, in this case Microsoft, releases new versions every three or four years. It may be irritating to learn so many new features of a program, so frequently, but there is help; help through shortcuts that may make life a little easier. The mere thought of learning to navigate through Windows 8 can seem tedious (see below). Some helpful shortcuts to keep in mind while using this program involve the Windows key, plus a second key. Keyboard shortcuts include (but are not limited to), minimizing, maximizing, opening new and restoring windows, as well as opening menu options. Windows 8 along with other new technologies use "Tiles" or "Apps," also known as applications. An "App" is a piece of software that can run on a computer, the Internet, mobile phones and other electronic devices.
Here are a few useful shortcuts: Using the Windows key + Q you are able to access the Apps search screen, which can be helpful and timesaving. Another search option includes the Windows key + W, which brings up an option to search the settings. Using the Windows key + F brings up a new menu to search for files, documents and so forth. While working with properties you can use the Windows key + X to open the tools menu, advanced system options, command prompts, file explorer, the task manager as well as the control panel. The Windows key + E opens the computer, accessing the hard drive, removable storage and other network locations. The Windows key + M will minimize all windows. To restore minimized windows simply use the Windows key + Shift + M. By pressing the Windows key and typing, you can search your computer. In order to lock the computer, merely use the Windows key + L. With the ever- changing software being released these days, it seems as though there is much to learn; however, shortcuts help a great deal with time management and productivity.
6/27/13 - Updated ERPIMS and ERIS Formats
Geotech recently updated two of our supported Department of Defense formats. One is the ERPIMS format for the U.S. Air Force Civil Engineering Center (AFCEC, formerly AFCEE). Enviro Data can now export ERPIMS version 6.0 files. Likewise, the Enviro Data export for the Environmental Restoration Information System (ERIS) from the U.S. Army Environmental Command, has been updated to version 3.0.
6/13/13 - .net update
As you may have heard, the decision by ESRI to end support for VBA in the 10.2 release has been reversed, and the VBA runtime is still included. Geotech has rewritten Enviro Spase from VBA to VB.net in anticipation of this change. We are finishing final testing and documentation for this revised software, but as long as ESRI continues to support VBA, there isn’t a pressing reason for most people to switch. Geotech will keep you posted on the status of this issue.
5/17/13 - New Clients
The second quarter of 2013 has been a busy one for the Geotech staff. Besides the myriad of other things that you’ve read about above, that fill our work days, the Geotech sales staff landed four large new clients this quarter. The first was an electric utility in the Northwest, which actually purchased their software last quarter, but added maintenance and training to their purchase this quarter. We next added a large Nevada gold company to our software users list, with their purchase of licenses, maintenance and a week of training. Our next new client was a geoconsulting and environmental remediation services company headquartered in Texas. And lastly, a California county that performs stormwater management services purchased our software, maintenance and training. We look forward to getting them all successfully up and running in the near future, and for many years to come.
5/15/13 - ACE-IT Approves Enviro Data 2012
Two Army Corps of Engineers districts now have the Enviro software for their data management and GIS needs, and have been using the 2010 version, both in their own and in cooperation with their contractors. Geotech recently received word that the Corps IT department has now approved our 2012 version as well. Our Corps users will now be upgrading to the latest version, and other districts can adopt the software without needing to go through the approval process. Thanks to the Omaha District for their help in getting this done.
4/22/13 – Mike Rich Attends Field Days
Sales Director Mike Rich attended another great Field Days show hosted by the well-known Geotech Environmental Equipment in north Denver. Visiting with other venders and attendees, Mike spent two days helping people find better solutions for their environmental needs. Mike gave a talk: “Managing, Reporting, and Displaying Baseline Data and Similar Data Types”, which helped people understand the best ways to handle environmental data depending on their project type. Mike met many wonderful new people and helped them understand the benefits of a centralized data management system.
4/5/13 - Download a Free Environmental Computing Glossary
Geotech is happy to provide a free resource to our friends. This is a 44 page glossary of environmental and computer industry terms. It has evolved over the last few years in various forms, and has recently been updated.
3/27/13 - Geotech Attends Spring AEHS Conference
At the end of March, Geotech again attended the AEHS Annual International Conference on Soil, Water, Energy, and Air in sunny San Diego, California. Mike Rich represented Geotech and he shared a booth with Richard Cartwright of MECX. Geotech and MECX are members of The Remediation Partners, a consortium of companies that work together to find solutions for a wide variety of environmental and remediation needs. Mike and the Remediation Partners met many new companies and people and provided many avenues for people to pursue as they look for solutions to their specific environmental problems. From data management to remediation, Remediation Partners is your one stop shop for your environmental needs. Many new partnerships were born and Geotech looks forward to working with all these new companies in the future.
3/15/13 - COGCC Rule 609 - Colorado Setting a Precedent
2/29/13 - New Geotech Clients
Geotech is pleased to have added six new clients to our Enviro Software family in the first quarter of 2013. The first is a consulting company with offices in California, Nevada, Arizona, New Jersey and Pennsylvania. Founded in 1946, this company specializes in Geotechnical Engineering, Environmental and Groundwater Science, Inspection and Testing Services, and many other disciplines. The second new client is an environmental and engineering consulting firm located in Colorado, that deals with business segments such as Brownfield Redevelopments, Land Development, Minerals Exploration, Mining, Oil & Gas, etc. Our third client this quarter is a minerals corporation headquarted in Canada and specializing in the exploration and development of uranium properties in the U.S., primarily in Wyoming and New Mexico. Fourth on our new client list is another Canadian company, established in 1973, that provides environmental services such as enhanced bioremediation, groundwater cutoff, In Situ chemical oxidation, and many others. With offices in Canada and Denver, our fifth new client is the environmental arm of a large silver producing company in Canada. This environmental group provides scientific and engineering services to mining, chemical, gas and government clients. They also provide water treatment and closure services at mining sites. Our final new client of the quarter is the Yakama Nation, a Native American group consisting of nearly 10,000 members, living in Washington State. We are happy that all of these clients have chosen the Enviro software to help them meet their environmental database management needs.
2/21/13 - Enviro Data 2012 Released
Geotech has been working for the last several months on a major new version of our Enviro Data software. With a fresh new look, Enviro Data 2012 allows you to more easily manage your databases, perform common tasks, import data in difficult formats, and generate just the output you need. The version got the name 2012 early in its development, and we didn't change it even though it's being released now. (It took longer because of all the useful stuff we wanted to put in it.)
Here are just a few of the new features:
- Redesigned interface makes the software easier to use for new users, while providing the full functionality of the software to experienced users.
- A new database tracking feature helps you keep track of your Enviro databases in Access, SQL Server, and Oracle. Now you can open a database with just a couple of mouse clicks, without having to navigate to the desired folder and file.
- Many new and updated import and export formats, including SEDD, ADR, WQX, Scribe, ERPIMS, EQuIS, ADaPT, COGCC, EnviroInsite, RockWorks, NJ Hazsite, and NYSDEC, among others.
- New import options, including an updated “Uncrosstabber” to help dissect and import Excel tables. You can also define your own imports of multiple related files.
- New data review tool for projects that don’t need Enviro Data’s full CLP-based validation.
- Support for biological data for both individual and population census data.
- Enhanced Bulk Data tool for managing time sequence data like level loggers and multi-parameter probes, downhole data, and 2- and 3-D survey data.
- Expanded Field Tool capability that now lets you create your field documents such as container labels and chains of custody in the field based on actual field conditions.
- Stations can now have aliases, similar to Parameters.
- Enhanced Crosstab Wizard export with integrated statistics.
- More regulatory limit options, including bolding, underlining, and super- and sub-scripts.
- Regression curve option for graph reports.
- Significantly enhanced performance for retrieving large data sets.
We have now completed the development, in-house testing, and external testing, and are now releasing it to all users.
1/27/13 - Data Management Help
One of the smartest things you can do for your business is to call on Geotech when you need data management help. We have trained, experienced staff to help you when: You have too much work to do and not enough staff to do it. You lose key data management personnel, have project deadlines, and no time to hire and train new people. When you want to save money. Hiring Geotech staff on an as-needed basis is far less expensive than hiring a full-time employee. Geotech provides a variety of data management services such as: Data entry and importing
Mapping Geotech has helped a wide variety of clients with their data management needs just in 2012: We have an ongoing project with a downhole push company to help them load their push and traditional lab data and generate various kinds of outputs.
A large environmental company in Chicago had us load 25 years of data, nearly three million records of data, from two historical databases and 300 lab deliverable files. We provided a spatial information company with analyses and reports on phosphate mine samples in China. A multi-office environmental consulting firm retained Geotech to make project specific reports for their client projects.
Geotech created a project-specific field data entry tool for Oak Ridge Laboratory. A uranium company hired Geotech to add statistics calculation capabilities to the Crosstab Wizard. We did a large data loading project for a refinery in the western US.
And for our Indian tribe clients, we performed data loading, validation modifications, and custom software development for their staff. So please give us a call the next time you need help managing your data. We are here to help you!
1/10/13 - Free Environmental Statistical Software
Performing statistics on environmental data can present special challenges. One of the largest of these is that the data distribution may not be “normal” or Gaussian, that is, it does not conform to the expected bell-shaped curve. In this case, the normal descriptive statistics such as mean, median, mode and standard deviation don’t present an accurate picture of the data. In particular, it can be hard to identify trends in the data. For this it is necessary to use “robust” statistics, running tests like Mann-Kendall, Seasonal Kendall, and Kruskall-Wallace to identify possible trends. A few years back, the Air Force had a contractor write software to perform these tests. It is called MAROS (Monitoring and Remediation Optimization Systems), and can be downloaded from www.gsi-net.com/en/software/free-software/maros.html. The software runs within Microsoft Access. The program has both statistical analysis and display capabilities, as shown in the following screen shot.
While there are a number of commercial statistics programs that provide this type of capability, MAROS has the advantage of being free.