Awesome ClickHouseData Visualization and Analysis

ClickHouse/adsb.exposed

⭐ 459 HTML repository created 2023-12-26

The project "ClickHouse/adsb.exposed" is an interactive visualization and analytics platform for ADS-B (Automatic Dependent Surveillance-Broadcast) data, leveraging the power of the ClickHouse database. It enables users to aggregate, query, and visualize massive amounts of air traffic data in real-time, with the ability to drill down from billions of records to individual data points using custom SQL queries. The platform showcases a variety of use cases and examples, such as visualizing helicopters over Manhattan, aircraft parking at Denver airport, and military training exercises in Texas and Langley. It also highlights the ability to filter and analyze specific types of aircraft, including military planes, helicopters, gliders, balloons, and dirigibles, revealing insights like military bases, hospitals, police stations, and airfields. The visualizations are described as highly detailed and aesthetically impressive, providing a unique way to explore air traffic patterns globally. The project also points out interesting geographic anomalies and gaps in the data, such as restricted airspace or natural features like volcanoes. Overall, the platform serves as a technology demo that combines big data analytics with interactive mapping to offer a comprehensive view of air traffic using ClickHouse's high-performance querying capabilities.

https://github.com/ClickHouse/adsb.exposed

ads-bair-traffic-dataairfieldsairportsanalyticsballoonsbig-dataclickhousedirigiblesflightradargeographic-anomaliesgeospatialglidershelicoptersinteractive-mappingmilitary-aircraftreal-time-queryingsql-queriesvisualization

Also in Data Visualization and Analysis

akvorado/akvorado

Akvorado is a flow collector, enricher, and visualizer that processes network flow data, enriches it with interface and geolocation information, and stores it in ClickHouse for real-time analysis and visualization.

clickvisual/clickvisual

ClickVisual is a lightweight log analytics and data visualization platform built on ClickHouse, designed for efficient log querying, analysis, and monitoring.

mr-karan/logchef

Logchef is a lightweight, high-performance log analytics platform built on ClickHouse, offering schema-agnostic querying, team-based access control, and easy deployment as a single binary.

Altinity/clickhouse-grafana

Altinity/clickhouse-grafana is a Grafana datasource plugin that enables seamless integration and visualization of ClickHouse data within Grafana dashboards.

serenedb/serenedb

SereneDB is a distributed real-time search analytics database that unifies Elasticsearch-like search and ClickHouse-like analytics in a single, Postgres-compatible platform for high performance and ease of use.

iamtelescope/telescope

Telescope is a web-based log viewer UI that enables intuitive exploration and analysis of log data stored primarily in ClickHouse, with support for Docker logs and advanced querying features.

ClickHouse/metabase-clickhouse-driver

A ClickHouse database driver enabling integration with the Metabase business intelligence front-end for data visualization and querying.

mprove-io/mprove

Mprove is an open-source self-service Business Intelligence platform with version control, leveraging ClickHouse for high-performance data analytics and flexible deployment options.