I posted on stackoverflow before to find this website. so here is my my post. I retreived europe.osm database with osm2pgsql. And now I try to exploit it. Is there a way to get the state, country, region, from a way like a town hamlet locality or city? https://wiki.openstreetmap.org/wiki/Nominatim databases osm format : if someone can provide me the SQL Query to retreive the information. asked 23 Apr '12, 15:52  Christophe D... edited 24 Apr '12, 08:39  SimonPoole ♦ |
One Answer:
I presume you have a full Nominatim installation as described on the installation page not just an osm2pgsql import. Doing SQL queries on the database directly is a bit involved. You can get administrative information much easier by sending reverse requests directly to your local installation. If you have the OSM id of your way, send something like: If you still want to go down the SQL road, have a look at the answered 24 Apr '12, 08:36  lonvia edited 24 Apr '12, 10:34 |
thanks I didn't make the full nominatim install because I've allready a geo request system, I need just to make an import to my system.
Sorry but there is not place_addressline table
The
placexandplace_addresslinetables are part of the full Nominatim import. If you don't want to do the full import, there is no point in importing the gazetteer schema in the first place.Ok I will follow the full installation. Thx