By Robert Ellison. Updated on Saturday, February 19, 2022.
This animation shows a year of tides in San Francisco with the sun and moon:
I was inspired to create this after adding a tide forecast to a personal weather dashboard I have running on an old Surface Pro. I realized I didn't understand tides that much. I still don't, but I know more than I did before.
The animation illustrates four components of the tide. The obvious ones are the position of the sun and moon. When the moon is new or full the Earth, sun and moon are all lined up leading to larger 'spring' tides, which happen twice a month just like spring doesn't. As the moon waxes or wanes and becomes half full the moon and sun are at right angles and partially cancel each other out resulting in lower highs and higher lows. This is the neap tide, almost as unhelpful as 'spring'.
As orbits are not circles the Earth is closer or further away from the sun over the course of a year and the moon behaves the same way. When it's close than usual we get super moons and king tides (finally a type of tide that does what it sounds like). In the animation the sun and moon actually grow and shrink in proportion to their distance from Earth.
Here's how to read the animation. The date and time at the bottom of the screen refers to the tide right in the middle. The full screen shows the forecast running from 12 hours before the current time to 12 hours later. The vertical range is from -4 feet to 10 feet, relative to mean lower low water (MLLW), the average lowest tide over 19 years. The sun and moon are on a different scale - 360 degrees horizontally and 90 degrees vertically.
The tide forecast is pulled from the NOAA Tides and Currents API. I used SunCalc-Net for the position of the sun and moon, and the phase of and distance to the moon. For the distance to the sun I used a formula I found on StackExchange.
I wanted to both fit in a full year and run slowly enough to see what's going on each month so the video is around 20 minutes long. I won't be offended if you don't finish it.
(Published to the Fediverse as:
One Year of Tides Animated (with Sun and Moon) #etc#tides#sun#moon#sanfrancisco#video Animation showing four influences on the tide - the position of the sun and moon, and the distance of the sun and moon from the earth. Illustrates tide height and sun/moon position and distance as seen from San Francisco, California.)
Software: Catfood Earth 4.10 updates to the latest National Weather Service "API" and also 2021a timezones. Photo Sorter 1.10 helps control the scourge of duplicate JPEGs.
Timelapse: Sunset #6, what would happen if you used a style transfer neural network on every frame of a timelapse? This (instructions).
By Robert Ellison. Updated on Friday, February 17, 2023.
I've been meaning to check out the new Gimlet/Spotify podcast, How to Save a Planet, and finally listened to the first episode about wind power last week.
It was sponsored by the Infiniti QX55.
This is not even a hybrid. It's a 268 horsepower SUV. Consumer Reports says:
"The company cited 26 mpg combined (city and highway) when the QX50 was introduced for 2019. We measured just 22 mpg overall in our tests, putting it on par with larger, more powerful SUVs. And it required premium fuel. Subsequently, the official EPA estimate was downgraded to 25 mpg."
It's not even a particularly efficient SUV. You are really unlikely to be saving a planet this way. I'm not sure I can bear to find out who sponsors the second episode. I'm imagining a subscription panda steak service or bitcoin.
I shouldn't throw stones. I bought into a Volkswagen clean diesel (which came with a green tax credit before they got busted). I currently drive a Land Rover that can only hit it's claimed mpg if the engine stop technology is working. That only happens for about twelve miles after it has been serviced, which feels like the same sort of scam as the Volkswagen frankly.
Or maybe the clue is in the indefinite article and they read my post about extreme environmentalism.
(Published to the Fediverse as:
How to Save a Planet (with an Infiniti QX55) #etc#climatechange#environmentalism#podcast You're not really helping to save the planet if you're helping Infinity to sell more QX55's.)
My dentist overcharged the FSA debit card by $2.10 due to some mix up between expected and actual insurance payment. Which would have sorted itself out on the next visit, but apparently it's an FSA emergency which needs paperwork now!
There are at least 28 million of these types of FSA/HSA accounts in the US.
Life expectancy at birth has fallen to 681,995 hours. So assuming that on average each account generates two hours of needless admin per year this is the equivalent of killing 68 people.
Serial killers are pretty terrifying and justifiably get a lot of TV shows and FBI task forces aimed at them. But we'd save as many lives by giving FSA administrators 25 years to life every time they decide to reconcile to the last cent. And we should be watching Law & Order: FSA where the detectives drink to conceal the pain of uploading a PDF and explaining your situation in 500 characters or less.
Or we could save the time and money and lives and implement single payer healthcare.
(Published to the Fediverse as:
Lock up the Flexible Spending Account Administrators #etc#hsa#fsa Flexible spending account administrators probably kill more Americans than serial killers and should probably suffer similar consequences.)
For no good reason I downloaded my gas and electricity consumption data by day for the last couple of years.
The electricity trend is unsurprising. At the start of the pandemic it jumps up and stays up. With work and school from home we're running four computers non-stop, burning lights and (the horror) printing things. Overall we used 24% more electricity in 2020.
Gas on the other hand is pretty flat. There are some different peaks at the start and end of the year, but our total gas consumption increased by 0.08%. This doesn't make any sense to me. Being at home doesn't make much of a difference to laundry but it should have had a big impact on everything else. The heating has been on way more, we're cooking breakfasts and lunches that would have occurred out of the house in 2019 and we must be using more hot water as well.
There is one strange difference between how electricity and gas are metered. Fractional kWh are distributed randomly between .00 and .99 as you'd expect. Fractional therms are totally different - we're apparently likely to use 1.02 or 2.03 therms but never 1.50. This feels like it must be some sort of rounding or other billing oddness but I can't find any reasonable explanation despite asking Google three different ways.
In a move that I might come to bitterly regret I have emailed PG&E to see if they can explain it. I'll update this post if I hear back. Or if you're a therm metering expert please leave a comment!
Updated 2021-02-20 13:51:
PG&E say:
"Thank you for contacting our Customer Service Center. Gas usage is registered by recording therms usage. If you view your daily usage online, you will see that therms are only registered in whole units. The only pace that you will see therms not as whole units is when you review the average daily usage. The pandemic started in March 2020 and since then your gas usage is up slightly versus previous years. Most customers will see a larger increase in electric usage versus gas usage when staying home more than normal. The majority of customers set the tempatures of the their heaters to very similar temperatures year over year and your heater will work to keep your house at the temperature whether you are home or not at home."
So the fractional therms are some sort of odd rounding on the downloaded data. Fair enough.
The majority of customers use the same temperature setting? Really? So that might be a good explanation if you constantly heat your house to the same temperature, but I know for sure that isn't us. We have a Nest Learning Thermostat and as I've previously reported this doesn't so much learn as just constantly turn the heating off. So staying warm is a constant battle with the thing.
Maybe the difference is that the pandemic started around Spring when San Francisco is warm enough to not need much heating. I'll look again when I can just compare winter vs winter in a couple of months.
Updated 2023-08-06 18:11:
Took a while to update, but here is some more data. Electricity stayed high until Spring 2021 and then dropped to roughly pre-pandemic levels. This is because I spent a lot of time in 2021 upgrading lighting. My house has a different type of fixture/bulb in every room making this a painful process but I'm almost 100% LED at this point which has made a difference. Gas on the other hand has got higher and stayed there and I should really replace some more windows and add some more insulation...
I really wish the utility companies made this data available through some useful API instead of needing to download the occasional CSV. I'd build a dashboard and obsess over energy usage far more.
(Published to the Fediverse as:
Pandemic Gas Mystery #etc#coronavirus#gas#electricity Why is my gas bill flat in 2020 when electricity usage has gone up 24%? A pandemic gas mystery based on PG&E data.)
(Published to the Fediverse as:
Accessing Printer Press ESC to cancel #etc#excel#microsoft How to fix the annoying Accessing Printer Press ESC to cancel wait in Excel by setting a different default printer in Windows 10.)
I migrated from Nest to Google Home today to save a few bucks and while eventually inevitable it was a really dumb move.
The first thing is that it doesn't work with your Google Workspace / G Suite account because of course it doesn't. So you need an unpaid Google account to move to. Luckily I already have one from that time that G Suite didn't support Google Fi. Interestingly while Google Home won't work with your paid account it has no problem reaching over to grab credit card information from it.
The next thing is goodbye Works with Nest, hello Works with Hey Google. So there goes my IFTTT integration. Because I can't use my main Google account it's kind of useless to me that this might work with Google Assistant. There is still Alexa integration though so I can play my Nest stream on the Echo Show once a year or so as a connected home party trick.
Having not read the changed terms of service I downloaded the Google Home app which a few minutes in I've take to calling Google Nope.
Nest Protect is not supported! This is my favorite smart home device just because when the battery runs out it can tell you which one to change. It's worth almost any amount of money to not spend several hours figuring out where in the house the omnidirectional smoke detector chirp is coming from. But for some reason Google Home doesn't integrate with Google Nest Protect so you need to keep the Nest app as well. Understandable, they only have several tens of thousands of engineers.
So they nailed the camera experience at least, right? Nope. In Nest there are about a hundred settings to play with. In Google Home you can change the name of the camera. In Nest you can scroll through all of your recorded history. In Google Home, despite specifically paying for the plan with 10 days of history you can't. It has a pre-Alpha feel to it. Good for a 'hey, we got the skeleton of an app thrown together' kind of internal demo but it feels like they probably should have added the things you've paid for before shipping it to anyone, let alone bribing them to go through a feature shredding 'migration' process.
My smart home ambitions are not that great. I had a nice little setup that switched some lights on and off around dawn and dusk, but Philips end-of-lifed the bridge and I'm not about to buy a new one. I had some fun making dropcam timelapses but Google broke the public cam URL. And thank goodness I didn't get the alarm system.
Lesson (eventually) learned. The only new smart home devices I'll install are the ones that I build myself.
(Published to the Fediverse as:
Leaving the Nest #etc#google#nest#philips The pain of migrating from Nest to Google Home which is not fully baked and does not support Workspace accounts.)
By Robert Ellison. Updated on Thursday, August 26, 2021.
You have to make allowances for the fact that many people are working from home (where maybe it's harder to test code and you certainly can't do hallway usability testing). Things also improved somewhat with the October patch. But Android 11 was a Windows ME level disaster. Google says that they dropped the desserts to make Android 'more accessible to a global audience' but I think it's probably because they know that new updates are no longer sweet.
Multi-tasking is completely broken. In pandemic mode I'm on video calls all day, and dodging the 2-3 video calls that are usually going on elsewhere in my house. Being able to have Teams and notes running at the same time is pretty important right now and with 11 it's not possible.
Other than conference calls and Kindle the other main use I have for my phone is podcasts. Android 11 improved the media controls by moving them to the quick settings area of the notification shade, providing easy switching between playback devices and allowing you to swipe through recent playback apps. All good, except that none of it works. The controls are there but do nothing so I have to run the app to pause. Also, there is a weird ghost of a previous media playback that shows up and then disappears when pulling down the notification shade. And as for dismissing previous sessions that seems to require a reboot.
Multi-tasking and media were fixed in the most recent patch, but there is also some new notification system to separate out conversations. In practice this seems to mean I get multiple groups of Gmail and Teams notifications instead of a single cluster per app. This isn't what I want, gives me more work to do and so far I haven't found a way to turn it off. Notifications have steadily improved over the last few major Android releases so it's upsetting to see them becoming worse.
This is all on a Pixel 4XL which you would assume would get some level of testing love. It used to be that the main advantage of a Pixel was getting new versions of Android quickly. With 11 I'm for the first time wishing I was waiting a few months while the kinks were worked out.
By Robert Ellison. Updated on Saturday, November 18, 2023.
This doesn't work any more as Purple is charging for their API. Sorry.
This post is updated hourly with a PM2.5 (2.5 micrometer or smaller particulate matter) map of San Francisco.
The video below shows the past 48 hours at six frames per second.
The PM2.5 data comes from the Purple Air API. The map uses one hour average readings from outdoor sensors and interpolates each point in San Francisco based on the inverse of the distance to the four closest sensors. The color scale is green to yellow (0-50), yellow to orange (50-100), orange to red (100-150) and red to purple (150-200+). San Francisco is plotted using elevation contours from DataSF.
Updated 2022-06-11 12:28:
The map is currently broken. The URL I use to download sensor data started returning a 500 error code at the end of may (Error: Server Error / The server encountered an error and could not complete your request. Please try again in 30 seconds.). This seemed like something Purple would need to fix. On closer inspection the error occurs after a redirect to https://purpleair-over-quota-2.appspot.com/ which sounds like too many requests (a 4xx error surely). With even more digging it turns out the download link is no longer supported (410 maybe then?) and so I'll need to migrate to the REST API to get this working again. I'm currently trying to get an API key and will get this fixed as soon as I can.
Updated 2022-06-13 17:28:
Purple Air were kind enough to issue me with an API key so the map is back to updating hourly.
Updated 2023-11-08 00:26:
And it's broken again. Purple have decided to start charging for their API. This is a shame, and I don't think I can pay for this just to keep this post running. I'm going to try moving to the AirNow system for some use cases, but it's not going to work for a detailed map of San Francisco as there is only one official sensor here.
