CODEWITHSUNDEEP
postgresqlopenstreetmap
Daniel
Daniel

Reputation: 1564

How to Find all address name from osm that's imported into postgres

How can I get all address name from osm. in the schemas imported into postgres database. I have found. But none of them seem to contain a readily available address, which I can easily select. What can I do?

 public | geometry_columns   | table | postgres
 public | planet_osm_line    | table | postgres
 public | planet_osm_nodes   | table | postgres
 public | planet_osm_point   | table | postgres
 public | planet_osm_polygon | table | postgres
 public | planet_osm_rels    | table | postgres
 public | planet_osm_roads   | table | postgres
 public | planet_osm_ways    | table | postgres
 public | spatial_ref_sys    | table | postgres

Upvotes: 2

Views: 1564

Answers (1)

MaM
MaM

Reputation: 2069

The DB schema you are refering to, is produced by osm2pgsql as part of the OSM rendering stack. So it's tuned for the purpose of drawing maps.

To search for an address (called geocoding) is a completely different use of geodata that needs different DB schemas/datastructures. Furthermore, you need to do preprocess and clean of OSM raw data to create hierachies (e.g. continent-country-county-city-street-housenumber) etc.
At OSM the nominatim tool is used for such kind of purposes and is recommend for (reverse)geocoding.

Upvotes: 1

Related Questions