Label | Explanation | Data Type |
Output Database Name
| The location of the SQLite database or GeoPackage that will 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.
| String |
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
arcpy.management.CreateSQLiteDatabase(out_database_name, {spatial_type})
Name | Explanation | Data Type |
out_database_name | The location of the SQLite database or GeoPackage that will 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.
| String |
Code sample
The following Python window script demonstrates how to use the CreateSQLiteDatabase function in immediate mode to create a GeoPackage.
import arcpy
arcpy.management.CreateSQLiteDatabase('c:/data/example.gpkg', 'GEOPACKAGE_1.2')
The following stand-alone script demonstrates how to use the CreateSQLiteDatabase function to create an SQLite database that contains the ST_Geometry spatial type.
import arcpy
# Run CreateSQLiteDatabase
arcpy.management.CreateSQLiteDatabase('C:/data/example.sqlite', 'ST_GEOMETRY')
Environments
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes