[postgis-users] Spoke too soon

[Paragon Corporation]

Darrell,

I'm having similar issues using our alpha3 build and latest comiled from
http://vbkto.dyndns.org/sdk/ .  There is an example in the FAQ with a text
field and that used to work when I tried it when I wrote that FAQ item a
while ago on windows.

I think it might be because of some changes in GDAL driver or raster that
broke string quoting.  I was hoping this was fixed already.  I've cc'd Jorge
since he manages the raster driver.
I think David Zwarg was planning to work on this at the code sprint which
should be starting soon.

Here is what I used to use which worked a while back:
gdal_translate -of PNG "PG:host=localhost port=5441 dbname=postgis20_sampler
user=postgres password='whatever' schema='aerials' table=test_100_100
mode='2' where="filename='23128870.jpg'"" C:\23128870.png

and now I get a: 
ERROR 1: Error browsing database for PostGIS Raster properties
GDALOpen failed - 1
Error browsing database for PostGIS Raster properties

I haven't checked my logs to see what query its running.  could be one of
the  field changes in the view.


As a work around, try this:

First figure out the rid range of the file with an SQL Query like:
SELECT max(rid), min(rid) FROM aerials.test_100_100 WHERE
filename='23128870.jpg';

gdal_translate -of PNG  "PG:host=localhost port=5441
dbname=postgis20_sampler user=postgres password='whatever' schema='aerials'
table=test_100_100 mode='2' where='rid between 1 and 2500'" C:\23128870.png

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Andy Colson
> Sent: Sunday, February 05, 2012 10:30 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Spoke too soon
> 
> On 02/05/2012 09:13 AM, Darrel Maddy wrote:
> > I would be grateful if someone could help me with the syntax for 
> > filenames when using the WHERE clause in gdal_translate
> >
> > I have
> > gdal_translate -of GTiff "PG:host=localhost port=5432  
> dbname=testcuda 
> > user=postgres password=H$%£"! schema=public table=rast100 
> > where='filename="Heights_11_10.tif"' mode=2" Height10.tif
> >
> > I tried various forms of the 'filename=' clause (and 
> simplifying the filename to H10.tif) but without success (the 
> form given on the FAQ does not work in windows either). What 
> does work is:
> >
> > gdal_translate -of GTiff "PG:host=localhost port=5432  
> dbname=testcuda 
> > user=postgres password= H$%£"!  schema=public table=rast100 
> > where='rid>someno AND rid<someno' mode=2" Height10.tif
> >
> > Obviously I can work with the latter but it requires me to 
> know the start and end rid (or do a query to find it). 
> Ideally I  would like to be able to just download the image 
> via the filename.
> >
> > Thanks in anticipation of your help.
> >
> > Darrel
> >
> >
> >
> 
> sql uses single quote for a string, and double quote for column names.
> 
> where='filename="Heights_11_10.tif"'
> 
> that probably meant: if column filename matched column 
> Heights_11_10.tif.
> 
> Try switching the quotes:
> 
> where="filename='Heights_11_10.tif' "
> 
> -Andy
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>