The 212 Environmental Database Management System (212 EDMS)

The 212 Environmental Data Management System (212 EDMS) was designed by and built for environmental professionals. As such, our system has been streamlined to remove unnecessary obstacles present in many other data management systems that inhibit the direct use of data by the geologist, engineer, statistician, chemist, risk assessor, modeler, operator, or manager. Specifically, we have removed the clunky web-interface and unnecessary “features” developed by programmers that simply slow down the applications and make the user experience complicated and frustrating. This allows our customers to quickly import data into their dedicated database and begin using our applications without downtime for training users or implementation for IT professionals.

Our system has been used by consultants, laboratories, municipalities, lawyers, and others to store, analyze, review, validate, and report all types of data at their facilities and sites. This includes initial investigation, site characterization, safety, system operational, routine, and non-routine monitoring, maintenance, and many other types of data. We have created applications for recording field notes and photos, as well as workflows for maintaining systems, equipment, or vehicles. We have electronic field forms and applications that completely eliminate the need for paper field forms and reports.

212 EDMS - Simplicity through Sophistication

Inputs

bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png

Groundwater and Surface Water Elevation Data

Field Screening Data (e.g., ambient air, soil vapor, groundwater, surface water, etc.)

Laboratory Analytical Data (e.g., ambient air, soil vapor, groundwater, surface water, etc.)

Light Non-Aqueous Phase Liquid Characterization Data

Forensics and Microbial Data

Equipment/System Operating Data

Equipment/System Maintenance Data

Equipment/System Monitoring Data

bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png
bulletpaper.png

Field Notes and Photographs

Auditor Notes and Findings

Laser Induced Fluorescence Data

Lithologic and Stratigraphic Data

Monitoring Location Construction Details

Geospatial and Coordinate Data

Chemical and Physical Property Data

Meteorological Data

Regulatory Limits and Screening Levels

Health and Safety Data

Security Features

key.png
key.png
key.png
key.png
key.png
key.png

Administrative credentials within Microsoft Azure as defined by 212

Administrative credentials within the SQL Database as defined by the Customer

IP address restrictions defined by the Customer

Device name restrictions defined by the Customer

User permissions within the 212 EDMS and Applications as defined by the Customer

Individual credentials defined by User

Outputs

piepoint.png
piepoint.png
piepoint.png

Database connected Excel spreadsheets for import into any drawing, modeling, statistical analysis, risk assessment, or third-party software 

Customizable database connected Excel spreadsheets for automated calculation of emissions, flowrates, pneumatic response, or any requested calculated output

Report ready Excel spreadsheets with statistical analysis and comparison to regulatory screening limits

piepoint.png
piepoint.png
piepoint.png
piepoint.png
piepoint.png

Workflow processes including calendars, task lists, and summary reports for operations, maintenance, and monitoring activities

Laboratory validation and qualifiers

Report ready inspection, audit, and field notes including photograph logs

Health and safety inspections

Routine compliance reports

Database Architecture

The 212 EDMS securely stores all your data in a cloud-based SQL database that is housed within Microsoft Azure Cloud Servers.  The 212 EDMS helps make sense of mountains of information through powerful queries that allow for assimilation and analysis of data from multiple sources. We offer several standard, as well as customizable, reporting tools that produce submission ready reports at the push of a button, in addition to Excel-ready files for incorporation into any modeling, visualization, statistical analysis, or similar program. This avoids the time, effort, and errors of transcribing data.

The best part about the 212 EDMS is that it is scalable and customized to each customer. You only need to pay for those applications that you need. This is not the typical web-based, one-size fits all system.  Our solution is affordable for everyone, whether a consultancy with one employee or a multinational company with tens of thousands of users worldwide.

212 EDMS Features

Intuitive Design

ProDesign.png

Designed by environmental professionals to ensure ease of use both in the field and in the office, with little downtime for training.

Field Forms

FieldForm.png

Paperless, intuitive Excel-based forms for conducting field events, eliminating the need for internet connectivity. Choose from our standard forms or have us customize field forms based on your project needs.

Automatic Verification

AutoVerify.png

Automated data verification and auditing built into applications to avoid importing corrupted data and maintain data integrity.

Sampling Triggers

SampleTrigger.png

Logic-based triggers to guide collection of representative samples during all sampling events, including low-flow groundwater or soil vapor sampling.  Triggers can be customized for your site-specific sampling plan.

Data Validation

DataValidate.png

Interface for importing, managing, and adding data validation flags during laboratory data validation. Flags are automatically added to report-ready tables.

Field Notes

FieldNotes.png

Field notes application for combining photographs and daily field notes into pre-formatted reports.  

Automated Calculations

EmbedCalcs.png

Customizable embedded calculations for estimating site-specific parameters such as flow rates, air emissions, and mass recovery rates to streamline site monitoring and compliance reporting.

Data Export

DataExport.png

Customizable export data in any format you need. Directly import data into any drawing, modeling, statistical analysis, risk assessment, or any other third-party software without the need for reformatting.

Maintenance Calendars

AutoSchedule.png

Automated scheduling, alerts, and notifications for maintenance and monitoring for any piece of equipment – field tools, fleet vehicles, laboratory equipment, or even a full-scale treatment plant.

Report-Ready Tables

ReportTable.png

Customizable, report-ready tables designed to provide you data without the need for reformatting.  Choose from our standard tables or have us customize tables based on your project needs, such as statistical information or comparison to screening criteria such as USEPA Maximum Contaminant Levels or Regional Screening Levels.

Support & Customization

CustomSupport.png

Reduces the need for dedicated programmers on your staff with customization of the database and existing applications provided by 212 Environmental. In addition, new applications can be developed and added to the system affordably and seamlessly by 212 Environmental database experts and programmers.

Comparison Guide

20220408_ComparisonTable_Draft.png

Pricing Philosophy

We work with our customers to develop their own unique environmental data management system based on their needs, because we know that no two organizations are the same. No matter the size of the organization or scope of the project, we will help tailor your 212 EDMS solution to meet your challenges at an affordable price. In many cases, we can create new or custom applications to solve specific problems that may be unique to your project or facility. All costs are transparent and definable. We’ve done away with complex, incomprehensible pricing models and created simple, straightforward pricing, displayed in an itemized quote with your selected applications.

Getting Started

Picture1.png

Your New EDMS

EDMSMockup_Dashboard.png

Cost Example

EDMS_PricingModelExample_ForWebsite_HighRes.png

**Cost Example is based on estimate created for a customer with three total users and three hours of technical support & development time (monthly cost shown includes requested development time billed evenly over one year).  All 212 EDMS packages are created specifically for each customer and therefore will have different monthly and annual costs.  Contact us to set up an appointment to create an affordable solution for your specific requirements.