<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Final question. How should my map file look in order to get the raster tile from the database not the file system?</div><div><br></div><div>LAYER</div><div> # 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 </div><div> NAME streetview_tileindex</div><div> TYPE polygon</div><div> PROJECTION</div><div> "init=epsg:27700"</div><div> END</div><div> CONNECTIONTYPE postgis</div><div> CONNECTION “********"</div><div> DATA "shape from (SELECT shape,location FROM mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location using srid=27700"</div><div><br></div><div> END</div><div><br></div><div> LAYER</div><div> #RASTER TILE LAYERS MUST RUN FROM A TILEINDEX</div><div> NAME streetview</div><div> TYPE RASTER</div><div> STATUS ON</div><div> TILEINDEX "streetview_tileindex"</div><div> TILEITEM "location"</div><div> OFFSITE 0 0 0 </div><div> PROJECTION</div><div> "init=epsg:27700"</div><div> END</div><div> DEBUG 5</div><div> EXTENT 0 0 3000000 1000000</div><div><br></div><div> END</div><div><br></div><div>This is not working as the layer street view returns an error:- </div><div><br></div><div>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’.</div><div><br></div><div>I set SHAPEFILE “” at the top of the file, but am unclear as to how the streetview layer will retrieve the tile ?</div><div><br></div><div><br></div><div><br></div><div id="bloop_sign_1408530673579525120" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px"><span style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;">-- </span><br style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;"><span style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;">Dave Barter</span><br style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;"><br style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;"><span style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;">Web: </span><a href="http://www.phased.co.uk/" target="_blank" style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;">http://www.phased.co.uk</a><br style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;"><a href="mailto:Email%3Adave@phased.co.uk" target="_blank" style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;">Email:dave@phased.co.uk</a><br style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;"><span style="line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; font-family: arial; font-size: small;">Twitter:@Citizenfishy</span></div></div></body></html>