Skip to main content

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

Project description

Project description

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.

Starting the development server

  1. Build run the initial build depending on your OS:

    • docker network create print-network

    • Linux: docker compose run --rm -u $(id -u):$(id -g) oereb-make build

    • MAC/Windows: docker compose run --rm oereb-make build

  2. docker compose up

Running docker compose up will start the DB (it will automatically import the test/dev data on startup) and start a running instance of the pyramid_oereb DEV server connected to the DB. The project folder is mounted to it. So changes take effect.

The sample static extract should then be available at http://localhost:6543/oereb/extract/json?EGRID=CH113928077734

Running the tests

To run the tests locally:

The docker way:

  • docker network create print-network

  • Linux: docker compose run --rm -u $(id -u):$(id -g) oereb-server make build tests

  • MAC/Windows: docker compose run --rm oereb-server make build tests

For systems having a local make tool, the following recipe can be used: make docker-tests

sometimes the local postgres port is already in use, and you must override it: EXPOSED_PGPORT=5433 make docker-tests

Local tests:

For local tests without the complete docker composition you need a running DB. You can create one based on the oereb image: docker compose up -d oereb-db

or create an empty postgis DB docker run -p 5555:5432 --name pg_oereb --rm -it -e POSTGRES_PASSWORD=pw postgis/postgis

Then you can run the tests easily: make tests

If the DB does not use standard credentials, you can set them as ENV vars: PGPORT=5555 PGPASSWORD=pw make tests

To run one specfic test:

docker compose exec oereb-server PYTEST_OPTS="-k <name_of_the_test>" make tests


Some local files may remain from previous builds, and the regular user may not be able to delete them. In this case cleanup can be done like:

docker compose run --rm oereb-make clean-all

Useful make targets

Run the make targets found in the Makefile either in the oereb-server container (if using docker compose) or in your local shell (if running the server locally). Some useful targets:

  • make serve-dev to run the application

  • make tests to run the application tests

  • make docker-tests to run the application tests inside a docker composition, so one does not have to care about local set up

  • make clean to empty the database

  • make clean-all to empty the database, uninstall the application and the virtual env and clear the rendered configuration files

  • make docker-clean-all to clean up everything written by the docker container. This is sometimes useful when docker has created some files with root only permission

If necessary the application is re-installed and the database is filled when running make serve-dev again.

There are further make targets to check the validity of federal data:

  • make check_fed_data downloads currently known federal data definitions and compares them with the active ones

  • make update_fed_data_urls try to retrieve the new urls from the server’s index page. The file fed.urls must then be committed to the repo

  • make update_fed_data_urls generate new json files in the repo. The modified files must then be committed

  • make auto_update_fed_data automagic command which finds the new URLs, generates json data, copies json to project. The files fed.urls and dev/sample_data/ch.*.json must be committed if changed

Using MapFish-Print

To be able to test the OEREB static extract (pdf), you need to run pyramid_oereb with docker compose and to have a running instance of pyramid_oereb_mfp. The Docker network print-network is also required and can be created with:

docker network create print-network

It is also possible to launch a Mapfish Print service on a local URL (via Docker or not) and then run the server via make serve. The correct print url must be provided:

PRINT_URL="http://localhost:8680/print/oereb" EXPOSED_PGPORT=5433 PGPORT=5433 make serve-dev

The sample static extract should then be available at http://localhost:6543/oereb/extract/pdf?EGRID=CH113928077734

CI Status

CI status on master branch:

Master CI status

Daily check status:

Daily check status

Code Quality Status:

Codacy Badge



  • Use ST_DWithin instead of ST_Distance for performance reasons (#1930)

  • Library upgrades (SQLAlchemy, geoalchemy2, urllib3, pypdf)


  • Support new Oereblex API version (via geolink-formatter 2.0.5)

  • Enhance test coverage (#1904)

  • Library upgrades (SQLAlchemy, lxml, jsonschema, c2cwsgiutils, pillow, pytest)

  • Fix database setup scripts (#1913, #1914)

  • Fix deprecation (#1915)


  • Add extract_index to disclaimer and general infomation (#1753)

  • Interlis bug fix (#1881)

  • Library upgrades (geoalchemy2, SQLAlchemy, jsonschema, lxml, responses, urllib3, pypdf)

  • Test coverage improvements

  • Python 3.8 is no longer explicitly supported

  • Remove print proxy xml2pdf, no longer used by the community (#1889)


  • Fix error with large of contents and new pdf library (#1813)

  • Fix timestamp for archived PDF (#1815)

  • Library upgrades (SQLAlchemy, geoalchemy2, shapely, psycopg2, pyreproj, pyramid, responses, urllib, pillow, pypdf, jsonschema)


  • Fix base layer usage in grouped PLRs (#1302)

  • Various minor library upgrades (SQLAlchemy, geoalchemy2, pypdf, lxml, urllib3)


  • Add option for a hook method for LogoRef URLs (#929, #1744)

  • Various minor library upgrades (urllib, requests, SQLAlchemy, geoalchemy2)


  • Add support for newest oereblex API (via geolink-formatter, #1703)

  • Various minor library upgrades (SQLAlchemy, geoalchemy, psycopg2, pypdf)


  • Add print configuration parameter for municipality name (#1703)

  • Various minor library upgrades (pyramid, shapely, grcode, pypdf)


  • Improve getegrid performance (#1680)

  • Remove unwanted URL encoding for symbol_ref (#1678)

  • Upgrade geolink_formatter library (#1682)

  • Various minor library upgrades (#1688, #1689)


  • Upgrade to pyramid 2, shapely 2 (#1625, #1642, #1647, #1662)

  • Various minor library upgrades

  • Preparations for SQLAlchemy 2 upgrade (#1665)

  • Python 3.8 is now the minimal recommended version of python


  • Add support for prepublinks (#1618)

  • Allow to force real estate geometry output (#1619)

  • Library updates (#1615, #1622)


  • Allow usage of xml2pdf service with embedded images (#1612, #1614)


  • Fix response code for parameter “url” (#1605)

  • Fix order of change order of ExtractIdentifier & MunicipalityCode (#1606)

  • Sort plr within themes (#1607)

  • Minor library updates (#1609)


  • Support tolerance per geometry type (#1603)

  • Library updates (#1604)


  • Fix xml2pdf proxy (#1596)

  • Library updates (#1597, #1598)


  • Default index for oereblex documents (#1591)

  • Sort theme lists (#1592)

  • Library updates (#1593, #1595)


  • Add library needed for QR-Code (#1589)

  • Various library updates (#1590)


  • Performance improvements (#1580)

  • Add QR-Code functionality (#1579)

  • Bug-fix for Other Legend (#1586)

  • Add optional tolerance on geometric operations (#1571)

  • Improve PDF filename when not using egrid (#1585)


  • Fix value for service version (#1576)

  • Fix XML for localized image blob (#1577)

  • Raise error in case of unsupported geometry type (#1578)


  • Move DataIntegration to application schema (#1549)

  • Bug fix for document relevant only for one municipality (#1561)

  • Bug fix for oereblex optional parameters (#1565)

  • Library updates (#1567)


  • Oereblex integration: facilitate customization of title logic (#1556)

  • Fix automated documentation publication (#1555)

  • Improve automated testing of federal data (#1548)


  • Disclaimer, glossary and municipality are now read only on startup, to improve performance (#1544)

  • Add support for OEREBlex prepubs URL (#1546)

  • Fix real estate type in XML for GetEgrid (#1545)


  • Fix legend entry collection (#1529)

  • Fix stats for GetEgrid (#1524)

  • Update theme and texts URL according to swisstopo (#1526)

  • Fix JSON response of GetEgrid (#1534)

  • Fix error in Interlis model sub-code usage (#1538)

  • Improve performance by moving availability to main schema and read only on startup (#1540)


  • Finalize stats reactivation (#1517)


  • Updates of all essential libraries used

  • Fix multiple disclaimers in print (#1511)


  • Fix capabilities extract (#1489)

  • Fix real estate type in get egrid extract (#1491)

  • Fix legend entry symbol selection (#1505)

  • Add document sorting by index in print (#1504)


  • Reorganize hook methos (#1484)

  • Fix Office Record assignment (#1473)

  • External library updates


  • Fix collection of legend entries (#1482)


  • Reactivate statistics functionality from V1 (#1480)

  • Additional fix for static extract (#1478)


  • Additional fix for static extract


  • Fixes for static extract


  • Fixes in configuration (#1445)


  • Fix XML templates


  • Fix sub-theme generation


  • Improvements in error logging


  • Fixes in Oereblex integration


  • Fix JSON extract


  • New federal data import tool and bug-fixes V2 (Status: beta)


  • First fully functional implementation of new Oereb specification as per 28.10.11 (Status: beta)


  • Implementation of the new Oereb specification 2021 (Status: beta)


  • 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