1import { files } from '@sublimated/sdk'
2
3const AIRPORTS = {
4 ARN: [17.9186, 59.6519],
5 ATH: [23.9445, 37.9364],
6 BCN: [2.0785, 41.2971],
7 BEG: [20.3091, 44.8184],
8 BER: [13.5033, 52.3667],
9 BOG: [-74.1469, 4.7016],
10 BUD: [19.2556, 47.4298],
11 CAG: [9.0543, 39.2515],
12 CDG: [2.5479, 49.0097],
13 CGH: [-46.6564, -23.6261],
14 CPH: [12.6561, 55.6181],
15 CUN: [-86.8770, 21.0365],
16 CWL: [-3.3433, 51.3967],
17 DEN: [-104.6732, 39.8561],
18 DPS: [115.1671, -8.7482],
19 DSS: [-17.4902, 14.7397],
20 DUB: [-6.2701, 53.4264],
21 EDI: [-3.3725, 55.9500],
22 EPA: [-58.6126, -34.6099],
23 EWR: [-74.1687, 40.6895],
24 EZE: [-58.5356, -34.8222],
25 FCO: [12.2389, 41.8003],
26 FMM: [10.2395, 47.9888],
27 FRA: [8.5622, 50.0333],
28 GIG: [-43.2436, -22.8099],
29 GRU: [-46.4730, -23.4356],
30 GUA: [-90.5275, 14.5833],
31 GYE: [-79.8836, -2.1574],
32 HEL: [24.9633, 60.3172],
33 HKG: [113.9145, 22.3089],
34 HNL: [-157.9224, 21.3187],
35 HRK: [36.2860, 49.9248],
36 IAH: [-95.3414, 29.9844],
37 IGR: [-54.4734, -25.7373],
38 IST: [28.8141, 40.9769],
39 JFK: [-73.7781, 40.6413],
40 KBP: [30.8947, 50.3450],
41 KEF: [-22.6056, 63.9850],
42 KRK: [19.7836, 50.0777],
43 LAS: [-115.1523, 36.0840],
44 LAX: [-118.4085, 33.9425],
45 LHR: [-0.4614, 51.4700],
46 LIS: [-9.1354, 38.7742],
47 MAD: [-3.5673, 40.4936],
48 MEX: [-99.0721, 19.4363],
49 MIA: [-80.2906, 25.7959],
50 MID: [-89.6577, 20.9370],
51 MUC: [11.7861, 48.3538],
52 MUN: [11.7861, 48.3538],
53 NYO: [16.9122, 58.7886],
54 OAK: [-122.2208, 37.7213],
55 OGG: [-156.4305, 20.8986],
56 ORY: [2.3594, 48.7233],
57 OZH: [35.3157, 47.8671],
58 PDX: [-122.5975, 45.5898],
59 PHX: [-112.0116, 33.4373],
60 PRG: [14.2632, 50.1008],
61 PTY: [-79.3835, 9.0714],
62 PVR: [-105.2551, 20.6801],
63 PXM: [-97.0898, 15.8769],
64 SAN: [-117.1896, 32.7336],
65 SAW: [29.3092, 40.8986],
66 SCL: [-70.7858, -33.3930],
67 SDU: [-43.1631, -22.9105],
68 SFO: [-122.3790, 37.6213],
69 SIN: [103.9894, 1.3502],
70 SJU: [-66.0018, 18.4394],
71 SKP: [21.6214, 41.9617],
72 SLC: [-111.9791, 40.7884],
73 STL: [-90.3700, 38.7487],
74 TGD: [19.2519, 42.3593],
75 TIJ: [-116.9700, 32.5411],
76 TIV: [18.7233, 42.4047],
77 TLL: [24.8328, 59.4133],
78 TXL: [13.2877, 52.5597],
79 UIO: [-78.3575, -0.1292],
80 VIE: [16.5697, 48.1103],
81 WAW: [20.9671, 52.1657],
82}
83
84const CITIES = {
85 'Agoura Hills, US': [-118.7609, 34.1531],
86 'Athens, GR': [23.7275, 37.9838],
87 'Bacalar, MX': [-88.3918, 18.6813],
88 'Badajoz, ES': [-6.9706, 38.8794],
89 'Banos, EC': [-78.4247, -1.3928],
90 'Barcelona, ES': [2.1734, 41.3851],
91 'Becici, ME': [18.8567, 42.2886],
92 'Belgrade, RS': [20.4568, 44.7866],
93 'Berlin, DE': [13.4050, 52.5200],
94 'Bologna, IT': [11.3426, 44.4949],
95 'Brookfield, CT, US': [-73.4068, 41.4645],
96 'Buenos Aires, AR': [-58.3816, -34.6037],
97 'Cadiz, ES': [-6.2926, 36.5271],
98 'Cancun, MX': [-86.8515, 21.1619],
99 'Cardiff, GB': [-3.1791, 51.4816],
100 'Carmel-by-the-Sea, US': [-121.9233, 36.5552],
101 'Castelldefels, ES': [1.9767, 41.2800],
102 'Ciudad de Mexico, MX': [-99.1332, 19.4326],
103 'Denpasar, ID': [115.2126, -8.6500],
104 'Denver, US': [-104.9903, 39.7392],
105 'Dresden, DE': [13.7373, 51.0504],
106 'Drogobych, UA': [23.5064, 49.3497],
107 'Dubrovnik, HR': [18.0944, 42.6507],
108 'Edinburgh, GB': [-3.1883, 55.9533],
109 'El Palomar, AR': [-58.6126, -34.6099],
110 'Ellenville, NY, US': [-74.3968, 41.7170],
111 'Encinitas, US': [-117.2928, 33.0370],
112 'Florence, IT': [11.2558, 43.7696],
113 'Fremont, CA, US': [-121.9886, 37.5485],
114 'Gili Trawangan, ID': [116.0345, -8.3520],
115 'Glasgow, GB': [-4.2518, 55.8642],
116 'Guadalajara, MX': [-103.3496, 20.6597],
117 'Guatemala City, GT': [-90.5069, 14.6349],
118 'Hani i Hotit, AL': [19.5603, 42.5336],
119 'Helsinki, FI': [24.9384, 60.1699],
120 'Ivano-Frankivsk, UA': [24.7111, 48.9226],
121 'Kahului, HI, US': [-156.4729, 20.8893],
122 'Karlovy Vary, CZ': [12.8714, 50.2306],
123 'Kharkiv, UA': [36.2304, 49.9935],
124 'Kihei, HI, US': [-156.4659, 20.7644],
125 'Kornati, HR': [15.3000, 43.8000],
126 'Krakow, PL': [19.9450, 50.0647],
127 'Kramatorsk, UA': [37.5558, 48.7362],
128 'Kyiv, UA': [30.5234, 50.4501],
129 'Larkspur, CA, US': [-122.5352, 37.9341],
130 'Leon, NI': [-86.8780, 12.4346],
131 'Lisbon, PT': [-9.1393, 38.7223],
132 'Los Angeles, US': [-118.2437, 34.0522],
133 'Lviv, UA': [24.0297, 49.8397],
134 'Madrid, ES': [-3.7038, 40.4168],
135 'Mahahual, MX': [-87.7112, 18.7142],
136 'Mammoth, CA, US': [-118.9721, 37.6485],
137 'Managua, NI': [-86.2504, 12.1150],
138 'Manchester, GB': [-2.2426, 53.4808],
139 'Memmingen, DE': [10.1811, 47.9837],
140 'Merida, MX': [-89.5926, 20.9674],
141 'Milan, IT': [9.1900, 45.4642],
142 'Morelia, MX': [-101.1950, 19.7060],
143 'Munich, DE': [11.5820, 48.1351],
144 'Napa, US': [-122.2869, 38.2975],
145 'New York, US': [-74.0060, 40.7128],
146 'Newark, NJ, US': [-74.1724, 40.7357],
147 'Ohrid, MK': [20.8019, 41.1231],
148 'Panama City, PA': [-79.5197, 8.9824],
149 'Paris, FR': [2.3522, 48.8566],
150 'Playa del Carmen, MX': [-87.0739, 20.6296],
151 'Podgorica, ME': [19.2636, 42.4304],
152 'Prague, CZ': [14.4378, 50.0755],
153 'Provo, US': [-111.6585, 40.2338],
154 'Puerto Vallarta, MX': [-105.2253, 20.6534],
155 'Pylypets, UA': [23.3311, 48.6614],
156 'Quito, EC': [-78.4678, -0.1807],
157 'Rio de Janeiro, BR': [-43.1729, -22.9068],
158 'Rome, IT': [12.4964, 41.9028],
159 'Sacramento, US': [-121.4944, 38.5816],
160 'Salt Lake City, US': [-111.8910, 40.7608],
161 'San Clemente, US': [-117.6120, 33.4270],
162 'San Diego, US': [-117.1611, 32.7157],
163 'San Francisco, US': [-122.4194, 37.7749],
164 'San Jose, CR': [-84.0907, 9.9281],
165 'San Luis Obispo, US': [-120.6596, 35.2828],
166 'San Salvador, SV': [-89.1872, 13.6929],
167 'Santa Rosa, US': [-122.7141, 38.4405],
168 'Sao Paulo, BR': [-46.6333, -23.5505],
169 'Sarajevo, BA': [18.4131, 43.8563],
170 'Sayulita, MX': [-105.4413, 20.8692],
171 'Sevilla, ES': [-5.9845, 37.3891],
172 'Shkoder, AL': [19.5126, 42.0693],
173 'Skopje, MK': [21.4254, 41.9973],
174 'Split, HR': [16.4402, 43.5081],
175 'Stockton, US': [-121.2908, 37.9577],
176 'Tallinn, EE': [24.7536, 59.4370],
177 'Tegucigalpa, HN': [-87.2068, 14.0723],
178 'Temecula, US': [-117.1484, 33.4936],
179 'Thira, GR': [25.4615, 36.3932],
180 'Tijuana, MX': [-117.0382, 32.5149],
181 'Tirana, AL': [19.8187, 41.3275],
182 'Tivat, ME': [18.7233, 42.4047],
183 'Tulum, MX': [-87.4654, 20.2115],
184 'Vail, CO, US': [-106.3742, 39.6403],
185 'Vallejo, CA, US': [-122.2566, 38.1041],
186 'Venice, IT': [12.3155, 45.4408],
187 'Vorokhta, UA': [24.5417, 48.2747],
188 'Warsaw, PL': [21.0122, 52.2297],
189 'Washington, US': [-77.0369, 38.9072],
190 'Wroclaw, PL': [17.0385, 51.1079],
191 'Yosemite Village, CA, US': [-119.5936, 37.7490],
192 'Zadar, HR': [15.2314, 44.1194],
193 'Zagreb, HR': [15.9819, 45.8150],
194 'Zaporizhzhia, UA': [35.1396, 47.8388],
195 'Zurich, CH': [8.5417, 47.3769],
196}
197
198function resolveLocation(loc) {
199 var trimmed = loc.trim()
200 if (AIRPORTS[trimmed]) return AIRPORTS[trimmed]
201 if (CITIES[trimmed]) return CITIES[trimmed]
202 return null
203}
204
205function parseTrip(filename, content) {
206 var segments = []
207 var lines = content.split('\n')
208 var inTable = false
209
210 for (var i = 0; i < lines.length; i++) {
211 var line = lines[i]
212 if (line.match(/^\|\s*from\s*\|/i)) {
213 inTable = true
214 continue
215 }
216 if (inTable && line.match(/^\|\s*-/)) continue
217 if (inTable && line.startsWith('|')) {
218 var parts = line.split('|').map(function(p) { return p.trim() }).filter(Boolean)
219 if (parts.length >= 4) {
220 var fromCoord = resolveLocation(parts[0])
221 var toCoord = resolveLocation(parts[1])
222 if (fromCoord && toCoord) {
223 segments.push({
224 from: parts[0], to: parts[1], date: parts[2], mode: parts[3],
225 trip: filename, fromCoord: fromCoord, toCoord: toCoord,
226 })
227 }
228 }
229 } else if (inTable && !line.startsWith('|')) {
230 inTable = false
231 }
232 }
233 return segments
234}
235
236function isFlightMode(mode) {
237 return mode.toLowerCase().startsWith('flight')
238}
239
240export default async function () {
241 var allFiles = await files.list('.')
242 var mdFiles = allFiles.filter(function(f) { return f.endsWith('.md') })
243
244 var allSegments = []
245
246 for (var i = 0; i < mdFiles.length; i++) {
247 var content = await files.read(mdFiles[i])
248 if (!content) continue
249 var segments = parseTrip(mdFiles[i], content)
250 allSegments.push.apply(allSegments, segments)
251 }
252
253 // per-trip geojson files
254 var segmentsByTrip = {}
255 for (var i = 0; i < allSegments.length; i++) {
256 var seg = allSegments[i]
257 if (!segmentsByTrip[seg.trip]) segmentsByTrip[seg.trip] = []
258 segmentsByTrip[seg.trip].push(seg)
259 }
260
261 var tripNames = Object.keys(segmentsByTrip)
262 for (var t = 0; t < tripNames.length; t++) {
263 var trip = tripNames[t]
264 var segs = segmentsByTrip[trip]
265 var features = []
266 var stops = {}
267 for (var j = 0; j < segs.length; j++) {
268 var s = segs[j]
269 features.push({
270 type: 'Feature',
271 properties: {
272 layer: isFlightMode(s.mode) ? 'flight' : 'route',
273 from: s.from, to: s.to, date: s.date, mode: s.mode,
274 },
275 geometry: { type: 'LineString', coordinates: [s.fromCoord, s.toCoord] },
276 })
277 stops[s.from] = s.fromCoord
278 stops[s.to] = s.toCoord
279 }
280 var stopNames = Object.keys(stops)
281 for (var k = 0; k < stopNames.length; k++) {
282 features.push({
283 type: 'Feature',
284 properties: { layer: 'stop', name: stopNames[k] },
285 geometry: { type: 'Point', coordinates: stops[stopNames[k]] },
286 })
287 }
288 await files.write(trip + '.geojson', JSON.stringify({ type: 'FeatureCollection', features: features }, null, 2))
289 }
290
291 // global flights.geojson
292 var globalFeatures = []
293 var globalStops = {}
294 for (var i = 0; i < allSegments.length; i++) {
295 var seg = allSegments[i]
296 globalFeatures.push({
297 type: 'Feature',
298 properties: {
299 layer: isFlightMode(seg.mode) ? 'flight' : 'route',
300 from: seg.from, to: seg.to, date: seg.date, mode: seg.mode, trip: seg.trip,
301 },
302 geometry: { type: 'LineString', coordinates: [seg.fromCoord, seg.toCoord] },
303 })
304 globalStops[seg.from] = seg.fromCoord
305 globalStops[seg.to] = seg.toCoord
306 }
307 var globalStopNames = Object.keys(globalStops)
308 for (var i = 0; i < globalStopNames.length; i++) {
309 globalFeatures.push({
310 type: 'Feature',
311 properties: { layer: 'stop', name: globalStopNames[i] },
312 geometry: { type: 'Point', coordinates: globalStops[globalStopNames[i]] },
313 })
314 }
315 await files.write('flights.geojson', JSON.stringify({ type: 'FeatureCollection', features: globalFeatures }, null, 2))
316
317 return new Response(JSON.stringify({
318 ok: true,
319 trips: tripNames.length,
320 segments: allSegments.length,
321 stops: globalStopNames.length,
322 flights: allSegments.filter(isFlightMode).length,
323 }))
324}