Airnav...
- Thread starter jesse
- Start date
jesse
Touchdown! Greaser!
Found it. A bunch of really big ass excel files. Typical of the government. Wouldn't want to provide information in an actual database.
Time to go write some code to take this and dump it into something useful.
Time to go write some code to take this and dump it into something useful.
Areeda
Pattern Altitude
Where did you find it?
LOL! Jesse!jangell said:
The ATA100 data are fixed length delimited format ASCII data files, all in upper case. The guvmint is still using big iron and COBOL, son.
http://www.faa.gov/ATS/ata/ata100/120/stdatafiles.html
I'm surprised you found a version that Excel can grok, although Excel can read comma delimited files. Just because you can open the file in Excel doesn't mean it's an excel file. We had text files before Word was written, too.
It's available from the FAA on CD and it appears there that subscribers can FTP some subset of it. Some kind souls zip and host the files on the CD:
Here ya go:
http://data.pilotage.com/software/cd_faa Note the message: It is requested that you download these files after 10:00 PM and before 7:00 AM Pacific Time. Please do not transfer files between 7:00AM to 10:00PM. Thank You.
The first file has a data dictionary describing the layout. I think you can get it from the FAA site above. Now you know where airnav gets the data. He massages things like the text case with Perl.
Now excuse me while I visit a Mosiac page.
Last edited:
jesse
Touchdown! Greaser!
mikea said:LOL! Jesse!
The ATA100 data are fixed length delimited format ASCII data files, all in upper case. The guvmint is still using big iron and COBOL, son.
http://www.faa.gov/ATS/ata/ata100/120/stdatafiles.html
I'm surprised you found a version that Excel can grok, although Excel can read comma delimited files. Just because you can open the file in Excel doesn't mean it's an excel file. We had text files before Word was written, too.
It's available from the FAA on CD and it appears there that subscribers can FTP some subset of it. Some kind souls zip and host the files on the CD:
Here ya go:
http://data.pilotage.com/software/cd_faa Note the message: It is requested that you download these files after 10:00 PM and before 7:00 AM Pacific Time. Please do not transfer files between 7:00AM to 10:00PM. Thank You.
The first file has a data dictionary describing the layout. I think you can get it from the FAA site above. Now you know where airnav gets the data. He massages things like the text case with Perl.
Now excuse me while I visit a Mosiac page.
Smartass. I'm not an idiot.
This is what I found:
http://www.faa.gov/airports_airtraffic/airports/airport_safety/airportdata_5010/menu/index.cfm#datadownloads
Notice the .xls extension ... last I checked .xls means Excel.
Microsoft Excel formatted text file containing airport facilities information. *
To learn more about XLS and Excel please see:
http://en.wikipedia.org/wiki/Xls
How do you know he uses Perl? Personally I'm just going to write a php script to dump the data into a mySQL database where I can further manipulate it.
Last edited:
etsisk
En-Route
Nice attitude, there, Jesse. 
Well, partly it was me ASSuming that he had found the ATA-100 data and thinking it was comman seperated. You forgot details in old age.tdager said:
Still I can't see on page whatever they have in Excel format. The link doesn't work. The feds have no business issuing public data in a proprietary format.
jesse
Touchdown! Greaser!
mikea said:
http://www.faa.gov/airports_airtraffic/airports/airport_safety/airportdata_5010/
Click Submit..and be prepared to download an Excel file that has like 26,000 rows.
Last edited:
etsisk
En-Route
Well, don't let it happen again and MAYBE you can use the truck this weekend . . .jangell said:
Yep. The only reason OpenOffice and others can read Excel and Word files is because they reverse engineered the format. Microsoft has never documented it. I understand that Word files actually have a copy of part of the PC's memory footprint in them.SCCutler said:
It's an arms race where Microsoft keeps adding new features to stay ahead. What that means ironically is that Microsoft's own older programs can't fully read and write the formats. That's also by design. They never seem to get "save as" old format or the translator utilities working right, so in the meantime why don't you just upgrade the whole company to the new version of Office? The sad thing is that works - every time.
There is a movement for the Open Document format which is pure XML.
http://en.wikipedia.org/wiki/OpenDocument
Microsoft is making the new Office formats be XML but they're trying to put propreitary extensions into it.
Many U.S. and world governemnts are writing open doc into law but Microsoft hits them with money and FUD to stop it. The CTO of Massachusetts ended up being eased out after a lot of pressure was bought to bear when he pushed OpenDocument for all government files. In the end OpenDocument was made law anyway.
Areeda
Pattern Altitude
I haven't had a chance to check this document out yet. I'm in ATL waiting for a flight that's 3 hrs late so far.
I do know that if you have a big html table and put an xls extension on it Excel will open it as if it were a spreadsheet.
Joe
I do know that if you have a big html table and put an xls extension on it Excel will open it as if it were a spreadsheet.
Joe
jdwatson
Line Up and Wait
Maybe try this link:
http://www.ngs.noaa.gov/AERO/UDDFdat.htm
http://www.ngs.noaa.gov/AERO/UDDFdat.htm
harish
Filing Flight Plan
jangell said:
Should take a little while to execute that foreach!
If you could make this a nice web service (xml style), I would greatly appreciate it. I'm a bit lazy and like having resources