tag:blogger.com,1999:blog-8501278254137514883.post8673667898473435240..comments2024-02-29T05:27:16.639-08:00Comments on pamela fox's blog: Geocoding with Google Spreadsheets (and Gadgets)Pamela Foxhttp://www.blogger.com/profile/15947664772001597300noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8501278254137514883.post-26447075758321199972010-12-05T06:47:39.890-08:002010-12-05T06:47:39.890-08:00Hello,
Thanks for sharing the link - but unfortu...Hello,<br /> <br />Thanks for sharing the link - but unfortunately it seems to be not working? Does anybody here at blog.pamelafox.org have a mirror or another source? <br /> <br /><br />Cheers,<br />DanielAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8501278254137514883.post-84568531911568885402010-02-15T19:41:35.262-08:002010-02-15T19:41:35.262-08:00Thanks for this helpful gadget. I have to agree w...Thanks for this helpful gadget. I have to agree with Tony Hurst though, it would be great have a cell in google spreadsheet that could automatically generate the latitude or longitude from the address in another cell.William B. Shueyhttps://www.blogger.com/profile/06607073469745042839noreply@blogger.comtag:blogger.com,1999:blog-8501278254137514883.post-13310117859146671442008-12-15T18:34:00.000-08:002008-12-15T18:34:00.000-08:00Como se hace para poner un google map en una pagin...Como se hace para poner un google map en una pagina y que las busquedas de los marcadores queden en el mapa y no se borren con el refreshHospital Publicohttps://www.blogger.com/profile/08276534004474205008noreply@blogger.comtag:blogger.com,1999:blog-8501278254137514883.post-2284461485002299882008-12-05T07:37:00.000-08:002008-12-05T07:37:00.000-08:00Tony,The "getting started" page on the spreadsheet...Tony,<BR/>The "getting started" page on the spreadsheet gadgets api is the best place to start:<BR/>http://code.google.com/apis/spreadsheets/spreadsheet_gadgets.html<BR/><BR/>Pamela - this is such a great gadget... the ability to move pins is simply perfect. Thanks (again) for leading the way.JRhttps://www.blogger.com/profile/03007138367944227896noreply@blogger.comtag:blogger.com,1999:blog-8501278254137514883.post-8969838430540394222008-12-03T16:17:00.000-08:002008-12-03T16:17:00.000-08:00Hey Tony-You could turn this gadget into a mapplet...Hey Tony-<BR/><BR/>You could turn this gadget into a mapplet, but I think it'd have to use a published spreadsheet and the API. I don't believe it can grab the authenticated spreadsheets data.<BR/><BR/>Re the geotype idea - my issue with that is that then there is no tweaking of the geocodes. It's my belief that geocodes are never perfect, so you should do a visual check of them before proceeding. A geotype would certainly make things simpler, but it would be better if there was a way of clicking on the cell and tweaking the result.<BR/><BR/>Re starting the gadget - I don't recall. Nowadays I just start from one of my previous gadgets, delete stuff, add stuff. It looks like you figured it out, I saw your Youtube post. Nice work! :)Pamela Foxhttps://www.blogger.com/profile/15947664772001597300noreply@blogger.comtag:blogger.com,1999:blog-8501278254137514883.post-34813486300398410072008-11-28T12:06:00.000-08:002008-11-28T12:06:00.000-08:00Hi Pamela,That was a really neat hack, thanks for ...Hi Pamela,<BR/><BR/>That was a really neat hack, thanks for sharing it:-)<BR/><BR/>I was wondering about doing a gadget myself, but I was thinking about building one in the context of the maps environment, rather than the spreadsheet environment... ie I imagined the gadget sitting in Google maps and pulling data from the spreadsheet...)<BR/><BR/>Another thought I had was just to define a formula that would take a cell that contains eg a place name and then call a geocoding webservice. This then led to the thought - it would be really neat if you could define a cell as a "geotype" that the spreadsheet automatically geocoded and annotated the cell with eg lat/long data in a couple of cells stacked in the third dimension...<BR/><BR/>Just out of interest, how did you get started with writing the gadget? I'm looking for a dead simple howto that shows just how i can eg get the data from a selection of cells and then display it in a table in the gadget (to provide to myself I can get the data and I can then populate a table with it?)<BR/><BR/>The use case I have is to repurpose this youtube playlist gadget (http://www.searchfeedr.com/gadgets/youTubePlaylistGadget.xml), and hack it so that instead of pulling the youtube movie URLs in from an RSS feed, it pulls them in from a list of cells...<BR/><BR/>tonyTony Hirsthttps://www.blogger.com/profile/07192476380420213082noreply@blogger.comtag:blogger.com,1999:blog-8501278254137514883.post-52754416247232507942008-11-27T09:53:00.000-08:002008-11-27T09:53:00.000-08:00This is also a neat way to circumvent the 50 impor...This is also a neat way to circumvent the 50 importdata functions per sheet limit; if you have been doing it the old-fashioned way.<BR/><BR/>I will have to take a peek at the source after exams, if I can add info-windows and custom icons, this could possibly be uber-useful.<BR/><BR/>You could have dynamic (and more than 50 records of) data plotted and geo-coded, if you put it in a table somewhere, use importurl and then use this on the resultant table in the spreadsheet.<BR/><BR/>Thanks Pamela.Ankit Guglanihttps://www.blogger.com/profile/15013101758047678358noreply@blogger.com