You are here
Home > Programming > South African Cities And Provinces – A Complete List

South African Cities And Provinces – A Complete List

- 486378
Find a list of South African Cities

South African Cities – Are you looking for a complete list of South African Cities along with their provinces? Well good luck with that. I spent the most part of my Saturday searching for a comprehensive list (which I didn’t find). Below is the product of my research, a down-loadable list of all South African Cities.

South African Cities – A Complete List

I have had to massage the data somewhat with doing some fancy SQL footwork. What I have ended up with is a list of SA Cities along with their provinces and Longitude and Latitude coordinates. You can download the files from the links below.

CSV File

Zipped RPT File

Excel File

SA Cities MSSQL Database RAR

SA Cities MSSQL Database 7 Zip

Lastly, if you’re looking for some useful Web Services, consider WebserviceX.NET which I used to illustrate the concept of Obfuscation. Enjoy!

UPDATE – 19 September 2015

Thanks to Charles Crous that made me aware of a possible error that exists for the GPS coordinates of Tweespruit in the Free State. Google reports the coordinates as 29.1856° S, 27.0289° E and not as defined in the list.

South African Cities on GitHub: UPDATE – 3 June 2017

I have added the files to a GitHub repository. If you would like to add to the database, making it better, please grab it from GitHub and contribute.

Dirk Strauss
Dirk is a Software Developer and Microsoft MVP from South Africa. He loves all things Technology and is slightly addicted to Twitter and Jimi Hendrix. Apart from writing code, he also enjoys writing human readable articles. "I love sharing knowledge and connecting with people from around the world. It's the diversity that makes life so beautiful." Dirk feels very strongly that pizza is simply not complete without Tabasco, that you can never have too much garlic, and that cooking the perfect steak is an art he has yet to master.

Similar Articles

Fallback Image

CodeFluent Entities – A Tool For Developers by Developers

41045

Introducing Code Contracts – Writing Better Code

0917
  • nimbus

    Dirk my son . . .
    So pleased you decided to devote some time (don’t want to think how long) to this 🙂 Very pleased you beat me to it!!

    Thanks bud
    Ray

  • Marthinus Strydom

    Very nice Dirk. Well done and thanks for saving me from the agony….

  • Andrei

    duuuuuuuuuuuude! thank you so much!

    • Dirk Strauss

      You’re very welcome Andrei

  • me

    Wow, Awesome. well done and thanks for this list!!

  • Mandie

    You saved my life today, thank you for this list

    • Dirk Strauss

      You’re welcome Mandie 🙂

  • Stephen

    What a nice compilation. You are a life saver! Thanks

  • Tyron Adams

    Thank you very much Dirk, perhaps we can convert this dataset to a RESTful API. Will be really fun.

    • Hey Tyron. Yeah man, the list is yours to do with as you please. It’s scattered all over the Internet anyway. So if you create this RESTful API, tip your hat to this blog post in the release notes 😉

  • Mr Shizzing

    Thanks Mate

  • You sir, are a Legend!

  • Qwa qwa

    Hi Dirk,
    Thanks for the info. Can you add the suburbs to it ?

    Thx

    • Hey Qwa qwa. You’re free to download the database and add the suburbs to it (if they’re not included already). Remember to share with the community too 🙂

  • Charles Crous

    Thanx for the list Dirk! I’ll hopefully release a list with the suburb and postal code detail soon. As I’ve shared your pain in trying to get this info (which should be freely available!).

    I came across two possible errors
    Tweespruit | Free State | -27.9667 | 28.6
    Twee Spruit | Free State | -28.1333 | 28.68333

    I don’t know, so I’m deferring to Google its:
    Tweespruit | Free State | -29.1852 | 27.03189

    Source:
    https://www.google.co.za/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=Tweespruit+free+state+latitude+and+longitude

    • Hey Charles. Thank you for the comment. I definitely think that there will be errors. I also fully agree with you that this information should be freely available. When you release your list, let me know and I’ll link to it from this article. I believe that it would add tremendous value.

    • Andrew

      Charles any update on your list with suburb?

  • You are becoming my fav blogger 2nd solutions by dirkstrauss.com. Your are really aiming for legend status.

    • Thanks for the kind words Henzard 🙂
      And thank you for reading!

  • Thanks for the list Dirk!

  • Dewald Posthumus

    Hi Dirk,
    I can only see all the town starting with a “G”, am I missing something?

  • Dewald Posthumus

    Idjit me, sort the list!

  • Quinton

    Thanks Dirk, much appreciated.

    • You’re most welcome Quinton. Thanks for reading the blog 🙂

  • Ryno Coetzee

    Duisend Dankies!

  • Student

    Hi Dirk, i was wondering how you compiled this? i need to do a similar thing but based on areas within the cities for my university project. if you could explain it would be much appreciated.

    thank you

  • Donavan Lazarus

    Thank you kindly Dirk, this really helps

  • Marilyn Myburgh

    Morning, The file helps me very much. Does anyone perhaps have a file which includes the postal codes? Many thanks.

  • I will contact you via email.

    • Tommaso Sonno

      Hello Dirk, I find this extremely useful too. However, I would need the same exercise for all African countries, could you please contact me, so that I can understand the feasibility of this? Thanks a lot.

  • Leeroy Stander-Zeiler

    Thanks for this Dirk

  • Barry

    I love people who are always willing to help without the need to make a buck. Well done and thank you Dirk.

  • Thanks Dirk!! You da man!!

  • Shaun Overmeyer

    This is exactly what I am looking for. Are there updated links as these are dead.

    • Hi Shaun. Thank you for this. I will correct the links now.

    • Meanwhile, I have shared the files on Dropbox with you.

  • Baldwin D Jere

    Hi. Do you by any chance have the list of surburbs as well?

    • Hi. I don’t think the list is that granular. See if any of the downloads listed contain suburb information.

  • Exactly what I was looking for, thanks so so much Dirk! Now I can populate my MS SQL DB and continue with development 😀

  • Andrew

    Thanks Dirk! This looks like a winner! Would be great to have the Google Place ID of each item.

  • Nhlangano Chabalala

    Thank you so much Dirk.

  • I have not updated it since publishing. But postal codes don’t change too often.

  • Amanda Dominy

    Hi there – I was wondering how you defined the cities, etc? Because, for example, Grantham Park in KZN is a suburb in Empangeni, it’s not a town of its own? And Rugby, in the Western Cape, is also a suburb, not a town (it’s the suburb I live in)…

    • Hi Amanda. The list was compiled using various public resources scattered across the Internet (that I could find at the time). I spent a while pulling in all the data into a single list, so I would definitely expect there to be errors. I also didn’t have anything to compare it with, so I couldn’t check it for accuracy. I added the database to a GitHub repository https://github.com/dirkstrauss/SouthAfrica

      Please consider contributing to the database and help in making it better?

Top