<!DOCTYPE html><html><head><title></title><style type="text/css">#qt p.qt-MsoNormal{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:0in;font-size:12pt;font-family:Calibri, sans-serif;}
p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div style="font-family:Arial;">https://www.orfeo-toolbox.org/ has an app for something like this (SampleExtraction?), but I think it writes the values into a new file and last time I tried, it think it only worked with shapefiles did some reason.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">Laurentiu</div><div style="font-family:Arial;"><br></div><div>On Thu, Dec 8, 2022, at 20:07, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev wrote:<br></div><blockquote type="cite" id="qt" style="overflow-wrap:break-word;"><div class="qt-WordSection1"><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;">Hi,</span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;"> </span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;">I have GPKG database with features represented by point geometries. I’d like to update these features, in a single SQL statement, to add a new column whose value is the pixel value of an external GPKG raster
for which the point geometry intersects with. I was hoping to find an OGR SQL function similar to burn for this, but I’ve come up empty handed.</span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;"> </span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;">Is this functionality available? Ideally, without resorting to manually updating each feature individually in a user application. Otherwise, perhaps a feature request is in order.</span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;"> </span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;">Thanks,</span></span><br></p><p class="qt-MsoNormal"><span style=""><span class="size" style="font-size:11pt;">Jesse</span></span><br></p></div><div>_______________________________________________<br></div><div>gdal-dev mailing list<br></div><div><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br></div><div><a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></div><div><br></div></blockquote></body></html>