A location on the surface of the Earth expressed as a pair of north-south and east-west offsets from legal survey lines.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
pty_legal_survey_location.east_west_distance
The distance of the offset in the east/west direction. east_west_distance_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
north_offset_first (O: CHAR(1))
pty_legal_survey_location.north_offset_first
If true, the north/south offset is measured first. If false, the east/west offset is measured first.
pty_legal_survey_location.north_south_distance
The distance of the offset in the north/south direction. north_south_distance_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
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.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
source_content (O: CHAR VARYING(80))
pty_location.source_content
This is the original source of the data (e.g., the surveying company). This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. This may be the same as or different from the provider of the instance (e.g., POSC).
activity_s (FSK, O: CHAR VARYING(19))
process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
east_west_line_s (FSK, O: CHAR VARYING(19))
pty_legal_survey_location.east_west_line
This is the legal survey line used to describe the east/west offset for this location. This line is generally north-south in orientation. If this line is not specified, the east or west line of the designated legal survey area should be used.
Defines a foreign key to table legal_survey_feature.
east_west_orientation (FNK, O: CHAR VARYING(80))
pty_legal_survey_location.east_west_orientation
The orientation of the east/west offset, either parallel to the north/south line or perpendicular to the east/west line.
Defines a foreign key to table r_offset_line_orientation.
pty_legal_survey_location.legal_survey_area
This designates the legal survey area within which the legal survey location is specified. legal_survey_area_s: Implements a foreign key to a row in one of the tables projected from entity legal_survey_area depending on the value of the next column (See below). legal_survey_area_t: Defines the name of the referenced table. Possible values are defined in @legal_survey_area.
location_status (FNK, O: CHAR VARYING(80))
pty_location.location_status
This indicates the status of a location.
Defines a foreign key to table r_location_status.
north_south_line_s (FSK, O: CHAR VARYING(19))
pty_legal_survey_location.north_south_line
This is the legal survey line used to describe the north/south offset for this location. This line is generally east-west in orientation. If this line is not specified, the north or south line of the designated legal survey area should be used.
Defines a foreign key to table legal_survey_feature.
pty_legal_survey_location.north_south_orientation
The orientation of the north/south offset, either parallel to the east/west line or perpendicular to the north/south line.
Defines a foreign key to table r_offset_line_orientation.
property.represent
This is the property that is the original for which this representation is an equivalent representation. represent_s: Implements a foreign key to a row in one of the tables projected from entity property depending on the value of the next column (See below). represent_t: Defines the name of the referenced table. Possible values are defined in @property.