Description
This dataset provides information on the national administrative division, also known as country.
| 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 country administrative area measured in square metres. | x | ||
| feature_length_m | double precision | float8 | YES | The perimeter of the country administrative area 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 | x |
| country | character varying | varchar | YES | The official country name specified in English. | x | x | x |
| ison | integer | int4 | YES | The iso country number defined in ISO 3166-1. | x | x | |
| iso3 | character varying | varchar | YES | The three-letter country code defined in ISO 3166-1. | x | x | |
| iso2 | character varying | varchar | YES | The two-letter country code defined in ISO 3166-1. | x | x | |
| name_english | character varying | varchar | YES | The name of the national administrative division name specified in English. | x | ||
| name_iso | character varying | varchar | YES | Internationally recognized country name that designate every country and most of the dependent areas. | x | x | |
| name_fao | character varying | varchar | YES | The name for a country as defined by the Food and Agriculture Organization. | x | ||
| name_local | character varying | varchar | YES | The local name for the country | x | ||
| name_obsolute | character varying | varchar | YES | The obsolete name of the country. | x | ||
| name_variant | character varying | varchar | YES | The alternative and/or former name of the national administrative division. | x | x | |
| name_nonlatin | character varying | varchar | YES | The name of the national administrative division specified in Non-Latin. | x | ||
| name_french | character varying | varchar | YES | The name of the national administrative division specified in French. | x | ||
| name_spanish | character varying | varchar | YES | The name of the national administrative division specified in Spanish. | x | ||
| name_russian | character varying | varchar | YES | The name of the national administrative division specified in Russian. | x | ||
| name_arabic | character varying | varchar | YES | The name of the national administrative division specified in Arabic. | x | ||
| name_chinese | character varying | varchar | YES | The name of the national administrative division specified in Chinese. | x | ||
| total_admin_level | integer | int4 | YES | The total number of administrative divisions below the national administrative division. | 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 feature. | 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 |