SpatiaLite

About

SpatiaLite is an SQLite database engine with spatial functions added.

•  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 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 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

Homepage

http://www.gaia-gis.it/spatialite/ 

License

MPL v1.1 and GPL v3

Documentation

Documentation is available online.

Sample data is located on this disc at /home/user/data/spatialite/ and online.

Running

To explore a SpatiaLite database on the Live DVD, click on the SpatiaLite GIS, SpatiaLite GUI or QGIS link on the desktop.