I have this working now:-
CREATE MATERIALIZED VIEW mapping_raster.streetview_tileindex AS
SELECT 'PG:host=localhost port=5432 …. schema=''mapping__raster''
table=''streetview'' mode=''1'' where=rid='||rid as location,
ST_ConvexHull(rast) as shape from mapping_raster.streetview
Thanks for the
Note that the current Wiki entry is here:
https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Database-RASTERS
And when you do get this working, please update this for the other PostGIS
users.
Mike
--
Michael Smith
US Army Corps
Remote Sensing GIS/Center
From: Rahkonen