Catfood Earth 3.42

Updated on Wednesday, February 22, 2017

Catfood Earth 3.42

Catfood Earth 3.42 is a small update to the latest (2016d) timezone database and the latest timezone world and countries maps from Eric Muller. If you use the political borders, places or time zones layers in Catfood Earth then you'll want to install this version.

Download the latest Catfood Earth.

(Previously)

Automate Google PageSpeed Insights with Apps Script

Updated on Sunday, March 14, 2021

Upload

Here's a quick script to automatically monitor your Google PageSpeed Insights desktop and mobile scores for a web page:

You need a spreadsheet with a tab called results and an API key for PageSpeed Insights (activate the API in the console and create an API key for it, the browser based / JavaScript option). Paste the code above into the script editor for the spreadsheet and add your API key and URL to monitor. Then just choose triggers from the Resources menu and schedule the monitor function to run once per day.

Note that this currently just logs the overall score. There are a bunch of other values returned (like number and types of resources on the page) that you could choose to monitor as well. It would also be easy to extend this to monitor more URLs, or to send you an email if the score drops below a threshold.

Updated May 5, 2019 to use version 5 of the PageSpeed API.

More Google Apps Script Projects

Vernal Equinox 2016

Vernal Equinox 2016

It's the start of Spring, unless you're equatorially challenged in which case welcome to Autumn.

Rendered in Catfood Earth (Windows, Android).

(Previously, Previously)

Catfood Software Support

Updated on Tuesday, May 4, 2021

Catfood Software Support

Need help with a Catfood Software product? Please leave a comment below.

Get an email when your security camera sees something new (Apps Script + Cloud Vision)

Updated on Sunday, March 14, 2021

Get an email when your security camera sees something new (Apps Script + Cloud Vision)

Nest (previously DropCam) can email you when it detects activity but that gets boring quickly. How about an email only when it sees something totally new?

The script below downloads a frame from a web cam and then calls the Google Cloud Vision API to label features. It keeps a record of everything that has previously been seen and only sends an email when a new feature is detected. You could easily tweak this to email on a specific feature (i.e. every time your dog is spotted), or to count the number of times a feature appears. I'm using a Nest cam but any security camera that has a publicly visible image download URL will work.

There is a bit of setup to get this working. Create a new Apps Script project in Google Drive and paste the code above in. You'll need to provide you own values for the three variables at the top.

OAuthCreds is the contents of the JSON format private key file for a Google Developer Console project. Go to the console, create a new project and enable the Cloud Vision API. You'll also need to enable billing (more on this below) - a trial account will work fine for this. Once the API is enabled create a service account under Credentials and download the JSON file. Just paste the contents of this into the script.

That's the hard part over. Now enter the URL of the image to monitor (see this post for instructions on finding this for a Nest / DropCam device) as MonitorImageUrl and your email address for SendEmailTo.

One last thing - follow the instructions here to reference the OAuth2 for Apps Script library.

Once this is all done run the script (the main() function) and authorize it. You should get an email with a picture attached and a list of the labels detected together with a confidence score from 0 to 1. If this doesn't happen check the logs (under the View menu).

You can now schedule the script to run repeatedly (Resources -> Current project's triggers). You get up to 1,000 units a month for free so once an hour should be safe. If you need more frequent updates check the Cloud Vision pricing guide for details.

After a few runs you should only get an email when something new is detected. If you're seeing too many wild guesses then add a filter on the score to exclude low confidence features.

Enjoy, and leave a comment if you have problems (or modify this in interesting ways).

(Previously)

More Google Apps Script Projects

Shapefile Update

Updated on Friday, May 14, 2021

A few people have asked for 3D shape support in my ESRI Shapefile library. I've never got around to it, but CodePlex user ekleiman has forked a version in his ESRI Shapefile to Image Convertor that supports PointZ, PolygonZ and PolyLineZ shapes. If that's what you need please check it out.

Winter Solstice 2015

Winter Solstice 2015

Winter Solstice 2015 rendered in Catfood Earth (Windows, Android).

(Previously, Previously)

Catfood Earth 3.41

Updated on Wednesday, February 22, 2017

Catfood Earth 3.41

Catfood Earth 3.41 fixes a problem that was preventing the weather radar layer from loading.

I've also updated to the latest (2015g) time zone database and the latest time zone map from Eric Muller.

Download the latest Catfood Earth.

(Previously)

Autumnal Equinox 2015

Updated on Thursday, November 12, 2015

Autumnal Equinox 2015

Autumn begins right now in the northern hemisphere, Spring for the hemispherically challenged. Rendered in Catfood Earth (Windows, Android).

(previously, previously)

Catfood Weather 2.20

Updated on Wednesday, February 22, 2017

Catfood Weather 2.20

Catfood Weather 2.20 fixes a problem with the forecast failing to update (the National Weather Service changed the URL of the web service that Catfood Weather uses and while they were kind enough to put a redirect in place it was a form of redirect that didn't play nicely with WebClient so a patch is needed).

In addition this release should fix the ignore alerts feature. It's one of those cases that after not having looked at the code for a couple of years I suddenly realized that the implementation was fatally flawed (bordering on idiotic) and could never have worked. Should be better now.

Download Catfood Weather 2.20.

(previously)