Description
Sublocality layer with aggregated measurements for various parameters.
| 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 | x |
| sublocality_type | character varying | varchar | YES | The type of the sub-locality. | x | x | |
| sublocality_name | character varying | varchar | YES | The name of the sub-locality. | x | x | x |
| sublocality_shortname | character varying | varchar | YES | An abbreviated or abridged textual name of the sub-locality. | x | x | |
| sublocality_variantname | character varying | varchar | YES | An alternative and/or former name of the sub-locality. | x | x | |
| sublocality_officialname | character varying | varchar | YES | The name as proclaimed by the authority | 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 | ||
| is_estate | character | bpchar | YES | An indicator of whether the sub-locality is an estate or not. | x | x | x |
| total_nad | integer | int4 | YES | Count of the National Address Database points. | x | x | x |
| total_scheme | integer | int4 | YES | Count of the number of sectional schemes. | x | x | x |
| total_scheme_nounits | integer | int4 | YES | Count of the number of sectional scheme units. | x | x | x |
| highway_length_km | double precision | float8 | YES | Total length of highway in kilometers. | x | x | x |
| arterial_length_km | double precision | float8 | YES | Total length of arterial roads in kilometers. | x | x | x |
| main_length_km | double precision | float8 | YES | Total length of main roads in kilometers. | x | x | x |
| secondary_length_km | double precision | float8 | YES | Total length of secondary roads in kilometers. | x | x | x |
| street_length_km | double precision | float8 | YES | Total length of streets in kilometers. | x | x | x |
| other_length_km | double precision | float8 | YES | Total length of other road types in kilometers. | x | x | x |
| barrier_length_km | double precision | float8 | YES | Total length of barriers in kilometers. | x | x | x |
| walkway_length_km | double precision | float8 | YES | Total length of walkways in kilometers. | x | x | x |
| has_ramp | character varying | varchar | YES | Indicates if the sublocality has an offramp with Yes/No. | x | x | x |
| total_automotive | integer | int4 | YES | Count of the number of points of interest classified as automotive. | x | x | x |
| total_commercial | integer | int4 | YES | Count of the number of points of interest classified as commercial. | x | x | x |
| total_entertainment | integer | int4 | YES | Count of the number of points of interest classified as entertainment. | x | x | x |
| total_filling_station | integer | int4 | YES | Count of the number of points of interest classified as filling stations. | x | x | x |
| total_medical | integer | int4 | YES | Count of the number of points of interest classified as medical services. | x | x | x |
| total_services | integer | int4 | YES | Count of the number of points of interest classified as services. | x | x | x |
| total_stores | integer | int4 | YES | Count of the number of points of interest classified as stores. | x | x | x |
| total_tourism_attraction | integer | int4 | YES | Count of the number of points of interest classified as tourism attractions. | x | x | x |
| total_transportation | integer | int4 | YES | Count of the number of points of interest classified as transportation. | x | x | x |
| total_erven | integer | int4 | YES | Count of the number of erven. | x | x | x |
| total_holding | integer | int4 | YES | Count of the number of holdings. | x | x | x |
| population_black_1996 | integer | int4 | YES | Total black population as in 1996 Census. | x | x | x |
| population_white_1996 | integer | int4 | YES | Total white population as in 1996 Census. | x | x | x |
| population_asian_1996 | integer | int4 | YES | Total asian population as in 1996 Census. | x | x | x |
| population_coloured_1996 | integer | int4 | YES | Total coloured population as in 1996 Census. | x | x | x |
| population_other_1996 | integer | int4 | YES | Total other population as in 1996 Census. | x | x | x |
| total_population_1996 | integer | int4 | YES | Total population as in 1996 Census. | x | x | x |
| avg_household_income_1996 | double precision | float8 | YES | Average household income as in 1996 Census. | x | x | x |
| total_households_1996 | integer | int4 | YES | Total number of households as in 1996 Census. | x | x | x |
| population_black_2001 | integer | int4 | YES | Total black population as in 2001 Census. | x | x | x |
| population_white_2001 | integer | int4 | YES | Total white population as in 2001 Census. | x | x | x |
| population_asian_2001 | integer | int4 | YES | Total asian population as in 2001 Census. | x | x | x |
| population_coloured_2001 | integer | int4 | YES | Total coloured population as in 2001 Census. | x | x | x |
| population_other_2001 | integer | int4 | YES | Total other population as in 2001 Census. | x | x | x |
| total_population_2001 | integer | int4 | YES | Total population as in 2001 Census. | x | x | x |
| avg_household_income_2001 | double precision | float8 | YES | Average household income as in 2001 Census. | x | x | x |
| total_households_2001 | integer | int4 | YES | Total number of households as in 2001 Census. | x | x | x |
| population_black_2011 | integer | int4 | YES | Total black population as in 2011 Census. | x | x | x |
| population_white_2011 | integer | int4 | YES | Total white population as in 2011 Census. | x | x | x |
| population_asian_2011 | integer | int4 | YES | Total asian population as in 2011 Census. | x | x | x |
| population_coloured_2011 | integer | int4 | YES | Total coloured population as in 2011 Census. | x | x | x |
| population_other_2011 | integer | int4 | YES | Total other population as in 2011 Census. | x | x | x |
| total_population_2011 | integer | int4 | YES | Total population as in 2011 Census. | x | x | x |
| avg_household_income_2011 | double precision | float8 | YES | Average household income as in 2011 Census. | x | x | x |
| total_households_2011 | integer | int4 | YES | Total number of households as in 2011 Census. | x | x | 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 |