{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Example of DOV search methods for quartaire stratigrafie" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "[![Binder](https://mybinder.org/badge_logo.svg)](https://mybinder.org/v2/gh/DOV-Vlaanderen/pydov/master?filepath=docs%2Fnotebooks%2Fsearch_quartaire_stratigrafie.ipynb)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Use cases:\n", "* Select records in a bbox\n", "* Select records in a bbox with selected properties\n", "* Select records within a distance from a point\n", "* Select records in a municipality\n", "* Get records using info from wfs fields, not available in the standard output dataframe" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import os, sys\n", "import inspect" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "# check pydov path\n", "import pydov" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Get information about code base" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'De quartaire afzettingen in Vlaanderen, de jongste afzettingen, zijn lateraal en verticaal heterogeen en varieren erg in dikte. De afzettingen zijn vooral onder continentale omstandigheden tot stand gekomen (rivier-, duinafzettingen). Eigenlijk zijn het pakketten die zelden meer dan 30 meter en soms zelfs minder dan 1 meter dik zijn. Omwille van deze grote eigenheid en de grote mate van detail van de beschrijvingen, werd hiervoor een eigen stratigrafische codering uitgewerkt voor Vlaanderen.'" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.search.interpretaties import QuartairStratigrafieSearch\n", "# information about the QuartairStratigrafie type (In Dutch):\n", "ip_quart = QuartairStratigrafieSearch()\n", "ip_quart.get_description()" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "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", "lid1\n", "relatie_lid1_lid2\n", "lid2\n" ] } ], "source": [ "# information about the available fields for a QuartairStratigrafie object\n", "fields = ip_quart.get_fields()\n", "# print available fields\n", "for f in fields.values():\n", " print(f['name'])" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", "
\n", "

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

\n", "
\n", " " ], "text/plain": [ "{'name': 'Type_proef', 'definition': \"Het type van de proef waarvan de quartaire stratigrafie een interpretatie is. Bij een quartaire stratigrafie zal dit altijd 'Boring' zijn.\", 'type': 'string', 'multivalue': False, 'notnull': False, 'query': True, 'cost': 1, 'codelist': >}" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# print information for a certain field\n", "fields['Type_proef']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The cost is an arbitrary attribute to indicate if the information is retrieved from a wfs query (cost = 1), \n", "or from an xml (cost = 10)\n", "\n", "Alternatively, you can list all the fields and their details by inspecting the `get_fields()` output or the search instance itself in a notebook:" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", "
\n", " \n", "
\n", " pydov.search.interpretaties.QuartairStratigrafieSearch\n", "
\n", "

De quartaire afzettingen in Vlaanderen, de jongste afzettingen, zijn lateraal en verticaal heterogeen en varieren erg in dikte. De afzettingen zijn vooral onder continentale omstandigheden tot stand gekomen (rivier-, duinafzettingen). Eigenlijk zijn het pakketten die zelden meer dan 30 meter en soms zelfs minder dan 1 meter dik zijn. Omwille van deze grote eigenheid en de grote mate van detail van de beschrijvingen, werd hiervoor een eigen stratigrafische codering uitgewerkt voor Vlaanderen.

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

pkey_interpretatie - URL die verwijst naar de gegevens van deze quartaire 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 quartaire stratigrafie een interpretatie is. Bij een quartaire 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 quartaire stratigrafie is een interpretatie van een boring.

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

Proefnummer - Het proefnummer van de boring waarvan de quartaire 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 - De maximumdiepte van de quartaire stratigrafie in meter. Dit is de 'tot' van de diepste geïnterpreteerde laag.

  • 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 quartaire stratigrafie.

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

Datum - De datum waarop de quartaire stratigrafie werd beschreven.

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

Opdrachten - De opdracht(en) waaraan de quartaire 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 quartaire 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 quartaire 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 quartaire 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 quartairstratigrafie 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 quartairstratigrafie in meter

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

lid1 - eerste eenheid van de laag quartairstratigrafie

  • 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", "

    ! - ! - Aanvulling-allerlei

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

    # - # - Herwerkt tertiair

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

    $ - $ - Tertiair

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

    << - << - Grind (Maas en Rijn, Eisden-Lanklaar)-fluviatiel

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

    ? - ? - Kleiig tot grindrijk facies (Maas en Rijn, Leut)-fluviatiel

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

    A - A - Zandig facies-eolisch

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

    A01 - A01 - Aangebracht, antropogeen - /-/

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

    B - B - Holoceen, Pleistoceen continentaal alluvium-grof facies

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

    C - C - Eemiaan continentaal-grof facies

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

    D - D - Weichseliaan continentaal eolisch-grof facies

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

    D01 - D01 - Zandig facies - Diachroon-Niet gedefinieerd

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

    D02 - D02 - Grindrijk facies - Diachroon-Niet gedefinieerd

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

    D03 - D03 - Silteus tot kleiig facies - Diachroon-Niet gedefinieerd

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

    D04 - D04 - Niet gedifferentieerd - Diachroon-Niet gedefinieerd

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

    D1 - D1 - Zandige facies op kleiig facies-fluviatiel, hellingsprocessen

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

    E - E - Eemiaan, marien-grof facies

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

    E01 - E01 - Klei en/of zand over de gehele sequentie en bedekt met eolische afzettingen - Holoceen-Eolisch, marien

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

    E02 - E02 - Klei en/of zand over de gehele sequentie en bedekt met een veenlaag direct onder de eolische afzettingen - Holoceen-Eolisch, marien

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

    E03 - E03 - Zand - Tardiglaciaal en/of Holoceen-Eolisch

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

    E04 - E04 - Zandig facies - Laat-Pleniglaciaal (Weichselien) en/of Vroeg-Holoceen-Eolisch

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

    E05 - E05 - Silteus facies - Laat-Pleniglaciaal (Weichselien) en/of Vroeg-Holoceen-Eolisch

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

    E06 - E06 - Zandig facies - Weichselien-Eolisch

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

    E07 - E07 - Zand tot zandleem met mogelijks in het basisgedeelte een alternatie van fijnere en grovere laagjes - Weichselien-Eolisch (dominant), hellingsprocessen

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

    E08 - E08 - Silt (loess) - Weichselien-Eolisch

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

    E09 - E09 - Homogeen silt gevolgd door silt met intercalaties van kleiige, venige en/of zandige laagjes - Weichselien-Eolisch , hellingsprocessen

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

    E10 - E10 - Lichte zandleem tot silt - Weichselien-Eolisch (dominant), lokale herwerking

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

    E11 - E11 - Zandig facies - Saalien en/of Weichselien-Eolisch

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

    E12 - E12 - Homogene silt en silt met intercalaties van kleiige en zandige laagjes - Saalien en/of Weichselien-Eolisch, hellingsprocessen

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

    ES01 - ES01 - Niet gedifferentieerd facies (zandig tot kleiig) - Holoceen-Estuarien

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

    ES02 - ES02 - Dominant zandige facies - Holoceen-Perimarien

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

    ES03 - ES03 - Dominant kleiig facies - Holoceen-Perimarien

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

    ES04 - ES04 - Dominant zandig facies, mogelijks schelprijk - Eemien-Getijdenomgeving (Marien en/of estuarien)

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

    ES05 - ES05 - Zandig/ kleiig – silteus complex - Eemien-Getijdenomgeving (Marien en/of estuarien)

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

    ES06 - ES06 - Niet gedifferentieerd facies, mogelijks veen - Eemien-Estuarien overgaand naar fluviatiel

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

    ES07 - ES07 - Zandig/kleiig complex - Midden-Pleistoceen-Getijdenomgeving

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

    ES08 - ES08 - Kleiig/zandig complex - Vroeg-Pleistoceen - Tertiair (1,2)-Estuarien (dominant), fluviatiel en eolisch

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

    ES09 - ES09 - Kleiig/zandig complex (Lid van Turnhout) - Vroeg- Pleistoceen – Tertiair (1)-Estuarien

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

    ES10 - ES10 - Kleiig/zandig complex (Lid van Rijkevorsel) - Vroeg-Pleistoceen – Tertiair (1)-Estuarien

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

    ES11 - ES11 - Dominant zandig complex - Vroeg-Pleistoceen –Tertiair (2)-Estuarien (dominant), fluviatiel

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

    ES12 - ES12 - Zandig complex - Vroeg-Pleistoceen –Tertiair (2)-Estuarien

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

    ES13 - ES13 - Zandig complex - Plio-Pleistoceen-Getijdenomgeving

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

    F - F - Weichseliaan, continentaal, fluviatiel, periglaciaal-grof facies

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

    F' - F' - Niet gedifferentieerd facies-fluviatiel

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

    F01 - F01 - Zandige facies, mogelijks vegetatieresten - Holoceen-Fluviatiel, hellingsprocessen

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

    F02 - F02 - Zandig facies op kleiig facies - Holoceen-Fluviatiel, hellingsprocessen

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

    F03 - F03 - Kleiig facies - Holoceen-Fluviatiel, hellingsprocessen

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

    F04 - F04 - Kleiig facies op zandig facies - Holoceen-Fluviatiel, hellingsprocessen

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

    F05 - F05 - Kleiig tot grindrijk facies (Maas en Rijn, Leut) - Holoceen-Fluviatiel

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

    F06 - F06 - Zandig facies - Tardiglaciaal tot Vroeg-Holoceen-Fluviatiel

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

    F07 - F07 - Lemig zandfacies tot kleiig facies - Tardiglaciaal tot Vroeg-Holoceen-Fluviatiel

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

    F08 - F08 - Dominant zandig facies - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F09 - F09 - Grind tot grindrijk zandig facies - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F1 - F1 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    F10 - F10 - Silteus tot kleiig facies, veen en kalktuf mogelijks aanwezig - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F11 - F11 - Niet gedifferentieerd facies, veen en kalktuf mogelijks aanwezig - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F12 - F12 - Dominant grind, zand (Maas en Rijn, Geistingen) - Laat-Weichselien-Fluviatiel

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

    F13 - F13 - Dominant zandig facies op dominant silteus facies - Weichselien-Fluviatiel

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

    F14 - F14 - Grind facies (Maas en Rijn, Mechelen a/d Maas) - Weichselien-Fluviatiel

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

    F15 - F15 - Dominant zandig facies op dominant silteus facies op dominant zandig facies - Weichselien-Fluviatiel

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

    F16 - F16 - Dominant zandig facies op dominant silteus facies op dominant zandig facies op dominant silteus facies - Weichselien-Fluviatiel

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

    F17 - F17 - Dominant silteus facies - Weichselien-Fluviatiel

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

    F18 - F18 - Fining-up cyclus (cycli), mogelijks met veen - Weichselien-Fluviatiel

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

    F19 - F19 - Niet gedifferentieerd fijn klastisch facies - Weichselien-Fluviatiel

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

    F2 - F2 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    F20 - F20 - Dominant silteus facies op dominant zandig facies - Weichselien-Fluviatiel

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

    F21 - F21 - Dominant silteus facies op dominant zandig facies op dominant silteus facies - Weichselien-Fluviatiel

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

    F22 - F22 - Dominant silteus facies op dominant zandig facies op dominant silteus facies op dominant zandig facies - Weichselien-Fluviatiel

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

    F23 - F23 - Dominant zandig facies - Weichselien-Fluviatiel

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

    F24 - F24 - Dominant silteus facies - Weichselien-Fluviatiel

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

    F25 - F25 - Dominant zandig facies - Weichselien-Fluviatiel

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

    F26 - F26 - Grindhoudend en grindrijk zand tot grind - Weichselien-Fluviatiel

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

    F27 - F27 - Klei tot kleiig zand - Weichselien-Fluvio-lacustrien

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

    F28 - F28 - Niet gedifferentieerd facies - Eemien en/of Weichselien-Fluviatiel

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

    F29 - F29 - Silteus tot kleiig facies, mogelijks met veen - Eemien-Fluviatiel

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

    F3 - F3 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    F30 - F30 - Fining – up cyclus, mogelijks met veen - Eemien-Fluviatiel

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

    F31 - F31 - Zandig facies - Saalien-Fluviatiel

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

    F32 - F32 - Niet gedifferentieerd facies - Saalien-Fluviatiel

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

    F33 - F33 - Grind (Maas en Rijn, Eisden-Lanklaar) - Saalien-Fluviatiel

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

    F34 - F34 - Grind facies (Maas en Rijn, Lanklaar) - Saalien tot en met Weichselien-Fluviatiel

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

    F35 - F35 - Fining-up sequentie (Schelde) - Holsteinien-Fluviatiel

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

    F36 - F36 - Grindrijk facies - Midden- en/of Laat-Pleistoceen-Fluviatiel

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

    F37 - F37 - Dominant zandig facies - Midden- en/of Laat-Pleistoceen-Fluviatiel

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

    F38 - F38 - Niet gedifferentieerd facies - Midden- en/of Laat-Pleistoceen-Fluviatiel

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

    F39 - F39 - Grind facies (Maas en Rijn, Zutendaal) - Midden-Pleistoceen-Fluviatiel

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

    F40 - F40 - Grind facies (Maas en Rijn, Mopertingen of Lanaken) - Midden-Pleistoceen-Fluviatiel

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

    F41 - F41 - Zandig complex met venige-humeuze en kleiige-silteuze lagen - Vroeg-Pleistoceen-Fluviatiel

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

    F42 - F42 - Zand- en grindfacies (Maas en Rijn, Lommel) - Vroeg-Pleistoceen, post-Jaromillo-Fluviatiel

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

    F43 - F43 - Zand- en grindfacies (Maas en Rijn, Bocholt) - Vroeg-Pleistoceen, post-Jaromillo-Fluviatiel

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

    F44 - F44 - Zand- en grindfacies (Maas en Rijn, Winterslag) - Vroeg-Pleistoceen, post-Jaromillo-Fluviatiel

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

    F45 - F45 - Grindfacies (Maas en Rijn, Lixhe) - Vroeg-Pleistoceen, pré-Jaromillo-Fluviatiel

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

    F46 - F46 - Dominant zandig facies met bodemhorizonten en veenlagen (Lid van Beerse) - Vroeg-Pleistoceen – Tertiair (1)-Fluviatiel en/of eolisch

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

    F47 - F47 - Dominant zandig facies - Vroeg-Pleistoceen –Tertiair (2)-Fluviatiel

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

    F48 - F48 - Grindfacies (Maas en Rijn, Simpelveld) - Vroeg-Pleistoceen –Tertiair (4)-Fluviatiel

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

    F49 - F49 - Zandig facies tot grindfacies (Schelde) - Vroeg- en/of Midden-Pleistoceen – Tertiair (3)-Fluviatiel

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

    F50 - F50 - Herwerkte Rijn- en Maasafzettingen - Pleistoceen-Lokale herwerking (dominant fluviatiel)

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

    F51 - F51 - Zand, soms grind - Pleistoceen-Fluviatiel (dominant), eolisch

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

    F52 - F52 - Fijn zand tot klei - Pleistoceen-Fluviatiel, mogelijks eolisch - lacustrien

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

    G - G - Weichseliaan, continentaal, niveo-eolisch, fluviatiel-grof facies

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

    Gb - Gb - Beekbodemgrind

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

    Gh - Gh - Hellingsgrind

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

    Gk - Gk - Grind

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

    Gt - Gt - Grind

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

    Gv - Gv - Valleibodemgrind

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

    H - H - Diachrone hellingsafzetting

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

    H' - H' - Niet gedifferentieerd grofkorrelig facies-hellingsprocessen

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

    H01 - H01 - Zandig facies - Diachroon-Hellingsprocessen

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

    H02 - H02 - Grindrijk facies - Diachroon-Hellingsprocessen

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

    H03 - H03 - Niet gedifferentieerd grofkorrelig facies - Diachroon-Hellingsprocessen

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

    H04 - H04 - Silteus tot kleiig facies - Diachroon-Hellingsprocessen

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

    H05 - H05 - Niet gedifferentieerd facies - Diachroon-Hellingsprocessen

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

    H06 - H06 - Silteus tot kleiig facies - Tardiglaciaal en/of Holoceen-Hellingsprocessen

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

    H07 - H07 - Niet gedifferentieerd facies - Tardiglaciaal en/of Holoceen-Hellingsprocessen

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

    H08 - H08 - Silt met intercalaties van kleiige, venige en/of zandige laagjes - Weichselien-Hellingsprocessen (dominant), eolisch

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

    HW01 - HW01 - Herwerkte Tertiaire afzettingen - Tertiair en/of Quartair-Lokale herwerking (proces niet gedifferentieerd)

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

    HW02 - HW02 - Herwerkte afzettingen - /-Lokale herwerking (proces niet gedifferentieerd)

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

    K - K - Holoceen, continentaal alluvium-grof facies

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

    K1 - K1 - Holoceen, continentaal alluvium

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

    K2 - K2 - Holoceen, continentaal alluvium

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

    M - M - Holoceen, marien-grof facies

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

    M01 - M01 - Klei en/of zand , geulopvulling over gehele sequentie - Laat-Holoceen-Marien

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

    M02 - M02 - Niet gedifferentieerd klastisch facies, veen, mogelijks kalkgyttja. - Holoceen-Marien

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

    M03 - M03 - Klei en/of zand over de gehele sequentie zonder veenlagen - Holoceen-Marien

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

    M04 - M04 - Klei en/of zand met aan de basis het basisveen - Holoceen-Marien

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

    M05 - M05 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag - Holoceen-Marien

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

    M06 - M06 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag en aan de basis het basisveen - Holoceen-Marien

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

    M07 - M07 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen en aan de basis het basisveen - Holoceen-Marien

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

    M08 - M08 - Afwisseling van klei en/of zand met een dunne veenlaag aan het oppervlak en aan de basis het basisveen - Holoceen-Marien

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

    M09 - M09 - Veen en/of organisch gyttja over de gehele sequentie met aan de top een klei- of zandlaag waarvan de dikte kleiner is dan de dikte van de veenlaag - Holoceen-Marien

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

    M10 - M10 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen en aan de basis het basisveen. Mogelijks veen aan het oppervlak - Holoceen-Marien

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

    M11 - M11 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen - Holoceen-Marien

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

    M12 - M12 - Dominant zandig facies - Holoceen-Marien

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

    M13 - M13 - Dominant kleiig facies - Holoceen-Marien

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

    M14 - M14 - Dominant kleiig facies - Eemien-Marien

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

    N - N - Weichseliaan, continentaal, niveo-eolisch-grof facies

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

    O - O - Niet gedifferentieerd klastisch facies, veen, mogelijks kalkgyttja-marien

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

    ON01 - ON01 - Onbekend - /-/

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

    P - P - Dominant zandige facies-perimarien

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

    Q - Q - Kwartair

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

    R - R - Diachroon-restgrind

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

    Rb - Rb - Beekbodemgrind

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

    Rf - Rf - Grindrijk zand - puinwaaier

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

    Rh - Rh - Hellingsgrind

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

    Ru - Ru - Grind

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

    S - S - Saale afzettingen

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

    S' - S' - Niet gedifferentieerd facies-fluviatiel

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

    T01 - T01 - Ondiep Tertiair substraat - Quartair en Tertiair-/

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

    T02 - T02 - Pré-Quartaire sedimenten - /-/

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

    U - U - Onbekend

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

    V' - V' - Venig complex-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel en/of eolisch

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

    V01 - V01 - Venig complex - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V02 - V02 - Veen op kleiig facies - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V03 - V03 - Veen op zandig facies - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V04 - V04 - Veen, kalktuf al dan niet met klastisch materiaal - Tardiglaciaal en/of Holoceen-Dominantie van organo-chemische processen

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

    V05 - V05 - Venig facies (veen al dan niet met klastische sedimenten) - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving

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

    V06 - V06 - Venig complex - Weichselien-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel en/of eolisch

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

    V1 - V1 - Veen op kleiig facies-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V2 - V2 - Veen op zandig facies-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    W1 - W1 - Klei en/of zand over gehele sequentie en bedekt met eolische afzettingen-eolisch, marien

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

    W3 - W3 - Klei en/of zand over de gehele sequentie en bedekt met eolische afzettingen-eolisch, marien

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

    X - X - Saale, continentaal-grof facies

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

    X1 - X1 - Klei en/of zand over de gehele sequentie zonder veenlagen-marien

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

    X11 - X11 - Klei en/of zand, geulopvulling over gehele sequentie-marien

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

    X2 - X2 - Klei en/of zand met aan de basis het basisveen-marien

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

    X3 - X3 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag-marien

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

    X4 - X4 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag en aan de basis het basisveen-marien

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

    Y - Y - Pre-Saale continentaal-grof facies

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

    Y1 - Y1 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen-marien

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

    Y2 - Y2 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen en aan de basis het basisveen-marien

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

    Y4 - Y4 - Afwisseling van klei en/of zand met een dunne veenlaag aan het oppervlak en aan de basis het basisveen-marien

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

    Z - Z - Zand-eolisch

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

    Z3 - Z3 - Veen en/of organisch gyttja over de gehele sequentie met aan de top een klei- of zandlaag waarvan de dikte kleiner is dan de dikte van de veenlaag-marien

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

    [\\]] - [\\]] - Fining-up sequentie (Schelde)-fluviatiel

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

    ^ - ^ - Grind facies (Maas en Rijn, Zutendaal)-fluviatiel

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

    ^F - ^F - Grindhoudend en grindrijk zand tot grind-fluviatiel

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

    ^H - ^H - Grindrijk facies-hellingsprocessen

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

    ^K - ^K - Grind tot grindrijk zandig facies-fluviatiel

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

    ^Q - ^Q - Grindrijk facies-niet gedefinieerd

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

    ^W - ^W - Grindrijk facies-fluviatiel

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

    a - a - Weichseliaan, contineltaal, hellingsafzettingen

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

    a' - a' - Lichte zandleem tot silt-eolisch (dominant), lokale herwerking

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

    b - b - Holoceen, Pleistoceen, continentaal alluvium-fijn facies

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

    c - c - Eemiaan continentaal-fijn facies

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

    c° - c° - Fining-up cyclus, mogelijks met veen-fluviatiel

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

    d - d - Weichseliaan, continentaal, eolisch-fijn facies

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

    d1 - d1 - Kleiig facies op zandig facies-fluviatiel, hellingsprocessen

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

    e - e - Eemiaan, marien-fijn facies

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

    e' - e' - Niet gedifferentieerd facies, mogelijks veen-estuarien overgaand naar fluviatiel

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

    f - f - Weichseliaan, continentaal, fluviatiel, periglaciaal-fijn facies

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

    f' - f' - Niet gedifferentieerd fijn klastisch facies-fluviatiel

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

    f1 - f1 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    f2 - f2 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    f3 - f3 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    f° - f° - Fining-up cyclus (cycli), mogelijks met veen-fluviatiel

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

    g - g - Weichseliaan, continentaal, niveo-eolisch, fluviatiel-fijn facies

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

    h - h - Diachroon-hellingsafzettingen

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

    h' - h' - Niet gedifferentieerd facies-hellingsprocessen

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

    i - i - Zandig/kleiig complex-getijdenomgeving

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

    j - j - Silteus tot kleiig facies-hellingsprocessen

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

    j' - j' - Niet gedifferentieerd facies-hellingsprocessen

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

    k - k - Holoceen, continentaal alluvium-fijn facies

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

    k' - k' - Niet gedifferentieerd facies, veen en kalftuf mogelijks aanwezig-fluviatiel

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

    k1 - k1 - Holoceen, continentaal alluvium

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

    k2 - k2 - Holoceen, continentaal alluvium

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

    l - l - Weichseliaan, continentaal-mergelig-venig

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

    m - m - Holoceen, marien-fijn facies

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

    n - n - Weichseliaan, continentaal, niveo-eolisch-fijn facies

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

    o - o - Holoceen - Pleistoceen overgang-organisch-klastisch complex

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

    p - p - Perimarien

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

    p' - p' - Niet gedifferentieerd facies (zandig tot kleiig)-estuarien

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

    q - q - Silteus tot kleiig facies-niet gedefinieerd

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

    q' - q' - Niet gedifferentieerd-niet gedefinieerd

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

    t - t - Kleiig/zandig complex (Lid van Turnhout)-estuarien

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

    u - u - Kleiig/zandig complex (Lid van Rijkevorsel)-estuarien

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

    v - v - Holoceen, continentaal-venig

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

    v' - v' - Venig complex-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    w - w - Dominant zandig facies-fluviatiel

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

    w' - w' - Niet gedifferentieerd facies-fluviatiel

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

    x - x - Saale continentaal-fijn facies

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

    x' - x' - Dominant zandig facies met bodemhorizonten en veenlagen (Lid van Beerse)-fluviatiel en/of eolisch

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

    y - y - Pré-Saaliaan continentaal-fijn facies

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

    y' - y' - Dominant zandig facies-fluviatiel

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

    z - z - ?

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

    £ - £ - Zand- en grindfacies (Maas en Rijn, Lommel)-fluviatiel

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

    ¥ - ¥ - Grindfacies (Maas en Rijn, Lixhe-fluviatiel

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

    ¦ - ¦ - Kleiig tot grindrijk facies (Maas en Rijn, Leut)-fluviatiel

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

    § - § - Zandig facies tot grindfacies (Schelde)-fluviatiel

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

    © - © - Fijn zand tot klei-fluviatiel, mogelijks eolisch - lacustrien

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

    ® - ® - Zand, soms grind-fluviatiel (dominant), eolisch

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

    µ - µ - Complex van Melle-,

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

    Á - Á - Zand tot zandleem met mogelijks in het basisgedeelte een alternatie van fijnere en grovere laagjes-eolisch (dominant), hellingsprocessen

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

    Æ - Æ - Zandig facies-eolisch

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

    Ç - Ç - Ondiep Tertiair substraat-,

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

    Ø - Ø - Grind facies (Maas en Rijn, Lanklaar)-fluviatiel

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

    Þ - Þ - Zand- en grindfacies (Maas en Rijn, Winterslag)-fluviatiel

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

    ß - ß - Zand- en grindfacies (Maas en Rijn, Bocholt)-fluviatiel

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

    á - á - Klei tot kleiig zand-fluvio-lacustrien

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

    â - â - Homogeen silt gevolgd door silt met intercalaties van kleiige, venige en/of zandige laagjes-fluvio-lacustrien

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

    å - å - Silt met intercalaties van kleiige, venige en/of zandige laagjes-hellingsprocessen (dominant), eolisch

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

    æ - æ - Homogene silt en silt met intercalaties van kleiige en zandige laagjes-eolisch, hellingsprocessen

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

    ç - ç - Herwerkte Tertiaire afzettingen-lokale herwerking (proces niet gedifferentieerd

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

    ç' - ç' - Herwerkte afzettingen-lokale herwerking (proces niet gedifferentieerd

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

    é - é - Zandig/kleiig - silteus complex-getijdenomgeving (Marien en/of estuarien

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

    ô - ô - Holoceen, continentaal eolisch-stuifzand

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

    õ - õ - Holoceen, Pleistoceen, continentaal eolisch-stuifzand

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

    ÿ - ÿ - Zandig complex-estuarien

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

relatie_lid1_lid2 - verbinding of relatie tussen lid1 en lid2 van de laag quartairstratigrafie

  • 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", "

    E - E - en, wordt gebruikt om aan te duiden dat er 2 eenheden geïdentificeerd kunnen worden

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

    O - O - of, wordt gebruikt bij twijfel tussen 2 eenheden in Lid1 en Lid2

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

    T - T - tot, wordt gebruikt om een pakket eenheden aan te duiden van Lid1 tot Lid2

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

lid2 - tweede eenheid van de laag quartairstratigrafie. Indien niet ingevuld wordt default dezelfde waarde als voor Lid1 ingevuld

  • 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", "

    ! - ! - Aanvulling-allerlei

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

    # - # - Herwerkt tertiair

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

    $ - $ - Tertiair

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

    << - << - Grind (Maas en Rijn, Eisden-Lanklaar)-fluviatiel

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

    ? - ? - Kleiig tot grindrijk facies (Maas en Rijn, Leut)-fluviatiel

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

    A - A - Zandig facies-eolisch

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

    A01 - A01 - Aangebracht, antropogeen - /-/

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

    B - B - Holoceen, Pleistoceen continentaal alluvium-grof facies

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

    C - C - Eemiaan continentaal-grof facies

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

    D - D - Weichseliaan continentaal eolisch-grof facies

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

    D01 - D01 - Zandig facies - Diachroon-Niet gedefinieerd

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

    D02 - D02 - Grindrijk facies - Diachroon-Niet gedefinieerd

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

    D03 - D03 - Silteus tot kleiig facies - Diachroon-Niet gedefinieerd

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

    D04 - D04 - Niet gedifferentieerd - Diachroon-Niet gedefinieerd

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

    D1 - D1 - Zandige facies op kleiig facies-fluviatiel, hellingsprocessen

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

    E - E - Eemiaan, marien-grof facies

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

    E01 - E01 - Klei en/of zand over de gehele sequentie en bedekt met eolische afzettingen - Holoceen-Eolisch, marien

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

    E02 - E02 - Klei en/of zand over de gehele sequentie en bedekt met een veenlaag direct onder de eolische afzettingen - Holoceen-Eolisch, marien

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

    E03 - E03 - Zand - Tardiglaciaal en/of Holoceen-Eolisch

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

    E04 - E04 - Zandig facies - Laat-Pleniglaciaal (Weichselien) en/of Vroeg-Holoceen-Eolisch

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

    E05 - E05 - Silteus facies - Laat-Pleniglaciaal (Weichselien) en/of Vroeg-Holoceen-Eolisch

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

    E06 - E06 - Zandig facies - Weichselien-Eolisch

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

    E07 - E07 - Zand tot zandleem met mogelijks in het basisgedeelte een alternatie van fijnere en grovere laagjes - Weichselien-Eolisch (dominant), hellingsprocessen

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

    E08 - E08 - Silt (loess) - Weichselien-Eolisch

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

    E09 - E09 - Homogeen silt gevolgd door silt met intercalaties van kleiige, venige en/of zandige laagjes - Weichselien-Eolisch , hellingsprocessen

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

    E10 - E10 - Lichte zandleem tot silt - Weichselien-Eolisch (dominant), lokale herwerking

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

    E11 - E11 - Zandig facies - Saalien en/of Weichselien-Eolisch

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

    E12 - E12 - Homogene silt en silt met intercalaties van kleiige en zandige laagjes - Saalien en/of Weichselien-Eolisch, hellingsprocessen

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

    ES01 - ES01 - Niet gedifferentieerd facies (zandig tot kleiig) - Holoceen-Estuarien

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

    ES02 - ES02 - Dominant zandige facies - Holoceen-Perimarien

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

    ES03 - ES03 - Dominant kleiig facies - Holoceen-Perimarien

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

    ES04 - ES04 - Dominant zandig facies, mogelijks schelprijk - Eemien-Getijdenomgeving (Marien en/of estuarien)

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

    ES05 - ES05 - Zandig/ kleiig – silteus complex - Eemien-Getijdenomgeving (Marien en/of estuarien)

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

    ES06 - ES06 - Niet gedifferentieerd facies, mogelijks veen - Eemien-Estuarien overgaand naar fluviatiel

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

    ES07 - ES07 - Zandig/kleiig complex - Midden-Pleistoceen-Getijdenomgeving

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

    ES08 - ES08 - Kleiig/zandig complex - Vroeg-Pleistoceen - Tertiair (1,2)-Estuarien (dominant), fluviatiel en eolisch

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

    ES09 - ES09 - Kleiig/zandig complex (Lid van Turnhout) - Vroeg- Pleistoceen – Tertiair (1)-Estuarien

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

    ES10 - ES10 - Kleiig/zandig complex (Lid van Rijkevorsel) - Vroeg-Pleistoceen – Tertiair (1)-Estuarien

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

    ES11 - ES11 - Dominant zandig complex - Vroeg-Pleistoceen –Tertiair (2)-Estuarien (dominant), fluviatiel

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

    ES12 - ES12 - Zandig complex - Vroeg-Pleistoceen –Tertiair (2)-Estuarien

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

    ES13 - ES13 - Zandig complex - Plio-Pleistoceen-Getijdenomgeving

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

    F - F - Weichseliaan, continentaal, fluviatiel, periglaciaal-grof facies

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

    F' - F' - Niet gedifferentieerd facies-fluviatiel

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

    F01 - F01 - Zandige facies, mogelijks vegetatieresten - Holoceen-Fluviatiel, hellingsprocessen

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

    F02 - F02 - Zandig facies op kleiig facies - Holoceen-Fluviatiel, hellingsprocessen

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

    F03 - F03 - Kleiig facies - Holoceen-Fluviatiel, hellingsprocessen

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

    F04 - F04 - Kleiig facies op zandig facies - Holoceen-Fluviatiel, hellingsprocessen

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

    F05 - F05 - Kleiig tot grindrijk facies (Maas en Rijn, Leut) - Holoceen-Fluviatiel

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

    F06 - F06 - Zandig facies - Tardiglaciaal tot Vroeg-Holoceen-Fluviatiel

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

    F07 - F07 - Lemig zandfacies tot kleiig facies - Tardiglaciaal tot Vroeg-Holoceen-Fluviatiel

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

    F08 - F08 - Dominant zandig facies - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F09 - F09 - Grind tot grindrijk zandig facies - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F1 - F1 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    F10 - F10 - Silteus tot kleiig facies, veen en kalktuf mogelijks aanwezig - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F11 - F11 - Niet gedifferentieerd facies, veen en kalktuf mogelijks aanwezig - Tardiglaciaal en/of Holoceen-Fluviatiel

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

    F12 - F12 - Dominant grind, zand (Maas en Rijn, Geistingen) - Laat-Weichselien-Fluviatiel

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

    F13 - F13 - Dominant zandig facies op dominant silteus facies - Weichselien-Fluviatiel

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

    F14 - F14 - Grind facies (Maas en Rijn, Mechelen a/d Maas) - Weichselien-Fluviatiel

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

    F15 - F15 - Dominant zandig facies op dominant silteus facies op dominant zandig facies - Weichselien-Fluviatiel

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

    F16 - F16 - Dominant zandig facies op dominant silteus facies op dominant zandig facies op dominant silteus facies - Weichselien-Fluviatiel

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

    F17 - F17 - Dominant silteus facies - Weichselien-Fluviatiel

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

    F18 - F18 - Fining-up cyclus (cycli), mogelijks met veen - Weichselien-Fluviatiel

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

    F19 - F19 - Niet gedifferentieerd fijn klastisch facies - Weichselien-Fluviatiel

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

    F2 - F2 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    F20 - F20 - Dominant silteus facies op dominant zandig facies - Weichselien-Fluviatiel

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

    F21 - F21 - Dominant silteus facies op dominant zandig facies op dominant silteus facies - Weichselien-Fluviatiel

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

    F22 - F22 - Dominant silteus facies op dominant zandig facies op dominant silteus facies op dominant zandig facies - Weichselien-Fluviatiel

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

    F23 - F23 - Dominant zandig facies - Weichselien-Fluviatiel

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

    F24 - F24 - Dominant silteus facies - Weichselien-Fluviatiel

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

    F25 - F25 - Dominant zandig facies - Weichselien-Fluviatiel

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

    F26 - F26 - Grindhoudend en grindrijk zand tot grind - Weichselien-Fluviatiel

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

    F27 - F27 - Klei tot kleiig zand - Weichselien-Fluvio-lacustrien

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

    F28 - F28 - Niet gedifferentieerd facies - Eemien en/of Weichselien-Fluviatiel

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

    F29 - F29 - Silteus tot kleiig facies, mogelijks met veen - Eemien-Fluviatiel

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

    F3 - F3 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    F30 - F30 - Fining – up cyclus, mogelijks met veen - Eemien-Fluviatiel

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

    F31 - F31 - Zandig facies - Saalien-Fluviatiel

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

    F32 - F32 - Niet gedifferentieerd facies - Saalien-Fluviatiel

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

    F33 - F33 - Grind (Maas en Rijn, Eisden-Lanklaar) - Saalien-Fluviatiel

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

    F34 - F34 - Grind facies (Maas en Rijn, Lanklaar) - Saalien tot en met Weichselien-Fluviatiel

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

    F35 - F35 - Fining-up sequentie (Schelde) - Holsteinien-Fluviatiel

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

    F36 - F36 - Grindrijk facies - Midden- en/of Laat-Pleistoceen-Fluviatiel

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

    F37 - F37 - Dominant zandig facies - Midden- en/of Laat-Pleistoceen-Fluviatiel

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

    F38 - F38 - Niet gedifferentieerd facies - Midden- en/of Laat-Pleistoceen-Fluviatiel

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

    F39 - F39 - Grind facies (Maas en Rijn, Zutendaal) - Midden-Pleistoceen-Fluviatiel

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

    F40 - F40 - Grind facies (Maas en Rijn, Mopertingen of Lanaken) - Midden-Pleistoceen-Fluviatiel

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

    F41 - F41 - Zandig complex met venige-humeuze en kleiige-silteuze lagen - Vroeg-Pleistoceen-Fluviatiel

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

    F42 - F42 - Zand- en grindfacies (Maas en Rijn, Lommel) - Vroeg-Pleistoceen, post-Jaromillo-Fluviatiel

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

    F43 - F43 - Zand- en grindfacies (Maas en Rijn, Bocholt) - Vroeg-Pleistoceen, post-Jaromillo-Fluviatiel

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

    F44 - F44 - Zand- en grindfacies (Maas en Rijn, Winterslag) - Vroeg-Pleistoceen, post-Jaromillo-Fluviatiel

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

    F45 - F45 - Grindfacies (Maas en Rijn, Lixhe) - Vroeg-Pleistoceen, pré-Jaromillo-Fluviatiel

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

    F46 - F46 - Dominant zandig facies met bodemhorizonten en veenlagen (Lid van Beerse) - Vroeg-Pleistoceen – Tertiair (1)-Fluviatiel en/of eolisch

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

    F47 - F47 - Dominant zandig facies - Vroeg-Pleistoceen –Tertiair (2)-Fluviatiel

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

    F48 - F48 - Grindfacies (Maas en Rijn, Simpelveld) - Vroeg-Pleistoceen –Tertiair (4)-Fluviatiel

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

    F49 - F49 - Zandig facies tot grindfacies (Schelde) - Vroeg- en/of Midden-Pleistoceen – Tertiair (3)-Fluviatiel

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

    F50 - F50 - Herwerkte Rijn- en Maasafzettingen - Pleistoceen-Lokale herwerking (dominant fluviatiel)

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

    F51 - F51 - Zand, soms grind - Pleistoceen-Fluviatiel (dominant), eolisch

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

    F52 - F52 - Fijn zand tot klei - Pleistoceen-Fluviatiel, mogelijks eolisch - lacustrien

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

    G - G - Weichseliaan, continentaal, niveo-eolisch, fluviatiel-grof facies

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

    Gb - Gb - Beekbodemgrind

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

    Gh - Gh - Hellingsgrind

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

    Gk - Gk - Grind

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

    Gt - Gt - Grind

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

    Gv - Gv - Valleibodemgrind

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

    H - H - Diachrone hellingsafzetting

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

    H' - H' - Niet gedifferentieerd grofkorrelig facies-hellingsprocessen

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

    H01 - H01 - Zandig facies - Diachroon-Hellingsprocessen

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

    H02 - H02 - Grindrijk facies - Diachroon-Hellingsprocessen

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

    H03 - H03 - Niet gedifferentieerd grofkorrelig facies - Diachroon-Hellingsprocessen

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

    H04 - H04 - Silteus tot kleiig facies - Diachroon-Hellingsprocessen

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

    H05 - H05 - Niet gedifferentieerd facies - Diachroon-Hellingsprocessen

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

    H06 - H06 - Silteus tot kleiig facies - Tardiglaciaal en/of Holoceen-Hellingsprocessen

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

    H07 - H07 - Niet gedifferentieerd facies - Tardiglaciaal en/of Holoceen-Hellingsprocessen

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

    H08 - H08 - Silt met intercalaties van kleiige, venige en/of zandige laagjes - Weichselien-Hellingsprocessen (dominant), eolisch

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

    HW01 - HW01 - Herwerkte Tertiaire afzettingen - Tertiair en/of Quartair-Lokale herwerking (proces niet gedifferentieerd)

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

    HW02 - HW02 - Herwerkte afzettingen - /-Lokale herwerking (proces niet gedifferentieerd)

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

    K - K - Holoceen, continentaal alluvium-grof facies

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

    K1 - K1 - Holoceen, continentaal alluvium

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

    K2 - K2 - Holoceen, continentaal alluvium

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

    M - M - Holoceen, marien-grof facies

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

    M01 - M01 - Klei en/of zand , geulopvulling over gehele sequentie - Laat-Holoceen-Marien

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

    M02 - M02 - Niet gedifferentieerd klastisch facies, veen, mogelijks kalkgyttja. - Holoceen-Marien

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

    M03 - M03 - Klei en/of zand over de gehele sequentie zonder veenlagen - Holoceen-Marien

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

    M04 - M04 - Klei en/of zand met aan de basis het basisveen - Holoceen-Marien

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

    M05 - M05 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag - Holoceen-Marien

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

    M06 - M06 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag en aan de basis het basisveen - Holoceen-Marien

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

    M07 - M07 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen en aan de basis het basisveen - Holoceen-Marien

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

    M08 - M08 - Afwisseling van klei en/of zand met een dunne veenlaag aan het oppervlak en aan de basis het basisveen - Holoceen-Marien

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

    M09 - M09 - Veen en/of organisch gyttja over de gehele sequentie met aan de top een klei- of zandlaag waarvan de dikte kleiner is dan de dikte van de veenlaag - Holoceen-Marien

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

    M10 - M10 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen en aan de basis het basisveen. Mogelijks veen aan het oppervlak - Holoceen-Marien

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

    M11 - M11 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen - Holoceen-Marien

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

    M12 - M12 - Dominant zandig facies - Holoceen-Marien

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

    M13 - M13 - Dominant kleiig facies - Holoceen-Marien

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

    M14 - M14 - Dominant kleiig facies - Eemien-Marien

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

    N - N - Weichseliaan, continentaal, niveo-eolisch-grof facies

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

    O - O - Niet gedifferentieerd klastisch facies, veen, mogelijks kalkgyttja-marien

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

    ON01 - ON01 - Onbekend - /-/

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

    P - P - Dominant zandige facies-perimarien

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

    Q - Q - Kwartair

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

    R - R - Diachroon-restgrind

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

    Rb - Rb - Beekbodemgrind

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

    Rf - Rf - Grindrijk zand - puinwaaier

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

    Rh - Rh - Hellingsgrind

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

    Ru - Ru - Grind

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

    S - S - Saale afzettingen

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

    S' - S' - Niet gedifferentieerd facies-fluviatiel

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

    T01 - T01 - Ondiep Tertiair substraat - Quartair en Tertiair-/

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

    T02 - T02 - Pré-Quartaire sedimenten - /-/

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

    U - U - Onbekend

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

    V' - V' - Venig complex-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel en/of eolisch

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

    V01 - V01 - Venig complex - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V02 - V02 - Veen op kleiig facies - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V03 - V03 - Veen op zandig facies - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V04 - V04 - Veen, kalktuf al dan niet met klastisch materiaal - Tardiglaciaal en/of Holoceen-Dominantie van organo-chemische processen

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

    V05 - V05 - Venig facies (veen al dan niet met klastische sedimenten) - Tardiglaciaal en/of Holoceen-Gedeeltelijke ontbinding van dode planten in een natte omgeving

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

    V06 - V06 - Venig complex - Weichselien-Gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel en/of eolisch

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

    V1 - V1 - Veen op kleiig facies-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    V2 - V2 - Veen op zandig facies-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    W1 - W1 - Klei en/of zand over gehele sequentie en bedekt met eolische afzettingen-eolisch, marien

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

    W3 - W3 - Klei en/of zand over de gehele sequentie en bedekt met eolische afzettingen-eolisch, marien

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

    X - X - Saale, continentaal-grof facies

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

    X1 - X1 - Klei en/of zand over de gehele sequentie zonder veenlagen-marien

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

    X11 - X11 - Klei en/of zand, geulopvulling over gehele sequentie-marien

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

    X2 - X2 - Klei en/of zand met aan de basis het basisveen-marien

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

    X3 - X3 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag-marien

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

    X4 - X4 - Klei en/of zand over de gehele sequentie met aan het huidige oppervlak een dunne veenlaag en aan de basis het basisveen-marien

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

    Y - Y - Pre-Saale continentaal-grof facies

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

    Y1 - Y1 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen-marien

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

    Y2 - Y2 - Klei en/of zand met intercalaties van één of meerdere verlandingsvenen en aan de basis het basisveen-marien

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

    Y4 - Y4 - Afwisseling van klei en/of zand met een dunne veenlaag aan het oppervlak en aan de basis het basisveen-marien

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

    Z - Z - Zand-eolisch

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

    Z3 - Z3 - Veen en/of organisch gyttja over de gehele sequentie met aan de top een klei- of zandlaag waarvan de dikte kleiner is dan de dikte van de veenlaag-marien

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

    [\\]] - [\\]] - Fining-up sequentie (Schelde)-fluviatiel

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

    ^ - ^ - Grind facies (Maas en Rijn, Zutendaal)-fluviatiel

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

    ^F - ^F - Grindhoudend en grindrijk zand tot grind-fluviatiel

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

    ^H - ^H - Grindrijk facies-hellingsprocessen

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

    ^K - ^K - Grind tot grindrijk zandig facies-fluviatiel

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

    ^Q - ^Q - Grindrijk facies-niet gedefinieerd

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

    ^W - ^W - Grindrijk facies-fluviatiel

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

    a - a - Weichseliaan, contineltaal, hellingsafzettingen

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

    a' - a' - Lichte zandleem tot silt-eolisch (dominant), lokale herwerking

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

    b - b - Holoceen, Pleistoceen, continentaal alluvium-fijn facies

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

    c - c - Eemiaan continentaal-fijn facies

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

    c° - c° - Fining-up cyclus, mogelijks met veen-fluviatiel

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

    d - d - Weichseliaan, continentaal, eolisch-fijn facies

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

    d1 - d1 - Kleiig facies op zandig facies-fluviatiel, hellingsprocessen

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

    e - e - Eemiaan, marien-fijn facies

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

    e' - e' - Niet gedifferentieerd facies, mogelijks veen-estuarien overgaand naar fluviatiel

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

    f - f - Weichseliaan, continentaal, fluviatiel, periglaciaal-fijn facies

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

    f' - f' - Niet gedifferentieerd fijn klastisch facies-fluviatiel

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

    f1 - f1 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    f2 - f2 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    f3 - f3 - Weichseliaan, continentaal, fluviatiel, periglaciaal

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

    f° - f° - Fining-up cyclus (cycli), mogelijks met veen-fluviatiel

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

    g - g - Weichseliaan, continentaal, niveo-eolisch, fluviatiel-fijn facies

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

    h - h - Diachroon-hellingsafzettingen

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

    h' - h' - Niet gedifferentieerd facies-hellingsprocessen

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

    i - i - Zandig/kleiig complex-getijdenomgeving

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

    j - j - Silteus tot kleiig facies-hellingsprocessen

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

    j' - j' - Niet gedifferentieerd facies-hellingsprocessen

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

    k - k - Holoceen, continentaal alluvium-fijn facies

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

    k' - k' - Niet gedifferentieerd facies, veen en kalftuf mogelijks aanwezig-fluviatiel

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

    k1 - k1 - Holoceen, continentaal alluvium

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

    k2 - k2 - Holoceen, continentaal alluvium

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

    l - l - Weichseliaan, continentaal-mergelig-venig

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

    m - m - Holoceen, marien-fijn facies

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

    n - n - Weichseliaan, continentaal, niveo-eolisch-fijn facies

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

    o - o - Holoceen - Pleistoceen overgang-organisch-klastisch complex

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

    p - p - Perimarien

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

    p' - p' - Niet gedifferentieerd facies (zandig tot kleiig)-estuarien

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

    q - q - Silteus tot kleiig facies-niet gedefinieerd

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

    q' - q' - Niet gedifferentieerd-niet gedefinieerd

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

    t - t - Kleiig/zandig complex (Lid van Turnhout)-estuarien

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

    u - u - Kleiig/zandig complex (Lid van Rijkevorsel)-estuarien

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

    v - v - Holoceen, continentaal-venig

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

    v' - v' - Venig complex-gedeeltelijke ontbinding van dode planten in een natte omgeving, fluviatiel

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

    w - w - Dominant zandig facies-fluviatiel

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

    w' - w' - Niet gedifferentieerd facies-fluviatiel

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

    x - x - Saale continentaal-fijn facies

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

    x' - x' - Dominant zandig facies met bodemhorizonten en veenlagen (Lid van Beerse)-fluviatiel en/of eolisch

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

    y - y - Pré-Saaliaan continentaal-fijn facies

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

    y' - y' - Dominant zandig facies-fluviatiel

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

    z - z - ?

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

    £ - £ - Zand- en grindfacies (Maas en Rijn, Lommel)-fluviatiel

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

    ¥ - ¥ - Grindfacies (Maas en Rijn, Lixhe-fluviatiel

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

    ¦ - ¦ - Kleiig tot grindrijk facies (Maas en Rijn, Leut)-fluviatiel

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

    § - § - Zandig facies tot grindfacies (Schelde)-fluviatiel

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

    © - © - Fijn zand tot klei-fluviatiel, mogelijks eolisch - lacustrien

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

    ® - ® - Zand, soms grind-fluviatiel (dominant), eolisch

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

    µ - µ - Complex van Melle-,

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

    Á - Á - Zand tot zandleem met mogelijks in het basisgedeelte een alternatie van fijnere en grovere laagjes-eolisch (dominant), hellingsprocessen

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

    Æ - Æ - Zandig facies-eolisch

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

    Ç - Ç - Ondiep Tertiair substraat-,

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

    Ø - Ø - Grind facies (Maas en Rijn, Lanklaar)-fluviatiel

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

    Þ - Þ - Zand- en grindfacies (Maas en Rijn, Winterslag)-fluviatiel

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

    ß - ß - Zand- en grindfacies (Maas en Rijn, Bocholt)-fluviatiel

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

    á - á - Klei tot kleiig zand-fluvio-lacustrien

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

    â - â - Homogeen silt gevolgd door silt met intercalaties van kleiige, venige en/of zandige laagjes-fluvio-lacustrien

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

    å - å - Silt met intercalaties van kleiige, venige en/of zandige laagjes-hellingsprocessen (dominant), eolisch

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

    æ - æ - Homogene silt en silt met intercalaties van kleiige en zandige laagjes-eolisch, hellingsprocessen

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

    ç - ç - Herwerkte Tertiaire afzettingen-lokale herwerking (proces niet gedifferentieerd

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

    ç' - ç' - Herwerkte afzettingen-lokale herwerking (proces niet gedifferentieerd

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

    é - é - Zandig/kleiig - silteus complex-getijdenomgeving (Marien en/of estuarien

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

    ô - ô - Holoceen, continentaal eolisch-stuifzand

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

    õ - õ - Holoceen, Pleistoceen, continentaal eolisch-stuifzand

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

    ÿ - ÿ - Zandig complex-estuarien

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

\n", "
\n", " " ], "text/plain": [ "" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ip_quart" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Try-out of use cases" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Select interpretations in a bbox" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/003] cc\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", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1lid1_labelrelatie_lid1_lid2lid2lid2_label
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132975.0191969.02.840.04.5KHoloceen, continentaal alluvium-grof faciesTKHoloceen, continentaal alluvium-grof facies
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132975.0191969.02.844.57.5FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132975.0191969.02.847.58.0RfGrindrijk zand - puinwaaierTRfGrindrijk zand - puinwaaier
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132949.0192068.02.570.04.5KHoloceen, continentaal alluvium-grof faciesTKHoloceen, continentaal alluvium-grof facies
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132949.0192068.02.574.59.5FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
\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 start_interpretatie_mtaw \\\n", "0 onbekend 132975.0 191969.0 2.84 \n", "1 onbekend 132975.0 191969.0 2.84 \n", "2 onbekend 132975.0 191969.0 2.84 \n", "3 onbekend 132949.0 192068.0 2.57 \n", "4 onbekend 132949.0 192068.0 2.57 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 \\\n", "0 0.0 4.5 K \n", "1 4.5 7.5 F \n", "2 7.5 8.0 Rf \n", "3 0.0 4.5 K \n", "4 4.5 9.5 F \n", "\n", " lid1_label relatie_lid1_lid2 lid2 \\\n", "0 Holoceen, continentaal alluvium-grof facies T K \n", "1 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "2 Grindrijk zand - puinwaaier T Rf \n", "3 Holoceen, continentaal alluvium-grof facies T K \n", "4 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "\n", " lid2_label \n", "0 Holoceen, continentaal alluvium-grof facies \n", "1 Weichseliaan, continentaal, fluviatiel, perigl... \n", "2 Grindrijk zand - puinwaaier \n", "3 Holoceen, continentaal alluvium-grof facies \n", "4 Weichseliaan, continentaal, fluviatiel, perigl... " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.util.location import Within, Box\n", "\n", "# Get all interpretations in a bounding box (llx, lly, ulx, uly)\n", "# the pkey_boring link is not available below, but is in the df\n", "df = ip_quart.search(location=Within(Box(132815, 191700, 133815, 192700, epsg=31370)))\n", "\n", "df['lid1_label'] = df['lid1'].apply(ip_quart.get_fields().lid1.codelist.get_definition)\n", "df['lid2_label'] = df['lid2'].apply(ip_quart.get_fields().lid2.codelist.get_definition)\n", "\n", "df = df[['pkey_interpretatie', 'pkey_boring', 'betrouwbaarheid_interpretatie', 'x', 'y',\n", " 'start_interpretatie_mtaw', 'diepte_laag_van', 'diepte_laag_tot', 'lid1', 'lid1_label',\n", " 'relatie_lid1_lid2', 'lid2', 'lid2_label']]\n", "\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Select interpretations in a bbox with selected properties" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['PropertyIsBetween',\n", " 'PropertyIsEqualTo',\n", " 'PropertyIsGreaterThan',\n", " 'PropertyIsGreaterThanOrEqualTo',\n", " 'PropertyIsLessThan',\n", " 'PropertyIsLessThanOrEqualTo',\n", " 'PropertyIsLike',\n", " 'PropertyIsNotEqualTo',\n", " 'PropertyIsNull',\n", " 'SortProperty']" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "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", "methods" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "from owslib.fes2 import PropertyIsGreaterThanOrEqualTo" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The property feature methodes listed above are available from the owslib module. These were not adapted for use in pydov." ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/003] cc\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", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1lid1_labelrelatie_lid1_lid2lid2lid2_label
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132975.0191969.02.840.04.5KHoloceen, continentaal alluvium-grof faciesTKHoloceen, continentaal alluvium-grof facies
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132975.0191969.02.844.57.5FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132975.0191969.02.847.58.0RfGrindrijk zand - puinwaaierTRfGrindrijk zand - puinwaaier
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132949.0192068.02.570.04.5KHoloceen, continentaal alluvium-grof faciesTKHoloceen, continentaal alluvium-grof facies
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...onbekend132949.0192068.02.574.59.5FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
\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 start_interpretatie_mtaw \\\n", "0 onbekend 132975.0 191969.0 2.84 \n", "1 onbekend 132975.0 191969.0 2.84 \n", "2 onbekend 132975.0 191969.0 2.84 \n", "3 onbekend 132949.0 192068.0 2.57 \n", "4 onbekend 132949.0 192068.0 2.57 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 \\\n", "0 0.0 4.5 K \n", "1 4.5 7.5 F \n", "2 7.5 8.0 Rf \n", "3 0.0 4.5 K \n", "4 4.5 9.5 F \n", "\n", " lid1_label relatie_lid1_lid2 lid2 \\\n", "0 Holoceen, continentaal alluvium-grof facies T K \n", "1 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "2 Grindrijk zand - puinwaaier T Rf \n", "3 Holoceen, continentaal alluvium-grof facies T K \n", "4 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "\n", " lid2_label \n", "0 Holoceen, continentaal alluvium-grof facies \n", "1 Weichseliaan, continentaal, fluviatiel, perigl... \n", "2 Grindrijk zand - puinwaaier \n", "3 Holoceen, continentaal alluvium-grof facies \n", "4 Weichseliaan, continentaal, fluviatiel, perigl... " ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Get deep boreholes in a bounding box \n", "from owslib.fes2 import PropertyIsLike\n", "# the propertyname can be any of the fields of the interpretations object that belong to the wfs source\n", "# the literal is always a string, no matter what its definition is in the boring object (string, float...)\n", "query = PropertyIsLike(\n", " propertyname='betrouwbaarheid_interpretatie', literal='onbekend')\n", "df = ip_quart.search(location=Within(Box(132815, 191700, 133815, 192700, epsg=31370)),\n", " query=query\n", " )\n", "\n", "df['lid1_label'] = df['lid1'].apply(ip_quart.get_fields().lid1.codelist.get_definition)\n", "df['lid2_label'] = df['lid2'].apply(ip_quart.get_fields().lid2.codelist.get_definition)\n", "\n", "df = df[['pkey_interpretatie', 'pkey_boring', 'betrouwbaarheid_interpretatie', 'x', 'y',\n", " 'start_interpretatie_mtaw', 'diepte_laag_van', 'diepte_laag_tot', 'lid1', 'lid1_label',\n", " 'relatie_lid1_lid2', 'lid2', 'lid2_label']]\n", "\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Select records within a distance from a point" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/015] ccccccccccccccc\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", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1lid1_labelrelatie_lid1_lid2lid2lid2_label
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1943...onbekend132035.0191802.03.140.01.5KHoloceen, continentaal alluvium-grof faciesTKHoloceen, continentaal alluvium-grof facies
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1943...onbekend132035.0191802.03.141.52.5DWeichseliaan continentaal eolisch-grof faciesTDWeichseliaan continentaal eolisch-grof facies
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1943...onbekend132035.0191802.03.142.511.5FWeichseliaan, continentaal, fluviatiel, perigl...TRfGrindrijk zand - puinwaaier
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1943...onbekend132035.0191802.03.1411.530.0$TertiairT$Tertiair
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1943...onbekend132066.0191830.03.150.02.0KHoloceen, continentaal alluvium-grof faciesTKHoloceen, continentaal alluvium-grof facies
\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/1943... \n", "1 https://www.dov.vlaanderen.be/data/boring/1943... \n", "2 https://www.dov.vlaanderen.be/data/boring/1943... \n", "3 https://www.dov.vlaanderen.be/data/boring/1943... \n", "4 https://www.dov.vlaanderen.be/data/boring/1943... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 onbekend 132035.0 191802.0 3.14 \n", "1 onbekend 132035.0 191802.0 3.14 \n", "2 onbekend 132035.0 191802.0 3.14 \n", "3 onbekend 132035.0 191802.0 3.14 \n", "4 onbekend 132066.0 191830.0 3.15 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 \\\n", "0 0.0 1.5 K \n", "1 1.5 2.5 D \n", "2 2.5 11.5 F \n", "3 11.5 30.0 $ \n", "4 0.0 2.0 K \n", "\n", " lid1_label relatie_lid1_lid2 lid2 \\\n", "0 Holoceen, continentaal alluvium-grof facies T K \n", "1 Weichseliaan continentaal eolisch-grof facies T D \n", "2 Weichseliaan, continentaal, fluviatiel, perigl... T Rf \n", "3 Tertiair T $ \n", "4 Holoceen, continentaal alluvium-grof facies T K \n", "\n", " lid2_label \n", "0 Holoceen, continentaal alluvium-grof facies \n", "1 Weichseliaan continentaal eolisch-grof facies \n", "2 Grindrijk zand - puinwaaier \n", "3 Tertiair \n", "4 Holoceen, continentaal alluvium-grof facies " ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.util.location import Point, WithinDistance\n", "\n", "# Get all interpretations within a defined distance from a point\n", "location = WithinDistance(location=Point(133000, 192000, epsg=31370),\n", " distance=1000, distance_unit='meter')\n", "df = ip_quart.search(location=location)\n", "\n", "df['lid1_label'] = df['lid1'].apply(ip_quart.get_fields().lid1.codelist.get_definition)\n", "df['lid2_label'] = df['lid2'].apply(ip_quart.get_fields().lid2.codelist.get_definition)\n", "\n", "df = df[['pkey_interpretatie', 'pkey_boring', 'betrouwbaarheid_interpretatie', 'x', 'y',\n", " 'start_interpretatie_mtaw', 'diepte_laag_van', 'diepte_laag_tot', 'lid1', 'lid1_label',\n", " 'relatie_lid1_lid2', 'lid2', 'lid2_label']]\n", "\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Select interpretations in a municipality" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/024] ccccccccccccc\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", "
pkey_interpretatiepkey_boringbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1lid1_labelrelatie_lid1_lid2lid2lid2_label
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1895...onbekend129384.0197648.06.00.02.7f1Weichseliaan, continentaal, fluviatiel, perigl...Tf1Weichseliaan, continentaal, fluviatiel, perigl...
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1895...onbekend128641.0197803.05.00.02.8FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1894...goed128930.0198740.04.00.012.2FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1894...goed128930.0198740.04.012.220.4$TertiairT$Tertiair
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1894...goed129770.0198680.04.60.03.5FWeichseliaan, continentaal, fluviatiel, perigl...TFWeichseliaan, continentaal, fluviatiel, perigl...
\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/1895... \n", "1 https://www.dov.vlaanderen.be/data/boring/1895... \n", "2 https://www.dov.vlaanderen.be/data/boring/1894... \n", "3 https://www.dov.vlaanderen.be/data/boring/1894... \n", "4 https://www.dov.vlaanderen.be/data/boring/1894... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 onbekend 129384.0 197648.0 6.0 \n", "1 onbekend 128641.0 197803.0 5.0 \n", "2 goed 128930.0 198740.0 4.0 \n", "3 goed 128930.0 198740.0 4.0 \n", "4 goed 129770.0 198680.0 4.6 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 \\\n", "0 0.0 2.7 f1 \n", "1 0.0 2.8 F \n", "2 0.0 12.2 F \n", "3 12.2 20.4 $ \n", "4 0.0 3.5 F \n", "\n", " lid1_label relatie_lid1_lid2 lid2 \\\n", "0 Weichseliaan, continentaal, fluviatiel, perigl... T f1 \n", "1 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "2 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "3 Tertiair T $ \n", "4 Weichseliaan, continentaal, fluviatiel, perigl... T F \n", "\n", " lid2_label \n", "0 Weichseliaan, continentaal, fluviatiel, perigl... \n", "1 Weichseliaan, continentaal, fluviatiel, perigl... \n", "2 Weichseliaan, continentaal, fluviatiel, perigl... \n", "3 Tertiair \n", "4 Weichseliaan, continentaal, fluviatiel, perigl... " ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from owslib.fes2 import PropertyIsEqualTo\n", "query = PropertyIsEqualTo(propertyname='gemeente',\n", " literal='Hamme')\n", "df = ip_quart.search(query=query)\n", "\n", "df['lid1_label'] = df['lid1'].apply(ip_quart.get_fields().lid1.codelist.get_definition)\n", "df['lid2_label'] = df['lid2'].apply(ip_quart.get_fields().lid2.codelist.get_definition)\n", "\n", "df = df[['pkey_interpretatie', 'pkey_boring', 'betrouwbaarheid_interpretatie', 'x', 'y',\n", " 'start_interpretatie_mtaw', 'diepte_laag_van', 'diepte_laag_tot', 'lid1', 'lid1_label',\n", " 'relatie_lid1_lid2', 'lid2', 'lid2_label']]\n", "\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Visualize results" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Using Folium, we can display the results of our search on a map." ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "# import the necessary modules (not included in the requirements of pydov!)\n", "import folium\n", "from folium.plugins import MarkerCluster\n", "from pyproj import Transformer" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [], "source": [ "# convert the coordinates to lat/lon for folium\n", "def convert_latlon(x1, y1):\n", " transformer = Transformer.from_crs(\"epsg:31370\", \"epsg:4326\", always_xy=True)\n", " x2,y2 = transformer.transform(x1, y1)\n", " return x2, y2\n", "\n", "df['lon'], df['lat'] = zip(*map(convert_latlon, df['x'], df['y'])) \n", "# convert to list\n", "loclist = df[['lat', 'lon']].values.tolist()" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
Make this Notebook Trusted to load map: File -> Trust Notebook
" ], "text/plain": [ "" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# initialize the Folium map on the centre of the selected locations, play with the zoom until ok\n", "fmap = folium.Map(location=[df['lat'].mean(), df['lon'].mean()], zoom_start=12)\n", "marker_cluster = MarkerCluster().add_to(fmap)\n", "for loc in range(0, len(loclist)):\n", " folium.Marker(loclist[loc], popup=df['lid1'][loc]).add_to(marker_cluster)\n", "fmap" ] } ], "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 }