Collect – Boring Log Map

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Collect Module >

Collect – Boring Log Map

Report Name: Collect – Boring Log Map (example)

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

Dependencies: Licensed Collect Module, EarthSoft.Reports.Library.EnviroInsite.dll

Software: EQuIS Collect, EQuIS Enterprise

Source: EQuIS Collect install

Language: English

Output Type: Report Grid1 or Link to generate a PDF

 

Description: The Boring Log Map report returns a georeferenced EnviroInsite boring log report.

 

Installation Instructions: This report requires a licensed EQuIS Collect module and the Collect Schema applied to the database. For use, this report should be published to the database and it. When publishing the report, the assembly should be stored in the database. First download the EQuIS Collect xcopy zip from the community center, unblock the *.zip file and extract the EarthSoft.Reports.Library.149680.dll file to the EQuIS Professional installation folder. For default installations this directory is C:\Program Files\EarthSoft\EQuIS. The report will be available for selection once it has been published.

 

This report also requires the EarthSoft.Reports.Library.EnviroInsite.dll file assembly. See instructions in EnviroInsite Report Installation to make this report available in Enterprise and therefore to this Collect report.

 

Overview:

The report can then be used as a layer in Collect Map to allow the user to open PDF boring logs from plots on the map. The user selects an EnviroInsite Boring Logs user report ID and location(s) and gets a link to generate a PDF report along with other fields related to the locations selected.

 

Tables: DT_LOCATION and DT_WELL tables are accessed in all report executions. Other tables may also be accessed depending on the contents of the boring log template being used. These include: DT_WATER_TABLE, DT_DRILL_ACTIVITY, DT_LITHOLOGY, DT_SAMPLE, DT_SAMPLE_PARAMETER, DT_DRILL_PARAMETER, DT_DOWNHOLE_POINT_DATA, and DT_WELL_SEGMENT.

 

 

Report Parameters

Report ID

Parameter for selecting the facility.

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Well Image Code

PLACE_CODE selection parameter.

EnivorInsite Boring Log


 

 

Report Output

FACILITY_ID

SYS_LOC_CODE

LOC_NAME

DATA_PROVIDER

SUBFACILITY_CODE

LOC_DESC

LOC_TYPE

LOC_PURPOSE

LOC_TYPE_2

LOC_MAJOR_BASIN

WITHIN_FACILITY_YN

LOC_COUNTY_CODE

LOC_DISTRICT_CODE

LOC_STATE_CODE

LOC_MINOR_BASIN

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

STREAM_CODE

STREAM_MILE

PHASE_CODE

REMARK_1

REMARK_2

BORE_ID

START_DATE

END_DATE

DRILLING_METHOD

GEOLOGIST

SAMPLING_METHOD

DRAWING_CHECKER

DRAWING_CHECK_DATE

DRAWING_EDITOR

DRAWING_EDIT_DATE

DRILLER

DEPTH_TO_BEDROCK

LOG_DATE

BEARING

PLUNGE

APPROVED

DRILLING_SUBCONTRACTOR

ENGINEER_SUBCONTRACTOR

ENGINEER

ESTAB_COMPANY_CODE

INSPECTOR

INSPECT_SUBCONTRACTOR

EBATCH

MAP_CODE

STATUS_FLAG

TOTAL_DEPTH

X_COORD

Y_COORD

UNITS

SURF_ELEV

ELEV_UNIT

WELL_ID

WELL_STATUS

LOG_REPORT

PHOTO

FACILITY_ID1

FACILITY_CODE

 

 

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