[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