[gdal-dev] gdal_translate clip PostGIS raster

[Andreas Oxenstierna]

Thanks

but still stumbling (using 2.3.2)
gdalwarp -cutline "PG:dbname=gisdb" -csql 'select * from polytest where id=1' -crop_to_cutline -of GTiff -srcnodata -9999 -dstnodata -9999 "PG:<connectinfo> schema=a table=rastertable" dest.tif

returns:
ERROR 1: Input file <rastertable> has no raster bands.

gdalinfo reports that the table is tiled in 360 pieces which potentially is the source for the issue:
Subdatasets:
  SUBDATASET_1_NAME=PG:host=

SUBDATASET_360_DESC=PostGIS Raster at

Hälsningar

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>
On 10 May 2021, 19:31 +0200, Even Rouault <even.rouault at spatialys.com>, wrote:

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<mailto: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/20210511/7f2e62a5/attachment.html>