From 181b22b54cb78462df6b49d9dff746e937b98bf7 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 17 Apr 2010 00:57:52 +0000 Subject: [PATCH] ST_SkewX, ST_SkewY, ST_SetSkew git-svn-id: http://svn.osgeo.org/postgis/trunk@5561 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_wktraster.xml | 186 ++++++++++++++++++++++++++++++++++++ 1 file changed, 186 insertions(+) diff --git a/doc/reference_wktraster.xml b/doc/reference_wktraster.xml index 696f06356..3918d8db6 100644 --- a/doc/reference_wktraster.xml +++ b/doc/reference_wktraster.xml @@ -879,6 +879,116 @@ FROM dummy_rast; + + + ST_SkewX + Returns the georeference X skew (or rotation parameter) + + + + + + float8 ST_SkewX + raster rast + + + + + + Description + + Returns the georeference X skew (or rotation parameter). Refer to World File + for more details. + + + + Examples + + SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, + ST_GeoReference(rast) as georef +FROM dummy_rast; + + rid | skewx | skewy | georef +-----+-------+-------+-------------------- + 1 | 0 | 0 | 2.0000000000 + : 0.0000000000 + : 0.0000000000 + : 3.0000000000 + : 0.5000000000 + : 0.5000000000 + : + 2 | 0 | 0 | 0.0500000000 + : 0.0000000000 + : 0.0000000000 + : -0.0500000000 + : 3427927.7500000000 + : 5793244.0000000000 + + + + + + + See Also + , + + + + + + ST_SkewY + Returns the georeference Y skew (or rotation parameter) + + + + + + float8 ST_SkewY + raster rast + + + + + + Description + + Returns the georeference Y skew (or rotation parameter). Refer to World File + for more details. + + + + Examples + + SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, + ST_GeoReference(rast) as georef +FROM dummy_rast; + + rid | skewx | skewy | georef +-----+-------+-------+-------------------- + 1 | 0 | 0 | 2.0000000000 + : 0.0000000000 + : 0.0000000000 + : 3.0000000000 + : 0.5000000000 + : 0.5000000000 + : + 2 | 0 | 0 | 0.0500000000 + : 0.0000000000 + : 0.0000000000 + : -0.0500000000 + : 3427927.7500000000 + : 5793244.0000000000 + + + + + + + See Also + , , + + + ST_SRID @@ -1350,6 +1460,82 @@ WHERE rid = 2; , , + + + + ST_SetSkew + Sets the georeference X and Y skew (or rotation parameter). If only one is passed in sets x and y to same number. + + + + + + raster ST_SetSkew + raster rast + float8 skewxy + + + raster ST_SetSkew + raster rast + float8 skewx + float8 skewy + + + + + + Description + + Sets the georeference X and Y skew (or rotation parameter). If only one is passed in sets x and y to same number. Refer to World File + for more details. + + + + Examples + + +-- Example 1 +UPDATE dummy_rast SET rast = ST_SetSkew(rast,1,2) WHERE rid = 1; +SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, + ST_GeoReference(rast) as georef +FROM dummy_rast WHERE rid = 1; + +rid | skewx | skewy | georef +----+-------+-------+-------------- + 1 | 1 | 2 | 2.0000000000 + : 2.0000000000 + : 1.0000000000 + : 3.0000000000 + : 0.5000000000 + : 0.5000000000 + + + + +-- Example 2 set both to same number: +UPDATE dummy_rast SET rast = ST_SetSkew(rast,0) WHERE rid = 1; +SELECT rid, ST_SkewX(rast) As skewx, ST_SkewY(rast) As skewy, + ST_GeoReference(rast) as georef +FROM dummy_rast WHERE rid = 1; + + rid | skewx | skewy | georef +-----+-------+-------+-------------- + 1 | 0 | 0 | 2.0000000000 + : 0.0000000000 + : 0.0000000000 + : 3.0000000000 + : 0.5000000000 + : 0.5000000000 + + + + + + + See Also + , , + + -- 2.40.0