Skip to content

Add 'Openbaarheid' fields to output #135

Description

@droomelotdegendt

Idea mentioned in: #133 (comment)
NOTE: Decide with end users if this issue (and all its subtasks) are necessary.

Tasks

  • Add 'Openbaarheid' field(s) to the output of the get_locs function. This information is on observation well level, so an additional decision should be made if this information should be in- or excluded from the aggregated output (when obswells is FALSE).
  • Add an additional argument to the get_locs function to exclude non public sampling points.

Background Info

The new DWH 'W0002_10_Watina' has a separate table DimOpenbaarheid with the following fields:

Kolom Datatype Beschrijving
OpenbaarheidWID int Technische ID warehouse
OpenbaarheidCode nvarchar Code voor de openbaarheid (PUBL, INCO, OWNCO, …)
OpenbaarheidBeschrijving nvarchar Beschrijving van de openbaarheid (volledige toegang, INBO contacteren, eigenaar contacteren, …)
OpenbaarheidSorteerVolgorde int Sorteervolgorde voor de openbaarheidscodes

The table looks like this:

OpenbaarheidWID OpenbaarheidCode OpenbaarheidBeschrijving OpenbaarheidSorteerVolgorde
-2 -2 Ontbrekend -1
-1 -1 Onbekend -1
1 INCO INBO te contacteren 4
2 NONE Geen toegang 6
3 OWNCO Eigenaar contacteren 5
4 PUBL Volledige toegang 2

It can be joined to the table DimPeilpunt by OpenbaarheidWID.

Metadata

Metadata

Labels

enhancementNew feature or requestquestionFurther information is requested

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions