SpatiaLite
Developer(s) | Alessandro Furieri |
---|---|
Initial release | March 21, 2008 |
Stable release | 4.1.0 / June 3, 2013 |
Operating system | GNU/Linux, MS-Windows, Mac OS X, POSIX compliant systems |
Type | Geographic information system |
License | MPL GPL LGPL tri-license |
Website | http://www.gaia-gis.it/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 (or even deleted) 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.[1] 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 in order to do advanced spatial queries and support multiple map projections, SpatiaLite is needed. 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.
Being a single binary file, Spatialite is also being used as a GIS vector format to exchange geospatial data.
Software that supports SpatiaLite
- Desktop:
- ESRI ArcGIS since version 10.2 as "Database Connection". [2]
- Quantum GIS supports SpatiaLite native since version 1.1[3]
- AutocadMap 2013
- Pitney Bowes MapInfo Professional 11.5.2[4]
- Global Mapper [5]
- OpenJUMP offers a Plug-In.
- FME (also available as server)
- TileMill renderer (uses Mapnik) reads SpatiaLite as data source. [6]
- (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. [14]
Standards
Spatialite supports several open standards from the OGC and has been listed as a reference implementation for the proposed GeoPackage standard.[15]
External links
- www.gaia-gis.it/spatialite/
- www.gaia-gis.it/spatialite-2.4.0-4/spatialite-cookbook/
- www.gaia-gis.it/gaia-sins/
- www.gaia-gis.it/gaia-sins/spatialite-sql-4.0.0.html
References
- ↑ "SpatiaLite Manual". Retrieved 25 January 2012.
- ↑ http://resources.arcgis.com/en/help/main/10.2/index.html#/What_s_new_in_ArcGIS_10_2/016w0000005s000000/
- ↑ "QGIS Features" (in Englisch). Retrieved 2010-01-21.
- ↑ http://reference.mapinfo.com/software/mapinfo_pro/english/11.5.2/MapInfoProfessionalReleaseNotes.pdf
- ↑ http://www.bluemarblegeo.com/products/global-mapper.php
- ↑ "TileMill" (in Englisch). Retrieved 2014-01-06.
- ↑ "Installing Spatialite" (in Englisch). Retrieved 2013-01-24.
- ↑ https://docs.djangoproject.com/en/dev/ref/contrib/gis/install/#requirements
- ↑ "FeatureServer.org" (in Englisch). FeatureServer.org. Retrieved 2014-01-06.
- ↑ "SQLite RDBMS" (in Englisch). Open Source Geospatial Foundation. Retrieved 2010-01-21.
- ↑ "JDBC SpatiaLite - GeoTools" (in Englisch). Retrieved 2013-01-24.
- ↑ "pyspatialite" (in Englisch). pyspatialite. Retrieved 2014-01-06.
- ↑ http://live.osgeo.org/en/quickstart/spatialite_quickstart.html
- ↑ http://giswiki.hsr.ch/GeoConverter
- ↑ http://www.opengeospatial.org/standards/requests/95