Skip to content

Instantly share code, notes, and snippets.

@stefanw
stefanw / fds_reconciliation.md
Last active February 25, 2019 15:59
FragDenStaat OpenRefine Reconciliation

OpenRefine Reconciliation with FragDenStaat.de

Preparations

FragDenStaat.de uses letsencrypt for HTTPS certificates. Unfortunately, the standard Java installation doesn't recognize that authority and the reconciliation will be stuck in the "Working" screen. Here's how to fix this.

  1. Download the cross-signed certificate: https://letsencrypt.org/certs/lets-encrypt-x3-cross-signed.pem.txt
  2. Import the certificate into the keystore of OpenRefine
keytool -import -alias letsencrypt -keystore /Applications/OpenRefine.app/Contents/PlugIns/jdk1.8.0_60.jdk/Contents/Home/jre/lib/security/cacerts -file ~/Downloads/lets-encrypt-x3-cross-signed.pem.txt
@corny
corny / txt2pdf.py
Last active May 6, 2017 11:40
Wandelt .txt-Emails von Fragdenstaat in PDFs um
#!/usr/bin/env python2
# -*- coding: utf-8 -*-
from pylatex import *
from pylatex.utils import italic
import fileinput
import sys
from email.header import decode_header, make_header
import io
import argparse

Fahrplandaten unter anerkannten Open Data Lizenzen

SWU

SWU Stadtwerke Ulm/Neu-Ulm GmbH

  • GTFS - offiziell, Lizenz ODbL 1.0, Zugriff muss beantragt werden

RNV