ST_ScaleX-AnalyticDB(AnalyticDB)-阿里云帮助中心

Returns the pixel width of a raster object on the X scale in the spatial reference system.

Prerequisites

The raster object must have a valid spatial reference system identifier (SRID).

float8 ST_ScaleX(raster raster_obj)

Parameter	Description
`raster_obj`	The raster object.

Query the X-axis and Y-axis pixel sizes of all raster objects in a table:

select st_scalex(rast), st_scaley(rast)
from raster_table;

Result:

 st_scalex | st_scaley
-----------+-----------
       1.3 |       0.3