Does anyone know a nice and easy way to recenter a tiled raster table in PostGIS?
By recentering I mean that I have a raster that is centered on the Pacific, but I need to recenter it on Greenwhich/Europe. In a sense the effect would be to offset pixels while "rolling" pixels that fall off the right edge back around to the left edge. It would be easier if the entire raster data was just a single big raster, but due to large memory size I have chopped up the raster into several subrasters/tiles with the raster2pgsql -t option (which is the PostGIS approach to raster data), which means the operation would have to be done on a tile by tile basis making the solution slightly more challenging.
أكثر...
By recentering I mean that I have a raster that is centered on the Pacific, but I need to recenter it on Greenwhich/Europe. In a sense the effect would be to offset pixels while "rolling" pixels that fall off the right edge back around to the left edge. It would be easier if the entire raster data was just a single big raster, but due to large memory size I have chopped up the raster into several subrasters/tiles with the raster2pgsql -t option (which is the PostGIS approach to raster data), which means the operation would have to be done on a tile by tile basis making the solution slightly more challenging.
أكثر...