Matching Properties
Overview
Merge with Staging uses matching to find similar wells, well samples and non-well samples in the Staging area.
Version: 2.0+ (Oct 2021)
Usage: Data upload, data merge and de-duplication.
Matching properties:
A well, well sample and non-well sample need at least one matching property to be eligible to be merged with Staging. A well or sample will be considered a match if it matches on at least one of the matching criteria.
Well matching
The matching properties for wells (or more strictly wellbores) are:
Matching Property | Matching Criterion / Comment |
Lat.Well, Long.Well | Within a tolerance of 150 m on the great arc between the locations on a WGS84 globe |
Location.Well | Based on the cleaned string |
Well Name.Well | Based on the cleaned string |
UWI.Well | Based on the cleaned string |
IHS ID.Well | Based on the cleaned string |
Internal#.Well | Based on the cleaned string |
Note that the string cleaning we apply is to strip any non-alphabetic or numeric characters, and turn the resulting string to lower case.
Well samples
The matching properties for well samples are:
Matching property | Matching criterion / comment |
Wellbore id | This is based on the matching from the Well matching result - the user will not see this |
Name.Sample | Based on the cleaned string |
Test#.Sample | Based on the cleaned string |
Internal#.Sample | Based on the cleaned string |
Vendor#.Sample | Based on the cleaned string |
Container#.Sample | Based on the cleaned string |
Base MD.Sample | Within a tolerance of 0.1 m |
Top MD.Sample | Within a tolerance of 0.1 m |
Sam date.Sample | Within a tolerance of 1 hour |
Non-well samples
The matching criteria for non-well samples (e.g. outcrops, seeps etc) are:
Matching property | Matching criterion / comment |
Lat.Sample, Long.Sample | Within a tolerance of 150 m on the great arc between the locations on a WGS84 globe |
Location.Sample | Based on the cleaned string |
Name.Sample | Based on the cleaned string |
Test#.Sample | Based on the cleaned string |
Internal#.Sample | Based on the cleaned string |
Vendor#.Sample | Based on the cleaned string |
Container#.Sample | Based on the cleaned string |
Sam date.Sample | Within a tolerance of 1 hour |
The matching criteria effectively provide guidance on whether a well or sample could be considered a possible match - the fact they do match should not be taken as evidence of a certain match and thus merge. Care should always be taken to review matches.
© 2024 Integrated Geochemical Interpretation Ltd. All rights reserved.