Version 1 of SpatiaLite

Updated 2009-11-03 16:21:00 by AKgnome

# 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]