Quantifiably Good
Today, President Trump tweeted out an image of a map with county shapes that looked Republican red. I was curious where this map originated from. There was an article back in 2016 by the Washington Post that provided some perspective. This was by county, the 2016 election results. However, the FLAT red county level map doesn't... Continue Reading →
I was trying to play with the hex map concept. But I noticed my state abbreviations were only showing up on a handful of my marks. I discovered that you can simply click on Label in the Marks card and select "Allow labels to overlap other marks": And boom! All labels are now on display.
My daughter got accepted to a summer program at MIT for women in engineering. So we thought since we'll already be on the east coast, why not extend the trip into exploring colleges in the Northeast. Now, being from the Pacific Northwest, my geography skills for anything east of the Rockies starts to get a... Continue Reading →
I've climbed Rainier a couple of times and there were a few crevasses we had to cross. Some were just a mere jump, others were wider and had to be crossed with a ladder. Got me thinking about crevasses in data and how you might want to fill in those crevasses with the last known... Continue Reading →
This morning, I was perusing an article on NPR about humanitarian icons. The short of it is - UNOCHA (United Nation's Humanitarian Agency) has created 295 icons to help convey useful information. 295? Wow! That does seem excessive. Why not create a new icon language and stack a few icons together to communicate? Oh wait,... Continue Reading →
Today I was asked how to extract the directional component from a street address. For example, the following 3 street addresses should have a directional value of 'East': E Street East Road Big River Blvd E My first approach was to do the old fashioned case statement. Select street_address , case when address like 'E%'... Continue Reading →
Wendy's recent article about migrating salmon got me thinking about our local Orca population and how these magnificent creatures have been struggling of late. Killer whales like to snack on salmon. And with all the news stories about emaciated Orcas, where's their salmon? What was the salmon tally this year? Is there a decline in... Continue Reading →
My 16 year old daughter recently participated in the Western Aerospace Scholars (WAS) sophomore program. She spent 3 days researching, learning and designing a rover for a robotic mission to Mars. What fun! I was curious about the demographics of her co-participants, specifically, how many other young ladies were participating in the program. Reason for my curiosity;... Continue Reading →
Want a quick way to copy your file's path and paste into that email to send to your fellow coworkers? In Windows Explorer, hold the SHIFT key while you RIGHT-CLICK on your file name and select Copy as path. Then paste into your document and voila! You have your entire path in quotes. So simple!... Continue Reading →
Recall our Bob's Burgers example of padding records. Let's expand on it. We now want to know for each record in our padded record set, what was the rolling weekly running sum of burgers served as well as total burgers served to date. And we might as well get the sum of burgers served overall... Continue Reading →