The database of RWs coordinates

[Patanom]

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]

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]

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]

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]

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]

Originally Posted by Skyjob

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]

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]

Originally Posted by KRviator

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]

Europe ED50

[DaveReidUK]

Originally Posted by Patanom

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]

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]

Originally Posted by Patanom

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]

Originally Posted by KRviator

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]

Originally Posted by DaveReidUK

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]

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.]

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]

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]

Originally Posted by wiedehopf

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]

Originally Posted by DaveReidUK

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]

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."