Demo site: php-sqlite3geo

Disclaimer:

GIS datasets used to build the demo&test DB are in the legal property of Comune di Appiano sulla Strada del Vino - Eppan an der Weinstrasse; they are published for free download at this URL
the following public act delibera G.M. 204/2006 makes their use free for any purpose.
I dati cartografici utilizzati per alimentare il DB utilizzato a titolo di esempio didattico appartengono al Comune di Appiano sulla Strada del Vino - Eppan an der Weinstrasse e sono liberamente scaricabili da questa URL ai sensi della delibera G.M. 204/2006 che rende libero l'uso della cartografia Comunale.

a complete SQLite3 demo&test database [80MB] is published via PHP scripts [using the php-sqlite3geo extension]
you can retrive full metadata for each table via the Show defs link
you can browse rows for each table via the Browse link
- tables in the GaiaCfgxxx family fully exemplify the SQLite peculiar way to enforce referential integrity, i.e. by using triggers
- all tables in the F0x, L0x and P0x families have a BLOB-type column named GaiaGeometry, actually containing some OpenGis compliant GEOMETRY
  - you can view a full set of geometric properties via the BLOB link
  - a visual prewiew is shown for geometries; this also is a pure PHP result obtained by using GD to build dynamic images
- table TUSCANY has BLOB-type columns FOTO1, FOTO2, FOTO3, STEMMACO and STEMMAPR actually containing JPEG images
  - you can view images via the BLOB link
- table epsg contains the complete EPSG geodetic parameters database