[gdal-dev] GDAL C# bindings - using rasterlite and spatialite in the same database

[Even Rouault]

Le jeudi 27 février 2014 21:39:52, Marcel Gangwisch a écrit :
> Dear Even,
> 
> thank you for your answer! I think I know the real problem now.
> Respectively Sandro (I think a developer of rasterlite) gave me the
> correct hint.
> (https://groups.google.com/forum/?hl=de#!topic/spatialite-users/g8b3va_zteg
> <https://groups.google.com/forum/?hl=de#%21topic/spatialite-users/g8b3va_zt
> eg>)
> 
> For the generation of the spatialite database I used spatialite 4.0...
> But the precompiled gdal version (http://vbkto.dyndns.org:1280/sdk/) I
> used, uses spatialite 3.0...
> I checked that, with the spatialite-gui.

I doubt this is the reason. GDAL doesn't use librasterlite code. So when you 
stay with GDAL/OGR utilities, that should work. Of course the problem is that 
rasterlite DBs produced by GDAL may not work correctly with spatialite 
utilities.

> 
> So like Sandro wrote:
> /"in this case a "new style" DB-file will be created in the first step; //
> //but librasterlite hasn't the capability to access "new style" DB-files,
> // //so any further attempt to import some raster data will then fail. /"
> 
> The Question is now, what to do...
> Obviously I want to use the newest spatialite version.
> Therefore I thinking about building gdal against spatialite 4.
> On the other side, Sandro wrote, that rasterlite 2 will be coming soon.
> So maybe I just stay on spatialite version 3. And use later version 4.
> 
> Best regards,
> Marcel
> 
> Am 27.02.2014 20:23, schrieb Even Rouault:
> > Le mardi 25 février 2014 18:12:55, Marcel Gangwisch a écrit :
> >> Hi *,
> >> 
> >> I use the following command:
> >> 
> >> rasterliteDriver.CreateCopy("RASTERLITE:GeoDatabase.db,TABLE=raster_test
> >> ", source, 1, options, null, null);
> >> 
> >> to read every gdal raster in my rasterlite database. After reading I'm
> >> also able to read another raster of vector file into the sqlite
> >> database. Everything works fine.
> >> 
> >> My Problem is now if I do this the other way around:
> >> Then I first read a vector file into a spatialite database, and after
> >> that I want to read a raster file into the same database I get the
> >> following exception:
> >> "does not exist in the file system, and is not recognised as a supported
> >> dataset name"
> >> 
> >> Does anybody know what I'm doing wrong?
> > 
> > Marcel,
> > 
> > You should provide something more precise to reproduce. I've tested
> > successfully the equivalent operations of what I've understood of your
> > above description with the following command lines :
> > 
> > ogr2ogr -f sqlite poly.sqlite poly.shp -dsco spatialite=yes
> > gdal_translate -of rasterlite byte.tif RASTERLITE:poly.sqlite,TABLE=byte
> > 
> > and then both ogrinfo and gdalinfo show the vector and raster layers.
> > 
> > Even

-- 
Geospatial professional services
http://even.rouault.free.fr/services.html