Location Information (Class)

Report Name: Location Information (example)

File Name: EarthSoft.Reports.Library.113024.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Location Information (Class) Report is the class version of the database procedure Location Information Report and includes the Additional Fields and Extra Select parameters. It provides metadata about locations with records in DT_SAMPLE (wells, boreholes, etc.), including the matrices by which locations have been sampled as well as the screened interval.

The X_COORD and Y_COORD columns in the Location Information (Class) Report are populated based on the COORD_TYPE_CODE and identifier defined in the DT_FACILITY table.

To populate the Longitude and Latitude columns for locations in the report output, the LAT LONG coordinates for those locations must be populated in the DT_COORDINATE table.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

This report requires numeric values in DT_LOCATION_PARAMETER.PARAM_VALUE unless configured to be otherwise.

See Location Parameter Report Configuration for further details.

Tables: DT_LOCATION, DT_WELL_SEGMENT, VW_LOCATION

Report Parameters *

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Sample
Matrix(es)	Section one or more sample matrix(es)
Additional Fields	This parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

* This report may include hidden parameters that could affect the output of the report.

Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report
that allows saving of user reports). These paramaters cannot be viewed or changed in unpublished reports outside of a
report parameter file.

Report Output
FACILITY_ID FACILITY_CODE SYS_LOC_CODE LOC_TYPE LOC_DESC LOC_PURPOSE LOC_MAJOR_BASIN	LOC_MINOR_BASIN LOC_COUNTY_CODE LOC_STATE_CODE X_COORD Y_COORD WITHIN_FACILITY_YN SURF_ELEV	TOTAL_DEPTH MATRIX_DESC SCREEN_TOP SCREEN_BOTTOM LONGITUDE LATITUDE STREAM_MILE

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_TYPE

LOC_DESC

LOC_PURPOSE

LOC_MAJOR_BASIN

LOC_MINOR_BASIN

LOC_COUNTY_CODE

LOC_STATE_CODE

X_COORD

Y_COORD

WITHIN_FACILITY_YN

SURF_ELEV

TOTAL_DEPTH

MATRIX_DESC

SCREEN_TOP

SCREEN_BOTTOM

LONGITUDE

LATITUDE

STREAM_MILE

Troubleshooting Error Messages

Error converting data type varchar to float.

Symptoms: Message received after attempting to run the report:

Error converting data type varchar to float.

Cause/Details: This error can occur if DT_COORDINATE.ELEV is populated with non-numeric values such as 'N/A','NA','NM','NSA', '-' or including trailing spaces (e.g. dt_coordinate.elev = '123.45 ' when it needs to be '123.45').

Resolution/Workaround: Please review DT_COORDINATE.ELEV to make sure it is populated with only numeric values.

MISSING UNIT CONVERSION FACTOR

Symptoms: Message received after attempting to run the report:

"MISSING UNIT CONVERSION FACTOR - cannot convert 'X' to 'XXX"

Cause/Details: This error can occur if any facility in the database, not only the one you are currently logged into, has different units in DT_COORDINATE.ELEV_UNIT and DT_FACILITY.ELEV_UNIT and there are no conversions for those units in RT_UNIT_CONVERSION_FACTOR.

Resolution/Workaround: Please review RT_UNIT_CONVERSION_FACTOR and add any necessary necessary unit conversion factors.

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.

LocationInformation