Data, Drives, and Donuts

A personal blog about some hobbies of mine.

Epic Road Trip Concluded

September 27, 2021

It is done! The (potentially over-ambitious) 2021 Epic Road Trip has successfully concluded with >10k miles recorded. Read on to see some numbers, learn about my next steps for the data, and check out the final donut stop on the trip.

By The Numbers

A final summary of ‘by the numbers’ to wrap up the road trip:

  • Miles: 10,639
  • Latest leg: 412 miles across 2021-09-21 & 2021-09-22
  • Donuts enjoyed: 71
  • Data records: 153,178
  • Data size: < 15 MB 1

Final map graphic: By The Numbers: Thru 2021-09-21

Data

As with all data efforts, the data is good but needs some work. Attributes like elevation are null while battery_level is an integer value. The former is painful because I will have to backfill the elevation while the latter is annoying because I will not be able to do precise power consumption analysis. All good, though, because I am already scheming up a couple data projects to augment this capture dataset with a couple other sources for elevation and weather.

Donuts

Before I left Salem, OR, there was a donut shop I saved for the last: Bigwig Donuts. They do not serve traditional donuts; their thing is all about craft donut holes! Really neat atmosphere and lots of ‘big wig’ jokes when you stop inside their shop. They had six different types of donut hole offerings when I visited… so I figured I would try them all. What I did not realize until I ordered was this is a ‘vegan’ donut spot. That is not necessarily a strike but these donuts were a bit too ‘wet’ for my liking. Vegan donuts do not rise like traditional yeast donuts, rely on pumpkin filling or applesauce as a base, and are often baked rather than fried. This ends up with a consistency closer to that of a brownie than a traditional donut. I thought the flavors were great but without the dry, flakey consistency they are not my favorite. Their coffee, though, was fantastic. I had a maple brown sugar oak milk latte. It was so good that I had to text a sweet-tooth’ed friend of mine about it.

Photos

Location

  1. Partitioning hasn’t been added to the schema yet. As a result, my latest query scanned 14.93 MB representing the entire dataset. This entire dataset contains data beyond the the road trip which ended on 2021-09-22.