Download the whole planet dataset (~80 Gb)
curl -OL https://planet.openstreetmap.org/pbf/planet-latest.osm.pbf
Using osmium tool filter amenity=toilets
nodes
osmium tags-filter planet-latest.osm.pbf n/amenity=toilets -o toilets.osm
Download the whole planet dataset (~80 Gb)
curl -OL https://planet.openstreetmap.org/pbf/planet-latest.osm.pbf
Using osmium tool filter amenity=toilets
nodes
osmium tags-filter planet-latest.osm.pbf n/amenity=toilets -o toilets.osm
Why golang sql
and sqlx
libraries can't parse array_agg
?
Why golang json
library parse [null]
as a struct with default values (int = 0
, string = ""
) instead of an error or an empty array ?
Why postgres COALESCE(jsonb_agg(DISTINCT to_jsonb(ti)), '[]')
still returns [null]
instead of []
?
I want to add FILTER…
As always:
# based on: https://www.hughesportal.com/blog.php?article=setup-network-bonding-using-netplan | |
network: | |
version: 2 | |
ethernets: | |
enp2s0f0: | |
dhcp4: no | |
dhcp6: no | |
enp2s0f1: | |
dhcp4: no | |
dhcp6: no |
NewUser=winston
sudo useradd $NewUser --create-home
sudo mkdir /home/$NewUser/.ssh
sudo touch /home/$NewUser/.ssh/authorized_keys
sudo chown -R $NewUser:$NewUser /home/$NewUser/.ssh
sudo chmod 700 /home/$NewUser/.ssh
sudo chmod 600 /home/$NewUser/.ssh/authorized_keys
function check_limit() { | |
// Get the active sheet | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
// Get the range of the selected column | |
var data = sheet.getDataRange().getValues(); | |
// Count the rows | |
var numRows = data.length; | |
var startRow = 4; | |
var limitCol = 3; | |
// Save the selected the Column |
Here is a brief description of what the Bash command I provided does:
This command allows you to download multiple videos from an input batch file by adding the season number and index of each video to the filename prefix.
Note: this command will only work if the yt-dlp command is installed on your system. If it is n
#!/usr/bin/env python | |
# put this file in /usr/local/bin | |
# vtt2srt my_subtitle.vtt | |
import os, re, argparse | |
parser = argparse.ArgumentParser() | |
parser.add_argument("filename", help=".vtt file") | |
args = parser.parse_args() | |
input_path_filename = args.filename |
``` | |
mdadm --detail /dev/mdX | |
``` | |
``` | |
mdadm --stop /dev/mdX | |
``` | |
``` | |
mdadm --assemble --force /dev/mdX /dev/sda /dev/sdb /dev/sdc /dev/sdd |