Re: [Qgis-user] Geology / formation database structure
Hi, i ' m not a geologist and no more skill on geology. However, i know the inspire group produced many specs also for geology. This is the data specs for geology. https://inspire.ec.europa.eu/Themes/128/2892 I dont know if could help you. Regards, Andrea. Il gio 24 ott 2019, 01:55 Matt Boyd ha scritto: > Hi QGISers, > possibly a little OT but do any of the geologists on the list know of a > pre-built structure for formation tops in well data? > > I'm thinking a relational DB structure that is able to be filtered by > group / formation / member and provides more functionality than > spreadsheets and with a smaller footprint than the monolithic > geology databases that seem to be around. > > I've started building this myself but I'm more of a user than a designer. > > Thanks > Matt > > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Geology / formation database structure
Hi Hugo, that looks very cool. I've been looking into this for a while and the thing that seems to be missing even in the expensive commercial software is the ability to define (non-spatial) relationships between data points. The articles I've found about this sort of thing via google all suggest that it would be very useful and discuss basic structures but I haven't been able to find an implementation. Ideally I'd find something implemented so compatibility was built in. Using postgis is a great. I'm working on the relationships in access at the moment just because it's easy to visualise and is installed on most of the PC's I work with. Once I get the tables right I'll look at moving to something better. Matt On Thu, Oct 24, 2019 at 10:45 PM Hugo Mercier wrote: > Hi Matt, > > On 24/10/2019 01:55, Matt Boyd wrote: > > Hi QGISers, > > possibly a little OT but do any of the geologists on the list know of a > > pre-built structure for formation tops in well data? > > > > I'm thinking a relational DB structure that is able to be filtered by > > group / formation / member and provides more functionality than > > spreadsheets and with a smaller footprint than the monolithic > > geology databases that seem to be around. > > > > I've started building this myself but I'm more of a user than a designer. > > > > I don't know if it fits your needs, but we are currently working on a > plugin [1] that allows the visualization of boreholes. Data are stored > in whatever formats QGIS is able to read (we mainly use postgis) and the > "data model" aims at being generic enough to adapt to different use cases. > > It still lacks a finishing touch before it goes to the main QGIS plugin > repository, but we will be working again on it for one of our customer > before the end of the year. > > Fell free to have a look ! > > [1] https://github.com/Oslandia/QGeoloGIS > > Hugo > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Geology / formation database structure
Hi Matt, so your are talking about a lithostratigraphic database. On chronostratigraphic handling in GIS and databases there is an interesting article here: https://repositorio.segemar.gob.ar/bitstream/handle/308849217/2128/asato-IAMG-2001.pdf (Efficient Chrono-Stratigraphic Database Structure in GIS) Stefan Am 2019-10-25 00:07, schrieb Matt Boyd: Hi Stefan, I had another look at midvatten it's not quite what I need. I'm not sure this is how to explain it but I'll try. The way you describe it treats stratigraphy as just another property at a layer. I need the stratigraphic relationships, groups at top level, then formation, then member in a stratigraphic database, which is then linked to the "base data" properties you've described. The idea is to force an internal consistency and enable me to check data thats been entered. Thanks Matt On Thu, Oct 24, 2019 at 8:32 PM Stefan Giese wrote: Hi Matt, did you have a look to the midvatten plugin (1), there you can create a project database for geology data from drilholes. I didn't use it so far, but I think it's worth have a look on. Normally the basic construct should be a one to many relation between base data and horizon data base data (position, name, ...) 1 - n horizons ( upper depth, lower depth, lithology, colour, fabric, texture, genesis, stratigraphy...) (1) https://github.com/jkall/qgis-midvatten-plugin/wiki Best regards Stefan Mit freundlichen Grüßen Stefan Giese Projektleiter/Consultant *** Where2B Konferenz 2019 12. Dezember 2019 in Bonn where2b-conference.com [1] *** WhereGroup GmbH Schwimmbadstr. 2 79100 Freiburg Germany Fon: +49 (0)761 / 519 102 - 61 Fax: +49 (0)761 / 519 102 - 11 stefan.gi...@wheregroup.com www.wheregroup.com [2] Geschäftsführer: Olaf Knopp, Peter Stamm Amtsgericht Bonn, HRB 9885 Am 24.10.2019 um 01:55 schrieb Matt Boyd: Hi QGISers, possibly a little OT but do any of the geologists on the list know of a pre-built structure for formation tops in well data? I'm thinking a relational DB structure that is able to be filtered by group / formation / member and provides more functionality than spreadsheets and with a smaller footprint than the monolithic geology databases that seem to be around. I've started building this myself but I'm more of a user than a designer. Thanks Matt ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user Links: -- [1] http://where2b-conference.com [2] http://www.wheregroup.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Geology / formation database structure
Hi Stefan, I had another look at midvatten it's not quite what I need. I'm not sure this is how to explain it but I'll try. The way you describe it treats stratigraphy as just another property at a layer. I need the stratigraphic relationships, groups at top level, then formation, then member in a stratigraphic database, which is then linked to the "base data" properties you've described. The idea is to force an internal consistency and enable me to check data thats been entered. Thanks Matt On Thu, Oct 24, 2019 at 8:32 PM Stefan Giese wrote: > Hi Matt, > > did you have a look to the midvatten plugin (1), there you can create a > project database for geology data from drilholes. I didn't use it so far, > but I think it's worth have a look on. > > Normally the basic construct should be a one to many relation between base > data and horizon data > > base data (position, name, ...) 1 - n horizons ( upper depth, lower > depth, lithology, colour, fabric, texture, genesis, stratigraphy...) > > (1) https://github.com/jkall/qgis-midvatten-plugin/wiki > > Best regards > > Stefan > > > Mit freundlichen Grüßen > Stefan Giese > Projektleiter/Consultant > *** > Where2B Konferenz 2019 > 12. Dezember 2019 in Bonnwhere2b-conference.com > *** > WhereGroup GmbH > Schwimmbadstr. 2 > 79100 Freiburg > Germany > > Fon: +49 (0)761 / 519 102 - 61 > Fax: +49 (0)761 / 519 102 - 11 > stefan.gi...@wheregroup.comwww.wheregroup.com > Geschäftsführer: > Olaf Knopp, Peter Stamm > Amtsgericht Bonn, HRB 9885 > > Am 24.10.2019 um 01:55 schrieb Matt Boyd: > > Hi QGISers, > possibly a little OT but do any of the geologists on the list know of a > pre-built structure for formation tops in well data? > > I'm thinking a relational DB structure that is able to be filtered by > group / formation / member and provides more functionality than > spreadsheets and with a smaller footprint than the monolithic > geology databases that seem to be around. > > I've started building this myself but I'm more of a user than a designer. > > Thanks > Matt > > > > ___ > Qgis-user mailing listqgis-u...@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Geology / formation database structure
Hi Hugo, that are really good news for all geologists working with QGIS. Thanks for that! Best Stefan Am 24.10.2019 um 13:40 schrieb Hugo Mercier: Hi Matt, On 24/10/2019 01:55, Matt Boyd wrote: Hi QGISers, possibly a little OT but do any of the geologists on the list know of a pre-built structure for formation tops in well data? I'm thinking a relational DB structure that is able to be filtered by group / formation / member and provides more functionality than spreadsheets and with a smaller footprint than the monolithic geology databases that seem to be around. I've started building this myself but I'm more of a user than a designer. I don't know if it fits your needs, but we are currently working on a plugin [1] that allows the visualization of boreholes. Data are stored in whatever formats QGIS is able to read (we mainly use postgis) and the "data model" aims at being generic enough to adapt to different use cases. It still lacks a finishing touch before it goes to the main QGIS plugin repository, but we will be working again on it for one of our customer before the end of the year. Fell free to have a look ! [1] https://github.com/Oslandia/QGeoloGIS Hugo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Geology / formation database structure
Hi Matt, On 24/10/2019 01:55, Matt Boyd wrote: > Hi QGISers, > possibly a little OT but do any of the geologists on the list know of a > pre-built structure for formation tops in well data? > > I'm thinking a relational DB structure that is able to be filtered by > group / formation / member and provides more functionality than > spreadsheets and with a smaller footprint than the monolithic > geology databases that seem to be around. > > I've started building this myself but I'm more of a user than a designer. > I don't know if it fits your needs, but we are currently working on a plugin [1] that allows the visualization of boreholes. Data are stored in whatever formats QGIS is able to read (we mainly use postgis) and the "data model" aims at being generic enough to adapt to different use cases. It still lacks a finishing touch before it goes to the main QGIS plugin repository, but we will be working again on it for one of our customer before the end of the year. Fell free to have a look ! [1] https://github.com/Oslandia/QGeoloGIS Hugo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Geology / formation database structure
Hi Matt, did you have a look to the midvatten plugin (1), there you can create a project database for geology data from drilholes. I didn't use it so far, but I think it's worth have a look on. Normally the basic construct should be a one to many relation between base data and horizon data base data (position, name, ...) 1 - n horizons ( upper depth, lower depth, lithology, colour, fabric, texture, genesis, stratigraphy...) (1) https://github.com/jkall/qgis-midvatten-plugin/wiki Best regards Stefan Mit freundlichen Grüßen Stefan Giese Projektleiter/Consultant *** Where2B Konferenz 2019 12. Dezember 2019 in Bonn where2b-conference.com *** WhereGroup GmbH Schwimmbadstr. 2 79100 Freiburg Germany Fon: +49 (0)761 / 519 102 - 61 Fax: +49 (0)761 / 519 102 - 11 stefan.gi...@wheregroup.com www.wheregroup.com Geschäftsführer: Olaf Knopp, Peter Stamm Amtsgericht Bonn, HRB 9885 Am 24.10.2019 um 01:55 schrieb Matt Boyd: Hi QGISers, possibly a little OT but do any of the geologists on the list know of a pre-built structure for formation tops in well data? I'm thinking a relational DB structure that is able to be filtered by group / formation / member and provides more functionality than spreadsheets and with a smaller footprint than the monolithic geology databases that seem to be around. I've started building this myself but I'm more of a user than a designer. Thanks Matt ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Geology / formation database structure
Hi QGISers, possibly a little OT but do any of the geologists on the list know of a pre-built structure for formation tops in well data? I'm thinking a relational DB structure that is able to be filtered by group / formation / member and provides more functionality than spreadsheets and with a smaller footprint than the monolithic geology databases that seem to be around. I've started building this myself but I'm more of a user than a designer. Thanks Matt ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user