{"id":569,"date":"2009-12-18T13:04:38","date_gmt":"2009-12-18T21:04:38","guid":{"rendered":"http:\/\/wellgolly.com\/?p=569"},"modified":"2010-02-17T13:23:36","modified_gmt":"2010-02-17T21:23:36","slug":"downloading-the-naco-afd","status":"publish","type":"post","link":"https:\/\/www.wellgolly.com\/?p=569","title":{"rendered":"Downloading the NACO A\/FD"},"content":{"rendered":"

NACO publishes terminal area charts and the Airport Facility Directory (A\/FD\u2014also known as the green book) and has an online version of the PDFs. The only obvious way to access them is through a map interface. The interface works fine for the terminal area charts but is broken for the A\/FD. It’s been broken for years and they don’t seem to have the expertise to fix it. The code is a bit convoluted and it’s on my list of things to decipher and fix. However, in the mean time I’ve provided a table by state to access the PDFs. It is located on the Touring Machine site at this link<\/a>. The page provides links to the PDFs that are located on the NACO site. The NACO site uses an XML file to determine the page in the AF\/D for each airport. Since XML is a very structured format, it is fairly straightforward to parse the file and convert it to useable HTML. The exact methods I’m using are specific to this file but the general process works on any XML file.<\/p>\n

The first step in the process is to read the XML file. The address is http:\/\/naco.faa.gov\/afd\/afd_17DEC2009.xml, where the date changes every 56 days. Your browser won’t display the xml, but if you view the source and save it you can begin working with it. The first couple of times through I used BBEdit to convert the XML to HTML tables. There aren’t too many steps, but it makes sense to automate the process. Any program that supports regular expressions could be used and I chose sed because I’m familiar with it. Make sure that the CR\/LF setting is changed to Unix or Mac<\/b> if you aren’t working on a Windows machine. Character encoding should probably be set to Western (ISO Latin 1), since that’s how it was originally encoded.
\n

\n#### Script to convert NACO A\/FD to HTML tables\n## Remove the first five lines of XML and creator information\n1,5d\n\n## The opening and closing tags aren't needed\n\/.*airports>\/d\n\n## Make each state a header tag\ns\/<location state="\/<h1>\/\n\n## Set up the table for each state\ns\/">\/<\\\/h1>\\\n<table width="100%" border="1"><tr><th>Airport Name<\\\/th><th>\nCity Name<\\\/th><th>ID<\\\/th><th>Navaid<\\\/th><th>pdf<\\\/th><\\\/tr>\/\n\n## Location is the demarcation for each state.\n## Close the table and put an End of State line for splitting\ns\/<\\\/location>\/<\\\/table>\\\nEOS\/g\n\n## Open and close the row for each airport or navaid\ns\/<airport>\/<tr>\/\ns\/<\\\/airport>\/<\\\/tr>\/\n\n## Replace each of the following with td> to open and close the columns\ns\/aptname>\/td>\/g\ns\/aptcity>\/td>\/g\ns\/aptid>\/td>\/g\ns\/navidname>\/td>\/g\n\n##The pdf tags are replaced with a link\ns\/<pdf>\/<td><a href="http:\\\/\\\/naco.faa.gov\\\/pdfs\\\/\/\ns\/<\\\/pdf>\/">pdf<\\\/a><\\\/td>\/\n\n## Change Tabs to spaces\ns\/  \/  \/g\n<\/pre><\/p>\n
Run this code on the raw XML file and then split it at the EOS line. I use a script to do it.
\n
\n#!\/bin\/bash\nFILENAME=NACO_17DEC2009_\nINDEX=1\nwhile read\ndo\n if [[ "$REPLY" = "EOS" ]]\n then\n  (( INDEX++ ))\n else\n  echo "$REPLY" >> \/Users\/username\/Desktop\/DEC\/$FILENAME$INDEX\n fi\ndone\n<\/pre><\/p>\n
You could modify it to take an argument but I just feed the input file to it.
\n
\n.\/SplitNaco.sh < afd_17DEC2009.xml.html\n<\/pre><\/p>\n
You can download the scripts from here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
NACO publishes terminal area charts and the Airport Facility Directory (A\/FD\u2014also known as the green book) and has an online version of the PDFs. The only obvious way to access them is through a map interface. The interface works fine for the terminal area charts but is broken for the A\/FD. It’s been broken for … Continue reading Downloading the NACO A\/FD<\/span><\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-569","post","type-post","status-publish","format-standard","hentry","category-coding"],"_links":{"self":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=569"}],"version-history":[{"count":0,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts\/569\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}