Software:SpatiaLite
 | |
| Developer(s) | Alessandro Furieri |
|---|---|
| Initial release | March 21, 2008 |
| Stable release | 5.1.0
/ August 4, 2023 |
| Written in | spatialite-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.
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.[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". https://packages.debian.org/jessie/spatialite-gui. Retrieved 2017-03-10.
- ↑ Furieri, Alessandro. "SpatiaLite - spatial extensions for SQLite". Gaia-SINS. http://www.gaia-gis.it/gaia-sins/spatialite-manual-2.3.1.html.
- ↑ "ArcGIS Help (10.2, 10.2.1, and 10.2.2)". http://resources.arcgis.com/en/help/main/10.2/index.html#/What_s_new_in_ArcGIS_10_2/016w0000005s000000/.
- ↑ "QGIS Features". http://qgis.org/en/about-qgis/features.html.
- ↑ "Global Mapper". http://www.bluemarblegeo.com/products/global-mapper-features.php.
- ↑ "TileMill". https://www.mapbox.com/tilemill/. Retrieved 2014-01-06.
- ↑ "Spatial Manager Desktop Page". http://www.spatialmanager.com/spm-desktop.
- ↑ "Spatial Manager for AutoCAD Page". http://www.spatialmanager.com/spm-forautocad.
- ↑ "Spatial Manager for BricsCAD Page". http://www.spatialmanager.com/spm-forbricscad.
- ↑ "SpatiaLite - GeoServer 2.6.X User Manual". http://docs.geoserver.org/stable/en/user/community/spatialite/index.html. Retrieved 2015-03-01.
- ↑ "Installing Spatialite". https://docs.djangoproject.com/en/dev/ref/contrib/gis/install/spatialite/. Retrieved 2013-01-24.
- ↑ "GeoDjango Installation | Django documentation | Django". https://docs.djangoproject.com/en/dev/ref/contrib/gis/install/#requirements.
- ↑ "FeatureServer.org". FeatureServer.org. http://featureserver.org/. Retrieved 2014-01-06.
- ↑ "SpatiaLite - MapServer Documentation". https://mapserver.org/input/vector/sqlite.html. Retrieved 2020-08-24.
- ↑ "SQLite RDBMS". Open Source Geospatial Foundation. http://www.gdal.org/ogr/drv_sqlite.html.
- ↑ "JDBC SpatiaLite - GeoTools". http://docs.codehaus.org/display/GEOTOOLS/JDBC+SpatiaLite.
- ↑ "pyspatialite". pyspatialite. https://github.com/lokkju/pyspatialite. Retrieved 2014-01-06.
- ↑ "SpatiaLite Quickstart — OSGeoLive 14.0 Documentation". http://live.osgeo.org/en/quickstart/spatialite_quickstart.html.
- ↑ "GeoConverter – Geoinformation HSR". http://giswiki.hsr.ch/GeoConverter.
- ↑ "The OGC Seeks Comments on Candidate GeoPackage Standard | OGC". https://www.ogc.org/press-release/the-ogc-seeks-comments-on-candidate-geopackage-standard/.
External links
- www
.gaia-gis .it /fossil /libspatialite / - www
.gaia-gis .it /gaia-sins /spatialite-cookbook / - www
.gaia-gis .it /gaia-sins /
 |  |
