ST_SameAlignment
Prev 9.14. Raster and Raster Band Spatial Relationships Next

Name

ST_SameAlignment — Returns true if rasters have same skew, scale, spatial ref and false if they don't with notice detailing issue.

Synopsis

boolean ST_SameAlignment( raster rastA , raster rastB );

boolean ST_SameAlignment( double precision ulx1 , double precision uly1 , double precision scalex1 , double precision scaley1 , double precision skewx1 , double precision skewy1 , double precision ulx2 , double precision uly2 , double precision scalex2 , double precision scaley2 , double precision skewx2 , double precision skewy2 );

Description

Returns true if the raster have same skew scale etc. Returns false if they don't and a NOTICE detailing the alignment issue.

Availability: 2.0.0

Examples: Rasters

SELECT ST_SameAlignment(
	ST_MakeEmptyRaster(1, 1, 0, 0, 1, 1, 0, 0),
	ST_MakeEmptyRaster(1, 1, 0, 0, 1, 1, 0, 0)
) as sm;

sm
----
t

SELECT ST_SameAlignment(A.rast,b.rast)
 FROM dummy_rast AS A CROSS JOIN dummy_rast AS B;

 NOTICE:  The two rasters provided have different SRIDs
NOTICE:  The two rasters provided have different SRIDs
 st_samealignment
------------------
 t
 f
 f
 f

See Also

Section 5.1, “Loading and Creating Rasters”, ST_MakeEmptyRaster

Prev Up Next
ST_Intersects Home Chapter 10. PostGIS Raster Frequently Asked Questions