Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Even Rouault
Le mercredi 30 avril 2014 17:37:21, Mario Jurcevic a écrit : > On 04/30/2014 05:32 PM, Even Rouault wrote: > > Le mercredi 30 avril 2014 17:19:04, Mario Jurcevic a écrit : > >> On 04/30/2014 05:11 PM, Even Rouault wrote: > >>> Not that much a big difference... Perhaps you should try to isolate > >>

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Jukka Rahkonen
Mario Jurcevic geosar.ch> writes: > > > On 04/30/2014 05:11 PM, Even Rouault wrote: > > Not that much a big difference... Perhaps you should try to isolate which layer > > conversion if particuarly slower with ogr2ogr > > I get big difference: > time ogr2ogr -sql 'select > "soft_gis_serial"

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Mario Jurcevic
On 04/30/2014 05:32 PM, Even Rouault wrote: Le mercredi 30 avril 2014 17:19:04, Mario Jurcevic a écrit : On 04/30/2014 05:11 PM, Even Rouault wrote: Not that much a big difference... Perhaps you should try to isolate which layer conversion if particuarly slower with ogr2ogr I get big differ

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Even Rouault
Le mercredi 30 avril 2014 17:19:04, Mario Jurcevic a écrit : > On 04/30/2014 05:11 PM, Even Rouault wrote: > > Not that much a big difference... Perhaps you should try to isolate which > > layer conversion if particuarly slower with ogr2ogr > > I get big difference: > time ogr2ogr -sql 'select >

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Mario Jurcevic
On 04/30/2014 05:11 PM, Even Rouault wrote: Not that much a big difference... Perhaps you should try to isolate which layer conversion if particuarly slower with ogr2ogr I get big difference: time ogr2ogr -sql 'select "soft_gis_serial","Origine","Qualita","Genere",st_curvetoline("Geometria"

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Even Rouault
Le mercredi 30 avril 2014 16:44:54, Mario Jurcevic a écrit : > On 04/30/2014 04:40 PM, Even Rouault wrote: > > Le mercredi 30 avril 2014 15:54:45, Mario Jurcevic a écrit : > >> On 04/30/2014 03:27 PM, Even Rouault wrote: > >>> Hum, I managed to import the dump but I'm having troubles make the > >>>

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Jukka Rahkonen
Mario Jurcevic geosar.ch> writes: > Postgresql 9.1.3 > Postgis 2.0.4 > gdal 1.9.2 > > Tables have MULTIPOLYGONS and MULTILINESTRING. > The export is done from Java by invoking for each table the ogr2ogr > command. Same for "pgsqltoshape". Could you try also by running the same ogr2ogr command

Re: [gdal-dev] postgis to esri shape slow

2014-04-30 Thread Mario Jurcevic
On 04/28/2014 08:02 PM, Even Rouault wrote: Le lundi 28 avril 2014 16:47:49, Mario Jurcevic a écrit : Hi, I try to export postgis tables ( 200 ) to shape; It seems ogr2ogr is much more slow than "pgsql2shp" from postgis. ogr2ogr: about 15 minutes pgsql2shp: about 2 minutes Any known reason f

Re: [gdal-dev] postgis to esri shape slow

2014-04-28 Thread Even Rouault
Le lundi 28 avril 2014 16:47:49, Mario Jurcevic a écrit : > Hi, > I try to export postgis tables ( 200 ) to shape; It seems ogr2ogr is > much more slow than "pgsql2shp" from postgis. > > ogr2ogr: about 15 minutes > pgsql2shp: about 2 minutes > > Any known reason for that? Interesting. I don't ha

[gdal-dev] postgis to esri shape slow

2014-04-28 Thread Mario Jurcevic
Hi, I try to export postgis tables ( 200 ) to shape; It seems ogr2ogr is much more slow than "pgsql2shp" from postgis. ogr2ogr: about 15 minutes pgsql2shp: about 2 minutes Any known reason for that? Thanks for any suggestion. -- Mario Jurcevic ___