Groundwater Data Management Platform

The Vendor is required to provide for groundwater data management software platform.
- Locations and Datums
•    Supports creation and maintenance of location-based data management (i.e., establishment of groundwater locations/stations with associated metadata and time series)
•    Provides customizable location types (e.g., “groundwater station”)
•    Allows for the creation, assignation, and customization of location attributes including strings/text, drop-down/picklists, Booleans, and numbers)
•    Permits the assignation of a standard datum and additional, customizable datums
•    Capable of vertical datum conversions
- Time Series
•    Supports multiple time series for each location
•    Associates time series with user-defined parameters (e.g., depth-to-water, temperature)
•    Provides data review tools including editing, analysis, and time series comparison
•    Supports editing of time series data including, at minimum, functions for applying drift corrections, offsets, and trims
•    Maintains and displays raw data independent of editing actions
•    Permits statistical calculations per time series (e.g., rolling averages, rate of change)
•    Computes periodic statistics per time series (e.g., daily maximum)
•    Allows for the filling of data gaps from one time series to another
•    Allows mixing of time series based on definable criteria or thresholds
•    Provides customizable approval levels assignable to data by level and timespan
•    Provides customizable grades assignable to data by grade and timespan
•    Provides customizable qualifiers assignable to data by qualifier, qualifier group, and timespan
•    Allows for the recording of field visits for the validation and adjustment of reference points
- Users & Auditing
•    Supports multiple user accounts definable by role and associated permissions
•    Maintains a log of all data corrections, metadata changes, and notes by user
- Map & Dashboards
•    Uses an interactive map to display locations, including the means to aggregate them, filter and symbolize them using location attributes, and select the parameters and timespans to display
•    Allows for the creation of customizable dashboards using widgets for time-series data, charts, text, and images
•    Supports API for exporting time-series data and statistics to external systems such as ArcGIS
•    Supports statistics definitions, custom legends, heat maps and reference periods
•    Permits internally hosted, customizable logos, chart images, and spreadsheet images
- Visualization
•    Provides customizable charts for displaying time-series data including axis scaling, custom coloring of lines, line types, and timeframes
•    Allows grades, approval levels, and qualifiers to be displayed alongside time-series data in charts
•    Allows charts to be saved, added to dashboards, or exported in CSV, PDF, and image formats.