----------------------------------------------------
----------------------------------------------------
as of August 1996
Spud Date - Relational Implementation
Well Datum Elevation - Relational Implementation
Well Operator Name - Relational Implementation
Total Depth - Relational Implementation
Well Field Name - Relational Implementation
Well State and County - Relational Implementation
Well Purpose - Relational Implementation
Well Status - Relational Implementation
This document details the parts of the Epicentre V2.0 Data Model that Texaco operating units have populated with data. As such, it indicates where there may be a market for technical applications. Those applications that can plug into Texaco's POSC data stores and do useful things with data residing in the entities and attributes (tables and columns) described here, may well be of interest today to those Texaco Asset Teams currently using POSC data stores.
The notation loosely follows that of POSC’s Examples of Epicentre Usage document and in developing data loaders at Texaco we have tried to follow that document’s interpretation of Epicentre as closely as possible.
(* Well surface location X,Y coordinates *) wal = WELL_ALIAS well_alias_s --> varchar(19) well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) sf = WELL_SURFACE_PT well_surface_pt_s --> varchar(19) well_s --> @wl.well_s loc = P_LOCATION_2D p_location_2d --> varchar(19) object_t --> 'WELL_SURFACE_PT' object_s --> @sf.well_surface_pt_s data_cord_sys --> 'Getty Plane' data_frst_ord --> 20008 data_frst_ord_u --> 'ftUS' data_sec_ord --> 19211 data_sec_ord_u --> 'ftUS'
(*
Well spud date
*)
wal = WELL_ALIAS
well_s --> @wl.well_s
id --> '0402970925'
r_naming_system_kd --> '10 digit API'
wl = WELL
well_s --> varchar(19)
ta = TYPICAL_ACTIVITY
typical_act_s --> varchar(19)
typical_act_name --> 'spud well'
source --> 'Texaco, Inc.'
wact = WELL_ACTIVITY
well_activity_s --> varchar(19)
well_s --> @wl.well_s
typical_act_name --> 'spud well'
start_time --> 05-MAY-95
r_existence_kd_nm --> 'actual'
(* Example query to retrieve the spud date for a well
based on the above footprint.
select
wact.start_time
from
WELL_ACTIVITY wact,
WELL wl,
WELL_ALIAS wal
where
wal.id = '0402970925' and
wal.r_naming_system_kd = '10 digit API' and
wal.well_s = wl.well_s and
wl.well_s = wact.well_s and
wact.typical_act_name = 'spud well'
*)
(* Wellbore reference datum (Kelly bushing) *) wal = WELL_ALIAS well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) wb = WELLBORE wellbore_s --> varchar(19) well_s --> @wl.well_s ref = WELLBORE_REF wellbore_ref_s --> varchar(19) entity_type_nm --> 'KELLY_BUSHING_REFERENCE' wellbore_s --> @wb.wellbore_s r_existence_kd_nm --> 'actual' gwp = GENERAL_WB_PT general_wb_pt_s --> varchar(19) wellbore_s --> @wb.wellbore_s r_wellbore_pt_name --> 'kelly bushing' wb_cmpn_fcl_s --> @ref.wellbore_ref_s wb_cmpn_fcl_t --> 'WELLBORE_REF' loc = P_LOCATION_1D p_location_1d --> varchar(19) object_s --> @gwp.general_wb_pt_s object_t --> 'GENERAL_WB_PT' data_cord_sys --> 'sea level elevation' data_frst_ord --> 807.00 data_frst_ord_u --> 'ftUS'
(*
Well operators
*)
wal = WELL_ALIAS
well_s --> @wl.well_s
id --> '0402970925'
r_naming_system_kd --> '10 digit API'
wl = WELL
well_s --> varchar(19)
op = BSASC_FCL_ASN
bsasc_fcl_asn_s --> varchar(19)
facility_t --> 'WELL'
facility_s --> @wl.well_s
bsasc_s --> @bsa.bsasc_s
r_bsasc_fcl_rle_nm --> 'well operator'
bsa = BSASC
bsasc_s --> varchar(19)
bsasc_id --> 'Texaco, Inc.'
kind --> 'company'
(* Example query to retrieve the operator name for a well
based on the above footprint.
select
bsa.bsasc_id
from
BSASC bsa,
BSASC_FCL_ASN op,
WELL wl,
WELL_ALIAS wal
where
wal.id = '0402970925' and
wal.r_naming_system_kd = '10 digit API' and
wl.well_s = wal.well_s and
op.facility_s = wl.well_s and
op.facility_t = 'WELL' and
op.r_bsasc_fcl_rle_nm = 'well operator' and
bsa.bsasc_s = op.bsasc_s
*)
(*
Wellbore bottomhole reference and bottomhole depth measured from a
ground level datum
*)
wal = WELL_ALIAS
well_s --> @wl.well_s
id --> '0402970925'
r_naming_system_kd --> '10 digit API'
wl = WELL
well_s --> varchar(19)
wb = WELLBORE
wellbore_s --> varchar(19)
well_s --> @wl.well_s
bhref = WELLBORE_REF
wellbore_ref_s --> varchar(19)
entity_type_nm --> 'BOTTOM_HOLE_REFERENCE'
wellbore_s --> @wb.wellbore_s
r_existence_kd_nm --> 'actual'
gwp = GENERAL_WB_PT
general_wb_pt_s --> varchar(19)
wellbore_s --> @wb.wellbore_s
r_wellbore_pt_name --> 'wellbore bottomhole'
wb_cmpn_fcl_s --> @bhref.wellbore_ref_s
wb_cmpn_fcl_t --> 'WELLBORE_REF'
bsasc_source --> 'Texaco, Inc.'
loc = P_LOCATION_1D
p_location_1d --> varchar(19)
object_s --> @gwp.general_wb_pt_s
object_t --> 'GENERAL_WB_PT'
data_cord_sys --> 'measured depth'
data_offset_s --> @glref.general_wb_pt_s
data_offset_t --> 'GENERAL_WB_PT'
data_frst_ord --> 1500.0
data_frst_ord_u --> 'ftUS'
glref = GENERAL_WB_PT
general_wb_pt_s --> varchar(19)
r_wellbore_pt_name --> 'ground level'
wellbore_s --> @wb.wellbore_s
(* Example query, based on the above footprint, to retrieve measured depth
at the bottom of the well, along with the well's API number and
the datum from which the depth was measured.
select
wal.id,
loc.data_frst_ord,
glref.r_wellbore_pt_name
from
GENERAL_WB_PT glref,
P_LOCATION_1D loc,
GENERAL_WB_PT gwp,
WELLBORE wb,
WELL wl,
WELL_ALIAS wal
where
wal.id = '0402970925' and
wal.r_naming_system_kd = '10 digit API' and
wl.well_s = wal.well_s and
wb.well_s = wl.well_s and
gwp.wellbore_s = wb.wellbore_s and
gwp.r_wellbore_pt_name = 'wellbore bottomhole' and
loc.object_s = gwp.general_wb_pt_s and
loc.object_t = 'GENERAL_WB_PT' and
loc.data_cord_sys = 'measured depth' and
loc.data_offset_t = 'GENERAL_WB_PT' and
glref.general_wb_pt_s = loc.data_offset_s and
glref.wellbore_s = wb.wellbore_s
*)
(*
Well field (regulatory) and field name aliases
*)
wal = WELL_ALIAS
well_s --> @wl.well_s
id --> '0402970925'
r_naming_system_kd --> '10 digit API'
wl = WELL
well_s --> varchar(19)
fld = FIELD
field_s --> varchar(19)
entity_type_nm --> 'REGULATORY_FIELD'
field_id --> 'Strathspey Field'
r_naming_system_kd --> 'common name'
esa1 = ERTH_SFTR_ALIAS
erth_sftr_alias_s --> varchar(19)
earth_sftr_s --> @fld.field_s
earth_sftr_t --> 'FIELD'
id --> 'Strathspey Field'
r_naming_system_kd --> 'common name'
esa2 = ERTH_SFTR_ALIAS
erth_sftr_alias_s --> varchar(19)
earth_sftr_s --> @fld.field_s
earth_sftr_t --> 'FIELD'
id --> 'ST'
r_naming_system_kd --> 'code'
wsr = WELL_SFTR_ROLE
well_sftr_role_s --> varchar(19)
r_well_sftr_rle_kd --> 'is located within'
well_s --> @wl.well_s
earth_sftr_s --> @fld.field_s
earth_sftr_t --> 'FIELD'
(* Example query to retrieve the field name for a well based on the above footprint.
select
fld.field_id
from
FIELD fld,
WELL_SFTR_ROLE wsr,
WELL wl,
WELL_ALIAS wal
where
wal.id = '0402970925' and
wal.r_naming_system_kd = '10 digit API' and
wal.well_s = wl.well_s and
wl.well_s = wsr.well_s and
wsr.r_well_sftr_rle_kd = 'is located within' and
wsr.earth_sftr_t = 'FIELD' and
wsr.earth_sftr_s = fld.field_s and
fld.entity_type_nm = 'REGULATORY_FIELD'
*)
(*
State and county in which well resides
*)
wal = WELL_ALIAS
well_s --> @wl.well_s
id --> '0402970925'
r_naming_system_kd --> '10 digit API'
wl = WELL
well_s --> varchar(19)
wsr1 = WELL_SFTR_ROLE
well_sftr_role_s --> varchar(19)
r_well_sftr_rle_kd --> 'is located within'
well_s --> @wl.well_s
earth_sftr_s --> @st.gopl_ftr_s
earth_sftr_t --> 'GOPL_FTR'
wsr2 = WELL_SFTR_ROLE
well_sftr_role_s --> varchar(19)
r_well_sftr_rle_kd --> 'is located within'
well_s --> @wl.well_s
earth_sftr_s --> @cty.gopl_ftr_s
earth_sftr_t --> 'GOPL_FTR'
st = GOPL_FTR (* Standard instance *)
gopl_ftr_s --> varchar(19)
r_gopl_area_name --> 'state'
gopl_ftr_name --> 'California'
cty = GOPL_FTR (* Standard instance *)
gopl_ftr_s --> varchar(19)
r_gopl_area_name --> 'county'
gopl_ftr_name --> 'Kern'
(* Example query to retrieve the state and county names for a well
based on the above footprint. NOTE: It is usually wiser to retrieve
the state and county names separately since the following query will
not return any data if either the state or county name is missing.
select
gf1.gopl_ftr_name STATE_NAME,
gf2.gopl_ftr_name COUNTY_NAME
from
GOPL_FTR gf2,
WELL_SFTR_ROLE wsr2,
GOPL_FTR gf1,
WELL_SFTR_ROLE wsr1,
WELL wl,
WELL_ALIAS wal
where
wal.id = '0402970925' and
wal.r_naming_system_kd = '10 digit API' and
wl.well_s = wal.well_s and
wsr1.well_s = wl.well_s and
wsr1.r_well_sftr_rle_kd = 'is located within' and
wsr1.earth_sftr_t = 'GOPL_FTR' and
wsr1.earth_sftr_s = gf1.gopl_ftr_s and
gf1.r_gopl_area_name = 'state' and
wsr2.well_s = wl.well_s and
wsr2.r_well_sftr_rle_kd = 'is located within' and
wsr2.earth_sftr_t = 'GOPL_FTR' and
wsr2.earth_sftr_s = gf2.gopl_ftr_s and
gf2.r_gopl_area_name = 'county'
*)
(* Wellbore purpose *) wal = WELL_ALIAS well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) wb = WELLBORE wellbore_s --> varchar(19) well_s --> @wl.well_s wellbore_id --> '00' r_naming_system_kd --> '2 digit sidetrack' r_existence_kd_nm --> 'actual' r_wellbore_purp_kd --> 'development'
(* Wellbore status *) wal = WELL_ALIAS well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) wb = WELLBORE wellbore_s --> varchar(19) well_s --> @wl.well_s wellbore_id --> '00' r_naming_system_kd --> '2 digit sidetrack' r_existence_kd_nm --> 'actual' current_status --> 'active' stat = WELLBORE_STATUS wellbore_status_s --> varchar(19) wellbore_s --> @wb.wellbore_s r_wellbore_sta_kd --> 'active'
(* Wellbore directional surveys *) wal = WELL_ALIAS well_s --> @wl.well_s id --> '1004115R' r_naming_system_kd --> 'X-section well name' wl = WELL well_s --> varchar(19) wb = WELLBORE wellbore_s --> varchar(19) well_s --> @wl.well_s wds = WB_DIR_SURVEY wb_dir_survey_s --> varchar(19) wellbore_s --> @wb.wellbore_s end_time --> 05-JAN-96 r_existence_kd_nm --> 'actual' (*------------------------ 1-d measured depth frame ----------------------*) edg1d = P_GEOM_1D_EDG p_geom_1d_edg_s --> varchar(19) entity_type_nm --> 'PTY_GEOMETRY_COMPLEX_1D_EDGE' object_s --> @wb.wellbore_s object_t --> 'WELLBORE' activity_s --> @wds.wb_dir_survey_s activity_t --> 'WB_DIR_SURVEY' coordinate_sys_id --> 'measured depth' vertex_s --> @kbref.general_wb_pt_s vertex_t --> 'GENERAL_WB_PT' data_value --> 'FRAME' sdt1 = SUPP_DATA_TYPE sk --> varchar(19) owner_sk --> @edg1d.p_geom_1d_edg_s owner_tn --> 'P_GEOM_1D_EDG' owner_col --> 'DATA_VALUE' vertex_sk --> @gwp.general_wb_pt_s vertex_tn --> 'GENERAL_WB_PT' lf1 = DAE_LEAF (*-------- measured depth leaf --------*) dae_leaf_s --> varchar(19) frame_sk --> @sdt1.sk pop_count --> 25 prop_unit_ac --> 'ftUS' rec_key --> varchar(30) ___________________________________________________________________________________________________ bh1 = BLOB_ HEADER (* BDAL controlled tables *) | recog_key --> @lf1.rec_key | data_key --> number | blob_table --> 'blob_table' | bt = BLOB_TABLE | data_key --> @bh1.data_key | chunk --> 0 | blob_length --> 30196 | blob --> long raw !numerical array of depth values | ___________________________________________________________________________________________________| (*------------------- 3-d tvd, delta X, delta Y frame --------------------*) edg3d = P_GEOM_3D_EDG p_geom_1d_edg_s --> varchar(19) object_s --> @wb.wellbore_s object_t --> 'WELLBORE' activity_s --> @wds.wb_dir_survey_s activity_t --> 'WB_DIR_SURVEY' represent_s --> @edg1d.p_geom_1d_edg_s represent_t --> 'P_GEOM_1D_EDG' coordinate_sys_id --> 'local X-Y-TVD coordinate system' vertex_s --> @kbref.general_wb_pt_s vertex_t --> 'GENERAL_WB_PT' data_value --> 'FRAME' sdt2 = SUPP_DATA_TYPE sk --> varchar(19) owner_sk --> @edg3d.p_geom_1d_edg_s owner_tn --> 'P_GEOM_3D_EDG' owner_col --> 'DATA_VALUE' vertex_sk --> @gwp.general_wb_pt_s vertex_tn --> 'GENERAL_WB_PT' lf2 = DAE_LEAF (*------ true vertical depth leaf --------*) dae_leaf_s --> varchar(19) frame_sk --> @sdt2.sk pop_count --> 25 prop_unit_ac --> 'ftUS' rec_key --> varchar(30) ___________________________________________________________________________________________________ bh2 = BLOB_HEADER (* BDAL controlled tables *) | recog_key --> @lf2.rec_key | data_key --> number | blob_table --> 'blob_table' | bt = BLOB_TABLE | data_key --> @bh2.data_key | chunk --> 0 | blob_length --> 30196 | blob --> long raw !numerical array of depth values | ___________________________________________________________________________________________________| lf3 = DAE_LEAF (*---------- delta X leaf ----------*) dae_leaf_s --> varchar(19) frame_sk --> @sdt2.sk pop_count --> 25 prop_unit_ac --> 'ftUS' rec_key --> varchar(30) ___________________________________________________________________________________________________ bh3 = BLOB_ HEADER (* BDAL controlled tables *) | recog_key --> @lf3.rec_key | data_key --> number | blob_table --> 'blob_table' | bt = BLOB_TABLE | data_key --> @bh3.data_key | chunk --> 0 | blob_length --> 30196 | blob --> long raw !numerical array of delta x values | ___________________________________________________________________________________________________| lf4 = DAE_LEAF (*---------- delta Y leaf ----------*) dae_leaf_s --> varchar(19) frame_sk --> @sdt2.sk pop_count --> 25 prop_unit_ac --> 'ftUS' rec_key --> varchar(30) ___________________________________________________________________________________________________ bh4 = BLOB_ HEADER (* BDAL controlled tables *) | recog_key --> @lf4.rec_key | data_key --> number | blob_table --> 'blob_table' | bt = BLOB_TABLE | data_key --> @bh4.data_key | chunk --> 0 | blob_length --> 30196 | blob --> long raw !numerical array of delta y values | ___________________________________________________________________________________________________| kbref = GENERAL_WB_PT general_wb_pt_s --> varchar(19) r_wellbore_pt_name --> 'kelly bushing' wellbore_s --> @wb.wellbore_s
(* Footprint on Epicentre V2.0 for an evenly-sampled temperature log *)
well = WELL
identifier --> 'theWellsName'
ref_naming_system --> @Geographix_Well_Id
ref_existence_kind --> @PRV_actual
wellbore <-- @wb
wal = WELL_ALIAS
identifier --> 'theWellsName'
ref_naming_system --> @Geographix_Well_Id
well --> @well
wb = WELLBORE
identifier --> '00'
ref_existence_kind --> @PRV_actual
well --> @well
activity <-- @wlp
create_wellbore_position <-- @intv
well_log_trace <-- @wlt
intv = WELLBORE_INTERVAL ! The part of the wellbore that was logged
identifier --> 'theWellsName_wbid_date'
wellbore --> @wb
wellbore_activity <-- @wlp
pty_geometry_1D_edge <-- @pass_depth_one_foot_index
wlp = WIRELINE_LOGGING_PASS ! The activity of recording log curves
ref_existence_kind --> @PRV_actual
name --> 'theWellsName_wbid_date'
start_time --> ndt_date_tod
position_in_wellbore --> @intv
wellbore --> @wb
process_data <-- @pg
well_log_trace <-- @wlt
pg = PTY_GEOMETRY_COMPLEX_1D_EDGE ! log's depth values
edge --> @intv
activity --> @wlp
grid_element_behavior <-- (@wlt,...)
data_value
md_geometry = geometry_frame
detailed_type --> 'FT_LINE'
descriptor --> @md_index
leaf_frame --> @md_leaf
grid_or_mesh --> @log_grid_1d
coordinate_system --> @PRV_mdcs
vertex --> @ground_level
md_index = descriptor
dimension --> 'INDEX-I'
lower_bound --> 1
count --> 711
md_leaf = leaf_frame
ref_property_kind --> @PRV_measured_depth
ref_unit_of_measure --> @PRV_ftUS
data_type --> 'DAE_C_FLOAT'
data_values --> ( 50, 51, ..., 761) !array of depth values
wlt = WELL_LOG_TRACE ! the log curve's actual data values
identifier --> 'TEMP - 11-DEC-94'
ref_well_log_trace --> @PRV_temp_log
wireline_logging_pass --> @wlp
wellbore --> @wb
grid_geometry_behavior --> @pg
trace_value
temp_frame = property_frame
detailed_type --> 'EGRID_1DNODE'
descriptor --> @temp_index
leaf_frame --> @temp_leaf
grid_or_mesh --> @log_grid_1d
temp_index = descriptor
dimension --> 'INDEX_I'
lower_bound --> 1
count --> 711
temp_leaf = Leaf_Frame
ref_property_kind --> @PRV_temperature
ref_unit_of_measure --> @PRV_degF
data_type --> 'DAE_C_FLOAT'
data_values --> (118.4,118.8,125.4,...) !array of temp. values
(* reference entities *)
log_grid_1d = GRID_1D_PARAMETRIC
name --> '50000 point'
point_count --> 50000
description --> 'A 50000 point grid.'
PRV_actual = REF_EXISTENCE_KIND
name --> 'actual'
source --> @POSC
PRV_mdcs = LOCAL_SPATIAL_COORDINATE_SYSTEM
identifier --> 'measured depth'
source --> @POSC
PRV_measured_depth = REF_PROPERTY_KIND
ref_property_type --> @PRV_rqp_md
source --> @POSC
PRV_rqp_md = REF_QUANTITY_PROPERTY
name --> 'measured depth'
source --> @POSC
PRV_temp_log = REF_WELL_LOG_TRACE
kind --> 'temperature'
source --> @POSC
xsect_type = REF_CODE_ALIAS
identifier --> 'QC64'
ref_naming_system --> @xsect
standard_code --> @PRV_temp_log
source --> @Texaco
xsect = REF_NAMING_SYSTEM
kind --> 'Texaco Cross Section System'
description --> 'The mainframe system for storing well logs.'
source --> @Texaco
PRV_temperature = REF_PROPERTY_KIND
ref_property_type --> @PRV_rqp_temp
source --> @POSC
PRV_rqp_temp = REF_QUANTITY_PROPERTY
name --> 'temperature'
source --> @POSC
(* Footprint on Epicentre V2.0 Relational Implementation for an evenly- sampled temperature log *) well = WELL well_s --> varchar(19) well_id --> 'JS83-4' r_naming_system_kd --> 'Geographix Well Id' r_existence_kd_nm --> 'actual' wal = WELL_ALIAS well_alias_s --> varchar(19) id --> 'JS83-4' r_naming_system_kd --> 'Geographix Well Id' well_s --> @well.well_s wb = WELLBORE wellbore_s --> varchar(19) wellbore_id --> '00' r_existence_kd_nm --> 'actual' well_s --> @well.well_s intv = WELLBORE_INTV wellbore_intv_s --> varchar(19) emodel_object_id --> 'JS83-4_00_05-30-95' wellbore_s --> @wb.wellbore_s wlp = WRLN_LOG_PASS wrln_log_pass_s --> varchar(19) wellbore_s --> @wb.wellbore_s r_existence_kd_nm --> 'actual' start_time --> '30-MAY-95' activity_name --> 'JS83-4_00_05-30-95' wbx = WB_ACT_POS_X wb_act_posc_x_s --> varchar(19) wellbore_act_s --> @wlp.wrln_log_pass_s wellbore_act_t --> 'WRLN_LOG_PASS' position_in_wb_s --> @intv.wellbore_intv_s position_in_wb_t --> 'WELLBORE_INTV' pg = P_GEOM_1D_EDG p_geom_1d_edg_s --> varchar(19) object_s --> @intv.wellbore_intv_s object_t --> 'WELLBORE_INTV' activity_s --> @wlp.wrln_log_pass_s activity_t --> 'WRLN_LOG_PASS' data_value --> 'FRAME' entity_type_nm --> 'PTY_GEOMETRY_COMPLEX_1D_EDGE' sdt1 = SUPP_DATA_TYPE sk --> varchar(19) owner_sk --> @pg.p_geom_1d_edg_s owner_tn --> 'P_GEOM_1D_EDG' owner_col --> 'DATA_VALUE' vertex_sk --> @gwp.general_wb_pt_s vertex_tn --> 'GENERAL_WB_PT' lf1 = DAE_LEAF dae_leaf_s --> varchar(19) frame_sk --> @sdt1.sk pop_count --> 7549 prop_unit_ac --> 'ftUS' rec_key --> varchar(30) ___________________________________________________________________________________________________ bh1 = BLOB_ HEADER (* BDAL controlled tables *) | recog_key --> @lf1.rec_key | data_key --> number | blob_table --> 'blob_table' | bt = BLOB_TABLE | data_key --> @bh1.data_key | chunk --> 0 | blob_length --> 30196 | blob --> long raw !numerical array of depth values | ___________________________________________________________________________________________________| wlt = WELL_LOG_TRACE well_log_trace_s --> varchar(19) r_well_log_trc_kd --> 'temperature' wrln_log_pass_s --> @wlp.wrln_log_pass_s grid_geom_bhv_s --> @pg.p_geom_1d_edge_s grid_geom_bhv_t --> 'P_GEOM_1D_EDG' wellbore_s --> @wb.wellbore_s trace_value --> 'FRAME' sdt2 = SUPP_DATA_TYPE sk --> varchar(19) owner_sk --> @wlt.well_log_trace_s owner_tn --> 'WELL_LOG_TRACE' owner_col --> 'TRACE_VALUE' lf2 = DAE_LEAF dae_leaf_s --> varchar(19) frame_sk --> @sdt2.sk pop_count --> 7549 prop_unit_ac --> 'degF' rec_key --> varchar(30) ___________________________________________________________________________________________________ bh2 = BLOB_ HEADER (* BDAL controlled tables *) | recog_key --> @lf2.rec_key | data_key --> number | blob_table --> 'log_blobs' | lb = LOG_BLOBS | data_key --> @bh2.data_key | chunk --> 0 | blob_length --> 30196 | blob --> long raw !numerical array of curve values | ___________________________________________________________________________________________________| gwp = GENERAL_WB_PT general_wb_pt_s --> varchar(19) emodel_object_id --> 'JS83-4_00_KB' description --> 'KB Datum' wellbore_s --> @wb.wellbore_s wb_cmpn_fcl_s --> @wbr.wellbore_ref_s wb_cmpn_fcl_t --> 'WELLBORE_REF' wbr = WELLBORE_REF wellbore_ref_s --> varchar(19) wb_cmpn_fcl_id --> 'JS83-4_00_KB' wellbore_s --> @wb.wellbore_s r_existence_kd_nm --> 'actual' entity_type_nm --> 'KELLY_BUSHING_REFERENCE' (* Coordinate system and axis definition for measured depth *) csys = COORDINATE_SYS coordinate_sys_s --> varchar(19) entity_type_nm --> 'LOCAL_SPATIAL_COORDINATE_SYSTEM' coordinate_sys_id --> 'measured depth' r_cord_sys_cstr_nm --> 'measured depth system' source --> 'Texaco Inc.' mdaxis = cord_sys_axis coordinate_sys_s --> varchar(19) entity_type_nm --> 'MEASURED_DEPTH_SYSTEM_AXIS' coordinate_sys_id --> 'measured depth' r_property_type_nm --> 'measured depth'
(* Formation top picks *) wal = WELL_ALIAS well_alias_s --> varchar(19) well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) wb = WELLBORE wellbore_s --> varchar(19) well_s --> @wl.well_s wellbore_id --> '00' bs = BSASC bsasc_s --> varchar(19) bsasc_id --> 'Jim Eacmen' kind --> 'person' gsi = GEOSCIENCE_NTRP geoscience_ntrp_s --> varchar(19) activity_name --> 'formation boundary picking' typical_act_name --> 'wellbore picking' r_existence_kd_nm --> 'actual' analyst --> 'Jim Eacmen' rock = ROCK_FEATURE rock_feature_s --> varchar(19) entity_type_nm --> 'LITHOSTRATIGRAPHIC_FORMATION' rock_feature_id --> 'sand A' r_naming_system_kd --> 'arbitrary' r_existence_kd_nm --> 'actual' x = ROCK_FTR_BND_X rock_ftr_bnd_x_s --> varchar(19) feature_bnd_s --> @fbnd.feature_bnd_s rock_feature_s --> @rock.rock_feature_s fbnd = FEATURE_BND feature_bnd_s --> varchar(19) entity_type_nm --> 'LITHOSTRATIGRAPHIC_MARKER' boundary_type_kind --> 'stratigraphic top' r_naming_system_kd --> 'arbitrary' feature_bnd_id --> 'top of sand A' gwbpt = GENERAL_WB_PT general_wb_pt_s --> varchar(19) wellbore_s --> @wb.wellbore_s r_wellbore_pt_name --> 'geologic pick' geologic_ftr_s --> @fbnd.feature_bnd_s geologic_ftr_t --> 'FEATURE_BND' geoscience_ntrp_s --> @gsi.geoscience_ntrp_s bsasc_source --> 'Texaco, Inc.' loc = P_LOCATION_1D p_location_1d_s --> varchar(19) object_t --> 'GENERAL_WB_PT' object_s --> @gwbpt.general_wb_pt_s data_cord_sys --> 'measured depth' data_offset_s --> @glref.general_wb_pt_s data_offset_t --> 'GENERAL_WB_PT' data_frst_ord --> 807.00 data_frst_ord_u --> 'ftUS' glref = GENERAL_WB_PT general_wb_pt_s --> varchar(19) r_wellbore_pt_name --> 'ground level' wellbore_s --> @wb.wellbore_s
(*
Well perforations
*)
wal = WELL_ALIAS
well_s --> @wl.well_s
id --> '0402970925'
r_naming_system_kd --> '10 digit API'
wl = WELL
well_s --> varchar(19)
wb = WELLBORE
wellbore_s --> varchar(19)
well_s --> @wl.well_s
sh = SHOOT_PERF
shoot_perf_s --> varchar(19)
end_time --> 05-JAN-96
wellbore_s --> @wb.wellbore_s
r_existence_kd_nm --> 'actual'
perf = PERFORATION_SET
perforation_set_s --> varchar(19)
wellbore_s --> @wb.wellbore_s
typical_fcl_name --> 'casing perforation'
shoot_perf_s --> @sh.shoot_perf_s
r_existence_kd_nm --> 'actual'
bsasc_source --> 'Texaco BDO warehouse'
intv = WELLBORE_INTV
wellbore_intv_s --> varchar(19)
wellbore_s --> @wb.wellbore_s
wb_cmpn_fcl_s --> @perf.perforation_set_s
wb_cmpn_fcl_t --> 'PERFORATION_SET'
(* Note: selected attributes top_depth and bottom_depth not
loaded because coordinate system and reference vertex
attributes were not also selected into this relational table *)
edg = P_GEOM_1D_EDG
p_geom_1d_edg_s --> varchar(19)
entity_type_nm --> 'PTY_GEOMETRY_SIMPLE_1D_EDGE'
object_s --> @intv.wellbore_intv_s
object_t --> 'WELLBORE_INTV'
activity_s --> @sh.shoot_perf_s
activity_t --> 'SHOOT_PERF'
coordinate_sys_id --> 'measured depth'
vertex_s --> @glref.general_wb_pt_s
vertex_t --> 'GENERAL_WB_PT'
minimum_point --> 1542.6
minimum_point_u --> 'ftUS'
maximum_point --> 1573.4
maximum_point_u --> 'ftUS'
glref = GENERAL_WB_PT
general_wb_pt_s --> varchar(19)
r_wellbore_pt_name --> 'ground level'
wellbore_s --> @wb.wellbore_s
(* Production data *) wal = WELL_ALIAS well_alias_s --> varchar(19) well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) cmp = WELL_COMPLETION well_completion_s --> varchar(19) well_s --> @wl.well_s well_completion_id --> '0001' r_existence_kd_nm --> 'actual' prd = PFNU_PD_PFM_RPT pfnu_pd_pfm_rpt_s --> varchar(19) pfnu_t --> 'WELL_COMPLETION' pfnu_s --> @cmp.well_completion_s r_inj_or_prod_kind --> 'production' r_transient_pd_nm --> 'monthly' prod_reporting_s --> @rpt.prod_reporting_s start_time --> 01-DEC-95 gas_volume --> 0.00 oil_volume --> 227.94 water_volume --> 681.00 port_time --> 30.0 bsasc_source --> 'POLIS' rpt = PROD_REPORTING prod_reporting_s --> varchar(19) activity_name --> 'report allocated volumes'
(* Injection data *) wal = WELL_ALIAS well_alias_s --> varchar(19) well_s --> @wl.well_s id --> '0402970925' r_naming_system_kd --> '10 digit API' wl = WELL well_s --> varchar(19) cmp = WELL_COMPLETION well_completion_s --> varchar(19) well_s --> @wl.well_s well_completion_id --> '0001' r_existence_kd_nm --> 'actual' prd = PFNU_PD_PFM_RPT pfnu_pd_pfm_rpt_s --> varchar(19) pfnu_t --> 'WELL_COMPLETION' pfnu_s --> @cmp.well_completion_s r_inj_or_prod_kind --> 'injection' r_transient_pd_nm --> 'monthly' prod_reporting_s --> @rpt.prod_reporting_s start_time --> 01-DEC-95 gas_volume --> 0.00 oil_volume --> 227.94 water_volume --> 681.00 port_time --> 30.0 bsasc_source --> 'POLIS' rpt = PROD_REPORTING prod_reporting_s --> varchar(19) activity_name --> 'report allocated volumes' (* Pressure reporting does not follow Epicentre logical model *) pr = P_PRESSURE p_pressure_s --> varchar(19) object_t --> 'PFNU_PD_PFM_RPT' object_s --> @prd.pfnu_pd_pfm_rpt_s activity_t --> 'OTHER_ACTIVITY' activity_s --> @act.other_activity_s data_value --> 25.3 act = OTHER_ACTIVITY other_activity_s --> varchar(19) activity_name --> 'measure average injection pressure'
(* Township/Range/Section boundaries This example shows how the coordinates are stored for this section boundary: Twn 31S Rng 22E Sec 35 1 35.1792984 -119.5882568 2 35.1947097 -119.5883178 3 35.1946948 -119.5794257 4 35.1946792 -119.5705337 5 35.1874260 -119.5703839 6 35.1802711 -119.5702362 7 35.1797848 -119.5792465 *)
SCHEMA_DATA Epicentre_V2.0
lsa = CONGRESSIONAL_LEGAL_SURVEY_AREA
identifier --> 'T31S R22E S35'
township --> 31
ref_north_or_south --> @south
range --> 22
ref_east_or_west --> @east
township_range_section --> 35
principal_meridian --> 'Gila and Salt River'
bounding_ring --> @lsb
south = REF_NORTH_OR_SOUTH
kind --> 'south'
east = REF_EAST_OR_WEST
name --> 'east'
lsb = LEGAL_SURVEY_BOUNDARY
identifier --> 'T31S R22E S35'
face <-- @lsa
pty_geometry_2d_ring <-- @pg
pg = PTY_GEOMETRY_2D_RING
ring --> @lsb
activity --> @dl
data_value
gfm = geometry_frame {
detailed_type(M) --> 'FT_LINE'
descriptor --> @dsc
grid_or_mesh --> @grd
coordinate_system --> #NAD27
leaf_frame --> (@lf1,@lf2)
dsc = descriptor
dimension -->'INDEX-I'
lower_bound --> 1
count --> 7 !number of points in the polygon
increment --> 1
lf1 = leaf_frame
ref_property_type --> @rptt
ref_unit_of_measure --> @uom
data_type --> 'DAE_C_DOUBLE'
data_values --> (35.1792984, 35.1947097, 35.1946948,
35.1946792, 35.1874260, 35.1802711,
35.1797848)
lf2 = leaf_frame
ref_property_type --> @rptn
ref_unit_of_measure --> @uom
data_type --> 'DAE_C_DOUBLE'
data_values --> (-119.5882568, -119.5883178, -119.5794257,
-119.5705337, -119.5703839, -119.5702362,
-119.5792465)
grd = GRID_1D_PARAMETRIC
name -->'7 point polygon grid'
description -->'Grid for polygons with 7 points'
point_count --> 7 !must equal number of points in the pgon
connected --> TRUE !indicates a polygon instead of a line
rptt = REF_QUANTITY_PROPERTY
name --> 'latitude'
ref_quantity_type --> @rqt
rptn = REF_QUANTITY_PROPERTY
name --> 'longitude'
ref_quantity_type --> @rqt
rqt = REF_QUANTITY_TYPE
name --> 'plane angle'
uom = REF_CUSTOMARY_UNIT_OF_MEASURE
acronym --> 'dega'
name --> 'degree of an angle'
(*
The DAE facility will populate the entities supporting the following
read-only view as the PTY_GEOMETRY_2D_RING geometry frames are loaded.
Note that to get the bounding box coordinates in DAE_LEAF_FRAME the function
daeUpdateLeafStatistics must be invoked after the frame has been loaded.
*)
dfe = DAE_FRAME
attribute_name -->'DATA_VALUE'
e_type -->'FT_LINE'
f_type -->'FT_GEOMETRY'
instance --> @pg
coordinate_system --> #NAD27
grid --> @grd
members --> (@lf1,@lf2)
lf1 = DAE_LEAF_FRAME
leaf_ordinal --> 1
max_value --> -119.5702362 !right side of pgon's bounding box
min_value --> -119.5883178 !left side of pgon's bounding box
lf2 = DAE_LEAF_FRAME
leaf_ordinal --> 2
max_value --> 35.1947097 !top of pgon's bounding box
min_value --> 35.1792984 !bottom of pgon's bounding box
lsa = CNGRS_LSA ! The surveyed Section
cngrs_lsa_s --> varchar(19)
lsa_id --> 'T31S R22E S35'
township --> 31
r_nrth_or_south_kd --> 'south'
range --> 22
r_east_or_west --> 'east'
township_rng_sec --> 35
fbx = FACE_BND_RING_X ! Many-to-many relationship btw sections and boundaries
face_t --> 'CNGRS_LSA'
face_s --> @lsa.cngrs_lsa_s
ring_t --> 'LEGAL_SRVY_BND'
ring_s --> @lsb.legal_srvy_bnd_s
lsb = LEGAL_SRVY_BND ! The section's boundary
legal_srvy_bnd_s --> varchar(19)
legal_srvy_bnd_id --> 'T31S R22E S35'
pg = P_GEOM_2D_RING ! The boundary's geometry
p_geom_2d_ring_s --> varchar(19)
object_t --> 'LEGAL_SRVY_BND'
object_s --> @lsb.legal_srvy_bnd_s
fm = DAE_FRAME ! Overall geometry header
dae_frame_s --> varchar(19)
instance_t --> 'P_GEOM_2D_RING'
instance_s --> @pg.p_geom_2d_ring_s
coordinate_sys_id --> 'NAD27'
lf1 = DAE_LEAF ! Individual header for the longitude array
dae_leaf_s --> varchar(19)
frame_sk --> @fm.dae_frame_s
leaf_ordinal --> 1
rec_key --> varchar(40)
min_value --> -119.5883178
max_value --> -119.5702362
lf2 = DAE_LEAF ! Individual header for the latitude array
dae_leaf_s --> varchar(19)
frame_sk --> @fm.dae_frame_s
leaf_ordinal --> 2
rec_key --> varchar(40)
min_value --> 35.1792984
max_value --> 35.1947097
___________________________________________________________________________________________________
ct1 = COLUMN_VALUE_TABLE ! The longitude values (* BDAL controlled tables *) |
rec_key --> @lf1.rec_key |
nodenum --> 1 |
(* there are six additional rows with nodenum: |
2, 3, 4, |
5, 6, 7 *) |
value --> -119.5882568 !longitude |
(* the six additional rows have value: |
-119.5883178,-119.5794257,-119.5705337, |
-119.5703839,-119.5702362,-119.5792465 *) |
ct2 = COLUMN_VALUE_TABLE ! The latitude values |
rec_key --> @lf2.rec_key |
nodenum --> 1 |
(* there are six additional rows with nodenum: |
2, 3, 4, |
5, 6, 7 *) |
value --> 35.1792984 !latitude |
(* the six additional rows have value: |
35.1947097, 35.1946948, 35.1946792, |
35.1874260, 35.1802711, 35.1797848 *) |
___________________________________________________________________________________________________|
(* Lease boundaries This example shows how the coordinates are stored for this lease boundary: Lease G -312267 A:A01 1 35.1792984 -119.5882568 2 35.1947097 -119.5883178 3 35.1946948 -119.5794257 4 35.1946792 -119.5705337 5 35.1874260 -119.5703839 6 35.1802711 -119.5702362 7 35.1797848 -119.5792465 *)
SCHEMA_DATA Epicentre_V2.0
lpp = LAND_PROPERTY_PARCEL
identifier --> 'G -312267 A:A01'
bounding_ring --> @lpb
lpb = LAND_PROPERTY_BOUNDARY
identifier --> 'G -312267 A:A01'
face <-- @lpp
pty_geometry_2d_ring <-- @pg
pg = PTY_GEOMETRY_2D_RING
ring --> @lpb
activity --> @dl
data_value
gfm = geometry_frame {
detailed_type(M) --> 'FT_LINE'
descriptor --> @dsc
grid_or_mesh --> @grd
coordinate_system --> #NAD27
leaf_frame --> (@lf1,@lf2)
dsc = descriptor
dimension -->'INDEX-I'
lower_bound --> 1
count --> 7 !number of points in the polygon
increment --> 1
lf1 = leaf_frame
ref_property_type --> @rptt
ref_unit_of_measure --> @uom
data_type --> 'DAE_C_DOUBLE'
data_values --> (35.1792984, 35.1947097, 35.1946948,
35.1946792, 35.1874260, 35.1802711,
35.1797848)
lf2 = leaf_frame
ref_property_type --> @rptn
ref_unit_of_measure --> @uom
data_type --> 'DAE_C_DOUBLE'
data_values --> (-119.5882568, -119.5883178, -119.5794257,
-119.5705337, -119.5703839, -119.5702362,
-119.5792465)
grd = GRID_1D_PARAMETRIC
name -->'7 point polygon grid'
description -->'Grid for polygons with 7 points'
point_count --> 7 !must equal number of points in the pgon
connected --> TRUE !indicates a polygon instead of a line
rptt = REF_QUANTITY_PROPERTY
name --> 'latitude'
ref_quantity_type --> @rqt
rptn = REF_QUANTITY_PROPERTY
name --> 'longitude'
ref_quantity_type --> @rqt
rqt = REF_QUANTITY_TYPE
name --> 'plane angle'
uom = REF_CUSTOMARY_UNIT_OF_MEASURE
acronym --> 'dega'
name --> 'degree of an angle'
(*
The DAE facility will populate the entities supporting the following
read-only view as the PTY_GEOMETRY_2D_RING geometry frames are loaded.
Note that to get the bounding box coordinates in DAE_LEAF_FRAME the function
daeUpdateLeafStatistics must be invoked after the frame has been loaded.
*)
dfe = DAE_FRAME
attribute_name -->'DATA_VALUE'
e_type -->'FT_LINE'
f_type -->'FT_GEOMETRY'
instance --> @pg
coordinate_system --> #NAD27
grid --> @grd
members --> (@lf1,@lf2)
lf1 = DAE_LEAF_FRAME
leaf_ordinal --> 1
max_value --> -119.5702362 !right side of pgon's bounding box
min_value --> -119.5883178 !left side of pgon's bounding box
lf2 = DAE_LEAF_FRAME
leaf_ordinal --> 2
max_value --> 35.1947097 !top of pgon's bounding box
min_value --> 35.1792984!bottom of pgon's bounding box
lpp = LAND_PPRC ! The Lease
land_pprc_s --> varchar(19)
land_pprc_id --> 'G -312267 A:A01' ! Lease Name
fbx = FACE_BND_RING_X ! Many-to-many relationship btw leases and boundaries
face_t --> 'LAND_PPRC'
face_s --> @lpp.land_pprc_s
ring_t --> 'LAND_PTY_BND'
ring_s --> @lpb.land_pty_bnd_s
lpb = LAND_PTY_BND ! The lease's boundary
land_pty_bnd_s --> varchar(19)
land_pty_bnd_id --> 'G -312267 A:A01'
pg = P_GEOM_2D_RING ! The boundary's geometry
p_geom_2d_ring_s --> varchar(19)
object_t --> 'LAND_PTY_BND'
object_s --> @lpb.land_pty_bnd_s
fm = DAE_FRAME ! Overall geometry header
dae_frame_s --> varchar(19)
instance_t --> 'P_GEOM_2D_RING'
instance_s --> @pg.p_geom_2d_ring_s
coordinate_sys_id --> 'NAD27'
lf1 = DAE_LEAF ! Individual header for the longitude array
dae_leaf_s --> varchar(19)
frame_sk --> @fm.dae_frame_s
leaf_ordinal --> 1
rec_key --> varchar(40)
min_value --> -119.5883178
max_value --> -119.5702362
lf2 = DAE_LEAF ! Individual header for the latitude array
dae_leaf_s --> varchar(19)
frame_sk --> @fm.dae_frame_s
leaf_ordinal --> 2
rec_key --> varchar(40)
min_value --> 35.1792984
max_value --> 35.1947097
___________________________________________________________________________________________________
ct1 = COLUMN_VALUE_TABLE ! The longitude values (* BDAL controlled tables *) |
rec_key --> @lf1.rec_key |
nodenum --> 1 |
(* there are six additional rows with nodenum: |
2, 3, 4, |
5, 6, 7 *) |
value --> -119.5882568 !longitude |
(* the six additional rows have value: |
-119.5883178,-119.5794257,-119.5705337, |
-119.5703839,-119.5702362,-119.5792465 *) |
ct2 = COLUMN_VALUE_TABLE ! The latitude values |
rec_key --> @lf2.rec_key |
nodenum --> 1 |
(* there are six additional rows with nodenum: |
2, 3, 4, |
5, 6, 7 *) |
value --> 35.1792984 !latitude |
(* the six additional rows have value: |
35.1947097, 35.1946948, 35.1946792, |
35.1874260, 35.1802711, 35.1797848 *) |
___________________________________________________________________________________________________|