SpatiaLite

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
Developer(s)Alessandro Furieri
Initial releaseMarch 21, 2008 (2008-03-21)
Stable release
4.3.0a / September 7, 2015 (2015-09-07)
Repository
Written inspatialite-gui: (C++, wxWidgets)[1]
Operating systemGNU/Linux, MS-Windows, Mac OS X, POSIX compliant systems
TypeGeographic information system
LicenseMPL GPL LGPL tri-license
Websitehttps://www.gaia-gis.it/fossil/libspatialite/

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:
  • Tools and libraries:
  • Web Apps:
    • GeoConverter - Free online data converter which reads and writes several GIS vector file formats (based on OGR), including SpatiaLite.[18]

Standards

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

gollark: This has been explained already.
gollark: I also do this, but:- how often do the search queries contain things you dislike- how hard is it to scroll past it or whatever, given that average queries probably won't bring up much of that
gollark: I do not think search is a significant issue, and the logreading thing can be fixed.
gollark: I mean, you could shunt it to an archive channel via webhook things after however long, but that would have its own issues.
gollark: The precise time is tunable, after some amount of time it would probably cease to be discussed. And why should they *not* exist? The logreading issue is fixable as I said, search... maybe less so, but I'm not sure how many search queries actually turn up that stuff *now* and how big an issue it would be.

References
  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. http://resources.arcgis.com/en/help/main/10.2/index.html#/What_s_new_in_ArcGIS_10_2/016w0000005s000000/
  4. "QGIS Features". Archived from the original on 2010-01-15. Retrieved 2010-01-21.
  5. http://www.bluemarblegeo.com/products/global-mapper-features.php
  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. https://docs.djangoproject.com/en/dev/ref/contrib/gis/install/#requirements
  13. "FeatureServer.org". FeatureServer.org. Retrieved 2014-01-06.
  14. "SQLite RDBMS". Open Source Geospatial Foundation. Archived from the original on 2010-06-15. Retrieved 2010-01-21.
  15. "JDBC SpatiaLite - GeoTools". Archived from the original on 2010-06-08. Retrieved 2013-01-24.
  16. "pyspatialite". pyspatialite. Retrieved 2014-01-06.
  17. http://live.osgeo.org/en/quickstart/spatialite_quickstart.html
  18. http://giswiki.hsr.ch/GeoConverter
  19. http://www.opengeospatial.org/standards/requests/95


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.