[mapserver-users] Postgis Tile Index

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

Re: [mapserver-users] Postgis Tile Index

..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

Re: [mapserver-users] Postgis Tile Index

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

Re: [mapserver-users] Postgis Tile Index

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,

Re: [mapserver-users] Postgis Tile Index

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

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

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

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

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

Re: [mapserver-users] WMS request fails when spaces are encoded as plus symbol in query part of URL

Steve, You are right about the outcome of 1 and 2. 1 encodes the % and 2 throws the following error. msBuildWMSLayerURLBase(): One of wms_onlineresource, wms_server_version, wms_name metadata is missing in layer USGS DRG 250k Topo Maps. Please either provide a valid CONNECTION URL, or

[mapserver-users] Postgis Raster Layer

One final question for today! When I use mapserver wms to serve the raster tiles from the file system, they look fine. But doing it from the database gives me problems with the black labels as can be seen by the image at 

Re: [mapserver-users] Postgis Raster Layer

AFAIK The same problem of the label is also on lines. See in your sample the boundaries of street. A. Il 20/ago/2014 16:53 Dave Barter dave.bar...@gmail.com ha scritto: One final question for today! When I use mapserver wms to serve the raster tiles from the file system, they look fine. But

Re: [mapserver-users] Postgis Raster Layer

I guess iT is a resampling question. My theory is that you dont see this issue with on polygon filled with solid color because the resample strategy find the same color in all the considered portion of polygon. This is not true for labels or lines. If this theory is true, it should fail also

Re: [mapserver-users] Postgis Raster Layer

Further investigation in QGIS shows that it is pixel value 161 that is not displaying gdalinfo tells me that  161: 0,0,0,255 for the raster So, can I correct this in map server, and why is it not rendering it as black? On 20 August 2014 at 16:12:06, Andrea Peri (aperi2...@gmail.com) wrote: I

Re: [mapserver-users] Postgis Raster Layer

I bet that 0 0 0 is interpreted as nodata for some reason. -Jukka Rahkonen- Lähettäjä: Dave Bartermailto:dave.bar...@gmail.com Lähetetty: ‎20.‎8.‎2014 19:01 Vastaanottaja: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org Aihe: Re: