Description
Dataset depicting informal settlements as derived from various sources.
| 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 | |
| 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 sub-locality measured in square metres. | x | ||
| feature_length_m | double precision | float8 | YES | The perimeter of the sub-locality 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 | 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 | 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 | NO | The unique 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 | ||
| postalcode_id | integer | int4 | YES | The unique identifier of the postal code region. | x | ||
| postalcode | character varying | varchar | YES | The postal code for street delivery as interpreted by the Postal Service | x | ||
| postal_boxcode | character varying | varchar | YES | Postal code for box delivery as interpreted by AfriGIS (Pty) Ltd. | x | ||
| postal_streetcode | character varying | varchar | YES | Postal code for street delivery as interpreted by AfriGIS (Pty) Ltd. | x | ||
| postal_areacode | character varying | varchar | YES | The reserved area code as supplied by the custodian | x | ||
| gatedcommunity_id | integer | int4 | NO | The unique identifier of the gated community. | x | ||
| gatedcommunity_name | character varying | varchar | YES | The gated community name. | x | ||
| gatedcommunity_type | character varying | varchar | YES | The classification of the gated community, e.g. urban, rural, etc. | x | ||
| gatedcommunity_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the gated community. | x | ||
| gatedcommunity_variantname | character varying | varchar | YES | An alternative and/or former name of the gated community. | x | ||
| majregion_id | integer | int4 | NO | The unique 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 | NO | The unique 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 | ||
| settlement_id | integer | int4 | NO | The unique identifier of the settlement. | x | x | |
| settlement_name | character varying | varchar | YES | The name of the settlement. | x | x | x |
| settlement_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the settlement. | x | x | |
| settlement_variantname | character varying | varchar | YES | An alternative and/or former name of the settlement. | x | x | |
| classification | character varying | varchar | YES | Classification of settlement based on size in sqm | x | ||
| is_estate | character | bpchar | YES | An indicator of whether the sub-locality is an estate or not. | x | ||
| is_controlled_access | 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 | YES | The latitude of the south-west corner of the minimum boundary rectangle. | x | ||
| mbr_sw_lng | double precision | float8 | YES | The longitude of the south-west corner of the minimum boundary rectangle. | x | ||
| mbr_ne_lat | double precision | float8 | YES | The latitude of the north-east corner of the minimum boundary rectangle. | x | ||
| mbr_ne_lng | double precision | float8 | YES | 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 |