from pathlib import Path
from toolbox_continu_inzicht.base.config import Config
from toolbox_continu_inzicht.base.data_adapter import DataAdapterWMS laag toevoegen aan database voor viewer
path = Path.cwd() / "data_sets"
config = Config(config_path=path / "example_inspection.yaml")
config.lees_config()
data_adapter = DataAdapter(config=config)data_adapter.input("inspections_results")| location_id | prioriteit | x | y | opmerking | datum | tijd | waterschap | |
|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 5.533930 | 52.596911 | foutje | 2-4-2025 | 09:08 | Zuiderzeeland |
| 1 | 1 | 1 | 5.451603 | 52.540697 | scheurvorming | 28-3-2025 | 15:48 | Zuiderzeeland |
| 2 | 2 | 3 | 5.407599 | 52.497642 | opschot | 28-3-2025 | 15:50 | Zuiderzeeland |
| 3 | 3 | 11 | 5.616243 | 52.602794 | beginnende scheurvorming | 31-3-2025 | 09:02 | Zuiderzeeland |
We willen de volgende data toevoegen aan de viewer:
url = "https://basisinformatie-overstromingen.nl/geoserver/LIWO_Basis/infrastructuur_dijkringen/ows?SERVICE=WMS&"
legend_url = "https://geodata.basisinformatie-overstromingen.nl/geoserver/LIWO_Basis/infrastructuur_dijkringen/ows?service=WMS&version=1.3.0&request=GetLegendGraphic&format=image/png&width=20&height=20&layer=infrastructuur_dijkringen&"
layer_wms_layer = "infrastructuur_dijkringen"
layer_wms_style = "LIWO_Basis_Dijkringen"Het layers bestand bevat de standaard opties
df_layers = data_adapter.input("layers")df_layers| group_name | layer_name | layer_visible | layer_type | layer_table | layer_wms_url | layer_wms_layer | layer_wms_style | layer_wms_legend_url | layer_data | layer_legend | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Extra Kaartlagen | Geojson met data | True | geojson | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | Extra Kaartlagen | WMS test | True | wms | NaN | https://geo.hkvservices.nl/geoserver/wms | Waterdiepte | liwo_waterdiepte_band1 | NaN | NaN | NaN |
| 2 | Extra Kaartlagen | table test | True | table | areas | NaN | NaN | NaN | NaN | NaN | NaN |
We vullen alleen de eerste kolom met de dijkringen informatie
df_wms_laag = df_layers.iloc[[1]].copy()
df_wms_laag.reset_index(drop=True, inplace=True)
df_wms_laag.loc[0, "group_name"] = "Dijkringen Nederland"
df_wms_laag.loc[0, "layer_wms_url"] = url
df_wms_laag.loc[0, "layer_wms_layer"] = layer_wms_layer
df_wms_laag.loc[0, "layer_wms_style"] = layer_wms_style
df_wms_laag["layer_wms_legend_url"] = df_wms_laag["layer_legend"].astype(str)
df_wms_laag.loc[0, "layer_wms_legend_url"] = legend_url
df_wms_laag = df_wms_laag.fillna("")
df_wms_laag| group_name | layer_name | layer_visible | layer_type | layer_table | layer_wms_url | layer_wms_layer | layer_wms_style | layer_wms_legend_url | layer_data | layer_legend | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Dijkringen Nederland | WMS test | True | wms | https://basisinformatie-overstromingen.nl/geos... | infrastructuur_dijkringen | LIWO_Basis_Dijkringen | https://geodata.basisinformatie-overstromingen... |
Omdat database interactie op GitHub niet mogelijk wordt de onderstaande cell niet uitgevoerd, lokaal kan dit uiteraard wel
En vervolgens kunnen we deze naar de database zetten
# data_adapter.output("to_ci_database", df_wms_laag)