Table sola.cadastre.level
LADM Definition: A set of spatial units, with geometric, and/or topological, and/or thematic coherence.
EXAMPLE 1 - One level for an urban cadastre and another level for a rural cadastre.
EXAMPLE 2 - One level with rights and another with restrictions.
EXAMPLE 3 - One level with formal rights, a second level with informal rights and a third level with customary rights.
EXAMPLE 4 - One level with point based spaital units, a second level with line based spatial units, and a third level with polygon based spatial features.
Implementation of the LADM LA_Level class. Used by SOLA to identify the set of spatial features for each layer displayed in the Map Viewer.
Tags: Reference Table, LADM Reference Object, 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
id varchar 40
level_config_map_layer.level_id level_config_map_layer_level_id_fk C
spatial_unit.level_id spatial_unit_level_id_fk57 R
LADM Definition: Level identifier.
name varchar 50  √  null LADM Definition: The name of the level.
register_type_code varchar 20 'all'::character varying
register_type.code level_register_type_code_fk58 R
LADM Definition: The register type of the content of the level. E.g. all, forest, mining, rural, urban, etc
structure_code varchar 20  √  null
structure_type.code level_structure_code_fk59 R
LADM Definition: Code for the structure of the level geometry. E.g. point, polygon, sketch, etc.
type_code varchar 20  √  null
level_content_type.code level_type_code_fk60 R
LADM Definition: The type of content of the level.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the level_historic table
rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar SOLA Extension: 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 SOLA Extension: The user id of the last person to modify the row.
change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
editable bool 1 false It shows if the spatial units of this level are editable from the spatial unit editor.

Analyzed at Tue May 31 09:57 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc level_pkey
rowidentifier Performance Asc level_index_on_rowidentifier
register_type_code Performance Asc level_register_type_code_fk58_ind
structure_code Performance Asc level_structure_code_fk59_ind
type_code Performance Asc level_type_code_fk60_ind

Close relationships  within of separation:

Excluded from diagram's relationships: cadastre_object.rowidentifier  spatial_unit_group.change_action  spatial_value_area.rowidentifier  cadastre_object_node_target.rowversion  spatial_unit_address.change_action  survey_point.rowidentifier  spatial_unit_address.change_user  survey_point.change_time  spatial_unit_group.rowversion  spatial_value_area.change_time  spatial_unit_in_group.change_action  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  survey_point.change_action  cadastre_object_node_target.change_user  cadastre_object.change_time  spatial_unit.change_user  spatial_unit_group.rowidentifier  survey_point.change_user  spatial_unit_in_group.change_time  spatial_unit.change_time  cadastre_object.change_action  survey_point.rowversion  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  spatial_unit_address.rowversion  spatial_unit_address.rowidentifier  cadastre_object_node_target.change_action