[gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-03 Thread Casper Børgesen
Hi devs I am trying to merge a bunch of SHAPE files into a few SpatiaLite files. To make it more simple I have two kinds of data sets A and B and each data set has two SHAPE files. So my result should end up being a SpatiaLite file for each data set. I am using the following commands to create

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-03 Thread jratike80
Casper Børgesen-2 wrote > Hi devs > > I am trying to merge a bunch of SHAPE files into a few SpatiaLite files. > To make it more simple I have two kinds of data sets A and B and each data > set has two SHAPE files. So my result should end up being a SpatiaLite > file for each data set. > > I am u

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-04 Thread Casper Børgesen
7 20:52 To: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite Casper Børgesen-2 wrote > Hi devs > > I am trying to merge a bunch of SHAPE files into a few SpatiaLite files. > To make it more simple I have two kinds of data sets A and B and each data

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-05 Thread Even Rouault
On mercredi 4 octobre 2017 08:58:25 CEST Casper Børgesen wrote: > Hi Jukka > > I tried only to discover that the error is probably about an invalid (?) > layer name (-nln). ogr2ogr doesn't complain if I give it a layer name with > a dash in the middle, like 'some-thing'. When appending data to the

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-05 Thread Casper Børgesen
gards, Casper From: Even Rouault [mailto:even.roua...@spatialys.com] Sent: 5. oktober 2017 12:34 To: gdal-dev@lists.osgeo.org Cc: Casper Børgesen Subject: Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite On mercredi 4 octobre 2017 08:58:25 CEST Casper Børgesen wrote: > Hi Jukka >

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-05 Thread Even Rouault
the creation stage. So your append -nln "a-b" will match a non existing layer Add -lco LAUNDER=NO to the creation stage and that will solve it. > > Regards, Casper > > From: Even Rouault [mailto:even.roua...@spatialys.com] > Sent: 5. oktober 2017 12:34 > To: gdal-de

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-05 Thread jratike80
Hi, I have a bit similar problem with making queries with SQLite SQL dialect if shapefile name has numbers. For example this succeeds fine with GDAL 2.3dev on Windows: ogrinfo -sql "select * from test2000" test2000.shp but this does not ogrinfo -dialect sqlite -sql "select * from test2000" tes

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-05 Thread Even Rouault
On jeudi 5 octobre 2017 05:20:02 CEST jratike80 wrote: > Hi, > > I have a bit similar problem with making queries with SQLite SQL dialect if > shapefile name has numbers. > For example this succeeds fine with GDAL 2.3dev on Windows: > > ogrinfo -sql "select * from test2000" test2000.shp > > but

Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite

2017-10-08 Thread Casper Børgesen
n the road? Regards, Casper From: Even Rouault [mailto:even.roua...@spatialys.com] Sent: 5. oktober 2017 13:15 To: Casper Børgesen Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] Problem with merging SHAPEs into SpatiaLite On jeudi 5 octobre 2017 10:52:42 CEST Casper Børgesen wrote: >