[gdal-dev] gdal_translate clip PostGIS raster

[Even Rouault]

Try with gdalwarp and the -cutline family of arguments

Le 10/05/2021 à 19:23, Andreas Oxenstierna a écrit :
> Hi list
>
> Is it possible to clip a PostGIS raster with a PostGIS vector poly 
> using gdal_translate?
>
> I cannot find a working syntax to define the clipping table in the 
> WHERE clause.
> Eg. this returns "Error browsing database for PostGIS Raster 
> properties : ERROR:  syntax error at or near "FROM"
>
> gdal_translate -of GTiff "PG:<connectinfo> schema=a table=rastertable 
> WHERE='ST_Intersects(rast,c.geom) AND c.id <http://c.id> = 2 FROM 
> a.vectortable c'" a.tif
>
> Best regards
>
> Andreas Oxenstierna
> T-Kartor Geospatial AB
> Olof Mohlins väg 12 Kristianstad
> mobile: +46 733 206831
> mailto: andreas.oxenstierna at t-kartor.com 
> <mailto:andreas.oxenstierna at t-kartor.com>
> www.t-kartor.com <http://www.t-kartor.com>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210510/38b8a578/attachment.html>