I decided to learn more about SpatiaLite today, so I googled "spatialite tutorial" and got stuck in. ...or tried to. I ran into some problems finding things on the websites. "New user onramp" type problems I suppose you might say. I think these point at some fairly easy website fixes, if anyone's interested in such things:
Than where it says...
SELECT PK_UID, AsText(Geometry) FROM HighWays WHERE PK_UID = 883;
I found there was no record with PK_UID = 883
but changing it to PK_UID = 744 works for example.
But perhaps that's due to using a newer version of the sample data?
All the png images are missing. Fortunately the tutorial doesn't rely on them to make sense, but yeah. broken images
Looks like it doesn't have CSS, but it could really do with some, and perhaps it could be part of the website navigation?
It's well written and all makes sense, but there's some quirky bad english in places e.g. Use of the word "profit" where "advantage" is what is meant.
I suppose one thing to do would be to move this to the wiki on the spatialite website, but (A) A redirect should be put in place if this is moved anywhere because it's currently top hit on google for "spatialite tutorial". (B) The wiki should be clearer on whether it is actually open for editing. It pretends to be, but I don't think it is.
The sample data download link is also ambiguous. I think it means the "Shapefile" link near the top of the MassGIS data page. It should say that, but in any case...
The tutorial data didn't work in spatialite gui.
The TOWNS_POLY.shp loading failed with the error "DBF contains unsupported data types". Perhaps this problem with changes to supported types:
So there's a few different website/other bugs for you. Hope it's useful
Harry Wood