-
Notifications
You must be signed in to change notification settings - Fork 2
/
aeros.py
71 lines (68 loc) · 8.69 KB
/
aeros.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
northeast = set(["Philadelphia, Pennsylvania (PHL)", "Boston, Massachusetts (BOS)", "Baltimore, Maryland (BWI)", "Hartford, Connecticut (BDL)", "New York, New York (JFK)", "New York, New York (LGA)", "Newark, New Jersey (EWR)", "Washington, D.C. (IAD)", "Washington, D.C. (DCA)"])
texas = set(["San Antonio, Texas (SAT)", "Austin, Texas (AUS)", "Dallas, Texas (DFW)", "Houston, Texas (IAH)", "Houston, Texas (HOU)"])
northwest = set(["Portland, Oregon (PDX)", "Seattle, Washington (SEA)"])
rockies = set(["Salt Lake City, Utah (SLC)", "Denver, Colorado (DEN)"])
california = set(["Los Angeles, California (LAX)", "San Francisco, California (SFO)", "Oakland, California (OAK)", "Sacremento, California (SMF)", "San Diego, California (SAN)", "San Jose, California (SJC)"])
midwest = set(["St Louis, Missouri (STL)", "Louisville, Kentucky (SDF)", "Indianapolis, Indiana (IND)"])
southwest = set(["Las Vegas, Nevada (LAS)", "Phoenix, Arizona (PHX)"])
florida = set(["Fort Lauderdale, Florida (FLL)", "Fort Meyers, Florida (RSW)", "Miami, Florida (MIA)", "Orlando, Florida (MCO)", "Tampa, Florida (TPA)"])
southeast = set(["Atlanta, Georgia (ATL)", "Memphis, Tennessee (MEM)", "Nashville, Tennessee (BNA)", "New Orleans, Louisiana (MSY)"])
greatLakes = set(["Minneapolis, Minnesota (MSP)", "Chicago, Illinois (MDW)", "Chicago, Illinois (ORD)", "Detroit, Michigan (DTW)"])
ohio = set(["Cleveland, Ohio (CLE)", "Cincinnati, Ohio (CVG)", "Columbus, Ohio (CMH)", "Pittsburgh, Pennsylvania (PIT)"])
northCarolina = set(["Charlotte, North Carolina (CLT)", "Raleigh, North Carolina (RDU)"])
old_total = northeast.union(texas).union(northwest).union(rockies).union(california).union(midwest).union(southwest).union(florida).union(southeast).union(greatLakes).union(ohio).union(northCarolina)
data = [[ 1077, "DBBDA5AA-2EE6-47FE-98BE-DF3CB104B117", 1077, 1247781711, "278324", 1247781711, "278324", None, "PHX", "33.43416667", "112.0116667" ]
, [ 1418, "4FE7EA2A-5576-4141-8624-AAFFE038D04F", 1418, 1247781711, "278324", 1247781711, "278324", None, "LAX", "33.9425", "118.4072222" ]
, [ 1473, "A7BF2538-20C0-4E4B-BF68-8319C57101FE", 1473, 1247781711, "278324", 1247781711, "278324", None, "OAK", "37.72138889", "122.2208333" ]
, [ 1557, "81262588-4853-41B2-BCB3-BAD40AA9870C", 1557, 1247781711, "278324", 1247781711, "278324", None, "SMF", "38.69555556", "121.5908333" ]
, [ 1570, "C2ABA99C-2D7C-4450-8A37-1E7643C0FA2D", 1570, 1247781711, "278324", 1247781711, "278324", None, "SAN", "32.73361111", "117.1897222" ]
, [ 1572, "EFD7BDD1-8F72-43A3-97D0-2FE925CC463F", 1572, 1247781711, "278324", 1247781711, "278324", None, "SFO", "37.61888889", "122.375" ]
, [ 1574, "91DAC48B-F644-47D2-BA77-FFF709AAD055", 1574, 1247781711, "278324", 1247781711, "278324", None, "SJC", "37.36277778", "121.9291667" ]
, [ 1754, "FDDFAC0D-F3F7-4A41-9FB1-CF9E9F6F959F", 1754, 1247781712, "278324", 1247781712, "278324", None, "DEN", "39.86166667", "104.6730556" ]
, [ 1998, "14840B7E-6A42-4939-A21C-08814B43AA2D", 1998, 1247781712, "278324", 1247781712, "278324", None, "BDL", "41.93888889", "72.68333333" ]
, [ 1999, "F432E60A-F809-4BE9-BA86-D43763F5246F", 1999, 1247781712, "278324", 1247781712, "278324", None, "DCA", "38.85222222", "77.03777778" ]
, [ 2000, "2E501AE3-BA30-4630-9E3E-856B9A47CF89", 2000, 1247781712, "278324", 1247781712, "278324", None, "IAD", "38.9475", "77.46" ]
, [ 2168, "34158DC4-E23F-4536-B937-FE63859CEF64", 2168, 1247781712, "278324", 1247781712, "278324", None, "FLL", "26.07258333", "80.15277778" ]
, [ 2175, "9729F85D-3E82-46A3-87FA-C682EA404C90", 2175, 1247781712, "278324", 1247781712, "278324", None, "RSW", "26.53616667", "81.75527778" ]
, [ 2352, "49677427-6C16-4AB8-9A3E-17290D7207A8", 2352, 1247781712, "278324", 1247781712, "278324", None, "MIA", "25.79325", "80.29055556" ]
, [ 2409, "A22D5203-43A7-453B-BBE1-493F09231BD7", 2409, 1247781712, "278324", 1247781712, "278324", None, "MCO", "28.42944444", "81.30888889" ]
, [ 2489, "875E0B07-053D-4B24-9A0E-D79E6D37EF15", 2489, 1247781712, "278324", 1247781712, "278324", None, "TPA", "27.97555556", "82.53333333" ]
, [ 2551, "C63A7D5E-EF7F-43C1-AA81-06B7E0BEFBB3", 2551, 1247781712, "278324", 1247781712, "278324", None, "ATL", "33.63666667", "84.42805556" ]
, [ 3401, "A301A865-E3A1-4370-9E88-88B54EB7558B", 3401, 1247781713, "278324", 1247781713, "278324", None, "MDW", "41.78611111", "87.7525" ]
, [ 3402, "2D1D5A78-6E35-4E28-991E-3C43594EC66E", 3402, 1247781713, "278324", 1247781713, "278324", None, "ORD", "41.98083333", "87.90666667" ]
, [ 4046, "D59E436E-4332-443B-B870-45389538312E", 4046, 1247781714, "278324", 1247781714, "278324", None, "IND", "39.71722222", "86.29472222" ]
, [ 4686, "44172A7D-52F1-4C89-BF08-4EF1D0DAB482", 4686, 1247781715, "278324", 1247781715, "278324", None, "CVG", "39.04888889", "84.66777778" ]
, [ 4742, "5B01F7C1-E98E-4477-BDCF-1334CF0D81D1", 4742, 1247781715, "278324", 1247781715, "278324", None, "SDF", "38.17416667", "85.73638889" ]
, [ 4961, "5C9A5CE2-70B2-4EF1-BA8C-E84A232693DA", 4961, 1247781715, "278324", 1247781715, "278324", None, "MSY", "29.99333333", "90.25805556" ]
, [ 5042, "91CE1137-C0D9-4697-BD46-F1ED3BD28E3D", 5042, 1247781715, "278324", 1247781715, "278324", None, "BOS", "42.36305556", "71.00638889" ]
, [ 5116, "38B70172-DCF3-4527-98DE-47775AAB8D48", 5116, 1247781715, "278324", 1247781715, "278324", None, "BWI", "39.17527778", "76.66833333" ]
, [ 5456, "C2CCE0B6-DA62-444C-A829-7469DAB8C420", 5456, 1247781716, "278324", 1247781716, "278324", None, "DTW", "42.2125", "83.35333333" ]
, [ 5951, "7DE6D229-0223-424B-9D0C-A5FFCD3A408A", 5951, 1247781717, "278324", 1247781717, "278324", None, "MSP", "44.88194444", "93.22166667" ]
, [ 6412, "31D61A5E-4841-4154-A9F0-26C63AA73269", 6412, 1247781719, "278324", 1247781719, "278324", None, "STL", "38.74861111", "90.37" ]
, [ 6937, "F4ED528A-2050-4217-9B41-1EBFBFB2F29F", 6937, 1247781720, "278324", 1247781720, "278324", None, "CLT", "35.21388889", "80.94305556" ]
, [ 7124, "73E89DC0-B023-4ED0-9402-E533E39464F8", 7124, 1247781720, "278324", 1247781720, "278324", None, "RDU", "35.87777778", "78.7875" ]
, [ 7797, "B2115F13-FD3E-4925-BBBE-050CEB39E950", 7797, 1247781720, "278324", 1247781720, "278324", None, "EWR", "40.6925", "74.16861111" ]
, [ 8026, "8040FF66-50F6-419A-B5E1-94BAEE4583E8", 8026, 1247781720, "278324", 1247781720, "278324", None, "LAS", "36.08", "115.1522222" ]
, [ 8328, "C2C19C37-87BD-4B85-968F-8648B6095E4E", 8328, 1247781720, "278324", 1247781720, "278324", None, "JFK", "40.63972222", "73.77888889" ]
, [ 8329, "CA9F7C64-29EB-4EB9-AD36-480920BB18C5", 8329, 1247781720, "278324", 1247781720, "278324", None, "LGA", "40.77722222", "73.8725" ]
, [ 8582, "439F1A52-0DEB-434B-8B08-D873CD82CDC1", 8582, 1247781721, "278324", 1247781721, "278324", None, "CLE", "41.40944444", "81.855" ]
, [ 8597, "3F0AA6CB-BDF7-43C0-8FF9-F9D7E78554E5", 8597, 1247781721, "278324", 1247781721, "278324", None, "CMH", "39.99805556", "82.89194444" ]
, [ 9516, "A4C4DBE5-A2C0-4BC8-B56D-0A3E20470D1B", 9516, 1247781723, "278324", 1247781723, "278324", None, "PDX", "45.58833333", "122.5975" ]
, [ 9915, "0B4013FF-AFAE-4A0F-82D9-B86D30EF12DB", 9915, 1247781723, "278324", 1247781723, "278324", None, "PHL", "39.87222222", "75.24083333" ]
, [ 9922, "4BCBAD0E-26C1-4299-B11C-239A6E97723B", 9922, 1247781723, "278324", 1247781723, "278324", None, "PIT", "40.49138889", "80.23277778" ]
, [ 10500, "99AB006A-46D3-447C-83F2-4D6B3D9CBB0A", 10500, 1247781723, "278324", 1247781723, "278324", None, "MEM", "35.0425", "89.97666667" ]
, [ 10521, "22F35316-1478-4D13-A959-1C6C2DE2700B", 10521, 1247781723, "278324", 1247781723, "278324", None, "BNA", "36.12444444", "86.67833333" ]
, [ 10653, "260752C9-B451-4F32-AAD8-58D88C446D9B", 10653, 1247781723, "278324", 1247781723, "278324", None, "AUS", "30.19444444", "97.67" ]
, [ 10939, "792305E9-0EF6-42B7-882F-C5D7E2917F86", 10939, 1247781723, "278324", 1247781723, "278324", None, "DFW", "32.89694444", "97.03805556" ]
, [ 11241, "B5245FB3-C8D5-4B70-A6B2-84E972BCB104", 11241, 1247781724, "278324", 1247781724, "278324", None, "IAH", "29.98444444", "95.34138889" ]
, [ 11252, "F2EDD6B3-2BD0-43DF-826C-A07D2C2CEE86", 11252, 1247781724, "278324", 1247781724, "278324", None, "HOU", "29.64555556", "95.27888889" ]
, [ 11747, "9077B71E-73E0-45F2-BF7F-57D1E6DA14FD", 11747, 1247781725, "278324", 1247781725, "278324", None, "SAT", "29.53361111", "98.46972222" ]
, [ 12102, "AFAEEAF9-BFE7-40A7-9619-319DC0023CDD", 12102, 1247781725, "278324", 1247781725, "278324", None, "SLC", "40.78833333", "111.9777778" ]
, [ 12722, "0A79FEDD-35E4-4735-8488-F279C76DCD9C", 12722, 1247781725, "278324", 1247781725, "278324", None, "SEA", "47.45", "122.3116667" ]
]
total = set([])
for entry in old_total:
for entry2 in data:
x = "(" + entry2[8] + ")"
if x == entry.split(" ")[-1]:
total.add(entry + ": " + entry2[9] + ", " + entry2[-1])