I want to create a WMS service from map server that has raster tiles stored in
a postgis database
I have loaded the tiles and have a table RASTERS as follows:-
CREATE TABLE mapping_raster.streetview
(
rid serial NOT NULL,
rast raster,
filename text,
CONSTRAINT streetview_pkey PRIMARY
..just needed to read the documentation a little harder, I’m assuming it is:-
CREATE MATERIALIZED VIEW mapping_raster.streetview_tileindex AS SELECT rid as
location, ST_ConvexHull(rast) as shape from mapping_raster.streetview
--
Dave Barter
Web: http://www.phased.co.uk
Final question. How should my map file look in order to get the raster tile
from the database not the file system?
LAYER
# CREATE MATERIALIZED VIEW
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location,
ST_ConvexHull(rast) as shape from
I’ve figured this out,
CREATE MATERIALIZED VIEW mapping_os_opendata_raster.streetview_tileindex AS
SELECT rid as location, ST_ConvexHull(rast) as shape from
mapping_os_opendata_raster.streetview
“location needs to be a path to the database/table/raster currently it is just
returning an ID,
Perhaps it is something like this (from
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html)
“Reading raster data from the database
If you want to use the GDAL WKT Raster driver, you must provide a connection
string as Dataset's name. The syntax of this connection string is (the quotes
may be
10:01:00 -0300
From: jmcke...@gatewaygeomatics.com
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Postgis tile index not working
Nelson Correia wrote:
Hi,
I'm trying to use a postgis layer as tile index of a raster layer and
can't get it working.
Here
Nelson Correia wrote:
Hi,
I'm trying to use a postgis layer as tile index of a raster layer and
can't get it working.
Here are the layers I'm using:
LAYER
NAME layer_tindex
TYPE POLYGON
CONNECTIONTYPE POSTGIS