{"id":92584,"date":"2026-06-02T01:27:30","date_gmt":"2026-06-02T01:27:30","guid":{"rendered":"https:\/\/gaeatech.com\/knowledge-center\/?p=92584"},"modified":"2026-06-01T02:09:14","modified_gmt":"2026-06-01T02:09:14","slug":"cross-dataset-validation-geotechnical-databases","status":"publish","type":"post","link":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/","title":{"rendered":"Cross-Dataset Validation in Geotechnical Databases"},"content":{"rendered":"\n<h2 id=\"h-why-data-relationships-matter-more-than-individual-data-fields\" class=\"wp-block-heading\">Why Data Relationships Matter More Than Individual Data Fields<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Modern geotechnical, geological, environmental, and mining projects generate vast amounts of interconnected data. A single borehole may contain lithology logs, sampling records, laboratory results, recovery measurements, Rock Quality Designation (RQD) values, Standard Penetration Test (SPT) results, well construction details, survey information, and spatial coordinates.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Most data validation systems focus on checking individual fields. For example, ensuring a depth is positive or that a required field is populated. While these checks are important, they only detect a portion of potential data quality issues.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Many of the most serious errors occur when related datasets become inconsistent with one another. A lithology interval may not align with sample intervals. Recovery values may contradict RQD measurements. Well construction records may extend beyond the borehole depth. Coordinates may place a borehole outside the project boundary.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation addresses these problems by examining relationships between multiple datasets rather than validating each table independently.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This article explores the importance of cross-dataset validation in geotechnical databases and examines common validation scenarios involving lithology, sampling, recovery, RQD, SPT data, well construction records, and spatial coordinates.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-what-is-cross-dataset-validation\" class=\"wp-block-heading\">What Is Cross-Dataset Validation?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation is the process of verifying consistency between related data tables within a geotechnical database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Unlike simple field validation, which evaluates a single value, cross-dataset validation compares information across multiple records and datasets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sample intervals should fall within lithology intervals.<\/li>\n\n\n\n<li>RQD cannot exceed recovery.<\/li>\n\n\n\n<li>Screen intervals should remain within borehole depth.<\/li>\n\n\n\n<li>SPT tests should occur within valid sampling intervals.<\/li>\n\n\n\n<li>Coordinates should match project boundaries.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">These checks ensure that the database represents a logically consistent interpretation of the borehole rather than a collection of isolated records.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-why-cross-dataset-validation-is-important\" class=\"wp-block-heading\">Why Cross-Dataset Validation Is Important<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Data quality problems often emerge when information is entered by multiple users over long project durations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A geologist enters lithology.<\/li>\n\n\n\n<li>A technician records recovery.<\/li>\n\n\n\n<li>A driller enters well construction details.<\/li>\n\n\n\n<li>A surveyor updates coordinates.<\/li>\n\n\n\n<li>A laboratory uploads testing results.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Each dataset may appear valid independently while still containing inconsistencies when compared with related data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Without cross-dataset validation, these issues may remain hidden until:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resource estimation begins<\/li>\n\n\n\n<li>Geotechnical designs are developed<\/li>\n\n\n\n<li>Regulatory reports are prepared<\/li>\n\n\n\n<li>Construction decisions are made<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Finding problems late in a project is significantly more expensive than identifying them during data entry.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-lithology-vs-sampling-validation\" class=\"wp-block-heading\">Lithology vs Sampling Validation<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">One of the most common cross-dataset checks involves comparing lithology intervals with sample intervals.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lithology provides the geological interpretation of the subsurface, while sampling records represent physical material collected for testing.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The two datasets should align logically.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-sample-intervals-within-borehole-limits\" class=\"wp-block-heading\">Sample Intervals Within Borehole Limits<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Every sample interval should fall within the borehole depth.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>Borehole Depth<\/th><th>Sample Interval<\/th><\/tr><tr><td>50 m<\/td><td>10\u201312 m<\/td><\/tr><tr><td>50 m<\/td><td>25\u201326 m<\/td><\/tr><tr><td>50 m<\/td><td>48\u201355 m<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The final sample exceeds the borehole depth and should be flagged.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Validation Rule:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SampleTo &lt;= BoreholeDepth<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-sample-coverage-verification\" class=\"wp-block-heading\">Sample Coverage Verification<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sampling intervals often need to correspond to logged lithology intervals.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Lithology<\/td><td>From<\/td><td>To<\/td><\/tr><tr><td>Clay<\/td><td>0<\/td><td>5<\/td><\/tr><tr><td>Sand<\/td><td>5<\/td><td>12<\/td><\/tr><tr><td>Till<\/td><td>12<\/td><td>20<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Sample:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Sample<\/td><td>From<\/td><td>To<\/td><\/tr><tr><td>S-101<\/td><td>5<\/td><td>7<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The sample falls entirely within the sand interval and is valid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If a sample spans multiple lithology units:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Sample<\/td><td>From<\/td><td>To<\/td><\/tr><tr><td>S-102<\/td><td>4.8<\/td><td>6.5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The sample crosses a lithology boundary and may require review.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Such situations are not necessarily incorrect but should be identified for verification.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-missing-lithology-coverage\" class=\"wp-block-heading\">Missing Lithology Coverage<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Every sampled interval should have corresponding geological logging.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Validation should detect:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Samples without lithology<\/li>\n\n\n\n<li>Gaps in geological interpretation<\/li>\n\n\n\n<li>Unclassified intervals<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">These conditions can impact geological modeling and reporting.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-recovery-vs-rqd-validation\" class=\"wp-block-heading\">Recovery vs RQD Validation<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Core recovery and Rock Quality Designation (RQD) are among the most important rock quality indicators in geotechnical investigations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Because RQD is derived from recovered core, the two values must remain logically consistent.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-understanding-the-relationship\" class=\"wp-block-heading\">Understanding the Relationship<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Recovery represents:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Recovered Core Length \/ Run Length \u00d7 100<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">RQD represents:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Length of Sound Core Pieces &gt; 10 cm \/ Run Length \u00d7 100<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Since RQD is calculated from recovered material, RQD cannot exceed recovery.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-validation-rule\" class=\"wp-block-heading\">Validation Rule<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>RQD &lt;= Recovery<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Recovery<\/td><td>RQD<\/td><td>Result<\/td><\/tr><tr><td>95<\/td><td>82<\/td><td>Valid<\/td><\/tr><tr><td>78<\/td><td>70<\/td><td>Valid<\/td><\/tr><tr><td>65<\/td><td>90<\/td><td>Invalid<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The final example is physically impossible and should generate an error.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-recovery-and-rock-type-relationships\" class=\"wp-block-heading\">Recovery and Rock Type Relationships<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation may also identify unusual combinations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Very high recovery in highly weathered rock<\/li>\n\n\n\n<li>Extremely low recovery in competent granite<\/li>\n\n\n\n<li>Sudden recovery changes without lithological explanation<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">These conditions often warrant review.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-spt-consistency-validation\" class=\"wp-block-heading\">SPT Consistency Validation<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Standard Penetration Test (SPT) data is widely used in geotechnical investigations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SPT values are often entered separately from lithology and sampling datasets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation helps ensure consistency.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-spt-depth-verification\" class=\"wp-block-heading\">SPT Depth Verification<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SPT tests should occur within borehole limits.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Borehole Depth<\/td><td>SPT Depth<\/td><\/tr><tr><td>20 m<\/td><td>18.5 m<\/td><\/tr><tr><td>20 m<\/td><td>25 m<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The second record exceeds borehole depth and should be rejected.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-spt-and-sample-alignment\" class=\"wp-block-heading\">SPT and Sample Alignment<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Many organizations collect SPT data within sampling intervals.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Validation can verify:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SPT depth falls inside a sample interval<\/li>\n\n\n\n<li>Sample identifiers exist<\/li>\n\n\n\n<li>Associated recovery records are present<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Missing relationships often indicate data entry errors.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-duplicate-spt-depths\" class=\"wp-block-heading\">Duplicate SPT Depths<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Multiple SPT tests at identical depths may indicate duplicate records.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Depth<\/td><\/tr><tr><td>10.0<\/td><\/tr><tr><td>10.0<\/td><\/tr><tr><td>10.0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation can identify duplicates automatically.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-spt-value-range-checks\" class=\"wp-block-heading\">SPT Value Range Checks<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">While technically a field-level validation, comparison with lithology can provide valuable context.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>N-value of 2 in dense gravel<\/li>\n\n\n\n<li>N-value of 100 in soft clay<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Such combinations may be valid but should be reviewed.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-well-construction-validation\" class=\"wp-block-heading\">Well Construction Validation<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Environmental and hydrogeological projects frequently include well construction information.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These records must remain consistent with borehole geometry.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-screen-interval-validation\" class=\"wp-block-heading\">Screen Interval Validation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Well screens must fit within the drilled borehole.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Borehole Depth<\/td><td>Screen Interval<\/td><\/tr><tr><td>30 m<\/td><td>10\u201320 m<\/td><\/tr><tr><td>30 m<\/td><td>25\u201335 m<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The second screen extends beyond the borehole depth and is invalid.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-screen-and-casing-overlap-checks\" class=\"wp-block-heading\">Screen and Casing Overlap Checks<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Validation should verify:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Screen intervals do not overlap casing intervals improperly<\/li>\n\n\n\n<li>Filter packs surround screens<\/li>\n\n\n\n<li>Annular seals are correctly positioned<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">These checks improve confidence in monitoring well design.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-construction-sequence-validation\" class=\"wp-block-heading\">Construction Sequence Validation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A typical monitoring well contains:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Borehole<\/li>\n\n\n\n<li>Screen<\/li>\n\n\n\n<li>Filter pack<\/li>\n\n\n\n<li>Bentonite seal<\/li>\n\n\n\n<li>Surface completion<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation ensures components are arranged logically.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Incorrect sequences often indicate data entry mistakes.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-material-consistency-checks\" class=\"wp-block-heading\">Material Consistency Checks<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Validation can compare:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Screen type<\/li>\n\n\n\n<li>Casing material<\/li>\n\n\n\n<li>Well diameter<\/li>\n\n\n\n<li>Installation method<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This helps identify configuration problems before regulatory submissions.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-coordinate-cross-checking\" class=\"wp-block-heading\">Coordinate Cross-Checking<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Spatial errors are among the most expensive mistakes in geotechnical databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Incorrect coordinates can affect:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Geological models<\/li>\n\n\n\n<li>Resource estimates<\/li>\n\n\n\n<li>Groundwater studies<\/li>\n\n\n\n<li>Engineering designs<\/li>\n\n\n\n<li>Regulatory compliance<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation plays a critical role in spatial quality control.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-project-boundary-validation\" class=\"wp-block-heading\">Project Boundary Validation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Coordinates should fall within the project area.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Validation can automatically compare borehole locations against:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site boundaries<\/li>\n\n\n\n<li>Property limits<\/li>\n\n\n\n<li>Mining leases<\/li>\n\n\n\n<li>Construction corridors<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Boreholes outside the project area should be flagged.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-coordinate-system-verification\" class=\"wp-block-heading\">Coordinate System Verification<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Common issues include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>UTM vs State Plane confusion<\/li>\n\n\n\n<li>Latitude\/longitude reversal<\/li>\n\n\n\n<li>Incorrect projection<\/li>\n\n\n\n<li>Incorrect datum<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset checks can identify coordinates that do not align with other boreholes in the project.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-elevation-consistency\" class=\"wp-block-heading\">Elevation Consistency<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Collar elevations should remain consistent with site topography.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Borehole<\/td><td>Elevation<\/td><\/tr><tr><td>BH-101<\/td><td>325 m<\/td><\/tr><tr><td>BH-102<\/td><td>327 m<\/td><\/tr><tr><td>BH-103<\/td><td>1125 m<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The final elevation may indicate a unit conversion or entry error.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"h-duplicate-coordinate-detection\" class=\"wp-block-heading\">Duplicate Coordinate Detection<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Multiple boreholes occupying identical coordinates should be reviewed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Potential causes include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Duplicate boreholes<\/li>\n\n\n\n<li>Copy-and-paste errors<\/li>\n\n\n\n<li>GPS recording mistakes<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Automated validation can identify these issues immediately.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-workflow-integration\" class=\"wp-block-heading\">Workflow Integration<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation delivers the greatest benefit when integrated into the project workflow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Validation should occur:<\/p>\n\n\n\n<h3 id=\"h-during-data-entry\" class=\"wp-block-heading\">During Data Entry<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Immediate feedback prevents invalid records from accumulating.<\/p>\n\n\n\n<h3 id=\"h-during-import\" class=\"wp-block-heading\">During Import<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Imported datasets should be checked before being accepted into the database.<\/p>\n\n\n\n<h3 id=\"h-during-review\" class=\"wp-block-heading\">During Review<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Reviewers should see all unresolved cross-dataset issues.<\/p>\n\n\n\n<h3 id=\"h-before-approval\" class=\"wp-block-heading\">Before Approval<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Organizations often require:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No unresolved errors<\/li>\n\n\n\n<li>No critical validation failures<\/li>\n\n\n\n<li>All mandatory datasets present<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">before approving a borehole.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-benefits-of-cross-dataset-validation\" class=\"wp-block-heading\">Benefits of Cross-Dataset Validation<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Organizations implementing comprehensive cross-dataset validation often experience:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Improved data quality<\/li>\n\n\n\n<li>Reduced manual review effort<\/li>\n\n\n\n<li>Earlier error detection<\/li>\n\n\n\n<li>Better regulatory compliance<\/li>\n\n\n\n<li>More reliable geological models<\/li>\n\n\n\n<li>Increased confidence in reporting<\/li>\n\n\n\n<li>Reduced project risk<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Most importantly, validation becomes proactive rather than reactive.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Problems are identified when data is entered rather than when reports are generated.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-best-practices\" class=\"wp-block-heading\">Best Practices<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">To maximize effectiveness:<\/p>\n\n\n\n<h3 id=\"h-use-automated-rule-engines\" class=\"wp-block-heading\">Use Automated Rule Engines<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Automated validation ensures consistent application of rules across all projects.<\/p>\n\n\n\n<h3 id=\"h-assign-rule-ids\" class=\"wp-block-heading\">Assign Rule IDs<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>R-201 Lithology Coverage Check<\/li>\n\n\n\n<li>R-313 RQD Cannot Exceed Recovery<\/li>\n\n\n\n<li>R-405 SPT Depth Validation<\/li>\n\n\n\n<li>R-510 Screen Interval Validation<\/li>\n\n\n\n<li>R-620 Coordinate Boundary Check<\/li>\n<\/ul>\n\n\n\n<h3 id=\"h-differentiate-warnings-and-errors\" class=\"wp-block-heading\">Differentiate Warnings and Errors<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Not every inconsistency is invalid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Warnings should highlight unusual conditions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Errors should identify impossible conditions.<\/p>\n\n\n\n<h3 id=\"h-maintain-audit-trails\" class=\"wp-block-heading\">Maintain Audit Trails<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Track:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Validation date<\/li>\n\n\n\n<li>User<\/li>\n\n\n\n<li>Rule triggered<\/li>\n\n\n\n<li>Resolution status<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">for complete accountability.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 id=\"h-conclusion\" class=\"wp-block-heading\">Conclusion<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Cross-dataset validation is one of the most powerful tools available for maintaining high-quality geotechnical databases. While field-level checks remain important, many of the most significant data quality issues occur between datasets rather than within them. By validating relationships between lithology, sampling, recovery, RQD, SPT records, well construction data, and coordinates, organizations can detect inconsistencies early, reduce project risk, improve reporting accuracy, and build greater confidence in their geological and <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">geotechnical information.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As geotechnical databases continue to grow in size and complexity, cross-dataset validation will become an increasingly essential component of modern QA\/QC programs and digital borehole data management systems.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-35f06ea7 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gaeatech.com\/winlog.php\" target=\"_blank\" rel=\"noreferrer noopener\">Learn more about our Borehole Data Solutions<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Why Data Relationships Matter More Than Individual Data Fields Modern geotechnical, geological, environmental, and mining projects generate vast amounts of interconnected data. A single borehole may contain lithology logs, sampling records, laboratory results, recovery measurements, Rock Quality Designation (RQD) values, Standard Penetration Test (SPT) results, well construction details, survey information, and spatial coordinates. Most data [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":92585,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[792,1880],"tags":[1882,1887,1886,809,535,1167,1609,1888,1889,697],"class_list":["post-92584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-borehole-data-management","category-borehole-qa-qc","tag-borehole-validation","tag-coordinate-validation","tag-cross-dataset-validation","tag-geological-database","tag-geotechnical-database","tag-lithology-logging","tag-qa-qc","tag-recovery-and-rqd","tag-spt-validation","tag-well-construction"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.6.1 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Cross-Dataset Validation in Geotechnical Databases - Knowledge Center<\/title>\n<meta name=\"description\" content=\"Explore Cross-Dataset Validation in geotechnical databases to ensure consistent borehole data and improve project outcomes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cross-Dataset Validation in Geotechnical Databases\" \/>\n<meta property=\"og:description\" content=\"Explore Cross-Dataset Validation in geotechnical databases to ensure consistent borehole data and improve project outcomes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.linkedin.com\/company\/2663277\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-02T01:27:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"GAEA Technologies\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GAEA Technologies\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/\"},\"author\":{\"name\":\"GAEA Technologies\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#\\\/schema\\\/person\\\/940fb5fed6e95dd9d0ec1370207f5dba\"},\"headline\":\"Cross-Dataset Validation in Geotechnical Databases\",\"datePublished\":\"2026-06-02T01:27:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/\"},\"wordCount\":1434,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cross-dataset-validation-geotechnical-databases-hero.jpg\",\"keywords\":[\"borehole validation\",\"coordinate validation\",\"cross dataset validation\",\"Geological Database\",\"Geotechnical Database\",\"lithology logging\",\"QA QC\",\"recovery and rqd\",\"spt validation\",\"Well Construction\"],\"articleSection\":[\"Borehole Data Management\",\"QA\\\/QC\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/\",\"url\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/\",\"name\":\"Cross-Dataset Validation in Geotechnical Databases - Knowledge Center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cross-dataset-validation-geotechnical-databases-hero.jpg\",\"datePublished\":\"2026-06-02T01:27:30+00:00\",\"description\":\"Explore Cross-Dataset Validation in geotechnical databases to ensure consistent borehole data and improve project outcomes.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cross-dataset-validation-geotechnical-databases-hero.jpg\",\"contentUrl\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cross-dataset-validation-geotechnical-databases-hero.jpg\",\"width\":1536,\"height\":1024,\"caption\":\"Cross-dataset validation helps ensure consistency between lithology, sampling, recovery, RQD, SPT data, well construction records, and spatial coordinates within geotechnical databases.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/cross-dataset-validation-geotechnical-databases\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cross-Dataset Validation in Geotechnical Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#website\",\"url\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/\",\"name\":\"GAEA Technologies Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#organization\",\"name\":\"GAEA Technologies\",\"url\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Gaea_3dlogo_white-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Gaea_3dlogo_white-scaled.jpg\",\"width\":2560,\"height\":1440,\"caption\":\"GAEA Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/2663277\\\/\"],\"description\":\"GAEA Technologies develops and distributes geoscience and engineering solutions worldwide. Our solutions have been used for over 30 years by companies and organizations around the world.\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/#\\\/schema\\\/person\\\/940fb5fed6e95dd9d0ec1370207f5dba\",\"name\":\"GAEA Technologies\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cdc2b26dbe02c637b6e6ae5e99ff7928c8d2c7fb325dffb8da7e8b0af95dcbd7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cdc2b26dbe02c637b6e6ae5e99ff7928c8d2c7fb325dffb8da7e8b0af95dcbd7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cdc2b26dbe02c637b6e6ae5e99ff7928c8d2c7fb325dffb8da7e8b0af95dcbd7?s=96&d=mm&r=g\",\"caption\":\"GAEA Technologies\"},\"sameAs\":[\"https:\\\/\\\/gaeatech.com\\\/wordpress\"],\"url\":\"https:\\\/\\\/gaeatech.com\\\/knowledge-center\\\/author\\\/mfraser\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cross-Dataset Validation in Geotechnical Databases - Knowledge Center","description":"Explore Cross-Dataset Validation in geotechnical databases to ensure consistent borehole data and improve project outcomes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/","og_locale":"en_US","og_type":"article","og_title":"Cross-Dataset Validation in Geotechnical Databases","og_description":"Explore Cross-Dataset Validation in geotechnical databases to ensure consistent borehole data and improve project outcomes.","og_url":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/","og_site_name":"Knowledge Center","article_publisher":"https:\/\/www.linkedin.com\/company\/2663277\/","article_published_time":"2026-06-02T01:27:30+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg","type":"image\/jpeg"}],"author":"GAEA Technologies","twitter_card":"summary_large_image","twitter_misc":{"Written by":"GAEA Technologies","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#article","isPartOf":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/"},"author":{"name":"GAEA Technologies","@id":"https:\/\/gaeatech.com\/knowledge-center\/#\/schema\/person\/940fb5fed6e95dd9d0ec1370207f5dba"},"headline":"Cross-Dataset Validation in Geotechnical Databases","datePublished":"2026-06-02T01:27:30+00:00","mainEntityOfPage":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/"},"wordCount":1434,"commentCount":0,"publisher":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/#organization"},"image":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg","keywords":["borehole validation","coordinate validation","cross dataset validation","Geological Database","Geotechnical Database","lithology logging","QA QC","recovery and rqd","spt validation","Well Construction"],"articleSection":["Borehole Data Management","QA\/QC"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/","url":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/","name":"Cross-Dataset Validation in Geotechnical Databases - Knowledge Center","isPartOf":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#primaryimage"},"image":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg","datePublished":"2026-06-02T01:27:30+00:00","description":"Explore Cross-Dataset Validation in geotechnical databases to ensure consistent borehole data and improve project outcomes.","breadcrumb":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#primaryimage","url":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg","contentUrl":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg","width":1536,"height":1024,"caption":"Cross-dataset validation helps ensure consistency between lithology, sampling, recovery, RQD, SPT data, well construction records, and spatial coordinates within geotechnical databases."},{"@type":"BreadcrumbList","@id":"https:\/\/gaeatech.com\/knowledge-center\/cross-dataset-validation-geotechnical-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gaeatech.com\/knowledge-center\/"},{"@type":"ListItem","position":2,"name":"Cross-Dataset Validation in Geotechnical Databases"}]},{"@type":"WebSite","@id":"https:\/\/gaeatech.com\/knowledge-center\/#website","url":"https:\/\/gaeatech.com\/knowledge-center\/","name":"GAEA Technologies Blog","description":"","publisher":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gaeatech.com\/knowledge-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/gaeatech.com\/knowledge-center\/#organization","name":"GAEA Technologies","url":"https:\/\/gaeatech.com\/knowledge-center\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gaeatech.com\/knowledge-center\/#\/schema\/logo\/image\/","url":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2025\/12\/Gaea_3dlogo_white-scaled.jpg","contentUrl":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2025\/12\/Gaea_3dlogo_white-scaled.jpg","width":2560,"height":1440,"caption":"GAEA Technologies"},"image":{"@id":"https:\/\/gaeatech.com\/knowledge-center\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/2663277\/"],"description":"GAEA Technologies develops and distributes geoscience and engineering solutions worldwide. Our solutions have been used for over 30 years by companies and organizations around the world."},{"@type":"Person","@id":"https:\/\/gaeatech.com\/knowledge-center\/#\/schema\/person\/940fb5fed6e95dd9d0ec1370207f5dba","name":"GAEA Technologies","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/cdc2b26dbe02c637b6e6ae5e99ff7928c8d2c7fb325dffb8da7e8b0af95dcbd7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cdc2b26dbe02c637b6e6ae5e99ff7928c8d2c7fb325dffb8da7e8b0af95dcbd7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cdc2b26dbe02c637b6e6ae5e99ff7928c8d2c7fb325dffb8da7e8b0af95dcbd7?s=96&d=mm&r=g","caption":"GAEA Technologies"},"sameAs":["https:\/\/gaeatech.com\/wordpress"],"url":"https:\/\/gaeatech.com\/knowledge-center\/author\/mfraser\/"}]}},"jetpack_featured_media_url":"https:\/\/gaeatech.com\/knowledge-center\/wp-content\/uploads\/2026\/06\/cross-dataset-validation-geotechnical-databases-hero.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/posts\/92584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/comments?post=92584"}],"version-history":[{"count":2,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/posts\/92584\/revisions"}],"predecessor-version":[{"id":92588,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/posts\/92584\/revisions\/92588"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/media\/92585"}],"wp:attachment":[{"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/media?parent=92584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/categories?post=92584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gaeatech.com\/knowledge-center\/wp-json\/wp\/v2\/tags?post=92584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}