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.oxenstie...@t-kartor.com
<mailto:andreas.oxenstie...@t-kartor.com>
www.t-kartor.com <http://www.t-kartor.com>
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev