Skip to content

Instantly share code, notes, and snippets.

@p3t3r67x0
p3t3r67x0 / rewe_discounter_details.json
Created March 31, 2021 18:34
List of probably all german listed REWE discounters with address data as well as contact data.
This file has been truncated, but you can view the full file.
[{
"registrationnumber": "0702020",
"schoolname": "Schule auf der Rude",
"principal": "Frau Saar",
"phone": "0461/852556",
"fax": "0461/851642",
"email": "[email protected]",
"website": "http://www.schule-auf-der-rude.lernnetz.de",
"address": "Lundweg 30",
"postalcode": "24941",
DROP TABLE IF EXISTS uland;
CREATE TABLE uland (
id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
uland NUMERIC NOT NULL,
name VARCHAR(255) NOT NULL
);
DROP TABLE IF EXISTS umonat;
# Generated by Powerlevel10k configuration wizard on 2023-10-05 at 11:27 CEST.
# Based on romkatv/powerlevel10k/config/p10k-rainbow.zsh, checksum 42599.
# Wizard options: nerdfont-complete + powerline, small icons, rainbow, unicode,
# angled separators, sharp heads, round tails, 1 line, compact, many icons, concise,
# instant_prompt=verbose.
# Type `p10k configure` to generate another config.
#
# Config for Powerlevel10k with powerline prompt style with colorful background.
# Type `p10k configure` to generate your own config based on it.
#
call plug#begin()
Plug 'https://github.com/junegunn/vim-plug.git'
call plug#end()
set backupcopy=yes
" Don't try to be vi compatible
set nocompatible
" Helps force plugins to load correctly when it is turned back on below
@p3t3r67x0
p3t3r67x0 / profiles.conf
Created October 5, 2023 09:46
dconf dump /org/gnome/terminal/legacy/profiles:/
[/]
audible-bell=false
background-color='rgb(0,43,54)'
background-transparency-percent=3
default-size-columns=300
default-size-rows=79
font='MesloLGS NF 15'
foreground-color='rgb(131,148,150)'
palette=['rgb(7,54,66)', 'rgb(220,50,47)', 'rgb(251,117,117)', 'rgb(181,137,0)', 'rgb(54,143,205)', 'rgb(211,54,130)', 'rgb(42,161,152)', 'rgb(238,232,213)', 'rgb(0,43,54)', 'rgb(181,231,208)', 'rgb(229,77,43)', 'rgb(101,123,131)', 'rgb(131,148,150)', 'rgb(108,113,196)', 'rgb(147,161,161)', 'rgb(253,246,227)']
scroll-on-keystroke=true

Install pgrouting2 on Ubuntu

sudo apt install osm2pgrouting
sudo apt install cmake g++ libboost-graph-dev
sudo apt install postgresql-16 postgresql-16-postgis postgresql-server-dev-16
sudo apt install postgresql-10-pgtap
sudo apt install sphinx-common
sudo apt install bzip2
wget -O pgrouting-3.0.6.tar.gz https://github.com/pgRouting/pgrouting/archive/v3.0.6.tar.gz