Create SQLite Database (Data Management)

Summary

Creates a GeoPackage or an SQLite database that contains the ST_Geometry or SpatiaLite spatial type.

Usage

• The Output Database Name parameter value will be automatically assigned an extension based on the value of the Spatial Type parameter. If the spatial type parameter value is ST_Geometry or SpatiaLite, the output name will have an .sqlite extension. If the spatial type parameter value is GeoPackage, the output name will have a .gpkg extension.

Parameters

Dialog

Label	Explanation	Data Type
Output Database Name	The location of the SQLite database or GeoPackage to be created and the name of the file. The .sqlite extension will be automatically assigned if the Spatial Type parameter value is ST_Geometry or SpatiaLite. If the Spatial Type parameter value is GeoPackage or any of the GeoPackage versions, the .gpkg extension will be automatically assigned.	File
Spatial Type (Optional)	Specifies the spatial type that will be installed with the new SQLite database or the GeoPackage version that will be created. ST_Geometry—The Esri spatial storage type will be installed. This is the default. SpatiaLite—SpatiaLite spatial storage type will be installed. GeoPackage (equivalent to GeoPackage 1.3)—An OGC GeoPackage 1.3 dataset is created. GeoPackage 1.0—An OGC GeoPackage 1.0 dataset will be created. GeoPackage 1.1—An OGC GeoPackage 1.1 dataset will be created. GeoPackage 1.2.1—An OGC GeoPackage 1.2.1 dataset will be created. GeoPackage 1.3—An OGC GeoPackage 1.3 dataset will be created.	String

Python

arcpy.management.CreateSQLiteDatabase(out_database_name, {spatial_type})

Name	Explanation	Data Type
out_database_name	The location of the SQLite database or GeoPackage to be created and the name of the file. The .sqlite extension will be automatically assigned if the spatial_type parameter value is ST_GEOMETRY or SPATIALITE. If the spatial_type parameter value is GEOPACKAGE, the .gpkg extension will be automatically assigned.	File
spatial_type (Optional)	Specifies the spatial type that will be installed with the new SQLite database or the GeoPackage version that will be created. ST_GEOMETRY—The Esri spatial storage type will be installed. This is the default. SPATIALITE—SpatiaLite spatial storage type will be installed. GEOPACKAGE—An OGC GeoPackage 1.3 dataset is created. GEOPACKAGE_1.0—An OGC GeoPackage 1.0 dataset will be created. GEOPACKAGE_1.1—An OGC GeoPackage 1.1 dataset will be created. GEOPACKAGE_1.2—An OGC GeoPackage 1.2.1 dataset will be created. GEOPACKAGE_1.3—An OGC GeoPackage 1.3 dataset will be created.	String

Code sample

CreateSQLiteDatabase example 1 (Python window)

The following Python window script demonstrates how to use the CreateSQLiteDatabase tool in immediate mode to create a GeoPackage.

import arcpy
arcpy.CreateSQLiteDatabase_management('c:/data/example.gpkg', 'GEOPACKAGE_1.2')

CreateSQLiteDatabase example 2 (stand-alone script)

The following stand-alone script demonstrates how to use the CreateSQLiteDatabase tool to create an SQLite database that contains the ST_Geometry spatial type.

import arcpy

# Execute CreateSQLiteDatabase
arcpy.CreateSQLiteDatabase_management('C:/data/example.sqlite', 'ST_GEOMETRY')

Environments

Current Workspace