Tag Info

New answers tagged


You need ST_Difference which returns the the geometry of a feature that does not intersect with another feature. In your case something like this: SELECT l.id, ST_Difference(l.geom, p.wkb_geometry) As diff_geom FROM lines l, polygons p Modify for your actual table and field names.


For irregular polygons, and assuming that your geotiff raster file is a binary raster, you could use GDAL_Calc: GDAL_Calc.py -A Mask.tif -B CutBigImageToClip.tif --outfile=SmallerFile.tif --NoDataValue=0 --Calc="B*(A>0)" This query will populate 0 where Mask.tif <= 0 and BigImage where the Mask > 0. To do this both rasters must be the same cell ...


I don't know if it's possible to clip a raster with an other raster but you could use gdaltindex to build the shapefile with the extent of your raster. http://www.gdal.org/gdaltindex.html


I have come up with a solution/ workaround (sightly specific to my problem): Step 1: Use clipper tool to extend the rasters to the same size. Step 2: Add the two rasters together. Step 3: In my situation the addition of the two rasters produced a raster where the values in the areas of interest (where I wanted more accurate data- note outside of these ...

Top 50 recent answers are included