Spatial Database

SpatiaLite is an SQLite database engine with spatial functions added.

SQLite is a Database Management System (DBMS) which is simple, robust, easy to use and very lightweight. Each SQLite database is simply a file. You can freely copy it, compress it, and port it between Windows, Linux, MacOs etc.

spatialite screenshot

Core Features

The SpatiaLite extension enables SQLite to support spatial data conformant to OGC specifications.


  • User friendly GUI

  • Standard WKT and WKB formats

  • SQL spatial functions such as AsText(), GeomFromText(), Area(), PointN() …

  • OpenGis spatial analysis functions provided via GEOS, such as Overlaps(), Touches(), Union(), Buffer() …

  • Full Spatial metadata in line with OpenGis specifications

  • Numerous Geometry notations - EWKT, GML, KML, and GeoJSON

  • Importing and exporting to shapefiles

  • Coordinate reprojection via PROJ.4 and EPSG geodetic parameters dataset

  • Locale charsets via GNU libiconv

  • Spatial Index based on the SQLite’s RTree extension

  • Access shapefiles as VIRTUAL TABLEs, enabling standard SQL queries on external shapefiles, without importing or converting them

  • Access external CSV/TxtTab files or xls spreadsheets as VIRTUAL TABLEs

  • Access XML documents, stored BLOB compressed binary objects, including syntactic “well formed” and XSF schema validation constrained checks. Specific support for ISO-Metadata, SLD/SE styles and SVG graphics.XML documents can be queried using standard XPath syntax.

  • Query external WFS servers.

  • Parse external DXF files (all versions) and store layers and geometries found.

  • Generate and Export DXF files


Website: http://www.gaia-gis.it/gaia-sins/

Licence: MPL v1.1 and GPL v3

Software Version: 5.0.0

Supported Platforms: Linux, Mac, Windows

API Interfaces: C