I installed OSM maps on POSTGRESQL database

I installed the osm.pbf file via Osm2pgsql.

after that i created a project in QGIS 3.16 Software.

This installation is for offline use.

I'm unable to perform a street and housenumber search using a plugin called "Discovery"

How do I know if the maps have been loaded correctly?

Is there another way/plugin to search for an address like google map (street and number)?

  • You can look (either in QGIS or directly in the DB) at the tables content and see if they look as expected. The next question would be to look at how you have configured the Discovery plugin
    – JGH
    Dec 13 '21 at 12:52
  • I did not know how the tables content should be , but I can see that table planet_osm_polygon contain the addr:housenumber but not the streetname what is the associatedStreet and how to create this value ?
    – alon A
    Dec 13 '21 at 15:14
  • it depends how you have configured osm2pgsql. In my case, I have loaded all extra attributes in a tag hstore column, and I can see addr:housenumber:,addr:street:, addr:postcode:,addr:city:. Let's note that this can be different between cities/countries, so you may want to also look at the points or even lines
    – JGH
    Dec 13 '21 at 16:09
  • Thanks , JGH can you sent me an example command line to load all tag ? I want to start from scratch with new DB
    – alon A
    Dec 14 '21 at 7:36
  • If you are using the "old" pgsql output, just add --hstore to the command
    – JGH
    Dec 14 '21 at 13:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.