Extract Social Media Data from Twitter and Facebook

• [Twitter] get tweets by defined query or specific users, and store collected tweets in dbf table or postgre sql database. Extract geo-tagged locations, mentioned users, retweeted users and replying users into separate fields.
• [Facebook] get public facebook posts from specific users, and store collected posts in posgtre sql database. Extract commented users and mentioned users into separate fields.

An visualization tool is provided at https://github.com/xbwei/Visualization-for-Geo-Twitter-Data