[postgis-devel] PostGIS Raster problem

David B�langer belanger_david at live.ca
Wed Oct 19 12:21:12 PDT 2011

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 ! 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20111019/8c8ab04c/attachment.html>

More information about the postgis-devel mailing list