Skip to content

Instantly share code, notes, and snippets.

@stefanw

stefanw/fds_reconciliation.md

Last active February 25, 2019 15:59
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stefanw/51d5521d4acc54122f7576c7caf0b91e to your computer and use it in GitHub Desktop.
Save stefanw/51d5521d4acc54122f7576c7caf0b91e to your computer and use it in GitHub Desktop.
Download ZIP
FragDenStaat OpenRefine Reconciliation
Raw
fds_reconciliation.md

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
  1. Use the default password: changeit

Reconciliation

Click on the menu for the column, choose "Reconcile", "Start reconciling..." and choose "Add Standard Service...."".

You can add the following reconciliation endpoints:

Endpoint for public bodies:

https://fragdenstaat.de/api/v1/publicbody/reconciliation/

Endpoint for geo regions:

https://fragdenstaat.de/api/v1/georegion/reconciliation/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment