[postgis-users] Postgis raster data display

celati laurent lcelati at latitude-geosystems.com
Tue Jul 10 04:03:13 PDT 2012


Hello,

I'm trying to display "Raster postgis data" via Qgis ("Load Postgis 
Raster Layer"). It works but it's a bit slow!
These raster are 11 Rapideye satellite images with 5 bands in native. I 
defined following overviews for each data : 3,9,27,81,243
Size of smallest SQL file : 270 MO
Size of biggest SQL file : 679 MO

1/What do you think about overviews values ?
2/According to you, the plugin is abble to display a sql file with a 
size of 679 MO ?
3/In native, these data have 5 bands but we need display only 3 bands. 
According to you, is it better before importing these data in database 
to remove 2 useless bands in order to speed up the display ?
4/Is there update regarding the speed problem ( Gdal driver issue).
5/Is there another way faster (Gvsig for instance) in displaying postgis 
raster data?
Thank you to throw light for me.

Regards.

Laurent Celati.

-- 
Laurent Celati – Geospatial applications specialist - LATITUDE GEOSYSTEMS
47, avenue de la Division Leclerc - 95170 Deuil-la-Barre, FRANCE
Tel : + 33 (0)1 34 17 23 84 - Fax : + 33 (0) 1 39 64 04 86
mob : + 33 (0)6 xx xx xx xx
skype lcelati
E-mail : lcelati at latitude-geosystems.com
http://www.latitude-geosystems.com




More information about the postgis-users mailing list