SpatiaLite explained

SpatiaLite
Developer:Alessandro Furieri
Logo Size:200px
Latest Release Version:5.1.0
Programming Language:spatialite-gui: (C++, wxWidgets)[1]
Operating System:Linux, MS-Windows, macOS, POSIX compliant systems
Genre: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

Standards

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

Notes and References

  1. Web site: Debian -- Details of package spatialite-gui in jessie . 2017-03-10.
  2. Web site: SpatiaLite - spatial extensions for SQLite. SpatiaLite manual. Gaia-SINS. Furieri. Alessandro.
  3. Web site: ArcGIS Help (10.2, 10.2.1, and 10.2.2).
  4. Web site: QGIS Features. 2010-01-21. dead. https://web.archive.org/web/20100115235652/http://www.qgis.org/en/about-qgis/features.html. 2010-01-15.
  5. Web site: Global Mapper.
  6. Web site: TileMill . 2014-01-06.
  7. Web site: Spatial Manager Desktop Page.
  8. Web site: Spatial Manager for AutoCAD Page.
  9. Web site: Spatial Manager for BricsCAD Page.
  10. Web site: SpatiaLite - GeoServer 2.6.X User Manual. 2015-03-01.
  11. Web site: Installing Spatialite. 2013-01-24.
  12. Web site: GeoDjango Installation | Django documentation | Django.
  13. Web site: FeatureServer.org. FeatureServer.org. 2014-01-06.
  14. Web site: SpatiaLite - MapServer Documentation. 2020-08-24.
  15. Web site: SQLite RDBMS. Open Source Geospatial Foundation. 2010-01-21. dead. https://web.archive.org/web/20100615135832/http://gdal.org/ogr/drv_sqlite.html. 2010-06-15.
  16. Web site: JDBC SpatiaLite - GeoTools. https://web.archive.org/web/20100608060534/http://docs.codehaus.org/display/GEOTOOLS/JDBC+SpatiaLite. dead. 2010-06-08. 2013-01-24.
  17. Web site: pyspatialite. pyspatialite. 2014-01-06.
  18. Web site: SpatiaLite Quickstart — OSGeoLive 14.0 Documentation.
  19. Web site: GeoConverter – Geoinformation HSR.
  20. Web site: The OGC Seeks Comments on Candidate GeoPackage Standard | OGC.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "SpatiaLite".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.