Note: these pages are no longer maintained

Never the less, much of the information is still relevant.
Beware, however, that some of the command syntax is from older versions, and thus may no longer work as expected.
Also: external links, from external sources, inside these pages may no longer function.

SpatiaLite logo

Getting started [installing the software]

2011 January 28

Previous Slide Table of Contents Next Slide

This one isn't a theory handbook: this one is a practical how-to tutorial for absolute beginners.
The underlying assumption is that you ignore everything about DBMS, SQL and even GIS.
So we'll begin downloading few resources from the WEB, and we'll then immediately start our operative session:

Download the app

Start your web browser and go to SpatiaLite's home:
The current version (January 2011) is v.2.4.0-RC4, and you can get executable binaries from:

Quite obviously the download site layout changes from time to time, so the above URLs may become quickly outdated.
May be Linux users have to build binaries from themselves starting from sources: in such case read carefully the appropriate release notes before starting.

Download the sample dataset #1

The first dataset we'll use is the Italian National Census 2001, kindly released by ISTAT (the Italian Census Bureau).
Point your web browser at and then download the following files:

Download the sample dataset #2

The second required dataset is GeoNames, a worldwide collection of Populated Places.
There are several flavors of this dataset: we'll use cities-1000 (any populated place into the word counting more than 1,000 peoples).

Launching the app

The spatialite_gui tool doesn't require any installation: simply unzip the compressed image you've just now downloaded, and click the launch icon. That's all.

Previous Slide Table of Contents Next Slide

CC-BY-SA logo Author: Alessandro Furieri
This work is licensed under the Attribution-ShareAlike 3.0 Unported (CC BY-SA 3.0) license.

GNU logo Permission is granted to copy, distribute and/or modify this document under the terms of the
GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation;
with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts.