SQLite Non-Spatial Quick Facts
|
Format Type Identifier |
SQLITE3 |
|
Reader/Writer |
Both |
|
Licensing Level |
Base |
|
Dependencies |
None |
|
Dataset Type |
File |
|
Feature Type |
Table name |
|
Typical File Extensions |
.sqlite, .sqlite3, .db, .sl3 Note that .db and .sl3 are equivalent; however, the .db filename extension is more commonly used. These filename extensions are not exclusive to the SQLite 3 format. |
|
Automated Translation Support |
Yes |
|
User-Defined Attributes |
Yes |
|
Coordinate System Support |
No |
|
Generic Color Support |
No |
|
Spatial Index |
Never |
|
Schema Required |
Yes |
|
Transaction Support |
Yes |
|
Encoding Support |
Yes |
|
Geometry Type |
db_none |
SQLite Non-Spatial Geometry Support
|
Geometry |
Supported? |
|
aggregate |
no |
|
circles |
no |
|
circular arc |
no |
|
donut polygon |
no |
|
elliptical arc |
no |
|
ellipses |
no |
|
line |
no |
|
none |
yes |
|
point |
no |
|
polygon |
no |
|
raster |
no |
|
solid |
no |
|
surface |
no |
|
text |
no |
|
z values |
n/a |