met’s gists

met / gtfs_id_with_underscore.sql

Created October 7, 2024 21:25

Find stop gtfs id containing underscore with duckdb SQL

SELECT * FROM read_csv_auto('stops.txt') WHERE stop_id LIKE '%\_%' ESCAPE '\';

met / trasy_linek.sql

Created October 6, 2024 00:42

Get line routes from static GTFS

	SELECT
	route_short_name, stop_name, route_long_name, stop_sequence, route_stops.route_id, route_stops.stop_id
	FROM
	read_csv_auto("route_stops.txt") as route_stops
	INNER JOIN
	read_csv_auto("routes.txt") as routes ON route_stops.route_id = routes.route_id
	INNER JOIN
	read_csv_auto("stops.txt") as stops ON route_stops.stop_id = stops.stop_id
	WHERE
	route_stops.direction_id = 0

met / gtfs_character_check.sh

Last active October 6, 2024 09:53

Show all characters used in Prague public transit stop_names, headsigns and route_short_names

	#!/usr/bin/env bash

	# Download static GTFS for Prague PID and show all used characters in stop_names, trip_headsigns and, route_short_names
	# Require: curl, unzip and duckdb

	GTFS_PID_URL='https://data.pid.cz/PID_GTFS.zip'
	GTFS_ZIP_FILEMAME='pid_gtfs.zip'
	GTFS_DIRNAME='pid_gtfs'

	# check for file GTFS_ZIP_FILEMAME

met / vocabulary2zivyObraz.gs

Created September 15, 2024 17:02

Train vocabulary with ZivyObraz.cz

	// This work by Martin Hassman is marked with CC0 1.0
	// https://creativecommons.org/publicdomain/zero/1.0/?ref=chooser-v1
	//
	// How to use:
	// 1. Upload your vocabulary into 1st column of 1st sheet in Google Tables
	// 2. Set apiKey of https://zivyobraz.eu/
	// 3. Set time trigger to SetNewVocab() function
	// 4. Practice vocabulary

	function SetNewVocab() {

met / concatenate-mp3.js

Created January 27, 2024 05:11

Generate bat file for concatenating MP3. Each 18 MP3 from directory is added 2 times into one biger MP3 file

	// Generate bat file for concatenating MP3. Each 18 MP3 from directory is added 2 times into one biger MP3 file
	// Like this, but every line contains 2x18 mp3 files:
	// ffmpeg -i "concat:50lang-1st-part-1-0001.mp3\|50lang-1st-part-1-0002.mp3\|50lang-1st-part-1-0003.mp3" -c copy 50lang-lesson-01.mp3

	const path = require('path');
	const fs = require('fs');

	const directoryPath = path.join(__dirname);

	let fff = [];

met / 50languagesToCSV.js

Created January 24, 2024 00:19

Export 50languages page to CSV containing language data for study

	// This is a modified script from https://www.geeksforgeeks.org/how-to-export-html-table-to-csv-using-javascript/

	function tableToCSV() {

	// Variable to store the final csv data
	let csv_data = [];

	let table = document.getElementById('table1');

	// Get each row data

met / svg-in-html.html

Created June 1, 2023 09:05

	<!DOCTYPE html>
	<html lang="cs">
	<body>
	<div>Test</div>
	<div class="w-full h-full flex justify-center py-2 opacity-0" style="opacity: 1;">
	<svg viewBox="0 0 38 29" fill="none" xmlns="http://www.w3.org/2000/svg" class="inline h-auto"><path d="M31.683.338C35.535 3.61 38 8.602 38 14.193c0 5.592-2.464 10.589-6.317 13.856a1.385 1.385 0 0 1-2.007-.217 1.533 1.533 0 0 1 .207-2.095c3.219-2.728 5.267-6.882 5.267-11.543 0-4.662-2.048-8.816-5.267-11.55-.611-.52-.7-1.457-.207-2.095a1.39 1.39 0 0 1 2.007-.217v.006ZM28.09 4.956c2.565 2.183 4.21 5.512 4.21 9.238 0 3.725-1.645 7.054-4.21 9.236a1.385 1.385 0 0 1-2.007-.216 1.533 1.533 0 0 1 .208-2.096c1.93-1.636 3.159-4.129 3.159-6.924 0-2.796-1.23-5.289-3.159-6.931-.611-.521-.7-1.457-.208-2.096a1.39 1.39 0 0 1 2.007-.217v.006Zm-3.592 4.619a6.062 6.062 0 0 1 2.102 4.619 6.062 6.062 0 0 1-2.102 4.618 1.385 1.385 0 0 1-2.007-.217A1.533 1.533 0 0 1 22.7 16.5a3.02 3.02 0 0 0 1.051-2.306c0-.93-.41-1.761-1.05-2.313-.613-.52-.702-1.457-.209-2.095a1.39 1.39 0 0 1 2.007-.217v.

met / kralovec-kaliningrad.txt

Last active October 16, 2022 20:48

Czech Kralovec (before Kaliningrad) news coverage

	[ENGLISH]
	https://www.expats.cz/czech-news/article/czech-annexation-of-kaliningrad-prank-goes-viral-with-ministries-and-embassies-joining-in
	https://english.radio.cz/czech-meme-scene-calls-return-kaliningrad-czechia-8763343
	https://nypost.com/2022/10/05/czechs-troll-russia-with-mock-annexation-of-kaliningrad/
	https://www.bloomberg.com/news/articles/2022-10-06/putin-s-land-grab-mocked-by-czechs-with-fake-kaliningrad-claim
	https://www.praguemorning.cz/czechs-troll-russia-with-mock-annexation-of-kaliningrad/
	https://www.newsweek.com/czech-petition-annexing-kaliningrad-russia-signed-thousands-1749063
	https://www.newsweek.com/czech-lawmaker-zdechovsky-joked-annexing-kaliningrad-death-threats-1749380
	https://www.euractiv.com/section/global-europe/opinion/the-brief-the-beauty-of-annexing-kaliningrad/
	https://localtoday.news/us/czech-petition-signed-by-thousands-to-annex-kaliningrad-from-russia-121937.html

met / 800-ukrainian-words-for-aplhabet-training.txt

Created May 17, 2022 12:33

800 Ukrainian words that are similar to Czech word for better learning of Ukranina alphabet

met / 300-ukrainian-words-for-aplhabet-training.txt

Created May 14, 2022 22:04

300 Ukrainian words that are similar to Czech word for better learning of Ukranina alphabet

Martin Hassman met