Skip to content

📚 Online archive for annual reports of the German internal intelligence

License

Notifications You must be signed in to change notification settings

beyondopen/verfassungsschutzberichte.de

Repository files navigation

Verfassungsschutzberichte.de

Über was informiert der Verfassungs­schutz? Die Berichte des Geheimdienstes: gesammelt, durchsuchbar und analysiert.

Der Verfassungsschutz hat die Aufgabe die Öffentlichkeit über verfassungsfeindliche Bestrebungen aufzuklären. Die 16 Landesämter und das Bundesamt für Verfassungsschutz veröffentlichen jährlich Verfassungsschutzberichte. Diese Webseite ist ein zivilgesellschaftliches Archiv, das den Zugang zu den Berichten erleichert.

English

About what does the Verfassungsschutz (the German internal intelligence, translated: protection of the constitution) inform? The reports of the secret service: collected, searchable and analyzed.

The Verfassungsschutz has the task of informing the public about anti-constitutional efforts. The 16 state offices and the federal office publish annual reports on the protection of the constitution. This website is a civil society archive that simplifies access to the reports.

Development

  1. install and run Docker
  2. git clone https://github.com/dmedak/verfassungsschutzberichte.de && cd verfassungsschutzberichte.de
  3. docker-compose up
  4. http://localhost:5000

Add PDFs for Development

To get started, put some PDFs in to verfassungsschutzberichte.de/data/pdfs and create the folder verfassungsschutzberichte.de/data/images. Then get the container id with docker ps, then enter the Docker container docker exec -it f00d7aa42de8 bash with the appropriate id. Finally run flask update-docs '*' inside the container to process PDFs.

Production

Deploy with Dokku.

  1. create a Dokku app, e.g. with the name vsb
  2. link a Postgres db
  3. link a Redis cache
  4. Then mount a folder data with contains two folders (pdfs for PDFs and images for images of the PDF pages) for the static content: dokku storage:mount $app $path:/data/

To serve the images and PDFs via nginx (xsendfile), adapt the nginx config of Dokku (e.g. create /home/dokku/vsb/nginx.conf.d/myconf.conf):

location /x_images {
  internal;
  add_header X-Robots-Tag "noindex, nofollow"; # prevent search enginges from indexing files
  alias /folder/with/images;
}

location /x_pdfs {
  internal;
  add_header X-Robots-Tag "noindex, nofollow";
  alias /folder/with/pdfs;
}

Adjust the Postgres config and increase shared_buffers and work_mem to, e.g., 1GB and 128MB respectively.

One-off commands

  • clear cache: dokku run vsb flask clear-cache
  • add documents: dokku run vsb flask update-docs '*'
  • remove all documents: dokku run vsb flask remove-docs '*'
  • remove one document: dokku run vsb flask remove-docs 'vsbericht-th-2002.pdf'
  • clean all data from the database and adds all documents again: dokku run vsb clear-data

Data Storage

The reports are organized by folders and filenames. This has the limitation that we can't store different versions of a yearly report.

PDF preprocessing

All documents should be PDF in a A4/A5 portrait format. Several pdf scripts exists but occasionally, manual work is required. See scripts.

Folder Structures

Two folders exists to store the PDFs:

  • raw, sometimes the original PDF requires manual help (e.g. some pages are in landscape format)
  • cleaned, normalized PDFs, but before the OCR & file reduction

Adding a New Report

Naming: vsbericht-nw-2000.pdf for NRW 2000, vsbericht-2000.pdf for the federal report 2000.

If a report is for multiple years, choose the latest year as the main date.

And update the title in src/report_info.py accordingly.

  1. Put the file in a folder, e.g. x
  2. cd scripts
  3. ./new_docs.sh /absolute/path/x process
  4. verify the result in x.done is fine, optionally add a x.raw folder with the unprocessed files.
  5. ./new_docs.sh /absolute/path/x upload

Search

Using Postgres' full-text search features via sqlalchemy-searchable. Right now, there are some shortcomings. It's not possible to use trigram similarity. And wildcard queries are the default and can only be deactivated by using quotes, i.e., "query". Also the matching tokens are not displayed on the page/image. Further work is required to improve the search.

License

MIT