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

Noli Sicad nsicad at gmail.com
Tue Jan 12 11:12:57 CET 2010


No. GDAL 1.7.0 not yet released.

http://www.mail-archive.com/gdal-dev@lists.osgeo.org/msg05330.html
http://svn.osgeo.org/gdal/trunk/gdal/NEWS

Noli

On 1/12/10, Noli Sicad <nsicad at gmail.com> wrote:
> 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))"
>



More information about the R-sig-Geo mailing list