Edit: Since writing this, my traffic has started to rise again. I'm not sure if this is due to my contacting Google, or just a natural progression of events.
Since leaving my previous job I've been working on bunch of different projects. The first one to be released was RecreationParks.net, a data mashup site combining naming information from the USGS with geocoded Wikipedia articles (thanks geonames.org!), Flickr photos, web searches, weather, maps, and user-submitted park activity information and links. The idea was to get some search-based traffic from the long tail of regional web searches by making a parks page for every public park in the United States (around 60k in the USGS data set). Most of these parks are tiny, but I figured someone might still care to search for them, and I tried to bring in as much smarts and data to mashup as I could, given my development timeframe of around a week and a half.

The initial traffic was nothing to write home about, but the derivative was positive, and so was I. I had posted a link on Hacker News and a few other sites, wrote a Rails sitemap controller, and submitted the sitemap to Google. I even outsourced some modest work to my online virtual assistant, who did a very good job building up link exchanges. (More on my experiences with an online VA in a future post.)
After the HN traffic fell off, natural search traffic took over and grew slowly. Over the time span of the above graph, search sent 3,655 total visits via 3,385 keywords, for parks all over the country. That's pretty decent breadth of exposure. Google started to index through the sitemaps (around 5,000 pages so far) and traffic was small but growing, with pages on RecreationParks.net showing in the top 10 results for a large range of very niche keywords. Then, probably due to a ranking adjustment, traffic suddenly fell at Peak A. Soon after it started to rise again with a nice trend line, only to fall again precipitously at Peak B to practically nothing. Given that the vast majority of the traffic was coming via Google, these changes should be explained by changes at those times in Google's view of the site.
I think that the fall after Peak A was the result of the "newness" of the site wearing off, causing it to decrease in the Google rankings. What I find strange is that this happened twice. I'd expect the Peak A adjustment, but I was surprised (and disappointed) by the fall after Peak B. It seemed like users were getting something out of the site, some comments were left, and quite a few parks received user feedback, then thunk the site fell out of almost every Google listing in which it had previously been in the top 10. Is Google penalizing mashup-based sites that re-mix existing content? Did the site get (falsely, I'd claim) classified as duplicate content or spam? What do you think? Why would I see such a drastic reduction in traffic?
Since this was just a side project, I'm content to leave it up and wait and see if it slowly makes its way back into the listings. Granted, this site doesn't have much original content, but I still think it's useful in providing results on very niche and under-served searches. It'll be interesting to see how the ranking changes in the future and to try to infer from these changes an understanding of how Google does their ranking. This much is clear: one can't rely on Google for all of their traffic, and getting into search listings is harder than I thought. Come on, big G, give me some love!