[postgis-devel] [PostGIS] #1808: [raster] Raster importation creates gaps and corrupted data

[PostGIS]

#1808: [raster] Raster importation creates gaps and corrupted data
--------------------+-------------------------------------------------------
 Reporter:  molgor  |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  high    |   Milestone:  PostGIS 2.0.1
Component:  raster  |     Version:  2.0.x        
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by dustymugs):

 If I import tile1114.tif using raster2pgsql

 {{{
 raster2pgsql -s 4326 -I -C tile1114.tif tile1114 | psql -U postgres -d
 test
 }}}

 And then view the table tile1114 in QGIS, it gives me a crazy output and
 strange pixel values.  But, when looking at the pixels through the
 following query...

 {{{
 WITH foo AS (
         SELECT ST_PixelAsPolygons(rast) AS gv FROM tile1114
 )
 SELECT
         (gv).val,
         count(*)
 FROM foo
 GROUP BY 1
 }}}

 There are no strange values and everything looks correct.  I'll test some
 more tiles to see if I can reproduce this.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1808#comment:10>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.