Generating a list of distances from the bottom of boreholes to a layer/tin - gct

We've got a huge database of historical data on a project.  There are several hundred holes.   I've got a proposed surface for new construction.  I'm trying to come up with a way to find out which holes do not extend far enough into the ground to reach the layer for proposed excavation.  I guess a list isn't particularly needed, but perhaps highlighting/visualizing within the file.   If I can get a relative distance from that layer, it would be helpful too.

  • Hi Jeff,

    I may have a solution, if you add the lithology for your boreholes, and then create terrains for the deepest layer, using top and bottom; you will end up with a MicroStation terrain element that would represent the bottom of your deepest layer and also the bottom of all boreholes. Let me know if that works

    Regards 

    Nicolas

  • I've created a layer representing the bottom of the holes.  I'm not certain it really gets me where I want.  I'm talking about measuring a vertical distance from the bottom of the hole to a specific tin.  Say for instance I've got a historic boring with a top of hole 1150 and a bottom hole of 1125.  A future project is going to cut this area to 1120; I've got a tin for the proposed excavation.  Now say I've got 100+ holes along this project.  I want to generate a list of distances from the bottom of each hole to the proposed excavation.  So the answer for the example hole would be 5 or -5, depending on how I write it.  I know I can measure each one individually, but I'd like to figure out a way to do this more efficiently.  I'd even be satisfied with a list of proposed tin elevations at each borehole location.  I could do the rest pretty easily.