Jump to content

Archived

This topic is now archived and is closed to further replies.

Thorsden

Runway Lengths

Recommended Posts

Hi

 

I hope that I'm posting in an appropriate forum.

 

I'm building a simple web page to display airport information when I input an ICAO  code.

 

I can't get the runway lengths out of the world data database. I suspect that it needs calculating by adding together a selection of individual items to produce the whole, but it's beyond me at the moment.

 

Can anyone point me in the right direction of what data I need to extract, filter and add to get this figure?

 

Many thanks

 

Bob

Share this post


Link to post
Share on other sites

Hi

 

I've found the answer in using Great Circle calculations and the co-ordinates for tthe ends of the runways included in the data file.

 

Even on short runways using a simple pythagorus triangle solution add in too many errors.

 

The formula in Excel is

 

=ACOS(COS(RADIANS(90-A2)) *COS(RADIANS(90-A3)) +SIN(RADIANS(90-A2)) *SIN(RADIANS(90-A3)) *COS(RADIANS(B2-B3))) *6371

Co-ordinates in A2,B2 and A3,B3

 

Thanks to BLueMM for the answer. Multiply this result by 1000 to convert to metres in length.

 

This formula gives a 2m error on the published length of Heathrows 3904m runway using the data in the current airport data file.

 

Bob

Share this post


Link to post
Share on other sites

  • Tom Allensworth,
    Founder of AVSIM Online


  • Flight Simulation's Premier Resource!

    AVSIM is a free service to the flight simulation community. AVSIM is staffed completely by volunteers and all funds donated to AVSIM go directly back to supporting the community. Your donation here helps to pay our bandwidth costs, emergency funding, and other general costs that crop up from time to time. Thank you for your support!

    Click here for more information and to see all donations year to date.
  • Donation Goals

    AVSIM's 2020 Fundraising Goal

    Donate to our annual general fundraising goal. This donation keeps our doors open and providing you service 24 x 7 x 365. Your donation here helps to pay our bandwidth costs, emergency funding, and other general costs that crop up from time to time. We reset this goal every new year for the following year's goal.


    39%
    $9,915.00 of $25,000.00 Donate Now
×
×
  • Create New...