[R-sig-Geo] Is latest Rgdal support spatialite

[Noli Sicad]

Hi,

Anybody know, if the latest update (3 January 2010) of Rgdal supports
spatialite - GDAL 1.7.0?


Thanks. Noli

~~~~~~~~~~~~~~~~~~~~~~~~`
http://www.gdal.org/ogr/drv_sqlite.html

from the site.
~~~~~~~~~~~~~~~~~~
Using the SpatiaLite library (Spatial extension for SQLite)
(Starting with GDAL 1.7.0)

The SQLite driver can read and write SpatiaLite databases without
needing to load the SpatiaLite library. But if you configure GDAL/OGR
with explicit linking to SpatiaLite library (version >= 2.3), you can
take advantage of all the extension functions provided by this
library, such as spatial indexes, spatial functions, etc...

A few examples :

# Duplicate the sample database provided with SpatiaLite (does not
need explicit linking with SpatiaLite)
ogr2ogr -f SQLite testspatialite.sqlite test-2.3.sqlite  -dsco SPATIALITE=YES

# Add a spatial index on the geometry column of the Towns table (needs
explicit linking with SpatiaLite)
ogrinfo testspatialite.sqlite -sql "SELECT CreateSpatialIndex('Towns',
'geometry')"

# Make a request with a spatial filter (needs explicit linking with SpatiaLite)
ogrinfo testspatialite.sqlite \
     -sql "SELECT Name, asText(geometry) FROM Towns WHERE
MBRWithin(geometry, BuildMBR(754000, 4692000, 770000, 4924000))"