Description
A register of the sectional schemes titles as registered at the deeds office.
| Column Name | Data Type | Data UDT Type | Nullable | Description | Basic | Standard | Enterprise |
|---|---|---|---|---|---|---|---|
| geom | geometry | geometry | YES | The spatial component or definition of the geographic feature. | x | x | x |
| objectid | integer | int4 | NO | An internal, managed, unique and non-null integer used to uniquely identify records. The values are limited to 32-bit values, which store a maximum value of 2,147,483,648. | x | x | x |
| created_at | timestamp without time zone | timestamp | NO | The created date of the record. | x | ||
| updated_at | timestamp without time zone | timestamp | YES | The last modification date of the record. | x | x | |
| revised_at | timestamp without time zone | timestamp | YES | The reviewed date of the record. | x | ||
| sfid | character varying | varchar | NO | Global Feature Identifier as defined by the GML2 specification | x | ||
| fid | integer | int4 | NO | Local Feature Identifier as defined by the GML2 specification | x | ||
| feature_code_iso | character varying | varchar | YES | Reserved - Geospatial dictionary feature classification - ISO | x | ||
| feature_code_sagd | character varying | varchar | YES | Reserved - Geospatial dictionary feature classification - SANS | x | ||
| country_id | integer | int4 | NO | The identifier of the national administrative division. | x | x | |
| country | character varying | varchar | YES | The official country name specified in English. | x | x | |
| ison | integer | int4 | YES | The iso country number defined in ISO 3166-1. | x | ||
| iso3 | character varying | varchar | YES | The three-letter country code defined in ISO 3166-1. | x | ||
| iso2 | character varying | varchar | YES | The two-letter country code defined in ISO 3166-1. | x | ||
| adminarea_l1_id | integer | int4 | YES | The identifier of the first-level administrative area. | x | x | |
| adminarea_l1_type | character varying | varchar | YES | The type of the first-level administrative area. | x | ||
| adminarea_l1_name | character varying | varchar | YES | The name of the first-level administrative area. | x | x | |
| adminarea_l1_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the first-level administrative area. | x | ||
| adminarea_l1_variantname | character varying | varchar | YES | An alternative and/or former name of the first-level administrative area. | x | ||
| adminarea_l2_id | integer | int4 | YES | The identifier of the second-level administrative area. | x | ||
| adminarea_l2_type | character varying | varchar | YES | The type of the second-level administrative area. | x | ||
| adminarea_l2_name | character varying | varchar | YES | The name of the second-level administrative area. | x | ||
| adminarea_l2_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the second-level administrative area. | x | ||
| adminarea_l2_variantname | character varying | varchar | YES | An alternative and/or former name of the second-level administrative area. | x | ||
| adminarea_l3_id | integer | int4 | YES | The identifier of the third-level administrative area. | x | x | |
| adminarea_l3_type | character varying | varchar | YES | The type of the third-level administrative area. | x | ||
| adminarea_l3_name | character varying | varchar | YES | The name of the third-level administrative area. | x | x | |
| adminarea_l3_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the third-level administrative area. | x | ||
| adminarea_l3_variantname | character varying | varchar | YES | An alternative and/or former name of the third-level administrative area. | x | ||
| locality_id | integer | int4 | YES | The identifier of the locality. | x | x | |
| locality_type | character varying | varchar | YES | The type of the locality. | x | ||
| locality_name | character varying | varchar | YES | The name of the locality. | x | x | |
| locality_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the locality. | x | ||
| locality_variantname | character varying | varchar | YES | An alternative and/or former name of the locality. | x | ||
| sublocality_id | integer | int4 | YES | The identifier of the sub-locality. | x | x | |
| sublocality_type | character varying | varchar | YES | The type of the sub-locality. | x | ||
| sublocality_name | character varying | varchar | YES | The name of the sub-locality. | x | x | |
| sublocality_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the sub-locality. | x | ||
| sublocality_variantname | character varying | varchar | YES | An alternative and/or former name of the sub-locality. | x | ||
| sapo_boxcode | character varying | varchar | YES | South African Post Office postal code for box delivery as interpreted by AfriGIS (Pty) Ltd. | x | ||
| sapo_streetcode | character varying | varchar | YES | South African Post Office postal code for street delivery as interpreted by AfriGIS (Pty) Ltd. | x | ||
| gatedcommunity_id | integer | int4 | YES | The identifier of the gated community. | x | ||
| gatedcommunity_name | character varying | varchar | YES | The gated community name. | x | ||
| gatedcommunity_type | character varying | varchar | YES | The type of the gated community. | x | ||
| majregion_id | integer | int4 | YES | The identifier of the major region. | x | ||
| majregion_name | character varying | varchar | YES | The name of the major region. | x | ||
| majregion_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the major region. | x | ||
| majregion_variantname | character varying | varchar | YES | An alternative and/or former name of the major region. | x | ||
| minregion_id | integer | int4 | YES | The identifier of the minor region. | x | ||
| minregion_name | character varying | varchar | YES | The name of the minor region. | x | ||
| minregion_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the minor region. | x | ||
| minregion_variantname | character varying | varchar | YES | An alternative and/or former name of the minor region. | x | ||
| scheme_id | integer | int4 | NO | The unique identifier of the sectional scheme. | x | x | x |
| scheme_name | character varying | varchar | YES | The registered name of the sectional scheme, e.g. SS Willow Manor. | x | x | x |
| scheme_shortname | character varying | varchar | YES | The registered name of the sectional scheme excluding the "SS" prefix, e.g. Willow Manor. | x | ||
| scheme_variantname | character varying | varchar | YES | An abbreviated or abridged textual name of the sectional scheme. | x | x | |
| scheme_number | integer | int4 | YES | The number assigned to the sectional scheme by the deeds office. | x | x | |
| scheme_year | integer | int4 | YES | The registration year of the sectional scheme at the deeds office. | x | ||
| scheme_firstunit | integer | int4 | YES | The number of the first unit of the sectional scheme for the scheme number/year. | x | ||
| scheme_lastunit | integer | int4 | YES | The number of the last unit of the sectional scheme for the scheme number/year. | x | ||
| scheme_nounits | integer | int4 | YES | The total number of units within the sectional scheme for the scheme number/year. | x | ||
| deed_office | character varying | varchar | YES | A reference to the deeds office at which the sectional scheme was registered. | x | ||
| deed_province | character varying | varchar | YES | The province of the sectional scheme as assigned by the deeds office. | x | ||
| deed_town | character varying | varchar | YES | The town of the sectional scheme as assigned by the deeds office. | x | ||
| deed_erf | character varying | varchar | YES | The parcel description of the sectional scheme as assigned by the deeds office. | x | ||
| landparcelkey_id | integer | int4 | YES | The global unique system key identifier for the land parcel across all land parcel types. | x | ||
| lpicode | character varying | varchar | YES | A 21 character key assigned by the Surveyor General to a cadastral land parcel. | x | x | |
| is_controlledaccess | character | bpchar | YES | Indicates if the gated community is access controlled or not - Y(Yes), N(No) | x | ||
| sagd_ftype_id | integer | int4 | YES | South African Geospatial Data Dictionary feature type identifier. | x | ||
| sagd_ftype_description | character varying | varchar | YES | South African Geospatial Data Dictionary feature type. | x | ||
| sagd_etype_id | integer | int4 | YES | South African Geospatial Data Dictionary feature type enumeration identifier. | x | ||
| sagd_etype_description | character varying | varchar | YES | South African Geospatial Data Dictionary feature type enumeration value. | x | ||
| confidence_id | integer | int4 | YES | The identifier for the confidence level of the record. | x | x | |
| confidence | character varying | varchar | YES | An absolute level specifying the relative position to which the record location was captured. | x | x | |
| originator | character varying | varchar | YES | The party who created the resources, i.e. a reference to the original source from where the resource provider obtained the data, and where the record was created. | x | ||
| custodian | character varying | varchar | YES | The party that accepts accountability and responsibility for the data and ensures appropriate care and maintenance of the resources. | x | x | |
| resource_provider | character varying | varchar | YES | The party that supplies the resource, i.e. the organisation that provides or distributes the dataset. | x | ||
| map_label1 | character varying | varchar | YES | A proposed expression for map labelling purposes. | x | ||
| map_label2 | character varying | varchar | YES | A proposed expression for map labelling purposes. | x | ||
| map_label3 | character varying | varchar | YES | A proposed expression for map labelling purposes. | x | ||
| lng | double precision | float8 | NO | Angular distance on the earth's surface, measured east or west from the prime meridian at Greenwich, to the meridian passing through the centroid expressed in degrees. | x | ||
| lat | double precision | float8 | NO | The angular distance north or south of the earth's equator, measured in degrees along a meridian, to the line of latitude passing through the centroid. | x | ||
| label_lng | double precision | float8 | NO | The recommended longitude for labelling. | x | ||
| label_lat | double precision | float8 | NO | The recommended latitude for labelling. | x | ||
| vbr_sw_lat | double precision | float8 | NO | The latitude of the south-west corner of the recommended viewport boundary rectangle. | x | ||
| vbr_sw_lng | double precision | float8 | NO | The longitude of the south-west corner of the recommended viewport boundary rectangle. | x | ||
| vbr_ne_lat | double precision | float8 | NO | The latitude of the north-east corner of the recommended viewport boundary rectangle. | x | ||
| vbr_ne_lng | double precision | float8 | NO | The longitude of the north-east corner of the recommended viewport boundary rectangle. | x | ||
| label | double precision | float8 | NO | The well-known text representation of the recommended label location. | x | ||
| vbr | double precision | float8 | NO | The well-known text representation of the viewport boundary rectangle. | x |