Hi,
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.
I have compared the result of the summer version of PostGIS with the old version.
The results:
select ST_MetaData(rast)…:
Old version of database: "(-71.7501041666667,45.5001041666667,1200,1200,0.000208333333333333, 0.000208333333333333,0,0,4269,1)"
Database Since this summer: "(-71.750104,45.500104,1200,1200,0.000208, -0.000208,0,0,4269,1)"
The result of the old version of the database is the truth.
Does anyone know this problem and can you help me?
Thanks !
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20111019/8c8ab04c/attachment.html>