Download our "Postcode database South Africa" and enhance your website / software with a Postcode radius search capability.
All of our databases contain longitude and latitude for each location + free source code for PHP/ MySQL and ASP / MS SQL-Server and many more...
Our products
- UK Postcode Database
- USA/Canada ZIPCode Database
- Germany Postcode Database
- Austria Postcode Database
- Switzerland Postcode Database
- BeNeLux Postcode Database
- France Postcode Database
- Italy Postcode Database
- Spain Postcode Database
- Greece Postcode Database
- Scandinavia Postcode Database
- Australia / NZ Postcode Database
- South Africa Postcode Database
- Europe Postcode Database
- Japan ZIP Codes Database
- Korea ZIP Codes Database
- Japan ZIP Codes Database
- Korea ZIP Codes Database
- World Postcode Database
- Free Postcode Radius Search Scripts
- Distances between postcodes
- Postcodes within a Radius
Testimonials
"...It has been our privilege to use your product and reap out the vast benefit it has given us in establishing a dealer locator on our web portals.
The customers are finding us in their nearest location in an easy way, and it has helped us to increase the sales rate incredibly..."
Daniel Braafheid, Cape Town, South Africa
"...We cordially thank you for your effort that you have made in your product and provided us a cost-effective and time-saving solution to establish a successful search portal.
Through this search portal, interested real estate dealers are finding us a lot easier and praising us for our effective customer support..."
David Nichols, Durban, South Africa
"...After a long time, we have been able to find the right service for the localized search in our wedding service partner website,
and that has been only possible through your great effort. We cordially thank you for the database and scripts and the benefits you have included in it..."
Joshua Kruger, Johannesburg, South Africa
Send your testimonial
South Africa Postcode Database
Product details and Download
Postcode Database South AfricaSingle LicenseBuy now... 99 £ Includes free lifetime updates!Enterprise LicenseBuy now... 199 £ Includes free lifetime updates! |
|
Details (Data of: September 2024)
The South Africa postcode database contains all South Africa Postcodes plus city and regions plus latitude/longitude.
Database content
South Africa | |
Areas | 5 |
Regions | 10 |
Cities | 952 |
Postcodes | 3266 |
Geocoded Postcodes | 100 % |
Number of records | 3920 |
Available formats:
Comma Separated Values (CSV) ~280 KB ZIP-compressed MySQL dump (SQL) ~280 KB ZIP-compressed MS SQL Server dump (SQL) ~280 KB ZIP-compressed Oracle dump (SQL) ~280 KB ZIP-compressed Postgre SQL Dump (SQL) ~280 KB ZIP-compressed Sybase SQL Dump (SQL) ~280 KB ZIP-compressed Miscroft Excel (XLS) ~280 KB ZIP-compressed Microsoft Access (MDB) ~400 KB ZIP-compressed
Easy to import into all major Database Systems.
Datatable structure
countrycode | varchar(2) |
postcode | varchar(4) |
city | varchar(48) |
area | varchar(48) |
region | varchar(48) |
latitude | decimal(13, 9) |
longitude | decimal(13, 9) |
Programming
Having a database of localities with their latitudes and longitudes enables you to locate the closest cities to a set point (or within a radius of X).
To help you to successfully implement a postcode radius / distance search we offer free access to example codes in many scripting and programming languages like ASP, PHP, Coldfusion...
To achieve the highest accuracy the formulas in our example scripts take the earth's curvature into consideration.
Test the capabilities of our scripts with your own postcode:
More information about the programming...
Delivery
Internet Download
Sample Data
countrycode;postcode;city;area;region;latitude;longitude
ZA;9800;PAUL ROUX;Central Region;Free State;-28.3005178;27.95051148
ZA;9810;REITZ;Central Region;Free State;-27.8006894;28.43403844
ZA;9820;TWEELING;Central Region;Free State;-27.5503002;28.51697753
ZA;9830;FRANKFORT;Central Region;Free State;-27.2854204;28.50218025
ZA;9835;VREDE;Central Region;Free State;-27.4172589;29.16729670
ZA;9840;VILLIERS;Central Region;Free State;-27.0345822;28.60132131
ZA;9850;CORNELIA;Central Region;Free State;-23.7176960;29.13459768
ZA;9850;VREDE;Central Region;Free State;-23.7178596;29.13479870
ZA;9860;KESTELL;Central Region;Free State;-28.3194190;28.70278964
ZA;9866;PHUTHADITJHABA;Central Region;Free State;-28.5344717;28.81781648
ZA;9868;WITSIESHOEK;Central Region;Free State;-28.5351052;28.80178847
ZA;9869;MOKODUMELA;Central Region;Free State;-28.5351537;28.80183744
ZA;9869;PHUTHADITJHABA;Central Region;Free State;-28.5334987;28.80016703
ZA;9869;WITSIESHOEK;Central Region;Free State;-28.5334616;28.80012960
ZA;9870;WITSIESHOEK;Central Region;Free State;-28.5346486;28.80132768
ZA;9873;DIKGAKENG;Central Region;Free State;-28.5352136;28.80189792
ZA;9875;WITSIESHOEK;Central Region;Free State;-28.5351936;28.80187776
ZA;9877;WITSIESHOEK;Central Region;Free State;-28.5337441;28.80041472
ZA;9878;WITSIESHOEK;Central Region;Free State;-28.5334017;28.80006912
ZA;9880;HARRISMITH;Central Region;Free State;-28.2844702;29.13450445
ZA;9882;HARRISMITH;Central Region;Free State;-28.2849624;29.13501137
ZA;9883;HARRISMITH;Central Region;Free State;-28.2848747;29.13492106
ZA;9885;HARRISMITH;Central Region;Free State;-28.2854008;29.13546294
ZA;9890;WARDEN;Central Region;Free State;-27.8524201;28.96918390
ZA;9904;REDDERSBURG;Central Region;Free State;-29.6506641;26.16725283
ZA;9908;EDENBURG;Central Region;Free State;-29.7344423;25.93430061
ZA;9913;TROMPSBURG;Central Region;Free State;-30.0342883;25.78415320
ZA;9917;SPRINGFONTEIN;Central Region;Free State;-30.2668452;25.70015163
ZA;9922;COLESBERG;Central Region;Free State;-30.7351588;25.10149094
ZA;9928;BLOEMFONTEIN;Central Region;Free State;-29.1360281;26.20242349
ZA;9932;PETRUSBURG;Central Region;Free State;-29.1184282;25.41820440
ZA;9936;PETRUSBURG;Central Region;Free State;-29.1194939;25.41913465
ZA;9940;DEWETSDORP;Central Region;Free State;-29.5853656;26.66849870
ZA;9944;WEPENER;Central Region;Free State;-29.7339249;27.03387126
ZA;9945;ZASTRON;Central Region;Free State;-30.3015301;27.08470100
ZA;9950;ZASTRON;Central Region;Free State;-30.3018392;27.08497725
ZA;9951;ZASTRON;Central Region;Free State;-30.3015271;27.08469829
ZA;9958;FREE STATE;Central Region;Free State;-30.4187441;26.83516601
ZA;9958;ROUXVILLE;Central Region;Free State;-30.4172628;26.83385923
ZA;9966;SMITHFIELD;Central Region;Free State;-30.2195856;26.53589641
ZA;9970;PHILIPPOLIS;Central Region;Free State;-30.2667968;25.28344201
ZA;9974;JAGERSFONTEIN;Central Region;Free State;-29.7693933;25.41899486
ZA;9978;FAURESMITH;Central Region;Free State;-29.7517373;25.31814519
ZA;9982;LUCKHOFF;Central Region;Free State;-29.7501427;24.78345225
ZA;9986;KOFFIEFONTEIN;Central Region;Free State;-29.4024578;25.01875809
ZA;9986;LUCKHOFF;Central Region;Free State;-29.4008996;25.01743221
ZA;9987;KOFFIEFONTEIN;Central Region;Free State;-29.4006144;25.01718954
ZA;9992;BETHULIE;Central Region;Free State;-30.5359377;21.28514876
ZA;9800;PAUL ROUX;Central Region;Free State;-28.3005178;27.95051148
ZA;9810;REITZ;Central Region;Free State;-27.8006894;28.43403844
ZA;9820;TWEELING;Central Region;Free State;-27.5503002;28.51697753
ZA;9830;FRANKFORT;Central Region;Free State;-27.2854204;28.50218025
ZA;9835;VREDE;Central Region;Free State;-27.4172589;29.16729670
ZA;9840;VILLIERS;Central Region;Free State;-27.0345822;28.60132131
ZA;9850;CORNELIA;Central Region;Free State;-23.7176960;29.13459768
ZA;9850;VREDE;Central Region;Free State;-23.7178596;29.13479870
ZA;9860;KESTELL;Central Region;Free State;-28.3194190;28.70278964
ZA;9866;PHUTHADITJHABA;Central Region;Free State;-28.5344717;28.81781648
ZA;9868;WITSIESHOEK;Central Region;Free State;-28.5351052;28.80178847
ZA;9869;MOKODUMELA;Central Region;Free State;-28.5351537;28.80183744
ZA;9869;PHUTHADITJHABA;Central Region;Free State;-28.5334987;28.80016703
ZA;9869;WITSIESHOEK;Central Region;Free State;-28.5334616;28.80012960
ZA;9870;WITSIESHOEK;Central Region;Free State;-28.5346486;28.80132768
ZA;9873;DIKGAKENG;Central Region;Free State;-28.5352136;28.80189792
ZA;9875;WITSIESHOEK;Central Region;Free State;-28.5351936;28.80187776
ZA;9877;WITSIESHOEK;Central Region;Free State;-28.5337441;28.80041472
ZA;9878;WITSIESHOEK;Central Region;Free State;-28.5334017;28.80006912
ZA;9880;HARRISMITH;Central Region;Free State;-28.2844702;29.13450445
ZA;9882;HARRISMITH;Central Region;Free State;-28.2849624;29.13501137
ZA;9883;HARRISMITH;Central Region;Free State;-28.2848747;29.13492106
ZA;9885;HARRISMITH;Central Region;Free State;-28.2854008;29.13546294
ZA;9890;WARDEN;Central Region;Free State;-27.8524201;28.96918390
ZA;9904;REDDERSBURG;Central Region;Free State;-29.6506641;26.16725283
ZA;9908;EDENBURG;Central Region;Free State;-29.7344423;25.93430061
ZA;9913;TROMPSBURG;Central Region;Free State;-30.0342883;25.78415320
ZA;9917;SPRINGFONTEIN;Central Region;Free State;-30.2668452;25.70015163
ZA;9922;COLESBERG;Central Region;Free State;-30.7351588;25.10149094
ZA;9928;BLOEMFONTEIN;Central Region;Free State;-29.1360281;26.20242349
ZA;9932;PETRUSBURG;Central Region;Free State;-29.1184282;25.41820440
ZA;9936;PETRUSBURG;Central Region;Free State;-29.1194939;25.41913465
ZA;9940;DEWETSDORP;Central Region;Free State;-29.5853656;26.66849870
ZA;9944;WEPENER;Central Region;Free State;-29.7339249;27.03387126
ZA;9945;ZASTRON;Central Region;Free State;-30.3015301;27.08470100
ZA;9950;ZASTRON;Central Region;Free State;-30.3018392;27.08497725
ZA;9951;ZASTRON;Central Region;Free State;-30.3015271;27.08469829
ZA;9958;FREE STATE;Central Region;Free State;-30.4187441;26.83516601
ZA;9958;ROUXVILLE;Central Region;Free State;-30.4172628;26.83385923
ZA;9966;SMITHFIELD;Central Region;Free State;-30.2195856;26.53589641
ZA;9970;PHILIPPOLIS;Central Region;Free State;-30.2667968;25.28344201
ZA;9974;JAGERSFONTEIN;Central Region;Free State;-29.7693933;25.41899486
ZA;9978;FAURESMITH;Central Region;Free State;-29.7517373;25.31814519
ZA;9982;LUCKHOFF;Central Region;Free State;-29.7501427;24.78345225
ZA;9986;KOFFIEFONTEIN;Central Region;Free State;-29.4024578;25.01875809
ZA;9986;LUCKHOFF;Central Region;Free State;-29.4008996;25.01743221
ZA;9987;KOFFIEFONTEIN;Central Region;Free State;-29.4006144;25.01718954
ZA;9992;BETHULIE;Central Region;Free State;-30.5359377;21.28514876
Other products
From 599 £ | From 999 £ | Free |