Hey Jesse,
I *think* I simplified your query a bit. Untested, but it may work.
delete from {label_name}
where gdal_get_pixel_value('{raster_fp}', {ndvi_band_num}, 'georef',
ST_X(st_centroid(geom)), ST_Y(st_centroid(geom))) < 600
Scott
On 1/8/25 12:53, Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYS
8.0)[SCIENCE SYSTEMS AND APPLICATIONS INC] via gdal-dev
Sent: Wednesday, January 8, 2025 1:53 PM
To: gdal-dev@lists.osgeo.org
Subject: [gdal-dev] Seeking SQL wizardry
◆ This message was sent from a non-UWYO address. Please exercise caution when
clicking links or opening attachments from external sou
BTW If this question is too specific to SQL and I should seek aid elsewhere,
please let me know.
I am able to return a layer of rowids associated with features whose geotiff
band value at the centroid location is above a particular threshold. I then
turn back around and delete all such feature
