SpatiaLite

SpatiaLite
Developer(s)	Alessandro Furieri
Initial release	March 21, 2008
Stable release	5.1.0 / August 4, 2023
Repository	www.gaia-gis.it/fossil/libspatialite/index ;
Written in	spatialite-gui: (C++, wxWidgets)
Operating system	Linux, MS-Windows, macOS, POSIX compliant systems
Type	Geographic information system
License	MPL GPL LGPL tri-license
Website	https://www.gaia-gis.it/fossil/libspatialite/

SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality. It is similar to PostGIS, Oracle Spatial, and SQL Server with spatial extensions, although SQLite/SpatiaLite aren't based on client-server architecture: they adopt a simpler personal architecture. i.e. the whole SQL engine is directly embedded within the application itself: a complete database simply is an ordinary file which can be freely copied and transferred from one computer/OS to a different one without any special precaution.

SpatiaLite extends SQLite's existing spatial support to cover the OGC's SFS specification.^[2] It isn't necessary to use SpatiaLite to manage spatial data in SQLite, which has its own implementation of R-tree indexes and geometry types. But SpatiaLite is needed for advanced spatial queries and to support multiple map projections. SpatiaLite is provided natively for Linux and Windows as a software library as well several utilities that incorporate the SpatiaLite library. These utilities include command line tools that extend SQLite's own with spatial macros, a graphical GUI for manipulating Spatialite databases and their data, and a simple desktop GIS tool for browsing data.

As it is a single binary file, SpatiaLite is also used as a GIS vector format to exchange geospatial data.

Software that supports SpatiaLite

Desktop:
- ESRI ArcGIS since version 10.2 as "Database Connection".^[3]
- QGIS supports SpatiaLite native since version 1.1^[4]
- AutocadMap 2013
- Global Mapper^[5]
- OpenJUMP offers a Plug-In.
- FME (also available as server)
- TileMill renderer (uses Mapnik) reads SpatiaLite as data source.^[6]
- Spatial Manager Desktop,^[7] Spatial Manager for AutoCAD,^[8] Spatial Manager for BricsCAD ^[9]
(Web)Server:
- GeoServer via SpatiaLite extension.^[10]
- GeoDjango via the GeoDjango module.^[11]
- Web2py (web framework) native ^[12]
- FeatureServer, a WFS server.^[13]
- MapServer via the GDAL library (actually OGR).^[14]
Tools and libraries:
- OGR Simple Feature Library reads and writes SpatiaLite since version 1.7^[15]
- GeoTools supports SpatiaLite using JDBC module.^[16]
- Mapnik, a renderer.
- pyspatialite, a Python library.^[17]
- OSGeo Live DVD includes spatialite along with a short tutorial.^[18]
Web Apps:
- GeoConverter - Free online data converter which reads and writes several GIS vector file formats (based on OGR), including SpatiaLite.^[19]

Standards

SpatiaLite supports several open standards from the OGC and has been listed as a reference implementation for the proposed GeoPackage standard.^[20]

References

^ "Debian -- Details of package spatialite-gui in jessie". Retrieved 2017-03-10.
^ Furieri, Alessandro. "SpatiaLite - spatial extensions for SQLite". SpatiaLite manual. Gaia-SINS.
^ "ArcGIS Help (10.2, 10.2.1, and 10.2.2)".
^ "QGIS Features". Archived from the original on 2010-01-15. Retrieved 2010-01-21.
^ "Global Mapper".
^ "TileMill". Retrieved 2014-01-06.
^ "Spatial Manager Desktop Page".
^ "Spatial Manager for AutoCAD Page".
^ "Spatial Manager for BricsCAD Page".
^ "SpatiaLite - GeoServer 2.6.X User Manual". Retrieved 2015-03-01.
^ "Installing Spatialite". Retrieved 2013-01-24.
^ "GeoDjango Installation | Django documentation | Django".
^ "FeatureServer.org". FeatureServer.org. Retrieved 2014-01-06.
^ "SpatiaLite - MapServer Documentation". Retrieved 2020-08-24.
^ "SQLite RDBMS". Open Source Geospatial Foundation. Archived from the original on 2010-06-15. Retrieved 2010-01-21.
^ "JDBC SpatiaLite - GeoTools". Archived from the original on 2010-06-08. Retrieved 2013-01-24.
^ "pyspatialite". pyspatialite. Retrieved 2014-01-06.
^ "SpatiaLite Quickstart — OSGeoLive 14.0 Documentation".
^ "GeoConverter – Geoinformation HSR".
^ "The OGC Seeks Comments on Candidate GeoPackage Standard | OGC".

External links

This computer science article is a stub. You can help Wikipedia by expanding it.

[1] "Debian -- Details of package spatialite-gui in jessie". Retrieved 2017-03-10.

[2] Furieri, Alessandro. "SpatiaLite - spatial extensions for SQLite". SpatiaLite manual. Gaia-SINS.

[3] "ArcGIS Help (10.2, 10.2.1, and 10.2.2)".

[4] "QGIS Features". Archived from the original on 2010-01-15. Retrieved 2010-01-21.

[5] "Global Mapper".

[6] "TileMill". Retrieved 2014-01-06.

[7] "Spatial Manager Desktop Page".

[8] "Spatial Manager for AutoCAD Page".

[9] "Spatial Manager for BricsCAD Page".

[10] "SpatiaLite - GeoServer 2.6.X User Manual". Retrieved 2015-03-01.

[11] "Installing Spatialite". Retrieved 2013-01-24.

[12] "GeoDjango Installation | Django documentation | Django".

[13] "FeatureServer.org". FeatureServer.org. Retrieved 2014-01-06.

[14] "SpatiaLite - MapServer Documentation". Retrieved 2020-08-24.

[15] "SQLite RDBMS". Open Source Geospatial Foundation. Archived from the original on 2010-06-15. Retrieved 2010-01-21.

[16] "JDBC SpatiaLite - GeoTools". Archived from the original on 2010-06-08. Retrieved 2013-01-24.

[17] "pyspatialite". pyspatialite. Retrieved 2014-01-06.

[18] "SpatiaLite Quickstart — OSGeoLive 14.0 Documentation".

[19] "GeoConverter – Geoinformation HSR".

[20] "The OGC Seeks Comments on Candidate GeoPackage Standard | OGC".

[1]

[2]

[3]

[4]

[5]

[6]

[7]

[8]

[9]

[10]

[11]

[12]

[13]

[14]

[15]

[16]

[17]

[18]

[19]

[20]