As the years passed, I came out with a number of other documents in the series: How do I do that in Manifold SQL, How do I do that in QGIS, and How do I do that in PostGIS. These documents have also been used by thousands of people (although, nowhere near the reach of the original document).
So today I am posting my latest book in the series: How do I do that in SpatiaLite: Illustrating Classic GIS Tasks. This book is short and to the point, and actually provides users with code to illustrate all the commands that the USGS’s 1988 document A Process for Evaluating Geographic Information Systems said should be in any GIS. Between Manifold, PostGIS, QGIS, SpatiaLite, and Arcpy, I can’t keep all these languages straight (the effects of aging, I suppose). So, I keep each of these books right next to my computer for a quick reference on how to do virtually any GIS task.
I welcome you to download the .pdf and make use of it yourself with the SQLite database.. You are free of course to send it to whomever you like, but I would appreciate it if you simply provided people with a link to my site so they can see more of what I’m doing here.
If you want to learn more about how to program geospatial tasks with SQL, or how to use Free and Open Source GIS like QGIS and PostGIS, check out all my courses here. And, in celebration of the book, you can get my course Python for Geospatial for $20 here.