[postgis-users] out-db

[Bborie Park]

For visualizing, I usually just suggest keeping the rasters out-db but
still make sure that in the database, the rasters are tiled.  Something
like...

raster2pgsql -t 100x100 -R myraster myschema.mytable

You should be able to use geoserver directly, as I can't confirm that
(just through the grapevine).

-bborie

On 01/11/2013 09:51 AM, LPlateAndy wrote:
> Hi bborie,
> 
> Thanks, i was starting to worry.
> 
> I'm actually just thinking how to manage a raster dataset (3 band) with a
> few hundred thousand tiles (4000*4000 px) each.
> 
> It's only to visualise but i thought it would be neat to use PostGIS so i
> could easily introduce a timestamp and query the most up to date raster
> layer for a given date.
> 
> Would i be better using something like imagemosaic through geoserver? I
> intend to use geoserver anyway at some point for other bits.
> 
> The hits on the data for viewing as a backdrop are currently fairly low but
> it would be interesting to know your thoughts should i need it to scale.
> 
> Thanks again
> 
> Andy
> 
> 
> 
> --
> View this message in context: http://postgis.17.n6.nabble.com/out-db-tp5002226p5002234.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu