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

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.