I am trying to import OSM data into Spatialite.
The data is a query from overpass called features.osm
I'm using spatialite 3.0, and following examples, I have created a new database with:
$ spatialite features.sqlite
then I import the data using
$ spatialite_osm_net -o features.osm -d features.sqlite -T features
This results in the following output:
SQLite version: 3.7.9 SpatiaLite version: 3.0.0-beta Loading OSM nodes ... wait please ... Loaded 11 OSM nodes Verifying OSM ways ... wait please ... Verified 0 OSM ways Disambiguating OSM nodes ... wait please ... No duplicate OSM nodes found - fine ... Loading network ARCs ... wait please ... Loaded 0 network ARCs Dropping temporary table 'osm_tmp_nodes' ... wait please ... Dropped table 'osm_tmp_nodes' Dropping index 'from_to' ... wait please ... Dropped index 'from_to' VACUUMing the DB ... wait please ... All done: OSM graph was successfully loaded
However when I open the database and view the contents of 'features' table, its empty. What am I missing here? Perhaps I'm trying to fit a square peg in a round hole?
What I want, is to be able to store osm data in the sqlite database and execute queries to retrieve nodes/ways/relations for a specific bounds (just like my original url request).