From 710bc00d8c5806f7bd218f613ec38fb38478a077 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 14 Apr 2010 14:56:32 +0000 Subject: [PATCH] more gdal_translate examples git-svn-id: http://svn.osgeo.org/postgis/trunk@5550 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/faq_wktraster.xml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/faq_wktraster.xml b/doc/faq_wktraster.xml index 6c5a95fb8..3e0598d00 100644 --- a/doc/faq_wktraster.xml +++ b/doc/faq_wktraster.xml @@ -82,8 +82,9 @@ Here is an example simple translation gdal_translate -of PNG -outsize 10% 10% "PG:host=localhost dbname='mygisdb' user='postgres' password=whatever' schema='someschema' table=sometable" C:\somefile.png You can also use SQL where clauses in your export using the where=... in your driver connection string. - Below is one using a where clause + Below are some using a where clause gdal_translate -of PNG -outsize 10% 10% "PG:host=localhost dbname='mygisdb' user='postgres' password=whatever' schema='someschema' table=sometable where="owner='jimmy'" " C:\somefile.png + gdal_translate -of PNG -outsize 10% 10% "PG:host=localhost dbname='mygisdb' user='postgres' password=whatever' schema='someschema' table=sometable where='ST_Intersects(rast, ST_SetSRID(ST_Point(-71.032,42.3793),4326) )' " C:\intersectregion.png To see more examples and syntax refer to Reading Raster Data of PostGIS WKT Raster section -- 2.40.0