[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