WARNING: this web page is nowadays obsolete and completely outdated.

The current version of SpatiaLite is available from here

If you are searching for updated Windows executables you'll find all them from here
Please look at the bottom of the page into the MS Windows binaries section.

SpatiaLite 2.3.1          a complete Spatial DBMS in a nutshell

previous version [2.3.0] is here
new updated version [3.0.0-BETA] is here new

logo the 2.3.1 is the current stable release supporting:
  • an enhanced GUI tool v1.2.1
  • PROJ.4 latest version (4.6.1)
  • GEOS latest version (3.1.1)
  • SQLite's latest version (3.6.16)
  • extensive debugging
  • new introducing a companion RasterLite library to handle huge Raster Data Sources within the DBMS new
  • new introducing spatialite-gis, a minimalistic GIS tool based on SpatiaLite new
Keep in touch ... join the community, visit the SpatiaLite User group
sources
precompiled binaries
documentation & tutorials
sample DBs & other resources

Quick intro

  • SQLite is a popular DBMS, simple, robust, easy to use and really lightweight
  • each SQLite database is simply a file; you can freely copy it, compress it, send it on a LAN or WEB with no complication at all
    They are also portables; the same database file will work on Windows, Linux, MacOs etc
  • the SpatiaLite extension enables SQLite to support spatial data too [aka GEOMETRY], in a way conformant to OpenGis specifications
    • supports standard WKT and WKB formats
    • implements SQL spatial functions such as AsText(), GeomFromText(), Area(), PointN() and alike
    • the complete set of OpenGis functions is supported via GEOS, this comprehending sophisticated spatial analysis functions such as Overlaps(), Touches(), Union(), Buffer() ..
    • supports full Spatial metadata along the OpenGis specifications
    • supports importing and exporting from / to shapefiles
    • supports coordinate reprojection via PROJ.4 and EPSG geodetic parameters dataset
    • supports locale charsets via GNU libiconv
    • implements a true Spatial Index based on the SQLite's RTree extension
  • the VirtualShape extension enables SQLite to access shapefiles as VIRTUAL TABLEs
    • you can then perform standard SQL queries on external shapefiles, with no need for importing or converting them
  • the VirtualText extension enables SQLite to access CSV/TxtTab files as VIRTUAL TABLEs
    • you can then perform standard SQL queries on external CSV/TxtTab files, with no need for importing or converting them
  • the GUI tool supports all this, in an user friendly way

SpatiaLite is developed and maintained by Alessandro Furieri a.furieri@lqt.it