{"action":"created","issue":{"url":"https://api.github.com/repos/swcarpentry/amy/issues/276","labels_url":"https://api.github.com/repos/swcarpentry/amy/issues/276/labels{/name}","comments_url":"https://api.github.com/repos/swcarpentry/amy/issues/276/comments","events_url":"https://api.github.com/repos/swcarpentry/amy/issues/276/events","html_url":"https://github.com/swcarpentry/amy/pull/276","id":76923953,"number":276,"title":"Script to show location of airports for addition to database","user":{"login":"gvwilson","id":911566,"avatar_url":"https://avatars.githubusercontent.com/u/911566?v=3","gravatar_id":"","url":"https://api.github.com/users/gvwilson","html_url":"https://github.com/gvwilson","followers_url":"https://api.github.com/users/gvwilson/followers","following_url":"https://api.github.com/users/gvwilson/following{/other_user}","gists_url":"https://api.github.com/users/gvwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/gvwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gvwilson/subscriptions","organizations_url":"https://api.github.com/users/gvwilson/orgs","repos_url":"https://api.github.com/users/gvwilson/repos","events_url":"https://api.github.com/users/gvwilson/events{/privacy}","received_events_url":"https://api.github.com/users/gvwilson/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-05-16T02:30:59Z","updated_at":"2015-05-17T21:58:18Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/swcarpentry/amy/pulls/276","html_url":"https://github.com/swcarpentry/amy/pull/276","diff_url":"https://github.com/swcarpentry/amy/pull/276.diff","patch_url":"https://github.com/swcarpentry/amy/pull/276.patch"},"body":"Adding all airports (#271) is impractical without a better database, so this script allows easy lookup of airports when/as they need to be added."},"comment":{"url":"https://api.github.com/repos/swcarpentry/amy/issues/comments/102863419","html_url":"https://github.com/swcarpentry/amy/pull/276#issuecomment-102863419","issue_url":"https://api.github.com/repos/swcarpentry/amy/issues/276","id":102863419,"user":{"login":"gvwilson","id":911566,"avatar_url":"https://avatars.githubusercontent.com/u/911566?v=3","gravatar_id":"","url":"https://api.github.com/users/gvwilson","html_url":"https://github.com/gvwilson","followers_url":"https://api.github.com/users/gvwilson/followers","following_url":"https://api.github.com/users/gvwilson/following{/other_user}","gists_url":"https://api.github.com/users/gvwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/gvwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gvwilson/subscriptions","organizations_url":"https://api.github.com/users/gvwilson/orgs","repos_url":"https://api.github.com/users/gvwilson/repos","events_url":"https://api.github.com/users/gvwilson/events{/privacy}","received_events_url":"https://api.github.com/users/gvwilson/received_events","type":"User","site_admin":false},"created_at":"2015-05-17T21:58:18Z","updated_at":"2015-05-17T21:58:18Z","body":"The data we have would take a lot of work to tidy up.  For example, I've already fixed up countries listed as \"UK\", \"United Kingdom\", and \"England\" to all be \"United-Kingdom\", and \"US\" and \"USA\" to be \"United-States\"; I'm sure there will be more of those before we can start to think sensibly about translating country names to refs to the country table, and then we have to sort out airport naming vs. city naming, etc.  With over 9000 entries, I'm figuring 9 hours of work (?)."}}