Well Construction

<< Click to Display Table of Contents >>

Well Construction

Report Name: Well Construction

 

Report Type: Standard Report, class type

 

Description: The  Well Construction Report is a class and Igrid Report that outputs well construction information from DT_WELL, DT_LOCATION, DT_COORDINATE, and DT_WELL_SEGMENT with default SEGMENT_TYPE='SCREEN'. The default value of SEGMENT_TYPE can be modified in ST_CONFIG by populating a new SEGMENT_TYPE value in STRING_VALUE where CONFIG_SECTION='well construction' and CONFIG_KEY='segment_type'.

                         

The X_COORD and Y_COORD columns are renamed as LONG/LAT, SPX/SPY, EASTING/NORTHING accordingly based on COORD_TYPE_CODE like '%LAT%LONG%', '%SPCS%' or '%UTM%'.

 

Report Dependencies: There are no dependencies for this report.

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)



Coordinate Type Code



Identifier




PRIMARY




                                               

30108-input.params.scrnsht

SYS_LOC_CODE, LOC_NAME, LOC_DESC, IS_WELL, LOC_STATE_CODE, LOC_COUNTRY_CODE, STREAM_MILE, UNITS, LOC_TYPE, LOC_TYPE_2, ELEV_DATUM_CODE, REFERENCE_POINT, HORZ_DATUM_CODE, HOR_ACCURACY_VALUE, HORZ_COLLECT_METHOD_CODE, SOURCE_SCALE, ELEVATION_OF, TOP_CASING_ELEV, ELEV_ACCURACY_VALUE, ELEV_COLLECT_METHOD_CODE, TOC, STICKUP_HEIGHT, STICKUP_UNIT, WELL_ID, WELL_OWNER, DEPTH_OF_WELL, WELL_DEPTH_UNIT, HEAD_CONFIGURATION, CONSTRUCT_COMPLETE_DATE,

WELL_REMARK, START_DEPTH, END_DEPTH, DEPTH_UNIT, OUTER_DIAMETER, INNER_DIAMETER, MATERIAL_TYPE_CODE, AQUIFER, COORD_TYPE_CODE, LAT, LONG, SPX, SPY, SPZ, EASTING, NORTHING, UTMZONE

       

Tables: DT_WELL, DT_WELL_SEGMENT, DT_LOCATION, DT_COORDINATE

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 6.0+

 

Data Requirements: Locations with well construction details stored in DT_WELL and DT_WELL_SEGMENT with the appropriate SEGMENT_TYPE per default set in ST_CONFIG.STRING_VALUE (see Description above)

 

Report Requirements: N/A

 

Output Type: IGrid

 

Example Output: View the following example.

 

30108-ex.output_zoom75

 

Remap Options:

 

The report output fields shown below can be remapped using REMAP_CODE = WELL_CONSTRUCTION.

 

COORD_TYPE_CODE

REFERENCE_POINT

HORZ_DATUM_CODE

HORZ_ACCURACY_VALUE

HORZ_COLLECT_METHOD_CODE

SOURCE_SCALE

ELEV_ACCURACY_VALUE

ELEV_COLLECT_METHOD_CODE

LOC_TYPE_2

HEAD_CONFIGURATION

 

The details are populated in RT_REMAP_DETAIL as follows:

 

EXTERNAL_FIELD = the name of the field to be remapped. These values may be upper or lower characters (e.g., Coord_Type_Code is valid if needed).

EXTERNAL_VALUE = the new target value

INTERNAL_VALUE = the old source value to be remapped

 

EarthSoft.Reports.Library._103887.Well_Construction