State Parks App: Let’s try that again?

Last week, I got all the way to the end before the damn Google Sheets API stopped working on me.  This week, I figured that we would create a JSON file out of the spreadsheet, host it somewhere, and then just use that.  I started by creating a CSV file from the Google Sheets document, …

Continue reading "State Parks App: Let’s try that again?"

State Parks App: Let’s actually build something

Previously, we built an API for the State Parks App, using Google Sheets and we set up hosting for the thing.  The next step is to actually write the first bit of the thing.  When we created the API, we also wrote a little vue.js proof of concept that loops over the data and outputs …

Continue reading "State Parks App: Let’s actually build something"

I moved jws.dev off of keybase

This post is 50% housekeeping and 50% devops, and something that normally wouldn’t warrant a blog post but I’m still getting over last week’s vacation and didn’t want to wait another week before posting new content.  I promise that next week’s post is going to be more substantive.

Continue reading "I moved jws.dev off of keybase"

How to sort a list of locations by how close they are to you

One of the things that are most important to me for phase 1 of the state parks app is to have the list of parks be sorted by how far the user is from the park.  After all, Tower Hill State Park might be interesting but if you live 4 hours away, you aren’t likely …

Continue reading "How to sort a list of locations by how close they are to you"

Playing with COVID-19 data: D3.js Bar Charts

Last week, we gathered COVID-19 statistical data.  This week, we are going to try to build some charts using D3.js.  D3.js is a javascript library that allows you to generate some fairly fancy charts and graphs but we are going to start with some basic bar charts.  Let’s take a look at a simple example. …

Continue reading "Playing with COVID-19 data: D3.js Bar Charts"

Did you know that you can use Google Sheets as a JSON API?

You don’t necessarily need to write server-side code for everything.  Sometime there is a much easier solution.  Did you know that you can use Google Sheets as an API endpoint?  Let’s take a look at a quick example. For a few years now, I have been archiving my tweets as Google Sheets documents.  There is …

Continue reading "Did you know that you can use Google Sheets as a JSON API?"