A location that is expressed in an ordered set of three ordinate values. The related coordinate system must have only three axes.

p_location_3d_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


data_value_1_o (M: FLOAT)
data_value_1_ou (FNK, M: CHAR VARYING(15))
data_value_2_o (M: FLOAT)
data_value_2_ou (FNK, M: CHAR VARYING(15))
data_value_3_o (M: FLOAT)
data_value_3_ou (FNK, M: CHAR VARYING(15))
data_value_cs (FNK, M: CHAR VARYING(40))
data_value_o_s (FSK, O: CHAR VARYING(19))
data_value_o_t (O: CHAR VARYING(16))

pty_location_3d.data_value
The coordinates of a point in a three dimensional coordinate system.
data_value_1_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
data_value_2_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
data_value_3_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
data_value_cs: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_sys.
data_value_o_s: Defines the origin of the coordinate value(s).Implements a foreign key to a row in one of the tables projected from entity vertex depending on the value of the next column (See below).
data_value_o_t: Defines the name of the referenced table. Possible values are: .


description (O: CHAR VARYING(2000))

pty_location.description
A remark, comment or description about the location value.


preferred_flag (O: CHAR(1))

property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.


activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))

process_data.activity
Defines the activity which created this instance.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


earth_pos_vrtx_s (FSK, O: CHAR VARYING(19))

pty_location_3d.earth_position_vertex

Defines a foreign key to table earth_pos_vrtx.


general_esrf_pt_s (FSK, O: CHAR VARYING(19))

pty_location_3d.general_earth_surface_point

Defines a foreign key to table general_esrf_pt.


other_sptl_obj_s (FSK, O: CHAR VARYING(19))
other_sptl_obj_t (O: CHAR VARYING(16))

property.other_spatial_object

other_sptl_obj_s: Implements a foreign key to a row in one of the tables projected from entity other_spatial_object depending on the value of the next column (See below).
other_sptl_obj_t: Defines the name of the referenced table. Possible values are defined in @other_spatial_object.


other_vertex_s (FSK, O: CHAR VARYING(19))

pty_location_3d.other_vertex

Defines a foreign key to table other_vertex.


wellbore_point_s (FSK, O: CHAR VARYING(19))
wellbore_point_t (O: CHAR VARYING(16))

pty_location_3d.wellbore_point

wellbore_point_s: Implements a foreign key to a row in one of the tables projected from entity wellbore_point depending on the value of the next column (See below).
wellbore_point_t: Defines the name of the referenced table. Possible values are: general_wb_pt, wb_aligned_pt (@wellbore_point).