Google Maps Street View
Another pretty amazing option in Google Maps. You now have the “street view” option in addition to map, satellite and hybrid views.
This view appears to be a real street level view of the city’s streets that you can advance incrementally (using the arrows you see). Talk about a great way to give your students a view of a particular novel or historical location. It appears to be just major cities right now but it’s pretty impressive.
It’s a bit awkward to see who did what in a Google Doc via the version history. That’s something faculty often want to do. The easiest path I found was to name the oldest and newest versions. Then click to show only named versions. That does it pretty well. The video above shows it with more detail.
A while back I posted about using GoogleLookup to get data quickly and easily to make and put into Google Earth via Google Spreadsheets. The example file is at http://spreadsheets.google.com/pub?key=pGAYO0Q5WpT8_Rsss6Uw2LQ&output=txt&gid=2&range=a1. It’s a network link. In Google Earth- click Add– Network Link and paste the URL into the Link box. Here’s some information on how to do this if you’re interested. Put Info into Google Earth from a Google Spreadsheet Things ended up being far easier than I anticipated. The last time I did a networked KML link from a spreadsheet (sounds way fancier than it is) I had to make it myself and go through a different service. Now Google has a nice template all set up to make things work well and it makes things pretty as well. Adding GoogleLookup to the Template So the next thing I did was play around a little with the lookup function. I didn’t do too much. I was just playing around to make sure it would work. This wouldn’t save you much time as it’s only five cities but it you wanted to plot all this information for 50 cities things would start to get a lot more interesting. I just added a few columns at the end of the spreadsheet and then set up the following formulas. I put the lookup […]
Talking to Bud the other day he mentioned that generating the citation page for his digital stories was something of a pain. I’ve thought about it a bit since then and decided to try to simplify a workflow for this. Odd thing I learned – – CHAR(10) is the official way to get line breaks in Google Spreadsheet formulas. Flickr to Diigo to Google Spreadsheets Initially, I looked at the Flickr galleries because that’s the option that Bud normally uses. I saw that the gallery was in a standard HTML list format and I had some hope. Google spreadsheets lets you pull lists and tables like these in via the IMPORTHTML function. Martin Hawksey has some good instructions and examples over here. So that failed but I could import just about every other list on the page. So, I decided doing this through Diigo would make pretty decent sense for a number of people. Assuming you choose a unique tag for the images you plan to use- this example just uses “flickr”, I’d suggest something story/movie specific. So the basic Diigo URL you’d get is https://www.diigo.com/user/bionicteaching/flickr. Trying to make this really easy for people, I set up the first page to allow you to paste that URL in and our friendly formulas transform it into https://www.diigo.com/rss/user/bionicteaching/flickr. The example linked here […]