<html style="direction: ltr;">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body bidimailui-charset-is-forced="true" style="direction: ltr;"
bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-cite-prefix">On 11/05/2019 3:16, Francois Chartier
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CALyCC-8qmy3-PaXFkqvjcTsx-RkKqEYia0NOwh4vYcXrakrRGA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Sorry i realised later that in my current table i
didnt rename the columns. here are the extract from excel (300 K
pts).
<div>i am using the TopDepthRasterDEM_MASL as the Z elevation,
and the attribute i am interested in are Texture in mm and K
in m/sec<br>
<div><br>
</div>
<div>
<table style="border-collapse:collapse;width:761pt"
cellspacing="0" cellpadding="0" border="0" width="1013">
<colgroup><col style="width:48pt" width="64" span="6"> <col
style="width:142pt" width="189"> <col
style="width:135pt" width="179"> <col
style="width:48pt" width="64" span="2"> <col
style="width:100pt" width="133"> </colgroup><tbody>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64" height="19">BHID</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">Zone</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">EAST83</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">NORTH83</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">GTADEM</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">MAT1</td>
<td
style="width:142pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="189">BOTDepthRasterDEM_MASL</td>
<td
style="width:135pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="179">TOPDepthRasterDEM_MASL</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">TEXTURE_mm</td>
<td
style="width:48pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="64">BH_Type</td>
<td class="gmail-xl63"
style="width:100pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
width="133"> K </td>
</tr>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right" height="19">11105041</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">17</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">580165.3</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">4873100</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.8977</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">SAND</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">277.7976701</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.59767</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">1.21</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">WWR</td>
<td class="gmail-xl63"
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">
0.0000050 </td>
</tr>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right" height="19">11105041</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">17</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">580165.3</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">4873100</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.8977</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">SAND</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">275.5976698</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">277.7976701</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">1.21</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">WWR</td>
<td class="gmail-xl63"
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">
0.0000050 </td>
</tr>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right" height="19">11105041</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">17</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">580165.3</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">4873100</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.8977</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">SAND</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">269.1976702</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">275.5976698</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">1.21</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">WWR</td>
<td class="gmail-xl63"
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">
0.0000050 </td>
</tr>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right" height="19">11105041</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">17</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">580165.3</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">4873100</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.8977</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">SAND</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">277.7976701</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">278</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">1.21</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">WWR</td>
<td class="gmail-xl63"
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">
0.0000050 </td>
</tr>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right" height="19">11105041</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">17</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">580165.3</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">4873100</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.8977</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">SAND</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">277.7976701</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">1.21</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">WWR</td>
<td class="gmail-xl63"
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">
0.0000050 </td>
</tr>
<tr style="height:14.5pt" height="19">
<td
style="height:14.5pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right" height="19">11105041</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">17</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">580165.3</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">4873100</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">279.8977</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">SAND</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">275.5976698</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">276</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap"
align="right">1.21</td>
<td
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">WWR</td>
<td class="gmail-xl63"
style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">
0.0000050 </td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<br>
</blockquote>
<p><br>
</p>
<p>First you can start with the suggestion by Moritz, to get the
surface elevation from your DTM uisng v.what.rast.</p>
<p>Then, calculate the depth (from the surface) of each sample with
a simple v.db.update expression.</p>
<p>Finally an SQL query in db.execute will get a table of aggregated
texture and K for depth ranges that you choose. This table will be
piped into v.in.ascii to get a new point vector map for each depth
range. (You can run the db.execute command without v.in.ascii to
check that you're getting the results you expect)<br>
</p>
<p><br>
</p>
<p>Here are the commands:</p>
<p><br>
</p>
<p><tt># 1.Surface elevation</tt></p>
<p><tt>v.db.addcolumn map=borehole_samples column="depth DOUBLE,
surface_elev DOUBLE"</tt></p>
<p><tt>v.what.rast map=borehole_samples raster=dtm
column=surface_elev</tt></p>
<p><tt><br>
</tt></p>
<p><tt># 2.Get Depth of samples</tt></p>
<p><tt>v.db.update map=borehole_samples column=depth
query_column="surface_elev - TOPDepthRasterDEM_MASL"</tt></p>
<p><tt><br>
</tt></p>
<p><tt># 3. Now an aggregate query for the texture and K </tt></p>
<p><tt><span style="font-size: 12px"># depth from 0 to 10 m</span><br>
</tt></p>
<p><tt>db.execute -c sql="SELECT BHID as bhid, EAST83 AS x, NORTH83
AS y,</tt><tt> AVG(</tt><tt>TEXTURE_mm) as avg_texture, AVG(K)
as avg_K WHERE depth>=0 and depth<10 GROUP BY bhid,x,y" |
v.in.ascii input=- output=soil_characteristics_0 x=2 y=3
columns="bhid INTEGER, x DOUBLE, y DOUBLE, avg_texture DOUBLE,
avg_K DOUBLE"</tt></p>
<p><tt><span style="font-size: 12px"><br>
</span></tt></p>
<p><tt><span style="font-size: 12px"># depth from 10 to 20</span></tt></p>
<p><tt>db.execute -c sql="SELECT BHID as bhid, EAST83 AS x, NORTH83
AS y, </tt><tt>AVG(</tt><tt>TEXTURE_mm) as avg_texture, AVG(K)
as avg_K WHERE depth>=10 and depth<20 GROUP BY bhid,x,y" |
v.in.ascii input=- output=soil_characteristics_10 x=2 y=3
columns="bhid INTEGER, x DOUBLE, y DOUBLE, avg_texture DOUBLE,
avg_K DOUBLE"</tt></p>
<p><tt><br>
</tt></p>
<p><tt><span style="font-size: 12px"># and so on for all the depth
ranges you need.</span><br>
</tt></p>
<p><br>
</p>
<blockquote type="cite"
cite="mid:CALyCC-8qmy3-PaXFkqvjcTsx-RkKqEYia0NOwh4vYcXrakrRGA@mail.gmail.com">
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Le jeu. 9 mai 2019 à 22:45,
Micha Silver <<a href="mailto:tsvibar@gmail.com"
moz-do-not-send="true">tsvibar@gmail.com</a>> a écrit :<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="direction:ltr" bgcolor="#FFFFFF">
<p>OK, please clarify what each column reprepsents.</p>
<p><br>
</p>
<div class="gmail-m_-8956376600293267960moz-cite-prefix">On
10/05/2019 5:25, Francois Chartier wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><br>
<div><br>
</div>
<div><br>
</div>
<div>V.DB.SELECT</div>
<div><br>
</div>
<div>
<div>cat,int_1,int_2,dbl_1,dbl_2,dbl_3,str_1,dbl_4,dbl_5,dbl_6,str_2,dbl_7</div>
</div>
</div>
</div>
</div>
</blockquote>
cat, bore_id??, ??, easting?, northing?, depth?, soil_type,
??, ??, bulk_density??, WWR ?, hydraulic_conduct?? <br>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>
<div>1,11105041,17,580165.3,4873100,279.89767,SAND,277.7976701,279.59767,1.21,WWR,5e-006</div>
<div>2,11105041,17,580165.3,4873100,279.89767,SAND,275.5976698,277.7976701,1.21,WWR,5e-006</div>
<div>3,11105041,17,580165.3,4873100,279.89767,SAND,269.1976702,275.5976698,1.21,WWR,5e-006</div>
<div>4,11105041,17,580165.3,4873100,279.89767,SAND,277.7976701,278,1.21,WWR,5e-006</div>
<div>5,11105041,17,580165.3,4873100,279.89767,SAND,277.7976701,279,1.21,WWR,5e-006</div>
<div>6,11105041,17,580165.3,4873100,279.89767,SAND,275.5976698,276,1.21,WWR,5e-006</div>
<div>7,11105041,17,580165.3,4873100,279.89767,SAND,275.5976698,277,1.21,WWR,5e-006</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Le jeu. 9 mai 2019
à 04:59, Francois Chartier <<a
href="mailto:fra.chartier@gmail.com" target="_blank"
moz-do-not-send="true">fra.chartier@gmail.com</a>>
a écrit :<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="auto">sure i will send that later. thks</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu., May 9,
2019, 04:00 Micha Silver, <<a
href="mailto:tsvibar@gmail.com" target="_blank"
moz-do-not-send="true">tsvibar@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px
0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div style="direction:ltr" bgcolor="#FFFFFF"> <br>
<div
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-cite-prefix">On
08/05/2019 16:10, Moritz Lennert wrote:<br>
</div>
<blockquote type="cite">On 8/05/19 15:03,
Francois Chartier wrote: <br>
<blockquote type="cite">Hi Micha, <br>
<br>
I have soil samples from boreholes where i
have data points at every meter interval and
where soil type changes. i would like to
create a weighted average of soil property
for lets say the first 1 m below the DEM, so
that i can evaluate potential for
infiltration across a watershed. <br>
</blockquote>
<br>
You can use v.what.rast to read the DEM value
into the attribute table of your points. Then
you can do whatever calculations you need
based on that. <br>
<br>
Moritz <br>
<br>
</blockquote>
<p><br>
</p>
<p>After Moritz's answer, It seems that your
question is a data aggregation problem. If we
can see the actual structure of your data
(i.e. <tt><a href="http://v.info"
rel="noreferrer" target="_blank"
moz-do-not-send="true">v.info</a> -c</tt>
or <tt>v.db.select</tt> then more specific
responses might be possible. Best would be a
small subset of the actual data.</p>
<p><br>
</p>
<p><br>
</p>
<blockquote type="cite">
<blockquote type="cite"> <br>
On Wed., May 8, 2019, 08:17 Moritz Lennert,
<<a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-abbreviated"
href="mailto:mlennert@club.worldonline.be"
rel="noreferrer" target="_blank"
moz-do-not-send="true">mlennert@club.worldonline.be</a>
<a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-rfc2396E"
href="mailto:mlennert@club.worldonline.be"
rel="noreferrer" target="_blank"
moz-do-not-send="true"><mailto:mlennert@club.worldonline.be></a>>
wrote: <br>
<br>
On 8/05/19 14:00, Micha Silver wrote: <br>
> You will most likely have to
convert the points to raster. But <br>
before <br>
> that, can you explain what you
mean by "located for 10 m from <br>
DEM", "10 <br>
> to 20". <br>
<br>
Or, if you mean zones of equal height,
you can transform them to vector <br>
polygons and use v.vect.stats on these
polygons and the points. <br>
<br>
Moritz <br>
<br>
> <br>
> <br>
> On 08/05/2019 13:31, Francois
Chartier wrote: <br>
>> Hi <br>
>> <br>
>> I would like to use mapcalc
with types of input a DEM (raster) <br>
and xyz <br>
>> property (vector). basically,
I would like to do a weighted <br>
average <br>
>> of data points located for 10
m from DEM, then 10 to 20 etc. <br>
>> <br>
>>
_______________________________________________
<br>
>> grass-user mailing list <br>
>> <a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-abbreviated"
href="mailto:grass-user@lists.osgeo.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true">grass-user@lists.osgeo.org</a>
<a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-rfc2396E"
href="mailto:grass-user@lists.osgeo.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"><mailto:grass-user@lists.osgeo.org></a>
<br>
>> <a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-freetext"
href="https://lists.osgeo.org/mailman/listinfo/grass-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/grass-user</a>
<br>
> <br>
> -- <br>
> Micha Silver <br>
> Ben Gurion Univ. <br>
> Sde Boker, Remote Sensing Lab <br>
> +972-523-665918 <br>
> <br>
> <br>
>
_______________________________________________
<br>
> grass-user mailing list <br>
> <a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-abbreviated"
href="mailto:grass-user@lists.osgeo.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true">grass-user@lists.osgeo.org</a>
<a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-rfc2396E"
href="mailto:grass-user@lists.osgeo.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"><mailto:grass-user@lists.osgeo.org></a>
<br>
> <a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-freetext"
href="https://lists.osgeo.org/mailman/listinfo/grass-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/grass-user</a>
<br>
> <br>
<br>
<br>
</blockquote>
<br>
<br>
_______________________________________________ <br>
grass-user mailing list <br>
<a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-abbreviated"
href="mailto:grass-user@lists.osgeo.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true">grass-user@lists.osgeo.org</a>
<br>
<a
class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-txt-link-freetext"
href="https://lists.osgeo.org/mailman/listinfo/grass-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/grass-user</a><br>
</blockquote>
<pre class="gmail-m_-8956376600293267960gmail-m_-7949487239083078615m_8087355881221876012moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918</pre>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
<pre class="gmail-m_-8956376600293267960moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918</pre>
</div>
</blockquote>
</div>
</blockquote>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918</pre>
</body>
</html>