|
POSC Specifications Version 2.2 |
Getting Started loadlist for refLoadLevelOne |
load_list is a file that contains the files to be loaded, and the order in which they are to be loaded. For the Stratton data, well information (including picks), the load_list file is shown below. Some of these include links to the load files.
ref_other_earth_point
general_earth_surface_point
general_coordinate_system_axis
vertical time system axis
local_spatial_coordinate_system
well
wellbore
well_surface_point
pty_location_2d
well_surface_feature_role
kelly_bushing_reference
general_wellbore_point
pty_location_1d
measured_depth_system_axis
local_spatial_coordinate_system_2
general_wellbore_point_2
pty_location_1d_2
well Data taken from Stratton table 2. use g_well_ref 3 identifier ref_existence_kind ref_naming_system ref_existence_kind.name ref_naming_system.kind M M O NDT NAME NDT NAME NDT NAME A40 A40 A40 ENDHEADER Stratton #1 actual local field Stratton #2 actual local field Stratton #3 actual local field Stratton #4 actual local field Stratton #5 actual local field Stratton #6 actual local field Stratton #7 actual local field Stratton #8 actual local field Stratton #9 actual local field Stratton #10 actual local field Stratton #11 actual local field Stratton #12 actual local field Stratton #13 actual local field Stratton #14 actual local field Stratton #15 actual local field Stratton #16 actual local field Stratton #17 actual local field Stratton #18 actual local field Stratton #19 actual local field Stratton #20 actual local field Stratton #21 actual local field
wellbore Data taken from Stratton table2. Use g_wellbore_ref 4 identifier well ref_existence_kind ref_naming_system well.identifier ref_existence_kind.name ref_naming_system.kind M M M O NDT NAME NDT NAME NDT NAME NDT NAME A40 A40 A40 A40 ENDHEADER Stratton #1 Stratton #1 actual local field Stratton #2 Stratton #2 actual local field Stratton #3 Stratton #3 actual local field Stratton #4 Stratton #4 actual local field Stratton #5 Stratton #5 actual local field Stratton #6 Stratton #6 actual local field Stratton #7 Stratton #7 actual local field Stratton #8 Stratton #8 actual local field Stratton #9 Stratton #9 actual local field Stratton #10 Stratton #10 actual local field Stratton #11 Stratton #11 actual local field Stratton #12 Stratton #12 actual local field Stratton #13 Stratton #13 actual local field Stratton #14 Stratton #14 actual local field Stratton #15 Stratton #15 actual local field Stratton #16 Stratton #16 actual local field Stratton #17 Stratton #17 actual local field Stratton #18 Stratton #18 actual local field Stratton #19 Stratton #19 actual local field Stratton #20 Stratton #20 actual local field Stratton #21 Stratton #21 actual local field
filename = general_wellbore_point
general_wellbore_point Data taken from Stratton table2. Use g_kbpt_ref 4 identifier wellbore ref_wellbore_point wellbore_component_facility wellbore.identifier ref_wellbore_point.name kelly_bushing_reference.identifier O M O O NDT NAME NDT NAME NDT NAME NDT NAME A40 A40 A40 A40 ENDHEADER kelly bushing for Stratton #1 Stratton #1 kelly bushing kelly bushing for Stratton #1 kelly bushing for Stratton #2 Stratton #2 kelly bushing kelly bushing for Stratton #2 kelly bushing for Stratton #3 Stratton #3 kelly bushing kelly bushing for Stratton #3 kelly bushing for Stratton #4 Stratton #4 kelly bushing kelly bushing for Stratton #4 kelly bushing for Stratton #5 Stratton #5 kelly bushing kelly bushing for Stratton #5 kelly bushing for Stratton #6 Stratton #6 kelly bushing kelly bushing for Stratton #6 kelly bushing for Stratton #7 Stratton #7 kelly bushing kelly bushing for Stratton #7 kelly bushing for Stratton #8 Stratton #8 kelly bushing kelly bushing for Stratton #8 kelly bushing for Stratton #9 Stratton #9 kelly bushing kelly bushing for Stratton #9 kelly bushing for Stratton #10 Stratton #10 kelly bushing kelly bushing for Stratton #10 kelly bushing for Stratton #11 Stratton #11 kelly bushing kelly bushing for Stratton #11 kelly bushing for Stratton #12 Stratton #12 kelly bushing kelly bushing for Stratton #12 kelly bushing for Stratton #13 Stratton #13 kelly bushing kelly bushing for Stratton #13 kelly bushing for Stratton #14 Stratton #14 kelly bushing kelly bushing for Stratton #14 kelly bushing for Stratton #15 Stratton #15 kelly bushing kelly bushing for Stratton #15 kelly bushing for Stratton #16 Stratton #16 kelly bushing kelly bushing for Stratton #16 kelly bushing for Stratton #17 Stratton #17 kelly bushing kelly bushing for Stratton #17 kelly bushing for Stratton #18 Stratton #18 kelly bushing kelly bushing for Stratton #18 kelly bushing for Stratton #19 Stratton #19 kelly bushing kelly bushing for Stratton #19 kelly bushing for Stratton #20 Stratton #20 kelly bushing kelly bushing for Stratton #20 kelly bushing for Stratton #21 Stratton #21 kelly bushing kelly bushing for Stratton #21
pty_location_1d Data taken from Stratton table2. Use g_elev_ref 2 data_value wellbore_point general_wellbore_point.identifier M O NDT LOCATION NDT NAME L A40 ENDHEADER # kelly bushing for Stratford #1 sea level elevation 111 ft @ # kelly bushing for Stratford #2 sea level elevation 107 ft @ # kelly bushing for Stratford #3 sea level elevation 104 ft @ # kelly bushing for Stratford #4 sea level elevation 110 ft @ # kelly bushing for Stratford #5 sea level elevation 109 ft @ # kelly bushing for Stratford #6 sea level elevation 125 ft @ # kelly bushing for Stratford #7 sea level elevation 111 ft @ # kelly bushing for Stratford #8 sea level elevation 108 ft @ # kelly bushing for Stratford #9 sea level elevation 119 ft @ # kelly bushing for Stratford #10 sea level elevation 111 ft @ # kelly bushing for Stratford #11 sea level elevation 114 ft @ # kelly bushing for Stratford #12 sea level elevation 114 ft @ # kelly bushing for Stratford #13 sea level elevation 114 ft @ # kelly bushing for Stratford #14 sea level elevation 111 ft @ # kelly bushing for Stratford #15 sea level elevation 109 ft @ # kelly bushing for Stratford #16 sea level elevation 122 ft @ # kelly bushing for Stratford #17 sea level elevation 116 ft @ # kelly bushing for Stratford #18 sea level elevation 111 ft @ # kelly bushing for Stratford #19 sea level elevation 107 ft @ # kelly bushing for Stratford #20 sea level elevation 115 ft @ # kelly bushing for Stratford #21 sea level elevation 107 ft @
filename = measured_depth_system_axis
measured_depth_system_axis generated from table 2 using g_mdsa_ref 3 description vertical_datum ref_quantity_property source general_wellbore_point.identifier ref_quantity_property.name ref_source.name O M M NDT NAME NDT NAME NDT NAME A40 A40 A40 ENDHEADER Stratton #1 MD system axis kelly bushing for Stratton #1 measured depth ilab Stratton #2 MD system axis kelly bushing for Stratton #2 measured depth ilab Stratton #3 MD system axis kelly bushing for Stratton #3 measured depth ilab Stratton #4 MD system axis kelly bushing for Stratton #4 measured depth ilab Stratton #5 MD system axis kelly bushing for Stratton #5 measured depth ilab Stratton #6 MD system axis kelly bushing for Stratton #6 measured depth ilab Stratton #7 MD system axis kelly bushing for Stratton #7 measured depth ilab Stratton #8 MD system axis kelly bushing for Stratton #8 measured depth ilab Stratton #9 MD system axis kelly bushing for Stratton #9 measured depth ilab Stratton #10 MD system axis kelly bushing for Stratton #10 measured depth ilab Stratton #11 MD system axis kelly bushing for Stratton #11 measured depth ilab Stratton #12 MD system axis kelly bushing for Stratton #12 measured depth ilab Stratton #13 MD system axis kelly bushing for Stratton #13 measured depth ilab Stratton #14 MD system axis kelly bushing for Stratton #14 measured depth ilab Stratton #15 MD system axis kelly bushing for Stratton #15 measured depth ilab Stratton #16 MD system axis kelly bushing for Stratton #16 measured depth ilab Stratton #17 MD system axis kelly bushing for Stratton #17 measured depth ilab Stratton #18 MD system axis kelly bushing for Stratton #18 measured depth ilab Stratton #19 MD system axis kelly bushing for Stratton #19 measured depth ilab Stratton #20 MD system axis kelly bushing for Stratton #20 measured depth ilab Stratton #21 MD system axis kelly bushing for Stratton #21 measured depth ilab
filename = local_spatial_coordinate_system_2
local_spatial_coordinate_system
Data taken from Stratton table2. Use g_mdcoord_ref
4
identifier ref_coordinate_system_constraint source coordinate_system_axis
ref_coordinate_system_constraint.name ref_source.name measured_depth_system_axis.description
M M M M
NDT NAME NDT NAME NDT NAME DAE_AGG_LIST
A40 A40 A40 A40
ENDHEADER
Stratton #1 MD system measured depth system ilab #
Stratton #1 MD system axis
@
Stratton #2 MD system measured depth system ilab #
Stratton #2 MD system axis
@
Stratton #3 MD system measured depth system ilab #
Stratton #3 MD system axis
@
Stratton #4 MD system measured depth system ilab #
Stratton #4 MD system axis
@
Stratton #5 MD system measured depth system ilab #
Stratton #5 MD system axis
@
Stratton #6 MD system measured depth system ilab #
Stratton #6 MD system axis
@
Stratton #7 MD system measured depth system ilab #
Stratton #7 MD system axis
@
Stratton #8 MD system measured depth system ilab #
Stratton #8 MD system axis
@
Stratton #9 MD system measured depth system ilab #
Stratton #9 MD system axis
@
Stratton #10 MD system measured depth system ilab #
Stratton #10 MD system axis
@
Stratton #11 MD system measured depth system ilab #
Stratton #11 MD system axis
@
Stratton #12 MD system measured depth system ilab #
Stratton #12 MD system axis
@
Stratton #13 MD system measured depth system ilab #
Stratton #13 MD system axis
@
Stratton #14 MD system measured depth system ilab #
Stratton #14 MD system axis
@
Stratton #15 MD system measured depth system ilab #
Stratton #15 MD system axis
@
Stratton #16 MD system measured depth system ilab #
Stratton #16 MD system axis
@
Stratton #17 MD system measured depth system ilab #
Stratton #17 MD system axis
@
Stratton #18 MD system measured depth system ilab #
Stratton #18 MD system axis
@
Stratton #19 MD system measured depth system ilab #
Stratton #19 MD system axis
@
Stratton #20 MD system measured depth system ilab #
Stratton #20 MD system axis
@
Stratton #21 MD system measured depth system ilab #
Stratton #21 MD system axis
@
Following are the awk files used to generate the data in the above loader files. Each awk file is linked to the loader file.
filename = g_well_ref (Generates local_spatial_coordinate_system
{
if (substr($1,1,4)=="Well") next #skip the header line in the input data table.
printf("Stratton #%s\tactual\tlocal field\n",$1)
}
filename = g_wellbore_ref (Generates local_spatial_coordinate_system
{
if (substr($1,1,4)=="Well") next
wellid = "Stratton #" $1
wboreid = wellid
printf("%s\t%s\tactual\tlocal field\n",wboreid,wellid)
}
filename = g_kbpt_ref (Generates general_wellbore_point
{
if (substr($1,1,4)=="Well") next
id = "kelly bushing for Stratton #" $1
wboreid = "Stratton #" $1
printf("%s\t%s\tkelly bushing\t%s\n",id,wboreid,id)
}
filename = g_elev_ref (Generates local_spatial_coordinate_system
{
if (substr($1,1,4)=="Well") next
kb = "kelly bushing for Stratford #" $1
elev = $4
cs = "sea level elevation"
#ndt location will take 5 lines
printf("#\t%s\n",kb) #uses "#" in column 1
printf("%s\t\n",cs) #coordinate system name
printf("%s\t\n",elev) #elevation from table2
printf("ft\t\n") #units of measure (ft)
printf("@\t\n") #"@" is the last line flag
}
filename = g_mdsa_ref (Generates measured_depth_system_axis
{
if (substr($1,1,4)=="Well") next
axdescr = "Stratton #" $1 " MD system axis"
vdatum = "kelly bushing for Stratton #" $1
printf("%s\t%s\tmeasured depth\tilab\n",axdescr,vdatum)
}
filename = g_mdcoord_ref (Generates local_spatial_coordinate_system
{
if (substr($1,1,4)=="Well") next
mdid = "Stratton #" $1 " MD system"
mdaxis = mdid " axis"
#Aggregate takes multiple lines. Three in this case.
printf("%s\tmeasured depth system\tilab\t#\n",mdid)
printf("\t\t\t%s\n",mdaxis)
printf("\t\t\t@\n")
}