Top

Name

ST_Affine — performs standard 2d affine transformation

Synopsis

ST_Affine ( in XXa any ,
  in XYb any ,
  in YYe any ,
  in Xoff any ,
  in Yoff any );
 

Description

performs standard 2d affine transformation with matrix: 

XXa XXb 0
YXd YYe 0
0    0    0

and shift (Xoff, Yoff, 0)

Parameters

XXa

matrix a

XYb

matrix b

YYe

matrix e

Xoff

x

Yoff

y

Return Types

Returns any.

Examples

Example 24.135. Simple Use 

select st_affine (st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3),
                                         (1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'),
                  30, 3, 1, 0.3, 0.001, 0.002)
VARCHAR NOT NULL
_______________________________________________________________________________

POLYGON((39.001000 1.902000,
         72.001000 3.202000,
         45.001000 2.502000,
         12.001000 1.202000,
         39.001000 1.902000),
        (40.501000 2.052000,
         57.001000 2.702000,
         43.501000 2.352000,
         27.001000 1.702000,
         40.501000 2.052000))

Prev  Up  Next
gz_uncompress   Home  st_point