Groom Lake

12:02 AM

!!distance aah aag

Aachen-Merzbrück Airport - Arapoti Airport • 9,969km / 6,194mi / 5,383nm • 43 hours by Cessna Skyhawk • 11 hours by Airbus A380

Danny Beckett

12:15 AM

!!live

!!distance lpl ams

Otto the Autopilot

Liverpool John Lennon Airport - Amsterdam Airport Schiphol
524km • 326mi • 283nm
2 hours by Cessna Skyhawk • 1 hour by Airbus A380

Danny Beckett

!!live

Otto the Autopilot

@DannyBeckett I'm not dead! Honest!

Danny Beckett

!!distance lpl ams

Otto the Autopilot

Liverpool John Lennon Airport - Amsterdam Airport Schiphol
2 hours by Cessna Skyhawk • 1 hour by Airbus A380
524km • 326mi • 283nm

Danny Beckett

12:21 AM

!!distance jfk mia

Otto the Autopilot

John F Kennedy International Airport - Miami International Airport
8 hours by Cessna Skyhawk • 2 hours by Airbus A380
1,757km • 1,092mi • 949nm

Danny Beckett

12:33 AM

!!distance man lpl

Otto the Autopilot

Manchester Airport - Liverpool John Lennon Airport
<1 hour by Cessna Skyhawk • <1 hour by Airbus A380
38km • 24mi • 21nm

Danny Beckett

!!weather man

Otto the Autopilot

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar MAN instead (uses an alternate data source).

Danny Beckett

12:48 AM

!!weather lpl

Otto the Autopilot

LPL/EGGP: Liverpool John Lennon Airport • Observed: 28 mins ago • Wind: 0°/N @ 1kts • Visibility: 6.21mi/9.99km • Clouds: Scattered @ 4,100ft • Temperature: 3.0°C/37°F • Dewpoint: 3.0°C/37°F • Pressure: 29.82" Hg/1,010mb • Conditions: VFR

Danny Beckett

!!distance lpl ams

Otto the Autopilot

Liverpool John Lennon Airport - Amsterdam Airport Schiphol
2 hours by Cessna Skyhawk • 1 hour by Airbus A380
524km • 326mi • 283nm

Danny Beckett

!!weather lgg

Otto the Autopilot

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar LGG instead (uses an alternate data source).

Danny Beckett

12:59 AM

!!weather lgg

Otto the Autopilot

LGG/EBLG: Liège Airport • Observed: 9 mins ago • Wind: 300°/WNW @ 5kts • Visibility: 2.61mi/4.2km • Clouds: Scattered @ 200ft; Broken @ 300ft • Temperature: 3.0°C/37°F • Dewpoint: 2.0°C/36°F • Pressure: 29.79" Hg/1,009mb • Conditions: LIFR

Danny Beckett

1:16 AM

!!weather par

Otto the Autopilot

@DannyBeckett No matching ICAO code could be found for the IATA code PAR! Check you typed the correct 3-letter IATA code, or type its 4-letter ICAO code instead.

Danny Beckett

!!weather cdg

Otto the Autopilot

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar CDG] instead (uses an alternate data source).

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar CDG instead (uses an alternate data source).

Danny Beckett

!!far

Otto the Autopilot

@DannyBeckett That didn't make much sense. Use the !!/help command to learn more.

Danny Beckett

1:17 AM

!!listcommands

Otto the Autopilot

@DannyBeckett help, listen, eval, coffee, refresh, forget, info, listcommands, tell, afk, distance, teachmetofly, lesson, weather, metar, taf, ban, unban, convert, define, findcommand, google, inhistory, learn, no, live, die, meme, nudge, parse, spec, stat, stats, summon, unsummon, timer, todo, undo, user, welcome, wiki, youtube (page 0/0)

Danny Beckett

1:48 AM

!!weather poz

Otto the Autopilot

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar POZ instead (uses an alternate data source).

Danny Beckett

!!distance poz mmx

Otto the Autopilot

Pozna?-?awica Airport - Malmö Sturup Airport
2 hours by Cessna Skyhawk • <1 hour by Airbus A380
413km • 257mi • 223nm

Danny Beckett

!!distance poz mmx

Otto the Autopilot

Pozna?-?awica Airport - Malmö Sturup Airport
2 hours by Cessna Skyhawk • <1 hour by Airbus A380
413km • 257mi • 223nm

Danny Beckett

1:52 AM

!!distance poz mmx

Otto the Autopilot

Pozna?-?awica Airport - Malmö Sturup Airport
2 hours by Cessna Skyhawk • <1 hour by Airbus A380
413km • 257mi • 223nm

Danny Beckett

!!distance poz mmx

Otto the Autopilot

Pozna?-?awica Airport - Malm� Sturup Airport
2 hours by Cessna Skyhawk • <1 hour by Airbus A380
413km • 257mi • 223nm

Danny Beckett

!!distance poz mmx

Otto the Autopilot

Pozna?-?awica Airport - Malmö Sturup Airport
2 hours by Cessna Skyhawk • <1 hour by Airbus A380
413km • 257mi • 223nm

Danny Beckett

1:53 AM

!!distance lgg lla

Otto the Autopilot

Liège Airport - Luleå Airport
8 hours by Cessna Skyhawk • 2 hours by Airbus A380
1,912km • 1,188mi • 1,032nm

Danny Beckett

!!distance 0ms4 0mn4

Otto the Autopilot

Sheriff's Courthouse Heliport - Paul's Seaplane Base
8 hours by Cessna Skyhawk • 2 hours by Airbus A380
1,846km • 1,147mi • 997nm

Danny Beckett

!!distance ams ---

Otto the Autopilot

Amsterdam Airport Schiphol - Oostwold Airport
1 hour by Cessna Skyhawk • <1 hour by Airbus A380
183km • 114mi • 99nm

Danny Beckett

2:06 AM

!!distance ams o62

Otto the Autopilot

@DannyBeckett No matching airport could be found for the code 000! Check you typed the correct 3-letter IATA code or 4-letter ICAO code.

Amsterdam Airport Schiphol - Carmel Valley
39 hours by Cessna Skyhawk • 10 hours by Airbus A380
8,867km • 5,509mi • 4,788nm

Danny Beckett

room topic changed to Groom Lake: You're probably looking for The Hangar; this is a separate room where our bot gets tested. You can try these commands - !!weather !!metar !!taf !!TeachMeToFly !!distance (no tags)

room topic changed to Groom Lake: You're probably looking for The Hangar; this is a separate room where our bot gets tested. You can try these commands: !!Weather !!METAR !!TAF !!TeachMeToFly !!Distance (no tags)

room topic changed to Groom Lake: You're probably looking for The Hangar; this is a separate room where our bot gets tested. You can try these commands: !!weather !!metar !!taf !!teachmetofly !!distance (no tags)

!!distance syd dfw

Otto the Autopilot

Sydney Kingsford Smith International Airport - Dallas Fort Worth International Airport
60 hours by Cessna Skyhawk • 15 hours by Airbus A380
13,808km • 8,580mi • 7,456nm

Danny Beckett

!!distance ewr sin

Otto the Autopilot

Newark Liberty International Airport - Singapore Changi International Airport
67 hours by Cessna Skyhawk • 17 hours by Airbus A380
15,336km • 9,530mi • 8,281nm

Danny Beckett

2:19 AM

!!distance asc tsa

Otto the Autopilot

Ascención De Guarayos Airport - Taipei Songshan Airport
82 hours by Cessna Skyhawk • 21 hours by Airbus A380
18,887km • 11,736mi • 10,198nm

Danny Beckett

!!distance agp akl

Otto the Autopilot

Málaga Airport - Auckland International Airport
87 hours by Cessna Skyhawk • 22 hours by Airbus A380
19,942km • 12,391mi • 10,768nm

Danny Beckett

!!distance ose ams

Otto the Autopilot

- Amsterdam Airport Schiphol
61 hours by Cessna Skyhawk • 16 hours by Airbus A380
14,005km • 8,703mi • 7,562nm

Steve V.

3:53 AM

!!distance kazo faor

Otto the Autopilot

Kalamazoo Battle Creek International Airport - Olifants River Bridge Landing Strip Airport
60 hours by Cessna Skyhawk • 15 hours by Airbus A380
13,834km • 8,596mi • 7,470nm

Steve V.

Hurm. That probably isn't right.

Huh, it's within 16 kilometers though.

Danny Beckett

@SteveV. did you get the right codes? are the airport names correct?

Steve V.

Kalamazoo is correct

FAOR is supposed to be O.R. Tambo in Johannesburg, South Africa

But the coincidence of Olifants River and the distance being so close....

Also, are you using some native distance calculation tool inside of SQL?

Danny Beckett

do you mean FAJS?

!!distance kazo fajs

Otto the Autopilot

4:03 AM

Kalamazoo Battle Creek International Airport - OR Tambo International Airport
60 hours by Cessna Skyhawk • 15 hours by Airbus A380
13,828km • 8,592mi • 7,466nm

Steve V.

That's the correct airport

Danny Beckett

@SteveV. I wrote a function, 1 sec

Steve V.

O. R. Tambo International Airport

| stat4-header = Social impact | stat4-data = | footnotes = Source: Passenger Statistics }} O. R. Tambo International Airport (ORTIA) is a major airport in Kempton Park, Ekurhuleni, Gauteng, South Africa, near the city of Johannesburg. It serves as the primary airport for domestic and international travel to/from South Africa and is Africa's busiest airport with a capacity to handle up to 28 million passengers annually. The airport is the hub of South Africa's largest international and domestic carrier, South African Airways (SAA), and a number of smaller local airlines. It was ...

But...i wonder what's up with the identifier.

FAOR is the correct identifier.

Danny Beckett

CREATE FUNCTION `distance` (`airport1` VARCHAR(4), `airport2` VARCHAR(4))
RETURNS DOUBLE
BEGIN
	SELECT	X(`location`),
		Y(`location`)
	INTO	@lat1,
		@lon1
	FROM	`airports`
	WHERE	`ident` = `airport1`
	OR	`iata` = `airport1`;

	SELECT	X(`location`),
		Y(`location`)
	INTO	@lat2,
		@lon2
	FROM	`airports`
	WHERE	`ident` = `airport2`
	OR	`iata` = `airport2`;

	RETURN (6371.009 * ACOS(COS(RADIANS(@lat1)) * COS(RADIANS(@lat2)) * COS(RADIANS(@lon1) - RADIANS(@lon2)) + SIN(RADIANS(@lat1)) * SIN(RADIANS(@lat2))));

Steve V.

Aha, i gotcha.

Danny Beckett

4:06 AM

@SteveV. The data comes from ourairports.com

Steve V.

/me gives up on bot programming, too many layers, too much thinking. JS -> PHP -> SQL....we should just do everything in Python, the way God intended.

:)

Danny Beckett

lol

yeah the identifier is mixed up on the main site too

not just in the data dump

Steve V.

ah, well then.

how odd that those two would be so close distance-wise

By the way, you're rocking out loud on this bot. As someone who ran a Python Freenode bot for a couple years and managed about one new function per month, I must say I'm very impressed.

Danny Beckett

according to the data dump, the ICAO code is FAJS. It has a "GPS code" of FAOR. I'm not sure what that column is; I disregarded it when I imported the data. You can use its IATA code instead: JNB

@SteveV. thanks a lot! the encouragement is always good :)

!!distance lpl jnb

Otto the Autopilot

Liverpool John Lennon Airport - OR Tambo International Airport
41 hours by Cessna Skyhawk • 10 hours by Airbus A380
9,333km • 5,799mi • 5,039nm

Danny Beckett

4:13 AM

:p

Steve V.

!!distance kazo jnb

Otto the Autopilot

Kalamazoo Battle Creek International Airport - OR Tambo International Airport
60 hours by Cessna Skyhawk • 15 hours by Airbus A380
13,828km • 8,592mi • 7,466nm

Danny Beckett

!!weather poz

Otto the Autopilot

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar POZ instead (uses an alternate data source).

Danny Beckett

!!metar poz

did I break the bot?

!!metar lpl

!!metar eham

!!taf kjfk

Otto the Autopilot

4:21 AM

TAF
  AMD KJFK 210244Z 2103/2206 33015KT P6SM SCT035 SCT060 BKN250
  TEMPO 2103/2105 33015G23KT BKN035 BKN060
 FM210900 34010KT P6SM SCT040 OVC120
 FM211600 01012KT 2SM -SN SCT015 BKN025 OVC040
 FM212000 02015G22KT 1SM -SN BKN015 OVC025
  TEMPO 2120/2124 1/2SM SN BKN007 OVC015
 FM220000 36020G30KT 1/2SM SN OVC004
  TEMPO 2200/2204 1/4SM +SN BLSN OVC003

Danny Beckett

looks like I broke METARs... weird

!!taf ams

Otto the Autopilot

TAF COR TAF COR EHAM 210309Z 2103/2206 VRB03KT 7000 SCT007 OVC014
  TEMPO 2103/2109 4000 BR BKN006
  BECMG 2109/2112 18005KT
  TEMPO 2118/2124 3000 -RADZ SCT005 BKN007 OVC010
  BECMG 2123/2202 15005KT 9999 SCT012 BKN020 PROB40 2202/2206 3500 BR BKN006

Danny Beckett

!!metar eggp

!!metar ams

!!LIVE

Otto the Autopilot

@DannyBeckett I'm not dead! Honest!

@DannyBeckett I awoke on Tue, 21 Jan 2014 04:24:30 GMT (that's about 11 seconds ago), got invoked 1 times, learned 1 commands

Danny Beckett

!!info

!!metar ams

!!weather ams

Otto the Autopilot

4:26 AM

@DannyBeckett Sorry, aviationweather.gov is currently down; weather reports cannot currently be retrieved. Try !!metar AMS instead (uses an alternate data source).

AMS/EHAM: Amsterdam Airport Schiphol • Observed: 32 mins ago • Wind: 300°/WNW @ 2kts • Visibility: 4.97mi/8.0km • Clouds: Few @ 600ft; Broken @ 1,200ft; Broken @ 1,900ft • Temperature: 3.0°C/37°F • Dewpoint: 2.0°C/36°F • Pressure: 29.82" Hg/1,010mb • Conditions: MVFR

Danny Beckett

!!metar ams

Steve V.

hasta la vista for now

Danny Beckett

seeya Steve!

Danny Beckett

4:44 AM

!!listcommands

Otto the Autopilot

@DannyBeckett help, listen, eval, coffee, refresh, forget, info, listcommands, tell, afk, distance, teachmetofly, lesson, weather, metar, taf, ban, unban, convert, define, findcommand, google, inhistory, learn, no, live, die, meme, nudge, parse, spec, stat, stats, summon, unsummon, timer, todo, undo, user, welcome, wiki, youtube (page 0/0)

Danny Beckett

!!metar

Otto the Autopilot

@DannyBeckett Retrieves the METAR weather data for a specified ICAO airport - e.g. !!metar KJFK or !!metar EGGP

Danny Beckett

!!metar jfk

!!metar kmia

Notice: !!metar is broke. I don't know why. Will investigate further tomorrow.

Otto the Autopilot

@DannyBeckett Information on interacting with me can be found at this page

Danny Beckett

4:58 AM

!!help

Information on interacting with the bot

Help: Information on interacting with the bot

Danny Beckett

8:41 PM

!!live

!!testing

Otto the Autopilot

@DannyBeckett You must specify a 3-letter IATA or 4-letter ICAO airport code - e.g. !!metar LPL or !!metar KJFK

Danny Beckett

!!testing ams

Otto the Autopilot

EHAM 212025Z 23009KT 8000 FEW007 SCT010 BKN012 05/04 Q1012 TEMPO BKN016

Danny Beckett

!!metar ams

!!live

Otto the Autopilot

@DannyBeckett I'm not dead! Honest!

Danny Beckett

8:51 PM

!!metar ams

!!testing lpl

!!metars man

Otto the Autopilot

EGGP 212020Z 15018KT 9999 -RA FEW015 BKN021 07/05 Q1001

EGCC 212020Z 16016KT 9999 -RA SCT018 06/04 Q1002

Danny Beckett

!!metar eham

!!testing egggp

!!metars egcc

Otto the Autopilot

@DannyBeckett You must specify a 3-letter IATA or 4-letter ICAO airport code - e.g. !!metar LPL or !!metar KJFK

EGCC 212020Z 16016KT 9999 -RA SCT018 06/04 Q1002

Danny Beckett

!!metar eham

!!testing eggp

!!metars egcc

Otto the Autopilot

EGGP 212020Z 15018KT 9999 -RA FEW015 BKN021 07/05 Q1001

EGCC 212020Z 16016KT 9999 -RA SCT018 06/04 Q1002

Danny Beckett

8:53 PM

!!listcommands

Otto the Autopilot

@DannyBeckett help, listen, eval, coffee, refresh, forget, info, listcommands, tell, afk, distance, teachmetofly, lesson, weather, metar, metars, testing, taf, ban, unban, convert, define, findcommand, google, inhistory, learn, no, live, die, meme, nudge, parse, spec, stat, stats, summon, unsummon, timer, todo, undo, user, welcome, wiki, youtube (page 0/0)

Danny Beckett

!!metar help

!!metar

Otto the Autopilot

@DannyBeckett Retrieves the METAR weather data for a specified ICAO airport - e.g. !!metar KJFK or !!metar EGGP

Danny Beckett

!!help metar

Otto the Autopilot

@DannyBeckett metar: Retrieves the METAR weather data for a specified ICAO airport - e.g. !!metar KJFK or !!metar EGGP

Danny Beckett

8:58 PM

!!refresh

!!help

!!info

!!live

Otto the Autopilot

@DannyBeckett I awoke on Tue, 21 Jan 2014 21:01:49 GMT (that's about 17 seconds ago), learned 1 commands

@DannyBeckett I'm not dead! Honest!

Danny Beckett

!!metars eham

!!metar eggp

Otto the Autopilot

EHAM 212055Z 24008KT 9999 FEW012 BKN015 05/04 Q1012 TEMPO 6000

Transcript for