TechniSolve Software

Where in the world are you?

[ Up ] [ Wall Builder ] [ SolarAngles ] [ PeakLoad ] [ World Locations ]

We have compiled a large database containing climatic data suitable for airconditioning and refrigeration calculations.  We use this database extensively in all of our applications and provided it at NO COST as a service to the industry.  All we ask is that if you use the database you acknowledge us.

The purpose of this document is to explain how to reconfigure the database to suit your needs.

The record

Each data field contains the following information.

The Data Files

To speed up file access, we have split the world into regions.  This is where you may want to make some changes.

The regions that we selected is as follows:

+All, United States, Canada, South Africa and Africa.

"+All" is where we started.  This contains the whole world data and each sub-region is a different country.  However, in a big country like the USA, you would want to split the country into the States.  The United States therefore becomes a region and the sub-regions are each of the states.

Open the file Regions.idx to see how to make the split.

The Actual Data

Now, the source is stored in a Comma Separated Variable (csv) text file called WorldLocations.csv. Below is an extract from somewhere in the middle of the file.

101,1,Germiston,-26.22,28.17,30,1665,31.0,20.0,1.0,9.6,31.6,-1.6,10.4

101,1,Johannesburg,-26.13,28.23,30,1700,29.0,15.6,1.0,9.6,31.6,-1.6,10.4

101,1,Krugersdorp,-26.08,27.77,30,1699,31.0,20.0,1.0,9.6,31.6,-1.6,10.4

101,1,Lyttleton,-25.75,28.33,30,1402,32.0,12.0,2.0,9.6,32.0,-1.6,14.0

101,1,Pretoria,-25.73,28.18,30,1322,31.9,17.6,3.9,6.4,34.7,1.6,9.8

101,1,Vanderbijlpark,-26.67,27.82,30,1417,33.0,21.0,1.0,9.6,33.0,-1.6,10.4

101,1,Vereeniging,-26.65,27.92,30,1417,33.0,21.0,1.0,9.6,33.0,-1.6,10.4

101,2,Barberton,-25.78,31.05,30,852,34.0,23.0,10.0,9.6,34.0,-1.6,10.0

101,2,Carolina,-26.07,30.12,30,1690,29.0,19.0,-1.0,9.6,31.6,-1.6,13.0

101,2,Ermelo,-26.50,30.03,30,1675,29.0,19.0,-1.0,9.6,31.6,-1.6,13.0

101,2,Komatiepoort,-25.40,31.97,30,1077,38.0,24.5,1.0,9.6,38.0,-1.6,10.4

101,2,Lydenburg,-25.17,30.42,30,1470,29.0,20.0,-1.0,9.6,31.6,-1.6,14.0

So, if you plan to make split South Africa into provinces, you will need to find all lines starting

with 101.  This applies to South Africa in the countries section.  Now edit the second field in the

database to reflect the province.  Next, add the section in the regions.idx file as seen below.  

OK, we did this one for you but if you follow this format you will be able to split any of the

regions into sub-regions.

[South Africa]
+All=0
Gauteng=1

Mpumulanga=2

Limpopo=3

North Western Province=4

Kwazulu Natal=5

Free State=6

Western Cape=7

Eastern Cape=8

Northern Cape=9

and so on...

Building the Database

The program doesn't work directly on the text files, this would be too slow.  Instead, we build a file of records.  The advantage is data security and speed.  Each data line that we discussed above can now be read with one read statement from the program. For you to make these files, just press the Build button.

You will see a message showing how many records were created.

Viewing the data

Pressing the Test button will allow you to browse the database.

Here you can browse the complete database.

Disclaimer

We provide this database as is with no guarantees as to its accuracy.  If you find any errors, please let us know.

Acknowledgements

We are strong supporters of the work done by ASHRAE.  Consequently much of the information used in our applications come from the ASHRAE Handbooks.  For local country information, we did gather some info off the internet and local references.  This type of information is hard to get, so if you can suggest some references to your local conditions, we would be interested.

ASHRAE 2001 Fundamentals Handbook

Carrier System Design Manual, Australia

SAIRAC Data Manual