Bug#746566: gdal-bin: ogr2ogr fails to create SQLite db using SPATIALITE=YES

2014-05-02 Thread Sebastiaan Couwenberg
Control: tags -1 confirmed

Hi Andy,

Thanks for reporting this issue.

I can reproduce the problem with the lakes.gml sample file shipped with
QGIS. It takes almost 8 minutes to create the spatialite database.

Creating an empty spatialite database is near instantaneous with the
spatialite commandline tool. It takes ogr2ogr significantly longer to
get its spatialite database to the same size.

ogr2ogr is taking a long time to populate the spatial_ref_sys table.
Possibly because GDAL no longer contains EPSG data (#745702) so it needs
to fall back to using PROJ.4 for each projection.

I'm currently working on updating the GDAL packaging for the recent
1.11.0 release, and intent to address the EPSG issue with that.
Hopefully that also solves this spatialite issue.

Kind Regards,

Bas


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



Bug#746566: gdal-bin: ogr2ogr fails to create SQLite db using SPATIALITE=YES

2014-05-01 Thread Andy Wood
Package: gdal-bin
Version: 1.10.1+dfsg-5+b1
Severity: normal

Dear Maintainer,

The following command works and creates rat_boxes.sqlite:
   ogr2ogr -f SQLite rat_boxes.sqlite rat_boxes.xml

 however the following command will continue indefinitely, aparently doing 
nothing:
   ogr2ogr -f SQLite rat_boxes.sqlite rat_boxes.xml -dsco SPATIALITE=YES

when interrupted both a .sqlite and a .sqlite-journal file is present.

This is a recent problem as this worked a month or so back.

libspatialite5 (4.1.1-9), spatialite-bin (4.1.1-4) libspatialite3 (3.1.0-rc2-2) 
are installed

Although this is being reported from x86_64, the same problem exists on i386.

-- System Information:
Debian Release: jessie/sid
  APT prefers testing
  APT policy: (900, 'testing'), (300, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.13-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages gdal-bin depends on:
ii  libc6   2.18-4
ii  libgcc1 1:4.8.2-16
ii  libgdal1h   1.10.1+dfsg-5+b1
ii  libstdc++6  4.8.2-16

gdal-bin recommends no packages.

Versions of packages gdal-bin suggests:
ii  python-gdal  1.10.1+dfsg-5+b1

-- no debconf information


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org