EQuIS Query

<< Click to Display Table of Contents >>

EQuIS 7  >>  EnviroInsite > EQuIS Database >

EQuIS Query

In addition to the standard query options, EQuIS database users are able to query from an additional set of fields that are not included in the standard EnviroInsite database.  Users connected to an EQuIS database will see these additional query options on an EQuIS Query tab within the data-centric object dialog boxes. Selecting none of the field values for a particular field will result in that field not being included as part of the resulting query. For instance, if no sample type is checked then the query will not consider the sample type in determining which samples are selected.

 

An explanation of the individual fields on the EQuIS query tab are explained below. Note that fields from DT_SAMPLE, DT_TEST, and DT_RESULT are revealed by selection of the sub-tabs in the lower section of the EQuIS Query tab.

 

50035-data_query_sample

 

 

50035-data_query_test

 

50035-data_query_result

 

User Report

 

In addition to selecting particular fields, query fields can be populated based on user-generated reports (e.g., Analytical Results or Analytical Results II reports). When the value of the selected user report is changed, the query fields on this tab and the primary Query tab are immediately updated based on the values in the user report. The user report name is not saved in the EnviroInsite document.

 

Only the fields contained in the EQuIS Query tab or the primary Query tab are updated. Some fields from the user report are ignored. These include the test lab matrix, the non-detect multiplier, the reporting limit, and the non-detect symbol. The non-detect multiplier is established in EnviroInsite as a document-level property.

 

There are some additional limitations in the user report:

EQuIS analyte groups are automatically converted into EnviroInsite constituent groups when first connecting to a database in EnviroInsite or on restoring an EnviroInsite document. Changes to the constituent groups in EnviroInsite are not conveyed back to the EQuIS database. These changes will also be overwritten by the contents of the EQuIS analyte group when the document is saved and then later restored in EnviroInsite.

The bar chart, pie chart, and radial diagram only allow selection of one constituent group. If several analyte groups are selected in a user report, then only the first analyte group will be used in these plot types.

In EnviroInsite, sample values are selected based on the depth query values if the depth of the sample midpoint lies between the depth limits. In EQuIS, the lower entered depth-query value is compared to sample start depths and the higher entered depth-query value is compared to sample end depths.

EnviroInsite has additional query parameters, such as elevation values and a rectangular position query, that may modify the returned values relative to the returned values in the EQuIS reports.

If both individual locations and location groups are selected during the EQuIS report generation, the resulting data is based on an OR operation on the two selections. For example in the figure below, all of the individual locations and any location in the selected location group will be pulled into the report.  When the same user report is selected in EnviroInsite, the program will perform an AND operation between the two selections. This will result in a set of locations that are within BOTH the set of individual locations and the location group.

 

50035-analytical_report_params