SpatiaLite 2.2 Release Update

In light of some recent comments on this blog about the direction TerraGo is heading with its product line, I thought it would only be fitting to announce the latest release of SpatiaLite.  I have posted about SpatiaLite before and it was very well received which makes it apparent that this is a highly desirable database technology in our industry.  

2.2 is the current stable release supporting:

• full UTF-8 SQLite internal data storage and locale charsets for input and output
  
• a GUI tool supporting DB management in an user friendly way
  
• PROJ.4 latest version (4.6.1), this including an updated EPSG dataset
  
• SQLite's latest version (3.6.2) implementing the definitive R*Tree Spatial Index
  
• an alternative Spatial Index implementation using MBR caching
  
• added the new Virtual Table module VirtualText supporting direct SQL access to CSV and TxtTab files

There is a Google Group that has been been created to use for public support and announcements related to this project.  You can find this group here and I encourage everyone to participate...

What can this technology do for you?  We've seen basic attribute queries in other software applications but imagine taking enterprise-level spatial query capabilities to your desktop in a completely redistributable package (aka. single GeoPDF).  Given the nature of the SQLite engine, the data publisher (YOU!) will be able to package multi-source data layers in a single file and then import/export as needed.  

Thanks again to Alessandro for continuing development on the SpatiaLite project...

SpatiaLite: An Alternative Spatial Database

We all know about ESRI's Personal GeoDatabase (MS Access), Refraction's PostGIS, Oracle Spatial, etc... but how many folks are familiar with SpatiaLite? SpatiaLite is the spatial extension to SQLite and after a few initial rounds of testing, I think we have a decent light-weight alternative to the bigger players in the spatial DB game.

First off, what is SQLite?

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

SQLite is the most widely deployed SQL database engine in the world. It is used in countless desktop computer applications as well as consumer electronic devices including cellphones, PDAs, and MP3 players. The source code for SQLite is in the public domain.

This means that the SQLite engine is deployed in more computing environments than any other database technology in the world.

Alessandro Furieri, the author of SpatiaLite and VirtualShape, created these extensions knowing this! Good job Alessandro!

The latest release of SQLite will include better R-Tree indexing and a wide variety of other enhancements that conform to the OpenGIS Standard for Spatial Data Processing. See below for the SpatiaLite 2.1 Quick Intro.

• 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
  They are also portables; the same database file will work on Windows, Linux, MacOs etc
• the SpatiaLite extension enables SQLite to support spatial data too [aka GEOMETRY], in a way conformant to OpenGis 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(), Contains() and so on
  • 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 still experimental 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 GUI tool supports all this, in an user friendly way

How to get started with SQLiteGeo (SpatiaLite, VirtualShape, and SQLite3 combo):

1. First, try downloading SQLiteGeo. Simply download the ZIP file or Linux Version and extract it anywhere on your local file system.
2. Follow the tutorial to import, index, and analyze your data.

Version 2.1 GUI Tool:

1. There is also a GUI tool that will keep you from having to go through the command line. Click Here for all available options!
2. Download the Windows version here and the Linux version here. Extract the files to your local system and go! There is no installation...

Also, try the SQLite ODBC Driver. I have been able to import/export data through Access and Excel without very many problems.

I'm certain that there are a wide variety of uses for this self contained, file-based, spatial database technology so please feel free to comment on any interaction you may have had with it.