serving/caching from PGRaster/PostGIS 2.0?

[geoff osborn]

Hi

sorry am new to the group - have looked for some answers on this, but
not found anything yet. So apologies if I've missed something

I'm looking for a fast tileserver/caching that is capable of either
directly serving, or connecting to and caching rasters stored in
postgis 2.0/pgraster.

Are there any moves afoot to give tilestache this capability? If not,
what would it take to do this?

thanks for any response, best wishes,

Geoff

[Michal Migurski]

Hi Geoff,

I didn't even know that PG had a raster feature. How does it work?

-mike.

----------------------------------------------------------------
michal migurski- mi...@stamen.com
415.558.1610

[geoff osborn]

similar to rasterlite and prob mbtiles (I guess) . Couple of links
below.

http://www.postgresonline.com/journal/archives/156-PostGIS-Raster-its-on-10-things-you-can-do-NOW-with-raster.html
http://www.postgis.org/documentation/manual-svn/using_raster.xml.html

GDAL 1.9 is being written to include support for pgraster. QGIS has
support for (an earlier version of PGraster) called WKTraster.
WKTraster has been around for a couple of years as an add-on to
PostGIS but now included in PG 2.0

I guess what needs to be done is to add PostGIS 2.0 raster as a
provider to tilestache, or wait till GDAL 1.9....?

thanks,Geoff

[Michal Migurski]

Huh, interesting.

So how would this be used? It seems like it would find its way into the GDAL provider, for example.

-mike.

----------------------------------------------------------------
michal migurski- mi...@stamen.com
415.558.1610

[Arek Skalski]

Could you use directly raster as source ?  Then you could use an existing provider mapnik with plugin:  https://github.com/mapnik/mapnik/wiki/Raster   which gives you sollution out of the box.

2012/4/13 Michal Migurski <mi...@stamen.com>

[Michal Migurski]

Seems like it should be possible to pull raster data out into a GDAL-like provider if I'm understanding these descriptions properly. Mapnik could also supply an avenue into this; I'm not 100% up to date on Mapnik's raster capabilities.

-mike.

[Arek Skalski]

As far as I know mapnik there is a plugin rasterlite for mapnik supporting the raster inside the spatialite database. But I didn't find the postgis one yet. It's also easy to configure and may be even faster than standard raster plugin.

2012/4/14 Michal Migurski <mi...@stamen.com>

[Dane Springmeyer]

On Apr 13, 2012, at 7:22 PM, Michal Migurski wrote:

> Seems like it should be possible to pull raster data out into a GDAL-like provider if I'm understanding these descriptions properly.

Yes, Postgres's raster support uses GDAL itself I think under the hood - so that seems like a good route.

> Mapnik could also supply an avenue into this; I'm not 100% up to date on Mapnik's raster capabilities.

Yes, it could. We'll add pgraster support in the form of a Mapnik plugin at some point soon. But as far as TileStache, seems like direct to GDAL makes the most sense.