Ah. I see that the Windows installation doesn't come with the gdal utilities. You can install GDAL using the OSGeo4W installer.
http://trac.osgeo.org/osgeo4w/ Once GDAL is installed, you should be able to call gdalinfo on the raster files and get a dump of the raster metadata. Overlap isn't a problem. The problem is that one of the rasters is not on the same "grid" as the other rasters. -bborie On 08/15/2012 06:57 AM, Melpati, Muni wrote: > Hi Park, > > I could not find gdalinfo.exe on my windows machine. I have installed postgis > 2.0. Should I install gdalinfo separately? I could not google to the > application download. Where should I find it? > > I could not find scale x/y values for the raster files. Moreover, I do not > see any problem in viewing them in ArcMap. They might overlap little bit on > the edges. But that is usually the case with raster images. > > Any help to sort of the problem. Thanks. > > > > Date: Tue, 14 Aug 2012 11:43:51 -0700 > > From: Bborie Park <bkp...@ucdavis.edu<mailto:bkp...@ucdavis.edu>> > > Subject: Re: [postgis-users] Could not add all rasters to a table. > > To: > postgis-users@postgis.refractions.net<mailto:postgis-users@postgis.refractions.net> > > Message-ID: > <502a9c67.5040...@ucdavis.edu<mailto:502a9c67.5040...@ucdavis.edu>> > > Content-Type: text/plain; charset=ISO-8859-1 > > > > 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... > > > > -bborie > > > > 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
