KJ7RRV

FOSS

I wrote a simple #FOSS Web app called Altimeter Practice. As the name implies, it's for practicing how to read altimeters. Most instruments used in #aviation are fairly simple to read (an airspeed indicator, for example, is not much different to read from a car's speedometer), but three-hand altimeters are more complicated. This site shows a random altitude from 0 to 18,000 feet, and you read the altitude and type it into the text box.

Thank you to Raymond Blaga, Edward Hanna, Pavlo Kuzhel, and Sébastien Matton for developing the original code that I use to display the altimeter.

More #RandomOpenData! Feel free to use this data for whatever you would like. This data is published in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose.

This breaks the number of current FCC-issued US #HamRadio licenses by state and license class.

This data is obtained by scraping the ARRL's FCC License Counts page, which is in turn based on data published by the FCC.

Because this data will change over time, I included both the data in JSON format and a Python script to obtain the data. I update the JSON data when I think about it, but it's better to use the script to get the data yourself if you need it to be up to date.

Scraper program

#!/usr/bin/env python3

# ham_stats.py - get statistics on US amateur radio licenses by state and class
#
# Copyright 2023 Samuel Sloniker KJ7RRV
#
# Permission to use, copy, modify, and/or distribute this software for any
# purpose with or without fee is hereby granted.
#
# THE SOFTWARE IS PROVIDED “AS IS” AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH
# REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
# AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT,
# INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
# LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR
# OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
# PERFORMANCE OF THIS SOFTWARE.

import json
import datetime
import requests
import bs4

page = requests.get("http://www.arrl.org/fcc-license-counts")
soup = bs4.BeautifulSoup(page.text, features="lxml")

date = datetime.datetime.strptime(
    soup.find(id="content").find("em").text.split(" ")[-1], "%d-%b-%Y"
).strftime("%Y-%m-%d")

classes = [cell.text for cell in soup.find("tr")][1:]
table_data = {
    row.find("td").text.replace("*", ""): {
        classes[number]: int("0" + cell.text)
        for number, cell in enumerate(row.find_all("td")[1:])
    }
    for row in soup.find_all("tr")[1:]
}

print(json.dumps({"date": date, "data": table_data}))

Current data as of April 19, 2023

{"date": "2023-10-19", "data": {"Alabama": {"Novice": 67, "Tech": 5445, "Tech-Plus": 0, "General": 3158, "Advanced": 537, "Extra": 2882, "Total": 12089}, "Alaska": {"Novice": 15, "Tech": 1565, "Tech-Plus": 0, "General": 887, "Advanced": 147, "Extra": 661, "Total": 3275}, "Arizona": {"Novice": 112, "Tech": 11136, "Tech-Plus": 0, "General": 5121, "Advanced": 1002, "Extra": 4565, "Total": 21936}, "Arkansas": {"Novice": 39, "Tech": 4107, "Tech-Plus": 0, "General": 1960, "Advanced": 312, "Extra": 1616, "Total": 8034}, "California": {"Novice": 648, "Tech": 58946, "Tech-Plus": 0, "General": 19532, "Advanced": 3434, "Extra": 15521, "Total": 98081}, "Colorado": {"Novice": 90, "Tech": 10653, "Tech-Plus": 0, "General": 4555, "Advanced": 708, "Extra": 3748, "Total": 19754}, "Connecticut": {"Novice": 121, "Tech": 3122, "Tech-Plus": 0, "General": 1891, "Advanced": 387, "Extra": 1686, "Total": 7207}, "Delaware": {"Novice": 20, "Tech": 768, "Tech-Plus": 0, "General": 509, "Advanced": 86, "Extra": 416, "Total": 1799}, "District of Columbia": {"Novice": 4, "Tech": 254, "Tech-Plus": 0, "General": 114, "Advanced": 20, "Extra": 118, "Total": 510}, "Florida": {"Novice": 437, "Tech": 18293, "Tech-Plus": 0, "General": 11839, "Advanced": 2533, "Extra": 9971, "Total": 43073}, "Georgia": {"Novice": 110, "Tech": 8791, "Tech-Plus": 0, "General": 4971, "Advanced": 829, "Extra": 4101, "Total": 18802}, "Guam": {"Novice": 1, "Tech": 104, "Tech-Plus": 0, "General": 50, "Advanced": 8, "Extra": 102, "Total": 265}, "Hawaii": {"Novice": 29, "Tech": 2030, "Tech-Plus": 0, "General": 770, "Advanced": 146, "Extra": 687, "Total": 3662}, "Idaho": {"Novice": 28, "Tech": 6483, "Tech-Plus": 0, "General": 2535, "Advanced": 246, "Extra": 1618, "Total": 10910}, "Illinois": {"Novice": 257, "Tech": 8576, "Tech-Plus": 0, "General": 5290, "Advanced": 1010, "Extra": 4386, "Total": 19519}, "Indiana": {"Novice": 168, "Tech": 7240, "Tech-Plus": 0, "General": 4148, "Advanced": 717, "Extra": 3179, "Total": 15452}, "Iowa": {"Novice": 55, "Tech": 2987, "Tech-Plus": 0, "General": 1685, "Advanced": 403, "Extra": 1493, "Total": 6623}, "Kansas": {"Novice": 70, "Tech": 3381, "Tech-Plus": 0, "General": 1936, "Advanced": 289, "Extra": 1535, "Total": 7211}, "Kentucky": {"Novice": 72, "Tech": 4573, "Tech-Plus": 0, "General": 2546, "Advanced": 408, "Extra": 2025, "Total": 9624}, "Louisiana": {"Novice": 60, "Tech": 2623, "Tech-Plus": 0, "General": 1689, "Advanced": 335, "Extra": 1354, "Total": 6061}, "Maine": {"Novice": 38, "Tech": 1853, "Tech-Plus": 0, "General": 1261, "Advanced": 213, "Extra": 1107, "Total": 4472}, "Maryland": {"Novice": 100, "Tech": 4768, "Tech-Plus": 0, "General": 2811, "Advanced": 541, "Extra": 2662, "Total": 10882}, "Massachusetts": {"Novice": 147, "Tech": 5746, "Tech-Plus": 0, "General": 3487, "Advanced": 661, "Extra": 3275, "Total": 13316}, "Michigan": {"Novice": 176, "Tech": 9764, "Tech-Plus": 0, "General": 5349, "Advanced": 988, "Extra": 4675, "Total": 20952}, "Minnesota": {"Novice": 108, "Tech": 5280, "Tech-Plus": 0, "General": 2970, "Advanced": 600, "Extra": 2509, "Total": 11467}, "Mississippi": {"Novice": 23, "Tech": 2174, "Tech-Plus": 0, "General": 1359, "Advanced": 223, "Extra": 1262, "Total": 5041}, "Missouri": {"Novice": 98, "Tech": 7503, "Tech-Plus": 0, "General": 3866, "Advanced": 637, "Extra": 3079, "Total": 15183}, "Montana": {"Novice": 27, "Tech": 2244, "Tech-Plus": 0, "General": 1172, "Advanced": 171, "Extra": 821, "Total": 4435}, "Nebraska": {"Novice": 28, "Tech": 1697, "Tech-Plus": 0, "General": 1038, "Advanced": 221, "Extra": 752, "Total": 3736}, "Nevada": {"Novice": 37, "Tech": 4505, "Tech-Plus": 0, "General": 1888, "Advanced": 318, "Extra": 1527, "Total": 8275}, "New Hampshire": {"Novice": 52, "Tech": 2437, "Tech-Plus": 0, "General": 1489, "Advanced": 261, "Extra": 1480, "Total": 5719}, "New Jersey": {"Novice": 196, "Tech": 5944, "Tech-Plus": 0, "General": 3232, "Advanced": 710, "Extra": 3072, "Total": 13154}, "New Mexico": {"Novice": 27, "Tech": 3256, "Tech-Plus": 0, "General": 1469, "Advanced": 272, "Extra": 1332, "Total": 6356}, "New York": {"Novice": 400, "Tech": 11825, "Tech-Plus": 0, "General": 6805, "Advanced": 1363, "Extra": 5923, "Total": 26316}, "North Carolina": {"Novice": 145, "Tech": 10303, "Tech-Plus": 0, "General": 5876, "Advanced": 1018, "Extra": 5131, "Total": 22473}, "North Dakota": {"Novice": 10, "Tech": 743, "Tech-Plus": 0, "General": 419, "Advanced": 63, "Extra": 300, "Total": 1535}, "Ohio": {"Novice": 319, "Tech": 12255, "Tech-Plus": 0, "General": 7404, "Advanced": 1294, "Extra": 6107, "Total": 27379}, "Oklahoma": {"Novice": 44, "Tech": 5003, "Tech-Plus": 0, "General": 2527, "Advanced": 376, "Extra": 1985, "Total": 9935}, "Oregon": {"Novice": 101, "Tech": 11190, "Tech-Plus": 0, "General": 4967, "Advanced": 707, "Extra": 3578, "Total": 20543}, "Pennsylvania": {"Novice": 276, "Tech": 10644, "Tech-Plus": 0, "General": 6351, "Advanced": 1293, "Extra": 5579, "Total": 24143}, "Puerto Rico": {"Novice": 100, "Tech": 2917, "Tech-Plus": 0, "General": 1195, "Advanced": 172, "Extra": 702, "Total": 5086}, "Rhode Island": {"Novice": 21, "Tech": 837, "Tech-Plus": 0, "General": 486, "Advanced": 90, "Extra": 460, "Total": 1894}, "South Carolina": {"Novice": 59, "Tech": 4690, "Tech-Plus": 0, "General": 2732, "Advanced": 471, "Extra": 2361, "Total": 10313}, "South Dakota": {"Novice": 16, "Tech": 887, "Tech-Plus": 0, "General": 598, "Advanced": 116, "Extra": 485, "Total": 2102}, "Tennessee": {"Novice": 112, "Tech": 9281, "Tech-Plus": 0, "General": 5196, "Advanced": 813, "Extra": 4372, "Total": 19774}, "Texas": {"Novice": 293, "Tech": 26659, "Tech-Plus": 0, "General": 13308, "Advanced": 2289, "Extra": 11236, "Total": 53785}, "Utah": {"Novice": 35, "Tech": 12721, "Tech-Plus": 0, "General": 3267, "Advanced": 307, "Extra": 2133, "Total": 18463}, "Vermont": {"Novice": 14, "Tech": 973, "Tech-Plus": 0, "General": 526, "Advanced": 103, "Extra": 496, "Total": 2112}, "Virgin Islands": {"Novice": 0, "Tech": 117, "Tech-Plus": 0, "General": 71, "Advanced": 10, "Extra": 53, "Total": 251}, "Virginia": {"Novice": 179, "Tech": 9406, "Tech-Plus": 0, "General": 5353, "Advanced": 935, "Extra": 4804, "Total": 20677}, "Washington": {"Novice": 187, "Tech": 18746, "Tech-Plus": 0, "General": 8128, "Advanced": 1136, "Extra": 5717, "Total": 33914}, "West Virginia": {"Novice": 41, "Tech": 3054, "Tech-Plus": 0, "General": 1444, "Advanced": 213, "Extra": 1244, "Total": 5996}, "Wisconsin": {"Novice": 93, "Tech": 4802, "Tech-Plus": 0, "General": 3217, "Advanced": 561, "Extra": 2553, "Total": 11226}, "Wyoming": {"Novice": 10, "Tech": 1014, "Tech-Plus": 0, "General": 646, "Advanced": 114, "Extra": 471, "Total": 2255}, "Other": {"Novice": 1, "Tech": 284, "Tech-Plus": 0, "General": 95, "Advanced": 7, "Extra": 201, "Total": 588}, "TOTAL": {"Novice": 5916, "Tech": 376599, "Tech-Plus": 0, "General": 187188, "Advanced": 32824, "Extra": 155108, "Total": 757635}}}

#Programming #FOSS

This is the first of a series of posts of #RandomOpenData. These posts will contain public-domain data in JSON and other readily-usable, machine-readable formats.

Feel free to use this data for whatever you would like. This data is published in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose.

Array of state names

["Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming"]

Array of state abbreviations

["AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DE", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NB", "NV", "NH", "NJ", "NM", "NY", "NC", "ND", "OH", "OK", "OR", "PA", "RI", "SC", "SD", "TN", "TX", "UT", "VT", "VA", "WA", "WV", "WI", "WY"]

Dictionary of states to abbreviations

{"Alabama": "AL", "Alaska": "AK", "Arizona": "AZ", "Arkansas": "AR", "California": "CA", "Colorado": "CO", "Connecticut": "CT", "Delaware": "DE", "Florida": "FL", "Georgia": "GA", "Hawaii": "HI", "Idaho": "ID", "Illinois": "IL", "Indiana": "IN", "Iowa": "IA", "Kansas": "KS", "Kentucky": "KY", "Louisiana": "LA", "Maine": "ME", "Maryland": "MD", "Massachusetts": "MA", "Michigan": "MI", "Minnesota": "MN", "Mississippi": "MS", "Missouri": "MO", "Montana": "MT", "Nebraska": "NB", "Nevada": "NV", "New Hampshire": "NH", "New Jersey": "NJ", "New Mexico": "NM", "New York": "NY", "North Carolina": "NC", "North Dakota": "ND", "Ohio": "OH", "Oklahoma": "OK", "Oregon": "OR", "Pennsylvania": "PA", "Rhode Island": "RI", "South Carolina": "SC", "South Dakota": "SD", "Tennessee": "TN", "Texas": "TX", "Utah": "UT", "Vermont": "VT", "Virginia": "VA", "Washington": "WA", "West Virginia": "WV", "Wisconsin": "WI", "Wyoming": "WY"}

Dictionary of abbreviations to states

{"AL": "Alabama", "AK": "Alaska", "AZ": "Arizona", "AR": "Arkansas", "CA": "California", "CO": "Colorado", "CT": "Connecticut", "DE": "Delaware", "FL": "Florida", "GA": "Georgia", "HI": "Hawaii", "ID": "Idaho", "IL": "Illinois", "IN": "Indiana", "IA": "Iowa", "KS": "Kansas", "KY": "Kentucky", "LA": "Louisiana", "ME": "Maine", "MD": "Maryland", "MA": "Massachusetts", "MI": "Michigan", "MN": "Minnesota", "MS": "Mississippi", "MO": "Missouri", "MT": "Montana", "NB": "Nebraska", "NV": "Nevada", "NH": "New Hampshire", "NJ": "New Jersey", "NM": "New Mexico", "NY": "New York", "NC": "North Carolina", "ND": "North Dakota", "OH": "Ohio", "OK": "Oklahoma", "OR": "Oregon", "PA": "Pennsylvania", "RI": "Rhode Island", "SC": "South Carolina", "SD": "South Dakota", "TN": "Tennessee", "TX": "Texas", "UT": "Utah", "VT": "Vermont", "VA": "Virginia", "WA": "Washington", "WV": "West Virginia", "WI": "Wisconsin", "WY": "Wyoming"}

#Programming #FOSS

I wrote a #MediaWiki template that allows for the creation of templates that change based on user configuration.

Edit: This will invalidate MediaWiki cache on pages that use it, increasing server CPU usage and page load times. Use this template sparingly.

Dependencies/Prerequisites

The GetUserName and ParserFunctions extensions are required. Also, you must create namespaces called DefaultConfig and UserConfig.

define("NS_DEFAULTCONFIG", 3000);
define("NS_DEFAULTCONFIG_TALK", 3001);
define("NS_USERCONFIG", 3002);
define("NS_USERCONFIG_TALK", 3003);
$wgExtraNamespaces[NS_USERCONFIG] = "UserConfig";
$wgExtraNamespaces[NS_USERCONFIG_TALK] = "UserConfig_talk";
$wgExtraNamespaces[NS_DEFAULTCONFIG] = "DefaultConfig";
$wgExtraNamespaces[NS_DEFAULTCONFIG_TALK] = "DefaultConfig_talk";
$wgNamespaceProtection[NS_DEFAULTCONFIG] = array("editdefaultconfig");
$wgGroupPermissions['sysop']['editdefaultconfig'] = true;
$wgCapitalLinkOverrides[NS_DEFAULTCONFIG] = false;
$wgCapitalLinkOverrides[NS_DEFAULTCONFIG_TALK] = false;
$wgNamespacesWithSubpages[NS_USERCONFIG] = true;
wfLoadExtension('GetUserName');
wfLoadExtension('ParserFunctions');

It is recommended to only allow administrators or other trusted users to edit the DefaultConfig namespace. Unfortunately, I am not aware of any way to prevent users from editing other users' UserConfig pages; this means that users can change the configuration settings of others.

Template

Put this in Template:Config:

{{#ifexist:DefaultConfig:{{{1}}}|{{#ifexist:UserConfig:{{#USERNAME:}}/{{{1}}}|{{UserConfig:{{#USERNAME:}}/{{{1}}}}}|{{ DefaultConfig:{{{1}}}}}}}|'''ERROR''': No such configuration option exists. Please {{#ifexist:UserConfig:{{#USERNAME:}}/isadmin|create|ask an administrator to create}} [[DefaultConfig:{{{1}}}]].}}

If you wish, you can create a UserConfig:[username]/isadmin page for all admin users. This has no effect other than changing the error message, so it is not important. Unlike other configuration settings, the content of this page does not matter; it only has to exist.

Usage

Simply use {{config|[option name]}} to get a configuration option. You must have a DefaultConfig:[option name] page. By default, {{config}} will return its content. However, if a user has a UserConfig:[user name]/[option name] page, its content will be returned instead.

Example

On the PBARC Web site, we use this for several things, including a {{time}} template. This takes time values in the format {{time|18|45}} and allows users to choose whether to see times as “6:45 PM” (12-hour time) or “18:45” (24-hour/military time).

Here is the code for Template:Time:

{{#ifeq: {{config|miltime}}|true|{{{1}}}:{{{2}}}|{{#ifexpr: ({{{1}}} = 12) and ({{{2}}} = 00)|12:00 noon|{{#ifexpr: ({{{1}}} = 00) and ({{{2}}} = 00)|12:00 midnight| {{#ifeq: {{#expr: {{{1}}} mod 12}} | 0 | 12 | {{#expr: {{{1}}} mod 12}}}}:{{{2}}} {{#ifexpr: {{{1}}} < 12|AM|PM}}}}}}}}

It will check the miltime configuration value and, if it is true, use 24-hour time; otherwise, it will use 12-hour time. On the PBARC site, it is set to false by default, but it could also be set to true.

License

This post, including all code, is released into the public domain under Creative Commons Zero. Feel free to use it for any purpose without asking permission or giving attribution.

#PBARC #FOSS #Programming