I have a 3D dataset consisting of xyz and property. The data points are along vertical axis (boreholes), and at different XY locations (at other borehole location). The data points are not all at the same elevation between each borehole location due to different soil intervals, and the property value is only provided for the Top of the interval.
My goal is to populate the borehole with properties between different soil Tops of interval, so that I can map properties at different horizontal elevation slices.
I found how to do this with Cross Join Query in MS Access but this creates very large data sets which can make the software crash as it provides every permutation possible.
Once that is done, the data needs to be filtered. So I am wondering if in QGIS, if there is a way to do something similar without having to generate this huge dataset by a Cross Join query. For example it would resemble something like this in plain english: "show points at elevation 110 masl at each Borehole location, if no point at elevation 110, then pick next one up."