Foursquare Open Source Places: A new foundational dataset

Re:Foursquare Open Source Places: A new foundational dataset by Qem on Wednesday November 20, 2024 @10:07AM (#42194528)

It's a bit bothersome they nudge you to install and use aws tools to download the data, instead of providing a plain CSV or JSON downloadable dump instead.

[ Parent | on HN ]

Re:Foursquare Open Source Places: A new foundational dataset by simonw on Wednesday November 20, 2024 @12:45PM (#42196400)

It's S3 so this works to list the bucket contents:

    curl -s "https://fsq-os-places-us-east-1.s3.amazonaws.com/?list-type=2&prefix=release/dt=2024-11-19/places/parquet/&delimiter=/"

And you can download a file called places-00000.snappy.parquet like this:

    curl -O "https://fsq-os-places-us-east-1.s3.amazonaws.com/release/dt=2024-11-19/places/parquet/places-00000.snappy.parquet"

[ Parent | on HN ]

Re:Foursquare Open Source Places: A new foundational dataset by dbbk on Thursday November 21, 2024 @09:53AM (#42204843)

I mean not really, why would you want to direct download a CSV or JSON dump this big

[ Parent | on HN ]

Re:Foursquare Open Source Places: A new foundational dataset by morgenkaffee on Tuesday November 26, 2024 @02:57PM (#42249372)

I also found it hard to deal with the AWS CLI and Parquet. I built this site so you can download it in CSV and Geopackage.

https://repromptai.com/data/foursquare

[ Parent | on HN ]