Thanks!  I keep forgetting about those builds.

But I do think the SQLite driver should report if it supports SpatiaLite. For example, in ogrsqlitedriver.cpp have something like:


const char *OGRSQLiteDriver::GetName()

{
#ifdef HAVE_SPATIALITE
    return "SQLite+SpatiaLite functions";
#else
    return "SQLite";
#endif
}

Although looking at the driver code, the support really isn't as simple as that. As the OGR driver doc mentions the OGR implementation of SQLite will read and write SpatiaLite databases, it just will not do spatial indexes or SpatiaLite spatial functions (as these are in the code library, not in the database as Stored Procedures as with other spatial database types like PostGIS). But it WILL read and write SpatiaLite's flavour of geometry, and create SpatiaLite-compatible databases (it even creates the geometry_columns and spatial_ref_sys tables!). I think these points need to be stated explicitly in the driver doc.

Best Regards,
Brent Fraser

Tamas Szekeres wrote:
Check out the recent builds from here:
http://vbkto.dyndns.org/sdk/

Those have been compiled with spatialite support.

Best regards,

Tamas



2010/3/11 Brent Fraser <[email protected] <mailto:[email protected]>>

    Tamas,

     I was afraid of that.  I'm having trouble getting MS4W 3 Beta 10's OGR
    to read my SpatiaLite database.  I suspect it's because SpatiaLite was
    not compiled in (I'm a SQLite newbie so I'm not sure); but there's no
    way to tell.

    Thanks!
    Brent

    >  Brent,
    >
    >  It should be "SQLite" in both cases.
    >
    >  Best regards,
    >
    >  Tamas
    >
    >
    >  2010/3/11 Brent Fraser <[email protected]
    <mailto:[email protected]>>
    >
    > > What would "ogrinfo --formats" show if GDAL was compiled with
    > > HAVE_SPATIALITE set?
    > > What would it show if only SQLite (and not SpatiaLite) was
    compiled in?
    > >
    > > Thanks!
    > > Brent Fraser
    > >
    > >
    > > _______________________________________________
    > > gdal-dev mailing list
    > > [email protected] <mailto:[email protected]>
    > > http://lists.osgeo.org/mailman/listinfo/gdal-dev
    > >
    >





_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to