Table sola.cadastre.survey_point
Used to store new survey point details (i.e. boundary and traverse) when capturing a survey plan into SOLA. Survey points can be used to define new cadastre objects.
Tags: FLOSS SOLA Extension, Change History

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
transaction_id varchar 40 survey_point_transaction_id_fk99 C
Identifier of the transaction that created the survey point.
id varchar 40 Identifier for the survey point.
boundary bool 1 true Flag to indicate if the survey point is a boundary point (true) or traverse point (false).
linked bool 1 false Flag to indicate if the new survey point has been linked to an existing cadastre object boundary node.
geom geometry 2147483647 Geometry representing the current position of the survey point.
original_geom geometry 2147483647 Geometry representing the original position of the survey point i.e. before it was linked to an existing cadastre object boundary node.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the survey_point_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.

Analyzed at Tue May 31 09:57 NZST 2016

Column(s) Type Sort Constraint Name
transaction_id + id Primary key Asc/Asc survey_point_pkey
geom Performance Asc survey_point_index_on_geom
original_geom Performance Asc survey_point_index_on_original_geom
rowidentifier Performance Asc survey_point_index_on_rowidentifier
transaction_id Performance Asc survey_point_transaction_id_fk99_ind

Close relationships  within of separation:

Excluded from diagram's relationships: cadastre_object.rowidentifier  spatial_unit_group.change_action  spatial_value_area.rowidentifier  level.change_time  cadastre_object_node_target.rowversion  spatial_unit_address.change_action  spatial_unit_address.change_user  spatial_unit_group.rowversion  spatial_value_area.change_time  spatial_unit_in_group.change_action  level.change_user  legal_space_utility_network.change_user  spatial_unit_in_group.rowidentifier  cadastre_object_node_target.rowidentifier  cadastre_object_target.change_time  legal_space_utility_network.change_time  cadastre_object.change_user  spatial_unit.rowidentifier  legal_space_utility_network.rowversion  cadastre_object_node_target.change_time  spatial_unit_in_group.rowversion  cadastre_object_node_target.change_user  cadastre_object.change_time  spatial_unit.change_user  spatial_unit_group.rowidentifier  spatial_unit_in_group.change_time  spatial_unit.change_time  level.rowversion  level.change_action  cadastre_object.change_action  legal_space_utility_network.change_action  spatial_unit_group.change_user  spatial_value_area.change_action  spatial_unit.change_action  cadastre_object_target.change_user  spatial_unit_group.change_time  spatial_unit_address.change_time  cadastre_object_target.rowversion  spatial_value_area.rowversion  spatial_value_area.change_user  cadastre_object_target.rowidentifier  spatial_unit.rowversion  legal_space_utility_network.rowidentifier  cadastre_object.rowversion  spatial_unit_in_group.change_user  cadastre_object_target.change_action  level.rowidentifier  spatial_unit_address.rowversion  spatial_unit_address.rowidentifier  cadastre_object_node_target.change_action