SpatiaLite

Last updated
SpatiaLite
Developer(s) Alessandro Furieri
Initial releaseMarch 21, 2008 (2008-03-21)
Stable release
5.1.0 / August 4, 2023 (2023-08-04)
Repository
Written inspatialite-gui: (C++, wxWidgets) [1]
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.

Contents

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]

Related Research Articles

<span class="mw-page-title-main">PostGIS</span> Geospatial extension for the PostgreSQL Database

PostGIS is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC).

A GIS file format is a standard for encoding geographical information into a computer file, as a specialized type of file format for use in geographic information systems (GIS) and other geospatial applications. Since the 1970s, dozens of formats have been created based on various data models for various purposes. They have been created by government mapping agencies, GIS software vendors, standards bodies such as the Open Geospatial Consortium, informal user communities, and even individual developers.

In computing, GeoServer is an open-source server written in Java that allows users to share, process and edit geospatial data. Designed for interoperability, it publishes data from any major spatial data source using open standards. GeoServer has evolved to become an easy method of connecting existing information to virtual globes such as Google Earth and NASA World Wind as well as to web-based maps such as OpenLayers, Leaflet, Google Maps and Bing Maps. GeoServer functions as the reference implementation of the Open Geospatial Consortium Web Feature Service standard, and also implements the Web Map Service, Web Coverage Service and Web Processing Service specifications.

A GIS software program is a computer program to support the use of a geographic information system, providing the ability to create, store, manage, query, analyze, and visualize geographic data, that is, data representing phenomena for which location is important. The GIS software industry encompasses a broad range of commercial and open-source products that provide some or all of these capabilities within various information technology architectures.

<span class="mw-page-title-main">Sol Katz</span> American software developer

Sol Katz was an American software developer who pioneered geospatial computer software and left behind a large body of work in the form of computer applications and format specifications while at the U.S. Bureau of Land Management. This early archive provided both source code and applications freely available to the community, including the Windows application PC-MOSS, where MOSS is the earliest known Open Source Geographic Information System. Katz was also a frequent contributor to many geospatial list servers.

A Web Map Service (WMS) is a standard protocol developed by the Open Geospatial Consortium in 1999 for serving georeferenced map images over the Internet. These images are typically produced by a map server from data provided by a GIS database.

<span class="mw-page-title-main">Shapefile</span> Geospatial vector data format

The shapefile format is a geospatial vector data format for geographic information system (GIS) software. It is developed and regulated by Esri as a mostly open specification for data interoperability among Esri and other GIS software products. The shapefile format can spatially describe vector features: points, lines, and polygons, representing, for example, water wells, rivers, and lakes. Each item usually has attributes that describe it, such as name or temperature.

<span class="mw-page-title-main">ArcGIS</span> Geographic information system maintained by Esri

ArcGIS is a family of client, server and online geographic information system (GIS) software developed and maintained by Esri.

Simple Features is a set of standards that specify a common storage and access model of geographic features made of mostly two-dimensional geometries used by geographic databases and geographic information systems. It is formalized by both the Open Geospatial Consortium (OGC) and the International Organization for Standardization (ISO).

gvSIG Desktop application for working with geographic data

gvSIG, geographic information system (GIS), is a desktop application designed for capturing, storing, handling, analyzing and deploying any kind of referenced geographic information in order to solve complex management and planning problems. gvSIG is known for having a user-friendly interface, being able to access the most common formats, both vector and raster ones. It features a wide range of tools for working with geographic-like information.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

<span class="mw-page-title-main">QGIS</span> Open-source desktop GIS software

QGIS, also known as Quantum GIS, is a geographic information system (GIS) software that is free and open-source. QGIS supports Windows, macOS, and Linux. It supports viewing, editing, printing, and analysis of geospatial data.

The Open Source Geospatial Foundation (OSGeo), is a non-profit non-governmental organization whose mission is to support and promote the collaborative development of open geospatial technologies and data. The foundation was formed in February 2006 to provide financial, organizational and legal support to the broader Free and open-source geospatial community. It also serves as an independent legal entity to which community members can contribute code, funding and other resources.

<span class="mw-page-title-main">GDAL</span> Translator library for raster and vector geospatial data formats

The Geospatial Data Abstraction Library (GDAL) is a computer software library for reading and writing raster and vector geospatial data formats, and is released under the permissive X/MIT style free software license by the Open Source Geospatial Foundation. As a library, it presents a single abstract data model to the calling application for all supported formats. It may also be built with a variety of useful command line interface utilities for data translation and processing. Projections and transformations are supported by the PROJ library.

JTS Topology Suite is an open-source Java software library that provides an object model for Euclidean planar linear geometry together with a set of fundamental geometric functions. JTS is primarily intended to be used as a core component of vector-based geomatics software such as geographical information systems. It can also be used as a general-purpose library providing algorithms in computational geometry.

In cartography, a Styled Layer Descriptor (SLD) is an XML schema specified by the Open Geospatial Consortium (OGC) for describing the appearance of map layers. It is capable of describing the rendering of vector and raster data. A typical use of SLDs is to instruct a Web Map Service (WMS) how to render a specific layer.

Cadcorp Limited is a British owned and run company established in 1991. Cadcorp has its headquarters in Stevenage, Hertfordshire, U.K. Cadcorp has a network of distributors and value added resellers (VARs) around the world.

The Spatial Data File (SDF) is a single-user geodatabase file format developed by Autodesk. The file format is the native spatial data storage format for Autodesk GIS programs MapGuide and AutoCAD Map 3D. As of 2014 SDF format version SDF3 uses a single file. Prior versions of the format required a spatial index file (SIF), with an optional key index file (KIF) to speed access to the file.

Tile Map Service or TMS, is a specification for tiled web maps, developed by the Open Source Geospatial Foundation. The definition generally requires a URI structure which attempts to fulfill REST principles. The TMS protocol fills a gap between the very simple standard used by OpenStreetMap and the complexity of the Web Map Service standard, providing simple urls to tiles while also supporting alternate spatial referencing system.

GIS Live DVD is a type of the thematic Live CD containing GIS/RS applications and related tutorials, and sample data sets. The general sense of a GIS Live DVD is to demonstrate the power of FLOSS GIS and encourage users to start on FLOSS GIS. However, a disc can be used for GIS data processing and training, too. A disc usually includes some selected Linux-based or Wine (software)-enabled Windows applications for GIS and Remote Sensing use. Using this disc the end users can execute GIS functions to get experience in free and open source software solutions or solve some simple business operations. The set-up and the operating behaviour of the applications can also be studied prior to building real FLOSS GIS-based systems. Recently a LiveDVD image is stored and booted from USB.

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. "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".