ST_Georeference

更新时间:
复制 MD 格式

Returns the geographic reference information about a raster object as a comma-separated string of 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 string of affine parameters in the format "A,B,C,D,E,F".

Examples

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

Output:

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

What's next

  • ST_SetGeoReference: Set or update the georeference metadata of a raster object.

  • ST_ScaleX: Return the X scale coefficient directly.

  • ST_ScaleY: Return the Y scale coefficient directly.