Post

Simon Willison
@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 …
Simon Willison
@simonwillison.net

Because it can run queries directly against Parquet files over HTTP without needing to download the whole file - it uses HTTP range requests to fetch just the bits of the file it needs to answer the question

1 repost45 likes