Things I Learned: Serving Images in Datasette

I had to take a few weeks' break before this one made sense to me. It finally did though, and now when the gang and I look at our QSO map in Datasette, we can see which outing generated a QSO by clicking on the marker of the receiving ham radio station.

So, for example, if we're wondering when we finally made that recent QSO with Hawaii? Oh yeah, it was during the California QSO party!

We've still got some data entry to do—if I had more tactical time at the moment, I'd use the datasette-write package and a form to make the entries more quickly... Anywway—but eventually, we'll have a pretty slick map.

The technical details

As for the details of what finally got everything to work for me (on a Windows machine.) You'll need

datasette

datasette-cluster-map

datasette-media

datasette-json-html

and a metadata.json file. (This was the bit that just kind of hurt me deep down and slowed me up for a few weeks. Once I accepted that there was no way around, and then spent time decoupling what looked like weird notation—at the time—to me, from what the file was actually doing, everything got better fast.) If you click through to mine using the link above, the important thing to realize is that the QSL 'select' statement it specifies is simply used to return the path that's associated with the 'key' (value of uuid) in photo_paths.csv.

The SQL query that constructed the map above for us is:

select rm_rnb_history_pres.rx_lng as longitude , rm_rnb_history_pres.rx_lat as latitude, rm_rnb_history_pres.timestamp, rm_rnb_history_pres.dB, rm_rnb_history_pres.Spotter, rm_rnb_history_pres.QSL_link, photo_path.path, photo_path.uuid, json_object(

'image',

'/-/media/thumbnail/' || uuid,

'title', Spotter || ' de KD0FNR',

'description', 'rx_rst: ' || dB || ' timestamp: ' || rm_rnb_history_pres.timestamp

) as popup

from rm_rnb_history_pres LEFT JOIN photo_path ON rm_rnb_history_pres.QSL_link = photo_path.uuid where (db > 100 or db = 0)

The things to note here is that the call to json_object is explained in the cluster map plugin Readme file. Again, everything could have gone more quickly for me if I'd only read this file down to the section I just linked to. It's the reason for the popup column in the query above, and it just works. It's so nice once it does!

Comments

More Cowbell! Record Production using Google Forms and Charts

First, the what : This article shows how to embed a new Google Form into any web page. To demonstrate ths, a chart and form that allow blog readers to control the recording levels of each instrument in Blue Oyster Cult's "(Don't Fear) The Reaper" is used. HTML code from the Google version of the form included on this page is shown and the parts that need to be modified are highlighted. Next, the why : Google recently released an e-mail form feature that allows users of Google Documents to create an e-mail a form that automatically places each user's input into an associated spreadsheet. As it turns out, with a little bit of work, the forms that are created by Google Docs can be embedded into any web page. Now, The Goods: Click on the instrument you want turned up, click the submit button and then refresh the page. Through the magic of Google Forms as soon as you click on submit and refresh this web page, the data chart will update immediately. Turn up the:

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 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 concept very sim

Copasetic Flow

Search This Blog