<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 style="font-size: 10pt;" face="Arial" size="2">I understand what you said but Is it possible
that the GDAL driver uses the ST_MetaData() function of PostGIS ? I’m using GDAL 1.8. I
don’t think that the problem is the version of GDAL because when I'm using
gdal_translate with an old version of PostGIS I'm having a good result but when
I'm using the version r7616 there is a problem. Like I said the x and y of the
upper left corner and the resolution of the data extracted are rounded. It is
exactly the same result of the ST_MetaData() function executed in an SQL API. It
is why I have suspected the problem in the ST_MetaData() function. Do you think
there is an other possibility ? Anyway I will intall the new version of PostGIS
and I will see.</font></span><BR><br><span lang="fr-ca"></span><BR><span lang="fr-ca"><font style="font-size: 10pt;" face="Arial" size="2">Thanks<br></font></span><BR>
<span lang="fr-ca"><font style="font-size: 10pt;" face="Arial" size="2"><br></font></span><BR><span lang="fr-ca"><font style="font-size: 10pt;" face="Arial" size="2">David</font></span><BR><br><br><div>> From: jorge.arevalo@deimos-space.com<br>> Date: Thu, 20 Oct 2011 10:05:19 +0200<br>> To: postgis-devel@postgis.refractions.net<br>> Subject: Re: [postgis-devel] PostGIS Raster problem<br>> <br>> I think it may be a confussion here. If you are using the ST_Metadata<br>> function, you're NOT using GDAL PostGIS Raster driver. The driver is<br>> used to read raster data from database without using the SQL API. For<br>> example, with gdalinfo, or gdal_translate.<br>> <br>> Anyway, which GDAL version are you using?<br>> <br>> On Wed, Oct 19, 2011 at 10:00 PM, David B�langer <belanger_david@live.ca> wrote:<br>> > Thank you ! I'm using the revision r7616. I will use the current revision.<br>> ><br>> > David<br>> ><br>> >> 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<br>> >> > results. The x and y of the upper left corner and the resolution are bad. It<br>> >> > seems that these properties have been rounded. This problem has appeared<br>> >> > since the summer version of PostGIS 2.0. I didn't have this problem before.<br>> >> > I think the problem is in the ST_MetaData() function which is used by the<br>> >> > GDAL driver. I know that this function was modified this summer. The others<br>> >> > 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<br>> >> > version.<br>> >> > The results:<br>> >> > select ST_MetaData(rast)…:<br>> >> > Old version of database:<br>> >> > "(-71.7501041666667,45.5001041666667,1200,1200,0.000208333333333333,<br>> >> > 0.000208333333333333,0,0,4269,1)"<br>> >> > Database Since this summer: "(-71.750104,45.500104,1200,1200,0.000208,<br>> >> > -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>> ><br>> > _______________________________________________<br>> > postgis-devel mailing list<br>> > postgis-devel@postgis.refractions.net<br>> > http://postgis.refractions.net/mailman/listinfo/postgis-devel<br>> ><br>> ><br>> <br>> <br>> <br>> -- <br>> Jorge Arévalo<br>> Internet & Mobility Division, DEIMOS<br>> jorge.arevalo@deimos-space.com<br>> http://es.linkedin.com/in/jorgearevalo80<br>> http://mobility.grupodeimos.com/<br>> http://gis4free.wordpress.com<br>> http://geohash.org/ezjqgrgzz0g<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>