Re: [R-sig-Geo] Write sf object to spatialite database

On 10/11/2016 17:15, Edzer Pebesma wrote: > Thanks for trying. > > I guess the sqlite session needs to be loaded with the spatialite > libraries before we can use the spatial functions, like > AddGeometryColumn, where it breaks on my machine: > I thought I did, but I'm no expert in databases,

Re: [R-sig-Geo] Write sf object to spatialite database

Thanks for trying. I guess the sqlite session needs to be loaded with the spatialite libraries before we can use the spatial functions, like AddGeometryColumn, where it breaks on my machine: > st_write_db(con, sf, "meuse_tbl", dropTable = FALSE) Error in sqliteSendQuery(con, statement,

[R-sig-Geo] Write sf object to spatialite database

Hi, Is it possible to write sf objects to spatialite databases? I tried to adapt the postgis example of the st_write_db function but I get the following error: Error in sqliteSendQuery(con, statement, bind.data) : error in statement: no such function: AddGeometryColumn Cheers, Loïc library(sf)