The Morning of Hitting the Zone with Datasette

I'm starting to be handy enough with Datasette that I can quickly get answers to my questions!

This morning, the question is whether or not the Tuna Topper amplifier combined with the Rockmite is giving better propagation results than the we get with the Rockmite running alone. Since we have a database of all the QSOs and RBN spots of the Rockmite, this is exactly the kind of question Datasette can answer.

Here are the commands to run datasette to get an sqlite database from the Rockmite's RBN and QSO data table. I'm listing the commands here because I've been to lazy to simply write a script, and thus far I haven't been able to get the whole assmeblelage to work on Windows, meaning I'm working on a github codespace. Codespaces are super-cool, but also—at least for me... so far—completely unable to keep command history around between launches

python -m pip install csvs-to-sqlite

python -m pip install pandas==1.5.0

csvs-to-sqlite -dt timestamp rm_rnb_history_pres.csv rm_toucans.db

The pandas install is necessary for an issue the Datasette csvs-to-sqlite utility has with the newer pandas versions.

Once I had my new database, I installed the super-cool datasette-cluster-map plugin on my windows machine

python -m datasette install datasette-cluster-map

Then! I renamed columns in SQL to get a cluster map of locations where the Rockmite was spotted by W6BB—UC Berkeley's across the Bay ham shack—with an SNR greater than or equal to 18 dB, (the result I'd seen this morning while testing the amplifier..

Here's the SQL command:

select tx_lng, tx_lat, rx_lng, rx_lat, timestamp, dB, frequency, tx_lng as longitude, tx_lat as latitude from rm_rnb_history_pres where "Spotter" = :p0 and dB >= 18 order by dB Desc limit 101

And I got back my results complete with a very helpful map that answered my quesstion!

While the Rockmite has reached W6BB with an SNR greater than 18 on several occasions, only three of those were from the home station in Excelsior and all three of those were this morning with the assistance of the Tuna Topper amplifier!

Comments

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...

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 ...

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:...

Copasetic Flow

Search This Blog