gwmod / nlmod

Python package to build, run and visualize MODFLOW 6 groundwater models in the Netherlands.
https://nlmod.readthedocs.io
MIT License
31 stars 2 forks source link

Add information about geotop stratigraphic units #361

Closed rubencalje closed 2 weeks ago

rubencalje commented 2 months ago

This PR adds the files REF_GTP_LITHO_CLASS.xlsx and REF_GTP_STR_UNIT.xlsx, which are copied from the GeoTOP-zip-file (version 1.6) downloaded from DINOloket. This PR adds a method (_save_excel_files_as_csv, which is never to be called directly by the user) to transform these xlsx-files into csv-files, which are better tracked using version-control, so we can monitor changes in future geotop-versions. REF_GTP_STR_UNIT.csv contains all the lastest stratigraphic units, of which we misinterpreted some (1095) in the list we used to use (geo_eenheden.csv).

One major benefit of this approach is that REF_GTP_STR_UNIT.csv contains a column SEQ_NR, which gives information about the sequence in which layers occur. We can use this SEQ_NR when we transform the geotop data into a layer model, using nlmod.read.geotop.to_model_layers().