[SEDONA-332] RS_Value and RS_Values don't need to fetch all the pixel data

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.1
• Fix Version/s: 1.5.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Kristin Cowalcijk
• Created: 28/Jul/23 05:57
• Updated: 19/Aug/23 23:35
• Resolved: 19/Aug/23 23:35

Description

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:

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

Issue Links

• links to: GitHub Pull Request #931