ArcMap

Create SQLite Database

Summary

Creates a ST_Geometry, SpatiaLite, or GeoPackage database.

Usage

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

Syntax

CreateSQLiteDatabase_management (out_database_name, {spatial_type})
ParameterExplanationData Type
out_database_name

Location of the SQLite database to be created and the name of the SQLite database file. An extension of .sqlite will be automatically assigned if the spatial_type is ST_GEOMETRY or SPATIALITE. If the spatial_type is GEOPACKAGE, a .gpkg extension is automatically assigned.

File
spatial_type
(Optional)

The spatial type to install with the new SQLite database.

  • ST_GEOMETRY —Esri's spatial storage type. This is the default.
  • SPATIALITE —SpatiaLite spatial storage type.
  • GEOPACKAGE — OGC GeoPackage dataset.
String

Code sample

Create SQLite Database example 1 (Python window)

import arcpy
arcpy.CreateSQLiteDatabase_management('c:/data/example.gpkg', 'GEOPACKAGE')
Create SQLite Database example 2 (stand-alone script)

import arcpy

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

Environments

Licensing information

  • ArcGIS Desktop Basic: Yes
  • ArcGIS Desktop Standard: Yes
  • ArcGIS Desktop Advanced: Yes

Related topics