# Visualizing Foursquare places with ClickHouse

DevFeed: [Visualizing Foursquare places with ClickHouse](<https://devfeed.tech/articles/visualizing-foursquare-places-with-clickhouse-5255.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/fsq>)

Author: Alexey Milovidov

Published: 2025-05-08T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [Web](<https://devfeed.tech/topics/web.md>)

Tags: [apache](<https://devfeed.tech/tags/apache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [data-visualization](<https://devfeed.tech/tags/data-visualization.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [hackathon](<https://devfeed.tech/tags/hackathon.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [web](<https://devfeed.tech/tags/web.md>)

## AI overview

The article describes a data visualization hackathon project that uses ClickHouse to explore and display a large Foursquare places dataset. It covers previewing and querying the data with clickhouse-local, loading it into ClickHouse, optimizing geographic coordinates and indexes, and adapting a web visualization tool for interactive map analysis.

## Source excerpt

Visualizing geographical datasets with ClickHouse in real-time