Install Sqlite3 from Sqlite.org

685
2
02-23-2018 06:40 PM
Status: Already Offered
Labels (1)
KimOllivier
Regular Contributor II

The default sqlite3.dll installed  with Python does not have enable_extensions compiled into it not just disabled as the python docs suggest. Therefore you cannot add spatial extensions to access geopackage spatial featureclasses from Python in ArcTools. If the sqlite3.dll from Sqlite.org was installed in .../Python/Dlls (that is enabled) we could then load the mod_spatialite.dll extension and supplement ArcTools just as is done with the python numpy module for Grid Tools. This could be done for ArcMap (32 and 64 bit) and ArcPro (64 bit) installations.

By the way, for those of you who cannot wait, you can do this yourself now for your own installations if you have admin rights and are prepared to hack.

2 Comments
ShaunWalbridge
Status changed to: Needs Clarification

Can you confirm this remains an issue for you? The sqlite provided in the Python environment has gone through multiple changes since you posted, and would appreciate your input if this is still impeding your work.

ShaunWalbridge
Status changed to: Already Offered

I believe that you can work with libspatialite by installing it from conda-forge:

conda install conda-forge::libspatialite
sqlite3
sqlite> SELECT load_extension('mod_spatialite.dll');

I don't think we have any immediate plans to reconfigure how we deploy sqlite, so will mark this as implemented since it does work via conda, but we can think more about this if it continues to impact your work.