Description
Data for surveyed boundaries approved by the Surveyor General office for street reserves. This layer is too large to load via WFS for the entire country. It can be customised based on client requirements.
| 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_area_sqm | double precision | float8 | YES | The surface area of the street measured in square metres. | x | ||
| feature_length_m | double precision | float8 | YES | The perimeter of the street measured in metres. | 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 | x | |
| majregion_name | character varying | varchar | YES | The name of the major region. | x | 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 | x | |
| minregion_name | character varying | varchar | YES | The name of the minor region. | x | 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 | ||
| landparcelkey_id | bigint | int8 | YES | The global unique system key identifier for the land parcel across all land parcel types. | x | ||
| landparcel_id | integer | int4 | NO | The unique identifier of the land parcel for the specific land parcel type. | x | x | x |
| landparcel_type | character varying | varchar | YES | The type of the land parcel. | x | ||
| gis_key | character varying | varchar | YES | An internal GIS character key indicating assigned land parcel key values. | x | ||
| lpicode | character varying | varchar | YES | A 21 character key assigned by the Surveyor General to a cadastral land parcel. | x | x | |
| registration_div | character varying | varchar | YES | The proclaimed major region assigned by the Surveyor General and registered with the deeds office. | x | ||
| township | character varying | varchar | YES | The proclaimed minor region surveyed by the Surveyor General and registered with the deeds office. | x | ||
| parcel_name | character varying | varchar | YES | The original registered land parcel name assigned by the Surveyor General. | x | x | |
| parcel_number | character varying | varchar | YES | The parcel number assigned by the Surveyor General and registered with the deeds office. | x | ||
| parcel_portion | character varying | varchar | YES | The parcel portion assigned by the Surveyor General and registered with the deeds office. | x | ||
| parcel_numberf | integer | int4 | YES | A formatted representation of the parcel number assigned by the Surveyor General and registered with the deeds office. | x | x | x |
| parcel_portionf | integer | int4 | YES | A formatted representation of the parcel portion assigned by the Surveyor General and registered with the deeds office. | x | 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 | ||
| mbr_sw_lat | double precision | float8 | NO | The latitude of the south-west corner of the minimum boundary rectangle. | x | ||
| mbr_sw_lng | double precision | float8 | NO | The longitude of the south-west corner of the minimum boundary rectangle. | x | ||
| mbr_ne_lat | double precision | float8 | NO | The latitude of the north-east corner of the minimum boundary rectangle. | x | ||
| mbr_ne_lng | double precision | float8 | NO | The longitude of the north-east corner of the minimum boundary rectangle. | 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 | ||
| mbr | double precision | float8 | NO | The well-known text representation of the minimum boundary rectangle. | x | ||
| vbr | double precision | float8 | NO | The well-known text representation of the viewport boundary rectangle. | x |