The SQLite file format is a standalone, file-based spatial database format that supports multiple features classes and properties in a single file, and provides spatial indexing, interoperability, and high performance for large data sets.
The SQLite file format has the following characteristics:
- SQLite files can be read on different platforms.
- One schema in a single SQLite file supports multiple feature classes.
- The SQLite file has not its own spatial indexing.
- SQLite files can store geometric and non-geometric data with minimum overhead.
- The SQLite file format supports a single writer at any time, with multiple readers.
Schema Capabilities
Data store provider supports following schema capabilities:
- Auto ID generation.
- Exclusive value range constraints.
- Null value constraints.
- Dynamic spatial contexts.
Geometry Capabilities
Data store provider supports following geometry capabilities:
- XYZ dimensionality.
- Geometry component types: Ring, LinearRing, CircularArcSegment, and LineStringSegment.
- Geometry types: Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, MultiGeometry, CurveString, CurvePolygon, MultiCurveString, and MultiCurvePolygon