Location Information

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Location Parameter Reports >

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

 

 

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