[postgis-devel] [PostGIS] #1404: [raster] raster2pgsql overviews don't look right

PostGIS trac at osgeo.org
Fri Dec 23 07:23:44 PST 2011


#1404: [raster] raster2pgsql overviews don't look right
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 This could be an issue with just windows.  But I'm finding that some of my
 main tiles do not intersect my overviews and on closer inspection my
 overviews look like they are missing parts.

 See attached that shows this query.

 The overview tile that this rast is in and my 593 rid rast


 {{{
 SELECT rast
 FROM (SELECT * from aerials.o_2_boston WHERE ST_Intersects(rast,(SELECT
 rast FROM aerials.boston WHERE rid = 593) )  ) as foo;
 }}}

 I don't think I had this issue with the raster2pgsql.py.  Then again could
 be the way I have my original files laid out, but that doesn't explain why
 some aerial tiles with obvious data in them are not intersecting the
 overviews.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1404>
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.


More information about the postgis-devel mailing list