[gdal-dev] Re: Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Jukka Rahkonen
Even Rouault mines-paris.org> writes: > > Le mercredi 04 avril 2012 19:16:34, Rahkonen Jukka a écrit : > > Even Rouault wrote: > > >Selon Jukka Rahkonen mmmtike.fi>: > > >> Hi, > > >> > > >> I had to write a million polygon shapefile into Spatialite with > > >> -skipfailures and I noticed that

RE: [gdal-dev] adf to ascii X,Y,Z [SEC=UNCLASSIFIED]

2012-04-04 Thread Pinner, Luke
Something like: gdal_translate –of xyz ingrid outfile.txt I don’t think MapInfo grids (*.mig) are supported, I couldn’t see that format listed in http://www.gdal.org/formats_list.html Luke From: gdal-dev-boun...@lists.osgeo.org [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of nicholas.g

[gdal-dev] adf to ascii X,Y,Z

2012-04-04 Thread nicholas . g . lawrence
Hello, I have the latest gdal for windows. What would be the DOS command for conferting a .adf file into an ascii x,y,z file? or alternatively, a Mapinfo Grid file? Kind regards, Nicholas Lawrence Geographic Information Systems Coordinator | Geospatial, Road Assets & Design Eng

RE: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Martin Chapman
Oh sweet. I never knew that option existed in OGR! Thanks for the info Even. Marty -Original Message- From: Even Rouault [mailto:even.roua...@mines-paris.org] Sent: Wednesday, April 04, 2012 1:12 PM To: gdal-dev@lists.osgeo.org Cc: Martin Chapman; 'Jukka Rahkonen' Subject: Re: [gdal-dev

Re: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Even Rouault
Le mercredi 04 avril 2012 21:01:29, Martin Chapman a écrit : > Try to execute this query before you start inserting: > > "PRAGMA synchronous = 0;" > > It turns synchronous writes off for sqlite and give a big performance > increase. I don't know if that will work for spatialite but it might. > Y

RE: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Martin Chapman
Try to execute this query before you start inserting: "PRAGMA synchronous = 0;" It turns synchronous writes off for sqlite and give a big performance increase. I don't know if that will work for spatialite but it might. You need to read about the ramifications on the sqlite web site first though

Re: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Even Rouault
Le mercredi 04 avril 2012 19:16:34, Rahkonen Jukka a écrit : > Even Rouault wrote: > >Selon Jukka Rahkonen : > >> Hi, > >> > >> I had to write a million polygon shapefile into Spatialite with > >> -skipfailures and I noticed that it was very many times slower that > >> without -skipfailures. Is >

Re: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Rahkonen Jukka
Even Rouault wrote: >Selon Jukka Rahkonen : >> Hi, >> >> I had to write a million polygon shapefile into Spatialite with -skipfailures >> and I noticed that it was very many times slower that without -skipfailures. >> Is >> there some logical reason for that or could it be due to a bug or someth

Re: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Even Rouault
Selon Jukka Rahkonen : > Hi, > > I had to write a million polygon shapefile into Spatialite with -skipfailures > and I noticed that it was very many times slower that without -skipfailures. > Is > there some logical reason for that or could it be due to a bug or something? > Only thing that comes

[gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Jukka Rahkonen
Hi, I had to write a million polygon shapefile into Spatialite with -skipfailures and I noticed that it was very many times slower that without -skipfailures. Is there some logical reason for that or could it be due to a bug or something? Only thing that comes into my mind is that if the -gt param

Re: [gdal-dev] VRT and overviews

2012-04-04 Thread Oyvind Idland
Ok, thanks, good to know. -- oyvind On Wed, Apr 4, 2012 at 3:24 PM, Dmitry Baryshnikov wrote: > 04.04.2012 16:57, Oyvind Idland написал: > > How do I get overviews to work with VRT datasets ? > > What I do is > - creating a .vrt with additional alpha band + nodata using gdalbuildvrt > (wrappi

Re: [gdal-dev] VRT and overviews

2012-04-04 Thread Dmitry Baryshnikov
04.04.2012 16:57, Oyvind Idland ???: How do I get overviews to work with VRT datasets ? What I do is - creating a .vrt with additional alpha band + nodata using gdalbuildvrt (wrapping an existing TIFF) - creating overviews using gdaladdo. I then get an external .ovr file. - creating a n

[gdal-dev] VRT and overviews

2012-04-04 Thread Oyvind Idland
How do I get overviews to work with VRT datasets ? What I do is - creating a .vrt with additional alpha band + nodata using gdalbuildvrt (wrapping an existing TIFF) - creating overviews using gdaladdo. I then get an external .ovr file. - creating a new TIFF from the VRT First, it seems that th