<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'>
<SPAN lang=fr-ca><FONT face=Arial size=2>Hi,</FONT></SPAN> <BR><SPAN lang=fr-ca><FONT face=Arial size=2>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.</FONT></SPAN><BR>
<SPAN lang=fr-ca><FONT face=Arial size=2> </FONT></SPAN> <BR><SPAN lang=fr-ca><FONT face=Arial size=2>I have compared the result of the summer version of PostGIS with the old version. </FONT></SPAN><BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>The results: </FONT></SPAN><BR><SPAN lang=fr-ca><FONT face=Arial size=2>select ST_MetaData(rast)…:</FONT></SPAN> <BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>Old version of database: "(-71.7501041666667,45.5001041666667,1200,1200,0.000208333333333333, 0.000208333333333333,0,0,4269,1)" </FONT></SPAN><BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>Database Since this summer: "(-71.750104,45.500104,1200,1200,0.000208, -0.000208,0,0,4269,1)"</FONT></SPAN> <BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>The result of the old version of the database is the truth.</FONT></SPAN><BR>
<SPAN lang=fr-ca><FONT face=Arial></FONT></SPAN> <BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>Does anyone know this problem and can you help me?</FONT></SPAN><BR>
<SPAN lang=fr-ca></SPAN> <BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>Thanks !</FONT></SPAN> <BR>
<SPAN lang=fr-ca><FONT face=Arial size=2>David</FONT></SPAN><BR> </div></body>
</html>