bedrock_ge.gi.sqlmodels
Project
Section titled “Project”class Project(SQLModel)
project_uid
Section titled “project_uid”Location
Section titled “Location”class Location(SQLModel)
location_uid
Section titled “location_uid”project_uid
Section titled “project_uid”source_id
Section titled “source_id”location_type
Section titled “location_type”easting
Section titled “easting”northing
Section titled “northing”ground_level
Section titled “ground_level”depth_to_base
Section titled “depth_to_base”elevation_at_base
Section titled “elevation_at_base”latitude
Section titled “latitude”longitude
Section titled “longitude”DepthInformation
Section titled “DepthInformation”class DepthInformation(SQLModel)
depth_to_top
Section titled “depth_to_top”depth_to_base
Section titled “depth_to_base”elevation_at_top
Section titled “elevation_at_top”elevation_at_base
Section titled “elevation_at_base”Sample
Section titled “Sample”class Sample(DepthInformation)
sample_uid
Section titled “sample_uid”project_uid
Section titled “project_uid”location_uid
Section titled “location_uid”source_id
Section titled “source_id”InSitu
Section titled “InSitu”class InSitu(DepthInformation)
project_uid
Section titled “project_uid”location_uid
Section titled “location_uid”class Lab(SQLModel)
project_uid
Section titled “project_uid”location_uid
Section titled “location_uid”sample_uid
Section titled “sample_uid”Material
Section titled “Material”class Material(InSitu)
Material descriptions from the field. GEOL group in AGS 3 and AGS 4.
material_name
Section titled “material_name”material_description
Section titled “material_description”class SPT(InSitu)
spt_count
Section titled “spt_count”RockCore
Section titled “RockCore”class RockCore(InSitu)
Weathering
Section titled “Weathering”class Weathering(InSitu)