<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
Thank you ! I'm using the revision r7616. I will use the current revision.<BR>
<BR>
David<BR>
<BR>
<DIV>
<DIV id=ecxSkyDrivePlaceholder></DIV>> Date: Wed, 19 Oct 2011 12:36:46 -0700<BR>> From: dustymugs@gmail.com<BR>> To: postgis-devel@postgis.refractions.net<BR>> Subject: Re: [postgis-devel] PostGIS Raster problem<BR>> <BR>> On 10/19/2011 12:21 PM, David B�langer wrote:<BR>> ><BR>> > Hi,<BR>> > I use the GDAL driver to extract a raster from PostGIS 2.0 but I got bad results. The x and y of the upper left corner and the resolution are bad. It seems that these properties have been rounded. This problem has appeared since the summer version of PostGIS 2.0. I didn't have this problem before. I think the problem is in the ST_MetaData() function which is used by the GDAL driver. I know that this function was modified this summer. The others functions (eg. ST_ScaleX, ST_ScaleY, ST_UpperLeftX...) give good results.<BR>> ><BR>> > I have compared the result of the summer version of PostGIS with the old version.<BR>> > The results:<BR>> > select ST_MetaData(rast)…:<BR>> > Old version of database: "(-71.7501041666667,45.5001041666667,1200,1200,0.000208333333333333, 0.000208333333333333,0,0,4269,1)"<BR>> > Database Since this summer: "(-71.750104,45.500104,1200,1200,0.000208, -0.000208,0,0,4269,1)"<BR>> > The result of the old version of the database is the truth.<BR>> ><BR>> > Does anyone know this problem and can you help me?<BR>> ><BR>> > Thanks !<BR>> > David <BR>> ><BR>> ><BR>> <BR>> What revisions of PostGIS trunk are you using? I rewrote the <BR>> ST_Metadata function over the summer and had to tweak it some time <BR>> afterwards due to how the values were getting rounded depending on how <BR>> the C function returned (Datums vs. CStrings).<BR>> <BR>> After digging through the logs, you'll want to be using r7638 <BR>> (7/14/2011) or more recent to ensure that your answers are correct.<BR>> <BR>> -bborie<BR>> _______________________________________________<BR>> postgis-devel mailing list<BR>> postgis-devel@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-devel<BR></DIV> </div></body>
</html>