South Africa cities list with latitude and longitude in CSV format

South_Africa
South Africa
CSV, SQL, XML, JSON

Last update : 26 May 2024.

Country
South Africa
Capitale
Pretoria
Number of cities
11960
Download

This is the best list of 11960 cities in the South Africa available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the South Africa file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
982382LokishiniZAEastern CapeChris Hani District Municipality-31.7117227.648380Africa/Johannesburgpopulated place
986348KuMateZAEastern CapeOR Tambo District Municipality-30.9652729.535250Africa/Johannesburgpopulated place
973608MotutulongZALimpopoSekhukhune District Municipality-24.631430.219920Africa/Johannesburgpopulated place
997919Ha-RabaliZALimpopoVhembe District Municipality-22.8785830.093930Africa/Johannesburgpopulated place
960742RondebultZAOrange Free StateXhariep District Municipality-29.5960826.386880Africa/Johannesburgpopulated place
1001418GoededachtZAMpumalangaNkangala District Municipality-26.1273228.729510Africa/Johannesburgpopulated place
1009730DitshilabelengZANorth-West-27.3423423.782930Africa/Johannesburgpopulated place
1023378Alexandersfontein HotelZAOrange Free State-28.8166724.80Africa/Johannesburgpopulated place
963243RandalhurstZAKwaZulu-NataluThungulu District Municipality-28.5666731.150Africa/Johannesburgpopulated place
961228RitaZALimpopoCapricorn District Municipality-23.6333329.633330Africa/Johannesburgpopulated place
11238392Vaal MarinaZAGautengSedibeng District Municipality-26.875828.228130Africa/Johannesburgpopulated place
1015959BrandhoekZAEastern CapeSarah Baartman District Municipality-33.7497523.894670Africa/Johannesburgpopulated place
967548OrangezigZAWestern CapeCape Winelands District Municipality-33.9947520.212320Africa/Johannesburgpopulated place
980134MakadikweZALimpopoSekhukhune District Municipality-24.7005529.745840Africa/Johannesburgpopulated place
11204543SoshanguveZANorth-WestBojanala Platinum District Municipality-25.4986727.970Africa/Johannesburgpopulated place
1017662BonfoiZANorthern CapePixley ka Seme District Municipality-29.3035122.464510Africa/Johannesburgpopulated place
947066TyeniZAEastern CapeJoe Gqabi District Municipality-30.8891728.575370Africa/Johannesburgpopulated place
1005681eMafakathiniZAKwaZulu-NataluMgungundlovu District Municipality-29.6557430.127560Africa/Johannesburgpopulated place
981324LuqaqeniZAEastern CapeAlfred Nzo District Municipality-30.1684829.057270Africa/Johannesburgpopulated place
939069WitkleibosWitkleibos,Witte Kley BosZAEastern CapeSarah Baartman District Municipality-34.0666724.450Africa/Johannesburgpopulated place
977870MawulaMawula,MpembaZAEastern CapeAlfred Nzo District Municipality-31.0183428.994210Africa/Johannesburgpopulated place
987431KransbergZALimpopoWaterberg District Municipality-24.4333327.533330Africa/Johannesburgpopulated place
955480SinqungweniSigungqwini,SinqungweniZAEastern CapeJoe Gqabi District Municipality-31.1243728.653940Africa/Johannesburgpopulated place
959364RooivloerZANorthern CapeSiyanda District Municipality-28.220.483330Africa/Johannesburgpopulated place
989223KlippanZANorth-West-25.4409228.028140Africa/Johannesburgpopulated place
972614MunsterMunsterZAKwaZulu-NatalUgu District Municipality-30.9982830.248710Africa/Johannesburgpopulated place
962930ReebokReebok,RheboksfonteinZAWestern CapeEden District Municipality-34.0788122.163430Africa/Johannesburgpopulated place
1013337ClermontClaremont,ClermontZAKwaZulu-NataleThekwini Metropolitan Municipality-29.7931230.897880Africa/Johannesburgpopulated place
947842TshivanganiZALimpopoVhembe District Municipality-23.1828630.436520Africa/Johannesburgpopulated place
1015128BuffelsfonteinZANorth-WestDr Kenneth Kaunda District Municipality-26.9214726.817510Africa/Johannesburgpopulated place
974301MooiplaasZAEastern CapeJoe Gqabi District Municipality-30.8333326.650Africa/Johannesburgpopulated place
983004LetselaskraalZAOrange Free StateThabo Mofutsanyana District Municipality-28.5528.316670Africa/Johannesburgpopulated place
9408086MagoebaskloofZALimpopoMopani District Municipality-23.8767330.001260Africa/Johannesburgpopulated place
11203899Bram FischervilleZAGautengCity of Johannesburg Metropolitan Municipality-26.1992627.812490Africa/Johannesburgpopulated place
982277LonganengZANorth-WestDr Ruth Segomotsi Mompati District Municipality-27.6283124.944280Africa/Johannesburgpopulated place
973350MpakeniZAMpumalangaEhlanzeni District-25.4856231.260750Africa/Johannesburgpopulated place
973430Mount ViewZAEastern CapeChris Hani District Municipality-31.9581627.137990Africa/Johannesburgpopulated place
979280MantshilibeniZAEastern CapeOR Tambo District Municipality-31.7587728.468760Africa/Johannesburgpopulated place
951658StudtisZAEastern CapeSarah Baartman District Municipality-33.5453123.983180Africa/Johannesburgpopulated place
981481LugolweniZAEastern CapeAlfred Nzo District Municipality-30.8838529.043390Africa/Johannesburgpopulated place
986234KuNkumbaZAEastern CapeAmathole District Municipality-32.0437829.034810Africa/Johannesburgpopulated place
1006937EbenezerZAEastern CapeAlfred Nzo District Municipality-31.0687330.16440Africa/Johannesburgpopulated place
963051RayonneZAKwaZulu-NataluMgungundlovu District Municipality-29.1666730.166670Africa/Johannesburgpopulated place
983249LemoenfonteinZAOrange Free StateXhariep District Municipality-30.3925926.365050Africa/Johannesburgpopulated place
1003322Ga-MamadilaZALimpopoCapricorn District Municipality-23.7936929.217850Africa/Johannesburgpopulated place
1014384CabazanaZAEastern CapeAlfred Nzo District Municipality-30.6874429.407290Africa/Johannesburgpopulated place
950687SwinburneZAEastern CapeNelson Mandela Bay Metropolitan Municipality-33.9151525.397060Africa/Johannesburgpopulated place
3365303KoiingnaasKIG,Koiingnaas,KoingnaasZANorthern CapeNamakwa District Municipality-30.2001817.28210Africa/Johannesburgpopulated place
1002851Ga-RankuwaGa-RankuwaZANorth-West-25.6169227.9947190945Africa/Johannesburgpopulated place
985601KwaMcatuveZAEastern CapeChris Hani District Municipality-31.8666727.633330Africa/Johannesburgpopulated place
976723MfinciZAEastern CapeJoe Gqabi District Municipality-30.5166727.60Africa/Johannesburgpopulated place
955460SipeziniZAEastern CapeOR Tambo District Municipality-31.1601329.485590Africa/Johannesburgpopulated place
984186LaudinaZAWestern CapeEden District Municipality-33.6923722.959030Africa/Johannesburgpopulated place
971017NgqeleniZAEastern CapeOR Tambo District Municipality-30.9952929.518220Africa/Johannesburgpopulated place
996336HlanjwaZAEastern CapeJoe Gqabi District Municipality-30.5527.283330Africa/Johannesburgpopulated place
977951MatuyeZANorth-West-27.3333323.350Africa/Johannesburgpopulated place
937676Xuka DriftXuka,Xuka DriftZAEastern CapeChris Hani District Municipality-31.7005928.230330Africa/Johannesburgpopulated place
985952KwaDlomoZAEastern CapeChris Hani District Municipality-31.7180627.868590Africa/Johannesburgpopulated place
949380The PoplarsZAOrange Free StateXhariep District Municipality-29.5014626.814010Africa/Johannesburgpopulated place
1012438CruachanZANorthern CapeSiyanda District Municipality-29.9380821.918880Africa/Johannesburgpopulated place
974009MoremelaZAMpumalangaEhlanzeni District-24.6166730.733330Africa/Johannesburgpopulated place
970978NgqwanguZAEastern CapeOR Tambo District Municipality-31.629.416670Africa/Johannesburgpopulated place
985130KweleraKwelega,Kwelegha,KweleraZAEastern CapeAmathole District Municipality-32.8493728.006570Africa/Johannesburgpopulated place
1000993Golf ViewZAGautengSedibeng District Municipality-26.4265527.94360Africa/Johannesburgpopulated place
991317KerreraZAEastern CapeChris Hani District Municipality-31.3446327.598670Africa/Johannesburgpopulated place
1013790CentuliZAEastern CapeOR Tambo District Municipality-31.6612828.62020Africa/Johannesburgpopulated place
955121SkilderkransZAEastern CapeJoe Gqabi District Municipality-31.0168525.983030Africa/Johannesburgpopulated place
1000420GrasbultZANorthern CapePixley ka Seme District Municipality-29.6489422.229220Africa/Johannesburgpopulated place
970370NkonjeniNkonjeni,Norwegian,Norwegian Mission StationZAKwaZulu-NatalZululand District Municipality-28.2267731.416070Africa/Johannesburgpopulated place
3362312RomansrivierRomans River,RomansrivierZAWestern CapeCape Winelands District Municipality-33.46919.214240Africa/Johannesburgpopulated place
956048ShewasauluZALimpopoVhembe District Municipality-23.0630430.345870Africa/Johannesburgpopulated place
958052SamesuipingZAOrange Free StateXhariep District Municipality-29.4572225.777670Africa/Johannesburgpopulated place
971904NciseZAEastern CapeOR Tambo District Municipality-31.5614728.655390Africa/Johannesburgpopulated place
945068Valley ViewZAEastern CapeOR Tambo District Municipality-31.347929.358480Africa/Johannesburgpopulated place
1003702FraserburgFraserburgZANorthern CapeNamakwa District Municipality-31.9156621.513353029Africa/Johannesburgpopulated place
995200Howieson’s PoortZAEastern CapeSarah Baartman District Municipality-33.3526.50Africa/Johannesburgpopulated place
11467813BongolethuZAWestern CapeEden District Municipality-33.5992322.24320Africa/Johannesburgpopulated place
1002778Ga-SekhukhuneZALimpopoSekhukhune District Municipality-24.7530.016670Africa/Johannesburgpopulated place
951935StoomhoekZAOrange Free StateMangaung Metropolitan Municipality-28.8075126.105130Africa/Johannesburgpopulated place
1019809BessiedamZANorthern CapeNamakwa District Municipality-30.1750921.060020Africa/Johannesburgpopulated place
1001654Glen GregorZAEastern CapeAmathole District Municipality-32.6333326.116670Africa/Johannesburgpopulated place
956511SendingSending,ZendingZALimpopoVhembe District Municipality-23.129.450Africa/Johannesburgpopulated place
1023353AlfalfaZAWestern CapeCape Winelands District Municipality-33.9407220.108070Africa/Johannesburgpopulated place
994396JaagbaanZAKwaZulu-NataluMgungundlovu District Municipality-29.3479530.692910Africa/Johannesburgpopulated place
955614SilindaZAMpumalangaEhlanzeni District-24.9531.116670Africa/Johannesburgpopulated place
962414RhodesiaZAEastern CapeJoe Gqabi District Municipality-30.86428.607560Africa/Johannesburgpopulated place
954739SlangfonteinZAOrange Free StateXhariep District Municipality-29.4342326.562110Africa/Johannesburgpopulated place
977417MdeniZAEastern CapeChris Hani District Municipality-31.9688127.899320Africa/Johannesburgpopulated place
945897Upper MjikaUpper Mjika,Upper UmjikaZAEastern CapeOR Tambo District Municipality-31.3736528.608630Africa/Johannesburgpopulated place
982403LogobateLogabate,Logabati,Logobate,Logobate LocationZANorth-West-27.1662923.415030Africa/Johannesburgpopulated place
947720TswaingZALimpopoCapricorn District Municipality-24.3364129.733720Africa/Johannesburgpopulated place
970198NokayamatlalaZALimpopoCapricorn District Municipality-23.729.033330Africa/Johannesburgpopulated place
974641MonotwaneZALimpopoSekhukhune District Municipality-24.5530.266670Africa/Johannesburgpopulated place
1007277Du ToitskraalZAOrange Free StateXhariep District Municipality-29.853526.054910Africa/Johannesburgpopulated place
1005612eMgadleteniZAKwaZulu-NataluMgungundlovu District Municipality-29.9484630.210530Africa/Johannesburgpopulated place
967006OuteniekwaOteniekwa,Outeniekwa,OuteniquaZAWestern CapeEden District Municipality-34.0309722.310790Africa/Johannesburgpopulated place
979248ManyanaZAEastern CapeAmathole District Municipality-32.628.433330Africa/Johannesburgpopulated place
988886KloofKloofZAKwaZulu-NataleThekwini Metropolitan Municipality-29.7852930.823250Africa/Johannesburgpopulated place
965406PhugwaneZALimpopoVhembe District Municipality-22.9789230.788210Africa/Johannesburgpopulated place
974988MofufutsoZANorth-WestNgaka Modiri Molema District Municipality-26.4447425.404040Africa/Johannesburgpopulated place

FaQ about South Africa


Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.