mercredi 30 septembre 2015

creating a spatialite database programmatically

I am trying to create a new spatialite database in a c# program. I couldn't find a way to create an empty spatialite database having all spatial view and functions.

I tried creating an sqlite database, then use it as a spatialite database by loading the extension module (libspatialite4.dll). With this way i can create spatial columns and insert spatial data successfully but i cannot create any Spatial Indexes (No error but simply no index is created when i run the CreateSpatialIndex command. Also, there are no spatialite related objects in database, probably because i created it as an sqlite database.

Anyone knows how to create an empty spatialite database inside a c# program or how to install spatialite related db objects to an existing sqlite database?

Aucun commentaire:

Enregistrer un commentaire