Overview

Querying, filtering, formulas, and the calculation engine - finding and deriving value from the data you collected.

Queries

Filter and retrieve objects, measurement points, and layer descriptions by condition.

• Creating Queries - filter objects and measurement points by conditions.
• Parameterized Queries - queries with placeholders that prompt for values at execution time.
• SQL and Advanced Options - direct SQL entry for logic the visual builder cannot express.
• Query Builder Reference - reference for the Query Builder, including the subquery table list and schema handling.
• Conditions and Operators - comparison and logical operators used to filter a result set.
• Layer Queries - query coded layer descriptions such as soil and rock attributes.
• Complex Layer Queries - advanced layer-query cases building on Layer Queries.

Formulas

Compute and store derived values from data already in the dataset.

• Formula Basics - compute derived values with GeoDin's formula syntax.
• Formulas in Measurement Values - apply formulas to measurement-value series.
• Object Type Formulas - define formulas on a data type's fields.

Calculation engine

Automated checks, geotechnical analyses, and curve-fitting applied to your data.

• Data Checks and Validations - automated checks and rules applied at data entry.
• Geotechnical Analyses - hydrogeochemical and grain-size analysis methods and their diagrams.
• Regression and Curve Fitting - time-series and measurement-value series properties for regression and curve-fitting work.