Opened 2 years ago

Last modified 2 years ago

#3044 new enhancement

[raster] raster2pgsql should have an option to align tiles

Reported by: pracine Owned by: dustymugs
Priority: medium Milestone: PostGIS Future
Component: raster Version: trunk
Keywords: Cc:

Description (last modified by pracine)

We should have the possibility to provide gridx and gridy coordinates of an arbitrary grid corner to tell the loader on which grid to align the tiles produced when using the -t option. This would allow rasters having different upperleft corner alignment to be tiled on the same grid in the same table.

Some tiles would have to be padded not only on the right and lower sides but also on the left and upper sides.

The gridx and gridy must be aligned with the pixel grid. Otherwise we would have to resample the raster before tiling which is time consuming. Pixel alignment is normally done with gdalwarp or gdal_translate as a preloading process.

ST_Tile() should also get those two extra gridx and gridy parameters.

Could be -A 0.0x0.0

Change History (2)

comment:1 Changed 2 years ago by pracine

Description: modified (diff)

comment:2 Changed 2 years ago by dustymugs

Milestone: PostGIS Future
Note: See TracTickets for help on using tickets.