Enviro Data is a program for managing and displaying site environmental data. This powerful and intuitive software uses Microsoft Access as a front-end user interface and any ODBC-compliant database such as Access, SQLServer or Oracle as a back-end database server. This open system, based on industry standard software, allows the system to be easily modified for specific project requirements. The data storage structure (data model) has been carefully refined over many years based on our experience storing millions of records of site data, and satisfies the rules of Fifth Normal Form data structure, as shown in the figure.
Starting with our powerful Import Wizard, one screen of which is shown to the left, Enviro Data helps you import analytical and other data from laboratory data files or other sources, review the quality of the data, and then store the data in the database. Our reference file system closes the loop between labs and data users, requiring the labs to check data against updated lists of well names, parameter spellings, and other data elements prior to delivering the data. This wizard-assisted import and use of the reference files has reduced the time for importing and checking lab deliverables by a factor of six, saving hours and dollars. For historical data, the program has automated features to help you step through problems in station names, parameters and units and fix each with just a few mouse clicks.
|Build for All Skill Levels|
Enviro Data was built for users of all skill levels, and the data selection process reflects this. You can select data using a simple form-based query system, shown to the left, to see just the data you need. This system lets you select data from drop-down lists of station names (wells, borings, etc.), parameter names, etc., enter the dates and/or depths you are interested in, and then retrieve just the data you want to see, without getting involved in complicated SQL (structured query language) queries. (Or you can use SQL if you prefer.) You can then create a printed report, graph, or map, save the data to disk, or copy it to the clipboard to paste into other Windows programs. You can even make a subset database to transfer to other locations.
The screen to the left shows just one of your display options once you have selected your data. The software has automatically converted the data to consistent units (the database contained a mix of milligrams and micrograms per liter), found the regulatory limit that we selected for the parameter being displayed, and drawn a graph showing the data and the limit. Either of these features can be turned on and off so you can get just the display that you need for your specific project requirements. You can graph multiple parameters for one well or multiple wells for one parameter.
If you don't need a full-blown GIS system, or just want an easy way to make simple maps of your data, Enviro Data has basic mapping capabilities built into the database software. You can display your existing CAD drawings as a base map, and then select a parameter for display by date, depth, or other factors. The software will then let you select cutoff values, and display colored dots and the values on the map. If you need mapping capabilities that go beyond that, our Enviro Spase program is just for you, with powerful features like Stiff water quality diagrams and time sequence graphs on maps, and built-in contouring, image display, and other features. Or, you can move your data to other GIS programs such as MapInfo or ArcView.
Enviro Data can store and display multiple regulatory limits by matrix, parameter and site. The editing screen for this data is shown to the left. The graphing system can display a selected limit. Some of the reports can highlight data records that exceed the limit or show only the exceedences. Other powerful features include tracking of quality control and review status of all the data, and also support for data validation. Believe it or not, Enviro Data can even overcome Access's problem with displaying the right number of decimal places where there are trailing zeros. (This is something that Excel can't easily do either.) You can even define parameters for each station and include those lines whether they were analyzed or not.
A very strong feature of Enviro Data is its user-configurable custom reporting. The program comes with over a dozen pre-configured reports that will satisfy many of your needs. But for that project with special requirements, it's easy to modify an existing report or create a new one with a specific data presentation. That report can be easily integrated with choices you make on the selection screen. Then you can add your new report to the list of available reports displayed in the software so the report is fully integrated into the program. This is one of the many features that makes Enviro Data almost infinitely flexible; able to accommodate project needs while leveraging the power of a time-tested product.
The best news is that Enviro Data provides you with all of this scalable power while still being easy to use! Whether you are implementing a data management system from scratch, replacing an outdated older program, or just trying to get your data organized, you can be productive with your new system in just a few hours. Backed up by our widely praised customer support and our rapidly growing list of useful features, Enviro Data is your obvious choice for the latest in site data management software.