Opened 9 years ago

Last modified 7 years ago

#3044 new enhancement

[raster] raster2pgsql should have an option to align tiles

Reported by: pracine Owned by: Bborie Park
Priority: medium Milestone: PostGIS Fund Me
Component: raster Version: master
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 (3)

comment:1 by pracine, 9 years ago

Description: modified (diff)

comment:2 by Bborie Park, 9 years ago

Milestone: PostGIS Future

comment:3 by robe, 7 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.