What is EnDAR?

EnDAR is a data management system for storing, managing, and querying your environmental data.

Our software helps you validate your data files and upload them to the database. Our database tracks the history of changes to that data. Our tools can help streamline sample planning and field data collection.

Web-based reports and dashboards are intuitive ways for clients and managers to understand the data. These are usually project-specific, but we can build them quickly so they are cost-effective for almost any client.

Is EnDAR right for my project?

There is likely no data management system out there that does everything you want the way you want, but EnDAR can make new possibilities feasible and affordable for your project. It provides a starting point for data management with little or no cost, and can be expanded according to your needs and budget. We're happy to discuss with you the most economical way to serve your needs.

Call or e-mail us, and we can help you understand whether EnDAR is a good fit for your project.

Christine Lew
(925) 280-7426 / Christine.Lew@tetratech.com

Travis Clark
(720) 376-4683 / Travis.Clark@tetratech.com

How do I get started?

To get started with EnDAR, we recommend first evaluating the needs of your project: Do you want to improve data storage and reporting? Do you need more efficient data collection? Do you have data loggers you want to automate? With EnDAR, you can use as little or as much of the system that you need.

For a simple project, find an example of the data you would like to store, and perhaps an example report table, send that to us and we can walk you through using the system to manage your data. For more complicated applications, email us or give us a call to discuss your needs.

If you want to try EnDAR for yourself, you can follow the instructions in this Quick Start Guide

What about security?

The shared EnDAR database restricts user permissions according to project site. However, the best security is to have a dedicated database for your project, which we can accomplish in just a few hours, with full software support.

How does EnDAR work?

At its core, EnDAR is a SQL Server database. A data processor manages any database tables that conform to certain patterns, and it tracks the full history of every record. The processor supports adding, editing, and deleting records using CSV files, which are called EDDs (electronic data deliverables). It checks data files for missing fields, incorrect data types, and invalid lookup values

The Data Manager provides an interface around the EDD processor for viewing file issues and upload results. It also supports finding existing records to edit or delete and contains a sample planner. A separate mobile application works with the sample planner for field data collection

EnDAR includes a notification system for sending out e-mails for system events, such as data uploads, and for alerting users of criteria exceedances, and a website for uploading files and viewing reports.

Features:

  • Database (SQL Server)
  • Web Application
  • Notifications
  • Web Reports
  • Dashboard
  • Sample Planning
  • Mobile Data Collection

Environmental Database:

  • Analytical Chemistry
  • Groundwater Elevations
  • Lithology
  • Field Parameters
  • Well Construction
  • Weather
  • CEDEN tables: toxicology, habitat
  • Remote Monitoring Data

Web Application:

  • Download templates and upload data files to the database
  • Browse data tables
  • Run reports on the data
  • Access dashboards
  • Perform system administration tasks (users, permissions, etc.)

EnDAR Data Processor:

  • Visual feedback
  • Atomic uploads: no partial files
  • Full history of all records
  • Use files to edit and delete data

Dashboard:

  • Interactive maps, charts, tables
  • Customized for project-specific visualization
  • Built in Power BI or Tableau
  • Exports for reports, presentations

Sample Planner:

  • Plan routine and special sampling events
  • Wizard-based to guide planning process
  • Uses pre-defined, project-specific analysis plans
  • Data transmitted to field application to guide data collection

Mobile Field Data Collection:

  • Collection on phone or tablet (Android or iOS)
  • Information from sample plans downloaded for offline use
  • Collection information is date/time/location stamped
  • Enter field parameters and capture photos
  • After upload of collection data, COC printed from website

Remote Monitoring Systems:

  • Store data collected via data loggers, air monitoring stations, other remote monitoring systems
  • Optimized data storage for high-frequency data
  • Automated import from cloud or telemetry systems