Formats
Microsoft Access, MySQL, CSV, DBF, SQL Server & Custom

Updates
This Database is updated every 120 Days. Master License holders can purchse updates for this database for $18.75.
PUBLICATION RIGHTS
$200.00
South Africa Geocode Database Content
USAGE RIGHTS (read only)
$75.00
South Africa Geocode Database Content
MASTER RIGHTS
$400.00
South Africa Geocode Database Content

South Africa Geocode Database v.1.0.0

116,915 Database Records


Download South Africa Geocode Database South Africa Geocode Database Download

License Database Purchase Options

Pick the right license USAGE
RIGHTS
$75.00
PUBLICATION
RIGHTS
$200.00
MASTER
RIGHTS
$400.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
  BUY NOW BUY NOW BUY NOW

This Geocode database for South Africa contains the geographic features of South Africa. Dataset Includes the Latitude and Longitude of Each Geographic Feature. This dataset is Perfect for Geocoding Applications. Database also contains all Feature Classification for Administrative regions, Populated places, Vegetation, Locality or area, Undersea, Streets, highways, roads, or railroad, Hypsographic, Hydrographic and Spot feature locations. The Republic of South Africa is a country located at the southern tip of the African continent. It borders the countries of Namibia, Botswana, Zimbabwe, Mozambique, and Swaziland. Lesotho is an enclave entirely surrounded by South African territory. South Africa has experienced a significantly different evolution than other nations in Africa arising primarily from two facts: immigration from Europe reached levels not experienced in other African communities and a level of mineralogical wealth that made the country extremely important to Western interests particularly during the Cold War. As a result of the former, South Africa is a very racially diverse nation. It has the largest population of people of Coloured (i.e., mixed racial background), European, and Indian communities in Africa. Black South Africans account for roughly 75% of the population.

Table Schema Database Field Statistics

  • Region Code
  • Unique Feature Identifier
  • Unique Name Identifier
  • Unique Geospatial Reference Coordinate (GRC) Identifier
  • Latitude
  • Longitude
  • Universal Transverse Mercator
  • Joint Operations Graphic
  • Feature Classification
  • Feature Designation Code
  • Populated Place Classification
  • Primary Country Code
  • First Order Division
  • Full Name
  • Short Name
  • Description
  • Type. See Record Information Below for full field descriptions.

Sample Data 116,915 Total Records

An Excel Speadsheet has been created with some sample data from this database. You can download this sample spreadsheet here: South Africa Geocode Database

Records Information

Field NameField DescriptionField TypeMaximum Field Length
RCRegion Code.  A code that determines the character mapping used in the Full_Name field:
1 = Western Europe/Americas;
2 = Eastern Europe;
3 = Africa/Middle East;
4 = Central Asia;
5 = Asia/Pacific;
6 = Vietnam.
number 1 Digit
UFIUnique Feature Identifier.  A number which uniquely identifies the feature.number 10 Digits
UNIUnique Name Identifier.  A number which uniquely identifies a name.number 10 Digits
UGIUnique Geospatial Reference Coordinate (GRC) Identifier.  A number which uniquely identifies a GRC.  A GRC is a set of multiple coordinates identifying a feature (in most cases the feature would be linear in nature).  This field is not normally selected by default. number 10 Digits
LATLatitude of the feature in decimal degree (WGS84):
no sign (+) = North;
negative sign (-) = South.
 number 2.15 Digits
LONGLongitude of the feature in decimal degree (WGS84):
no sign (+) = East;
negative sign (-) = West.
 number 3.14 Digits
DMS_LATLatitude of the feature in degree, minuets, and seconds (WGS84):
no sign (+) = North;
negative sign (-) = South.
number 6 Digits
DMS_LONGLongitude of the feature in degree, minuets, and seconds (WGS84):
no sign (+) = East;
negative sign (-) = West.
number 7 Digits
UTMUniversal Transverse Mercator coordinate grid reference.character4 Characters
JOGJoint Operations Graphic reference.character7 Characters
FCFeature Classification:
A = Administrative region;
P = Populated place;
V = Vegetation;
L = Locality or area;
U = Undersea;
R = Streets, highways, roads, or railroad;
T = Hypsographic;
H = Hydrographic;
S = Spot feature.
character1 Character
DSGFeature Designation Code.  A two to five-character code used to identify the type of feature a name is applied to.character5 Characters
PCPopulated Place Classification.  A graduated numerical scale denoting the relative importance of a populated place.  The scale ranges from 1,  relatively high, to 5, relatively low.  The scale could also include NULL (no value) as a value for populated places with unknown or undetermined classification.number1 Digit
CC1Primary Country Code.  A two alphabetic character code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).character2 Characters
ADM1First-order administrative division.  A two alphanumeric character code uniquely identifying a primary administrative division of a country, such as a state in the United States.character2 Characters
ADM2Second-order administrative division.  The name of a subdivision of a first-order administrative division, such as a county in the United States.variable character200 Characters
POPPopulation Figures.number10 Digits
ELEVElevations (in meters, decimal values accepted).number 22 Digits - floating decimal point
CC2Secondary Country Code.  A two alphabetic character code uniquely identifying the country code of a particular name if different than that of the feature.character2 Characters
GCCGeospatial Reference Coordinate (GRC) Country Code. A two alphabetic character code uniquely identifying the country code of a particular name of a GRCThis field is not normally selected by default. character2 Characters
NTName Type:
C = Conventional;
D = Not verified;
N = Native;
V = Variant or alternate.
character1 Character
LCLanguage Code.  A two alphabetic character code uniquely identifying a language of  a country if multiple official languages are used.character2 Characters
SHORT_FORMA specific part of the name that could substitute for the full name.variable character128 Characters
GENERICThe descriptive part of the full name (does not apply to populated place names).variable character128 Characters
SORT_NAMEA form of the full name which allows for easy sorting of the name into alpha-numeric sequence.  It is comprised of the specific name, generic name, and any articles or prepositions. This field is all upper case with spaces, diacritics, and hyphens removed and numbers are substituted with lower case alphabetic characters.variable character200 Characters
FULL_NAMEThe full name is a complete name which identifies the named feature.  It is comprised of  the specific name, generic name, and any articles or prepositions.variable character200 Characters
FULL_NAME_NDSame as the full name but the diacritics and special characters are substituted with Roman characters ND = No Diacritics / Stripped Diacritics. variable character200 Characters
MOD_DATEThe date a new feature was added or any part of an existing feature was modified (YYYY-MM-DD).  This field is not normally selected by default. date-time10 Characters
This is NOT an email marketing list
Auto Lamp Replacement Part List