Home

PostGIS cheatsheet

Get NODATA value:

select st_bandnodatavalue(rast, 1), st_bandnodatavalue(rast, 2) from file_jelbrqhpickujrbtqwyp;

Get info

select st_pixelwidth(A.rast) as pxWa, st_pixelheight(A.rast) as pxHa, st_pixelwidth(B.rast) as pxWb, st_pixelheight(B.rast) as pxHb, st_width(A.rast) as wA, st_height(A.rast) as hA, st_width(B.rast) as wB, st_height(B.rast) as hB, st_scalex(A.rast) as scalexA, st_scalex(B.rast) as scalexB, st_skewx(A.rast) as skewxA, st_skewx(B.rast) as skewxB from file_kguekgquebpafblewhne as A, file_vxrelgsabnyisfreftdh as B;

Check alignment

`SELECT ST_SameAlignment( A.rast, B.rast ), ST_NotSameAlignmentReason( A.rast, B.rast )

from file_kguekgquebpafblewhne as A, file_dquamjioaefmnspnpzah as B

;`