ST_GeoReference
Name
ST_GeoReference — Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. Default is GDAL.
Synopsis
text
ST_GeoReference
(
raster
rast
, text
format=GDAL
)
;
Description
Returns the georeference meta data including carriage return in GDAL or ESRI format as commonly seen in a world file . Default is GDAL if no type specified. type is string 'GDAL' or 'ESRI'.
Difference between format representations is as follows:
GDAL
:
Output
scalex skewy skewx scaley upperleftx upperlefty
ESRI
:
Output
scalex skewy skewx scaley upperleftx + scalex*0.5 upperlefty + scaley*0.5
Examples
Code
SELECT
format,
replace(ST_GeoReference(rast, format), E'\n', ' | ') AS georef
FROM dummy_rast
CROSS JOIN (VALUES ('ESRI'), ('GDAL')) AS formats(format)
WHERE rid = 1;
Output
format | georef --------+--------------------------------------------------------------------------- ESRI | 2.0000000000 | 0.0000000000 | 0.0000000000 | 3.0000000000 | 1.5000000000 | 2.0000000000 GDAL | 2.0000000000 | 0.0000000000 | 0.0000000000 | 3.0000000000 | 0.5000000000 | 0.5000000000 (2 rows)