in access you use 2 tables one with the range of a particular attribute and the actual table you are working with, and you do a query. the key is to not connect any attibute between tables when doing the query, this way Access runs every possible permutation; its called a Cross Join query/table. then you have to export to excel or do it Access and only keep point that are in between your data range ( example : ground surface and bottom of borehole at that location). i havent found another way of doing this but i am sure coding would work too.
On Sat, Nov 3, 2018, 05:12 Nicolas Cadieux, <nicolas.cadi...@archeotec.ca> wrote: > Hi, > > I am not quite sure I understand what you are asking but in Excel you > could use a “round up” function. Then perhaps use this rounded up number > to do a vlookup on a table having the next higher up value? Not sure how to > do that in Access. > > Not sure how or if you can do that in QGIS... I would need to see actual > problem i think to be able to fully understand it. > > Nicolas > > > > Le 2 nov. 2018 à 21:28, Francois Chartier <fra.chart...@gmail.com> a > écrit : > > > > Hi, > > > > I am using Microsoft Access to populate a data set at regular intervals > along the vertical axis between two elevation ranges (50 to 350 masl) and > have the attribute (which does not exist) of that elevation to become the > attribute of the above data point. example at 124.4, attribute at location > 1 is A, therefore at 124 attribute becomes A, and this down to the next > data point at example 121.6 masl where it is B (you will at location 1: at > 124=A, 123=A, 122=A). > > The goal being to interpolate different elevation slices at regular > intervals as data points are not all at the same elevations depending on > location. > > I am able to do this with a Cross Join query in access and then removing > any intervals above top and bottom. this is quite fastiduous, and i am > wondering if i can do this straight in qgis, or > > if i can run an interpolation with a condition that the value at > location x,y equals the next above attribute value. this would keep the > attribute table much smaller. > > > > thanks > > F > > _______________________________________________ > > Qgis-user mailing list > > Qgis-user@lists.osgeo.org > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
