{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Introductory tutorial" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "[![Binder](https://mybinder.org/badge_logo.svg)](https://mybinder.org/v2/gh/DOV-Vlaanderen/pydov/master?filepath=docs%2Fnotebooks%2Fintroductory_tutorial.ipynb)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "pydov provides machine access to the data that can be visualized with the [DOV viewer](https://www.dov.vlaanderen.be/portaal/?module=verkenner).\n", "\n", "All the pydov functionalities rely on the existing DOV webservices. An in-depth overview of the available services and endpoints is provided on the [accessing DOV data page](https://pydov.readthedocs.io/en/latest/endpoints.html#endpoints). To retrieve data, pydov uses a combination of the available WFS services and the XML representation of the core DOV data. \n", "\n", "As pydov relies on the XML data returned by the existing DOV webservices, downloading DOV data with pydov is governed by the same [disclaimer](https://www.dov.vlaanderen.be/page/disclaimer) that applies to the other DOV services. Be sure to consult it when using pydov!\n", "\n", "pydov interfaces data and services hosted by the Flemish governement. Therefore, some syntax of the API as well as the descriptions provided by the backend are in Dutch. " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Use case: gather data for a hydrogeological model" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import inspect, sys" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import pydov\n", "import pandas as pd" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### pydov: general info" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To get started with pydov you should first determine which information you want to search for. DOV provides a lot of different datasets about soil, subsoil and groundwater of Flanders, some of which can be queried using pydov. Supported datasets are listed in the [quickstart](https://pydov.readthedocs.io/en/stable/quickstart.html)." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "In this case, to start with a hydrogeological model, we are interested in the hydrostratigraphic interpretation of the borehole data and the groundwater level. These datasets can be found with the following search objects:\n", "- [Hydrostratigraphic interpretation](https://pydov.readthedocs.io/en/stable/reference.html#pydov.search.interpretaties.HydrogeologischeStratigrafieSearch)\n", "- [Groundwater level](https://pydov.readthedocs.io/en/stable/reference.html#pydov.search.grondwaterfilter.GrondwaterFilterSearch)\n", "\n", "Indeed, each of the datasets can be queried using a search object for the specific dataset. While the search objects are different, the workflow is the same for each dataset. Relevant classes can be imported from the pydov.search package, for example if we’d like to query the dataset with hydrostratigraphic interpretations of borehole data:" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "from pydov.search.interpretaties import HydrogeologischeStratigrafieSearch\n", "hs = HydrogeologischeStratigrafieSearch()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "If you would like some more information or metadata about the data you can retrieve, you can query the search object. Since pydov interfaces services and metadata from Flemish government agencies, the descriptions are in Dutch:" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'De hydrostratigrafie geeft, op basis van de (gecodeerde) lithologie, een indeling weer naar de al dan niet watervoerende eigenschappen van een bepaald beschreven diepte-interval. Deze interpretatie respecteert de lithostratigrafie van het Tertiair, maar deelt deze anders in. De hiervoor gebruikte standaard is de Hydrogeologische Codering van de Ondergrond van Vlaanderen (HCOV). Deze kan beschouwd worden als de officiele hydrogeologische codering voor het Vlaams Gewest.'" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "hs.get_description()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The different fields that are available for objects of the 'Hydrogeologische Stratigrafie' datatype can be requested with the get_fields() method:" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "pkey_interpretatie\n", "Type_proef\n", "Proefnummer\n", "pkey_boring\n", "x\n", "y\n", "start_interpretatie_mtaw\n", "diepte_tot_m\n", "gemeente\n", "Auteurs\n", "Datum\n", "Opdrachten\n", "betrouwbaarheid_interpretatie\n", "Geldig_van\n", "Geldig_tot\n", "eerste_invoer\n", "geom\n", "diepte_laag_van\n", "diepte_laag_tot\n", "aquifer\n" ] } ], "source": [ "fields = hs.get_fields()\n", "# print available fields\n", "for f in fields.values():\n", " print(f['name'])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "You can get more information of a field by requesting it from the fields dictionary:\n", "\n", "- name: name of the field\n", "- definition: definition of this field\n", "- cost: currently this is either 1 or 10, depending on the datasource of the field. It is an indication of the expected time it will take to retrieve this field in the output dataframe.\n", "- notnull: whether the field is mandatory or not\n", "- type: datatype of the values of this field\n", "- query: whether you can use this field in an attribute query\n", "\n", "Alternatively, you can either list all fields by consulting the output of the get_fields() method, or the search instance itself:" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "\n", " \n", "
\n", " \n", "
\n", " pydov.search.interpretaties.HydrogeologischeStratigrafieSearch\n", "
\n", "

De hydrostratigrafie geeft, op basis van de (gecodeerde) lithologie, een indeling weer naar de al dan niet watervoerende eigenschappen van een bepaald beschreven diepte-interval. Deze interpretatie respecteert de lithostratigrafie van het Tertiair, maar deelt deze anders in. De hiervoor gebruikte standaard is de Hydrogeologische Codering van de Ondergrond van Vlaanderen (HCOV). Deze kan beschouwd worden als de officiele hydrogeologische codering voor het Vlaams Gewest.

\n", " \n", "
\n", "

pkey_interpretatie - URL die verwijst naar de gegevens van deze hydrogeologische stratigrafie op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Type_proef - Het type van de proef waarvan de hydrogeologische stratigrafie een interpretatie is. Bij een hydrogeologische stratigrafie zal dit altijd 'Boring' zijn.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.FeatureCatalogueValues\n", "
    \n", " \n", " \n", "
    \n", "

    Boring - Boring - De hydrogeologische stratigrafie is een interpretatie van een boring.

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

Proefnummer - Het proefnummer van de boring waarvan de hydrogeologische stratigrafie een interpretatie is.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

pkey_boring - URL die verwijst naar de gegevens van de boring op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

x - De x-coördinaat van de boring in het Lambert72 coördinaatsysteem (in meter, EPSG:31370).

  • type: float
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

y - De y-coördinaat van de boring in het Lambert72 coördinaatsysteem (in meter, EPSG:31370).

  • type: float
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

start_interpretatie_mtaw - De hoogte van het aanvangspeil van de boring in het TAW stelsel (in meter).

  • type: float
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

diepte_tot_m - None

  • type: float
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

gemeente - De gemeente waarin de boring van deze interpretatie gelegen is.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Auteurs - De auteur of auteurs van de hydrogeologische stratigrafie.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Datum - De datum waarop de hydrogeologische stratigrafie werd beschreven.

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Opdrachten - De opdracht(en) waaraan de hydrogeologische stratigrafie gekoppeld is.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

betrouwbaarheid_interpretatie - De betrouwbaarheid van het geheel van de hydrogeologische stratigrafie (goed, twijfelachtig of onbekend). Deze wordt toegekend door een DOV-medewerker verantwoordelijk voor de ingave.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Geldig_van - Het tijdstip vanaf wanneer de hydrogeologische stratigrafie geldig is.

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Geldig_tot - Het tijdstip tot wanneer de hydrogeologische stratigrafie geldig is.

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

eerste_invoer - Het tijdstip waarop deze interpretatie voor het eerst in DOV ingevoerd werd.

  • type: datetime
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

geom - None

  • type: geometry
  • notnull: False
  • query: False
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

diepte_laag_van - Diepte van de bovenkant van de laag hydrogeologische stratigrafie in meter.

  • type: float
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

diepte_laag_tot - Diepte van de onderkant van de laag hydrogeologische stratigrafie in meter.

  • type: float
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

aquifer - Code van de watervoerende laag waarin de laag Hydrogeologische stratigrafie zich bevindt (HCOVv1)

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    0000 - 0000 - Onbekend

    \n", "
    \n", " \n", " \n", "
    \n", "

    0100 - 0100 - Quartaire aquifersystemen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0110 - 0110 - Ophogingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0120 - 0120 - Duinen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0130 - 0130 - Polderafzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0131 - 0131 - Kleiige polderafzettingen van de kustvlakte

    \n", "
    \n", " \n", " \n", "
    \n", "

    0132 - 0132 - Kleiige polderafzettingen van het Meetjesland

    \n", "
    \n", " \n", " \n", "
    \n", "

    0133 - 0133 - Kleiige polderafzettingen van Waasland-Antwerpen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0134 - 0134 - Zandige kreekruggen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0135 - 0135 - Veen-kleiige poelgronden

    \n", "
    \n", " \n", " \n", "
    \n", "

    0140 - 0140 - Alluviale deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0150 - 0150 - Deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0151 - 0151 - Zandige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0152 - 0152 - Zand-lemige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0153 - 0153 - Lemige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0154 - 0154 - Kleiige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0160 - 0160 - Pleistocene afzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0161 - 0161 - Pleistoceen van de kustvlakte

    \n", "
    \n", " \n", " \n", "
    \n", "

    0162 - 0162 - Pleistoceen van de Vlaamse Vallei

    \n", "
    \n", " \n", " \n", "
    \n", "

    0163 - 0163 - Pleistoceen van de riviervalleien

    \n", "
    \n", " \n", " \n", "
    \n", "

    0170 - 0170 - Maas- en Rijnafzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0171 - 0171 - Afzettingen Hoofdterras

    \n", "
    \n", " \n", " \n", "
    \n", "

    0172 - 0172 - Afzettingen Tussenterassen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0173 - 0173 - Afzettingen Maasvlakte

    \n", "
    \n", " \n", " \n", "
    \n", "

    0200 - 0200 - Kempens Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0210 - 0210 - Kiezeloolietformatie ten noorden van Feldbiss

    \n", "
    \n", " \n", " \n", "
    \n", "

    0211 - 0211 - Zandige eenheid boven de Brunssum I-klei

    \n", "
    \n", " \n", " \n", "
    \n", "

    0212 - 0212 - Brunssum I-Klei

    \n", "
    \n", " \n", " \n", "
    \n", "

    0213 - 0213 - Zand van Pey

    \n", "
    \n", " \n", " \n", "
    \n", "

    0214 - 0214 - Brunssum II-klei

    \n", "
    \n", " \n", " \n", "
    \n", "

    0215 - 0215 - Zand van Waubach

    \n", "
    \n", " \n", " \n", "
    \n", "

    0220 - 0220 - Klei-zand-complex van de Kempen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0221 - 0221 - Klei van Turnhout

    \n", "
    \n", " \n", " \n", "
    \n", "

    0222 - 0222 - Zand van Beerse

    \n", "
    \n", " \n", " \n", "
    \n", "

    0223 - 0223 - Klei van Rijkevorsel

    \n", "
    \n", " \n", " \n", "
    \n", "

    0230 - 0230 - Pleistoceen en Plioceen aquifer

    \n", "
    \n", " \n", " \n", "
    \n", "

    0231 - 0231 - Zanden van Brasschaat en/of Merksplas

    \n", "
    \n", " \n", " \n", "
    \n", "

    0232 - 0232 - Zand van Mol

    \n", "
    \n", " \n", " \n", "
    \n", "

    0233 - 0233 - Zandige top van Lillo

    \n", "
    \n", " \n", " \n", "
    \n", "

    0234 - 0234 - Zand van Poederlee en/of zandige top van Kasterlee

    \n", "
    \n", " \n", " \n", "
    \n", "

    0240 - 0240 - Pliocene kleiige laag

    \n", "
    \n", " \n", " \n", "
    \n", "

    0241 - 0241 - Kleiig deel van Lillo en/of van de overgang Lillo-Kattendijk

    \n", "
    \n", " \n", " \n", "
    \n", "

    0242 - 0242 - Kleiige overgang tussen de zanden van Kasterlee en Diest

    \n", "
    \n", " \n", " \n", "
    \n", "

    0250 - 0250 - Mioceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0251 - 0251 - Zand van Kattendijk en/of onderste zandlaag van Lillo

    \n", "
    \n", " \n", " \n", "
    \n", "

    0252 - 0252 - Zand van Diest

    \n", "
    \n", " \n", " \n", "
    \n", "

    0253 - 0253 - Zand van Bolderberg

    \n", "
    \n", " \n", " \n", "
    \n", "

    0254 - 0254 - Zanden van Berchem en/of Voort

    \n", "
    \n", " \n", " \n", "
    \n", "

    0255 - 0255 - Klei van Veldhoven

    \n", "
    \n", " \n", " \n", "
    \n", "

    0256 - 0256 - Zand van Eigenbilzen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0300 - 0300 - Boom Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    0301 - 0301 - Kleiig deel van Eigenbilzen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0302 - 0302 - Klei van Putte

    \n", "
    \n", " \n", " \n", "
    \n", "

    0303 - 0303 - Klei van Terhagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0304 - 0304 - Klei van Belsele-Waas

    \n", "
    \n", " \n", " \n", "
    \n", "

    0400 - 0400 - Oligoceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0410 - 0410 - Zand van Kerniel

    \n", "
    \n", " \n", " \n", "
    \n", "

    0420 - 0420 - Klei van Kleine-Spouwen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0430 - 0430 - Ruisbroek-Berg Aquifer

    \n", "
    \n", " \n", " \n", "
    \n", "

    0431 - 0431 - Zand van Berg

    \n", "
    \n", " \n", " \n", "
    \n", "

    0432 - 0432 - Zand van Kerkom

    \n", "
    \n", " \n", " \n", "
    \n", "

    0433 - 0433 - Kleiig zand van Oude Biezen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0434 - 0434 - Zand van Boutersem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0435 - 0435 - Zand van Ruisbroek

    \n", "
    \n", " \n", " \n", "
    \n", "

    0436 - 0436 - Zand van Wintham

    \n", "
    \n", " \n", " \n", "
    \n", "

    0440 - 0440 - Tongeren Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    0441 - 0441 - Klei van Henis

    \n", "
    \n", " \n", " \n", "
    \n", "

    0442 - 0442 - Klei van Watervliet

    \n", "
    \n", " \n", " \n", "
    \n", "

    0450 - 0450 - Onder-Oligoceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0451 - 0451 - Zand van Neerrepen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0452 - 0452 - Zand-Klei van Grimmertingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0453 - 0453 - Kleiig zand van Bassevelde

    \n", "
    \n", " \n", " \n", "
    \n", "

    0500 - 0500 - Bartoon Aquitardsysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0501 - 0501 - Klei van Onderdijke

    \n", "
    \n", " \n", " \n", "
    \n", "

    0502 - 0502 - Zand van Buisputten

    \n", "
    \n", " \n", " \n", "
    \n", "

    0503 - 0503 - Klei van Zomergem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0504 - 0504 - Zand van Onderdaele

    \n", "
    \n", " \n", " \n", "
    \n", "

    0505 - 0505 - Kleien van Ursel en/of Asse

    \n", "
    \n", " \n", " \n", "
    \n", "

    0600 - 0600 - Ledo Paniseliaan Brusseliaan Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0610 - 0610 - Wemmel-Lede Aquifer

    \n", "
    \n", " \n", " \n", "
    \n", "

    0611 - 0611 - Zand van Wemmel

    \n", "
    \n", " \n", " \n", "
    \n", "

    0612 - 0612 - Zand van Lede

    \n", "
    \n", " \n", " \n", "
    \n", "

    0620 - 0620 - Zand van Brussel

    \n", "
    \n", " \n", " \n", "
    \n", "

    0630 - 0630 - Afzettingen van het Boven-Paniseliaan

    \n", "
    \n", " \n", " \n", "
    \n", "

    0631 - 0631 - Zanden van Aanlter en/of Oedelem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0632 - 0632 - Zandige klei van Beernem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0640 - 0640 - Zandige afzettingen van het Onder-Paniseliaan (Vlierzele en/of Aalterbrugge)

    \n", "
    \n", " \n", " \n", "
    \n", "

    0700 - 0700 - Paniseliaan Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    0701 - 0701 - Klei van Pittem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0702 - 0702 - Klei van Merelbeke

    \n", "
    \n", " \n", " \n", "
    \n", "

    0800 - 0800 - Ieperiaan Aquifer (Egem en of Mont-Panisel)

    \n", "
    \n", " \n", " \n", "
    \n", "

    0900 - 0900 - Ieperiaan aquitardsysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    0910 - 0910 - Silt van Kortemark

    \n", "
    \n", " \n", " \n", "
    \n", "

    0920 - 0920 - Afzettingen van Kortrijk

    \n", "
    \n", " \n", " \n", "
    \n", "

    0921 - 0921 - Klei van Aalbeke

    \n", "
    \n", " \n", " \n", "
    \n", "

    0922 - 0922 - Klei van Moen

    \n", "
    \n", " \n", " \n", "
    \n", "

    0923 - 0923 - Zand van Mons-en-Pévèle

    \n", "
    \n", " \n", " \n", "
    \n", "

    0924 - 0924 - Klei van Saint-Maur

    \n", "
    \n", " \n", " \n", "
    \n", "

    0925 - 0925 - Klei van Mont-Héribu

    \n", "
    \n", " \n", " \n", "
    \n", "

    1000 - 1000 - Paleoceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    1010 - 1010 - Landeniaan Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    1011 - 1011 - Zand van Knokke

    \n", "
    \n", " \n", " \n", "
    \n", "

    1012 - 1012 - Zandige afzettingen van Loksbergen en/of Dormaal

    \n", "
    \n", " \n", " \n", "
    \n", "

    1013 - 1013 - Zand van Grandglise en/of Hoegaarden

    \n", "
    \n", " \n", " \n", "
    \n", "

    1014 - 1014 - Kleiig deel van Lincent

    \n", "
    \n", " \n", " \n", "
    \n", "

    1015 - 1015 - Versteend deel van Lincent

    \n", "
    \n", " \n", " \n", "
    \n", "

    1020 - 1020 - Landeniaan en Heersiaan Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    1021 - 1021 - Siltige afzetting van Halen

    \n", "
    \n", " \n", " \n", "
    \n", "

    1022 - 1022 - Klei van Waterschei

    \n", "
    \n", " \n", " \n", "
    \n", "

    1023 - 1023 - Slecht doorlatend deel van de mergels van Gelinden

    \n", "
    \n", " \n", " \n", "
    \n", "

    1030 - 1030 - Heersiaan en Opglabbeek Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    1031 - 1031 - Doorlatend deel van de Mergels van Gelinden

    \n", "
    \n", " \n", " \n", "
    \n", "

    1032 - 1032 - Zand van Orp

    \n", "
    \n", " \n", " \n", "
    \n", "

    1033 - 1033 - Zand van Eisden

    \n", "
    \n", " \n", " \n", "
    \n", "

    1034 - 1034 - Klei van Opoeteren

    \n", "
    \n", " \n", " \n", "
    \n", "

    1035 - 1035 - Zand van Maasmechelen

    \n", "
    \n", " \n", " \n", "
    \n", "

    1100 - 1100 - Krijt Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    1110 - 1110 - Krijt Aquifer

    \n", "
    \n", " \n", " \n", "
    \n", "

    1111 - 1111 - Kalksteen van Houthem

    \n", "
    \n", " \n", " \n", "
    \n", "

    1112 - 1112 - Tufkrijt van Maastricht

    \n", "
    \n", " \n", " \n", "
    \n", "

    1113 - 1113 - Krijt van Gulpen

    \n", "
    \n", " \n", " \n", "
    \n", "

    1120 - 1120 - Afzettingen van Vaals (Smectiet van Herve)

    \n", "
    \n", " \n", " \n", "
    \n", "

    1130 - 1130 - Zand van Aken

    \n", "
    \n", " \n", " \n", "
    \n", "

    1140 - 1140 - Turoonmergels op Massief van Brabant

    \n", "
    \n", " \n", " \n", "
    \n", "

    1150 - 1150 - Wealdiaan

    \n", "
    \n", " \n", " \n", "
    \n", "

    1200 - 1200 - Jura-Trias-Perm

    \n", "
    \n", " \n", " \n", "
    \n", "

    1210 - 1210 - Jura

    \n", "
    \n", " \n", " \n", "
    \n", "

    1220 - 1220 - Trias

    \n", "
    \n", " \n", " \n", "
    \n", "

    1230 - 1230 - Perm

    \n", "
    \n", " \n", " \n", "
    \n", "

    1300 - 1300 - Sokkel

    \n", "
    \n", " \n", " \n", "
    \n", "

    1310 - 1310 - Boven-Carboon

    \n", "
    \n", " \n", " \n", "
    \n", "

    1320 - 1320 - Kolenkalk

    \n", "
    \n", " \n", " \n", "
    \n", "

    1330 - 1330 - Devoon

    \n", "
    \n", " \n", " \n", "
    \n", "

    1340 - 1340 - Cambro-Siluur Massief van Brabant

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", "

\n", "
\n", " " ], "text/plain": [ "" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "hs" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", "
\n", "

pkey_interpretatie - URL die verwijst naar de gegevens van deze hydrogeologische stratigrafie op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen.

\n", "
\n", " " ], "text/plain": [ "{'name': 'pkey_interpretatie', 'definition': \"URL die verwijst naar de gegevens van deze hydrogeologische stratigrafie op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen.\", 'type': 'string', 'multivalue': False, 'notnull': False, 'query': True, 'cost': 1}" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fields['pkey_interpretatie']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The fields `pkey_interpretatie` and `pkey_boring` are important identifiers. In this case `pkey_interpretatie` is the unique identifier of this interpretation and is also the **permanent url** where the data can be consulted (~https://www.dov.vlaanderen.be/data/interpretatie/...). You can retrieve an XML representation by appending '.xml' to the URL, or a JSON equivalent by appending '.json'.\n", "\n", "The `pkey_boring` is the identifier of the borehole from which this interpretation was made. As mentioned before, it is also the **permanent url** (~https://www.dov.vlaanderen.be/data/boring/...). " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Optionally, if the field has an associated codelist, this is listed as *codelist*:" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", "
\n", "

Type_proef - Het type van de proef waarvan de hydrogeologische stratigrafie een interpretatie is. Bij een hydrogeologische stratigrafie zal dit altijd 'Boring' zijn.

\n", "
\n", " " ], "text/plain": [ "{'name': 'Type_proef', 'definition': \"Het type van de proef waarvan de hydrogeologische stratigrafie een interpretatie is. Bij een hydrogeologische stratigrafie zal dit altijd 'Boring' zijn.\", 'type': 'string', 'multivalue': False, 'notnull': False, 'query': True, 'cost': 1, 'codelist': >}" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fields['Type_proef']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Query the data with pydov" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Attributes" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The data can be queried on **attributes**, **location** or both. To query on attributes, the OGC filter functions from OWSLib are used:" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "PropertyIsBetween\n", "PropertyIsEqualTo\n", "PropertyIsGreaterThan\n", "PropertyIsGreaterThanOrEqualTo\n", "PropertyIsLessThan\n", "PropertyIsLessThanOrEqualTo\n", "PropertyIsLike\n", "PropertyIsNotEqualTo\n", "PropertyIsNull\n", "SortProperty\n" ] } ], "source": [ "# list available query methods\n", "methods = [i for i,j in inspect.getmembers(sys.modules['owslib.fes2'], \n", " inspect.isclass) \n", " if 'Property' in i]\n", "print(*methods, sep = \"\\n\") " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "If you are for example interested in all the hydrostratigraphic interpretations in the city of Leuven, you compose the query like below (mind that the values are in Dutch):" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/036] cccccccccccccccccccccccccccccccccccc\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totaquifer
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.00.04.50162
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.04.559.00620
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.059.090.70900
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.090.7110.01013
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.0110.0130.01014
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "2 https://www.dov.vlaanderen.be/data/interpretat... \n", "3 https://www.dov.vlaanderen.be/data/interpretat... \n", "4 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1932... \n", "1 https://www.dov.vlaanderen.be/data/boring/1932... \n", "2 https://www.dov.vlaanderen.be/data/boring/1932... \n", "3 https://www.dov.vlaanderen.be/data/boring/1932... \n", "4 https://www.dov.vlaanderen.be/data/boring/1932... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 goed 173252.0 179257.0 17.0 \n", "1 goed 173252.0 179257.0 17.0 \n", "2 goed 173252.0 179257.0 17.0 \n", "3 goed 173252.0 179257.0 17.0 \n", "4 goed 173252.0 179257.0 17.0 \n", "\n", " diepte_laag_van diepte_laag_tot aquifer \n", "0 0.0 4.5 0162 \n", "1 4.5 59.0 0620 \n", "2 59.0 90.7 0900 \n", "3 90.7 110.0 1013 \n", "4 110.0 130.0 1014 " ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from owslib.fes2 import PropertyIsEqualTo\n", "query = PropertyIsEqualTo(\n", " propertyname='gemeente',\n", " literal='Leuven')\n", "dfhs = hs.search(query=query)\n", "dfhs.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This yielded 36 interpretations from 36, or less, boreholes. It can be less than 36 boreholes because multiple interpretations can be made of a single borehole. \n", "\n", "If you would like to narrow the search down to for example interpretations deeper than 200 meters, you can combine features in the search using the **logical operators And, Or** provided by OWSLib:" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/001] c\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totaquifer
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.00.04.50162
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.04.559.00620
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.059.090.70900
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.090.7110.01013
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.0110.0130.01014
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "2 https://www.dov.vlaanderen.be/data/interpretat... \n", "3 https://www.dov.vlaanderen.be/data/interpretat... \n", "4 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1932... \n", "1 https://www.dov.vlaanderen.be/data/boring/1932... \n", "2 https://www.dov.vlaanderen.be/data/boring/1932... \n", "3 https://www.dov.vlaanderen.be/data/boring/1932... \n", "4 https://www.dov.vlaanderen.be/data/boring/1932... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 goed 173252.0 179257.0 17.0 \n", "1 goed 173252.0 179257.0 17.0 \n", "2 goed 173252.0 179257.0 17.0 \n", "3 goed 173252.0 179257.0 17.0 \n", "4 goed 173252.0 179257.0 17.0 \n", "\n", " diepte_laag_van diepte_laag_tot aquifer \n", "0 0.0 4.5 0162 \n", "1 4.5 59.0 0620 \n", "2 59.0 90.7 0900 \n", "3 90.7 110.0 1013 \n", "4 110.0 130.0 1014 " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from owslib.fes2 import And\n", "from owslib.fes2 import PropertyIsGreaterThan\n", "query = And([\n", " PropertyIsEqualTo(\n", " propertyname='gemeente',\n", " literal='Leuven'),\n", " PropertyIsGreaterThan(\n", " propertyname='diepte_tot_m',\n", " literal='200')\n", " ])\n", "dfhs = hs.search(query=query)\n", "dfhs.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Mind the difference between attributes `diepte_tot_m` and `diepte_laag_...`. The former is defined in the WFS service and can be used as attribute in the query. The latter attributes are defined in the linked XML document, from which the information is only available after it has been gathered from the DOV webservice. All the attributes with cannot be used in the intial query and should be used in a subsequent filtering of the Pandas DataFrame." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "More information on querying attribute properties is given in the [docs](https://pydov.readthedocs.io/en/stable/query_attribute.html). Worth mentioning is the query using lists where pydov extends the default OGC filter expressions described with a new expression **PropertyInList** that allows you to use lists (of strings) in search queries." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "One last goodie is the possibility to join searches using common attibutes. For example the `pkey_boring` field, denoting the borehole. As such, you can get the boreholes for which a hydrostratigraphical interpretation is available, and also query the lithological description of that borehole. Like below:" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/001] c\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totaquiferbeschrijving
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.00.04.50162NaN
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.04.559.00620sable gris quartzeux, avec grès gris quartzeux...
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.059.090.70900argile grise finement sableuse
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.090.7110.01013NaN
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1932...goed173252.0179257.017.0110.0130.01014sable argileux gris, avec petits débris broyés...
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "2 https://www.dov.vlaanderen.be/data/interpretat... \n", "3 https://www.dov.vlaanderen.be/data/interpretat... \n", "4 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1932... \n", "1 https://www.dov.vlaanderen.be/data/boring/1932... \n", "2 https://www.dov.vlaanderen.be/data/boring/1932... \n", "3 https://www.dov.vlaanderen.be/data/boring/1932... \n", "4 https://www.dov.vlaanderen.be/data/boring/1932... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 goed 173252.0 179257.0 17.0 \n", "1 goed 173252.0 179257.0 17.0 \n", "2 goed 173252.0 179257.0 17.0 \n", "3 goed 173252.0 179257.0 17.0 \n", "4 goed 173252.0 179257.0 17.0 \n", "\n", " diepte_laag_van diepte_laag_tot aquifer \\\n", "0 0.0 4.5 0162 \n", "1 4.5 59.0 0620 \n", "2 59.0 90.7 0900 \n", "3 90.7 110.0 1013 \n", "4 110.0 130.0 1014 \n", "\n", " beschrijving \n", "0 NaN \n", "1 sable gris quartzeux, avec grès gris quartzeux... \n", "2 argile grise finement sableuse \n", "3 NaN \n", "4 sable argileux gris, avec petits débris broyés... " ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.util.query import Join\n", "from pydov.search.interpretaties import LithologischeBeschrijvingenSearch\n", "\n", "ls = LithologischeBeschrijvingenSearch()\n", "dfls = ls.search(query=Join(dfhs, 'pkey_boring'))\n", "df_joined = pd.merge(dfhs, dfls.loc[:, ['pkey_boring','diepte_laag_van', 'diepte_laag_tot', 'beschrijving']], \n", " how='left', \n", " left_on=['pkey_boring','diepte_laag_van', 'diepte_laag_tot'], \n", " right_on = ['pkey_boring','diepte_laag_van', 'diepte_laag_tot']\n", " )\n", "df_joined.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Location" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "One can also query on **location**, using the location objects and spatial filters from the pydov.util.location module. For example, to request all hydrostratigraphic interpretations in a given bounding **box**:" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/005] ccccc\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totaquifer
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/2016...goed170853.0172888.044.00.05.00153
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/2016...goed170853.0172888.044.05.042.00620
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/2016...goed170853.0172888.044.042.043.00922
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1946...goed170355.0171118.024.40.09.00163
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1946...goed170355.0171118.024.49.010.50920
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "2 https://www.dov.vlaanderen.be/data/interpretat... \n", "3 https://www.dov.vlaanderen.be/data/interpretat... \n", "4 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring \\\n", "0 https://www.dov.vlaanderen.be/data/boring/2016... \n", "1 https://www.dov.vlaanderen.be/data/boring/2016... \n", "2 https://www.dov.vlaanderen.be/data/boring/2016... \n", "3 https://www.dov.vlaanderen.be/data/boring/1946... \n", "4 https://www.dov.vlaanderen.be/data/boring/1946... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 goed 170853.0 172888.0 44.0 \n", "1 goed 170853.0 172888.0 44.0 \n", "2 goed 170853.0 172888.0 44.0 \n", "3 goed 170355.0 171118.0 24.4 \n", "4 goed 170355.0 171118.0 24.4 \n", "\n", " diepte_laag_van diepte_laag_tot aquifer \n", "0 0.0 5.0 0153 \n", "1 5.0 42.0 0620 \n", "2 42.0 43.0 0922 \n", "3 0.0 9.0 0163 \n", "4 9.0 10.5 0920 " ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.util.location import Within, Box\n", "location = Within(Box(170000, 171000, 172000, 173000, epsg=31370))\n", "df = hs.search(location=location)\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Alternatively, you can define a **Point** or a **GML document** for the spatial query as is described in the [docs](https://pydov.readthedocs.io/en/stable/query_location.html). For example, if you are interested in a site you can define the point with a search radius of for example 500 meters like this:" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/001] c\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totaquifer
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.390.00.60110
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.390.614.40100
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.3914.495.10000
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.3995.1118.91100
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.39118.9124.51300
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "2 https://www.dov.vlaanderen.be/data/interpretat... \n", "3 https://www.dov.vlaanderen.be/data/interpretat... \n", "4 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1974... \n", "1 https://www.dov.vlaanderen.be/data/boring/1974... \n", "2 https://www.dov.vlaanderen.be/data/boring/1974... \n", "3 https://www.dov.vlaanderen.be/data/boring/1974... \n", "4 https://www.dov.vlaanderen.be/data/boring/1974... \n", "\n", " betrouwbaarheid_interpretatie x y \\\n", "0 goed 171548.77 172680.92 \n", "1 goed 171548.77 172680.92 \n", "2 goed 171548.77 172680.92 \n", "3 goed 171548.77 172680.92 \n", "4 goed 171548.77 172680.92 \n", "\n", " start_interpretatie_mtaw diepte_laag_van diepte_laag_tot aquifer \n", "0 26.39 0.0 0.6 0110 \n", "1 26.39 0.6 14.4 0100 \n", "2 26.39 14.4 95.1 0000 \n", "3 26.39 95.1 118.9 1100 \n", "4 26.39 118.9 124.5 1300 " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.util.location import WithinDistance, Point\n", "location = WithinDistance(\n", " Point(171500, 172500, epsg=31370), \n", " 500, \n", " distance_unit='meter'\n", " )\n", "df = hs.search(location=location)\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Groundwater head data" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Querying the groundwater head data follows the same workflow as mentioned above for the interpretation of borehole data with the instantiation of a search object and the subsequent query with selection on attribute or location properties." ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "tags": [] }, "outputs": [ { "data": { "text/html": [ "\n", " \n", "
\n", " \n", "
\n", " pydov.search.grondwaterfilter.GrondwaterFilterSearch\n", "
\n", "

In de Databank Ondergrond Vlaanderen zijn verschillende grondwatermeetnetten opgenomen. Deze meetnetten staan in functie van uitgebreide monitoringprogramma’s met de bedoeling een goed beeld te krijgen van de beschikbare grondwaterkwantiteit en grondwaterkwaliteit van de watervoerende lagen in Vlaanderen.

\n", " \n", "
\n", "

gw_id - Identificatie van de grondwaterlocatie. Dit veld was vroeger bekend als 'putnummer'.

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

pkey_grondwaterlocatie - URL die verwijst naar de gegevens van de grondwaterlocatie op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

filternummer - Het filternummer van de filter.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

pkey_filter - URL die verwijst naar de gegevens van de filter op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen. Wanneer dit veld leeg is betreft dit record een put zonder filters.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

namen - Andere namen voor deze grondwaterlocatie

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

filtergrafiek - URL die verwijst naar een interactieve grafiek van de filter op de website. Wanneer dit veld leeg is betreft dit record een grondwaterlocatie zonder filters

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

putgrafiek - URL die verwijst naar een interactieve grafiek van alle filters van de grondwaterlocatie op de website.

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Aquifer_HCOVv1 - None

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

Aquifer_HCOVv2 - None

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

diepte_onderkant_filter - De diepte van de onderkant van de filter (in meter, positief onder aanvangspeil put gegeven in attribuut Z_mTAW)

  • type: float
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

lengte_filter - De lengte van de filter (in meter).

  • type: float
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

putsoort - de soort grondwaterlocatie

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.FeatureCatalogueValues\n", "
    \n", " \n", " \n", "
    \n", "

    Installatie - Installatie

    \n", "
    \n", " \n", " \n", "
    \n", "

    batterijput - batterijput

    \n", "
    \n", " \n", " \n", "
    \n", "

    bodemlus - bodemlus

    \n", "
    \n", " \n", " \n", "
    \n", "

    bron, natuurlijke holte - bron, natuurlijke holte

    \n", "
    \n", " \n", " \n", "
    \n", "

    bronbemaling - bronbemaling

    \n", "
    \n", " \n", " \n", "
    \n", "

    draineringsinrichting - draineringsinrichting

    \n", "
    \n", " \n", " \n", "
    \n", "

    galerij - galerij

    \n", "
    \n", " \n", " \n", "
    \n", "

    graverij, mijn, groeve - graverij, mijn, groeve

    \n", "
    \n", " \n", " \n", "
    \n", "

    niet-verbuisde boorput - niet-verbuisde boorput

    \n", "
    \n", " \n", " \n", "
    \n", "

    onbekend - onbekend

    \n", "
    \n", " \n", " \n", "
    \n", "

    ring- of steenput - ring- of steenput

    \n", "
    \n", " \n", " \n", "
    \n", "

    verbuisde boorput - verbuisde boorput

    \n", "
    \n", " \n", " \n", "
    \n", "

    vijver - vijver

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

filtertype - Het type van de filter. Wanneer dit veld leeg is betreft dit record een put zonder filters.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.FeatureCatalogueValues\n", "
    \n", " \n", " \n", "
    \n", "

    infiltratiefilter - infiltratiefilter

    \n", "
    \n", " \n", " \n", "
    \n", "

    natuurlijke filter - natuurlijke filter

    \n", "
    \n", " \n", " \n", "
    \n", "

    omkeerbare filter - omkeerbare filter

    \n", "
    \n", " \n", " \n", "
    \n", "

    peilfilter - peilfilter

    \n", "
    \n", " \n", " \n", "
    \n", "

    pompfilter - pompfilter

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

meetnet - Het meetnet waartoe de filter behoort.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.FeatureCatalogueValues\n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 1 - primair meetnet - afdeling Water - meetnet 1 - primair meetnet - afdeling Water

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 10 - rubriek 55 (verticale boringen) - meetnet 10 - rubriek 55 (verticale boringen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 11 - rubriek 53.6 (koude-warmtepompen) - meetnet 11 - rubriek 53.6 (koude-warmtepompen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 3 - tijdelijk meetnet - afdeling Water - meetnet 3 - tijdelijk meetnet - afdeling Water

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 4 - externe instanties - meetnet 4 - externe instanties

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 5 - peilputten drinkwatermaatschappijen - meetnet 5 - peilputten drinkwatermaatschappijen

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 6 - peilputten individuele bedrijven - meetnet 6 - peilputten individuele bedrijven

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 7 - winningsputten - meetnet 7 - winningsputten

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 8 - freatisch meetnet - afdeling water - meetnet 8 - freatisch meetnet - afdeling water

    \n", "
    \n", " \n", " \n", "
    \n", "

    meetnet 9 - peilputten INBO en natuurorganisaties - meetnet 9 - peilputten INBO en natuurorganisaties

    \n", "
    \n", " \n", " \n", "
    \n", "

    onbekend - onbekend

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

x - De x-coördinaat van de put in het Lambert72 coördinaatsysteem (in meter, EPSG:31370).

  • type: float
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

y - De y-coördinaat van de put in het Lambert72 coördinaatsysteem (in meter, EPSG:31370).

  • type: float
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

start_grondwaterlocatie_mtaw - De hoogte van het aanvangspeil van de put in het TAW stelsel (in meter).

  • type: float
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

gemeente - De gemeente waarin de put gelegen is

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

grondwaterlichaam - Het grondwaterlichaam waarin de filter hangt. Als tekst, opgebouwd uit de afkorting en de naam gescheiden door \" - \"

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

afgesloten_volgens_gwdecreet - None

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

datum_in_filter - De datum wanneer de filter in gebruik genomen is

  • type: date
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

datum_uit_filter - De datum wanneer de filter uit gebruik genomen is

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

stijghoogterapport - URL die verwijst naar het stijghoogterapport van de grondwaterlocatie in PDF formaat.

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

analyserapport - URL die verwijst naar het analyserapport van de grondwaterlocatie in PDF formaat.

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

boornummer - Het boornummer (ook gekend als proefnummer) van de boring.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

boringfiche - Permanente URL die verwijst naar de gegevens van de boring op de website. Voeg '.xml' toe om een XML voorstelling van deze gegevens te verkrijgen.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

peilmetingen_van - Datum waarop de eerste peilmeting werd uitgevoerd.

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

peilmetingen_tot - Datum waarop de laatste peilmeting werd uitgevoerd.

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

kwaliteitsmetingen_van - Datum waarop het eerste grondwaterstaal op deze filter werd genomen

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

kwaliteitsmetingen_tot - Datum waarop het laatste grondwaterstaal op deze filter werd genomen.

  • type: date
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

recentste_exploitant - De recentste exploitant van een grondwaterlocatie (installatieput)

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

beheerder - De huidige beheerder van een grondwaterlocatie (meetnetput)

  • type: string
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

aantal_dagen_sinds_laatste_meting - None

  • type: integer
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

eerste_invoer - Het tijdstip waarop deze filter voor het eerst in DOV ingevoerd werd. In het geval van een grondwaterlocatie zonder filter: het tijdstip waarop deze grondwaterlocatie voor het eerst in DOV ingevoerd werd.

  • type: datetime
  • notnull: True
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

recentste_installatie - De unieke identificatie van de meest recente installatie waaraan deze grondwaterlocatie gekoppeld is.

  • type: string
  • notnull: False
  • query: True
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

geom - None

  • type: geometry
  • notnull: False
  • query: False
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

meetnet_code - Tot welk meetnet behoort deze filter.

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    0 - 0 - onbekend

    \n", "
    \n", " \n", " \n", "
    \n", "

    1 - 1 - meetnet 1 - primair meetnet - afdeling Water

    \n", "
    \n", " \n", " \n", "
    \n", "

    10 - 10 - meetnet10 - rubriek 55 (verticale boringen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    100 - 100 - meetnet 100 - Geotechniek

    \n", "
    \n", " \n", " \n", "
    \n", "

    11 - 11 - meetnet 11 - rubriek 53.6 (koude-warmtepompen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    12 - 12 - meetnet 12 - lokale besturen

    \n", "
    \n", " \n", " \n", "
    \n", "

    2 - 2 - meetnet 2 - onzekere kwaliteit - afdeling Water

    \n", "
    \n", " \n", " \n", "
    \n", "

    3 - 3 - meetnet 3 - tijdelijk meetnet - afdeling Water

    \n", "
    \n", " \n", " \n", "
    \n", "

    4 - 4 - meetnet 4 - externe instanties

    \n", "
    \n", " \n", " \n", "
    \n", "

    5 - 5 - meetnet 5 - peilputten drinkwatermaatschappijen

    \n", "
    \n", " \n", " \n", "
    \n", "

    6 - 6 - meetnet 6 - peilputten individuele bedrijven

    \n", "
    \n", " \n", " \n", "
    \n", "

    7 - 7 - meetnet 7 - winningsputten

    \n", "
    \n", " \n", " \n", "
    \n", "

    8 - 8 - meetnet 8 - freatisch meetnet - afdeling water

    \n", "
    \n", " \n", " \n", "
    \n", "

    9 - 9 - meetnet 9 - peilputten INBO en natuurorganisaties

    \n", "
    \n", " \n", " \n", "
    \n", "

    edov - edov - meetnet 20 – eDOV erkende boorbedrijven

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

aquifer_code - De aquifer (watervoerende laag) waarin de filter hangt (code) (HCOVv2)

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    A0000 - A0000 - Onbepaald

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0100 - A0100 - Quartaire Aquifersystemen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0110 - A0110 - Ophogingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0120 - A0120 - Duinen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0130 - A0130 - Polderafzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0131 - A0131 - Kleiige polderafzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0132 - A0132 - Zandige Kreekruggen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0133 - A0133 - Veen-kleiige poelgronden

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0134 - A0134 - Strandafzettingen***

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0140 - A0140 - Alluviale deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0150 - A0150 - Eolische deklagen buiten de Roerdalslenk

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0151 - A0151 - Zandige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0152 - A0152 - Zand-lemige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0153 - A0153 - Lemige deklagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0160 - A0160 - Fluvio-eolische deklagen binnen de Roerdalslenk

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0161 - A0161 - Boxtel zand 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0162 - A0162 - Boxtel klei 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0163 - A0163 - Boxtel zand 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0164 - A0164 - Boxtel klei 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0165 - A0165 - Boxtel zand 3

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0170 - A0170 - Pleistocene afzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0180 - A0180 - Maas- en Rijnafzettingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0181 - A0181 - Beegden zand 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0182 - A0182 - Beegden klei 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0183 - A0183 - Beegden zand 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0184 - A0184 - Beegden klei 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0185 - A0185 - Beegden zand 3

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0186 - A0186 - Beegden ongedifferentieerd

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0187 - A0187 - Sterksel zand 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0188 - A0188 - Sterksel klei 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0189 - A0189 - Sterksel zand 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0200 - A0200 - Kempens Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0210 - A0210 - Klei-zand complex van de Kempen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0220 - A0220 - Pleistoceen en Plioceen Aquifersysteem - west

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0221 - A0221 - Kleiig zand van Malle

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0222 - A0222 - Zand van Merksplas

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0223 - A0223 - Zanden van Zandvliet en Merksem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0224 - A0224 - Kleiig zand van Kruisschans

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0225 - A0225 - Zanden van Oorderen en Luchtbal

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0226 - A0226 - Ongedifferentieerde zanden van Lillo en Poederlee

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0230 - A0230 - Pleistoceen en Plioceen Aquifersysteem - oost

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0231 - A0231 - Zand van Mol

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0232 - A0232 - Kiezeloöliet zand 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0233 - A0233 - Kiezeloöliet klei 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0234 - A0234 - Kiezeloöliet zand 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0235 - A0235 - Kiezeloöliet klei 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0236 - A0236 - Kiezeloöliet zand 3

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0237 - A0237 - Kiezeloöliet klei 3

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0238 - A0238 - Kiezeloöliet zand 4

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0240 - A0240 - Kleiige zanden van Kattendijk en Kasterlee

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0250 - A0250 - Mioceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0251 - A0251 - Zand van Diest buiten de Roerdalslenk

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0252 - A0252 - Zanden van Diest en Bolderberg binnen de Roerdalslenk

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0253 - A0253 - Zand van Bolderberg buiten de Roerdalslenk

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0254 - A0254 - Zanden van Berchem en Voort buiten de Roerdalslenk

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0255 - A0255 - Voort zand 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0256 - A0256 - Voort klei 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0257 - A0257 - Voort zand 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0258 - A0258 - Zandig deel van Eigenbilzen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0300 - A0300 - Boom Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0301 - A0301 - Kleiig deel van Eigenbilzen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0302 - A0302 - Klei-silt van Boeretang

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0303 - A0303 - Klei van Putte

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0304 - A0304 - Klei van Terhagen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0305 - A0305 - Silt van Belsele-Waas

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0400 - A0400 - Oligoceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0410 - A0410 - Zand van Kerniel

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0420 - A0420 - Klei van Kleine-Spouwen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0430 - A0430 - Ruisbroek-Berg Aquifer

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0431 - A0431 - Zand van Berg

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0432 - A0432 - Zand van Ruisbroek

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0433 - A0433 - Zand van Kerkom

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0434 - A0434 - Kleiig zand van Alden Biesen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0440 - A0440 - Tongeren Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0441 - A0441 - Klei van Henis

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0442 - A0442 - Zandige klei van Watervliet

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0450 - A0450 - Onder-Oligoceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0451 - A0451 - Zand van Neerrepen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0452 - A0452 - Kleiig zand van Grimmertingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0453 - A0453 - Kleiig zand van Bassevelde

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0500 - A0500 - Bartoon Aquitardsysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0501 - A0501 - Bartoon klei 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0502 - A0502 - Bartoon zand 1

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0503 - A0503 - Bartoon klei 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0504 - A0504 - Bartoon zand 2

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0505 - A0505 - Bartoon klei 3

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0600 - A0600 - Ledo Paniseliaan Brusseliaan Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0610 - A0610 - Wemmel-Lede Aquifer

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0611 - A0611 - Zand van Wemmel

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0612 - A0612 - Zand van Lede

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0620 - A0620 - Zand van Brussel

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0630 - A0630 - Afzettingen van het Paniseliaan

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0631 - A0631 - Zand van Oedelem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0632 - A0632 - Zandige klei van Beernem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0633 - A0633 - Zanden van Aalterbrugge en Vlierzele

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0700 - A0700 - Paniseliaan Aquitardsysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0701 - A0701 - Kleiig zand van Pittem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0702 - A0702 - Klei van Merelbeke

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0800 - A0800 - Ieperiaan Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0801 - A0801 - Zand van Egem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0802 - A0802 - Klei van Egemkapel

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0803 - A0803 - Silt van Kortemark en zand van Mont-Panisel

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0900 - A0900 - Ieperiaan Aquitardsysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0901 - A0901 - Klei van Aalbeke

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0902 - A0902 - Zandige klei van Roubaix

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0903 - A0903 - Kleiig zand van Mons-en-Pévèle

    \n", "
    \n", " \n", " \n", "
    \n", "

    A0904 - A0904 - Kleien van Orchies, Mont-Héribu en Het Zoute

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1000 - A1000 - Paleoceen Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1010 - A1010 - Landeniaan Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1011 - A1011 - Zand van Knokke

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1012 - A1012 - Zandige afzettingen van Loksbergen en Dormaal

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1013 - A1013 - Zand van Grandglise

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1020 - A1020 - Landeniaan en Heersiaan Aquitard

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1021 - A1021 - Siltige afzettingen van Halen en Tufsteen van Lincent

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1022 - A1022 - Kleien van Waterschei en Beselare

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1030 - A1030 - Heersiaan en Opglabbeek Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1031 - A1031 - Kleiige mergels van Maaseik

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1032 - A1032 - Mergels van Gelinden

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1033 - A1033 - Zand van Orp

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1034 - A1034 - Zand van Eisden

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1035 - A1035 - Klei van Opoeteren

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1100 - A1100 - Krijt Aquifersysteem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1101 - A1101 - Kalkareniet van Houthem

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1102 - A1102 - Kalkarenieten van Maastricht en Kunrade

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1103 - A1103 - Krijtafzettingen van Gulpen en Nevele, zanden en mergels van Vaals en Dorne en de Turoonmergels

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1104 - A1104 - Zand van Aken

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1200 - A1200 - Jura - Trias - Perm

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1210 - A1210 - Jura (incl. Sleen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1220 - A1220 - Trias (excl. Sleen) en Perm

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1300 - A1300 - Sokkel

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1310 - A1310 - Boven-Carboon (steenkoolterrein en -lagen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1320 - A1320 - Kolenkalk (incl. Wealdiaan)

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1330 - A1330 - Devoon

    \n", "
    \n", " \n", " \n", "
    \n", "

    A1340 - A1340 - Cambro-Siluur Massief van Brabant

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

grondwaterlichaam_code -

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0160_GWL_1M - BLKS_0160_GWL_1M - Quartaire Maas- en Rijnafzettingen, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0160_GWL_1S - BLKS_0160_GWL_1S - Pleistoceen Rivierafzettingen, lokaal gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0400_GWL_1M - BLKS_0400_GWL_1M - Oligoceen Aquifersysteem, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0400_GWL_1S - BLKS_0400_GWL_1S - Oligoceen Aquifersysteem, lokaal freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0400_GWL_2M - BLKS_0400_GWL_2M - Oligoceen Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0400_GWL_2S - BLKS_0400_GWL_2S - Oligoceen Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0600_GWL_1 - BLKS_0600_GWL_1 - Brusseliaan Aquifer, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0600_GWL_2 - BLKS_0600_GWL_2 - Brusseliaan Aquifer, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_0600_GWL_3 - BLKS_0600_GWL_3 - Brusseliaan venster: contact met Diestiaan, lokaal gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_1000_GWL_1S - BLKS_1000_GWL_1S - Landeniaan Aquifersysteem, lokaal gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_1000_GWL_2S - BLKS_1000_GWL_2S - Landeniaan Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_1100_GWL_1M - BLKS_1100_GWL_1M - Krijt Aquifersysteem, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_1100_GWL_1S - BLKS_1100_GWL_1S - Krijt Aquifersysteem, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_1100_GWL_2M - BLKS_1100_GWL_2M - Krijt Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    BLKS_1100_GWL_2S - BLKS_1100_GWL_2S - Krijt Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    CKS_0200_GWL_1 - CKS_0200_GWL_1 - Centrale zanden van de Kempen, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CKS_0200_GWL_2 - CKS_0200_GWL_2 - Noordelijke Zanden van de Kempen, freatisch, plaatselijk semi-freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CKS_0220_GWL_1 - CKS_0220_GWL_1 - Complex van de Kempen, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CKS_0250_GWL_1 - CKS_0250_GWL_1 - Diestiaangeul: contact Brusseliaan, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0100_GWL_1 - CVS_0100_GWL_1 - Dun Quartair dek boven op Paleogeen klei, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0160_GWL_1 - CVS_0160_GWL_1 - Pleistoceen afzettingen, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0400_GWL_1 - CVS_0400_GWL_1 - Oligoceen Aquifersysteem, lokaal freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0600_GWL_1 - CVS_0600_GWL_1 - Ledo-Paniseliaan Aquifersysteem, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0600_GWL_2 - CVS_0600_GWL_2 - Ledo-Paniseliaan Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0800_GWL_1 - CVS_0800_GWL_1 - Ieperiaan Aquifer, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0800_GWL_2 - CVS_0800_GWL_2 - Ieperiaan Aquifer, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    CVS_0800_GWL_3 - CVS_0800_GWL_3 - Ieperiaan Aquifer Heuvelstreken, lokaal gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    KPS_0120_GWL_1 - KPS_0120_GWL_1 - Duin- en kreekgebieden in het kustgebied, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    KPS_0120_GWL_2 - KPS_0120_GWL_2 - Duin- en kreekgebieden in de Oost-Vlaamse Polders, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    KPS_0160_GWL_1 - KPS_0160_GWL_1 - verzilt Quartair en Eoceen van het kustgebied, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    KPS_0160_GWL_2 - KPS_0160_GWL_2 - verzilt Quartair en Oligoceen van Oost-Vlaamse Polders, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    KPS_0160_GWL_3 - KPS_0160_GWL_3 - verzilt Quartair, Plioceen en Mioceen van Scheldepolders, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    MS_0100_GWL_1 - MS_0100_GWL_1 - Quartair Aquifersysteem, freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    MS_0200_GWL_1 - MS_0200_GWL_1 - Kempens Aquifersysteem, freatisch, plaatselijk semi-freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    MS_0200_GWL_2 - MS_0200_GWL_2 - Kempens Aquifersysteem in de Centrale Slenk, freatisch, plaatselijk semi-freatisch

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1000_GWL_1 - SS_1000_GWL_1 - Landeniaan Aquifersysteem, depressietrechter, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1000_GWL_2 - SS_1000_GWL_2 - Landeniaan Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1300_GWL_1 - SS_1300_GWL_1 - Kolenkalk, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1300_GWL_2 - SS_1300_GWL_2 - Sokkel + Krijt Aquifersysteem, lokaal freatisch, voedingsgebied

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1300_GWL_3 - SS_1300_GWL_3 - Sokkel + Krijt Aquifersysteem, depressietrechter, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1300_GWL_4 - SS_1300_GWL_4 - Sokkel + Krijt Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    SS_1300_GWL_5 - SS_1300_GWL_5 - Sokkel + Krijt Aquifersysteem, depressietrechter, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    X_BLKS_0400_GWL_2 - X_BLKS_0400_GWL_2 - Ten noorden van de grens van het BLKS, in het Oligoceen Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    X_BLKS_0600_GWL_2 - X_BLKS_0600_GWL_2 - Ten N van de grens van het BLKS, in de Brusseliaan Aquifer, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    X_BLKS_1000_GWL_2 - X_BLKS_1000_GWL_2 - Ten N van de grens van het BLKS, in het Landeniaan Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    X_BLKS_1100_GWL_2 - X_BLKS_1100_GWL_2 - Ten N van de grens van het BLKS, in het Krijt Aquifersysteem, gespannen

    \n", "
    \n", " \n", " \n", "
    \n", "

    meerdere GWL - meerdere GWL - Bevat filters in meerder grondwaterlichamen

    \n", "
    \n", " \n", " \n", "
    \n", "

    onbekend - onbekend - onbekend

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

regime -

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

datum - Datum waarop de peilmeting uitgevoerd werd.

  • type: date
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

tijdstip - Tijdstip waarop de peilmeting uitgevoerd werd (optioneel).

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

peil_mtaw - Diepte van de peilmeting, uitgedrukt in mTAW.

  • type: float
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

betrouwbaarheid - Betrouwbaarheid van de peilmeting (goed, onbekend of twijfelachtig).

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

methode - Methode waarop de peilmeting uitgevoerd werd.

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    Dieptelood - Dieptelood

    \n", "
    \n", " \n", " \n", "
    \n", "

    Onbekend - Onbekend

    \n", "
    \n", " \n", " \n", "
    \n", "

    andere methode - andere methode

    \n", "
    \n", " \n", " \n", "
    \n", "

    automatische sonde - automatische sonde

    \n", "
    \n", " \n", " \n", "
    \n", "

    borrelbuis - borrelbuis

    \n", "
    \n", " \n", " \n", "
    \n", "

    gemiddelde van loggermetingen - gemiddelde van loggermetingen

    \n", "
    \n", " \n", " \n", "
    \n", "

    manometer - manometer

    \n", "
    \n", " \n", " \n", "
    \n", "

    peillint - peillint

    \n", "
    \n", " \n", " \n", "
    \n", "

    peilmeting onmogelijk - peilmeting onmogelijk

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

filterstatus - Status van de filter tijdens de peilmeting (in rust - werking).

  • type: string
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    in rust - in rust

    \n", "
    \n", " \n", " \n", "
    \n", "

    onbekend - onbekend

    \n", "
    \n", " \n", " \n", "
    \n", "

    werking - werking

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

filtertoestand - Filtertoestand bij de peilmeting. Standaardwaarde is '1' = Normaal.

  • type: integer
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
  • codelist:
    • \n", " \n", "
    \n", " \n", "
    \n", " pydov.util.codelists.XsdType\n", "
    \n", " \n", " \n", "
    \n", "

    -999 - -999 - Vertrouwelijk (SCK-meting)

    \n", "
    \n", " \n", " \n", "
    \n", "

    -998 - -998 - Past niet in de stijghoogtereeks

    \n", "
    \n", " \n", " \n", "
    \n", "

    -990 - -990 - Verdwenen

    \n", "
    \n", " \n", " \n", "
    \n", "

    -985 - -985 - Infiltratie

    \n", "
    \n", " \n", " \n", "
    \n", "

    -981 - -981 - Buiten bereik Diver (VMW-980)

    \n", "
    \n", " \n", " \n", "
    \n", "

    -980 - -980 - Afpomping

    \n", "
    \n", " \n", " \n", "
    \n", "

    -971 - -971 - \"Meting onder filter (VMW-970)\"

    \n", "
    \n", " \n", " \n", "
    \n", "

    -970 - -970 - Onder water

    \n", "
    \n", " \n", " \n", "
    \n", "

    -960 - -960 - Loopt over

    \n", "
    \n", " \n", " \n", "
    \n", "

    -950 - -950 - Vervallen

    \n", "
    \n", " \n", " \n", "
    \n", "

    -940 - -940 - Verstopt

    \n", "
    \n", " \n", " \n", "
    \n", "

    -930 - -930 - Beschadigd/defekt

    \n", "
    \n", " \n", " \n", "
    \n", "

    -920 - -920 - Bevroren

    \n", "
    \n", " \n", " \n", "
    \n", "

    -910 - -910 - droog

    \n", "
    \n", " \n", " \n", "
    \n", "

    -905 - -905 - \"Geen meting (onbereikbaar)

    \n", "
    \n", " \n", " \n", "
    \n", "

    -903 - -903 - Afgesloten van het net (VMW)

    \n", "
    \n", " \n", " \n", "
    \n", "

    -902 - -902 - Vee in de weide (VMW)

    \n", "
    \n", " \n", " \n", "
    \n", "

    -901 - -901 - Werken aan de put (VMW)

    \n", "
    \n", " \n", " \n", "
    \n", "

    -900 - -900 - Geen waarneming

    \n", "
    \n", " \n", " \n", "
    \n", "

    1 - 1 - normaal

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

mv_mtaw - Maaiveldhoogte in mTAW op dag dat de put/boring uitgevoerd werd

  • type: float
  • notnull: False
  • query: False
  • cost: 10
  • multivalue: False
\n", "
\n", "

\n", "
\n", " " ], "text/plain": [ "" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.search.grondwaterfilter import GrondwaterFilterSearch\n", "gws = GrondwaterFilterSearch()\n", "gws" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "For example query all data in a bounding box:" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/055] ....c...cc.....c..c...c..........c...........c.cc.\n", "[050/055] .....\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_filterpkey_grondwaterlocatiegw_idfilternummerfiltertypexystart_grondwaterlocatie_mtawmv_mtawgemeente...regimediepte_onderkant_filterlengte_filterdatumtijdstippeil_mtawbetrouwbaarheidmethodefilterstatusfiltertoestand
0https://www.dov.vlaanderen.be/data/filter/2000...https://www.dov.vlaanderen.be/data/put/2018-00...DYLP1621peilfilter170716.0172051.024.4824.48Leuven...onbekend2.180.52000-09-01NaN23.48onbekendpeillintonbekend1.0
1https://www.dov.vlaanderen.be/data/filter/2000...https://www.dov.vlaanderen.be/data/put/2018-00...DYLP1621peilfilter170716.0172051.024.4824.48Leuven...onbekend2.180.52000-09-15NaN23.65onbekendpeillintonbekend1.0
2https://www.dov.vlaanderen.be/data/filter/2000...https://www.dov.vlaanderen.be/data/put/2018-00...DYLP1621peilfilter170716.0172051.024.4824.48Leuven...onbekend2.180.52000-09-27NaN23.67onbekendpeillintonbekend1.0
3https://www.dov.vlaanderen.be/data/filter/2000...https://www.dov.vlaanderen.be/data/put/2018-00...DYLP1621peilfilter170716.0172051.024.4824.48Leuven...onbekend2.180.52000-10-09NaN23.73onbekendpeillintonbekend1.0
4https://www.dov.vlaanderen.be/data/filter/2000...https://www.dov.vlaanderen.be/data/put/2018-00...DYLP1621peilfilter170716.0172051.024.4824.48Leuven...onbekend2.180.52000-10-18NaN23.77onbekendpeillintonbekend1.0
\n", "

5 rows × 23 columns

\n", "
" ], "text/plain": [ " pkey_filter \\\n", "0 https://www.dov.vlaanderen.be/data/filter/2000... \n", "1 https://www.dov.vlaanderen.be/data/filter/2000... \n", "2 https://www.dov.vlaanderen.be/data/filter/2000... \n", "3 https://www.dov.vlaanderen.be/data/filter/2000... \n", "4 https://www.dov.vlaanderen.be/data/filter/2000... \n", "\n", " pkey_grondwaterlocatie gw_id filternummer \\\n", "0 https://www.dov.vlaanderen.be/data/put/2018-00... DYLP162 1 \n", "1 https://www.dov.vlaanderen.be/data/put/2018-00... DYLP162 1 \n", "2 https://www.dov.vlaanderen.be/data/put/2018-00... DYLP162 1 \n", "3 https://www.dov.vlaanderen.be/data/put/2018-00... DYLP162 1 \n", "4 https://www.dov.vlaanderen.be/data/put/2018-00... DYLP162 1 \n", "\n", " filtertype x y start_grondwaterlocatie_mtaw mv_mtaw \\\n", "0 peilfilter 170716.0 172051.0 24.48 24.48 \n", "1 peilfilter 170716.0 172051.0 24.48 24.48 \n", "2 peilfilter 170716.0 172051.0 24.48 24.48 \n", "3 peilfilter 170716.0 172051.0 24.48 24.48 \n", "4 peilfilter 170716.0 172051.0 24.48 24.48 \n", "\n", " gemeente ... regime diepte_onderkant_filter lengte_filter datum \\\n", "0 Leuven ... onbekend 2.18 0.5 2000-09-01 \n", "1 Leuven ... onbekend 2.18 0.5 2000-09-15 \n", "2 Leuven ... onbekend 2.18 0.5 2000-09-27 \n", "3 Leuven ... onbekend 2.18 0.5 2000-10-09 \n", "4 Leuven ... onbekend 2.18 0.5 2000-10-18 \n", "\n", " tijdstip peil_mtaw betrouwbaarheid methode filterstatus filtertoestand \n", "0 NaN 23.48 onbekend peillint onbekend 1.0 \n", "1 NaN 23.65 onbekend peillint onbekend 1.0 \n", "2 NaN 23.67 onbekend peillint onbekend 1.0 \n", "3 NaN 23.73 onbekend peillint onbekend 1.0 \n", "4 NaN 23.77 onbekend peillint onbekend 1.0 \n", "\n", "[5 rows x 23 columns]" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "location = Within(Box(170000, 171000, 173000, 174000, epsg=31370))\n", "df = gws.search(location=location)\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "One important difference is the presence of time-related data. More specifically the attributes `datum` and `tijdstip`. These can be combined to create a date.datetime object that can be used in the subsequent manipuliation of the Pandas DataFrame. Make sure to **remove** the records without a valid `datum` and **fill** the empty `tijdstip` fields with a default timestamp (!)" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 2000-09-01\n", "1 2000-09-15\n", "2 2000-09-27\n", "3 2000-10-09\n", "4 2000-10-18\n", "Name: tijd, dtype: datetime64[ns]" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "df.reset_index(inplace=True)\n", "df = df.loc[~df.datum.isna()]\n", "df['tijdstip'] = df.tijdstip.fillna('00:00:00')\n", "df['tijd'] = pd.to_datetime(df.datum.astype(str) + ' ' + df.tijdstip.astype(str))\n", "df.tijd.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "More examples for the timeseries processing and analysis is available in the Notebooks of pydov." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Data cache" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Notice the cc in the progress bar while loading of the data? It means the data was loaded from your local cache instead of being downloaded, as it was already part of an earlier data request. See the [caching documentation](https://pydov.readthedocs.io/en/stable/caching.html#caching) for more in-depth information about the default directory, how to change and/or clean it, and even how to create some custom cache format." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Putting it all together" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/001] c\n", "[000/001] .\n", "[000/002] cc\n", "[000/001] .\n", "[000/010] cccccccccc\n" ] } ], "source": [ "# imports\n", "import pandas as pd\n", "import pydov\n", "from pydov.util.location import WithinDistance, Point\n", "from pydov.util.query import Join\n", "from pydov.search.interpretaties import LithologischeBeschrijvingenSearch\n", "from pydov.search.interpretaties import HydrogeologischeStratigrafieSearch\n", "from pydov.search.grondwaterfilter import GrondwaterFilterSearch\n", "from owslib.fes2 import PropertyIsEqualTo\n", "\n", "# define search objects\n", "hs = HydrogeologischeStratigrafieSearch()\n", "ls = LithologischeBeschrijvingenSearch()\n", "gws = GrondwaterFilterSearch()\n", "\n", "# search hydrostratigraphic interpretations based on location\n", "location = WithinDistance(\n", " Point(171500, 172500, epsg=31370), \n", " 500,\n", " distance_unit='meter'\n", " )\n", "dfhs = hs.search(location=location)\n", "\n", "# join the lithostratigraphic desriptions\n", "dfls = ls.search(query=Join(dfhs, 'pkey_boring'))\n", "df_joined = pd.merge(dfhs, dfls.loc[:, ['pkey_boring','diepte_laag_van', 'diepte_laag_tot', 'beschrijving']], \n", " how='left', \n", " left_on=['pkey_boring','diepte_laag_van', 'diepte_laag_tot'], \n", " right_on = ['pkey_boring','diepte_laag_van', 'diepte_laag_tot']\n", " )\n", "\n", "# search the groundwater head data in the neighbourhoud\n", "dfgw = gws.search(location=location)\n", "\n", "# create date.datetime objects for further processing\n", "dfgw.reset_index(inplace=True)\n", "dfgw = dfgw.loc[~dfgw.datum.isna()]\n", "dfgw['tijdstip'] = dfgw.tijdstip.fillna('00:00:00')\n", "dfgw['tijd'] = pd.to_datetime(dfgw.datum.astype(str) + ' ' + dfgw.tijdstip.astype(str))" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totaquiferbeschrijving
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.390.00.60110aangevulde grond
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.390.614.40100NaN
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.3914.495.10000Brusseliaan - Ieperiaan en Landeniaan
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.3995.1118.91100Krijt
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...goed171548.77172680.9226.39118.9124.51300Primair
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "2 https://www.dov.vlaanderen.be/data/interpretat... \n", "3 https://www.dov.vlaanderen.be/data/interpretat... \n", "4 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1974... \n", "1 https://www.dov.vlaanderen.be/data/boring/1974... \n", "2 https://www.dov.vlaanderen.be/data/boring/1974... \n", "3 https://www.dov.vlaanderen.be/data/boring/1974... \n", "4 https://www.dov.vlaanderen.be/data/boring/1974... \n", "\n", " betrouwbaarheid_interpretatie x y \\\n", "0 goed 171548.77 172680.92 \n", "1 goed 171548.77 172680.92 \n", "2 goed 171548.77 172680.92 \n", "3 goed 171548.77 172680.92 \n", "4 goed 171548.77 172680.92 \n", "\n", " start_interpretatie_mtaw diepte_laag_van diepte_laag_tot aquifer \\\n", "0 26.39 0.0 0.6 0110 \n", "1 26.39 0.6 14.4 0100 \n", "2 26.39 14.4 95.1 0000 \n", "3 26.39 95.1 118.9 1100 \n", "4 26.39 118.9 124.5 1300 \n", "\n", " beschrijving \n", "0 aangevulde grond \n", "1 NaN \n", "2 Brusseliaan - Ieperiaan en Landeniaan \n", "3 Krijt \n", "4 Primair " ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_joined.head()" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
indexpkey_filterpkey_grondwaterlocatiegw_idfilternummerfiltertypexystart_grondwaterlocatie_mtawmv_mtaw...diepte_onderkant_filterlengte_filterdatumtijdstippeil_mtawbetrouwbaarheidmethodefilterstatusfiltertoestandtijd
00https://www.dov.vlaanderen.be/data/filter/1974...https://www.dov.vlaanderen.be/data/put/2017-00...2-00051peilfilter171548.77172680.9226.3926.39...118.9531.51984-01-2600:00:0012.53goedpeillintin rust1.01984-01-26
11https://www.dov.vlaanderen.be/data/filter/1974...https://www.dov.vlaanderen.be/data/put/2017-00...2-00051peilfilter171548.77172680.9226.3926.39...118.9531.51984-09-3000:00:0012.53goedpeillintin rust1.01984-09-30
22https://www.dov.vlaanderen.be/data/filter/1974...https://www.dov.vlaanderen.be/data/put/2017-00...2-00051peilfilter171548.77172680.9226.3926.39...118.9531.51985-11-0100:00:0011.57goedpeillintin rust1.01985-11-01
33https://www.dov.vlaanderen.be/data/filter/1974...https://www.dov.vlaanderen.be/data/put/2017-00...2-00051peilfilter171548.77172680.9226.3926.39...118.9531.51986-04-0400:00:0011.28goedpeillintin rust1.01986-04-04
44https://www.dov.vlaanderen.be/data/filter/1974...https://www.dov.vlaanderen.be/data/put/2017-00...2-00051peilfilter171548.77172680.9226.3926.39...118.9531.51986-10-0100:00:0010.86goedpeillintin rust1.01986-10-01
\n", "

5 rows × 25 columns

\n", "
" ], "text/plain": [ " index pkey_filter \\\n", "0 0 https://www.dov.vlaanderen.be/data/filter/1974... \n", "1 1 https://www.dov.vlaanderen.be/data/filter/1974... \n", "2 2 https://www.dov.vlaanderen.be/data/filter/1974... \n", "3 3 https://www.dov.vlaanderen.be/data/filter/1974... \n", "4 4 https://www.dov.vlaanderen.be/data/filter/1974... \n", "\n", " pkey_grondwaterlocatie gw_id filternummer \\\n", "0 https://www.dov.vlaanderen.be/data/put/2017-00... 2-0005 1 \n", "1 https://www.dov.vlaanderen.be/data/put/2017-00... 2-0005 1 \n", "2 https://www.dov.vlaanderen.be/data/put/2017-00... 2-0005 1 \n", "3 https://www.dov.vlaanderen.be/data/put/2017-00... 2-0005 1 \n", "4 https://www.dov.vlaanderen.be/data/put/2017-00... 2-0005 1 \n", "\n", " filtertype x y start_grondwaterlocatie_mtaw mv_mtaw \\\n", "0 peilfilter 171548.77 172680.92 26.39 26.39 \n", "1 peilfilter 171548.77 172680.92 26.39 26.39 \n", "2 peilfilter 171548.77 172680.92 26.39 26.39 \n", "3 peilfilter 171548.77 172680.92 26.39 26.39 \n", "4 peilfilter 171548.77 172680.92 26.39 26.39 \n", "\n", " ... diepte_onderkant_filter lengte_filter datum tijdstip peil_mtaw \\\n", "0 ... 118.95 31.5 1984-01-26 00:00:00 12.53 \n", "1 ... 118.95 31.5 1984-09-30 00:00:00 12.53 \n", "2 ... 118.95 31.5 1985-11-01 00:00:00 11.57 \n", "3 ... 118.95 31.5 1986-04-04 00:00:00 11.28 \n", "4 ... 118.95 31.5 1986-10-01 00:00:00 10.86 \n", "\n", " betrouwbaarheid methode filterstatus filtertoestand tijd \n", "0 goed peillint in rust 1.0 1984-01-26 \n", "1 goed peillint in rust 1.0 1984-09-30 \n", "2 goed peillint in rust 1.0 1985-11-01 \n", "3 goed peillint in rust 1.0 1986-04-04 \n", "4 goed peillint in rust 1.0 1986-10-01 \n", "\n", "[5 rows x 25 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfgw.head()" ] } ], "metadata": { "kernelspec": { "display_name": ".venv (3.13.5)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.13.5" } }, "nbformat": 4, "nbformat_minor": 4 }