project logo

SpatiaLite

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.

screenshot

Core Features

The SpatiaLite extension enables SQLite to support spatial data conformant to OGC 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 alternative Geometry notations - EWKT, GML, KML, and GeoJSON
  • Supports importing and exporting 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
  • The VirtualXL extension enables SQLite to access xls spreadsheet tables as VIRTUAL TABLEs
  • You can then perform standard SQL queries on external CSV/TxtTab files or Excel tables, with no need for importing or converting them
  • The GUI tool supports all this, in an user friendly way

Details

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

Licence: MPL v1.1 and GPL v3

Software Version: spatialite 3.1.0 / librasterlite 1.1 / spatialite-gui 1.5.0 / spatialite-gis 1.0.0

Supported Platforms: Linux, Mac, Windows

API Interfaces: C

Copyright & Disclaimer