[gdal-dev] What can OGR do with SpatiaLite files at this moment and in the near future?

[Even Rouault]

Selon Dan Putler <dan.putler at sauder.ubc.ca>:

> Hi all,
>
> On the R-Sig-Geo list there is a thread going on related to using
> SpatiaLite as a file based store of vector geodata. The first issue that
> comes up is what can OGR do with SpatiaLite files both now, and in the
> near future? My understanding (which may well be wrong) is that there is
> a SQLite read-only driver in GDAL/OGR 1.6.X versions.

Yes

> My first specific
> question, assuming my understanding is correct, is whether OGR can read
> the geometry field in a SpatiaLite file?

Yes, since GDAL 1.6.0

> My second question is whether
> there are any current plans to extend the SQLite driver to enable it to
> write SpatiaLite files?

It's already working in gdal SVN trunk (for GDAL/OGR 1.7.0)

> My final question is more on the FWTools front,
> and that is whether the current Windows version of FWTools has a build
> of the GDAL/OGR library that has both the SQLite

FWTools has SQLite support but uses a too old version of sqlite3 library that
cannot read the format of databases produced by spatialite utilities. An
upgraded sqlite3 could read&write them (you can also do it yourself by just
replacing the sqlite3.dll that comes with FWTools by the latest one on the
sqlite3 web site). And linking against libspatialite would also bring spatial
extensions functions. It's simply a matter of build dependencies. I'm not sure
what Frank's plans are about that.

> and PostGIS drivers
> included?

Yes, PostgreSQL/PostGIS support is in FWTools

>
> Dan
>
> --
> Dan Putler
> Sauder School of Business
> University of British Columbia
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>