Version 8 of SpatiaLite

Updated 2010-06-10 20:36:04 by torsten

# the SpatiaLite extension enables SQLite to support spatial data too aka GEOMETRY, in a way conformant to OpenGis specifications

# Available at: [L1 ]

• 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, thus comprehending sophisticated spatial analysis functions such as Overlaps(), Touches(), Union(), Buffer() ..
• supports full Spatial metadata along the OpenGis specifications
• supports importing and exporting from / 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

SpatiaLite is developed and maintained by Alessandro Furieri [email protected]

---

JMN 2009-11-07 Looks interesting - but I see no reference to Tcl on the site. I'm assuming by 'extension' this refers only to it being an extension to SQLite, and that there is no Tcl interface?

SEH -- Spatialite is an extension to SQLite, and thus the Tcl binding to SQLite can be used to access Spatialite's features.

TR --This works (using sqlite 3.3.7 or newer):

 package require sqlite3
 sqlite3 db someDBfile.db
 db enable_load_extension true
 db eval {select load_extension('/path/to/spatialsqlite/libraryfile')}

andrewshadoura -- On Debian, the following works fine:

 db eval {select load_extension("libspatialite.so.2")}

---