Hi,
As this is a access question, I am posting this question this forum. I have also posted this question for QGIS to know if this can be done also through this software. https://gis.stackexchange.com/questions/314787/qgis-3d-data-set-with-stacked-points-at-different-elevations-is-it-possible-t
I have been trying this for nearly a year, and i still unable to find a way around this.
I have a 3D dataset consisting of xyz and property. The data points are along vertical axis (boreholes), and at different XYZ 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 (where the new soil type starts from a top down direction).
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 there would be a better way to do this than Cross Join, 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.
here is the query in SQL
SELECT [GEOMOD_m&masl_7].BORE_HOLE_ID, [GEOMOD_m&masl_7].ZONE, [GEOMOD_m&masl_7].EAST83, [GEOMOD_m&masl_7].NORTH83, [GEOMOD_m&masl_7].ELEVATION, [GEOMOD_m&masl_7].LAYER, [GEOMOD_m&masl_7].MAT1, [GEOMOD_m&masl_7].[_code_formation_Material_DES], [GEOMOD_m&masl_7].MAT2, [GEOMOD_m&masl_7].[_code_formation_Material_1_DES], [GEOMOD_m&masl_7].MAT3, [GEOMOD_m&masl_7].[_code_formation_Material_2_DES], [GEOMOD_m&masl_7].FORMATION_TOP_DEPTH, [GEOMOD_m&masl_7].FORMATION_END_DEPTH, [GEOMOD_m&masl_7].FORMATION_END_DEPTH_UOM, [GEOMOD_m&masl_7].TOP_MASL, [GEOMOD_m&masl_7].BOT_MASL, [elevation range].[elevation range]
FROM [GEOMOD_m&masl_7], [elevation range];