[jira] [Created] (SEDONA-332) RS_Value don't need to fetch all the pixel data

[Kristin Cowalcijk (Jira)]

Kristin Cowalcijk created SEDONA-332:
----------------------------------------

             Summary: RS_Value don't need to fetch all the pixel data
                 Key: SEDONA-332
                 URL: https://issues.apache.org/jira/browse/SEDONA-332
             Project: Apache Sedona
          Issue Type: Bug
    Affects Versions: 1.4.1
            Reporter: Kristin Cowalcijk


Currently {{RS_Value}} always fetches all the pixel data ({{Raster raster = 
rasterGeom.getRenderedImage().getData()}}), which is unnecessary and may lead 
to problems when processing rasters loaded from large GeoTiff. We can fetch the 
tile containing the pixel data we want to get, instead of fetching all the 
tiles. We can make the following query load less data by doing this:

{code}
SELECT RS_Value(RS_FromGeoTiff(content), ST_Point(x, y)) FROM ...
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)