Airport Information Module V2 - Looking for Data

[stuartpb]

Some time ago, I released a module that added airport information pages to phpVMS, with the help of some other members. I'm looking to release version 2 within the next month, with more features. One of these I've already sorted out, and that's runway information, as shown below:

It's pretty basic at the moment, showing only the runway Idents, surfaces and lengths. I'm going to be adding elevations and whether they have runway lighting or not next. Not sure there is any other data I could include here?

I'm also adding NOTAMs and METARS with these ready to drop into the existing scripts.

What else would be worth adding though? I could add real world data, such as delays etc. Any suggestion would be welcome at this stage.

[Parkho]

Maybe you can include the NAV data such as ILS frequencies and VOR/DME and even some approach information, Approach/tower/ground frequencies and information like those.

[mischka]

A link to the charts maybe?

Also it would be nice to have some description field for the airport/city where you can do a little write-up as to where a pilot would want to fly there.

For example: Tivat Airport, also known as the "kai tak of Europe" is situated at the coast of Montenegro. It's southern approach to runway 32 has an offset ILS localizer (like in Innsbruck) leading through a narrow valley, with a steep turn at the end. etc etc.

[Jeff]

A link to the charts maybe?

The link to the charts can be linked to the Airport Chart module found in these forums.

[Nighthawk]

Ils Frqs and course would be fine

[Nighthawk]

Nothing new here?

[HighFlyerPL185]

I'm also wondering whether this addon is being still developed?

[stuartpb]

I've been busy with my part time university studies and work, so this project took a back seat for a long time. I started working on it again a couple of days ago though, and have made some progress. I've made the "find airports by country" form pull the data via ajax. A difference from the original. The data I have being used for the module is:

Basic Airport Info (ICAO, lat & lng, country)

I can add an airport description easily enough. For me, it isn't going to me used, as I have over 30,000 airports in my database, and I can't find a good data source I could use to pull the descriptions from. I'm not going to be manually adding that much data myself, but I will build the description in to the module for anyone to use.

Flights info

Latest flights from and to the airport, and total arrivals and departures. May expand on this to show most used by pilots etc.

Runways

Basic info is shown for each runway, including surface, heading, length, width and elevation. It also shows if the runway is lit and the displaced threshold if any. I'm going to be creating a visual representation of the runways for each airport. I lost the work I had done previously so I have to start from scratch on that.

Radio Frequencies

If the airport has radio, the frequencies will be listed.

NOTAMs

The four latest NOTAMs will be displayed, if there are any available.

METAR

The latest METAR will be displayed if available, with a description too.

I'm looking around for ILS data I can use, if anyone knows of a reliable data source that's freely available, let me know and I can sort that out. I'm going to be working on this over the next couple of weeks, so don't expect this to be released straight away.

Any other suggestions for this module would be welcomed. For a sneak peek at where I am now, and to see how things are progressing, you can visit the airport info pages on my development site:

http://aroundtheworl...ex.php/airports

Cheers,

Stuart

I forgot to mention, if you take a look at the work in progress, some of the data for the airports is incomplete in my database. There are over 30,000 airports, and some don't have much data at all. If you come across an airport with little information, odds are that it's not a major airport. Try going for a big international airport instead.

[FSX30HD]

I can make an XML file with MakeRunways of Peter Dowson

MakeRwys is a simple utility which extracts sleected airport data from active scenery, basing its scan on the active SCENERY.CFG file. It produces data files for all versions of Radar Contact, for FStarRC, and for several other programs. It is suitable for FS2002, FS2004 and FSX.

Documentation of the CSV data files produced is now included in the Read Me., inside the ZIP. The program is free for anyone to use as necessary to support their own data needs, as well as users of the mentioned programs. January 28th 2014

Give you that :

<ICAO id="LFPG">
<ICAOName>Charles-de-Gaulle</ICAOName>
<Country>France</Country>
<State></State>
<City>Paris</City>
<Longitude>2.547778</Longitude>
<Latitude>49.009724</Latitude>
<Altitude>392</Altitude>
<MagVar>-2.000</MagVar>
<Runway id="08L">
<Len>13944</Len>
<Hdg>87.350</Hdg>
<Def>Macadam</Def>
<ILSFreq>108.70</ILSFreq>
<ILSHdg>87.30</ILSHdg>
<ILSid>GLE</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>48.995686</Lat>
<Lon>2.552631</Lon>
<FSStartLat>48.995777</FSStartLat>
<FSStartLon>2.554275</FSStartLon>
<ClosedLanding>TRUE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="08R">
<Len>8832</Len>
<Hdg>87.350</Hdg>
<Def>Concrete</Def>
<ILSFreq>108.55</ILSFreq>
<ILSHdg>87.30</ILSHdg>
<ILSid>DSE</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>48.992916</Lat>
<Lon>2.565580</Lon>
<FSStartLat>48.992947</FSStartLat>
<FSStartLon>2.566115</FSStartLon>
<ClosedLanding>FALSE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="09L">
<Len>8840</Len>
<Hdg>87.350</Hdg>
<Def>Tarmac</Def>
<ILSFreq>109.35</ILSFreq>
<ILSHdg>87.30</ILSHdg>
<ILSid>PNE</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>49.024704</Lat>
<Lon>2.524823</Lon>
<FSStartLat>49.024773</FSStartLat>
<FSStartLon>2.525766</FSStartLon>
<ClosedLanding>FALSE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="09R">
<Len>13780</Len>
<Hdg>87.350</Hdg>
<Def>Macadam</Def>
<ILSFreq>110.10</ILSFreq>
<ILSHdg>87.30</ILSHdg>
<ILSid>CGE</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>49.020611</Lat>
<Lon>2.512920</Lon>
<FSStartLat>49.020664</FSStartLat>
<FSStartLon>2.514065</FSStartLon>
<ClosedLanding>TRUE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="26L">
<Len>8832</Len>
<Hdg>267.350</Hdg>
<Def>Concrete</Def>
<ILSFreq>108.35</ILSFreq>
<ILSHdg>267.3</ILSHdg>
<ILSid>DSU</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>48.994877</Lat>
<Lon>2.602380</Lon>
<FSStartLat>48.994820</FSStartLat>
<FSStartLon>2.601723</FSStartLon>
<ClosedLanding>FALSE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="26R">
<Len>13944</Len>
<Hdg>267.350</Hdg>
<Def>Macadam</Def>
<ILSFreq>109.10</ILSFreq>
<ILSHdg>267.3</ILSHdg>
<ILSid>GAU</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>48.998783</Lat>
<Lon>2.610736</Lon>
<FSStartLat>48.998676</FSStartLat>
<FSStartLon>2.608975</FSStartLon>
<ClosedLanding>TRUE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="27L">
<Len>13780</Len>
<Hdg>267.350</Hdg>
<Def>Macadam</Def>
<ILSFreq>110.70</ILSFreq>
<ILSHdg>267.3</ILSHdg>
<ILSid>CGW</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>49.023678</Lat>
<Lon>2.570370</Lon>
<FSStartLat>49.022110</FSStartLat>
<FSStartLon>2.562932</FSStartLon>
<ClosedLanding>TRUE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
<Runway id="27R">
<Len>8840</Len>
<Hdg>267.350</Hdg>
<Def>Tarmac</Def>
<ILSFreq>110.35</ILSFreq>
<ILSHdg>267.3</ILSHdg>
<ILSid>PNW</ILSid>
<ILSslope>3.00</ILSslope>
<Lat>49.026672</Lat>
<Lon>2.561681</Lon>
<FSStartLat>49.026646</FSStartLat>
<FSStartLon>2.561236</FSStartLon>
<ClosedLanding>FALSE</ClosedLanding>
<ClosedTakeoff>FALSE</ClosedTakeoff>
<EdgeLights>NONE</EdgeLights>
<CenterLights>NONE</CenterLights>
<CenterRed>FALSE</CenterRed>
</Runway>
</ICAO>

But after that no idea to parse this file

Best Regards Fred

[Felipe]

NOTAMs

The four latest NOTAMs will be displayed, if there are any available.

I was about to ask it. But... how about all available ones? If possible, of course...