[Qgis-user] Geology / formation database structure

[Stefan Giese (WhereGroup)]

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
> <Stefan.Giese at wheregroup.com> 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.giese at 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 at 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