{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Example of DOV search methods for interpretations (formele 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_formele_stratigrafie.ipynb)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Use cases explained below\n", "* Get 'formele stratigrafie' in a bounding box\n", "* Get 'formele stratigrafie' with specific properties\n", "* Get 'formele stratigrafie' in a bounding box based on specific properties\n", "* Select 'formele stratigrafie' in a municipality and return date\n", "* Get 'formele stratigrafie' based on fields not available in the standard output dataframe\n", "* Get 'formele stratigrafie' data, returning fields not available in the standard output dataframe" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import inspect, sys" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "# check pydov path\n", "import pydov" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Get information about the datatype 'Formele stratigrafie'" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "from pydov.search.interpretaties import FormeleStratigrafieSearch\n", "itp = FormeleStratigrafieSearch()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "A description is provided for the 'Formele stratigrafie' datatype:" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'Een formele stratigrafie van een boring of een sondering is een lithostratigrafische interpretatie van een (gecodeerde) lithologische beschrijving op basis van een welbepaalde vastgelegde standaard per diepte-interval. DOV gebruikt de gangbare standaarden binnen Vlaanderen. U vindt een overzicht van de gebruikte standaarden op onze website. De formele stratigrafie wordt gebruikt om de dikte van het Quartair te identificeren, en om de onderliggende pakketten Neogene, Paleogene en/of oudere lagen te onderscheiden en te identificeren.'" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "itp.get_description()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The different fields that are available for objects of the 'Formele stratigrafie' datatype can be requested with the get_fields() method:" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "pkey_interpretatie\n", "Type_proef\n", "Proefnummer\n", "Proeffiche\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", "pkey_boring\n", "pkey_sondering\n" ] } ], "source": [ "fields = itp.get_fields()\n", "\n", "# print available fields\n", "for f in fields.values():\n", " print(f['name'])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "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.FormeleStratigrafieSearch\n", "
\n", "

Een formele stratigrafie van een boring of een sondering is een lithostratigrafische interpretatie van een (gecodeerde) lithologische beschrijving op basis van een welbepaalde vastgelegde standaard per diepte-interval. DOV gebruikt de gangbare standaarden binnen Vlaanderen. U vindt een overzicht van de gebruikte standaarden op onze website. De formele stratigrafie wordt gebruikt om de dikte van het Quartair te identificeren, en om de onderliggende pakketten Neogene, Paleogene en/of oudere lagen te onderscheiden en te identificeren.

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

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

  • 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 formele stratigrafie is een interpretatie van een boring.

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

    Sondering - Sondering - De formele stratigrafie is een interpretatie van een sondering.

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

Proefnummer - Het proefnummer van de proef (boring of sondering) waarvan de formele stratigrafie een interpretatie is.

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

Proeffiche - URL die verwijst naar de gegevens van de proef (boring of sondering) 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 proef 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 proef 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 proef 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 formele 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 proef 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 formele stratigrafie.

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

Datum - De datum waarop de formele stratigrafie werd beschreven.

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

Opdrachten - De opdracht(en) waaraan de formele 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 formele 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 formele 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 formele 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 Formele stratigrafie in meter.

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

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

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

lid1 - eerste eenheid van de laag formele stratigrafie

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

    A - A - Antropogeen

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

    Aa - Aa - Formatie van Aalter

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

    AaBe - AaBe - Lid van Beernem (Formatie van Aalter)

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

    AaOe - AaOe - Lid van Oedelem (Formatie van Aalter)

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

    Ab - Ab - Formatie van Arenberg

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

    AbRs - AbRs - Lid van Rotselaar (Formatie van Arenberg)

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

    AbWi - AbWi - Lid van Wichelen (Formatie van Arenberg)

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

    AbX - AbX - Ongedifferentieerd Lid (Formatie van Arenberg)

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

    Ag - Ag - Formatie van Adegem

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

    Bb - Bb - Formatie van Bolderberg

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

    BbGe - BbGe - Lid van Genk (Formatie van Bolderberg)

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

    BbHo - BbHo - Lid van Houthalen (Formatie van Bolderberg)

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

    BbOp - BbOp - Lid van Opitter (Formatie van Bolderberg)

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

    Bc - Bc - Formatie van Berchem

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

    BcAn - BcAn - Lid van Antwerpen (Formatie van Berchem)

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

    BcEd - BcEd - Lid van Edegem (Formatie van Berchem)

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

    BcKi - BcKi - Lid van Kiel (Formatie van Berchem)

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

    BcZo - BcZo - Lid van Zonderschot (Formatie van Berchem)

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

    Be - Be - Formatie van Bertaimont

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

    Bi - Bi - Formatie van Bilzen

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

    BiBe - BiBe - Lid van Berg (Formatie van Bilzen)

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

    BiKe - BiKe - Lid van Kerniel (Formatie van Bilzen)

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

    BiKs - BiKs - Lid van Kleine Spouwen (Formatie van Bilzen)

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

    Bm - Bm - Formatie van Boom

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

    BmBt - BmBt - Lid van Boeretang (Formatie van Boom)

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

    BmBw - BmBw - Lid van Belsele-Waas (Formatie van Boom)

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

    BmPu - BmPu - Lid van Putte (Formatie van Boom)

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

    BmTe - BmTe - Lid van Terhagen (Formatie van Boom)

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

    Bo - Bo - Formatie van Borgloon

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

    BoBt - BoBt - Lid van Boutersem (Formatie van Borgloon)

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

    BoHe - BoHe - Lid van Henis (Formatie van Borgloon)

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

    BoKe - BoKe - Lid van Kerkom (Formatie van Borgloon)

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

    BoOb - BoOb - Lid van Alden Biezen (Formatie van Borgloon)

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

    Br - Br - Formatie van Brussel

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

    BrAr - BrAr - Lid van Archennes (Formatie van Brussel)

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

    BrBh - BrBh - Lid van Bois de la Houssière (Formatie van Brussel)

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

    BrBi - BrBi - Lid van Bierbeek (Formatie van Brussel)

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

    BrCg - BrCg - Lid van Chaumont-Gistoux (Formatie van Brussel)

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

    BrDi - BrDi - Lid van Diegem (Formatie van Brussel)

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

    BrKr - BrKr - Lid van Kraaiberg (Formatie van Brussel)

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

    BrMa - BrMa - Lid van Machelen (Formatie van Brussel)

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

    BrNe - BrNe - Lid van Neerijse (Formatie van Brussel)

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

    Bs - Bs - Formatie van Brasschaat

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

    BsAk - BsAk - Brasschaat

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

    BsHd - BsHd - Lid van Hemeldonk (Formatie van Brasschaat)

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

    BsSv - BsSv - Lid van Schorvoort (Formatie van Brasschaat)

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

    BsVs - BsVs - Lid van Vosselaar (Formatie van Brasschaat)

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

    Ca - Ca - Carboon

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

    CaDi - CaDi - Groep van Dinantiaan

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

    CaNa - CaNa - Groep van Namuriaan

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

    CaWe - CaWe - Groep van Westfaliaan

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

    Ci - Ci - Formatie van Ciply

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

    Cm - Cm - Groep van Cambrium

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

    De - De - Groep van Devoon

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

    Di - Di - Formatie van Diest

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

    DiBo - DiBo - Lid van Borsbeek (Formatie van Diest)

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

    DiDe - DiDe - Lid van Dessel (Formatie van Diest)

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

    DiDn - DiDn - Lid van Deurne (Formatie van Diest)

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

    DiHa - DiHa - Lid van Hageland Diest (Formatie van Diest)

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

    DiKe - DiKe - Lid van Kempen Diest (Formatie van Diest)

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

    Eg - Eg - Formatie van Eigenbilzen

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

    El - El - Formatie van Eeklo

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

    FX - FX - Formatie van afgedekte formatie

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

    G - G - Groep van geroerd/verstoord

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

    Ge - Ge - Formatie van Gentbrugge

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

    GeAb - GeAb - Lid van Aalterbrugge (Formatie van Gentbrugge)

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

    GeHo - GeHo - Lid van Hombeek (Formatie van Gentbrugge)

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

    GeKw - GeKw - Lid van Kwatrecht (Formatie van Gentbrugge)

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

    GeMe - GeMe - Lid van Merelbeke (Formatie van Gentbrugge)

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

    GePi - GePi - Lid van Pittem (Formatie van Gentbrugge)

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

    GeVl - GeVl - Lid van Vlierzele (Formatie van Gentbrugge)

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

    Gm - Gm - Formatie van Gembloux

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

    Gt - Gt - Formatie van Gent

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

    GtAb - GtAb - Lid van Achterbos (Formatie van Gent)

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

    GtDi - GtDi - Lid van Dilsen (Formatie van Gent)

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

    GtDp - GtDp - Lid van De Panne (Formatie van Gent)

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

    GtOg - GtOg - Lid van Opgrimbie (Formatie van Gent)

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

    GtTi - GtTi - Lid van Tisselt (Formatie van Gent)

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

    HP - HP - Groep van Haspengouw

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

    Ha - Ha - Formatie van Hainin

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

    Hn - Hn - Formatie van Hannut

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

    HnBe - HnBe - Lid van Beselare (Formatie van Hannut)

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

    HnCh - HnCh - Lid van Chercq (Formatie van Hannut)

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

    HnGr - HnGr - Lid van Grandglise (Formatie van Hannut)

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

    HnHa - HnHa - Lid van Halen (Formatie van Hannut)

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

    HnLi - HnLi - Lid van Lincent (Formatie van Hannut)

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

    HnWa - HnWa - Lid van Waterschei (Formatie van Hannut)

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

    Ho - Ho - Formatie van Houthem

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

    Hs - Hs - Formatie van Heers

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

    HsGe - HsGe - Lid van Gelinden (Formatie van Heers)

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

    HsMa - HsMa - Lid van Maaseik (Formatie van Heers)

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

    HsOr - HsOr - Lid van Orp (Formatie van Heers)

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

    Hy - Hy - Formatie van Hyon

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

    HyBo - HyBo - Lid van Bois-la-Haut (Formatie van Hyon)

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

    HyEg - HyEg - Lid van Egem (Formatie van Hyon)

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

    HyMo - HyMo - Lid van Mont-Panisel (Formatie van Hyon)

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

    Hz - Hz - Formatie van Herzeele

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

    IE - IE - Groep van Ieper

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

    In - In - Formatie van Inden

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

    KRWe - KRWe - Wealden

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

    Kd - Kd - Formatie van Kattendijk

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

    Ke - Ke - Formatie van Kempen

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

    Kh - Kh - Formatie van Kruishoutem

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

    Kl - Kl - Formatie van Kasterlee

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

    KlBe - KlBe - Lid van Beerzel (Formatie van Kasterlee)

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

    KlHa - KlHa - Lid van Hallaar (Formatie van Kasterlee)

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

    KlHe - KlHe - Lid van Heist-op-den-Berg (Formatie van Kasterlee)

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

    KlLi - KlLi - Lid van Lichtaart (Formatie van Kasterlee)

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

    Ko - Ko - Formatie van Kortrijk

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

    KoAa - KoAa - Lid van Aalbeke (Formatie van Kortrijk)

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

    KoMh - KoMh - Lid van Mont-Héribu (Formatie van Kortrijk)

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

    KoMo - KoMo - Lid van Moen (Formatie van Kortrijk)

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

    KoMp - KoMp - Lid van Mons-en-Pévèle (Formatie van Kortrijk)

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

    KoOl - KoOl - Lid van Lower Orchies (Formatie van Kortrijk)

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

    KoOm - KoOm - Lid van Middle Orchies (Formatie van Kortrijk)

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

    KoOr - KoOr - Lid van Orchies (Formatie van Kortrijk)

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

    KoOu - KoOu - Lid van Upper Orchies (Formatie van Kortrijk)

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

    KoRo - KoRo - Lid van Roubaix (Formatie van Kortrijk)

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

    KoSm - KoSm - Lid van Saint Maur (Formatie van Kortrijk)

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

    KoZo - KoZo - Lid van Het Zoute (Formatie van Kortrijk)

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

    Kz - Kz - Formatie van Kiezelooliet

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

    KzB1 - KzB1 - Lid van Brunssum1 (Formatie van Kiezelooliet)

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

    KzB2 - KzB2 - Lid van Brunssum2 (Formatie van Kiezelooliet)

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

    KzBr - KzBr - Lid van Brunssum (Formatie van Kiezelooliet)

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

    KzJa - KzJa - Lid van Jagersborg (Formatie van Kiezelooliet)

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

    KzPe - KzPe - Lid van Pey (Formatie van Kiezelooliet)

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

    KzWb - KzWb - Lid van Waubach (Formatie van Kiezelooliet)

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

    KzX - KzX - Lid van ongedefinieerd (Formatie van Kiezelooliet)

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

    LA - LA - Groep van Landen

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

    Ld - Ld - Formatie van Lede

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

    Li - Li - Formatie van Lillo

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

    LiKr - LiKr - Lid van Kruisschans (Formatie van Lillo)

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

    LiLu - LiLu - Lid van Luchtbal (Formatie van Lillo)

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

    LiMe - LiMe - Lid van Merksem (Formatie van Lillo)

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

    LiOo - LiOo - Lid van Oorderen (Formatie van Lillo)

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

    LiPd - LiPd - Lid van Poederlee (Formatie van Lillo)

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

    LiX - LiX - Lid van ongedifferentieerd (Formatie van Lillo)

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

    LiZa - LiZa - Lid van Zandvliet (Formatie van Lillo)

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

    Lk - Lk - Formatie van Lanklaar

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

    Ln - Ln - Formatie van Lanaken

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

    MA - MA - Groep van Maas

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

    MAa - MAa - Formatie van Aalburg

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

    MAk - MAk - Formatie van Aachen

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

    MAkAa - MAkAa - Zand van Aachen

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

    MAkHe - MAkHe - Hergenrath

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

    MBe - MBe - Formatie van Bernissart

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

    MBu - MBu - Formatie van Buntsandstein

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

    MBuBr - MBuBr - Lid van Bree (Formatie van Buntsandstein)

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

    MBuBu - MBuBu - Lid van Bullen (Formatie van Buntsandstein)

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

    MBuGr - MBuGr - Lid van Gruitrode (Formatie van Buntsandstein)

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

    MDo - MDo - Formatie van Dorne

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

    MDoB1 - MDoB1 - Beutenaken1

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

    MDoB2 - MDoB2 - Beutenaken2

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

    MDoOv - MDoOv - Onder-Vijlen

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

    MDoZe - MDoZe - Zeven Wegen Equivalent

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

    ME - ME - Groep van Maas

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

    MEs - MEs - Formatie van Esplechin

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

    MGu - MGu - Formatie van Gulpen

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

    MGuBe - MGuBe - Lid van Beutenaken Kalk (Formatie van Gulpen)

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

    MGuLa - MGuLa - Lid van Lanaye (Formatie van Gulpen)

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

    MGuLi - MGuLi - Lid van Lixhe (Formatie van Gulpen)

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

    MGuVi - MGuVi - Lid van Vijlen (Formatie van Gulpen)

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

    MGuZe - MGuZe - Lid van Zeven Wegen (Formatie van Gulpen)

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

    MHa - MHa - Groep van Hainaut

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

    MJU - MJU - Groep van Jura

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

    MKR - MKR - Groep van Krijt

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

    MKe - MKe - Formatie van Keuper

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

    MKu - MKu - Formatie van Kunrade

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

    MMa - MMa - Formatie van Maastricht

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

    MMaKu - MMaKu - Lid van Kunrade (Formatie van Maastricht)

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

    MMaVa - MMaVa - Lid van Valkenburg (Formatie van Maastricht)

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

    MMs - MMs - Formatie van Maisières Chalk

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

    MMu - MMu - Formatie van Muschelkalk

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

    MMuAn - MMuAn - Anhydrit Gruppe

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

    MMuHa - MMuHa - Hauptmuschelkalk

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

    MMuWe - MMuWe - Wellenkalk

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

    MNe - MNe - Formatie van Nevele

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

    MNeSt - MNeSt - Lid van Stekene (Formatie van Nevele)

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

    MNeWa - MNeWa - Lid van Wachtebeke (Formatie van Nevele)

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

    MRo - MRo - Formatie van Röt

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

    MSl - MSl - Formatie van Sleen

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

    MVa - MVa - Formatie van Vaals

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

    MVaBG - MVaBG - Boven Vaalser Groenzand

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

    MVaOG - MVaOG - Onder Vaalser groenzand

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

    MVg - MVg - Formatie van Vert Galand

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

    Ma - Ma - Formatie van Maldegem

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

    MaAs - MaAs - Lid van Asse (Formatie van Maldegem)

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

    MaBu - MaBu - Lid van Buisputten (Formatie van Maldegem)

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

    MaOd - MaOd - Lid van Onderdijke (Formatie van Maldegem)

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

    MaOn - MaOn - Lid van Onderdale (Formatie van Maldegem)

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

    MaUr - MaUr - Lid van Ursel (Formatie van Maldegem)

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

    MaWe - MaWe - Lid van Wemmel (Formatie van Maldegem)

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

    MaZo - MaZo - Lid van Zomergem (Formatie van Maldegem)

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

    Mb - Mb - Formatie van Meulebeke

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

    Me - Me - Formatie van Merksplas

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

    MeB - MeB - Merksplas

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

    Ml - Ml - Formatie van Mol

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

    MlDo - MlDo - Lid van Donk (Formatie van Mol)

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

    MlMa - MlMa - Lid van Maat (Formatie van Mol)

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

    MlMh - MlMh - Lid van Maatheide (Formatie van Mol)

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

    MlRe - MlRe - Lid van Rees (Formatie van Mol)

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

    MlRt - MlRt - Lid van Retie (Formatie van Mol)

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

    MlRu - MlRu - Lid van Russendorp (Formatie van Mol)

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

    Mn - Mn - Formatie van Molenbeersel

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

    Mo - Mo - Formatie van Mons

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

    Mp - Mp - Formatie van Mons-en-Pévèle

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

    Mx - Mx - Formatie van Melle

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

    My - My - Formatie van Malle

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

    Ne - Ne - Groep van Neogeen

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

    Op - Op - Formatie van Opglabbeek

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

    OpEi - OpEi - Lid van Eisden (Formatie van Opglabbeek)

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

    OpMa - OpMa - Lid van Maasmechelen (Formatie van Opglabbeek)

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

    OpOp - OpOp - Lid van Opoeteren (Formatie van Opglabbeek)

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

    Or - Or - Groep van Ordovicium

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

    Ot - Ot - Formatie van Oostende

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

    Ow - Ow - Formatie van Oostwinkel

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

    P - P - Groep van Paleozoïcum

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

    P1 - P1 - Groep van Onder Paleozoïcum

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

    P2 - P2 - Groep van Boven Paleozoïcum

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

    PAi - PAi - Formatie van Aisemont

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

    PAl - PAl - Formatie van Alvaux

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

    PAn - PAn - Formatie van Andenne

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

    PAt - PAt - Formatie van Antoing

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

    PAtGa - PAtGa - Lid van Gaurain-Ramecroix (Formatie van Antoing)

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

    PAtWa - PAtWa - Lid van Warchin (Formatie van Antoing)

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

    PAv - PAv - Formatie van Abbaye de Villers

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

    PBe - PBe - Formatie van Berneau

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

    PBg - PBg - Formatie van Bellegem

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

    PBi - PBi - Formatie van Booischot

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

    PBl - PBl - Formatie van Blanmont

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

    PBn - PBn - Formatie van Bornival

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

    PBnXa - PBnXa - Lid van Lid niet benoemd (Formatie van Bornival)

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

    PBnXb - PBnXb - Lid van Lid niet benoemd (Formatie van Bornival)

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

    PBnXc - PBnXc - Lid van Lid niet benoemd (Formatie van Bornival)

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

    PBo - PBo - Formatie van Bosscheveld

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

    PBp - PBp - Formatie van Bois Grand-Père

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

    PBr - PBr - Formatie van Brûtia

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

    PBv - PBv - Formatie van Bovesse

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

    PC - PC - Groep van Condroz

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

    PCa - PCa - Formatie van Châtelet

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

    PCaFl - PCaFl - Lid van Floriffoux (Formatie van Châtelet)

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

    PCaRa - PCaRa - Lid van Ransart (Formatie van Châtelet)

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

    PCe - PCe - Formatie van Chevlipont

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

    PCh - PCh - Formatie van Charleroi

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

    PChAs - PChAs - Lid van As (Formatie van Charleroi)

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

    PChEi - PChEi - Lid van Eikenberg (Formatie van Charleroi)

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

    PChMo - PChMo - Lid van Mons (Formatie van Charleroi)

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

    PCo - PCo - Formatie van Chokier

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

    PCoBo - PCoBo - Lid van Bois-et-Borsu (Formatie van Chokier)

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

    PCoTr - PCoTr - Lid van Tramaka (Formatie van Chokier)

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

    PCr - PCr - Formatie van Corroy

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

    PDe - PDe - Formatie van Deerlijk

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

    PEt - PEt - Formatie van Etroeungt

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

    PEv - PEv - Formatie van Evieux

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

    PF - PF - Groep van Frasne

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

    PFa - PFa - Groep van Famenne

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

    PFf - PFf - Formatie van Froide Fontaine

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

    PFi - PFi - Formatie van Fallais

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

    PFiPi - PFiPi - Lid van Pitet (Formatie van Fallais)

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

    PFiXa - PFiXa - Lid van Lid A (Formatie van Fallais)

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

    PFiXb - PFiXb - Lid van Lid B (Formatie van Fallais)

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

    PFiXc - PFiXc - Lid van Lid C (Formatie van Fallais)

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

    PFiXd - PFiXd - Lid van Lid D (Formatie van Fallais)

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

    PFiXe - PFiXe - Lid van Lid E (Formatie van Fallais)

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

    PFl - PFl - Formatie van Flénu

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

    PFlMe - PFlMe - Lid van Meeuwen (Formatie van Flénu)

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

    PFlNe - PFlNe - Lid van Neerglabbeek (Formatie van Flénu)

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

    PFlWa - PFlWa - Lid van Wasmes (Formatie van Flénu)

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

    PFq - PFq - Formatie van Fauquez

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

    PFr - PFr - Formatie van Franc-Waret

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

    PFu - PFu - Formatie van Fumal

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

    PG - PG - Groep van Givet

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

    PGe - PGe - Formatie van Goeree

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

    PGo - PGo - Formatie van Gottignies

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

    PHe - PHe - Formatie van Helchteren

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

    PHeH1 - PHeH1 - Helchteren1

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

    PHeH2 - PHeH2 - Helchteren2

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

    PHeH3 - PHeH3 - Helchteren3

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

    PHeH4 - PHeH4 - Helchteren4

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

    PHeH5 - PHeH5 - Helchteren5

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

    PHi - PHi - Formatie van Heibaart

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

    PHo - PHo - Formatie van Hosdin

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

    PHs - PHs - Formatie van Hastière

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

    PHu - PHu - Formatie van Huet

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

    PIt - PIt - Formatie van Ittre

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

    PJo - PJo - Formatie van Jodoigne

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

    PK - PK - Groep van Kolenkalk

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

    PKe - PKe - Formatie van Kessel

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

    PLa - PLa - Formatie van Landelies

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

    PLm - PLm - Formatie van Lambermont

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

    PLo - PLo - Formatie van Loenhout

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

    PLs - PLs - Formatie van Lust

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

    PLt - PLt - Formatie van Latinne

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

    PLu - PLu - Formatie van Lustin

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

    PMa - PMa - Formatie van Mazy

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

    PMd - PMd - Formatie van Madot

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

    PMdXa - PMdXa - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXb - PMdXb - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXc - PMdXc - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXd - PMdXd - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXe - PMdXe - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXf - PMdXf - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXg - PMdXg - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMn - PMn - Formatie van Montfort

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

    PMo - PMo - Formatie van Mousty

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

    PMoFr - PMoFr - Lid van Franquenies (Formatie van Mousty)

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

    PMoTa - PMoTa - Lid van Tangissart (Formatie van Mousty)

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

    PMoXx - PMoXx - Lid van Lid niet benoemd (Formatie van Mousty)

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

    PMu - PMu - Formatie van Mautiennes

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

    PNe - PNe - Formatie van Neeroeteren

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

    POD - POD - Ordovicium

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

    POr - POr - Formatie van Orient

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

    POs - POs - Formatie van Oisquercq

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

    POsAs - POsAs - Lid van Asquempont (Formatie van Oisquercq)

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

    POsRi - POsRi - Lid van Ripain (Formatie van Oisquercq)

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

    PPe - PPe - Formatie van Pecq

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

    PPo - PPo - Formatie van Pont d'Arcole

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

    PPr - PPr - Formatie van Presles

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

    PPt - PPt - Formatie van Petit-Roeulx

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

    PRh - PRh - Formatie van Rhisnes

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

    PRi - PRi - Formatie van Rigenée

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

    PRk - PRk - Formatie van Rekkem

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

    PRn - PRn - Formatie van Ronquières

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

    PSa - PSa - Formatie van Samme

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

    PSaBo - PSaBo - Lid van Bois de la Rocq (Formatie van Samme)

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

    PSaFe - PSaFe - Lid van Feluy (Formatie van Samme)

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

    PSaMe - PSaMe - Lid van Mévergnies (Formatie van Samme)

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

    PSe - PSe - Formatie van Steenkerque

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

    PSo - PSo - Formatie van Souvré

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

    PSt - PSt - Formatie van Steentje-Turnhout

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

    PTo - PTo - Formatie van Tournai

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

    PToAl - PToAl - Lid van Allain (Formatie van Tournai)

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

    PToCr - PToCr - Lid van Crampon (Formatie van Tournai)

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

    PToPo - PToPo - Lid van Point-à-Rieu (Formatie van Tournai)

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

    PToPr - PToPr - Lid van Providence (Formatie van Tournai)

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

    PToVa - PToVa - Lid van Vaulx (Formatie van Tournai)

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

    PToVi - PToVi - Lid van Vignobles (Formatie van Tournai)

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

    PTr - PTr - Formatie van Tribotte

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

    PTu - PTu - Formatie van Tubize

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

    PTuFo - PTuFo -

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

    PTuRo - PTuRo -

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

    PTuXx - PTuXx -

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

    PVa - PVa - Formatie van Les Vallées

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

    PVc - PVc - Formatie van Vichenet

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

    PVe - PVe - Formatie van Vesdre

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

    PVi - PVi - Formatie van Visé

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

    PVl - PVl - Formatie van Velp

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

    PVs - PVs - Formatie van Vissoul

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

    Pa - Pa - Paleogeen

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

    Pd - Pd - Formatie van Poederlee

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

    PdHe - PdHe - Lid van Heieinde (Formatie van Poederlee)

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

    Q - Q - Groep van Quartaire afzetting

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

    QH - QH - Quartair Holoceen

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

    QP - QP - Quartair Pleistoceen

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

    RO - RO - Groep van Romont

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

    RU - RU - Groep van Rupel

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

    Rb - Rb - Formatie van Rozebeke

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

    S - S - Primair

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

    SC - SC - Groep van Schelde

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

    Sh - Sh - Formatie van Sint Huibrechts Hern

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

    ShGr - ShGr - Lid van Grimmertingen (Formatie van Sint Huibrechts Hern)

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

    ShNe - ShNe - Lid van Neerrepen (Formatie van Sint Huibrechts Hern)

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

    Si - Si - Groep van Siluur

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

    Sk - Sk - Formatie van Stokkem

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

    St - St - Formatie van Sterksel

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

    StBo - StBo - Lid van Bocholt (Formatie van Sterksel)

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

    StHa - StHa - Lid van Hamont (Formatie van Sterksel)

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

    StLo - StLo - Lid van Lommel (Formatie van Sterksel)

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

    T - T - Tertiaire afzetting

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

    TO - TO - Groep van Tongeren

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

    TR - TR - Groep van Trias

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

    Ti - Ti - Formatie van Tienen

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

    TiDo - TiDo - Lid van Dormaal (Formatie van Tienen)

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

    TiEr - TiEr - Lid van Erquelinne (Formatie van Tienen)

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

    TiKn - TiKn - Lid van Knokke (Formatie van Tienen)

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

    TiLo - TiLo - Lid van Loksbergen (Formatie van Tienen)

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

    Tt - Tt - Formatie van Tielt

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

    TtEg - TtEg - Lid van Egem (Formatie van Tielt)

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

    TtEk - TtEk - Lid van Egemkapel (Formatie van Tielt)

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

    TtKo - TtKo - Lid van Kortemark (Formatie van Tielt)

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

    U - U - Onbekend

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

    Vd - Vd - Formatie van Veldhoven

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

    VdSo - VdSo - Lid van Someren (Formatie van Veldhoven)

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

    VdVo - VdVo - Lid van Voort (Formatie van Veldhoven)

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

    VdWi - VdWi - Lid van Wintelre (Formatie van Veldhoven)

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

    Ve - Ve - Formatie van Veldwezelt

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

    Vh - Vh - Formatie van Vlaamse Heuvels

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

    Vl - Vl - Formatie van Vlaanderen

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

    VlCa - VlCa - Lid van Calais (Formatie van Vlaanderen)

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

    VlDh - VlDh - Lid van De Haan (Formatie van Vlaanderen)

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

    VlDu - VlDu - Lid van Dunkerque (Formatie van Vlaanderen)

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

    Vo - Vo - Formatie van Voort

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

    VoSo - VoSo - Lid van Someren (Formatie van Voort)

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

    VoVe - VoVe - Lid van Veldhoven (Formatie van Voort)

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

    VoVo - VoVo - Lid van Voort (Formatie van Voort)

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

    We - We - Formatie van Weelde

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

    WeBs - WeBs - Lid van Beerse (Formatie van Weelde)

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

    WeRv - WeRv - Lid van Rijkevorsel (Formatie van Weelde)

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

    WeTu - WeTu - Lid van Turnhout (Formatie van Weelde)

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

    Wu - Wu - Formatie van Wurfeld

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

    ZE - ZE - Groep van Zenne

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

    Zd - Zd - Formatie van Zutendaal

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

    Zz - Zz - Formatie van Zelzate

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

    ZzBa - ZzBa - Lid van Bassevelde (Formatie van Zelzate)

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

    ZzRu - ZzRu - Lid van Ruisbroek (Formatie van Zelzate)

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

    ZzWa - ZzWa - Lid van Watervliet (Formatie van Zelzate)

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

relatie_lid1_lid2 - verbinding/relatie tussen lid1 en lid2 van de laag formele stratigrafie

  • 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 formele stratigrafie. Indien niet ingevuld wordt default de waarde van 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", "

    A - A - Antropogeen

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

    Aa - Aa - Formatie van Aalter

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

    AaBe - AaBe - Lid van Beernem (Formatie van Aalter)

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

    AaOe - AaOe - Lid van Oedelem (Formatie van Aalter)

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

    Ab - Ab - Formatie van Arenberg

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

    AbRs - AbRs - Lid van Rotselaar (Formatie van Arenberg)

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

    AbWi - AbWi - Lid van Wichelen (Formatie van Arenberg)

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

    AbX - AbX - Ongedifferentieerd Lid (Formatie van Arenberg)

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

    Ag - Ag - Formatie van Adegem

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

    Bb - Bb - Formatie van Bolderberg

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

    BbGe - BbGe - Lid van Genk (Formatie van Bolderberg)

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

    BbHo - BbHo - Lid van Houthalen (Formatie van Bolderberg)

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

    BbOp - BbOp - Lid van Opitter (Formatie van Bolderberg)

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

    Bc - Bc - Formatie van Berchem

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

    BcAn - BcAn - Lid van Antwerpen (Formatie van Berchem)

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

    BcEd - BcEd - Lid van Edegem (Formatie van Berchem)

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

    BcKi - BcKi - Lid van Kiel (Formatie van Berchem)

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

    BcZo - BcZo - Lid van Zonderschot (Formatie van Berchem)

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

    Be - Be - Formatie van Bertaimont

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

    Bi - Bi - Formatie van Bilzen

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

    BiBe - BiBe - Lid van Berg (Formatie van Bilzen)

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

    BiKe - BiKe - Lid van Kerniel (Formatie van Bilzen)

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

    BiKs - BiKs - Lid van Kleine Spouwen (Formatie van Bilzen)

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

    Bm - Bm - Formatie van Boom

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

    BmBt - BmBt - Lid van Boeretang (Formatie van Boom)

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

    BmBw - BmBw - Lid van Belsele-Waas (Formatie van Boom)

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

    BmPu - BmPu - Lid van Putte (Formatie van Boom)

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

    BmTe - BmTe - Lid van Terhagen (Formatie van Boom)

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

    Bo - Bo - Formatie van Borgloon

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

    BoBt - BoBt - Lid van Boutersem (Formatie van Borgloon)

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

    BoHe - BoHe - Lid van Henis (Formatie van Borgloon)

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

    BoKe - BoKe - Lid van Kerkom (Formatie van Borgloon)

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

    BoOb - BoOb - Lid van Alden Biezen (Formatie van Borgloon)

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

    Br - Br - Formatie van Brussel

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

    BrAr - BrAr - Lid van Archennes (Formatie van Brussel)

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

    BrBh - BrBh - Lid van Bois de la Houssière (Formatie van Brussel)

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

    BrBi - BrBi - Lid van Bierbeek (Formatie van Brussel)

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

    BrCg - BrCg - Lid van Chaumont-Gistoux (Formatie van Brussel)

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

    BrDi - BrDi - Lid van Diegem (Formatie van Brussel)

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

    BrKr - BrKr - Lid van Kraaiberg (Formatie van Brussel)

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

    BrMa - BrMa - Lid van Machelen (Formatie van Brussel)

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

    BrNe - BrNe - Lid van Neerijse (Formatie van Brussel)

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

    Bs - Bs - Formatie van Brasschaat

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

    BsAk - BsAk - Brasschaat

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

    BsHd - BsHd - Lid van Hemeldonk (Formatie van Brasschaat)

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

    BsSv - BsSv - Lid van Schorvoort (Formatie van Brasschaat)

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

    BsVs - BsVs - Lid van Vosselaar (Formatie van Brasschaat)

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

    Ca - Ca - Carboon

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

    CaDi - CaDi - Groep van Dinantiaan

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

    CaNa - CaNa - Groep van Namuriaan

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

    CaWe - CaWe - Groep van Westfaliaan

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

    Ci - Ci - Formatie van Ciply

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

    Cm - Cm - Groep van Cambrium

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

    De - De - Groep van Devoon

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

    Di - Di - Formatie van Diest

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

    DiBo - DiBo - Lid van Borsbeek (Formatie van Diest)

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

    DiDe - DiDe - Lid van Dessel (Formatie van Diest)

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

    DiDn - DiDn - Lid van Deurne (Formatie van Diest)

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

    DiHa - DiHa - Lid van Hageland Diest (Formatie van Diest)

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

    DiKe - DiKe - Lid van Kempen Diest (Formatie van Diest)

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

    Eg - Eg - Formatie van Eigenbilzen

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

    El - El - Formatie van Eeklo

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

    FX - FX - Formatie van afgedekte formatie

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

    G - G - Groep van geroerd/verstoord

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

    Ge - Ge - Formatie van Gentbrugge

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

    GeAb - GeAb - Lid van Aalterbrugge (Formatie van Gentbrugge)

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

    GeHo - GeHo - Lid van Hombeek (Formatie van Gentbrugge)

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

    GeKw - GeKw - Lid van Kwatrecht (Formatie van Gentbrugge)

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

    GeMe - GeMe - Lid van Merelbeke (Formatie van Gentbrugge)

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

    GePi - GePi - Lid van Pittem (Formatie van Gentbrugge)

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

    GeVl - GeVl - Lid van Vlierzele (Formatie van Gentbrugge)

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

    Gm - Gm - Formatie van Gembloux

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

    Gt - Gt - Formatie van Gent

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

    GtAb - GtAb - Lid van Achterbos (Formatie van Gent)

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

    GtDi - GtDi - Lid van Dilsen (Formatie van Gent)

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

    GtDp - GtDp - Lid van De Panne (Formatie van Gent)

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

    GtOg - GtOg - Lid van Opgrimbie (Formatie van Gent)

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

    GtTi - GtTi - Lid van Tisselt (Formatie van Gent)

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

    HP - HP - Groep van Haspengouw

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

    Ha - Ha - Formatie van Hainin

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

    Hn - Hn - Formatie van Hannut

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

    HnBe - HnBe - Lid van Beselare (Formatie van Hannut)

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

    HnCh - HnCh - Lid van Chercq (Formatie van Hannut)

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

    HnGr - HnGr - Lid van Grandglise (Formatie van Hannut)

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

    HnHa - HnHa - Lid van Halen (Formatie van Hannut)

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

    HnLi - HnLi - Lid van Lincent (Formatie van Hannut)

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

    HnWa - HnWa - Lid van Waterschei (Formatie van Hannut)

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

    Ho - Ho - Formatie van Houthem

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

    Hs - Hs - Formatie van Heers

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

    HsGe - HsGe - Lid van Gelinden (Formatie van Heers)

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

    HsMa - HsMa - Lid van Maaseik (Formatie van Heers)

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

    HsOr - HsOr - Lid van Orp (Formatie van Heers)

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

    Hy - Hy - Formatie van Hyon

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

    HyBo - HyBo - Lid van Bois-la-Haut (Formatie van Hyon)

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

    HyEg - HyEg - Lid van Egem (Formatie van Hyon)

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

    HyMo - HyMo - Lid van Mont-Panisel (Formatie van Hyon)

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

    Hz - Hz - Formatie van Herzeele

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

    IE - IE - Groep van Ieper

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

    In - In - Formatie van Inden

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

    KRWe - KRWe - Wealden

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

    Kd - Kd - Formatie van Kattendijk

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

    Ke - Ke - Formatie van Kempen

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

    Kh - Kh - Formatie van Kruishoutem

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

    Kl - Kl - Formatie van Kasterlee

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

    KlBe - KlBe - Lid van Beerzel (Formatie van Kasterlee)

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

    KlHa - KlHa - Lid van Hallaar (Formatie van Kasterlee)

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

    KlHe - KlHe - Lid van Heist-op-den-Berg (Formatie van Kasterlee)

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

    KlLi - KlLi - Lid van Lichtaart (Formatie van Kasterlee)

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

    Ko - Ko - Formatie van Kortrijk

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

    KoAa - KoAa - Lid van Aalbeke (Formatie van Kortrijk)

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

    KoMh - KoMh - Lid van Mont-Héribu (Formatie van Kortrijk)

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

    KoMo - KoMo - Lid van Moen (Formatie van Kortrijk)

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

    KoMp - KoMp - Lid van Mons-en-Pévèle (Formatie van Kortrijk)

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

    KoOl - KoOl - Lid van Lower Orchies (Formatie van Kortrijk)

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

    KoOm - KoOm - Lid van Middle Orchies (Formatie van Kortrijk)

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

    KoOr - KoOr - Lid van Orchies (Formatie van Kortrijk)

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

    KoOu - KoOu - Lid van Upper Orchies (Formatie van Kortrijk)

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

    KoRo - KoRo - Lid van Roubaix (Formatie van Kortrijk)

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

    KoSm - KoSm - Lid van Saint Maur (Formatie van Kortrijk)

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

    KoZo - KoZo - Lid van Het Zoute (Formatie van Kortrijk)

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

    Kz - Kz - Formatie van Kiezelooliet

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

    KzB1 - KzB1 - Lid van Brunssum1 (Formatie van Kiezelooliet)

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

    KzB2 - KzB2 - Lid van Brunssum2 (Formatie van Kiezelooliet)

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

    KzBr - KzBr - Lid van Brunssum (Formatie van Kiezelooliet)

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

    KzJa - KzJa - Lid van Jagersborg (Formatie van Kiezelooliet)

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

    KzPe - KzPe - Lid van Pey (Formatie van Kiezelooliet)

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

    KzWb - KzWb - Lid van Waubach (Formatie van Kiezelooliet)

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

    KzX - KzX - Lid van ongedefinieerd (Formatie van Kiezelooliet)

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

    LA - LA - Groep van Landen

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

    Ld - Ld - Formatie van Lede

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

    Li - Li - Formatie van Lillo

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

    LiKr - LiKr - Lid van Kruisschans (Formatie van Lillo)

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

    LiLu - LiLu - Lid van Luchtbal (Formatie van Lillo)

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

    LiMe - LiMe - Lid van Merksem (Formatie van Lillo)

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

    LiOo - LiOo - Lid van Oorderen (Formatie van Lillo)

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

    LiPd - LiPd - Lid van Poederlee (Formatie van Lillo)

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

    LiX - LiX - Lid van ongedifferentieerd (Formatie van Lillo)

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

    LiZa - LiZa - Lid van Zandvliet (Formatie van Lillo)

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

    Lk - Lk - Formatie van Lanklaar

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

    Ln - Ln - Formatie van Lanaken

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

    MA - MA - Groep van Maas

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

    MAa - MAa - Formatie van Aalburg

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

    MAk - MAk - Formatie van Aachen

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

    MAkAa - MAkAa - Zand van Aachen

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

    MAkHe - MAkHe - Hergenrath

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

    MBe - MBe - Formatie van Bernissart

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

    MBu - MBu - Formatie van Buntsandstein

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

    MBuBr - MBuBr - Lid van Bree (Formatie van Buntsandstein)

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

    MBuBu - MBuBu - Lid van Bullen (Formatie van Buntsandstein)

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

    MBuGr - MBuGr - Lid van Gruitrode (Formatie van Buntsandstein)

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

    MDo - MDo - Formatie van Dorne

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

    MDoB1 - MDoB1 - Beutenaken1

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

    MDoB2 - MDoB2 - Beutenaken2

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

    MDoOv - MDoOv - Onder-Vijlen

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

    MDoZe - MDoZe - Zeven Wegen Equivalent

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

    ME - ME - Groep van Maas

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

    MEs - MEs - Formatie van Esplechin

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

    MGu - MGu - Formatie van Gulpen

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

    MGuBe - MGuBe - Lid van Beutenaken Kalk (Formatie van Gulpen)

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

    MGuLa - MGuLa - Lid van Lanaye (Formatie van Gulpen)

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

    MGuLi - MGuLi - Lid van Lixhe (Formatie van Gulpen)

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

    MGuVi - MGuVi - Lid van Vijlen (Formatie van Gulpen)

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

    MGuZe - MGuZe - Lid van Zeven Wegen (Formatie van Gulpen)

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

    MHa - MHa - Groep van Hainaut

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

    MJU - MJU - Groep van Jura

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

    MKR - MKR - Groep van Krijt

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

    MKe - MKe - Formatie van Keuper

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

    MKu - MKu - Formatie van Kunrade

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

    MMa - MMa - Formatie van Maastricht

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

    MMaKu - MMaKu - Lid van Kunrade (Formatie van Maastricht)

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

    MMaVa - MMaVa - Lid van Valkenburg (Formatie van Maastricht)

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

    MMs - MMs - Formatie van Maisières Chalk

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

    MMu - MMu - Formatie van Muschelkalk

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

    MMuAn - MMuAn - Anhydrit Gruppe

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

    MMuHa - MMuHa - Hauptmuschelkalk

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

    MMuWe - MMuWe - Wellenkalk

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

    MNe - MNe - Formatie van Nevele

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

    MNeSt - MNeSt - Lid van Stekene (Formatie van Nevele)

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

    MNeWa - MNeWa - Lid van Wachtebeke (Formatie van Nevele)

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

    MRo - MRo - Formatie van Röt

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

    MSl - MSl - Formatie van Sleen

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

    MVa - MVa - Formatie van Vaals

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

    MVaBG - MVaBG - Boven Vaalser Groenzand

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

    MVaOG - MVaOG - Onder Vaalser groenzand

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

    MVg - MVg - Formatie van Vert Galand

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

    Ma - Ma - Formatie van Maldegem

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

    MaAs - MaAs - Lid van Asse (Formatie van Maldegem)

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

    MaBu - MaBu - Lid van Buisputten (Formatie van Maldegem)

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

    MaOd - MaOd - Lid van Onderdijke (Formatie van Maldegem)

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

    MaOn - MaOn - Lid van Onderdale (Formatie van Maldegem)

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

    MaUr - MaUr - Lid van Ursel (Formatie van Maldegem)

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

    MaWe - MaWe - Lid van Wemmel (Formatie van Maldegem)

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

    MaZo - MaZo - Lid van Zomergem (Formatie van Maldegem)

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

    Mb - Mb - Formatie van Meulebeke

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

    Me - Me - Formatie van Merksplas

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

    MeB - MeB - Merksplas

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

    Ml - Ml - Formatie van Mol

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

    MlDo - MlDo - Lid van Donk (Formatie van Mol)

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

    MlMa - MlMa - Lid van Maat (Formatie van Mol)

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

    MlMh - MlMh - Lid van Maatheide (Formatie van Mol)

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

    MlRe - MlRe - Lid van Rees (Formatie van Mol)

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

    MlRt - MlRt - Lid van Retie (Formatie van Mol)

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

    MlRu - MlRu - Lid van Russendorp (Formatie van Mol)

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

    Mn - Mn - Formatie van Molenbeersel

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

    Mo - Mo - Formatie van Mons

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

    Mp - Mp - Formatie van Mons-en-Pévèle

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

    Mx - Mx - Formatie van Melle

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

    My - My - Formatie van Malle

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

    Ne - Ne - Groep van Neogeen

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

    Op - Op - Formatie van Opglabbeek

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

    OpEi - OpEi - Lid van Eisden (Formatie van Opglabbeek)

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

    OpMa - OpMa - Lid van Maasmechelen (Formatie van Opglabbeek)

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

    OpOp - OpOp - Lid van Opoeteren (Formatie van Opglabbeek)

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

    Or - Or - Groep van Ordovicium

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

    Ot - Ot - Formatie van Oostende

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

    Ow - Ow - Formatie van Oostwinkel

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

    P - P - Groep van Paleozoïcum

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

    P1 - P1 - Groep van Onder Paleozoïcum

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

    P2 - P2 - Groep van Boven Paleozoïcum

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

    PAi - PAi - Formatie van Aisemont

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

    PAl - PAl - Formatie van Alvaux

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

    PAn - PAn - Formatie van Andenne

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

    PAt - PAt - Formatie van Antoing

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

    PAtGa - PAtGa - Lid van Gaurain-Ramecroix (Formatie van Antoing)

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

    PAtWa - PAtWa - Lid van Warchin (Formatie van Antoing)

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

    PAv - PAv - Formatie van Abbaye de Villers

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

    PBe - PBe - Formatie van Berneau

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

    PBg - PBg - Formatie van Bellegem

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

    PBi - PBi - Formatie van Booischot

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

    PBl - PBl - Formatie van Blanmont

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

    PBn - PBn - Formatie van Bornival

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

    PBnXa - PBnXa - Lid van Lid niet benoemd (Formatie van Bornival)

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

    PBnXb - PBnXb - Lid van Lid niet benoemd (Formatie van Bornival)

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

    PBnXc - PBnXc - Lid van Lid niet benoemd (Formatie van Bornival)

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

    PBo - PBo - Formatie van Bosscheveld

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

    PBp - PBp - Formatie van Bois Grand-Père

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

    PBr - PBr - Formatie van Brûtia

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

    PBv - PBv - Formatie van Bovesse

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

    PC - PC - Groep van Condroz

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

    PCa - PCa - Formatie van Châtelet

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

    PCaFl - PCaFl - Lid van Floriffoux (Formatie van Châtelet)

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

    PCaRa - PCaRa - Lid van Ransart (Formatie van Châtelet)

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

    PCe - PCe - Formatie van Chevlipont

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

    PCh - PCh - Formatie van Charleroi

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

    PChAs - PChAs - Lid van As (Formatie van Charleroi)

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

    PChEi - PChEi - Lid van Eikenberg (Formatie van Charleroi)

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

    PChMo - PChMo - Lid van Mons (Formatie van Charleroi)

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

    PCo - PCo - Formatie van Chokier

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

    PCoBo - PCoBo - Lid van Bois-et-Borsu (Formatie van Chokier)

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

    PCoTr - PCoTr - Lid van Tramaka (Formatie van Chokier)

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

    PCr - PCr - Formatie van Corroy

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

    PDe - PDe - Formatie van Deerlijk

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

    PEt - PEt - Formatie van Etroeungt

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

    PEv - PEv - Formatie van Evieux

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

    PF - PF - Groep van Frasne

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

    PFa - PFa - Groep van Famenne

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

    PFf - PFf - Formatie van Froide Fontaine

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

    PFi - PFi - Formatie van Fallais

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

    PFiPi - PFiPi - Lid van Pitet (Formatie van Fallais)

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

    PFiXa - PFiXa - Lid van Lid A (Formatie van Fallais)

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

    PFiXb - PFiXb - Lid van Lid B (Formatie van Fallais)

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

    PFiXc - PFiXc - Lid van Lid C (Formatie van Fallais)

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

    PFiXd - PFiXd - Lid van Lid D (Formatie van Fallais)

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

    PFiXe - PFiXe - Lid van Lid E (Formatie van Fallais)

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

    PFl - PFl - Formatie van Flénu

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

    PFlMe - PFlMe - Lid van Meeuwen (Formatie van Flénu)

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

    PFlNe - PFlNe - Lid van Neerglabbeek (Formatie van Flénu)

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

    PFlWa - PFlWa - Lid van Wasmes (Formatie van Flénu)

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

    PFq - PFq - Formatie van Fauquez

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

    PFr - PFr - Formatie van Franc-Waret

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

    PFu - PFu - Formatie van Fumal

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

    PG - PG - Groep van Givet

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

    PGe - PGe - Formatie van Goeree

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

    PGo - PGo - Formatie van Gottignies

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

    PHe - PHe - Formatie van Helchteren

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

    PHeH1 - PHeH1 - Helchteren1

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

    PHeH2 - PHeH2 - Helchteren2

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

    PHeH3 - PHeH3 - Helchteren3

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

    PHeH4 - PHeH4 - Helchteren4

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

    PHeH5 - PHeH5 - Helchteren5

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

    PHi - PHi - Formatie van Heibaart

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

    PHo - PHo - Formatie van Hosdin

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

    PHs - PHs - Formatie van Hastière

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

    PHu - PHu - Formatie van Huet

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

    PIt - PIt - Formatie van Ittre

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

    PJo - PJo - Formatie van Jodoigne

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

    PK - PK - Groep van Kolenkalk

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

    PKe - PKe - Formatie van Kessel

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

    PLa - PLa - Formatie van Landelies

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

    PLm - PLm - Formatie van Lambermont

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

    PLo - PLo - Formatie van Loenhout

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

    PLs - PLs - Formatie van Lust

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

    PLt - PLt - Formatie van Latinne

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

    PLu - PLu - Formatie van Lustin

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

    PMa - PMa - Formatie van Mazy

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

    PMd - PMd - Formatie van Madot

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

    PMdXa - PMdXa - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXb - PMdXb - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXc - PMdXc - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXd - PMdXd - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXe - PMdXe - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXf - PMdXf - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMdXg - PMdXg - Lid van Lid niet benoemd (Formatie van Madot)

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

    PMn - PMn - Formatie van Montfort

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

    PMo - PMo - Formatie van Mousty

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

    PMoFr - PMoFr - Lid van Franquenies (Formatie van Mousty)

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

    PMoTa - PMoTa - Lid van Tangissart (Formatie van Mousty)

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

    PMoXx - PMoXx - Lid van Lid niet benoemd (Formatie van Mousty)

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

    PMu - PMu - Formatie van Mautiennes

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

    PNe - PNe - Formatie van Neeroeteren

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

    POD - POD - Ordovicium

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

    POr - POr - Formatie van Orient

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

    POs - POs - Formatie van Oisquercq

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

    POsAs - POsAs - Lid van Asquempont (Formatie van Oisquercq)

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

    POsRi - POsRi - Lid van Ripain (Formatie van Oisquercq)

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

    PPe - PPe - Formatie van Pecq

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

    PPo - PPo - Formatie van Pont d'Arcole

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

    PPr - PPr - Formatie van Presles

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

    PPt - PPt - Formatie van Petit-Roeulx

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

    PRh - PRh - Formatie van Rhisnes

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

    PRi - PRi - Formatie van Rigenée

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

    PRk - PRk - Formatie van Rekkem

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

    PRn - PRn - Formatie van Ronquières

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

    PSa - PSa - Formatie van Samme

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

    PSaBo - PSaBo - Lid van Bois de la Rocq (Formatie van Samme)

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

    PSaFe - PSaFe - Lid van Feluy (Formatie van Samme)

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

    PSaMe - PSaMe - Lid van Mévergnies (Formatie van Samme)

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

    PSe - PSe - Formatie van Steenkerque

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

    PSo - PSo - Formatie van Souvré

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

    PSt - PSt - Formatie van Steentje-Turnhout

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

    PTo - PTo - Formatie van Tournai

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

    PToAl - PToAl - Lid van Allain (Formatie van Tournai)

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

    PToCr - PToCr - Lid van Crampon (Formatie van Tournai)

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

    PToPo - PToPo - Lid van Point-à-Rieu (Formatie van Tournai)

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

    PToPr - PToPr - Lid van Providence (Formatie van Tournai)

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

    PToVa - PToVa - Lid van Vaulx (Formatie van Tournai)

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

    PToVi - PToVi - Lid van Vignobles (Formatie van Tournai)

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

    PTr - PTr - Formatie van Tribotte

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

    PTu - PTu - Formatie van Tubize

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

    PTuFo - PTuFo -

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

    PTuRo - PTuRo -

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

    PTuXx - PTuXx -

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

    PVa - PVa - Formatie van Les Vallées

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

    PVc - PVc - Formatie van Vichenet

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

    PVe - PVe - Formatie van Vesdre

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

    PVi - PVi - Formatie van Visé

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

    PVl - PVl - Formatie van Velp

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

    PVs - PVs - Formatie van Vissoul

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

    Pa - Pa - Paleogeen

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

    Pd - Pd - Formatie van Poederlee

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

    PdHe - PdHe - Lid van Heieinde (Formatie van Poederlee)

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

    Q - Q - Groep van Quartaire afzetting

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

    QH - QH - Quartair Holoceen

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

    QP - QP - Quartair Pleistoceen

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

    RO - RO - Groep van Romont

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

    RU - RU - Groep van Rupel

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

    Rb - Rb - Formatie van Rozebeke

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

    S - S - Primair

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

    SC - SC - Groep van Schelde

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

    Sh - Sh - Formatie van Sint Huibrechts Hern

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

    ShGr - ShGr - Lid van Grimmertingen (Formatie van Sint Huibrechts Hern)

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

    ShNe - ShNe - Lid van Neerrepen (Formatie van Sint Huibrechts Hern)

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

    Si - Si - Groep van Siluur

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

    Sk - Sk - Formatie van Stokkem

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

    St - St - Formatie van Sterksel

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

    StBo - StBo - Lid van Bocholt (Formatie van Sterksel)

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

    StHa - StHa - Lid van Hamont (Formatie van Sterksel)

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

    StLo - StLo - Lid van Lommel (Formatie van Sterksel)

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

    T - T - Tertiaire afzetting

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

    TO - TO - Groep van Tongeren

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

    TR - TR - Groep van Trias

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

    Ti - Ti - Formatie van Tienen

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

    TiDo - TiDo - Lid van Dormaal (Formatie van Tienen)

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

    TiEr - TiEr - Lid van Erquelinne (Formatie van Tienen)

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

    TiKn - TiKn - Lid van Knokke (Formatie van Tienen)

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

    TiLo - TiLo - Lid van Loksbergen (Formatie van Tienen)

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

    Tt - Tt - Formatie van Tielt

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

    TtEg - TtEg - Lid van Egem (Formatie van Tielt)

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

    TtEk - TtEk - Lid van Egemkapel (Formatie van Tielt)

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

    TtKo - TtKo - Lid van Kortemark (Formatie van Tielt)

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

    U - U - Onbekend

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

    Vd - Vd - Formatie van Veldhoven

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

    VdSo - VdSo - Lid van Someren (Formatie van Veldhoven)

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

    VdVo - VdVo - Lid van Voort (Formatie van Veldhoven)

    \n", "
    \n", " \n", " \n", "
    \n", "

    VdWi - VdWi - Lid van Wintelre (Formatie van Veldhoven)

    \n", "
    \n", " \n", " \n", "
    \n", "

    Ve - Ve - Formatie van Veldwezelt

    \n", "
    \n", " \n", " \n", "
    \n", "

    Vh - Vh - Formatie van Vlaamse Heuvels

    \n", "
    \n", " \n", " \n", "
    \n", "

    Vl - Vl - Formatie van Vlaanderen

    \n", "
    \n", " \n", " \n", "
    \n", "

    VlCa - VlCa - Lid van Calais (Formatie van Vlaanderen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    VlDh - VlDh - Lid van De Haan (Formatie van Vlaanderen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    VlDu - VlDu - Lid van Dunkerque (Formatie van Vlaanderen)

    \n", "
    \n", " \n", " \n", "
    \n", "

    Vo - Vo - Formatie van Voort

    \n", "
    \n", " \n", " \n", "
    \n", "

    VoSo - VoSo - Lid van Someren (Formatie van Voort)

    \n", "
    \n", " \n", " \n", "
    \n", "

    VoVe - VoVe - Lid van Veldhoven (Formatie van Voort)

    \n", "
    \n", " \n", " \n", "
    \n", "

    VoVo - VoVo - Lid van Voort (Formatie van Voort)

    \n", "
    \n", " \n", " \n", "
    \n", "

    We - We - Formatie van Weelde

    \n", "
    \n", " \n", " \n", "
    \n", "

    WeBs - WeBs - Lid van Beerse (Formatie van Weelde)

    \n", "
    \n", " \n", " \n", "
    \n", "

    WeRv - WeRv - Lid van Rijkevorsel (Formatie van Weelde)

    \n", "
    \n", " \n", " \n", "
    \n", "

    WeTu - WeTu - Lid van Turnhout (Formatie van Weelde)

    \n", "
    \n", " \n", " \n", "
    \n", "

    Wu - Wu - Formatie van Wurfeld

    \n", "
    \n", " \n", " \n", "
    \n", "

    ZE - ZE - Groep van Zenne

    \n", "
    \n", " \n", " \n", "
    \n", "

    Zd - Zd - Formatie van Zutendaal

    \n", "
    \n", " \n", " \n", "
    \n", "

    Zz - Zz - Formatie van Zelzate

    \n", "
    \n", " \n", " \n", "
    \n", "

    ZzBa - ZzBa - Lid van Bassevelde (Formatie van Zelzate)

    \n", "
    \n", " \n", " \n", "
    \n", "

    ZzRu - ZzRu - Lid van Ruisbroek (Formatie van Zelzate)

    \n", "
    \n", " \n", " \n", "
    \n", "

    ZzWa - ZzWa - Lid van Watervliet (Formatie van Zelzate)

    \n", "
    \n", " \n", "
    \n", "
\n", "
\n", " \n", " \n", "
\n", "

pkey_boring - URL die verwijst naar de gegevens van de boring waaraan deze interpretatie gekoppeld is (indien gekoppeld aan een boring).

  • type: string
  • notnull: False
  • query: False
  • cost: 1
  • multivalue: False
\n", "
\n", " \n", " \n", "
\n", "

pkey_sondering - URL die verwijst naar de gegevens van de sondering waaraan deze interpretatie gekoppeld is (indien gekoppeld aan een sondering).

  • type: string
  • notnull: False
  • query: False
  • cost: 1
  • multivalue: False
\n", "
\n", "

\n", "
\n", " " ], "text/plain": [ "" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "itp" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Example use cases" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get 'Formele stratigrafie' in a bounding box" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Get data for all the 'Formele stratigrafie' interpretations that are geographically located within the bounds of the specified box.\n", "\n", "The coordinates are in the Belgian Lambert72 (EPSG:31370) coordinate system and are given in the order of lower left x, lower left y, upper right x, upper right y." ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/001] .\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", "
pkey_interpretatiepkey_boringpkey_sonderingbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1relatie_lid1_lid2lid2
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...NaNonbekend153147.0206931.014.120.03.00QTQ
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...NaNonbekend153147.0206931.014.123.014.05UTBc
\n", "
" ], "text/plain": [ " pkey_interpretatie \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... \n", "1 https://www.dov.vlaanderen.be/data/interpretat... \n", "\n", " pkey_boring pkey_sondering \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1974... NaN \n", "1 https://www.dov.vlaanderen.be/data/boring/1974... NaN \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 onbekend 153147.0 206931.0 14.12 \n", "1 onbekend 153147.0 206931.0 14.12 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 relatie_lid1_lid2 lid2 \n", "0 0.0 3.00 Q T Q \n", "1 3.0 14.05 U T Bc " ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from pydov.util.location import Within, Box\n", "\n", "df = itp.search(location=Within(Box(153145, 206930, 153150, 206935, epsg=31370)))\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The dataframe contains one 'Formele stratigrafie' interpretation where two layers ('laag') were identified. The available data are flattened to represent unique attributes per row of the dataframe.\n", "\n", "Using the *pkey_interpretatie* field one can request the details of this interpretation in a webbrowser:" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "https://www.dov.vlaanderen.be/data/interpretatie/2000-001087\n" ] } ], "source": [ "for pkey_interpretatie in set(df.pkey_interpretatie):\n", " print(pkey_interpretatie)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Using the field's *values* information, we can translate the stratigraphical codes to human readable layers:" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiediepte_laag_vandiepte_laag_totlid1lid1_lbrelatie_lid1_lid2lid2lid2_lb
0https://www.dov.vlaanderen.be/data/interpretat...0.03.00QGroep van Quartaire afzettingTQGroep van Quartaire afzetting
1https://www.dov.vlaanderen.be/data/interpretat...3.014.05UOnbekendTBcFormatie van Berchem
\n", "
" ], "text/plain": [ " pkey_interpretatie diepte_laag_van \\\n", "0 https://www.dov.vlaanderen.be/data/interpretat... 0.0 \n", "1 https://www.dov.vlaanderen.be/data/interpretat... 3.0 \n", "\n", " diepte_laag_tot lid1 lid1_lb relatie_lid1_lid2 lid2 \\\n", "0 3.00 Q Groep van Quartaire afzetting T Q \n", "1 14.05 U Onbekend T Bc \n", "\n", " lid2_lb \n", "0 Groep van Quartaire afzetting \n", "1 Formatie van Berchem " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['lid1_lb'] = df['lid1'].map(fields['lid1']['codelist'].get_definition)\n", "df['lid2_lb'] = df['lid2'].map(fields['lid2']['codelist'].get_definition)\n", "df[['pkey_interpretatie', 'diepte_laag_van', 'diepte_laag_tot', 'lid1', 'lid1_lb', 'relatie_lid1_lid2', 'lid2', 'lid2_lb']]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get 'Formele stratigrafie' with specific properties" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Next to querying interpretations based on their geographic location within a bounding box, we can also search for interpretations matching a specific set of properties. For this we can build a query using a combination of the 'FormeleStratigrafie' fields and operators provided by the WFS protocol.\n", "\n", "A list of possible operators can be found below:" ] }, { "cell_type": "code", "execution_count": 10, "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": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "[i for i,j in inspect.getmembers(sys.modules['owslib.fes2'], inspect.isclass) if 'Property' in i]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "In this example we build a query using the *PropertyIsGreaterThan* and *PropertyIsEqualTo* operators to find all interpretations that are at least 20 m deep, that are deemed appropriate for a range of 1 km from a defined point:" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/008] ........\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", "
pkey_interpretatiepkey_boringpkey_sonderingbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1relatie_lid1_lid2lid2
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1972...NaNgoed153906.0207506.016.000.001.25ATA
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1972...NaNgoed153906.0207506.016.001.252.25ElOGt
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1972...NaNgoed153906.0207506.016.002.2522.25BcTBc
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1972...NaNgoed153906.0207506.016.0022.2523.00BmTBm
4https://www.dov.vlaanderen.be/data/interpretat...NaNhttps://www.dov.vlaanderen.be/data/sondering/1...goed153898.0207038.014.880.004.20QTQ
\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/1972... \n", "1 https://www.dov.vlaanderen.be/data/boring/1972... \n", "2 https://www.dov.vlaanderen.be/data/boring/1972... \n", "3 https://www.dov.vlaanderen.be/data/boring/1972... \n", "4 NaN \n", "\n", " pkey_sondering \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 https://www.dov.vlaanderen.be/data/sondering/1... \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 goed 153906.0 207506.0 16.00 \n", "1 goed 153906.0 207506.0 16.00 \n", "2 goed 153906.0 207506.0 16.00 \n", "3 goed 153906.0 207506.0 16.00 \n", "4 goed 153898.0 207038.0 14.88 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 relatie_lid1_lid2 lid2 \n", "0 0.00 1.25 A T A \n", "1 1.25 2.25 El O Gt \n", "2 2.25 22.25 Bc T Bc \n", "3 22.25 23.00 Bm T Bm \n", "4 0.00 4.20 Q T Q " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from owslib.fes2 import And, PropertyIsGreaterThan, PropertyIsEqualTo\n", "from pydov.util.location import WithinDistance, Point\n", "\n", "query = And([PropertyIsEqualTo(propertyname='Betrouwbaarheid',\n", " literal='goed'),\n", " PropertyIsGreaterThan(propertyname='diepte_tot_m',\n", " literal='20'),\n", " ])\n", " \n", "df = itp.search(query=query, \n", " location=WithinDistance(Point(153145, 206930, epsg=31370), 1000))\n", "\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Once again we can use the *pkey_interpretatie* as a permanent link to the information of these interpretations:" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "https://www.dov.vlaanderen.be/data/interpretatie/2006-240085\n", "https://www.dov.vlaanderen.be/data/interpretatie/2006-240153\n", "https://www.dov.vlaanderen.be/data/interpretatie/2006-240082\n", "https://www.dov.vlaanderen.be/data/interpretatie/2006-240081\n", "https://www.dov.vlaanderen.be/data/interpretatie/2006-240080\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372783\n", "https://www.dov.vlaanderen.be/data/interpretatie/2006-240083\n", "https://www.dov.vlaanderen.be/data/interpretatie/2006-240086\n" ] } ], "source": [ "for pkey_interpretatie in set(df.pkey_interpretatie):\n", " print(pkey_interpretatie)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get 'Formele stratigrafie' in a bounding box based on specific properties" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We can combine a query on attributes with a query on geographic location to get the interpretations within a bounding box that have specific properties.\n", "\n", "The following example requests the interpretations of boreholes only, within the given bounding box.\n", "\n", "(Note that the datatype of the *literal* parameter should be a string, regardless of the datatype of this field in the output dataframe.)" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n", "[000/052] ..........c.............................c.........\n", "[050/052] ..\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", "
pkey_interpretatiepkey_boringpkey_sonderingbetrouwbaarheid_interpretatiexystart_interpretatie_mtawdiepte_laag_vandiepte_laag_totlid1relatie_lid1_lid2lid2
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1895...NaNgoed153400.0207400.020.000.01.90QTQ
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1895...NaNgoed153400.0207400.020.001.92.40BcTBc
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...NaNonbekend153162.0207053.014.460.02.00QTQ
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...NaNonbekend153162.0207053.014.462.06.85BcTBc
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1974...NaNonbekend153174.0207102.015.670.03.00QTQ
\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 pkey_sondering \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1895... NaN \n", "1 https://www.dov.vlaanderen.be/data/boring/1895... NaN \n", "2 https://www.dov.vlaanderen.be/data/boring/1974... NaN \n", "3 https://www.dov.vlaanderen.be/data/boring/1974... NaN \n", "4 https://www.dov.vlaanderen.be/data/boring/1974... NaN \n", "\n", " betrouwbaarheid_interpretatie x y start_interpretatie_mtaw \\\n", "0 goed 153400.0 207400.0 20.00 \n", "1 goed 153400.0 207400.0 20.00 \n", "2 onbekend 153162.0 207053.0 14.46 \n", "3 onbekend 153162.0 207053.0 14.46 \n", "4 onbekend 153174.0 207102.0 15.67 \n", "\n", " diepte_laag_van diepte_laag_tot lid1 relatie_lid1_lid2 lid2 \n", "0 0.0 1.90 Q T Q \n", "1 1.9 2.40 Bc T Bc \n", "2 0.0 2.00 Q T Q \n", "3 2.0 6.85 Bc T Bc \n", "4 0.0 3.00 Q T Q " ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from owslib.fes2 import PropertyIsEqualTo\n", "\n", "query = PropertyIsEqualTo(\n", " propertyname='Type_proef',\n", " literal='Boring')\n", "\n", "df = itp.search(\n", " location=Within(Box(153145, 206930, 154145, 207930, epsg=31370)),\n", " query=query\n", " )\n", "\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We can look at one of the interpretations in a webbrowser using its *pkey_interpretatie*:" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "https://www.dov.vlaanderen.be/data/interpretatie/2023-372912\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023809\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372915\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372903\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023815\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372885\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372919\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372917\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-001313\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372871\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023811\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372913\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372639\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372710\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023869\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-000327\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372895\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007698\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-006799\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023807\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007739\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007696\n", "https://www.dov.vlaanderen.be/data/interpretatie/1999-007793\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372916\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-001088\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023813\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372870\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023808\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007740\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007697\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-001378\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007699\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372660\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372909\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007694\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-371952\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372910\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372869\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372783\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023870\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-001087\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372847\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-007695\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372664\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372920\n", "https://www.dov.vlaanderen.be/data/interpretatie/2000-023816\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372868\n", "https://www.dov.vlaanderen.be/data/interpretatie/2024-385637\n", "https://www.dov.vlaanderen.be/data/interpretatie/2024-385640\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372914\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372918\n", "https://www.dov.vlaanderen.be/data/interpretatie/2023-372867\n" ] } ], "source": [ "for pkey_interpretatie in set(df.pkey_interpretatie):\n", " print(pkey_interpretatie)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Select 'Formele stratigrafie' in a municipality and return date" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We can limit the columns in the output dataframe by specifying the *return_fields* parameter in our search.\n", "\n", "In this example we query all the 'Formele stratigrafie' interpretations in a distance of 1 km and return their date:" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\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", "
Datum
02000-02-02
12000-02-02
22000-02-02
32000-02-02
41999-03-01
\n", "
" ], "text/plain": [ " Datum\n", "0 2000-02-02\n", "1 2000-02-02\n", "2 2000-02-02\n", "3 2000-02-02\n", "4 1999-03-01" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = itp.search(location=WithinDistance(Point(153145, 206930, epsg=31370), 1000),\n", " return_fields=('Datum',))\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Datum
count62
unique10
top2000-05-20
freq23
\n", "
" ], "text/plain": [ " Datum\n", "count 62\n", "unique 10\n", "top 2000-05-20\n", "freq 23" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.describe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get 'Formele stratigrafie' based on fields not available in the standard output dataframe" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To keep the output dataframe size acceptable, not all available WFS fields are included in the standard output. However, one can use this information to select interpretations as illustrated below.\n", "\n", "For example, make a selection of the interpretations in municipality the of Antwerp, before 1/1/1990:\n", "\n", "!*remark: mind that the municipality attribute is merely an attribute that is defined by the person entering the data. It can be ok, empty, outdated or wrong*!" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatieDatum
0https://www.dov.vlaanderen.be/data/interpretat...1984-09-10
\n", "
" ], "text/plain": [ " pkey_interpretatie Datum\n", "0 https://www.dov.vlaanderen.be/data/interpretat... 1984-09-10" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from owslib.fes2 import And, PropertyIsEqualTo, PropertyIsLessThan\n", "\n", "query = And([PropertyIsEqualTo(propertyname='gemeente',\n", " literal='Antwerpen'),\n", " PropertyIsLessThan(propertyname='Datum', \n", " literal='1990-01-01')]\n", " )\n", "df = itp.search(query=query,\n", " return_fields=('pkey_interpretatie', 'Datum'))\n", "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get 'Formele stratigrafie' data, returning fields not available in the standard output dataframe" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "As denoted in the previous example, not all available fields are available in the default output frame to keep its size limited. However, you can request any available field by including it in the *return_fields* parameter of the search:" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[000/001] .\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
pkey_interpretatiepkey_boringpkey_sonderingxystart_interpretatie_mtawgemeenteAuteursProefnummer
0https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1989...NaN173294.0179226.017.5LeuvenSevens, E. - bedrijf-dienst onbekendkb24d74e-B141
1https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1914...NaN172656.0179837.017.0LeuvenSevens, E. - bedrijf-dienst onbekendkb24d74e-B358
2https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1893...NaN173428.0179002.016.0LeuvenSevens, E. - bedrijf-dienst onbekendkb24d74e-B4
3https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1893...NaN173517.0178945.015.0LeuvenSevens, E. - bedrijf-dienst onbekendkb24d74e-B5
4https://www.dov.vlaanderen.be/data/interpretat...https://www.dov.vlaanderen.be/data/boring/1894...NaN173855.0179683.016.0LeuvenSevens, E. - bedrijf-dienst onbekendkb24d74e-B9
\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 pkey_sondering x \\\n", "0 https://www.dov.vlaanderen.be/data/boring/1989... NaN 173294.0 \n", "1 https://www.dov.vlaanderen.be/data/boring/1914... NaN 172656.0 \n", "2 https://www.dov.vlaanderen.be/data/boring/1893... NaN 173428.0 \n", "3 https://www.dov.vlaanderen.be/data/boring/1893... NaN 173517.0 \n", "4 https://www.dov.vlaanderen.be/data/boring/1894... NaN 173855.0 \n", "\n", " y start_interpretatie_mtaw gemeente \\\n", "0 179226.0 17.5 Leuven \n", "1 179837.0 17.0 Leuven \n", "2 179002.0 16.0 Leuven \n", "3 178945.0 15.0 Leuven \n", "4 179683.0 16.0 Leuven \n", "\n", " Auteurs Proefnummer \n", "0 Sevens, E. - bedrijf-dienst onbekend kb24d74e-B141 \n", "1 Sevens, E. - bedrijf-dienst onbekend kb24d74e-B358 \n", "2 Sevens, E. - bedrijf-dienst onbekend kb24d74e-B4 \n", "3 Sevens, E. - bedrijf-dienst onbekend kb24d74e-B5 \n", "4 Sevens, E. - bedrijf-dienst onbekend kb24d74e-B9 " ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "query = PropertyIsEqualTo(\n", " propertyname='gemeente',\n", " literal='Leuven')\n", "\n", "df = itp.search(query=query,\n", " return_fields=('pkey_interpretatie', 'pkey_boring', 'pkey_sondering',\n", " 'x', 'y', 'start_interpretatie_mtaw', 'gemeente', 'Auteurs', 'Proefnummer'))\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": 19, "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": 20, "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": 21, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Make this Notebook Trusted to load map: File -> Trust Notebook
" ], "text/plain": [ "" ] }, "execution_count": 21, "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['Proefnummer'][loc]).add_to(marker_cluster)\n", "fmap\n" ] } ], "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 }