[Qgis-user] Clip raster with vectorlayer in Postgis

[Lene Fischer]

Hi Casper,
Tried to use the GDAL Clip, but it seems to be the ‘Cutline’ that miss a table name.

gdalwarp -ot Float32 -q -of GTiff -dstnodata 0 -cutline "PG:dbname='projekter' port=5432 user='postgres' password='xxxx' sslmode=disable" -crop_to_cutline -co COMPRESS=DEFLATE -co PREDICTOR=1 -co ZLEVEL=6 -wo OPTIMIZE_SIZE=TRUE C:/gis/bettedanmark/bettedanmark.vrt "[temporary file]"

I try to open a bug report on this.
Thanks for your help


Lene Fischer
Associate Professor

University of Copenhagen
Department of Geoscience and Natural Resource Management
Forest and Landscape College
Nødebovej 77a
3480 Fredensborg
Denmark


MOB +45 40115084
lfi at ign.ku.dk<mailto:lfi at ign.ku.dk>







From: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Casper Bertelsen
Sent: 10. januar 2018 09:52
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Clip raster with vectorlayer in Postgis

Hi Lene,

Using the Toolbox I get the option to use my vectorlayer from PostGIS. However I did not have any luck getting it to clip with the GDAL-clipper (Trying with a shape file there was no problem), but using the SAGA Clip raster with polygon works fine for me :)

Mvh. / Best regards
Casper Bertelsen

Mail: casperbj94 at gmail.com<mailto:casperbj94 at gmail.com>

On 10-01-2018 08:51, Lene Fischer wrote:
Hi
Just started to use PostGIS in QGIS. I only have vector data in postGIS
When I try to clip a raster layer with a vector mask (PostGIS) the layer is not shown in the drop down meny.
So I had to ‘Save As’ shape before clipping. Is this correct ?

Regards


Lene Fischer
Associate Professor

University of Copenhagen
Department of Geoscience and Natural Resource Management
Forest and Landscape College
Nødebovej 77a
3480 Fredensborg
Denmark


MOB +45 40115084
lfi at ign.ku.dk<mailto:lfi at ign.ku.dk>





_______________________________________________

Qgis-user mailing list

Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>

List info: https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180110/612b357f/attachment.html>