I have the same problem. I tried to create a database with "spatialite ireland.sqlite" and it did not create any additional tables. There is also no init_spatialite script, so I have to use extra files. The spatialite_osm programme included with spatialite doesn't work with out an initialised database
$ spatialite ireland.sqlite SpatiaLite version ..: 2.4.0 Supported Extensions: - 'VirtualShape' [direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualNetwork' [Dijkstra shortest path] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache' [Spatial Index - MBR cache] - 'VirtualFDO' [FDO-OGR interoperability] - 'SpatiaLite' [Spatial SQL - OGC] PROJ.4 version ......: Rel. 4.7.1, 23 September 2009 GEOS version ........: 3.2.2-CAPI-1.6.2 SQLite version ......: 3.7.7 Enter ".help" for instructions spatialite> .tables spatialite> -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/651287 Title: spatialite doesn't include init_spatialite which is needed for SRID transformations & geometry_columns To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/spatialite/+bug/651287/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs