Skip to content

Instantly share code, notes, and snippets.

@Wikinaut
Wikinaut / wikidata-query-without-and-with-aggregation.txt
Last active December 20, 2021 11:09
Wikidata query with aggregation
Without aggregation. with dates
# Wikidata SPARQL-Query for nuclear power plants, research reactors, waste facilities
# regardless of their status
# one result line per location - check columns count and types
# 20200612 with service entry/retirement dates; no aggregation
# 20200518
# 20200509 initial version
# Paste this code into the code input box of https://query.wikidata.org/
Bkat Stand: 09.11.2021 – 14. Auflage
Quelle: https://www.kba.de/DE/Themen/ZentraleRegister/FAER/BT_KAT_OWI/btkat_node.html
------ Grundregeln - § 1 StVO
TBNR 101000 35,00 €
Sie kamen von der Fahrbahn ab und verursachten Sachschaden.
TBNR 101006 35,00 €
Sie gerieten ins Schleudern und verursachten Sachschaden.
@Wikinaut
Wikinaut / buergerbot.py
Created July 2, 2021 10:26
Bürgeramt-Terminfinder
#!/usr/bin/env python
# kleiner Bürgeramt-Terminfinder
#
# 20210702 init
# basierend auf https://gist.github.com/jaysonsantos/0ef66e0677be32050574
import subprocess
import time
@Wikinaut
Wikinaut / extend-crop-background.sh
Last active April 17, 2021 18:25
Extend (or crop) the canvas background of an image to a multiple of a modulus (such as 32)
#!/bin/bash
if [ $# -lt 1 ]; then
echo "extend-crop-background <imagefile> [modulus [extent]]"
echo "Extend or crop image to a multiple of modulus ±'extent'"
echo
echo "modulus: default 32"
echo "extent: default=modulus"
echo
echo "Examples:"
@Wikinaut
Wikinaut / make-impact.sh
Created April 5, 2021 07:09
make-impact.sh
#!/bin/bash
# https://twitter.com/climagic/status/1314635495280959489
# Make an impact with ImageMagick
echo "make-impact text outfile"
font="Kanit-ExtraBold"
# convert -list font # list all font names
convert -size 1000x600 \
-define gradient:radii=1000,500 radial-gradient:#884b88-#010101 \
-font $font -fill white -background transparent -interline-spacing -30 -gravity center \
@Wikinaut
Wikinaut / fax-a-video.sh
Last active December 19, 2022 19:23
fax-a-video
#!/bin/bash
# Script to create one or more images of a number n of equally spaced frames of video.
# Adding a caption with a prefix and counting number.
# this version 20221219
# init 20210321
# Licence: WTFPL
@Wikinaut
Wikinaut / install-dependencies-and-build-kodi.sh
Last active February 7, 2021 10:09
install-dependencies-and-build-kodi.sh on Raspberry Pi
sudo apt update
sudo apt upgrade
sudo apt -y install build-essential
sudo apt -y install autoconf
sudo apt -y install automake
sudo apt -y install autopoint
sudo apt -y install gettext
sudo apt -y install autotools-dev
sudo apt -y install cmake
@Wikinaut
Wikinaut / audio2video.sh
Last active May 6, 2021 00:16
Create a video for Twitter from an audio and a dummy image file - transcode audio into a video for twitter
#!/bin/bash
if [[ $# -ne 2 ]]; then
echo "audio2video: create a video for Twitter from audio and a dummy image."
echo "Usage:"
echo "audio2video audio.mp3 dummyimage.png"
echo
echo "Remark: width and height need to be divisible by 2."
exit
fi
@Wikinaut
Wikinaut / breaking-news.sh
Created February 1, 2021 19:51
Breaking-News-Generator
#!/bin/bash
# Imagegenerator for "Breaking News"
# Init 20210112
if [[ $# -ne 3 ]] ; then
echo "Usage:"
echo "breaking-news imagefile \"headline-text\" \"yellow-ribbon-text\""
exit
fi
@Wikinaut
Wikinaut / getLangeNaechte.sh
Last active February 1, 2021 20:08
Erstellt lokal eine kompakte Webseite aller "Langen Nächte" von DLF/DLFKultur
#!/bin/bash
# Erstellt lokal eine kompakte Webseite aller "Langen Nächte" von DLF/DLFKultur
# Lizenz: WTFPL
rm "lange-naechte.html"
# get number of pages
maxpages=$(wget -q -O - "https://www.deutschlandfunkkultur.de/lange-nacht.1023.de.html" | \
grep -oE "paginationanzahl.*Seite ./[0-9]+" | \