Things I Learned: The Google Maps Elevation API and jq

This is moving kind of fast!

Regarding the goal of automating elevations using Datasette and the Google Maps Elevation API. I pulled a QSO out of a hat last night and tried the coordinates between stations in a call to the Google Maps Elevation API.

The URL to use the API looked like this:

https://maps.googleapis.com/maps/api/elevation/json?path=37.7248952%2C-122.4229361%7C37.7247294%2C-122.4207246&samples=200&key=

where the path parameter contains two coordinates separated by %7C (html encoding for the pipe symbol: '|') and commas (aka %2C) define the coordinates of the tx station and the coordinate of a point 200 meters along the path to the rx station, and the samples parameter tells the API how many points to split the path into and return elevations for. It's all documented by Google here.

I was quickly rewarded with data that looked like the following:

{
   "results" : 
   [
      {
         "elevation" : 123.6165237426758,
         "location" : 
         {
            "lat" : 37.72489522009444,
            "lng" : -122.4229361744053
         },
         "resolution" : 9.543951988220215
      },
      {
         "elevation" : 123.4337463378906,
         "location" : 
         {
            "lat" : 37.72489438728456,
            "lng" : -122.4229250613661
         },
         "resolution" : 9.543951988220215
      },...

I passed that into a jq filter, (yes it did take a little experimentation and stack overflow), to get data that looked like

0,123.6165237426758
1,123.4337463378906
2,123.2948989868164
3,123.1553573608398
...

For reference, the jq filter I used is

.results | keys[] as $k | [$k, .[$k].elevation] | @csv

I then used to Google Sheets to graph (look towards the bottom of the sheet) the elevation and compared that graph to the Google Earth Pro result for the same QSO.

Not to shabby for a first try:

Google Earth

The same data from the API plotted in Google Sheets

Also cute! ( I think )

When I looked for my notes on jq, I found out that the project that became this whole mapping thing started about a year ago in January.

Comments

Cool Math Tricks: Deriving the Divergence, (Del or Nabla) into New (Cylindrical) Coordinate Systems

Now available as a Kindle ebook for 99 cents ! Get a spiffy ebook, and fund more physics The following is a pretty lengthy procedure, but converting the divergence, (nabla, del) operator between coordinate systems comes up pretty often. While there are tables for converting between common coordinate systems , there seem to be fewer explanations of the procedure for deriving the conversion, so here goes! What do we actually want? To convert the Cartesian nabla to the nabla for another coordinate system, say… cylindrical coordinates. What we’ll need: 1. The Cartesian Nabla: 2. A set of equations relating the Cartesian coordinates to cylindrical coordinates: 3. A set of equations relating the Cartesian basis vectors to the basis vectors of the new coordinate system: How to do it: Use the chain rule for differentiation to convert the derivatives with respect to the Cartesian variables to derivatives with respect to the cylindrical variables. The chain ...

The Alcubierre Warp Drive Tophat Function and Open Science with Sage

I transferred yesterday's Mathematica file with the Alcubierre warp drive[2] line element and space curvature calculations to the +Sage Mathematical Software System today, (the files been added to the public repository [3]). If you haven't used Sage before, it's a Python based software package that's similar in functionality to Mathematica. Oh, and it' free. I also worked a little more on understanding the theory, but frankly, I made far more progress with the software than the theory. What follows will be a little more of the Alcubierre theory, plus, a cool Sage interactive demo of one of the Alcubierre functions[1], as well as a bit about my first experience with using Sage. Theory The theory is fun, but it's moving slowly. Here's the chalk board from this morning's discussion Alcubierre setup the derivation using something called the 3+1 formalism which means we consider space to be flat, (in this case), slices that are labelled ...

The Valentine's Day Magnetic Monopole

There's an assymetry to the form of the two Maxwell's equations shown in picture 1. While the divergence of the electric field is proportional to the electric charge density at a given point, the divergence of the magnetic field is equal to zero. This is typically explained in the following way. While we know that electrons, the fundamental electric charge carriers exist, evidence seems to indicate that magnetic monopoles, the particles that would carry magnetic 'charge', either don't exist, or, the energies required to create them are so high that they are exceedingly rare. That doesn't stop us from looking for them though! Keeping with the theme of Fairbank[1] and his academic progeny over the semester break, today's post is about the discovery of a magnetic monopole candidate event by one of the Fairbank's graduate students, Blas Cabrera[2]. Cabrera was utilizing a loop type of magnetic monopole detector. Its operation is in...

Copasetic Flow

Search This Blog