[postgis-devel] [PostGIS] #497: [raster] Start testing displaying PostGIS raster with Mapserver

PostGIS trac at osgeo.org
Tue Feb 15 13:20:05 PST 2011


#497: [raster] Start testing displaying PostGIS raster with Mapserver
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  task            |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I started to test this earnestly and as expected its kind of slow to put.
 Though it does eventually render.  Of course I picked the cruelest of
 tests -- trying to load aerials.

 My layer looks something like this and I was pulling via OpenLayers.


 {{{
   LAYER
           NAME boston_aerials
           TYPE raster
           STATUS ON
           DATA "PG:host='localhost' port='5432' dbname='ma' user='ma'
 schema='aerials' table='o_2_boston' mode='2'"
           PROJECTION
            "init=epsg:26986"
            END
   END
 }}}

 On inspecting the queries it seems to be doing some very intensive stupid
 things, but it does also do make box queries but using ~ instead of &&
 which we were planning on deprecating and irradicating.

 so basically these are the two kinds of  queries I am seeing as I zoom on
 the map.


 {{{
 SELECT rid, rast FROM aerials.o_2_boston WHERE rast ~
 ST_SETSRID(ST_makebox2d(st_point(225866,892151),
 st_point(225926,892211)),26986);

 select (foo.md).*, foo.rid from (select rid, st_metadata(rast) as md
 from aerials.o_2_boston) as foo

 }}}

 why does it need to pull all the meta data for the whole table?  I'll do
 some more logging to make sure its not just that the query is being cut
 off and I'm not seeing the whole thing.

 I'm using a couple of days old GDAL trunk with mapserver I believe.

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