Description
The AfriGIS National Address Database (NAD) is a comprehensive spatial representation of physical street addresses in South Africa. 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_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 | ||
| nad_id | integer | int4 | NO | The unique identifier of the address. | x | x | x |
| nad_type | character varying | varchar | YES | The type of the address. | x | x | |
| streetnumber | character varying | varchar | YES | The alphanumeric identifier representing a street or house number. | x | 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 | 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 street. | x | x | |
| streettype_abbrv | character varying | varchar | YES | An abbreviation of the street type. | 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 | 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 | ||
| 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 | ||
| landparcelkey_id | integer | int4 | YES | The unique identifier for the land parcel to which the address refers (spatially). | x | ||
| is_controlledaccess | character | bpchar | NO | Indicates if the gated community is access controlled or not - Y(Yes), N(No) | x | ||
| permissible | character | bpchar | NO | Indicator if address is permissible from the local authority | 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 | x |
| confidence | character varying | varchar | YES | An absolute level specifying the relative position to which the record location was captured. | x | 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 |