<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;">I want to create a WMS service from map server that has raster tiles stored in a postgis database</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">I have loaded the tiles and have a table RASTERS as follows:-</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><div id="bloop_customfont" style="margin: 0px;">CREATE TABLE mapping_raster.streetview</div><div id="bloop_customfont" style="margin: 0px;">(</div><div id="bloop_customfont" style="margin: 0px;"> rid serial NOT NULL,</div><div id="bloop_customfont" style="margin: 0px;"> rast raster,</div><div id="bloop_customfont" style="margin: 0px;"> filename text,</div><div id="bloop_customfont" style="margin: 0px;"> CONSTRAINT streetview_pkey PRIMARY KEY (rid)</div><div id="bloop_customfont" style="margin: 0px;">)</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">I understand that Mapserver now needs two layers as per this link <a href="https://trac.osgeo.org/mapserver/wiki/DatabaseTileIndex">https://trac.osgeo.org/mapserver/wiki/DatabaseTileIndex</a></div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">How do I create the tile index table from my raster data? The Oracle example query looks like:-</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;"><span style="font-family: monospace;">create or replace view my_raster_tindex as select some_attribute, 'geor: user/pass@tns, raster_table_DATA,'||r.raster.rasterid location, R.RASTER.spatialextent shape from rasters_table r;</span></div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">I don’t properly understand which attribute links to the raster in the tile index?</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">TIA</div><div id="bloop_customfont" style="margin: 0px;">Dave </div></div><br><div id="bloop_sign_1408528436487045888" 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>