Hi,

It feels like quite special tool. Have you considered to use the Sample Raster 
Values tool in QGIS? The description of the tool is:

Sample raster values
This algorithm creates a new vector layer with the same attributes of the input 
layer and the raster values corresponding on the point location.
If the raster layer has more than one band, all the band values are sampled.

-Jukka Rahkonen-

Lähettäjä: gdal-dev <gdal-dev-boun...@lists.osgeo.org> Puolesta Meyer, Jesse R. 
(GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev
Lähetetty: torstai 8. joulukuuta 2022 20.07
Vastaanottaja: gdal-dev@lists.osgeo.org
Aihe: [gdal-dev] SQL query to set column to GPKG raster pixel value of point 
intersection result

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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
  • ... Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev
    • ... Rahkonen Jukka
      • ... Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev
        • ... Even Rouault
          • ... Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev
            • ... Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev
              • ... Even Rouault
    • ... Laurențiu Nicola via gdal-dev

Reply via email to