By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
hole_id | block_id | xcollar | ycollar | zcollar | HOLE_NO |
---|---|---|---|---|---|
2B24D001B01 | 2B24D001 | 4382.693 | 3858.52 | 109.725 | B01 |
2B25D001B01 | 2B25D001 | 4382.693 | 3858.52 | 109.725 | B01 |
2B25D001B02 | 2B25D001 | 7383.893 | 9356.03 | 662.5 | B02 |
2B24D001B02 | 2B24D001 | 7383.893 | 9356.03 | 662.5 | B02 |
2B24D001B03 | 2B24D001 | 8876.038 | 3352.216 | 399.38 | B03 |
2B25D001B03 | 2B25D001 | 8876.038 | 3352.216 | 399.38 | B03 |
1B13D078B03 | 1B13D078 | 8876.038 | 3352.216 | 399.38 | B03 |
1B12D078B03 | 1B13D078 | 1828.253 | 3556.26 | 392.53 | B03 |