SQL-driver officielebekendmakingen.nl

The site zoek.officielebekendmakingen.nl serves publications from governmental organisations.

It can be accessed as described in:

It would be handy for statistical analyses when a driver would be available.

There are three sample cases for which data extraction should be possible using Invantive UniversalSQL.

Case 1 - simple

A request for a permit. No external documents, no additional documents.

See also:

https://zoek.officielebekendmakingen.nl/gmb-2025-221815.html

Case 2 - external documents

A request for a permit. With external documents, no additional documents.

There are two external documents in this sample:

See also:

https://zoek.officielebekendmakingen.nl/prb-2014-1564.html

Case 3 - bundled documents

A decision on the Omgevingswet. No external documents, with additional documents (available for inspection, “terinzagelegging”).

The documents should be queryable:

See also:

https://zoek.officielebekendmakingen.nl/prb-2025-8841.html

Search Options

For statistical purposes, queries should be possible using CQL, either providing the CQL as a table function parameter or maybe even as a server-side filter.

For example, the following searches for publications with a title containing both “julianalaan” as well as “123”, created by “Ermelo”:

https://repository.overheid.nl/sru?maximumRecords=1000&query=(c.product-area==officielepublicaties%20AND%20dt.title=julianalaan%20AND%20dt.creator=Ermelo%20AND%20dt.title=123)

CQL is defined in:

https://docs.oasis-open.org/search-ws/searchRetrieve/v1.0/os/part5-cql/searchRetrieve-v1.0-os-part5-cql.html

A number of drivers are considered for being added:

  • Officiele Publicaties (identifier “officielepublicaties”),
  • Samenwerkende Catalogi,
  • SG Digitaal,
  • Tuchtrecht,
  • Verdragenbank,
  • PLOOI (allegedly failed).

The following additions might be added also, although they are likely to have a different format:

  • CVDR
  • BWB
  • Europese Richtlijnen
  • PUC Open Data
  • Wetgevingskader
  • Staatsalmanak (overheidsorganisaties)