DBMS Table Not Found with SQLite and ArcGIS 10.3

Question

I'm trying to set up a spatially enabled SQLite database with ArcGIS 10.3. I've gone through the following steps:

1. Create a database using the sqlite3 utility: sqlite3 mydatabase.sqlite

2. Load the relevant extensions: SELECT load_extension('c:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite\Windows32\stgeometry_sqlite.dll','SDE_SQL_funcs_init');

3. Create the tables to add the ST_Geometry tables to the database: SELECT CreateOGCTables();

After following the above, I can browse to the database in ArcCatalog. I can copy feature classes from personal geodatabases into it using Feature Class to Feature Class. However, whenever I attempt to buffer this feature class in the SQLite database, with the same database the output, I get the error "DBMS table not found".

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.

Answer 1

So yes, there is a tool. It is in ArcGIS Pro: http://pro.arcgis.com/en/pro-app/tool-reference/data-management/create-sqlite-database.htm.

The only thing that is exposed at this point is support for SQLite Databases. Esri supports 3 flavors. ST_Geometry, SpatiaLite and GeoPackages. GeoPackage is a OGC standard format. There is support simple features in all three cases (point, multipoint, line and polygon). No other geodatabase functionality is supported. You can load data, append data and use calculate field. You cannot open an edit session. Support for GP against feature classes (like buffer) is supported.