A variable-length binary large object. Stored as SQLite BLOB.
A boolean value (0 for false, 1 for true). Stored as SQLite BOOLEAN.
An ISO 8601 date string (e.g., YYYY-MM-DD). Stored as SQLite DATE.
An ISO 8601 datetime string in UTC (e.g., YYYY-MM-DDTHH:MM:SS.SSSZ). Stored as SQLite DATETIME.
A 64-bit IEEE floating-point number. Stored as SQLite DOUBLE.
A 32-bit IEEE floating-point number. Stored as SQLite FLOAT.
A 32-bit signed integer. Stored as SQLite INT.
A 32-bit signed integer (alias for INT). Stored as SQLite INTEGER.
A 24-bit signed integer. Stored as SQLite MEDIUMINT.
A 64-bit IEEE floating-point number (alias for DOUBLE). Stored as SQLite REAL.
A 16-bit signed integer. Stored as SQLite SMALLINT.
A variable-length string encoded in UTF-8 or UTF-16. Stored as SQLite TEXT.
An 8-bit signed integer. Stored as SQLite TINYINT.
Enumeration of column data types supported by the GeoPackage specification.
These types map to the data types defined in the GeoPackage Column Data Types table. They are used when defining the schema of user data tables and are stored as SQLite column type affinity names.