Summary
Creates an ST_Geometry, a SpatiaLite, or a GeoPackage database.
Usage
The output Output Database Name will be automatically assigned an extension based on 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(out_database_name, {spatial_type})
Parameter | Explanation | Data 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.
| String |
Code sample
CreateSQLiteDatabase example 1 (Python window)
The following Python window script demonstrates how to use the CreateSQLiteDatabase tool in immediate mode.
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.
import arcpy
# Execute CreateSQLiteDatabase
arcpy.CreateSQLiteDatabase_management('C:/data/example.sqlite', 'ST_GEOMETRY')
Environments
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes