Spatialite Database

SQLite based file Geodatabase

SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.

It is similar to PostGISOracle Spatial, and Microsoft 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 Walkthrough

Walkthrough review of the SpatiaLite and QGis applications following Lee Hachadoorian’s presentation to NYC Open Data Meetup group.

Devin Markell Devin Markell

SpatiaLite Walkthrough 2

shows some analysis and visualization.

Read and write a SpatiaLite database

Read and write spatial data to a SQLite database using FME’s SpatiaLite Reader / Writer. Achieve support for spatial features and multiple coordinate systems inside a small, local relational database engine.

Dataset obtained from City of Vancouver –http://data.vancouver.ca/datacatalogu…

spatialite-gui

spatialite-gui is an open source Graphical User Interface (GUI) tool supporting SpatiaLite

It’s a tool to build a database, create tables, convert Shapefiles and other data into SpatiaLite Tables

Please check website for latest version and other information

Sources: current version is 1.7.1 (released on 2013-06-29)

About

SpatiaLite itself simply implements a basic subset of the SQL with Geometry Types environment proposed by OGC; but SpatiaLite directly integrates others very popular open source libraries, such as: the GEOS library implements sophisticated spatial analysis functions GEOS was originally developed to support the PostGIS spatial extension for PostgreSQL; so, SpatiaLite can perform any kind of spatial analysis, and in exactly the same way PostGIS will do the PROJ.4 library implements coordinate transformation between different Coordinate System References it supports the very popular and widespread EPSG geodetic database, thus allowing to use any known CSR [at least, the main ones] the LIBICONV library implements support for locale_charset, thus effectively supporting any exotic language, such as Chinese, Japanese, Cyrillic etc the SQLite library implements a full SQL data engine; SQLite’s latest version 3.6.2 includes a native implementation for RTree, thus effectively supporting Spatial Indices
 

Strengths of SpatiaLite

All this put together make SpatiaLite to be a quite complete and powerful Spatial DBMS. The main strength points of the SQLite + SpatiaLite couple are: no need for complex installation procedures no DBMS administration at all a very low system footprint an elementary complexity, combined with a good performance level a big simplicity of use

SQL Reference Functions

Spatial SQL functions reference guide

SQL Reference

SpatiaLite 4.1.0          SQL functions reference list

back

SpatiaLite Tools

Tools

  • spatialite: a complete CLI front-end, more or less equivalent to the well known sqlite3 front-end, but fully supporting SpatiaLite
  • spatialite_tool: a tool supporting import/export of Shapefiles and DBF-files
  • shp_doctor: a diagnostic tool to check anomalous shapefiles
  • exif_loader: an import tool for EXIF or EXIF-GPS (JPEG) pictures
  • spatialite_osm_raw: a tool importing OSM files (raw format tables, strictly corresponding to XML input)
  • spatialite_osm_filter: a tool allowing to re-export spatially selected OSM files form a raw-format DB
  • spatialite_osm_map: a tool importing map layers from an OSM file
  • spatialite_osm_net: a tool creating a road network from an OSM file
  • spatialite_network: a tool creating a VirtualNetwork (supporting shortest path / routing SQL queries)
  • spatialite_gml: a tool importing GML files

spatialite-tools are licensed under the GPL v3 (or any subsequent version) terms

This content is from https://www.gaia-gis.it/fossil/spatialite-tools/index  please check here for the latest version
Sources: current version is 4.1.1 (released on 2013-06-29)

more documentation about OSM tools