[Live-demo] Reviewed Spatialite Overview docs

Cameron Shorter cameron.shorter at gmail.com
Sun Aug 1 02:29:00 PDT 2010


Pirmin,
Thanks for these docs. There are very good, answering questions users 
are likely to want to know.
I've made a couple of very minor syntax corrections.
The only thing I'd like you to update is that there is only one version 
described.
The version number should describe the version of the software installed 
on this DVD.


    Spatial Database¶ <cid:part1.04000906.05030802 at gmail.com>

SpatiaLite is an SQLite <http://www.sqlite.org/> database engine with 
spatial functions added.

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.

The files are also portable; the same database file will work on 
Windows, Linux, MacOs etc.


      Core Features¶ <cid:part2.09010503.01060901 at gmail.com>

The SpatiaLite extension enables SQLite to support spatial data 
conformant to OGC specifications.

    * Supports standard WKT and WKB formats
    * Implements SQL spatial functions such as AsText(), GeomFromText(),
      Area(), PointN() and alike
    * The complete set of OpenGis functions is supported via GEOS, this
      comprehending sophisticated spatial analysis functions such as
      Overlaps(), Touches(), Union(), Buffer() ..
    * Supports full Spatial metadata along the OpenGis specifications
    * Supports importing and exporting to shapefiles
    * Supports coordinate reprojection via PROJ.4 and EPSG geodetic
      parameters dataset
    * Supports locale charsets via GNU libiconv
    * Implements a true Spatial Index based on the SQLite's RTree extension
    * The VirtualShape extension enables SQLite to access shapefiles as
      VIRTUAL TABLEs
    * You can then perform standard SQL queries on external shapefiles,
      with no need for importing or converting them
    * The VirtualText extension enables SQLite to access CSV/TxtTab
      files as VIRTUAL TABLEs
    * You can then perform standard SQL queries on external CSV/TxtTab
      files, with no need for importing or converting them
    * The GUI tool supports all this, in an user friendly way


      Details¶ <cid:part3.09080509.04010605 at gmail.com>

*Website:* http://www.gaia-gis.it/spatialite/

*Licence:* MPL v1.1 and GPL v3

*Software Version:* 2.3.1 / 2.4 beta

*Supported Platforms:* Linux, Mac, Windows

*API Interfaces:* C++

-- 
Cameron Shorter
Geospatial Director
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254

Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
http://www.lisasoft.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20100801/30cbd4c9/attachment.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20100801/30cbd4c9/attachment-0001.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20100801/30cbd4c9/attachment-0002.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20100801/30cbd4c9/attachment-0003.html>


More information about the Osgeolive mailing list