Example of EntityLoader

This file is based on a table of information on the Stratton Field in Texas. The data is supplied by the Bureau of Economic Geology of the state of Texas.

A table of data for 23 wells was supplied. Following is the 36 columns of data in the well information table. it includes some basic information on the well, and then contains 30 picks of 10 horizons. Each horizon has a kelly bushing depth, a sea level depth, and a two-way seismic travel time. Note that a 99999 represent a null field. The column names are given below, along with the data from the first well. Once the first well is done, all other wells follow the same pattern.

Column name Well #1 value
Well no. 1
Inline (EW lines) 94
Crossline (NS lines) 60
Elevation (kelly bushing [KB]) 111
X 3245
Y 5115
B46 KB datum 4790
B46 Sea-level (SL) datum 4679
B46 Two-way time (ms) 1262
C38 KB datum 5150
C38 SL datum 5039
C38 Two-way time (ms) 1333
D11 KB datum 5445
D11 SL datum 5334
D11 Two-way time (ms) 1391
D18 KB datum 5570
D18 SL datum 5459
D18 Two-way time (ms) 1416
E41 KB datum 6260
E41 SL datum 6149
E41 Two-way time (ms) 1553
E49 KB datum 6322
E49 SL datum 6211
E49 Two-way time (ms) 1565
F11 KB datum 6420
F11 SL datum 6309
F11 Two-way time (ms) 1585
F21 KB datum 99999
F21 SL datum 99999
F21 Two-way time (ms) 99999
F37 KB datum 99999
F37 SL datum 99999
F37 Two-way time (ms) 99999
F39 KB datum 99999
F39 SL datum 99999
F39 Two-way time (ms) 99999

Following is an example EntityLoader file for the single well above. Note that EntityLoader treats a single well completely before going to the next well.

The EntityLoader file is given in

preformatted courier text.
Inline comments will be in italicized color . These comments may not be a part of the load file.

Refer to the EntityLoader documentation in Appendix H of the Data Access and Exchange Specification for documentation of the commands.

 

Begin by looking up some instance handles.
These are mostly reference entities and standard values.
LOOKUP	actual
VALUE	ref_existence_kind	name	actual

LOOKUP	loc_field
VALUE	ref_naming_system	kind	local field

LOOKUP	ilab
VALUE	ref_source	name	ILAB

LOOKUP	earth2d
VALUE	ref_coordinate_system_constraint	name	earth 2d

LOOKUP	mdsys
VALUE	ref_coordinate_system_constraint	name	measured depth system

LOOKUP	vertsys
VALUE	ref_coordinate_system_constraint	name	vertical system

LOOKUP	kbpt
VALUE	ref_wellbore_point	name	kelly bushing

LOOKUP	inside
VALUE	ref_object_intersection	kind	inside

LOOKUP	is_within
VALUE	ref_well_surface_feature_role	kind	is located within

LOOKUP	mdepth
VALUE	ref_quantity_property	name	measured depth

LOOKUP	twotime
VALUE	ref_quantity_property	name	seismic time

LOOKUP	sealevel
VALUE	local_spatial_coordinate_system	identifier	sea level elevation

Here is some information loaded earlier.
LOOKUP	stratton_field
VALUE	regulatory_field	identifier	Stratton-Agua Dulce field

LOOKUP	stratton_area
VALUE	general_surface_area	identifier	Stratton Agua Dulce field

If an instance exists, use it. If not, create it.
IF_NEXISTS	labelaa	csorig
VALUE	ref_other_earth_point	kind	coordinate system origin

ENTITY	ref_other_earth_surface_point	csorig
ATTRIBUTE	kind	DAE_C_STRING
VALUE	coordinate system origin
ATTRIBUTE	description	DAE_C_STRING
VALUE	A point that serves as an origin to a coordinate system.
ATTRIBUTE	source	DAE_C_INSTANCE
VALUE	HANDLE	ilab

LABEL	labelaa

This sets up some local coordinate systems to be
used for the project. These are instantiated once.
ENTITY	general_earth_surface_point	swcorner
ATTRIBUTE	identifier	DAE_C_STRING
VALUE	SW Corner, Stratton Field area
ATTRIBUTE	description	DAE_C_STRING
VALUE	The South West Corner of the seismic survey supplied 
by the BEG, in the Stratton Field. Location unknown.
ATTRIBUTE	ref_other_earth_point	DAE_C_INSTANCE
VALUE	HANDLE	csorig

ENTITY	general_coordinate_system_axis	xaxis
ATTRIBUTE	ref_quantity_property	DAE_C_INSTANCE
VALUE	ref_quantity_property	name	x

ENTITY	general_coordinate_system_axis	yaxis
ATTRIBUTE	ref_quantity_property	DAE_C_INSTANCE
VALUE	ref_quantity_property	name	y

ENTITY	local_spatial_coordinate_system	xysystem
ATTRIBUTE	identifier	DAE_C_STRING
VALUE	Stratton local coordinate system
ATTRIBUTE	ref_coordinate_system_constraint	DAE_C_INSTANCE
VALUE	HANDLE	earth2d
ATTRIBUTE	source	DAE_C_INSTANCE
VALUE	HANDLE	ilab
ATTRIBUTE	description	DAE_C_STRING
VALUE	Local 2d coordinate system with origin at southwestern 
corner of the Stratton field. Supplied by the BEG
ATTRIBUTE	coordinate_system_axis	DAE_AGG_LIST	DAE_C_INSTANCE
VALUE	HANDLE	xaxis
VALUE	HANDLE	yaxis
ATTRIBUTE	earth_surface_feature	DAE_AGG_SET	DAE_C_INSTANCE
VALUE	HANDLE	stratton_field
ATTRIBUTE	vertex	DAE_C_INSTANCE
VALUE	HANDLE	swcorner

ENTITY	vertical_time_system_axis	vtaxis
ATTRIBUTE	ref_quantity_property	DAE_C_INSTANCE
VALUE	HANDLE	twotime
ATTRIBUTE	description	DAE_C_STRING
VALUE	Two way P wave travel time from sea level
ATTRIBUTE	vertical_datum	DAE_C_INSTANCE
VALUE	geoid	identifier	Mean Sea Level

ENTITY	local_spatial_coordinate_system	time
ATTRIBUTE	identifier	DAE_C_STRING
VALUE	Two way time system
ATTRIBUTE	ref_coordinate_system_constraint	DAE_C_INSTANCE
VALUE	HANDLE	vertsys
ATTRIBUTE	source	DAE_C_INSTANCE
VALUE	HANDLE	ilab
ATTRIBUTE	coordinate_system_axis	DAE_AGG_LIST	DAE_C_INSTANCE
VALUE	HANDLE	vtaxis

All the above is done once. The information captured
above can be reused for each well.
Now begin the wells. Only well #1 is actually done in this example.
The first four entities duplicate the type of information in the refLoadLevelOne example.
ENTITY well well ATTRIBUTE identifier DAE_C_STRING VALUE Stratton #1 ATTRIBUTE ref_existence_kind DAE_C_INSTANCE VALUE HANDLE actual ATTRIBUTE ref_naming_system DAE_C_INSTANCE VALUE HANDLE loc_field ENTITY well_surface_feature_role ATTRIBUTE well DAE_C_INSTANCE VALUE HANDLE well ATTRIBUTE earth_surface_feature DAE_C_INSTANCE VALUE HANDLE stratton_field ATTRIBUTE ref_well_surface_feature_role DAE_C_INSTANCE VALUE HANDLE is_within ENTITY wellbore wbore ATTRIBUTE identifier DAE_C_STRING VALUE Stratton #1 ATTRIBUTE ref_existence_kind DAE_C_INSTANCE VALUE HANDLE actual ATTRIBUTE ref_naming_system DAE_C_INSTANCE VALUE HANDLE loc_field ATTRIBUTE well DAE_C_INSTANCE VALUE HANDLE well ENTITY well_surface_point wsp ATTRIBUTE identifier DAE_C_STRING VALUE Stratton #1 ATTRIBUTE well DAE_C_INSTANCE VALUE HANDLE well Give some locations (x,y) and elevations ENTITY pty_location_2d ATTRIBUTE well_surface_point DAE_C_INSTANCE VALUE HANDLE wsp ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE xysystem NULL 2 3245 ft 5115 ft ENTITY kelly_bushing_reference kelly ATTRIBUTE identifier DAE_C_STRING VALUE kelly bushing for Stratton #1 ATTRIBUTE ref_existence_kind DAE_C_INSTANCE VALUE HANDLE actual ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ENTITY general_wellbore_point kb ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE identifier DAE_C_STRING VALUE kelly bushing for Stratton #1 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE kbpt ATTRIBUTE wellbore_component_facility DAE_C_INSTANCE VALUE HANDLE kelly ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE kb ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE sealevel NULL 1 111 ft Create a measured depth coordinate system for the well. Each well will have its own. Measured depths will be given referencing this coordinate system. ENTITY measured_depth_system_axis mdaxis ATTRIBUTE ref_quantity_property DAE_C_INSTANCE VALUE HANDLE mdepth ENTITY local_spatial_coordinate_system mdcs ATTRIBUTE identifier DAE_C_STRING VALUE Stratton #1 MD system ATTRIBUTE ref_coordinate_system_constraint DAE_C_INSTANCE VALUE HANDLE mdsys ATTRIBUTE source DAE_C_INSTANCE VALUE HANDLE ilab ATTRIBUTE coordinate_system_axis DAE_AGG_LIST DAE_C_INSTANCE VALUE HANDLE mdaxis Ready to store picks. Lookup previously stored marker names. LOOKUP B46 VALUE lithostratigraphic_marker identifier B46 LOOKUP C38 VALUE lithostratigraphic_marker identifier C38 LOOKUP D11 VALUE lithostratigraphic_marker identifier D11 LOOKUP D18 VALUE lithostratigraphic_marker identifier D18 LOOKUP E41 VALUE lithostratigraphic_marker identifier E41 LOOKUP E49 VALUE lithostratigraphic_marker identifier E49 LOOKUP F11 VALUE lithostratigraphic_marker identifier F11 LOOKUP F21 VALUE lithostratigraphic_marker identifier F21 LOOKUP F37 VALUE lithostratigraphic_marker identifier F37 LOOKUP F39 VALUE lithostratigraphic_marker identifier F39 LOOKUP tvdsl VALUE local_spatial_coordinate_system identifier tvd from sea level LOOKUP gpick VALUE ref_wellbore_point name geologic pick For each pick, Create a point. Give the measured depth (in coordinate system mdcs) Give the true vertical depth (in coordinate system tvdsl) Give the two way travel time (in coordinate system time) Note that the pattern is the same for each location that is stored. ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE B46 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon B46 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE B46 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 4790 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 4679 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1262 msec ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE C38 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon C38 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE C38 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 5150 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 5039 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1333 msec ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE D11 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon D11 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE D11 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 5445 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 5334 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1391 msec ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE D18 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon D18 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE D18 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 5570 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 5459 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1416 msec ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE E41 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon E41 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE E41 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 6260 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 6149 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1553 msec ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE E49 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon E49 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE E49 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 6322 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 6211 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1565 msec ENTITY general_wellbore_point wbpt ATTRIBUTE identifier DAE_C_STRING VALUE F11 Stratton #1 ATTRIBUTE description DAE_C_STRING VALUE Pick for reservoir horizon F11 in Stratton #1 ATTRIBUTE wellbore DAE_C_INSTANCE VALUE HANDLE wbore ATTRIBUTE geologic_feature DAE_C_INSTANCE VALUE HANDLE F11 ATTRIBUTE ref_wellbore_point DAE_C_INSTANCE VALUE HANDLE gpick ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE mdcs NULL 1 6420 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE tvdsl NULL 1 6309 ft ENTITY pty_location_1d ATTRIBUTE wellbore_point DAE_C_INSTANCE VALUE HANDLE wbpt ATTRIBUTE data_value DAE_C_LOC_QTY_REAL VALUE HANDLE time NULL 1 1585 msec

{Return to Getting Started Introduction]
[Return to text file]