Clipping a DEM in Spatialite

[José Sánchez]

Hi,

I there any specific function to clip a raster within spatialite based on a pair of corner coordinates and/or based on a rectangle or shapefile and export the raster outside spatialite?

Thanks,

[mj10777]

On Thursday, 17 May 2018 13:31:50 UTC+2, José Sánchez wrote:

Hi,

I there any specific function to clip a raster within spatialite based on a pair of corner coordinates and/or based on a rectangle or shapefile and export the raster outside spatialite?

If it a external raster: no, for this you must use gdalwarp parameters 

-crop_to_cutline : use -cutline and -csql for cutting

-cutline : dame of spatialite-database

-csql a valid sql to retrieve the Polygon to use as cutline

Sample:

-crop_to_cutline -cutline Berlin_Liebenow.maps.gcp.db -csql "SELECT cutline_polygon FROM create_cutline_polygons WHERE ((id_gcp_coverage = (SELECT id_gcp_coverage FROM gcp_coverages WHERE (raster_file LIKE '1867.Berlin_Liebenow_5_Pariser_Platz.6250%'))) AND (cutline_type=77));

As a RasterLite2 image use the export commands.

Mark

Thanks,