Location Information

Report Name: Location Information (example)

Stored Procedure: v54.location_info

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Note: The v54 reports have been superseded by more comprehensive class reports (version ‘II’). The Location Information report was replaced by Location Information (Class). EarthSoft recommends using the Location Information (Class) report rather than Location Information to take advantage of additional features, fixes, and performance optimization.

Description: The Location Information Report provides metadata about sample locations (wells, boreholes, etc.), including the matrices by which locations have been sampled as well as the screened interval.

Installation Instructions: The Location Information report is part of the EQuIS Schema and is created when the EQuIS database is created.

Overview:

Source Tables DT_FACILITY, DT_LOCATION, DT_SAMPLE, DT_WELL_SEGMENT, RT_GROUP, RT_GROUP_MEMBER, RT_MATRIX, 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)

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

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

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