[GIS] How to filter OSM data for addr keys with Osmosis

importMySQLopenstreetmaposmfilterosmosis

I'm trying to import the address data of a specific country from an OSM file into a MySQL DB.

I tried to insert the data with osmosis and also to filter them with osmfilter before running OSM but without success.

After a long time of google search and frustration, I decided to post here my problem.

Can someone tell me how I can use the osmosis to import only data with following keys ->

'addr:city', 'addr:housenumber', 'addr:postcode', 'addr:street', 'addr:country', 'addr:housename', 'address',  'addr:place', 'addr:suburb', 'addr:province', 'addr:state', 'addr:number'

Best Answer

As stated here link to previous article while it is possible to add the data to MySQL common wisdom advises against this practice. Most of the tools have been developed to import OSM data in PostgresQL + PostGIS databases, for RDBMS or using GDAL toolkit, to convert OSM XML data to SpatiaLite file database.

Related Solutions

[GIS] How to filter OSM files based on tags using Osmosis

You cannot combine filter options (condition A && condition B).

What you can do is filter in two different steps - first keep only ways satisfying the source condition and then filter the first step's result using the attribution condition.

E.g.:

./bin/osmosis --rx file=ireland.osm --tf accept-ways source=* --un --wx step1.osm

./bin/osmosis --rx file=step1.osm --tf accept-ways attribution=* --un --wx result.osm

[GIS] Extracting data with osmosis

Part of the error log says:

XML document structures must start and end within the same entity.

This looks like a broken download.

To test your tool chain, you better start up with some of the smaller datasets offered by Geofabrik. By the way, reading .pbf is much faster than the old .bz2 format.

For simple filtering, I would prefer osmfilter and osmconvert.

Best Answer

Related Solutions

[GIS] How to filter OSM files based on tags using Osmosis

[GIS] Extracting data with osmosis

Related Question