Data Validation

 

 

Data Validation

By default, when the data file name is specified, EnviroInsite goes through a process of data validation to check the integrity of the linked data fields. A listing of errors and inconsistencies is displayed in the Output window. The data validation procedure consists of the following checks: 

1.All constituent names in the measured value table are contained in the constituent table.

2.All well names in the screen table are contained in the well table.

3.All well-screen pairs in the screen table are contained in the measured value table.

4.Null screen names in screen table and measured value table are replaced with a hyphen.

5.Null media field values in the observation table and null class field values in the wells table are replaced with a hyphen.

Data files with errors can be used although some data may not be plotted if the errors are not reconciled.

Users can turn off the data validation option by unchecking the do data validation checkbox in the open-database file dialog box.