GitHub - mbriney/GeoRSS-Parser: Takes a GeoRSS feed such as Foursquare and turns into a MySQL database

mbriney / GeoRSS-Parser Public

Notifications You must be signed in to change notification settings
Fork 0
Star 2

Takes a GeoRSS feed such as Foursquare and turns into a MySQL database

mattbriney.com/travel/

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
inc/jquery.vector-map		inc/jquery.vector-map
README		README
config.inc		config.inc
createdb.sql		createdb.sql
cron.php		cron.php
states.php		states.php
world.php		world.php

Repository files navigation

GeoRSS Parser
by Matt Briney

-----------------------------------------
Licensed under GPLv3

You are welcome to copy this code but
please fork the repository so we can
keep track of changes!
-----------------------------------------

This cron script takes a GeoRSS feed from Foursquare, grabs the latest check-ins and dumps them into a MySQL database.  The script uses the Yahoo Placefinder API to reverse geocode your coordinates and fill in city, state and country.


TO INSTALL
- Download contents to your webserver
- Dump the SQL file to your MySQL database to create the required tables
- Edit config.inc and insert your Foursquare ID and database connections
- Schedule cron.php to run at an interval you prefer

MAPS
- Once you have built your database you can load the states.php and world.php files to display aggregated locations of where you have been


FUTURE PLANS
- Render a Google Map of all of the cities you have visited
- Create a moving map of your check-ins
- Move beyond Foursquare? - need ideas