ST_Georeference

更新时间:
复制 MD 格式

Returns the georeference metadata of a raster object as six comma-separated affine parameters in the format A,B,C,D,E,F.

Syntax

text ST_Georeference(raster raster_obj);

Parameters

ParameterDescription
raster_objThe raster object.

Return value

Returns a text value containing six comma-separated affine parameters. The parameters represent the affine transformation coefficients that define the mapping between pixel coordinates and geographic coordinates.

Examples

Retrieve the georeference metadata for a raster object:

SELECT ST_Georeference(raster_obj) FROM raster_table WHERE id = 1;

Output:

2.500000000000000,0.000000000000000,38604686.750000000000000,0.000000000000000,-2.500000000000000,4573895.750000000000000