[gdal-dev] SQL query to set column to GPKG raster pixel value of point intersection result

[Laurențiu Nicola]

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.

Laurentiu

On Thu, Dec 8, 2022, at 20:07, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev wrote:
> Hi,
>  
> 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.
>  
> 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.
>  
> Thanks,
> Jesse
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20221208/57aa95ad/attachment.htm>