mjacqu / glenglat

Global Englacial Temperature database
Creative Commons Attribution 4.0 International
2 stars 0 forks source link

Resolve and merge duplicate boreholes #39

Closed ezwelty closed 1 year ago

ezwelty commented 1 year ago

Before the advent of the profile table, boreholes with multiple measurement profiles were added as multiple boreholes, each with one profile. These should be resolved and correctly represented as a single borehole with multiple profiles. The tricky thing is that it is not always clear whether two rows in borehole with identical latitude and longitude are:

Borehole mergers

The proposed merges are presented below with the id of the first borehole on the left, and the id of subsequent boreholes on the right. In each case, we need to determine whether they are the same borehole.

Same borehole and merged

Different boreholes