Re: [otb-users] OTB PostgreSQL API

[Guillaume Pasero]

Hi, In OTB, almost every image is opened using GDAL. If you manage to have GDAL reading from a PostGIS database, it should be transparent on OTB side. More information here: https://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html The same goes for the shape->PostGIS, if you can directly output the vector segmentation in a PostGIS table, it should be faster. (http://www.gdal.org/drv_pg.html) About the LSMS Smoothing performance, there may be a way to improve the situation with the parameters exposed in the application. Regards, Guillaume On 07/28/2016 09:11 AM, Jiří Fejfar wrote: Hi all, I am performing segmentation on many Landsat8 scenes stored in PostgreSQL / PostGIS. I have a very sub-optimal work-flow (all is done in Python script on server side): export tiled raster from PostGIS to .tiff image perform 4 steps of LSMS segmentation using python API resulting in .shp with segments import this with shp2pgsql back to table in PostGIS. Although this is working it has several drawbacks I have found that first step of LSMS is not linear regarding elapsed time and amount of data (see attached image) ... I have found not possible to process with this step whole Landsat8 scene, so I am doing whole before-mentioned pipeline in cycle processing 5 rows (1 consists from tiles of the size 128 x 128 px) loosing advantage of artifacts free result. I believe it can be much faster. Because of that I am trying to find the way, how to pass tiled image from PostgreSQL directly to OTB... I have found http://wiki.orfeo-toolbox.org/index.php/OTB-PostGIS_Interface but it seems to be focused opposite way: expose PostGIS functionality to OTB. I would like to expose OTB functionality (actually only LSMS 4 steps) directly to PostGIS. Do you know such existing API? If there is no such API, I would like to contribute to that. I have experience creating API exposing C++ classes / functions to PostgreSQL like described in 35.9.13. Using C++ for Extensibility. Best regards, Jiří. -- -- Check the OTB FAQ at http://www.orfeo-toolbox.org/FAQ.html   You received this message because you are subscribed to the Google Groups "otb-users" group. To post to this group, send email to otb-users@googlegroups.com To unsubscribe from this group, send email to otb-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/otb-users?hl=en --- You received this message because you are subscribed to the Google Groups "otb-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to otb-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Guillaume PASERO Responsable technique Business Unit E-SPACE & Geo Information - Département Image & Applications CS Systèmes d'Information Parc de la Grande Plaine - 5, Rue Brindejonc des Moulinais - BP 15872 31506 Toulouse Cedex 05 - FRANCE +33 561 17 64 21 - guillaume.pas...@c-s.fr -- -- Check the OTB FAQ at http://www.orfeo-toolbox.org/FAQ.html   You received this message because you are subscribed to the Google Groups "otb-users" group. To post to this group, send email to otb-users@googlegroups.com To unsubscribe from this group, send email to otb-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/otb-users?hl=en --- You received this message because you are subscribed to the Google Groups "otb-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to otb-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.