Hi, I downloaded OSM data from Geofabrik and saved it in a Spatialite database. Now I want to select all the buildings from my region and save it in a separate table. Is there a way to do this in Spatialite with a Inner Join between the osm nodes id/tags tables and the way id/tags tables? asked 10 Sep '17, 18:42  terra03032006 |
This is a static archive of our old OSM Help Site.
Please post any new questions and answers at community.openstreetmap.org.
How did you convert from .osm.pbf (or .osm.bz2) to Spatialite? The software used for that will determine the options you have.
I used the spatial_osm_raw tool like this: spatial_osm_raw -o region.osm.pbf -d my_data.sqlite
Are you really sure you want to go down this (hard) route which would require that you manually collect the nodes for building ways (as well as the ways and nodes for building relations!) when using
spatialite_osm_map(instead ofspatialite_osm_raw) promises to handle all this for you automatically?I am not using these tools myself but when searching for the name of the tool on the web, I found https://www.gaia-gis.it/fossil/spatialite-tools/wiki?name=OSM+tools which seems to explain that
spatialite_osm_mapalready gives you tables for the individual feature types, including (I suppose) buildings!ya but I want to work with the raw data, are there some links which can help me to achieve my goal?