TY - DATA
T1 - RockIn - A webapp for rock sample registration
PY - 2024/08/22
AU - Jose Urra Llanusa
AU - Liliana Vargas Meleza
UR - 
DO - 10.4121/09461663-32eb-4dda-aeba-28016fd7e7f6.v1
KW - borehole
KW - borehole drilling
KW - rock sample
KW - drilling cuttings
KW - cuttings
KW - core
KW - geothermal well
KW - sample inventory
KW - shallow borehole
KW - deep borehole
N2 - <p>A simple webapp developed in Python to register rock samples collected from a well or borehole. This tool was developed to use the existing data-entry forms of an MS Access database (published <a href=" https://www.doi.org/10.4121/2292437e-2ce4-42b7-8350-7774d762cc60 " target="_blank"><strong>here</strong></a>) as a front-end client connected to a remote MySQL database. It includes a Django data model for a MySQL database, as well as scripts to migrate data from Microsoft Access to MySQL. The <a href="https://github.com/jurra/rockin-datamodel/" target="_blank"><strong>data model</strong></a> was developed the package Pydantic, helps to describe relationships between entities without having to rely on a specific implementation, webapp or database. This data model can also be used to generate schemas.</p><p></p><p>Initially, this webapp would have been used to register samples from the geothermal well installed on TU Delft campus (<a href="https://data.4tu.nl/my/datasets/09461663-32eb-4dda-aeba-28016fd7e7f6/www.tudelft.nl/geothermalwell" target="_blank">https:www.tudelft.nl/geothermalwell</a>) but drilling activities ended before the tool was completed. However, this sample registration tool could be of interest for other borehole drilling projects. </p><p></p><p>The webapp was developed by Jose Urra Llanusa, software developer from TU Delft Digital Competence Centre (DCC), and the pydantic data model is based on the data model from the MS Access database developed by Liliana Vargas Meleza, Data Manager of the geothermal well.</p><p></p>
ER -