In 2004, I created a little document with my students titled How do I do that in ArcGIS/Manifold. To our surprise, the document really took off, and had tens of thousands of downloads from all over the world. It was that document, and the response, that got me to realize how as a Professor, I could have a far reaching impact on people learning GIS.
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.