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 help, I will update the wiki shortly
On 20 August 2014 at 12:15:48, Smith, Michael ERDC-RDE-CRREL-NH
(michael.sm...@erdc.dren.mil) wrote:
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 Jukka (Tike)" <jukka.rahko...@mmmtike.fi>
Date: Wednesday, August 20, 2014 at 6:56 AM
To: Dave Barter <dave.bar...@gmail.com>, "mapserver-users@lists.osgeo.org"
<mapserver-users@lists.osgeo.org>
Subject: [EXTERNAL] Re: [mapserver-users] Postgis Tile Index
Resent-From: Michael Smith <michael.sm...@usace.army.mil>
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 ommitted):
PG:"host='<host>' port:'<port>' dbname='<dbname>' user='<user>'
password='<password>' [schema='<schema>'] [table='<raster_table>']
[where='<sql_where>'] [mode='<working_mode>']"
I would test first by using the string for one image as DATA of your raster
layer before to continue towards TILEINDEX+TILEITEM.
-Jukka Rahkonen-
Dave Barter wrote:
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, but I cannot find any documentation as to how to construct
this for postgres
So nearly there?
On 20 August 2014 at 11:34:03, Dave Barter (dave.bar...@gmail.com) wrote:
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 mapping_os_opendata_raster.streetview
NAME streetview_tileindex
TYPE polygon
PROJECTION
"init=epsg:27700"
END
CONNECTIONTYPE postgis
CONNECTION “********"
DATA "shape from (SELECT shape,location FROM
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location
using srid=27700"
END
LAYER
#RASTER TILE LAYERS MUST RUN FROM A TILEINDEX
NAME streetview
TYPE RASTER
STATUS ON
TILEINDEX "streetview_tileindex"
TILEITEM "location"
OFFSITE 0 0 0
PROJECTION
"init=epsg:27700"
END
DEBUG 5
EXTENT 0 0 3000000 1000000
END
This is not working as the layer street view returns an error:-
msDrawMap(): Image handling error. Failed to draw layer named 'streetview'.
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file
'654016' for layer 'street view’.
I set SHAPEFILE “” at the top of the file, but am unclear as to how the
streetview layer will retrieve the tile ?
--
Dave Barter
Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users