RS_MetaData¶

Returns raster metadata as a struct.

Usage¶

struct RS_MetaData(rast: raster)

Arguments¶

rast (raster): Input raster

Description¶

RS_MetaData() returns a struct containing:

upperLeftX, upperLeftY: origin of the raster geotransform
gridWidth, gridHeight: raster dimensions in pixels
scaleX, scaleY: pixel scale
skewX, skewY: geotransform skew terms
srid: raster SRID if available, otherwise 0
numSampleDimensions: band count
tileWidth, tileHeight: GDAL block size derived tile dimensions

For rasters with no bands, tileWidth and tileHeight are 0.

Examples¶

SELECT RS_MetaData(RS_Example());

┌──────────────────────────────────────────────────────────────────────────────┐
│                           rs_metadata(rs_example())                          │
│                                    struct                                    │
╞══════════════════════════════════════════════════════════════════════════════╡
│ {upperLeftX: 43.08, upperLeftY: 79.07, gridWidth: 64, gridHeight: 32, scale… │
└──────────────────────────────────────────────────────────────────────────────┘

SELECT meta."gridWidth", meta."gridHeight"
FROM (
  SELECT RS_MetaData(
    RS_FromPath('https://download.osgeo.org/geotiff/samples/gdal_eg/cea.tif')
  ) AS meta
) q;

┌───────────────────┬────────────────────┐
│ q.meta[gridWidth] ┆ q.meta[gridHeight] │
│       int64       ┆        int64       │
╞═══════════════════╪════════════════════╡
│               514 ┆                515 │
└───────────────────┴────────────────────┘