tag:blogger.com,1999:blog-8453126.post4083315505467418708..comments2023-05-27T03:03:25.460-07:00Comments on SeanDaniel.com / technology: How to map your FourSquare dataSean Danielhttp://www.blogger.com/profile/05628006595925427776noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8453126.post-68860318587807867542016-12-28T14:43:23.721-08:002016-12-28T14:43:23.721-08:00Thanks a lot for this writeup, in 2016 this still ...Thanks a lot for this writeup, in 2016 this still works :-) Just managed to make a map with all my Swarm checkins for 2016. Ingridhttp://www.thegirlinthecafe.comnoreply@blogger.comtag:blogger.com,1999:blog-8453126.post-47548975864709967772016-09-27T14:30:43.612-07:002016-09-27T14:30:43.612-07:00This is awesome and worked seamlessly for me! Than...This is awesome and worked seamlessly for me! Thanks!O n T Schrockhttps://www.blogger.com/profile/04726758541714827318noreply@blogger.comtag:blogger.com,1999:blog-8453126.post-85456298242029325472015-06-25T23:02:22.236-07:002015-06-25T23:02:22.236-07:00I have the same problem, haven't found a work ...I have the same problem, haven't found a work around yet. Moor automation!!Sean Danielhttps://www.blogger.com/profile/05628006595925427776noreply@blogger.comtag:blogger.com,1999:blog-8453126.post-69515540792241642502015-06-13T09:35:58.359-07:002015-06-13T09:35:58.359-07:00Thank you so much for the tutorial. I was quite sa...Thank you so much for the tutorial. I was quite sad when Google Maps ended the convenient setup of being able to paste the KML URL into the map "search" form to instantly create a map.<br /><br />I used your walk through and was able to successfully create a map.<br /><br />I did have a question though:<br /><br />Using the Fusion Tables, I did the KML file upload to then populate the map. But my question is:<br /><br /><b>Is it possible to create a Google Spreadsheet where there is an "ImportXML" formula that populates a spreadsheet automatically based on the Foursquare KML URL? </b><br /><br />I ask because I've realized that the map will ONLY be updated manually when the KML file is uploaded to a new Fusion table, and then having the copy copy/pasted onto my own site.<br /><br />But if the data source for the Fusion Table came from a Google spreadsheet that was auto-populating via an "ImportXML" formula as being used, the data would be updated on the map automatically.<br /><br />I did a test of the formula in a Google spreadsheet and it does automatically update with the most recent foursquare data. But I am not skilled enough to format the sheet to work with a Fusion table.<br /><br />Any thoughts?<br /><br />Matt Peloquinhttps://www.blogger.com/profile/03716145501337728000noreply@blogger.comtag:blogger.com,1999:blog-8453126.post-1634939494786948342014-09-09T05:52:37.146-07:002014-09-09T05:52:37.146-07:00Sean, I've been uploading it to MapBox and cre...Sean, I've been uploading it to MapBox and creating the lines manually.<br /><br />Would be so swell to have it automated. I need to download kml data and reupload/customize every time I have new data.<br /><br />Still comes out very clean and the best solution I've found yet. - http://travels.luizcentenaro.com/map/Anonymoushttps://www.blogger.com/profile/05740672218914130891noreply@blogger.comtag:blogger.com,1999:blog-8453126.post-75252586432156411172014-07-30T09:28:59.532-07:002014-07-30T09:28:59.532-07:00Glad you enjoyed it Luiz, thanks for all the tweet...Glad you enjoyed it Luiz, thanks for all the tweets as well. I'm not sure how to add lines. something to explore for sure. based on time, that would be pretty cool. Might have to look into that one.Sean Danielhttps://www.blogger.com/profile/05628006595925427776noreply@blogger.comtag:blogger.com,1999:blog-8453126.post-62766252045611614482014-07-29T21:48:11.175-07:002014-07-29T21:48:11.175-07:00Great tutorial Sean. Do you know how to add number...Great tutorial Sean. Do you know how to add numbers and lines, tracking a trip across the United States would be the goal.<br /><br />Thanks.Anonymoushttps://www.blogger.com/profile/05740672218914130891noreply@blogger.comtag:blogger.com,1999:blog-8453126.post-86871302234379261702014-03-07T19:39:06.382-08:002014-03-07T19:39:06.382-08:00What is weird, is just about a week later, I tried...What is weird, is just about a week later, I tried again and now the Fusion table is taking all of my check-ins. So you might not need to break it down by year. It is "experimental" so maybe I just got lucky?Sean Danielhttps://www.blogger.com/profile/05628006595925427776noreply@blogger.com