8
$\begingroup$

It appears that the FAA, in its infinite wisdom, has removed the HTML version of the P/CG (pilot/controller glossary) and all the links that I and others have used are now dead. Example: http://www.faa.gov/air_traffic/publications/atpubs/pcg/F.HTM

As far as I can find out, the P/CG is now only available as a PDF. Leaving aside the rights and wrongs of that decision for now, how do we handle all the dead links? Can someone do a mass update to point all existing links at the new URL?

$\endgroup$
4
  • 1
    $\begingroup$ …What does FAA stand for? $\endgroup$
    – voretaq7
    Apr 7 '15 at 19:22
  • 3
    $\begingroup$ @voretaq7 I would suggest something, but this is a family website... $\endgroup$
    – Pondlife
    Apr 7 '15 at 23:31
  • $\begingroup$ If the html comes back, it might be nice to link to both. $\endgroup$ Apr 11 '15 at 21:28
  • $\begingroup$ We could update all of the links to point to the Internet Wayback Machine. :) $\endgroup$
    – reirab
    Apr 13 '15 at 4:20
5
$\begingroup$

Running the following query on data, I found that only a handful of posts have used this URL (http://www.faa.gov/air_traffic/publications/atpubs/pcg/). Please note that I am not including HTML page.

select
  pt.Name as PostType,
  p.CreationDate,
  u.DisplayName as PostWrittenBy,
  p.Body
from Posts p
join PostTypes pt
  on p.PostTypeId = pt.Id
join Users u
  on p.OwnerUserId = u.Id
where p.Body like '%http://www.faa.gov/air_traffic/publications/atpubs/pcg/%'
order by p.CreationDate asc

Since there are not many references of it, this task can be done manually by editing each post. But I am up for other suggestions.

$\endgroup$
5
  • $\begingroup$ Nice query! I had no idea if there were a lot of links or a few, this is good to know $\endgroup$
    – Pondlife
    Apr 7 '15 at 16:50
  • $\begingroup$ The Data Explorer data is a little stale (2 days old), but that's probably most of the affected posts. Manual fixing (-> faa.gov/air_traffic/publications/media/PCG.pdf )is probably the easiest way to deal with this. $\endgroup$
    – voretaq7
    Apr 7 '15 at 19:25
  • 1
    $\begingroup$ data.stackexchange.com/aviation/query/297700/… <-- Updated version of query which generates (usually-working) links. Should work for Questions & Answers. Definitely broken for tag wikis. $\endgroup$
    – voretaq7
    Apr 7 '15 at 19:42
  • 2
    $\begingroup$ @voretaq7 Thanks! I updated them all manually $\endgroup$
    – Pondlife
    Apr 7 '15 at 23:33
  • $\begingroup$ @voretaq7: You can just use SELECT Posts.Id as [Post Link] ... and get magic links automatically. But it looks like all the posts have been fixed already, anyway. $\endgroup$ Apr 13 '15 at 16:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .