[postgis-users] Could not add all rasters to a table.

Bborie Park bkpark at ucdavis.edu
Tue Aug 14 11:43:51 PDT 2012

The error is just that: at least one raster isn't aligned with the other
rasters being added to that table.  One way to see what could be going
on is to use gdalinfo on the four rasters.  Check the values for the
upper-left corner, scale and skew.  The scale and skew should be the
same while the upper-left corners should be divisible without a remainder...

(rast1X - rast2X) / scaleX = whole number

(rast1Y - rast2Y) / scaleY = whole number

If all that looks good, post the outputs from gdalinfo for all four
rasters so that I can take a look and see if there are strange floating
point issues...


On 08/14/2012 11:32 AM, Melpati, Muni wrote:
> Hi,
> I am getting this error "raster with different alignment found in the set of rasters being converted to postgis raster" while I load all four jpg files into a new table. When I view them ArcMap they just seems to align well.
> What must be going wrong?
> Here is the text in the bat file:
> path=%path%;"E:\PostgreSQL\8.4\bin
> cd /D "%~dp0"
> raster2pgsql -I -C -e -Y -F -s 26986 -t 300x300  -l 2,4 F:\PostGIS\raster\*.jpg private_schema.rasterly1 | psql -h localhost -U postgres -d gis_raster -p 5433
> pause
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Bborie Park
Center for Vectorborne Diseases
UC Davis
bkpark at ucdavis.edu

More information about the postgis-users mailing list