Skip to main content

pyramid_oereb, extension for pyramid web frame work to provide a basic server part for the oereb project

Project description

Build Status Requirements Status

pyramid_oereb is an open-source implementation of the server side part for the swiss “Cadastre of Public-law Restrictions on landownership” (PLR-cadastre).

It is written in Python and designed as a plugin for the Pyramid Web Framework. This allows pyramid_oereb to be included in any Pyramid web application.

Please refer to the documentation for detailed information and instructions for installation and configuration.

If you are interested in contributing or extending the project, take a look at the contribution page.

Local testing (quick preview)

Run dev server

Following packages are required: python3-venv postgresql-client libpq-dev

Clone project:

git clone
cd pyramid_oereb

The information for the connection to the main database, the print service and the statistics functionality database has to be provided in a .env file (not committed, copy sample.env and edit it if necessary):

cp sample.env .env


make serve

JSON reduced extract is accessible at: http://localhost:6543/oereb/extract/reduced/json/CH113928077734.

When running in to issues installing libpq-dev :

The following packages have unmet dependencies:
 libpq-dev : Depends: libpq5 (= 10.12-0ubuntu0.18.04.1) but 12.3-1.pgdg18.04+1 is to be installed

Try to install a specific version (adapt the version to your requirement):

sudo apt install libpq5=10.12-0ubuntu0.18.04.1

Run tests

To check your code, run make checks. It will run style checks and tests. It’s also possible to run sub-target independently:

  • make checks-style to run only style-related checks (linting).
  • make tests to run tests. Python 3.7 is used by default. But you can run tests with another version by running: PYTHON_TEST_VERSION=python3.x make tests. You can also set this variable in the Makefile.

After running tests, the coverage is available in the folder coverage_report.

Use Oereblex data model

To test the application with the Oereblex data model, adapt the configuration files pyramid_oereb_standard.yml.mako and docker/config.yml.tmpl. See this example with the theme forest_perimeters:

  # Standard data model
  #class: pyramid_oereb.standard.sources.plr.DatabaseSource
  # Oereblex data model
  class: pyramid_oereb.contrib.sources.plr_oereblex.DatabaseOEREBlexSource
    db_connection: *main_db_connection
    # Standard data model
    #models: pyramid_oereb.standard.models.forest_perimeters
    # Oereblex data model
    models: pyramid_oereb.contrib.models.oereblex.forest_perimeters

The sample data is in sample_data/oereblex.

Run the application:


JSON reduced extract is accessible at: http://localhost:6544/oereb/extract/reduced/json/CH113928077734. This will do a call to the Oereblex service defined in the configuration file, and the success of the call will depend on the external service being available, and the geolink id being used in the sample data still existing on the external system.

It is possible to run this instance in parallel to the instance which uses the standard database. For this, one should create a second clone of the project.

If testing make serve with another theme than forest_perimeters, changes will be necessary in the directory sample_data/oereblex/plr119: first remove the symbolic link corresponding to this theme, then create a directory and add JSON data files into it. In comparison to the data from the standard model, a new attribute geolink is required in public_law_restriction.json, which should correspond to an existing geolink in the Oereblex server defined in the configuration (see sample_data/oereblex/plr119/forest_perimeters for example files).


  • Oereblex: improve testing functionality for Oereblex (#1197)
  • Various library updates
  • Oereblex: support new Oereblex API version 1.2.1
  • Various library updates
  • Oereblex: add configuration to pass URL parameters to the oereblex call (#1117)
  • Various library updates
  • Improve handling of empty geometries, in preparation of additional library updates (#1107)
  • Print using MapFish Print: the inclusion of the cantonal logo is now configurable (#1139)
  • Update of external libraries such as numpy, SQLAlchemy, lxml, and more.
  • oereblex support: avoid extract failure upon missing enactment_date in oereblex (#1093)
  • Improve support of Python 3.7 in template Makefile and sample data loading (#1104, #1106)
  • Fix bug affecting concurrent requests (#1068)
  • Enhance federal data import script to make it more usable with Docker (#1078)
  • For full extracts, add configuration parameter to make additional sld usage optional (#1077)
  • Improve federal data import script (#1057)
  • Last maintenance release with verified python2 compatibility
  • Update of all libraries used by pyramid_oereb that still work with python2
  • Federal data import script: add SLD_VERSION for legend_at_web (#1022)
  • Oereblex integration: add optional configuration ‘validation’ (#1034)
  • Restrict the version of the Shapely library used to 1.6 (#1037)
  • Fix import of federal data for cases including both coordinate reference systems (#1011)
  • Oereblex: support geolink schema version 1.2.0 (#1010)
  • Print: make geometry inclusion optional (performance improvement for MapFish Print) (#1006)
  • Test release only; not an official release.
  • Print: fix nr_of_points computation (#1002)
  • Oereblex: improve performance (implement per topic store) (#993)
  • Add statistics functionality (#987)
  • Print: fix table of contents page numbering (#983)
  • Improve multilingual support (#915, #918, #943, #950)
  • Ensure XML schema compliance (#914, #926)
  • Improve extract speed (#965)
  • Additional options for sorting and grouping (#925, #931, #948, #979)
  • Additional options for xml2pdf integration (#905, #938)
  • Add PDF archive functionality (#982)
  • Make WMS usage in print more flexible (#986)
  • Bug fixes and debugging possibilities improvement (#910, #909, #897, #894, #916, #919, #870, #908, #932, #955, #958, #963, #970)
  • Provide multilingual OEREB logo (#915)
  • Add file extension in logo and symbol URLs (#917)
  • Ensure XML Schema compliance (#872, #891)
  • Fix polygon GML rendering (#830)
  • Integration of XML2PDF service (#631, #883, #887)
  • Fixed a number formatting problem in the legend list (Mapfish Print, GitHub issue 824, pull request 826)
  • Fixed an encoding issue for PLR records (GitHub pull request 828)
  • Allow configuration of custom parameters for WMS calls in Mapfish Print (GitHub pull request 831)
  • Section ‘Certification’ is now optional, can be configured in the Mapfish Print config (GitHub pull request 841)
  • Only prints the PLR section of the PDF if at least one PLR is available (Mapfish Print, GitHub pull request 846)
  • Various layout fixes in the table of contents of the Mapfish Print PDF (GitHub pull requests 842, 856, 859)
  • Legends are now sorted by geometry type and value (Mapfish Print, GitHub pull request 851)
  • Multiple ResponsibleOffices per theme are now rendered correctly (Mapfish Print, GitHub issue 651, pull request 865)
  • PDF/A conformance enabled by default (Mapfish Print, GitHub pull request 852)
  • In the XML output, LengthShare and NrOfPoints elements were moved to their correct place (GitHub issue 834, GitHub pull request 854)
  • Optimized theme sorting (GitHub issue 443, GitHub pull request 858)
  • Updated Mapfish Print to 3.20.0
  • Dependency updates, better test coverage
  • Fixed import script for federal topics (GitHub pull request 821)
  • Added test for ordering of non-concerned themes (GitHub pull request 817)
  • Fixed footer with disappearing page numbers with MapFish print 3.18 (GitHub pull request 814)
  • Downgrade version of pyproj to fix coordinate reprojections (GitHub pull request 810)
  • Dependency updates
  • Fixed id types in oereblex models and model template, fixed documentation errors in standard models and model template (GitHub pull request 807)
  • Fixed warnings in tests (GitHub pull request 803)
  • Dependency updates (GitHub pull request 805)
  • Additional multilingual functionality (GitHub issues 704, 705, 779)
  • Maintenance release (GitHub issues 447, 610, 590, 609, 757, 750, 681, 752, 753, 460, 736, 666, 596, 678, 461, 751)
  • Import script for federal data
  • Bug-fix release for 1.2.2 (fix intersection bug, fix pdfreport template)
  • Further bug-fixes for oereb service versoin 1.0, notably regarding schema conformity and better support for other OS versions.
  • New configuration parameter type_mapping in real_estate, which allows to configuratively define the texts to be used for realestate types (optional parameter).
  • Bug-fixes for service version 1.0 (pyramid_oereb 1.2.0), using results from pilot integration of new version at BL.
  • First implementation of federal extract requirements as per november 2017 (service in version 1.0, extract in version 1.0.1, data model in version 1.0.1).
  • Update of automated tests to correspond to new requirements.
  • Static extract implementation update according to Weisung july 1st, 2018.
  • Oereb lex model creation support and documentation.
  • Bug fixes (legend entries, multiple view services, scaling in print, document titles in print).
  • Facilitate customization of document title generation.
  • Final implementation of federal extract requirements as per november 2016 (extract in version 0.8, data model in version 0.4).
  • introduce configurable pdf print service (print proxy)
  • enable proxy configuration for external web api usage
  • fix standard database
  • improve python 3 compatibility
  • minor bug fixing
  • improved doc
  • fix bug for doc creation on python 3.6
  • proceed with renderer for xml and json
  • add metadata for embeddable flavour
  • images accessible via URL
  • add configurable methods for processing
  • improve geometry handling
  • add documentation on
  • several bugfixes
  • first running approach of server
  • main web services are available (not all formats are implemented yet)
  • standard configuration can be used to run server out of the box
  • see README for more details
  • initial version

Project details

Release history Release notifications | RSS feed