Description
The dataset that shows a representation of portions of streets with uniform characteristics. 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 | YES | Global Feature Identifier as defined by the GML2 specification. | x | ||
| fid | integer | int4 | YES | Local Feature Identifier as defined by the GML2 specification. | x | ||
| feature_length_m | double precision | float8 | YES | The length of the street segment measured in metres. | x | x | |
| dir | smallint | int2 | YES | Indicates one ways and dual roads. | 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 | ||
| streetsegment_id | integer | int4 | NO | The unique identifier of the street segment. | x | x | x |
| navigate | character varying | varchar | YES | Used by the Navigator and the Mapserver routing algorithm, e.g. "ramp", "circle", etc. | x | ||
| avgspeed | double precision | float8 | YES | An estimate of the average speed of vehicles travelling on the street segment. | x | ||
| traveltime | double precision | float8 | YES | The time in minutes to traverse the street segment when travelling at the average speed. | x | ||
| routespeed | double precision | float8 | YES | The assigned route speed of the street segment. | x | ||
| routetime | double precision | float8 | YES | The time in minutes to traverse the street segment when travelling at the route speed. | x | ||
| is_tollway | smallint | int2 | YES | An indication of the presence of an etoll or SANRAL toll on the street segment. | x | ||
| is_code | character varying | varchar | YES | To be removed from view. | x | ||
| is_desc | character varying | varchar | YES | To be removed from view. | x | ||
| is_controlledaccess | character | bpchar | YES | Indicates if the gated community is access controlled or not - Y(Yes), N(No) | x | ||
| streetclass_id | integer | int4 | YES | The category of the street segment | x | ||
| streetclass | character varying | varchar | YES | The category of the street segment. | x | x | |
| streetmodifier_before | character varying | varchar | YES | An element in the complete street name that precedes the street name and type in the complete street name and modifies it. | x | x | |
| streetname | character varying | varchar | YES | Official name of a street as assigned by a local governing authority excluding the street type, directional and modifier. | x | x | x |
| streettype | character varying | varchar | YES | The element of the complete street name either preceding the street name element or following it that indicates the type of the street. | x | x | |
| streettype_abbrv | character varying | varchar | YES | An abbreviation of the street type. | x | x | |
| streetmodifier_after | character varying | varchar | YES | An element in the complete street name that follows the street name and type in the complete street name and modifies it. | x | x | |
| streetdirectional | character varying | varchar | YES | A geographic direction in the complete street name that either precedes or follows the street name and type, and that indicates the relative direction of the street. | x | ||
| fullstreetname_long | character varying | varchar | YES | Official name of a street as assigned by a local governing authority including the street type, directional and modifier. | x | x | x |
| fullstreetname_short | character varying | varchar | YES | Official name of a street as assigned by a local governing authority including the street type abbreviation, directional and modifier. | x | ||
| roadname | character varying | varchar | YES | Official name of a road as assigned by a provincial or national authority or another name that is used and recognized for a road in a non-urban area. | 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 | 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 |