From 6f3e33730fae6d03330a82d735dd9f5db21245c4 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 18 May 2011 12:55:32 +0000 Subject: [PATCH] define ST_SRText and backref git-svn-id: http://svn.osgeo.org/postgis/trunk@7190 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_raster.xml | 54 +++++++++++++++++++++++++++++++++++++--- 1 file changed, 50 insertions(+), 4 deletions(-) diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml index 5a4dfb710..d34632338 100644 --- a/doc/reference_raster.xml +++ b/doc/reference_raster.xml @@ -1441,6 +1441,52 @@ srid , + + + + ST_SRText + Returns the spatial reference srtext from spatial_ref_sys table corresponding to srid of raster. + + + + + + text ST_SRText + raster rast + + + + + + Description + + Returns the srtext corresponding to the spatial referenceof the raster object as defined in the spatial_ref_sys table. If not + defined returns proj4text and if not in spatial_ref_sys returns NULL. + + Availability: 2.0.0 + + + + Examples + + SELECT ST_SRSText(rast) As srtext +FROM somerast_table WHERE rid=2; + +srtext +---------------- +"GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563, +AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]], +PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]], +UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]" + + + + + + See Also + , + + @@ -3335,9 +3381,9 @@ FROM dummy_rast WHERE rid=2; nbands is an array of bands to export (note that max is 3 for PNG) and the order of the bands is RGB. e.g ARRAY[3,2,1] means map band 3 to Red, band 2 to green and band 1 to blue - compression Compression expression -- JPEG90 (or someother percent), LZMA, JPEG, DEFALTE9 - options text Array of GDAL create options as defined for GTiff (look at create_options for GTiff of ). or refer to GDAL Raster format options for more details. - + compression Compression expression -- JPEG90 (or someother percent), LZMA, JPEG, DEFALTE9. + options text Array of GDAL create options as defined for GTiff (look at create_options for GTiff of ). or refer to GDAL Raster format options for more details. + srs If not specified uses the srtext corresponding to the spatial_ref_sys of the raster. Availability: 2.0.0 - requires GDAL >= 1.6.0. @@ -3354,7 +3400,7 @@ FROM dummy_rast WHERE rid=2; See Also - , + , , -- 2.50.1