Groundwater Data Management Software Platform

The Vendor is required to provide groundwater data management software platform for include:
- Groundwater data management
1. Locations and datums
•    Supports creation and maintenance of location-based data management (i.e., establishment of groundwater locations and 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 and text, drop-down and picklists, Booleans, and numbers) 
•    Permits the assignation of a standard datum and additional, customizable datums 
•    Capable of vertical datum conversions
2. 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
3. Users and auditing
•    Supports multiple user accounts definable by role and associated permissions
•    Maintains a log of all data corrections, metadata changes, and notes by user
- Groundwater data acquisition
1. Data import
•    Allows for the quick import of common groundwater-level data from sources including
•    In-situ, camp bell scientific, and sutron data loggers
•    Supports delimited txt, csv, xml, and json file formats
•    Encrypts data transfers between client and server using https or another commonly accepted protocol
2. Data capture
•    Supports the automated extraction of publicly accessible united states geological survey (USGS) national water information system (NWIS) text-file data
•    Automatically processes USGS NWIS data by specified parameters including location and station number, time zone, grade
•    Permits user-defined data capture and extraction schedules (e.g., weekly, daily, twice-daily)
- Groundwater data dissemination
1. Map and 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
2. 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
3. Reports
•    Allows for the creation of report templates including grid, crosstab, and event analysis elements
•    Allows for the definition of custom export templates
•    Permits batch and automated export of reports
•    Provides alerts, alerting templates, distribution groups, and policies for notifications
•    Creates audit logs of user access, report generation, dashboard editing, etc.