Google Spreadsheet Unique Item Count

By | July 30, 2015

Google sheets can do some neat tricks. Here’s how you can generate a chart of unique words submitted and their counts. The form for collecting a single word. Loading… The formula to paste in column C. All credit to this Stack Overflow post. =QUERY({B:B,B:B},”select Col1, count(Col2) where Col1 != ” group by Col1 label count(Col2) […]

Read more »

Benson, Discourse, and WordPress

By | July 28, 2015

It sounds like an exciting new buddy movie . . . but it’s an attempt to better integrate elements of our Discourse install in WordPress using Benson (a neat plugin Mark made that lets you use Angular w/in WordPress). I decided to look into this after seeing this example using Twig. Ordinarily, I’d do something […]

Read more »

Flickr Group Widget – Round 1

By | July 27, 2015

flickr photo shared by Little Orange Crow under a Creative Commons ( BY-NC ) license The goal here was simply to take the Flickr API knowledge I’d gained earlier and apply it within a WordPress widget. In doing so, I learned a few things. The primary one being that I often harm myself by being […]

Read more »

Weekly Web Harvest (weekly)

By | July 25, 2015

Sea level study: James Hansen issues dire climate warning. “: Hansen’s study comes via a nontraditional publishing decision by its authors. The study will be published in Atmospheric Chemistry and Physics, an open-access “discussion” journal, and will not have formal peer review prior to its appearance online later this week. [Update, July 23: The paper […]

Read more »

Photography – Week 84

By | July 25, 2015

A dancer being filmed on the median on Broad Street.

Read more »

Flickr API Basics – Pulling a Group Feed

By | July 25, 2015

Someone at work mentioned that the Flickr WordPress widget didn’t work with group photos. We use this group as part of our (sort of just getting started) Friday photo walks. Since I’m trying to learn stuff I figured I’d play a bit with the Flickr API and see how that worked. After getting an API […]

Read more »

He stood so still

By | July 25, 2015

He stood so still while the world moved on around him. Just a little animated gif made from two shots I took walking past this gentleman staring so intently at his phone. He didn’t move a bit but because I was walking the shot shifted some allowing me to animate it and give you this… Read More

Read more »

Scraping Instagram – Take 3

By | July 24, 2015

flickr photo shared by JeepersMedia under a Creative Commons ( BY ) license I started to apologize for writing three posts on this and promising not to do any more but I reconsidered. This is my site. I’ll write whatever I want. Skip it if it bores you or exile me from your feed reader.1… Read More

Read more »

Scraping Instagram #2

By | July 24, 2015

flickr photo shared by Marco Gomes under a Creative Commons ( BY ) license Remember last night when I posted about scraping data from Instagram? I woke up this morning about 5:30 (literally with a start) astounded by how easy the solution to archiving the pagination returns was. So before I even left for work… Read More

Read more »

Scraping Instagram

By | July 23, 2015

flickr photo shared by ajmexico under a Creative Commons ( BY ) license I’m trying to step up my programming game a bit.1 APIs are also getting more and more accessible to jokers like myself.2 (In this case I also use php, cron, and some regex.) All of this should make Alan very proud. But… Read More

Read more »