QGIS import osm data via OSM-plugin and sqlite does not only import selected tags

Question

I have the following problem: I want to use the OSM plugin to import data from a sqlite database that contains OSM data. In the 'Export OSM topolgy to spatialite' dialog I choose the database file and the polygon geometry. Then I click the 'Exported tags' button. This shows me the list of tags together with the count of features. In my case, I select admin_level, which has 267 features. Now I press ok. After the export, I would expect that only 267 features are inserted in the added layer. But when I check the feature count of the new layer it has about 52000 tags, which is pretty much every polygon. When I had a look at the attribute table the admin_level field has the value NULL for every feature.

When I check the 'Not Null' checkbox, the new layer is empty and has no features at all, so it seems that all values are NULL in some sense. I'm not sure to what attribute the 'not null' conditions applies. If I would know, I could cross-check it in the database.

Answer 1

The Openstreetmap import tool still seems to have some bugs. While filtering for amenity works for me, it returns no objects for me when filtering for admin_level. It might be that closed ways and relations of type boundary and multipolygon are treated differently.

A more reliable way is the QuickOSM plugin, which lets you search for the key admin_level (with no entry in the value field) on the server side.

Answer 2

Did you check the 'Not Null' checkbox to apply the filter? If you didn't that might explain it.

You might not have spotted this... sometimes you need to resize the dialog (or scroll horizontally) to see it. Clicking on Select all selects all tags, but it doesn't check the corresponding 'is null' values, you'll need to do that manually.

Also, I find the OSM Spatialite function falls over if it finds two tags which have the same name, but differ in case (like 'FIXME' and 'Fixme'). You need to remove them by hand. (You'll get a 'duplicate field' error)

If this still doesn't work, there are other ways to get OSM data into QGIS - you might want to look at the QuickOSM plugin (if you don't need a database) and osm2pgsql to populate a postgres/postgis database.