POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
Spatial objects are topological elements, such as region, face, edge, and vertex, which can have geometrical representation. Each spatial object represents one opinion of the spatial nature of something. All associated geometrical properties are different representations of the same opinion.
- 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).
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: composite_spatial_object, edge, face, region, ring, shell, vertex.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- first_node (O: CHAR VARYING(11))
- edge.first_node
Asserts a topological relationship with the grid of the edge. FIRSTBOUND specifies that the first boundary is coincident with the first node of the grid. SECONDBOUND specifies that the second boundary is coincident with the first node of the grid.
- identifier (O: CHAR VARYING(80))
- spatial_object.identifier
The identifier of the spatial object.
- 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.
- on_surface (O: CHAR(1))
- composite_spatial_object.on_surface
TRUE asserts that the spatial collection is "on" (as opposed to near) the surface of the earth. All objects on the surface of the earth which have the same x,y location are asserted to coincide (i.e., have the same elevation). FALSE asserts that it is not on the surface of the earth or is only near it.
edge.on_surface
TRUE asserts that the edge is "on" (as opposed to near) the surface of the earth. All objects on the surface of the earth which have the same x,y location are asserted to coincide (i.e., have the same elevation). FALSE asserts that it is not on the surface of the earth or is only near it.
face.on_surface
TRUE asserts that the face is "on" (as opposed to near) the surface of the earth. All objects on the surface of the earth which have the same x,y location are asserted to coincide (i.e., have the same elevation). FALSE asserts that it is not on the surface of the earth or is only near it.
ring.on_surface
TRUE asserts that the ring is "on" (as opposed to near) the surface of the earth. All objects on the surface of the earth which have the same x,y location are asserted to coincide (i.e., have the same elevation). FALSE asserts that it is not on the surface of the earth or is only near it.
vertex.on_surface
TRUE asserts that the vertex is "on" (as opposed to near) the surface of the earth. All objects on the surface of the earth which have the same x,y location are asserted to coincide (i.e., have the same elevation). FALSE asserts that it is not on the surface of the earth or is only near it.
- preferred_flag (O: CHAR(1))
- spatial_object.preferred_flag
When true, this designates this instance as being the preferred spatial representation for the related locatable_object.
- 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".
- creating_activity_s (FSK, O: CHAR VARYING(19))
- spatial_object.creating_activity
The activity which created the spatial opinion.
Defines a foreign key to table activity.
- first_boundary_s (FSK, O: CHAR VARYING(19))
- edge.first_boundary
The first of the two vertices which form the boundary of the edge.
Defines a foreign key to table spatial_object.
- identifying_whole_s (FSK, O: CHAR VARYING(19))
- spatial_object.identifying_whole
The composite objects within whose context this object is unique.
Defines a foreign key to table spatial_object.
- located_activity_s (FSK, O: CHAR VARYING(19))
- spatial_object.located_activity
The activity which is (at least partially) located by this spatial opinion. This allows the spatial opinions of locatable objects to be versioned within the context of the activity.
Defines a foreign key to table activity.
- located_object_s (FSK, O: CHAR VARYING(19))
located_object_t (O: CHAR VARYING(30))
- spatial_object.located_object
The locatable object that is represented by this spatial nature.
located_object_s: Implements a foreign key to a row in one of the tables projected from entity locatable_object depending on the value of the next column (See below).
located_object_t: Defines the name of the referenced table. Possible values are defined in @locatable_object.
- second_boundary_s (FSK, O: CHAR VARYING(19))
- edge.second_boundary
The second of the two vertices which form the boundary of the edge.
Defines a foreign key to table spatial_object.