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.

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

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

** This report contains the hidden parameter: ebatch

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