TechniSolve Software

Software for the air conditioning, ventilation and refrigeration industry

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.

If you plan to make updates, please pass on the changes to us so that we can update our source.

The record

Each data field contains the following information.

Latitude

Angle North in degrees, North is positive, South is negative

Longitude

Angle West of Greenwich.  East is positive, West is negative

Time Zone

Angle West of Greenwich.  East is positive, West is negative

Altitude

Height above sea level in metre

Cooling DB

Dry bulb for typical aircon cooling calculations in degree C

Cooling WB

Wet bulb for typical aircon cooling calculations in degree C

Heating DB

Dry bulb for heating calculations in degree C

Wind Speed

Average wind speed in m/s

Max DryBulb

Maximum dry bulb for coldroom wall calculations in degree C

Min DryBulb

Minimum dry bulb for heating calculations in degree C

DB Range

Daily dry bulb range in degree C

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.

 

 

 world locations editor

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.

world locations viewer

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