I'm trying to set up a spatially enabled SQLite database with ArcGIS 10.3. I've gone through the following steps:
If a run the same buffer operation from a personal geodatabase to the SQLite database, it succeeds. If I run the same operation from SQLite to a personal geodatabase, it fails.
The database name and feature class names are all lowercase, per the advice of this SE post.
It seems that something is wrong with the data in SQLite, but I have no idea what.
أكثر...
- Create a database using the sqlite3 utility: sqlite3 mydatabase.sqlite
- Load the relevant extensions: SELECT load_extension('c:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite\Windows32\stgeometry_sqlite.dll','SDE_SQL_funcs_init');
- Create the tables to add the ST_Geometry tables to the database: SELECT CreateOGCTables();
If a run the same buffer operation from a personal geodatabase to the SQLite database, it succeeds. If I run the same operation from SQLite to a personal geodatabase, it fails.
The database name and feature class names are all lowercase, per the advice of this SE post.
It seems that something is wrong with the data in SQLite, but I have no idea what.
أكثر...