Name

ST_Affine, 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.144. 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))

      


© 1992 - OpenLink Software. All rights reserved.

Making Technology Work for You®