Post

@simonwillison.net

Foursquare just open sourced their 100 million place point of interest dataset! Some notes on poking around with it using DuckDB (it's Parquet files on S3) simonwillison.net/2024/Nov/20/...

simonwillison.netFoursquare Open Source Places: A new foundational dataset for the geospatial communityI did not expect this! > [...] we are announcing today the general availability of a foundational open data set, Foursquare Open Source Places ("FSQ OS Places"). This base layer …

@lemonodor.bsky.social

I'm having so much fun with this dataset. For some reason I'm doing a lot of analysis of fast food places. Did you know Istanbul has the highest density of fast food restaurants, with Burger King being #1?M

@simonwillison.net

There are genuinely 349 Burger Kings in Istanbul!?

21/11/24, 11:48 pm0 reposts1 like

@lemonodor.bsky.social

I mean, append "…in the foursquare POI dataset, according to queries I wrote as fast as possible often with unvetted sql from ChatGPT" to everything I wrote, so… probably not.

@simonwillison.net

What are you using to query it - DuckDB against a local download of the parquet files?

@lemonodor.bsky.social

Yes.

@lemonodor.bsky.social

(Looks like there might be about 130 Burger Kings in Istanbul, and the rest are outside Istanbul but still in that H3 cell.)