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

South African Cities And Provinces – A Complete List

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.

Google Maps Geocoding API Address Validator – 17 July 2017

I have created a small C# project that uses the free* Google API to validate an address. Check it out on GitHub.

* Free – Limited to 2,500 free requests per day.

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.
Top