last updated: 2019-01-04

Back to the SpatiaLite home page

Chapter 01: Kitchen tools and cooking techniques

     Topics Topic page
quick technical intro read
getting started [installing the software] ---
building your first Spatial Database ---
what's a Shapefile ? read
what's a Virtual Shapefile ? (and Virtual Tables ...) read
what's a Charset Encoding ?? (and why must I deal with such nasty things ?) read
what's this SRID stuff ? ... I've never heard this term before now ... read
executing your first SQL queries. read
basics about SQL queries read
understanding aggregate functions read
kitchen tools

Chapter 02: Commonly used ingredients

     Topics Topic page
your first Spatial SQL queries read
more about Spatial SQL: WKT and WKB read
Spatial MetaData Tables read
viewing SpatiaLite layers in QGIS read

Chapter 03: Family cooking

     Topics Topic page
recipe #1: creating a well designed DB read
recipe #2: your first JOIN queries read
recipe #3: more about JOIN read
recipe #4: about VIEWs read
recipe #5: creating a new table (and related paraphernalia) read
recipe #6: creating a new Geometry column read
recipe #7: Insert, Update and Delete read
recipe #8: understanding Constraints read
recipe #9: ACIDity: understanding Transactions read
recipe #10: wonderful R*Tree Spatial Index read

Chapter 04: Haute cuisine

     Topics Topic page
recipe #11: Guinness Book of Records read
recipe #12: Neighbours read
recipe #13: Isolated Islands read
recipe #14: Populated Places vs Communities read
recipe #15: Tightly bounded Populated Places read
recipe #16: Railways vs Communities read
recipe #16a: SpatialIndex as BoundingBox read
recipe #17: Railways vs Populated Places read
recipe #18: Railway Zones as Buffers read
recipe #19: merging Communities into Provinces and so on ... ---
recipe #20: Spatial Views read
recipe #20: Spatial Views - Writable read
terrine de saumon

Chapter 05: Desserts, spirits, tea and coffee

     Topics Topic page
System level performace hints read
Importing/Exporting Shapefiles (DBF, TXT ...) read
Language bindings: [C/C++, Java, Python, PHP ...] read
Fine dining experience: Chez Dijkstra read
fried banana

Chapter 06: Cooking basics, which are useful to know

     Topics Topic page
An introduction to SpatiaLite read
The OpenGIS geometry model read
Supported Spatial Data Formats read
Coordinate Reference Systems; the EPSG dataset read
Spatial Metadata support read
The VirtualShape module read
The VirtualText module ---
Spatial Indexing support read
Mbr Caching support read
SpatiaLite conformance and compatibility read
Dynamically loading SpatiaLite as an extension module read

Chapter 07: Exotic Cooking aspects, which are often forgotten (or avoided)

     Topics Topic page
Geodesic background knowlage, needed for Geodesic functions read

Chapter 08: Background Information and Sql-HowTo's

     Topics Topic page
Background Information about: ---
Administration Tasks: ---
How to Sql samples: ---
How to Topology: ---

Other topics of interest, for which no recipes (yet) exist

     Topics Topic page
Spatialite Tools (installing): ---
Dynamically loading SpatiaLite as an extension module read
Correspondences between SQL Functions and DE-9IM Intersection Matrices read
Affine Transformations read
SQL functions supporting Circles and Ellipses read
using CloneTable() read
Importing and exporting geospatial data as CAD drawing files read
GPX tracks read
Ground Control Points read
ISO Metadata read
ISO Topology read
SRID Inspection read
ST_Cutter read
SQL Procedures, Stored Procedures and Stored Variables read
Tessellation-related SQL functions read
about VirtualElementary read
Loading geospatial data from a WFS datasource read
XmlBlob - Quick start read
about VirtualPG (Version 2) read
VirtualKNN: a quick intro read
Separate complex geometries into distinct elements: VirtualElementary read

Back to the SpatiaLite home page
last updated: 2019-01-04

The author
CC-BY-SA logo Authors:
Alessandro Furieri (first and second edition 3.0, 5.0)
Mark Johnson (second edition 5.0)
The co-author
This work is licensed under the Attribution-ShareAlike 4.0 International 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.