It has been XY years since I have done any maths involving TAN etc. So please help. If I know the coordinates of the start and end of the runway, eg
27°49'49.01"E 33° 1'51.81"S
27°49'14.31"E 33° 2'31.45"S
how do I calculate the runway numbers?
I know it will be something like
Degrees = TAN (y1-y2/x1-x2) + 02
In Excel?
The idea is to look up the runway coordinates on google and then know the runway numbers....
Runway Numbers
- gertcoetzee
- Frequent Flyer
- Posts: 1303
- Joined: Mon May 23, 2005 1:01 pm
- Location: Cape Town
- Contact:
Distance : 1.519 km
Bearing :216°16′23″ from first co-ord to second
216deg + mag var 26W = 242 = RWY 06/24
______________________________________________
Distance
R = earth’s radius (mean radius = 6,371km)
Δlat = lat2− lat1
Δlong = long2− long1
a = sin²(Δlat/2) + cos(lat1).cos(lat2).sin²(Δlong/2)
c = 2.atan2(√a, √(1−a))
d = R.c
Bearing
Formula: θ = atan2(sin(Δlong).cos(lat2),
cos(lat1).sin(lat2) − sin(lat1).cos(lat2).cos(Δlong) )
what ever :D

Bearing :216°16′23″ from first co-ord to second
216deg + mag var 26W = 242 = RWY 06/24
______________________________________________
Distance
R = earth’s radius (mean radius = 6,371km)
Δlat = lat2− lat1
Δlong = long2− long1
a = sin²(Δlat/2) + cos(lat1).cos(lat2).sin²(Δlong/2)
c = 2.atan2(√a, √(1−a))
d = R.c
Bearing
Formula: θ = atan2(sin(Δlong).cos(lat2),
cos(lat1).sin(lat2) − sin(lat1).cos(lat2).cos(Δlong) )



Last edited by cobra on Wed Sep 05, 2007 5:41 am, edited 2 times in total.
Aerotrike Cobra
-
- Learning to fly
- Posts: 63
- Joined: Mon Jun 12, 2006 8:08 pm
- Location: Stellenbosch
- John Young
- The Boss
- Posts: 1973
- Joined: Tue May 24, 2005 8:38 am
- Location: Jacksonville, Florida, USA
Add west to true to get magnetic
Hi Gert,andrepieterse wrote:Remember to take variation into account as runway headings are magnetic.
Yip, for our SA condx., add the west variation to true to get magnetic.
The main runway shown here is 06 / 24. You will see it as approx. 45° true.
For info, in Durbs magnetic variation is 23º W.
Variation decreases towards north up to the equator and increases towards south.
Regards
John ZU-CIB
You do not have the required permissions to view the files attached to this post.
- Biggles
- Pilot in Command
- Posts: 770
- Joined: Wed Nov 02, 2005 12:29 pm
- Location: Cape Town/ Namibia
- Contact:
Just remember that magnetic declination varies with time. So while the magnetic bearing is 26o now it might have been different when the field was built. I belive they have renumbered runways in the past because the runway number was now far off the magnetic bearing.
So all in all call a local.
So all in all call a local.
Trike pilot
Aerotrike Cobra
ZU-DLP
Winelands FAWN
Aerotrike Cobra
ZU-DLP
Winelands FAWN
- John Young
- The Boss
- Posts: 1973
- Joined: Tue May 24, 2005 8:38 am
- Location: Jacksonville, Florida, USA
Not enough to worry me in this lifetime.
Hi Biggles,Biggles wrote:Just remember that magnetic declination varies with time. So while the magnetic bearing is 26o now it might have been different when the field was built. I belive they have renumbered runways in the past because the runway number was now far off the magnetic bearing.
Depending on area, the magnetic variation will slowly and progressively change by 1° every 40 to 120 years.
Not enough to worry me in this lifetime.

This is normally shown at the bottom of the chart.
Regards
John ZU-CIB
Who is online
Users browsing this forum: No registered users and 1 guest