Collect - Boring Log Map Report

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. 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.
EnviroInsite 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

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.

Collect – Boring Log Map Report

Collect – Boring Log Map Report