SQLite3 Quick Facts

About Quick Facts Tables

Format Type Identifier

SQLite3

Reader/Writer

Both

Licensing Level

Base

Dependencies

None

Dataset Type

File

Feature Type

Feature Class

Typical File Extensions

.db or .sl3

Automated Translation Support

Yes

User-Defined Attributes

Yes

Coordinate System Support

Yes

Generic Color Support

No

Spatial Index

Always

Schema Required

Yes

Transaction Support

No

Geometry Type Attribute

fdo_type

Encoding Support No

SQLite3 Geometry Support

Geometry

Supported?

aggregate

no

circles

yes

circular arc

yes

donut polygon

yes

elliptical arc

no

ellipses

no

line

yes

none

yes

point

yes

polygon

yes

raster

no

solid

no

surface

no

text

no

z values

yes