{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "32a1a143",
   "metadata": {},
   "source": [
    "# 2. Get data of a SoilProfile"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0",
   "metadata": {},
   "outputs": [],
   "source": [
    "import dutchsoils as ds"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "287d50bf",
   "metadata": {},
   "source": [
    "## 2.0. Get soil profile"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c483a006",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get soil profile\n",
    "sp = ds.SoilProfile.from_bofekcluster(1008)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5",
   "metadata": {},
   "source": [
    "## 2.1. Get all data (default)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "layernumber",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "faohorizonnotation",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "ztop",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "zbottom",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "staringseriesblock",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "organicmattercontent",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "organicmattercontent10p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "organicmattercontent90p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "acidity",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "acidity10p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "acidity90p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "cnratio",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "peattype",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "calciccontent",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "fedith",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "loamcontent",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "loamcontent10p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "loamcontent90p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "lutitecontent",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "lutitecontent10p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "lutitecontent90p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "sandmedian",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "sandmedian10p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "sandmedian90p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "siltcontent",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "density",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "wcres",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "wcsat",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "vgmalpha",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "vgmnpar",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "vgmlambda",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "ksatfit",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "staringblockdescription",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "staringblocklabel",
         "rawType": "object",
         "type": "string"
        }
       ],
       "ref": "6e70a927-ff84-4de1-a2c0-5a052a507297",
       "rows": [
        [
         "0",
         "1",
         "Ahg",
         "0.0",
         "0.1",
         "B17",
         "20.0",
         "10.0",
         "30.0",
         "5.0",
         "4.5",
         "5.5",
         "12",
         null,
         "0.0",
         "2.1",
         "75",
         "40",
         "90",
         "40",
         "25",
         "60",
         "140",
         "110",
         "170",
         "35",
         "0.641",
         "0.0",
         "0.71862598",
         "0.01906191",
         "1.1366583",
         "0.0001",
         "4.48373535",
         "venige klei",
         "venige klei"
        ],
        [
         "1",
         "2",
         "Cwg",
         "0.1",
         "0.35",
         "O13",
         "7.0",
         "5.0",
         "30.0",
         "5.0",
         "4.5",
         "5.5",
         "14",
         null,
         "0.0",
         "2.0",
         "90",
         "70",
         "100",
         "55",
         "40",
         "70",
         "110",
         "90",
         "130",
         "35",
         "1.044",
         "0.01",
         "0.573268",
         "0.02785405",
         "1.07995207",
         "-6.09131057",
         "9.68929074",
         "zeer zware klei",
         "z.zw. klei"
        ],
        [
         "2",
         "3",
         "Cw",
         "0.35",
         "0.8",
         "O17",
         "75.0",
         "60.0",
         "90.0",
         "5.0",
         "4.7",
         "5.5",
         "22",
         "zeggeveen",
         "0.0",
         "1.4",
         "75",
         "45",
         "85",
         "18",
         "6",
         "30",
         "125",
         "110",
         "140",
         "57",
         "0.232",
         "0.01",
         "0.84863548",
         "0.01192909",
         "1.27153561",
         "-1.24929996",
         "3.40200949",
         "mesotroof en eutroof veen",
         "meso-eutroof veen"
        ],
        [
         "3",
         "4",
         "BCb",
         "0.8",
         "0.95",
         "O01",
         "3.0",
         "1.0",
         "8.0",
         "4.8",
         "4.5",
         "5.2",
         "22",
         null,
         "0.0",
         "0.4",
         "8",
         "5",
         "20",
         "2",
         "1",
         "4",
         "160",
         "140",
         "180",
         "6",
         "1.545",
         "0.01",
         "0.36584689",
         "0.01598691",
         "2.16275113",
         "2.8679672",
         "22.32215442",
         "leemarm zeer fijn tot matig fijn zand",
         "leemarm z.f.-m.f. zand"
        ],
        [
         "4",
         "5",
         "Cu",
         "0.95",
         "1.2",
         "O01",
         "0.4",
         "0.1",
         "3.0",
         "4.8",
         "4.5",
         "5.2",
         "22",
         null,
         "0.0",
         "0.3",
         "8",
         "5",
         "20",
         "2",
         "1",
         "4",
         "160",
         "140",
         "180",
         "6",
         "1.668",
         "0.01",
         "0.36584689",
         "0.01598691",
         "2.16275113",
         "2.8679672",
         "22.32215442",
         "leemarm zeer fijn tot matig fijn zand",
         "leemarm z.f.-m.f. zand"
        ]
       ],
       "shape": {
        "columns": 34,
        "rows": 5
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>layernumber</th>\n",
       "      <th>faohorizonnotation</th>\n",
       "      <th>ztop</th>\n",
       "      <th>zbottom</th>\n",
       "      <th>staringseriesblock</th>\n",
       "      <th>organicmattercontent</th>\n",
       "      <th>organicmattercontent10p</th>\n",
       "      <th>organicmattercontent90p</th>\n",
       "      <th>acidity</th>\n",
       "      <th>acidity10p</th>\n",
       "      <th>...</th>\n",
       "      <th>siltcontent</th>\n",
       "      <th>density</th>\n",
       "      <th>wcres</th>\n",
       "      <th>wcsat</th>\n",
       "      <th>vgmalpha</th>\n",
       "      <th>vgmnpar</th>\n",
       "      <th>vgmlambda</th>\n",
       "      <th>ksatfit</th>\n",
       "      <th>staringblockdescription</th>\n",
       "      <th>staringblocklabel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Ahg</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.10</td>\n",
       "      <td>B17</td>\n",
       "      <td>20.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>...</td>\n",
       "      <td>35</td>\n",
       "      <td>0.641</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.718626</td>\n",
       "      <td>0.019062</td>\n",
       "      <td>1.136658</td>\n",
       "      <td>0.000100</td>\n",
       "      <td>4.483735</td>\n",
       "      <td>venige klei</td>\n",
       "      <td>venige klei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Cwg</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.35</td>\n",
       "      <td>O13</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>...</td>\n",
       "      <td>35</td>\n",
       "      <td>1.044</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.573268</td>\n",
       "      <td>0.027854</td>\n",
       "      <td>1.079952</td>\n",
       "      <td>-6.091311</td>\n",
       "      <td>9.689291</td>\n",
       "      <td>zeer zware klei</td>\n",
       "      <td>z.zw. klei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Cw</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.80</td>\n",
       "      <td>O17</td>\n",
       "      <td>75.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>...</td>\n",
       "      <td>57</td>\n",
       "      <td>0.232</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.848635</td>\n",
       "      <td>0.011929</td>\n",
       "      <td>1.271536</td>\n",
       "      <td>-1.249300</td>\n",
       "      <td>3.402009</td>\n",
       "      <td>mesotroof en eutroof veen</td>\n",
       "      <td>meso-eutroof veen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>BCb</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.95</td>\n",
       "      <td>O01</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1.545</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.365847</td>\n",
       "      <td>0.015987</td>\n",
       "      <td>2.162751</td>\n",
       "      <td>2.867967</td>\n",
       "      <td>22.322154</td>\n",
       "      <td>leemarm zeer fijn tot matig fijn zand</td>\n",
       "      <td>leemarm z.f.-m.f. zand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Cu</td>\n",
       "      <td>0.95</td>\n",
       "      <td>1.20</td>\n",
       "      <td>O01</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1.668</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.365847</td>\n",
       "      <td>0.015987</td>\n",
       "      <td>2.162751</td>\n",
       "      <td>2.867967</td>\n",
       "      <td>22.322154</td>\n",
       "      <td>leemarm zeer fijn tot matig fijn zand</td>\n",
       "      <td>leemarm z.f.-m.f. zand</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   layernumber faohorizonnotation  ztop  zbottom staringseriesblock  \\\n",
       "0            1                Ahg  0.00     0.10                B17   \n",
       "1            2                Cwg  0.10     0.35                O13   \n",
       "2            3                 Cw  0.35     0.80                O17   \n",
       "3            4                BCb  0.80     0.95                O01   \n",
       "4            5                 Cu  0.95     1.20                O01   \n",
       "\n",
       "   organicmattercontent  organicmattercontent10p  organicmattercontent90p  \\\n",
       "0                  20.0                     10.0                     30.0   \n",
       "1                   7.0                      5.0                     30.0   \n",
       "2                  75.0                     60.0                     90.0   \n",
       "3                   3.0                      1.0                      8.0   \n",
       "4                   0.4                      0.1                      3.0   \n",
       "\n",
       "   acidity  acidity10p  ...  siltcontent  density wcres     wcsat  vgmalpha  \\\n",
       "0      5.0         4.5  ...           35    0.641  0.00  0.718626  0.019062   \n",
       "1      5.0         4.5  ...           35    1.044  0.01  0.573268  0.027854   \n",
       "2      5.0         4.7  ...           57    0.232  0.01  0.848635  0.011929   \n",
       "3      4.8         4.5  ...            6    1.545  0.01  0.365847  0.015987   \n",
       "4      4.8         4.5  ...            6    1.668  0.01  0.365847  0.015987   \n",
       "\n",
       "    vgmnpar  vgmlambda    ksatfit                staringblockdescription  \\\n",
       "0  1.136658   0.000100   4.483735                            venige klei   \n",
       "1  1.079952  -6.091311   9.689291                        zeer zware klei   \n",
       "2  1.271536  -1.249300   3.402009              mesotroof en eutroof veen   \n",
       "3  2.162751   2.867967  22.322154  leemarm zeer fijn tot matig fijn zand   \n",
       "4  2.162751   2.867967  22.322154  leemarm zeer fijn tot matig fijn zand   \n",
       "\n",
       "        staringblocklabel  \n",
       "0             venige klei  \n",
       "1              z.zw. klei  \n",
       "2       meso-eutroof veen  \n",
       "3  leemarm z.f.-m.f. zand  \n",
       "4  leemarm z.f.-m.f. zand  \n",
       "\n",
       "[5 rows x 34 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp.get_data_horizons()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "deaa7e16",
   "metadata": {},
   "source": [
    "## 2.2. Get chemical data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "35f72c2a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "layernumber",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "faohorizonnotation",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "ztop",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "zbottom",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "organicmattercontent",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "organicmattercontent10p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "organicmattercontent90p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "acidity",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "acidity10p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "acidity90p",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "cnratio",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "peattype",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "calciccontent",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "fedith",
         "rawType": "float64",
         "type": "float"
        }
       ],
       "ref": "5973e6d3-0487-4fea-9974-3da598381b66",
       "rows": [
        [
         "0",
         "1",
         "Ahg",
         "0.0",
         "0.1",
         "20.0",
         "10.0",
         "30.0",
         "5.0",
         "4.5",
         "5.5",
         "12",
         null,
         "0.0",
         "2.1"
        ],
        [
         "1",
         "2",
         "Cwg",
         "0.1",
         "0.35",
         "7.0",
         "5.0",
         "30.0",
         "5.0",
         "4.5",
         "5.5",
         "14",
         null,
         "0.0",
         "2.0"
        ],
        [
         "2",
         "3",
         "Cw",
         "0.35",
         "0.8",
         "75.0",
         "60.0",
         "90.0",
         "5.0",
         "4.7",
         "5.5",
         "22",
         "zeggeveen",
         "0.0",
         "1.4"
        ],
        [
         "3",
         "4",
         "BCb",
         "0.8",
         "0.95",
         "3.0",
         "1.0",
         "8.0",
         "4.8",
         "4.5",
         "5.2",
         "22",
         null,
         "0.0",
         "0.4"
        ],
        [
         "4",
         "5",
         "Cu",
         "0.95",
         "1.2",
         "0.4",
         "0.1",
         "3.0",
         "4.8",
         "4.5",
         "5.2",
         "22",
         null,
         "0.0",
         "0.3"
        ]
       ],
       "shape": {
        "columns": 14,
        "rows": 5
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>layernumber</th>\n",
       "      <th>faohorizonnotation</th>\n",
       "      <th>ztop</th>\n",
       "      <th>zbottom</th>\n",
       "      <th>organicmattercontent</th>\n",
       "      <th>organicmattercontent10p</th>\n",
       "      <th>organicmattercontent90p</th>\n",
       "      <th>acidity</th>\n",
       "      <th>acidity10p</th>\n",
       "      <th>acidity90p</th>\n",
       "      <th>cnratio</th>\n",
       "      <th>peattype</th>\n",
       "      <th>calciccontent</th>\n",
       "      <th>fedith</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Ahg</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.10</td>\n",
       "      <td>20.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.5</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Cwg</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.35</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.5</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Cw</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.80</td>\n",
       "      <td>75.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>22</td>\n",
       "      <td>zeggeveen</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>BCb</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.95</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.2</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Cu</td>\n",
       "      <td>0.95</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.2</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   layernumber faohorizonnotation  ztop  zbottom  organicmattercontent  \\\n",
       "0            1                Ahg  0.00     0.10                  20.0   \n",
       "1            2                Cwg  0.10     0.35                   7.0   \n",
       "2            3                 Cw  0.35     0.80                  75.0   \n",
       "3            4                BCb  0.80     0.95                   3.0   \n",
       "4            5                 Cu  0.95     1.20                   0.4   \n",
       "\n",
       "   organicmattercontent10p  organicmattercontent90p  acidity  acidity10p  \\\n",
       "0                     10.0                     30.0      5.0         4.5   \n",
       "1                      5.0                     30.0      5.0         4.5   \n",
       "2                     60.0                     90.0      5.0         4.7   \n",
       "3                      1.0                      8.0      4.8         4.5   \n",
       "4                      0.1                      3.0      4.8         4.5   \n",
       "\n",
       "   acidity90p  cnratio   peattype  calciccontent  fedith  \n",
       "0         5.5       12        NaN            0.0     2.1  \n",
       "1         5.5       14        NaN            0.0     2.0  \n",
       "2         5.5       22  zeggeveen            0.0     1.4  \n",
       "3         5.2       22        NaN            0.0     0.4  \n",
       "4         5.2       22        NaN            0.0     0.3  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp.get_data_horizons(which=\"chemical\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5fd2bc4f",
   "metadata": {},
   "source": [
    "## 2.3. Get physical/textural data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "92d0a2d6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "layernumber",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "faohorizonnotation",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "ztop",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "zbottom",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "loamcontent",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "loamcontent10p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "loamcontent90p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "lutitecontent",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "lutitecontent10p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "lutitecontent90p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "sandmedian",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "sandmedian10p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "sandmedian90p",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "siltcontent",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "density",
         "rawType": "float64",
         "type": "float"
        }
       ],
       "ref": "c628e355-25e6-44f9-8037-514cb5e91f9d",
       "rows": [
        [
         "0",
         "1",
         "Ahg",
         "0.0",
         "0.1",
         "75",
         "40",
         "90",
         "40",
         "25",
         "60",
         "140",
         "110",
         "170",
         "35",
         "0.641"
        ],
        [
         "1",
         "2",
         "Cwg",
         "0.1",
         "0.35",
         "90",
         "70",
         "100",
         "55",
         "40",
         "70",
         "110",
         "90",
         "130",
         "35",
         "1.044"
        ],
        [
         "2",
         "3",
         "Cw",
         "0.35",
         "0.8",
         "75",
         "45",
         "85",
         "18",
         "6",
         "30",
         "125",
         "110",
         "140",
         "57",
         "0.232"
        ],
        [
         "3",
         "4",
         "BCb",
         "0.8",
         "0.95",
         "8",
         "5",
         "20",
         "2",
         "1",
         "4",
         "160",
         "140",
         "180",
         "6",
         "1.545"
        ],
        [
         "4",
         "5",
         "Cu",
         "0.95",
         "1.2",
         "8",
         "5",
         "20",
         "2",
         "1",
         "4",
         "160",
         "140",
         "180",
         "6",
         "1.668"
        ]
       ],
       "shape": {
        "columns": 15,
        "rows": 5
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>layernumber</th>\n",
       "      <th>faohorizonnotation</th>\n",
       "      <th>ztop</th>\n",
       "      <th>zbottom</th>\n",
       "      <th>loamcontent</th>\n",
       "      <th>loamcontent10p</th>\n",
       "      <th>loamcontent90p</th>\n",
       "      <th>lutitecontent</th>\n",
       "      <th>lutitecontent10p</th>\n",
       "      <th>lutitecontent90p</th>\n",
       "      <th>sandmedian</th>\n",
       "      <th>sandmedian10p</th>\n",
       "      <th>sandmedian90p</th>\n",
       "      <th>siltcontent</th>\n",
       "      <th>density</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Ahg</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.10</td>\n",
       "      <td>75</td>\n",
       "      <td>40</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>25</td>\n",
       "      <td>60</td>\n",
       "      <td>140</td>\n",
       "      <td>110</td>\n",
       "      <td>170</td>\n",
       "      <td>35</td>\n",
       "      <td>0.641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Cwg</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.35</td>\n",
       "      <td>90</td>\n",
       "      <td>70</td>\n",
       "      <td>100</td>\n",
       "      <td>55</td>\n",
       "      <td>40</td>\n",
       "      <td>70</td>\n",
       "      <td>110</td>\n",
       "      <td>90</td>\n",
       "      <td>130</td>\n",
       "      <td>35</td>\n",
       "      <td>1.044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Cw</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.80</td>\n",
       "      <td>75</td>\n",
       "      <td>45</td>\n",
       "      <td>85</td>\n",
       "      <td>18</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>125</td>\n",
       "      <td>110</td>\n",
       "      <td>140</td>\n",
       "      <td>57</td>\n",
       "      <td>0.232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>BCb</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.95</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>160</td>\n",
       "      <td>140</td>\n",
       "      <td>180</td>\n",
       "      <td>6</td>\n",
       "      <td>1.545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Cu</td>\n",
       "      <td>0.95</td>\n",
       "      <td>1.20</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>160</td>\n",
       "      <td>140</td>\n",
       "      <td>180</td>\n",
       "      <td>6</td>\n",
       "      <td>1.668</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   layernumber faohorizonnotation  ztop  zbottom  loamcontent  loamcontent10p  \\\n",
       "0            1                Ahg  0.00     0.10           75              40   \n",
       "1            2                Cwg  0.10     0.35           90              70   \n",
       "2            3                 Cw  0.35     0.80           75              45   \n",
       "3            4                BCb  0.80     0.95            8               5   \n",
       "4            5                 Cu  0.95     1.20            8               5   \n",
       "\n",
       "   loamcontent90p  lutitecontent  lutitecontent10p  lutitecontent90p  \\\n",
       "0              90             40                25                60   \n",
       "1             100             55                40                70   \n",
       "2              85             18                 6                30   \n",
       "3              20              2                 1                 4   \n",
       "4              20              2                 1                 4   \n",
       "\n",
       "   sandmedian  sandmedian10p  sandmedian90p  siltcontent  density  \n",
       "0         140            110            170           35    0.641  \n",
       "1         110             90            130           35    1.044  \n",
       "2         125            110            140           57    0.232  \n",
       "3         160            140            180            6    1.545  \n",
       "4         160            140            180            6    1.668  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp.get_data_horizons(which=\"physical\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f3983381",
   "metadata": {},
   "source": [
    "## 2.4. Get hydraulic data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "88aa3fe1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "layernumber",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "faohorizonnotation",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "ztop",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "zbottom",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "staringseriesblock",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "wcres",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "wcsat",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "vgmalpha",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "vgmnpar",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "vgmlambda",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "ksatfit",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "staringblockdescription",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "staringblocklabel",
         "rawType": "object",
         "type": "string"
        }
       ],
       "ref": "6cb5c4ce-e7ac-44be-a335-61b390b49d34",
       "rows": [
        [
         "0",
         "1",
         "Ahg",
         "0.0",
         "0.1",
         "B17",
         "0.0",
         "0.71862598",
         "0.01906191",
         "1.1366583",
         "0.0001",
         "4.48373535",
         "venige klei",
         "venige klei"
        ],
        [
         "1",
         "2",
         "Cwg",
         "0.1",
         "0.35",
         "O13",
         "0.01",
         "0.573268",
         "0.02785405",
         "1.07995207",
         "-6.09131057",
         "9.68929074",
         "zeer zware klei",
         "z.zw. klei"
        ],
        [
         "2",
         "3",
         "Cw",
         "0.35",
         "0.8",
         "O17",
         "0.01",
         "0.84863548",
         "0.01192909",
         "1.27153561",
         "-1.24929996",
         "3.40200949",
         "mesotroof en eutroof veen",
         "meso-eutroof veen"
        ],
        [
         "3",
         "4",
         "BCb",
         "0.8",
         "0.95",
         "O01",
         "0.01",
         "0.36584689",
         "0.01598691",
         "2.16275113",
         "2.8679672",
         "22.32215442",
         "leemarm zeer fijn tot matig fijn zand",
         "leemarm z.f.-m.f. zand"
        ],
        [
         "4",
         "5",
         "Cu",
         "0.95",
         "1.2",
         "O01",
         "0.01",
         "0.36584689",
         "0.01598691",
         "2.16275113",
         "2.8679672",
         "22.32215442",
         "leemarm zeer fijn tot matig fijn zand",
         "leemarm z.f.-m.f. zand"
        ]
       ],
       "shape": {
        "columns": 13,
        "rows": 5
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>layernumber</th>\n",
       "      <th>faohorizonnotation</th>\n",
       "      <th>ztop</th>\n",
       "      <th>zbottom</th>\n",
       "      <th>staringseriesblock</th>\n",
       "      <th>wcres</th>\n",
       "      <th>wcsat</th>\n",
       "      <th>vgmalpha</th>\n",
       "      <th>vgmnpar</th>\n",
       "      <th>vgmlambda</th>\n",
       "      <th>ksatfit</th>\n",
       "      <th>staringblockdescription</th>\n",
       "      <th>staringblocklabel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Ahg</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.10</td>\n",
       "      <td>B17</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.718626</td>\n",
       "      <td>0.019062</td>\n",
       "      <td>1.136658</td>\n",
       "      <td>0.000100</td>\n",
       "      <td>4.483735</td>\n",
       "      <td>venige klei</td>\n",
       "      <td>venige klei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Cwg</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.35</td>\n",
       "      <td>O13</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.573268</td>\n",
       "      <td>0.027854</td>\n",
       "      <td>1.079952</td>\n",
       "      <td>-6.091311</td>\n",
       "      <td>9.689291</td>\n",
       "      <td>zeer zware klei</td>\n",
       "      <td>z.zw. klei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Cw</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.80</td>\n",
       "      <td>O17</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.848635</td>\n",
       "      <td>0.011929</td>\n",
       "      <td>1.271536</td>\n",
       "      <td>-1.249300</td>\n",
       "      <td>3.402009</td>\n",
       "      <td>mesotroof en eutroof veen</td>\n",
       "      <td>meso-eutroof veen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>BCb</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.95</td>\n",
       "      <td>O01</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.365847</td>\n",
       "      <td>0.015987</td>\n",
       "      <td>2.162751</td>\n",
       "      <td>2.867967</td>\n",
       "      <td>22.322154</td>\n",
       "      <td>leemarm zeer fijn tot matig fijn zand</td>\n",
       "      <td>leemarm z.f.-m.f. zand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Cu</td>\n",
       "      <td>0.95</td>\n",
       "      <td>1.20</td>\n",
       "      <td>O01</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.365847</td>\n",
       "      <td>0.015987</td>\n",
       "      <td>2.162751</td>\n",
       "      <td>2.867967</td>\n",
       "      <td>22.322154</td>\n",
       "      <td>leemarm zeer fijn tot matig fijn zand</td>\n",
       "      <td>leemarm z.f.-m.f. zand</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   layernumber faohorizonnotation  ztop  zbottom staringseriesblock  wcres  \\\n",
       "0            1                Ahg  0.00     0.10                B17   0.00   \n",
       "1            2                Cwg  0.10     0.35                O13   0.01   \n",
       "2            3                 Cw  0.35     0.80                O17   0.01   \n",
       "3            4                BCb  0.80     0.95                O01   0.01   \n",
       "4            5                 Cu  0.95     1.20                O01   0.01   \n",
       "\n",
       "      wcsat  vgmalpha   vgmnpar  vgmlambda    ksatfit  \\\n",
       "0  0.718626  0.019062  1.136658   0.000100   4.483735   \n",
       "1  0.573268  0.027854  1.079952  -6.091311   9.689291   \n",
       "2  0.848635  0.011929  1.271536  -1.249300   3.402009   \n",
       "3  0.365847  0.015987  2.162751   2.867967  22.322154   \n",
       "4  0.365847  0.015987  2.162751   2.867967  22.322154   \n",
       "\n",
       "                 staringblockdescription       staringblocklabel  \n",
       "0                            venige klei             venige klei  \n",
       "1                        zeer zware klei              z.zw. klei  \n",
       "2              mesotroof en eutroof veen       meso-eutroof veen  \n",
       "3  leemarm zeer fijn tot matig fijn zand  leemarm z.f.-m.f. zand  \n",
       "4  leemarm zeer fijn tot matig fijn zand  leemarm z.f.-m.f. zand  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp.get_data_horizons(which=\"hydraulic\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}