3 ms·

Is it possible to export a report of traffic by a selected region?

• zX41ZdbW 3y ago
  Yes, it is possible to connect to the database directly and run an arbitrary query. Example: $ clickhouse-client --user website --host kvzqttvc2n.eu-west-1.aws.clickhouse-staging.com clickhouse-cloud :) SELECT t, desc, count() AS c FROM planes_mercator_sample100 GROUP BY ALL ORDER BY c DESC LIMIT 10 ┌─t────┬─desc────────────────────────────┬────────c─┐ 1. │ B738 │ BOEING 737-800 │ 51530781 │ 2. │ A320 │ AIRBUS A-320 │ 37196762 │ 3. │ C172 │ CESSNA 172 Skyhawk │ 20049393 │ 4. │ A321 │ AIRBUS A-321 │ 19983151 │ 5. │ A20N │ AIRBUS A-320neo │ 14938832 │ 6. │ B38M │ BOEING 737 MAX 8 │ 14200826 │ 7. │ B737 │ BOEING 737-700 │ 13929403 │ 8. │ A319 │ AIRBUS A-319 │ 13906164 │ 9. │ E75L │ EMBRAER ERJ-170-200 (long wing) │ 12006441 │ 10. │ A21N │ AIRBUS A-321neo │ 10965047 │ └──────┴─────────────────────────────────┴──────────┘ Add FORMAT CSV to output in CSV (or any other format). To obtain an SQL query for a particular region, you can open the browser dev tools (F12), switch to Network, and copy a particular request that is made when you select an area with the rectangle selection tool.
  • nickphx 3y ago
    Ah very nice, thank you kind internet friend.