In a new post to his blog James Morris has shared a custom Symfony2 console command he's written to pull in Foursquare data for his testing locally.

I've been playing with the Foursquare API recently, I'm attempting to get a new homepage built and want to display a map of where I hang out. I use Foursquare quite a bit so wanted to get the locations from their API then plot them on Google maps. There's a venuehistory endpoint that gives you a massive list of all the venues you've checked into with details such as the venue name, location including lat and lng coordinates, and the count of times you've checked in.

He includes a screenshot of the API's results, the code you'll need to recreate it and an example of it running.