<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16447">
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Consolas;
}
@page WordSection1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P.MsoPlainText {
MARGIN: 0in 0in 0pt; FONT-FAMILY: Consolas; FONT-SIZE: 10.5pt; mso-style-priority: 99; mso-style-link: "Plain Text Char"
}
LI.MsoPlainText {
MARGIN: 0in 0in 0pt; FONT-FAMILY: Consolas; FONT-SIZE: 10.5pt; mso-style-priority: 99; mso-style-link: "Plain Text Char"
}
DIV.MsoPlainText {
MARGIN: 0in 0in 0pt; FONT-FAMILY: Consolas; FONT-SIZE: 10.5pt; mso-style-priority: 99; mso-style-link: "Plain Text Char"
}
P.MsoAcetate {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
LI.MsoAcetate {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
DIV.MsoAcetate {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
SPAN.PlainTextChar {
FONT-FAMILY: Consolas; mso-style-priority: 99; mso-style-link: "Plain Text"; mso-style-name: "Plain Text Char"
}
SPAN.BalloonTextChar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text"; mso-style-name: "Balloon Text Char"
}
.MsoChpDefault {
mso-style-type: export-only
}
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
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"
lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial>Olivier,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial>You can use FWTools or Tamas nightly builds.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/documentation/manual-2.0/RT_FAQ.html#id2979398">http://www.postgis.org/documentation/manual-2.0/RT_FAQ.html#id2979398</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial>Both have gdalinfo.exe. Tamas always has the latest and
greatest.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=502100422-15082012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=502100422-15082012></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Hope that helps,</FONT></FONT></FONT></DIV>
<DIV><SPAN class=502100422-15082012></SPAN><SPAN
class=502100422-15082012></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN class=502100422-15082012>egina</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=502100422-15082012></SPAN><SPAN
class=502100422-15082012></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><A href="http://www.postgis.us">h<SPAN
class=502100422-15082012>ttp://www.postgis.us</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=502100422-15082012></SPAN></FONT></FONT></FONT><BR> </DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Olivier Courtin<BR><B>Sent:</B> Wednesday, August 15, 2012 10:48
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Could not add all rasters to a table<BR></FONT><BR></DIV>
<DIV></DIV>
<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>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BODY></HTML>