Skip to content

Instantly share code, notes, and snippets.

View gerbsen's full-sized avatar

gerbsen gerbsen

10 followers · 4 following
View GitHub Profile
@gerbsen
gerbsen / gist:66c1de098ab520921b7257d3d3388b48
Created February 5, 2025 17:16
Ice Cubes Crash report
-------------------------------------
Translated Report (Full Report Below)
-------------------------------------
Process: Ice Cubes [32581]
Path: /Applications/Ice Cubes.app/Contents/MacOS/Ice Cubes
Identifier: com.thomasricouard.IceCubesApp
Version: 1.11.2 (2887)
App Item ID: 6444915884
App External ID: 869915156
@gerbsen
gerbsen / README.md
Created January 30, 2025 12:23 — forked from Sieboldianus/README.md
Download all Features from all layers of a WFS Service and save as separate shapefile per layer, with iteration (BfN example)

Example to retrieve all WFS Features and store as shapefile with pandas and geopandas.

Setup:

conda create -n wfs_env -c conda-forge
conda activate wfs_env
conda install owslib geopandas requests

First, check capabilities in browser :

@gerbsen
gerbsen / postgres_queries_and_commands.sql
Created February 17, 2024 10:57 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@gerbsen
gerbsen / docker-cleanup-resources.md
Created November 22, 2017 08:55 — forked from bastman/docker-cleanup-resources.md
docker cleanup guide: containers, images, volumes, networks

Docker - How to cleanup (unused) resources

Once in a while, you may need to cleanup resources (containers, volumes, images, networks) ...

delete volumes

// see: https://github.com/chadoe/docker-cleanup-volumes

$ docker volume rm $(docker volume ls -qf dangling=true)

$ docker volume ls -qf dangling=true | xargs -r docker volume rm

@gerbsen
gerbsen / lag_europa_24_06_2017.md
Last active July 19, 2017 08:50

0. Teilnehmer

Holger Haugk, Marcel Bäck, Werner Tomas, Sven Grams, Jakob Lindenthal, Marija Dragica, Gisela Kallebach, Daniel Gerber

1. Auswertung Treffen ENS

  • ENS

  • Entwicklungspolitisches Netzwerk Sachsen e.V.

  • Ansprechpersonen

  • Anne Schicht, [email protected]

@gerbsen
gerbsen / rocket.chat.naming.md
Last active June 21, 2017 14:39

Vorschlag für Namesgebung

Generelle Regeln:

  • nur Kleinschreibung
  • Leerzeichen mit Unterstrichen oder Bindestrichen

| Channel Name | Bedeutung |

@gerbsen
gerbsen / lag_europa_treffen_25022017.md
Last active February 27, 2017 20:58

LAG Europa und Internationales 25.02.2017

Vorstellungsrunde:

  • Marcel
  • Sven Krams
  • Peter (chairmain usti region)
  • Jirji (was chairman of usti region for 4 years)
  • adam suchez (vice chairman of green party usti region)
  • Nino
@gerbsen
gerbsen / europe_end_of_solidarity.md
Last active February 12, 2017 18:21

Title of panel

  • The End of solidarity? The return of the national though in Europe.
  • Das Ende der Gemeinsamkeit? Die Rückkehr des nationalen Gedankens in Europa.

Type of discussion

  • Expert panel
  • Sunday, 12.02.2017,
  • Schauspiel Leipzig,
  • Moderation Dr. Jens Bisky, Feuilleton SZ
@gerbsen
gerbsen / prerender start script
Created October 22, 2015 08:27
cat /etc/init.d/prerender
#!/bin/bash
### BEGIN INIT INFO
# Provides: prerender
# Required-Start: networking
# Required-Stop: networking
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Run prerender collector as daemon
# Description: Run prerender collector as daemon
@gerbsen
gerbsen / prerender.install.log
Created October 22, 2015 08:25
/install.sh
» Prerender-daemon installer v1.1.1 by Luciano Mammino
» http://loige.com
» https://github.com/lmammino/prerender-daemon
Installing prerender-daemon
npm http GET https://registry.npmjs.org/prerender
npm http 200 https://registry.npmjs.org/prerender
npm http GET https://registry.npmjs.org/lodash