<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoPlainText>Hi Park,<o:p></o:p></p><p class=MsoPlainText>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?<o:p></o:p></p><p class=MsoPlainText>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.<o:p></o:p></p><p class=MsoPlainText>Any help to sort of the problem. Thanks.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Date: Tue, 14 Aug 2012 11:43:51 -0700<o:p></o:p></p><p class=MsoPlainText>From: Bborie Park <<a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a>><o:p></o:p></p><p class=MsoPlainText>Subject: Re: [postgis-users] Could not add all rasters to a table.<o:p></o:p></p><p class=MsoPlainText>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><o:p></o:p></p><p class=MsoPlainText>Message-ID: <<a href="mailto:502A9C67.5040901@ucdavis.edu">502A9C67.5040901@ucdavis.edu</a>><o:p></o:p></p><p class=MsoPlainText>Content-Type: text/plain; charset=ISO-8859-1<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>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...<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>(rast1X - rast2X) / scaleX = whole number<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>(rast1Y - rast2Y) / scaleY = whole number<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>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...<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>-bborie<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>On 08/14/2012 11:32 AM, Melpati, Muni wrote:<o:p></o:p></p><p class=MsoPlainText>> Hi,<o:p></o:p></p><p class=MsoPlainText>> 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.<o:p></o:p></p><p class=MsoPlainText>> What must be going wrong?<o:p></o:p></p><p class=MsoPlainText>> <o:p></o:p></p><p class=MsoPlainText>> Here is the text in the bat file:<o:p></o:p></p><p class=MsoPlainText>> path=%path%;"E:\PostgreSQL\8.4\bin<o:p></o:p></p><p class=MsoPlainText>> cd /D "%~dp0"<o:p></o:p></p><p class=MsoPlainText>> raster2pgsql -I -C -e -Y -F -s 26986 -t 300x300 -l 2,4 <o:p></o:p></p><p class=MsoPlainText>> F:\PostGIS\raster\*.jpg private_schema.rasterly1 | psql -h localhost <o:p></o:p></p><p class=MsoPlainText>> -U postgres -d gis_raster -p 5433<o:p></o:p></p><p class=MsoPlainText>> <o:p></o:p></p><p class=MsoPlainText>> pause<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>