An exploratory visualization tool for the analysis of movements between geographic locations (Origin-Destination data with attributes).
Try the LIVE DEMO.
flowmap.query currently only supports ClickHouse as its database backend. ClickHouse is a scalable column-oriented database. It's shows great query performance especially for aggregation queries over large single-table datasets. This makes ClickHouse a great choice for supporting interactive analysis of OD-datasets with attributes.
We plan to add support for BigQuery and Google Sheets in the future.
Running flowmap.query on DigitalOcean: Step-by-step guide.
- How to install ClickHouse in DigitalOcean.
- How to set up a Node.js app in DigitalOcean.
- A tutorial describing how to load US flight delays dataset containing 166 million rows into ClickHouse.
- Benchmarking ClickHouse on the 1.1 Billion Taxi Rides dataset: on a single machine and in an AWS EC2 cluster. The author also describes in detail how to prepare and ingest the whole dataset.
Add a .env file with ClickHouse URL:
CLICKHOUSE_URL=http://localhost:8123?enable_http_compression=1&password=YOUR_CLICKHOUSE_PASSWORD"
Add a client/.env file with the Mapbox access token:
REACT_APP_MapboxAccessToken=...
To build:
npm install
cd client && npm install && npm run build && cd ..
Then, to start in production mode:
npm start
Run in the root folder:
npm run dev
Alternatively, you can run the server and the client separately:
npm run dev:server
npm run dev:client
Developed by Ilya Boyandin at Teralytics.