<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SpatiaLite — OSGeo Live v4.0 documentation</title>
<link rel="stylesheet" href="_static/overview.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: '#',
VERSION: '4.0',
COLLAPSE_MODINDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true
};
</script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<link rel="top" title="OSGeo Live v4.0 documentation" href="index.html" />
<link rel="next" title="Ushahidi" href="ushahidi_overview.html" />
<link rel="prev" title="Sahana Agasti" href="sahana_overview.html" />
</head>
<body>
<div class="header">
<div class="wrap">
<ul id="top-nav">
<li class="first"><a href="http://osgeo.org">OSGeo</a></li>
</ul>
</div>
</div>
<div class="related">
<ul id="breadcrumbs">
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
accesskey="I">index</a></li>
<li class="right" >
<a href="ushahidi_overview.html" title="Ushahidi"
accesskey="N">next</a> |</li>
<li class="right" >
<a href="sahana_overview.html" title="Sahana Agasti"
accesskey="P">previous</a> |</li>
<li><a href="overview.html">OSGeo Live v4.0 documentation</a> »</li>
<li><a href="#">SpatiaLite</a></li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="body">
<a class="reference external image-reference" href="http://www.gaia-gis.it/spatialite/" id="spatialite-overview"><img align="right" alt="project logo" class="align-right" src="_images/logo-spatialite.png" style="width: 128.0px; height: 113.0px;" /></a>
<div class="section" id="spatialite">
<h1>SpatiaLite<a class="headerlink" href="#spatialite" title="Permalink to this headline">¶</a></h1>
<div class="section" id="spatial-database">
<h2>Spatial Database<a class="headerlink" href="#spatial-database" title="Permalink to this headline">¶</a></h2>
<p>SpatiaLite is an <a class="reference external" href="http://www.sqlite.org/">SQLite</a> database engine with spatial functions added.</p>
<p>SQLite is a popular DBMS, simple, robust, easy to use and really lightweight. Each SQLite database is simply a file; you can freely copy it, compress it, send it on a LAN or WEB with no complication at all.</p>
<p>The files are also portable; the same database file will work on Windows, Linux, MacOs etc.</p>
<a class="reference external image-reference" href="_images/spatialite.jpg"><img align="right" alt="screenshot" class="align-right" src="_images/spatialite.jpg" style="width: 513.5px; height: 386.5px;" /></a>
<div class="section" id="core-features">
<h3>Core Features<a class="headerlink" href="#core-features" title="Permalink to this headline">¶</a></h3>
<p>The SpatiaLite extension enables SQLite to support spatial data conformant to OGC specifications.</p>
<ul class="simple">
<li>Supports standard WKT and WKB formats</li>
<li>Implements SQL spatial functions such as AsText(), GeomFromText(), Area(), PointN() and alike</li>
<li>The complete set of OpenGis functions is supported via GEOS, this comprehending sophisticated spatial analysis functions such as Overlaps(), Touches(), Union(), Buffer() ..</li>
<li>Supports full Spatial metadata along the OpenGis specifications</li>
<li>Supports importing and exporting to shapefiles</li>
<li>Supports coordinate reprojection via PROJ.4 and EPSG geodetic parameters dataset</li>
<li>Supports locale charsets via GNU libiconv</li>
<li>Implements a true Spatial Index based on the SQLite’s RTree extension</li>
<li>The VirtualShape extension enables SQLite to access shapefiles as VIRTUAL TABLEs</li>
<li>You can then perform standard SQL queries on external shapefiles, with no need for importing or converting them</li>
<li>The VirtualText extension enables SQLite to access CSV/TxtTab files as VIRTUAL TABLEs</li>
<li>You can then perform standard SQL queries on external CSV/TxtTab files, with no need for importing or converting them</li>
<li>The GUI tool supports all this, in an user friendly way</li>
</ul>
</div>
<div class="section" id="details">
<h3>Details<a class="headerlink" href="#details" title="Permalink to this headline">¶</a></h3>
<p><strong>Website:</strong> <a class="reference external" href="http://www.gaia-gis.it/spatialite/">http://www.gaia-gis.it/spatialite/</a></p>
<p><strong>Licence:</strong> MPL v1.1 and GPL v3</p>
<p><strong>Software Version:</strong> 2.3.1 / 2.4 beta</p>
<p><strong>Supported Platforms:</strong> Linux, Mac, Windows</p>
<p><strong>API Interfaces:</strong> C++</p>
</div>
</div>
</div>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related">
<ul id="breadcrumbs">
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
>index</a></li>
<li class="right" >
<a href="ushahidi_overview.html" title="Ushahidi"
>next</a> |</li>
<li class="right" >
<a href="sahana_overview.html" title="Sahana Agasti"
>previous</a> |</li>
<li><a href="overview.html">OSGeo Live v4.0 documentation</a> »</li>
<li><a href="#">SpatiaLite</a></li>
</ul>
</div>
<div class="footer">
© Copyright 2010, OSGeo.
Last updated on Aug 01, 2010.
Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 0.6.4.
</div>
</body>
</html>