From 9f0cf493a0ee3abc5f5c069c41364cd047d40d2a Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Mon, 12 Apr 2010 20:58:39 +0000 Subject: [PATCH] Add quickie faq about exporting raster data from PostGIS git-svn-id: http://svn.osgeo.org/postgis/trunk@5535 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/faq_wktraster.xml | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) diff --git a/doc/faq_wktraster.xml b/doc/faq_wktraster.xml index a71d92a33..53f3d354d 100644 --- a/doc/faq_wktraster.xml +++ b/doc/faq_wktraster.xml @@ -53,6 +53,29 @@ Your particular gdal install may not support all formats. To verify the ones supported by your particular gdal install, you can use gdalinfo --formats + + + + Can I export my PostGIS WKT Raster data to other raster formats? + + + + Yes + GDAL 1.7+ has a PostGIS WKT Raster. If you are compiling from source, you need to include in your configure + --enable-FEATURE=WKTRaster --with-pg=path/to/pg_config to enable the driver. + + If you version of GDAL is compiled with the WKT Raster driver you should see PostGIS WKT Raster in list when you do + gdalinfo --formats + FWTools latest version for Windows is compiled with WKT Raster support. + To get a summary about your raster via gdal use gdalinfo: + gdalinfo "PG:host=localhost port=5432 dbname='mygisdb' user='postgres' password='whatever' schema='someschema' table=sometable" + + To export data to other raster formats, use gdal_translate the below will export all data into a table at 10% size. + gdal_translate -of PNG -outsize 10% 10% "PG:host=localhost dbname='mygisdb' user='postgres' password=whatever' schema='someschema' table=sometable" C:\somefile.png + + Refer to Reading Raster Data of PostGIS WKT Raster section + + -- 2.40.0