Contents
Can you connect ArcGIS to a SQLite database?
SQLite data in ArcGIS You can connect from ArcGIS for Desktop to an SQLite database to create maps and perform spatial analysis. ArcGIS supports spatial data in SQLite databases that contain one of the following storage types: Esri ST_Geometry—The database file must have the extension.sqlite to be used with ArcGIS.
What kind of data is stored in SQLite?
For more information on SQLite databases, visit the SQLite website. You can store spatial information in an SQLite database using the Esri ST_Geometry spatial data type, SpatiaLite, or use the OGC GeoPackage spatial storage format. OGC GeoPackage files are interoperable across many environments and are useful on mobile devices.
What kind of data can be stored in ArcGIS?
ArcGIS supports spatial data in SQLite databases that contain one of the following storage types: Esri ST_Geometry—The database file must have the extension .sqlite to be used with ArcGIS.
Is it OK to read geopackages in SQLite?
SQLite and GeoPackages can be read by multiple users, but you should not make any updates to the database while someone else is editing. For example, do not append data into an existing table or create a table in the database while someone else is appending data into an existing table or creating a table in the database.
How to create a spatially enable SQLite database?
See Spatially enable an SQLite database for information on adding a spatial storage type to an existing database. To create an SQLite database that uses either ST_Geometry or SpatiaLite storage, or to create a GeoPackage, use the CreateSQLiteDatabase ArcPy function.
What kind of data can I use with ArcGIS?
ArcGIS supports spatial data in SQLite databases that contain one of the following storage types: Esri ST_Geometry—The database file must have the extension .sqlite to be used with ArcGIS. SpatiaLite—The database file must have the extension .sqlite to be used with ArcGIS.
How do you control access to a SQLite database?
You control access to an SQLite database or GeoPackage by controlling permissions on the folder where it is stored. Unlike other databases, you do not create users who are authenticated by the database, and you do not grant privileges on specific datasets to other users.
Can you use more than one storage type in SQLite?
You can use only one spatial storage type per SQLite database. See Spatially enable an SQLite database for information on adding a spatial storage type to an existing database.