JasonMorrison.net

I’ve recently switched over from my iPhone to an HTC Dream phone running Google’s Android operating system, otherwise known as the G1.  One of the main reasons I switched was because my older iPhone didn’t have a real GPS, and the cell-tower triangulation just didn’t cut it in many parts of the country.

Google just released an app that makes the GPS really useful, called My Tracks.  I’m not the first to write about it, and there’s a pretty thorough review at AndroidGuys, but I thought I’d share my first experience.  This is also an excuse to post more pictures of my cute kid on my supposedly technology-focused blog, since she came along for the walk.

To use My Tracks you’ll need to download it for free from the Android Market. Once you have it installed it’s just a matter of starting up and hitting the menu button and then Record Track.  You can put your phone in your pocket and forget about it while you hike or even surf the web and use other apps – it will keep running in the background.  Multitasking is another advantage that Android has over the iPhone.

Here’s my walk with my internet-famous firstborn:

View Larger Map

It’s fairly accurate, and you can even tell which side of the street I walked on most of the time. Mountain View is no metropolis but walking near tallish buildings downtown did seem to throw it off a bit. I promise I was not staggering from side to side as I walked down Castro Street.

You also get summary data about the duration, traveling speed, and even elevation changes of your trip.

The best thing about My Tracks is that it uses Google Maps and makes it easy to share your route with people. One note – you’ll have the click the little down arrow button on the map screen and choose “Send to Google…” before it shows up in your “My Maps” list in Google Maps. To embed the result in the blog post (like I did above), click the “Link” link in Google Maps and you’ll get code for an iframe.

You can also share some route details with Google Docs but to be honest I was hoping for more data – I’d like to get the point-by-point GPS data so I can use it to automatically geotag photos. I am an obsessive geotagger on Flickr but it’s just too time-consuming to do it manually if the data already exists somewhere. You can access Google Docs spreadsheet data with Python, after all.

Another similar Google product I haven’t signed up for yet is Latitude – I’m not so much worried about privacy as I am unlikely to be traveling around enough for it to be interesting at this point. Athena likes to go for walks but we aren’t roaming too far yet.

I used Google Docs spreadsheets to pick a name for my baby. Here’s another interesting social use of spreadsheets.

Check out this YouTube video:

It’s amazing what people will think of once you put something mundane up on the web and give people the freedom to work together.

Thanks to everyone who voted and sent us your suggestions. We’re getting very close to the due date, so I’m officially shutting down votes tomorrow. We’ve decided to make the final choice once the baby is born, just in case the kid has some suggestions of their own. Watch this space for news, hopefully soon.

In the mean time, here are a few things I’ve learned:

• Spreadsheets are the next frontier in web2.0 social networking. No kidding.
• Blog posts about babies are much more popular than posts about statistics.
• Let random people vote on a baby name over the internet, and a few will spam the form or enter nasty stuff, but the vast majority will give you helpful suggestions. Way to go, Internet.

Here’s the form, get your vote in by end of day Friday, November 14th.

If you can’t see the poll, follow this link to get to it.

We’ve hit well over 2000 votes on our baby name survey, and so far my blog has held up well (thank you, WP Super Cache). The traffic has been enough at times to slow the Google Docs form and graphs. To get slightly back on track for this blog, here’s a quick usability lesson – as a form becomes less responsive to users, double- and triple-submissions will increase.

Votes have been coming from all sorts of interesting places:

• Many, many Googlers contributed votes. Obviously I can’t link to any internal company discussion, but I can assure you it was equal parts amusing, helpful, and nerdly. I had a fun time explaining all the programming jokes to Ann, particularly why we won’t be naming the baby after little Bobby Tables. Wysz supplied the very first votes, for Erin and Isaac.

• The MOMformation blog at ParentCenter wrote (somewhat disapprovingly) about our search for baby name assistance.

• Someone posted the link in a thread on Salon.com’s Tabletalk forum. Tabletalk is bizarrely non-searchable, which they could fix with a quick update to their robots.txt file.

• Neatorama picked up the story, which resulted in a flood of votes.

• For some international perspective, The Telegraph wrote about the survey in their “How About That?” column. If anyone has a copy of today’s print edition, I’d love to see if the story made it’s way on to dead trees, given my former journalistic predilections. I really got a kick of the headline, “Google man asks Internet to name his baby” – now that I’ve been publicly outed as Google Man, I’ll need to start wearing my cape to work.

If I’ve missed any, please add them in the comments below. And if you’re having trouble voting or seeing the charts and graphs, try again a little later – I think I my use of Docs and Spreadsheets is somewhere between “statistical outlier” and “abusive” at this point.

You may have noticed the snazzy poll I posted on my blog the other day.  There’s a number of different survey and poll plugins for WordPress but all the ones I’ve looked at have caveats and limitations.  You can also use a service like SurveyMonkey but it has some data limitations for free accounts.  Instead, I used Google Docs and Spreadsheets to create a survey quickly and easily.  Here’s how to do it.

1. Getting to Google Docs and starting your form

We’re going to assume you have a Gmail account or have signed up for some other Google service already.  Go to http://docs.google.com.  Click on New -> Form

2.  Creating your form

This is actually pretty easy, and the online help does a pretty good job explaining what to do.  You have a number of options when creating a question – you can make it multiple choice, full text, or even a numerical scale, and you can mark some questions as required.  If you’re looking for the “Add question” button, it’s up at the top of the page rather than below the last question.

3.  Publishing the survey on your site

After you’ve created your form, use the More Actions button to find the Embed option.  Just copy this iframe into your blog post – it’s that simple. You’ll get code that looks something like this:

<iframe src=”http://spreadsheets.google.com/embeddedform?key=ppevxmL24UqnRb77Xy3AOWg” width=”310″ height=”1044″ frameborder=”0″ marginheight=”0″ marginwidth=”0″>Loading…</iframe>

You can change the height and weight to better fit your blog template.  Keep in mind that some blogging software will not let you post HTML code and others, like WordPress, require you to use the HTML view.

If you can edit your template or sidebar you can even include the poll on every page, instead of just putting it in a post.

4.  Getting data

Here’s where it gets really cool – the data is automatically collected into a spreadsheet that you can share, edit online, or export to Microsoft Excel.  It’s pretty easy to export CSV for a statistical package like SPSS too.

There’s an optional fifth step, creating a chart or graph to let your users see the results, that I’ll cover later.  If you can’t wait just jump back to my post about urban usability and read about how I created the time-series chart there.

A little while ago I added the Sphere Related Content plugin to my blog, and I’ve been using the ShareThis plugin for social bookmarking links for a while now.  The former should theoretically benefit users who want to read more about a topic I’ve written about, while the latter should make it easy to share my articles with others.

WordPress makes it easy to add plugins but I wonder if these are actually useful my readers.  Please take a moment to fill out this survey and let me know.

I used a Google Docs and Spreadsheets form to make the poll.  Later I’ll post about how you can do the same on your blog as well.

I have a little project called Localographer, which you can use to create heat maps and find a house or apartment near your workplace, friends and relatives, or other place you’d like to be.  When I showed it to my brother he tried mapping out places in Boston and ran into a limitation – the interface doesn’t show you various transit options and it doesn’t make it easy to figure out the real cost and benefits of living in different places.

If you move to the suburbs, you might be able to commute by car but living by a train stop can be cheaper and easier.  In some neighborhoods you can get 10 different kinds of food in a 10 minute walk, in others you need to get in your car and drive a quarter mile to get anything to eat at all.

Adding features like this to Localographer means solving two problems – data and user interface.  I don’t have access to restaurant locations, transit stops, etc. and that sort of data can be expensive to get from commercial sources.  I could go the wiki route but that would require building an interface for users to contribute data and finding ways to make the data more reliable.

So in the mean time, if you want to get an idea of how walkable a potential neighborhood might be, take a look at Walk Score.  It’s a very cool site which has some of the features I’ve been meaning to add to Localographer – you can get a score for how livable the area around any address might be.

For example, my current neighborhood in California has a score of 74 out of 100.   Our house in Shaker Heights scores 62 out of 100.  Because any excuse is a good excuse to use a spreadsheet and a graph, I’ve plotted out the walkability of all the places I’ve lived using a Google Docs spreadsheet and the Interactive Time Series Gadget.  I wrote earlier about how you can embed any Google Doc or Spreadsheet into a blog post but Gadgets are even easier – just click the “Publish” button on the gadget and paste the Javascript code in the raw HTML view of your blogging software.

There are some issues with Walk Score, of course – for example Naples, Florida scores very high, but when I lived there I really missed having access to a car.  Most of the restaurants and shops along 5th Street and Tamiami Trail were out of my internship-funded price range.  I used to bike some distance to get to The Clock, a cheap diner.

All of this discussion is pointing toward a much larger question that I have been thinking about for a long time – I know how to study the usability of web sites and other software, but I wonder if anyone does usability studies of urban planning?  I’ve seen traffic flow studies and I know building codes have some basis in ergonomics and accessibility, but does anyone do observational studies of how people interact with different urban environments to figure out what works and what doesn’t?  Is there a Fitt’s Law of where to locate grocery stores compared to condos?

I just wrote a post about buying a new camera, and because I want to compare specs on several different cameras and lenses, I’m going to need a spreadsheet.  Luckily there are some great online spreadsheet programs to chose from.  I’m going to use this as an opportunity to explore how to use Google Docs and Spreadsheets in blog posts.

Before you get started I’m assuming you already have a Google Docs spreadsheet ready to go.

1.  You can always just link to the document. By default your docs will be private so you’ll need to make them available to your readers.  To do so you’ll need to either go to the Share tab and check “Anyone can view this document WITHOUT LOGGING IN at:” or go to the Publish tab and publish the doc. Either way you’ll get regular URL to post, like this one:  http://spreadsheets.google.com/ccc?key=ppevxmL24UqmeiZSbqIU1DQ&hl=en

Links aren’t very exciting though, so how can you embed into a post instead?

2.  You can embed the content into the post.  If you’re wondering how to do it in Wordpress, one solution I’ve come across is the Inline Google Docs plugin at Broken Watch.  This plugin gets the actual text/html of the spreadsheet and places it inline in your post.  So if you have a wide blog template, or a spreadsheet with relatively few columns, it should blend right in.  On the other hand, there’s no editing or other fun.

Here’s an example of what the output looks like:

NOTE: I had to disable this, it was throwing errors once I upgraded to WordPress 2.7. You mileage may vary.

3.  You can put the doc directly in the page with an iframe. This works really, really well with Google Presentations but is a bit trickier with a doc and even less optimal with a spreadsheet. You’ll get the best-looking results if you publish the document and use the published URL in the iframe. On the other hand if you use the shared URL collaborators should be able to make changes right in your blog post.

You’ll want to create some code like this:

<iframe src=”http://spreadsheets.google.com/pub?key=ppevxmL24UqmeiZSbqIU1DQ” width=”500″ height=”400″></iframe>

Make sure you put the code in the “HTML” editing mode of Wordpress rather than “Visual” mode.  As a result you can see some of the info I’ve gathered about possible camera / lens combinations in the spreadsheet below.

The main issue here is the relatively small iframe window size. If you use a wider blog template this technique might work really well.

Why bother? Spreadsheets aren’t the most exciting thing in the world for most people, but play around with all the features of Google Docs and Spreadsheets and you’ll see why this can be pretty cool.  You can embed questionnaires and surveys, cool charts and graphs with Gadgets, and anything else you can think of.