Build 25.1 (Jun 2025)

The EQuIS 7.25.1 Build files are available in the "Products" folder on the Downloads Dashboard of the EarthSoft Community Center (ECC). Per our Product Support Lifecycle, this release will be supported for 24 months.

Please review the known issues listed in this chapter.

A list of reports as well as Schema files and database scripts updated in this release can be found later in this article.

This build includes the following highlights:

•Alive

•Alive Schema – Added new fields to AT_SAMPLE_OBSERV table.

•Alive EDGE Format – Fixed format accessibility.

•ArcEQuIS

•ArcEQuIS Table Labels Report – Increased functionality so that users can further customize table label appearance and display more data.

•ArcEQuIS Crosstab Converter Report – Resolved issue with report returning non-related data when selecting a location group.

•Numerous interface improvements and bug fixes.

•Collect

•Bug fixes for Collect Enterprise.

•Data Governance

•New DQM and SPM metrics reports available on the ECC.

•DQM

•Updated Holding Time, Relative Percent Difference (RPD), and Surrogate Recovery checks.

•DQM Reports – Added ASSO_EX_SAMPLE and Third-party Validation Fields to report output.

•Bug fixes.

•EDP

•Tables with Warnings Only (no errors) displayed in orange.

•Enterprise EDP – Add ST_CONFIG table setting to notify data submitters when EDD is stuck.

•Formats now recognize Enterprise licenses.

•New Oil_Gas_Baseline_EQEDD format package for loading and reporting fracking-specific data available on the ECC.

•New ERPIMS Group 3 Prime report that is part of the ERPIMS format package available on the ECC.

•Updated the ActionLevels, EQEDD, EQEDD_v2, ERPIMS, Facility, GeotrackerEDF, Historical, Person_and_Company and refvals formats.

•Numerous improvements and bug fixes.

•Enterprise

•Improvements to deployment process:

•Deploy button added to Module Manager widget.

•Auto-publish report DLL files added to the Enterprise deploy folder.

•Auto-save user report XML files added to the Enterprise deploy folder.

•Auto-update report and user report references from incoming dashboard files.

•New File Association Manager Widget (Beta) – Add, view, and download files associated with certain records in database.

•Map Widget – Improved access to OAuth-secured layers.

•Time Series Chart Widget – Added setting to enable/disable export options.

•Web Forms Widget – Added numerous interface improvements.

•Launch Professional – Added Facility Group connection.

•EarthSoft.Enterprise.dll and widget security improvements.

•Bug fixes.

•EnviroInsite

•Numerous improvements and fixes for Boring Logs and Subsurface Profiles:

•Added option to open and save EnviroInsite templates from database.

•Multiple data series can be plotted in a single column.

•Conditional line types for function columns.

•Improved lithology remark to avoid overlap and include depth.

•Added CAS_RN to Constituent names for the 2D/3D charts, tables, and diagram elements query.

•Added Signing Certificate to executable files.

•Numerous improvements and fixes.

•Geotech

•Updated the Geotech Schema.

•Updated Geotechnical_v2 and Geotech_refvals formats.

•Updated Geotechnical Compaction and Results reports.

•Link

•Fixed AGS file error.

•Live

•New beta Live File Processor widget interface to add a device to the database using a wizard.

•Updated Live format so that DT_LOGGER_DATUM drop-down menus filter correctly.

•Added Signing Certificate to the Live File Processor and Loggernet PowerShell Scripts.

•Numerous user interface improvements and fixes to the Live Chart, Live Circular Gauge, Live Heatmap, Live Historical Chart, Live Table, Live Wind Rose Chart, and Live Weather Underground widgets.

•Professional

•Improved the current Enterprise user login method (browser pop-up) to retain username.

•Action Levels Form – Improved the Advanced Action Levels Lookup column filter.

•EQuIS Alert Form – Deprecated and will no longer be available on the ECC.

•Advanced Action Levels – Add multiple-analyte calculations.

•Updated Action Level Exceedance II, Analytical Results II, Analytical Results II - Statistics, Location Parameters (Extra Fields), RDL, Statistics: Analytical Statistics (by Location), Water Level - Action Level Exceedance, and Water Levels II reports.

•Updated third party icons on the Data and Graphics ribbons.

•New reports/forms:

oNew Role Manager Form – Adds ability to assign users to roles in Professional, bypassing connection timeouts.

oNew Agent - Configuration Settings Report – Enables administrators to modify certain ST_CONFIG settings in the report interface.

oNew Agent - Coordinate Updates Report – Enables users to add converted coordinates via Enterprise

oNew Reference Value Summary Report – Generates Excel file with reference values pertinent to analytical results data for given facility or facilities

•REST API

•Updated Swagger user interface.

•New api/report/{reportId}-GeoJSON Endpoint – Uses reportID to provide a distinct name and prevent duplicate errors in ArcGIS Online with GeoJSON links created through EZView widget.

•Removed deprecated POST /api/spm/tasks/scheduleChangeReasons endpoint.

•Several minor updates and fixes.

•Schema – Standard, Alive, EDGE, Enterprise, Geotech, and SPM Schema updates required; External License Database updates required.

•Fixed incorrect EUID column definitions in EUID-Based _ID tables potentially causing mismatches.

•Stopped publishing v54 Reports in new databases and set defunct v54 reports to STATUS_FLAG = ‘R’.

•See Schema Files and Scripts section below.

•SPM

•Added filtering for easier selection when assigning samples to a Chain of Custody.

•Updated EZSPM, EZSRN, SPM_CONTRACT, SPM_eQuote and SPM formats.

•Updated SPM COC, SPM Completeness Report, SPM Completeness Table - Activities, SPM Labels (Custom2), SPM Laboratory Invoice, SPM Task Details, and SPM Planned Task Details reports.

•Numerous improvements and bug fixes.

Report Files

Republishing reports is an additional step that an admin-level user can perform after an installation or build upgrade. Below are the reports that have been updated or created with this release. EarthSoft recommends reports be republished for this build of EQuIS if they have already been published to the database.

As you run user reports and custom reports built on any republished reports, please ensure that they function as expected. If not, they should be rebuilt (e.g., reloaded with the published report, new parameters selected if needed, and user reports resaved or custom reports republished). Added report parameters or changes to the DISPLAY_TYPE of report parameters are most likely to affect user reports.

DQM

EarthSoft.Reports.Library.63867.dll

•DQM Event – See Release Note d44163 for details.

EnviroInsite

EarthSoft.Reports.Library.EnviroInsite.dll

•EnviroInsite Boring Logs II – See Release Note d42855 for details.

Geotech

EarthSoft.Reports.Library.176839.dll

•Geotechnical Atterberg Limits – See Release Note d45173 for details.

•Geotechnical Compaction – See Release Note d42456 for details.

•Geotechnical Water Content vs. Depth – See Release Note d42822 for details.

EarthSoft.Reports.Library.d30189.dll

•Geotechnical Results – See Release Notes d41901 and d42831 for details.

Professional

EarthSoft.Reports.Library.14425.dll

•Statistics: Analytical Statistics (by Location) – See Release Note d42898 for details.

EarthSoft.Reports.Library.50943.dll

•Analytical Results II – See Release Note d42845 for details.

EarthSoft.Reports.Library.51729.dll

•Action Level Exceedance II – See Release Notes d43569, d46357, d46570, d46748, d46900, and d46936 for details.

EarthSoft.Reports.Library.52702.dll

•Water Level - Action Level Exceedance – See Release Note d45599 for details.

EarthSoft.Reports.Library.64102.dll

•Water Levels II – See Release Note d43271 for details.

EarthSoft.Reports.Library.65991.dll

•Location Parameters (Extra Fields) – See Release Note d46022 for details.

EarthSoft.Reports.Library.80823.dll

•Analytical Results II - Statistics – See Release Note d42953, d45073, and d46165 for details.

EarthSoft.Reports.Library.627608.dll

•ArcEQuIS Crosstab Converter – See Release Note d42942 for details.

EarthSoft.Reports.Library.d36974.dll

•ArcEQuIS Table Labels – See Release Note d45866 for details.

SPM

EarthSoft.Reports.Library.48827.dll

•SPM Completeness – See Release Note d43561 for details.

•SPM Completeness Table - Activities – See Release Note d44316 for details.

•SPM Labels (Custom2) – See Release Note d42715 for details.

•SPM Planned Task Details – See Release Notes d42945 and d44884 for details.

•SPM Task Details – See Release Note d42945 for details.

EarthSoft.Reports.Library.72317.dll

•SPM - COC – See Release Notes d42695 and d44438 for details.

EarthSoft.Reports.Library.197043.dll

•SPM - Laboratory Invoice – See Release Note d44801 for details.

Schema Files and Scripts

The following Schema files and database scripts have changed since the previous build. The locations and purpose of these Schema files are provided on the Database Schema page. For information on applying new Schemas to a database, see Applying Additional Modules/Schemas to a Database. Custom formats can be updated to match the new Schema changes. See Making Changes to Format Files for additional information. Contact your account manager if assistance is needed from EarthSoft in updating a custom format.

Alive: Schema.Alive.xme

•See Release Note d46642 for details.

EDGE:

•See Release Note d47681 for details.

Enterprise:

•See Release Note d47664 for details.

Geotech: schema.geotech.xse

•See Release Notes d46220 and d47665 for details.

Professional: schema.xme

•See Release Notes d39538, d43427, d43466, d43468, d43471, d45431, d46214, d46223, d46359, d46376, d46593, and d47528 for details.

SPM: schema.SPM.xme

•See Release Note d47666 for details.

License Database: Updated External SQL License Database script to transfer object permissions from the public role to the ES_PUBLIC role. Script available on the EarthSoft Community Center Downloads Dashboard, under Products > Additional Resources.

•See Release Note d40806 for details.