PPRuNe Forums

PPRuNe Forums (https://www.pprune.org/)
-   Tech Log (https://www.pprune.org/tech-log-15/)
-   -   The database of RWs coordinates (https://www.pprune.org/tech-log/606961-database-rws-coordinates.html)

Patanom 24th Mar 2018 02:01

The database of RWs coordinates
 
Hello ,
Can anybody to send me files ( .dat; .csv) the runways of the world?
For exemple, I have got such file all airports of the world (.csv, the some strings) :

6753,"Mardin Airport","Mardin","Turkey","MQM","LTCR",37.223300933800004,4 0.6316986084,1729,3,"E","Europe/Istanbul","airport","OurAirports"
6754,"Sugraly Airport","Zarafshan","Uzbekistan","AFS","UTSN",41.6138992309 5703,64.23320007324219,1396,5,"U","Asia/Samarkand","airport","OurAirports"
6755,"Deering Airport","Deering","United States","DRG","PADE",66.0696029663,-162.76600647,21,-9,"A","America/Anchorage","airport","OurAirports"
6756,"Leon Airport","Leon","Spain","LEN","LELN",42.5890007019043,-5.65556001663208,3006,1,"E","Europe/Madrid","airport","OurAirports"
6757,"Burgos Airport","Burgos","Spain","RGS","LEBG",42.357601165771484,-3.620759963989258,2945,1,"E","Europe/Madrid","airport","OurAirports"
6758,"Sege Airport","Sege","Solomon Islands","EGM","AGGS",-8.578889846801758,157.87600708007812,0,11,"U","Pacific/Guadalcanal","airport","OurAirports"

DaveReidUK 24th Mar 2018 07:56

I've seen such files available, at a cost, from the principal nav/FMS data suppliers.

I'm not aware of any that are available (legally) for free.

ZFT 24th Mar 2018 08:23

As stated above, data is available in ARINC 424 format but you will need a subscription with one of the data providers and it isn't cheap.

It is typically priced by the record so a worldwide db would be quite costly

Skyjob 24th Mar 2018 11:08

This data can be found online as well with some research but is then not verified for accuracy.
Depending on your requirements, this may not be an issue.

For verified and up to date data the above posters are correct, it has to be paid for.

2014 last updated file, source unknown

aterpster 24th Mar 2018 13:57

For FAA airports runway and navaid data is publicly available in PDF format:

</title> <script src="/Scripts/jquery-1.10.2.js" type="text/javascript"></script> <script type="text/javascript"> // reference the Disclaimer http file // var httpURL = "/Content/Disclaimer.html"; // original code from Airnav 1 DMZ WebDatasheet, whic

Patanom 25th Mar 2018 04:50

1 Attachment(s)

Originally Posted by Skyjob (Post 10095148)
This data can be found online as well with some research but is then not verified for accuracy.
Depending on your requirements, this may not be an issue.

For verified and up to date data the above posters are correct, it has to be paid for.

2014 last updated file, source unknown

Thank you. I found such site:
Open data @ OurAirports
(runways , abt 3 Mbytes, may be open by Notepad)
The thresholds don't alignment with Google maps. I will try to check Europe Datum 1950.
For example, coordinates 54.1657,13.7602

236107,2205,"EDCM",3609,92,"CON",1,0,"03",51.2931,14.1232,49 5,34.1,,"21",51.3012,14.1321,495,214.1,
236108,2205,"EDCM",3609,131,"GRS",0,0,"03L",51.2934,14.1223, ,34.1,,"21R",51.3016,14.1312,,214.1,
259782,28656,"EDCN",2789,,"UNK",0,0,"11",,,110,,,"29",,,110, ,
236110,2206,"EDCO",4757,98,"ASP",0,0,"11",51.2699,10.6251,90 9,110,,"29",51.2655,10.6446,909,290,
236300,2207,"EDCP",7874,197,"CON",0,0,"13",54.1657,13.7602,7 ,137,,"31",54.1499,13.7852,7,317,
259729,28503,"EDCQ",3445,,"UNK",0,0,"11",,,525,,,"29",,,525, ,
259820,28712,"EDCS",3281,,"UNK",0,0,"10",,,164,,,"28",,,164, ,
269325,29069,"EDCT",1965,98,"Grass",0,0,"07",,,492,,,"25",,, 492,,
259799,28687,"EDCV",2953,,"UNK",0,0,"09",,,72,,,"27",,,72,,
323352,28762,"EDCW",2099,131,"Grass",0,0,"08",,,43,,,"26",,, 43,,
259808,28698,"EDCX",3609,,"grass",0,0,"04",,,66,,,"22",,,66, ,
236275,2208,"EDCY",6562,98,"CON",1,0,"04",51.5716,14.1306,37 5,36,,"22",51.5861,14.1476,375,216,

KRviator 25th Mar 2018 09:28

Not runways, but I have made databases of every Australian Certified airport, ALA & navaid available in CSV format, that are available from the Dynon forums HERE, that I will endeavour to keep current. Runway threshold data is available in *.PDF format in section 18 of ASA's DAH, available for download HERE, and 45 minutes with Excel will give you a similar CSV file with the runways.

Patanom 25th Mar 2018 14:36

1 Attachment(s)

Originally Posted by KRviator (Post 10096295)
Not runways, but I have made databases of every Australian Certified airport, ALA & navaid available in CSV format, that are available from the Dynon forums HERE, that I will endeavour to keep current. Runway threshold data is available in *.PDF format in section 18 of ASA's DAH, available for download HERE, and 45 minutes with Excel will give you a similar CSV file with the runways.

Thank you. I would like to know the threshold point of the runway. Why? There are many satellites arround the Earth, 3 navigational systems. But if somebody to try the "blind" landing by GPS/GLONASS/GALILEO only (w/o ILS) , it's the disaster.
The threshold (in Europe example) look like ED50 datum ( pic. in attachmemt). The latitude arc sec is constant (1852 m : 60 sec), but tne longitude arc sec is depended fm latitude, on 60 deg it is abt 1,5 less then on the equator.
I.e the transfomation coordinates (include altitude) are needed or no?

Patanom 25th Mar 2018 14:40

1 Attachment(s)
Europe ED50

DaveReidUK 25th Mar 2018 14:46


Originally Posted by Patanom (Post 10096568)
Thank you. I would like to know the threshold point of the runway. Why? There are many satellites arround the Earth, 3 navigational systems. But if somebody to try the "blind" landing by GPS/GLONASS/GALILEO only (w/o ILS) , it's the disaster.
The threshold (in Europe example) look like ED50 datum ( pic. in attachmemt). The latitude arc sec is constant (1852 m : 60 sec), but tne longitude arc sec is depended fm latitude, on 60 deg it is abt 1,5 less then on the equator.
I.e the transfomation coordinates (include altitude) are needed or no?

I'm not aware of any nav/FMS data providers that publish non-WGS84 data. I don't really see what the problem is.

Denti 25th Mar 2018 15:01


Thank you. I would like to know the threshold point of the runway. Why? There are many satellites arround the Earth, 3 navigational systems. But if somebody to try the "blind" landing by GPS/GLONASS/GALILEO only (w/o ILS) , it's the disaster.
GLS actually is CAT IIIb capable, but not approved so far. So blind landing with that is completely possible, and the best bit is, you do not need an onboard database for that as the approach geometry is broadcasted by the groundstation. Which is of course the downside of it, it requires a ground station.

KRviator 25th Mar 2018 20:26


Originally Posted by Patanom (Post 10096568)
Thank you. I would like to know the threshold point of the runway. Why? There are many satellites arround the Earth, 3 navigational systems. But if somebody to try the "blind" landing by GPS/GLONASS/GALILEO only (w/o ILS) , it's the disaster.
The threshold (in Europe example) look like ED50 datum ( pic. in attachmemt). The latitude arc sec is constant (1852 m : 60 sec), but tne longitude arc sec is depended fm latitude, on 60 deg it is abt 1,5 less then on the equator.
I.e the transfomation coordinates (include altitude) are needed or no?

IIRC, threshold data (or intersection data) is used by some FMS' to do a last-minute update to the IRS position prior to letting it navigate on its own.

DaveReidUK 25th Mar 2018 21:05


Originally Posted by KRviator (Post 10096868)
IIRC, threshold data (or intersection data) is used by some FMS' to do a last-minute update to the IRS position prior to letting it navigate on its own.

More typically that's done at the gate (most airports publish stand coordinates and/or display them where the crew can see them).

I guess that it's done more easily before you start moving, on the assumption that the IRS isn't going to drift too much on the taxy out.

KRviator 25th Mar 2018 21:20


Originally Posted by DaveReidUK (Post 10096900)
More typically that's done at the gate (most airports publish stand coordinates and/or display them where the crew can see them).

I guess that it's done more easily before you start moving, on the assumption that the IRS isn't going to drift too much on the taxy out.

The initial position is entered at the gate, true, but with some Airbus' and if GPS PRIMARY is not available, the FMS will update to the database threshold coordinates when takeoff thrust is applied - unless you get the gate position wrong, then all sorts of weird and wonderful things happen...Just ask AirAsia what happened out of Sydney a few years ago!

underfire 26th Mar 2018 12:02


GLS actually is CAT IIIb capable, but not approved so far. So blind landing with that is completely possible, and the best bit is, you do not need an onboard database for that as the approach geometry is broadcasted by the groundstation.
As noted, the signal does certainly qualify for CAT III autoland procedures.
While not approved for commercial, there are many military entities, including helo, that use GBAS CAT III autoland.

Markos. 26th Mar 2018 22:03

The problem here is not about the datum. It is about how you get the coordinates. You can’t just take them directly from the image on google earth. You need a precission GPS equipment certified, a corrected satellite image or other means of point designation like and Air to ground litening pod from a fighter aicraft.
This precission on the coordinates is measured by the TLE(Target Location Error) and it will let you know how precise are the coordinates you are getting.

wiedehopf 26th Mar 2018 22:23

anyone asking for data on a forum will not navigate with them i hope.

on the other hand the planes overlaid on the google images on flightradar24 seem to be in the right place. but maybe the google imagery isn't as accurate in every country.

DaveReidUK 26th Mar 2018 22:37


Originally Posted by wiedehopf (Post 10098168)
anyone asking for data on a forum will not navigate with them i hope.

I wouldn't have thought so.

Despite the OP's reference to the potential for disaster resulting from use of coordinates based on the wrong datum, I don't see that as a real-world problem. And even if it was, crowd-sourcing data wouldn't be a viable solution.

Patanom 26th Mar 2018 23:42

1 Attachment(s)

Originally Posted by DaveReidUK (Post 10098181)
I wouldn't have thought so.

Despite the OP's reference to the potential for disaster resulting from use of coordinates based on the wrong datum, I don't see that as a real-world problem. And even if it was, crowd-sourcing data wouldn't be a viable solution.

One question
When the coordinates was re-calculated from local datums to WGS84, may be coordinate Z (altitude) was omited ?
Usually is used the altitude from RA and barometric for the landing (1990's), but now DGPS altitude is used (the sentence $GPGGA , corrected WAAS etc).For example, handheld Garmin , we can choose more than 100 datums and the accuracy ,especially height, will better.

Patanom 13th Apr 2018 00:38

3 Attachment(s)
One more case - a helicopter MI-8 near Khabarovsk crashed, hooked on the stretches of the radio tower. Six men were killed.
The difference in coordinates (near the tower is 262 meters high) - more than 100 meters. Plus the difference in altitude is 35.6 meters.

May be, all the same it is necessary to change datum in other countries?

"Setup 1

In some areas outside of United States, datums other than WGS-84 or NAD-83 may be used.
If the GNS 430 is authorized for use by the appropriate Airworthiness authority, the required
geodetic datum must be set in the GNS 430 prior to its use for navigation."


All times are GMT. The time now is 23:04.


Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.