You can connect to an SQLite database in ArcGIS Pro to create maps and perform spatial analysis on your data. SQLite databases are relational database management systems that are often embedded in software packages. They use a simple data model and are contained in one file, which can be advantageous for the exchange of data between software packages. For example, SQLite databases can be useful on mobile devices with limited connectivity to exchange data with a server when connectivity is reestablished. To read more information on SQLite databases, you can visit the SQLite website.
Geospatial information can be shared in an SQLite database by using Esri's ST_Geometry, SpatiaLite, or the OGC GeoPackage spatial storage format. OGC GeoPackages are interoperable across many environments and may also be useful on mobile devices. See the section on creating a new GeoPackage that conforms to the OGC specification.
Connect to an SQLite database
An SQLite database can be accessed through a folder connection or by adding it to the project, similar to accessing a file geodatabase.
You can see and work with an SQLite database from a folder connection and any additional files stored in the same location. If you only want to see and work with an SQLite database and its items, and not other items stored in the same location as the SQLite database, you can add it directly to the project.
- Connect to a folder that contains the SQLite database that you want to use.
- In the Catalog pane, browse to the folder that contains the SQLite database.
- Right-click the SQLite database and click Add to Project . The database appears in the Catalog pane under the Databases category.
- Browse to the database to start using its items.
If you do not want to add the database to the project, you can use the contents of the database directly from the folder connection.
Add SQLite data to the map
Data stored in an SQLite database can be added to the map by using the Add Data button on the ribbon or by dragging it onto the map from the Catalog pane.
- Click the Add Data button on the Map tab on the ribbon.
- Browse to the SQLite database when the Add Data dialog box appears.
- Click the table or feature class that you want to add to the map.
- Click Select.
Alternatively, if you have already added the SQLite database to the project, you can right-click the feature class or table and choose Add to Current Map to add the data to the current map or Add to New Map to add the data to a new map in the project.
Work with SQLite database data in fields view
You can use fields view to view field properties of the fields in an SQLite database table or feature class, or add new fields. Dropping or renaming a field in an SQLIte database is not supported.
You can use fields view to do the following:
- View field name.
- View field data type.
- View nullability.
- View field length.
- Add new fields.
If fields view is opened from the layer in the Contents pane, you can modify the layer properties, such as visibility, field alias, or number format, of the SQLite table or feature class.
Create a new SQLite database
To create a new SQLite database or GeoPackage in ArcGIS Pro, you can use the Create SQLite Database geoprocessing tool.
- Open the Geoprocessing pane by clicking the Tools button on the Analysis tab.
- In the search box, type Create SQLite Database.
- Open the Create SQLite Database tool and fill in the parameters as desired.