0

Although there is a osm wiki page that attempts to shed light on the different tables which are created within a postgres/postgis database there is something that is not quite made clear:

Is the data in table planet_osm_roads duplicate? (i.e. would it provide anything that could not also be retrieved however indirectly from the other tables planet_osm_line,planet_osm_point,planet_osm_polygon ?

Bonus: If as assumed this is duplicate stuff is there a way to prevent its creation in the first place (assuming it increases the costs both in time and memory and disk space)?

Improve this question
4
  • 1
    osm2pgsql is a specific purpose tool, written to setup the backend for the standardized Mapnik-based OSM rendering pipeline...and the planet_osm_roads table creation is hardcoded; it's a collection of highway tagged relations for low-zoom rendering, all 'duplicates'. either drop that table, check out the --output multi backend configuration options (you can freely setup the output table structure yourself, albeit manually), or look into other tools: ogr2ogr, Imposum, Osmium, Osmosis, osm2po, osm2postgis, osm2postgres, to name a few classics.
    – geozelot
    Commented Oct 11, 2019 at 8:14
  • @ThingumaBoI thanks for your comment, which imho alraeady features most of the aspects I have asked, maybe it could become transformed to an answer as to accept it and more clearly mark it for others faceing a similar doubt?
    – humanityANDpeace
    Commented Oct 11, 2019 at 9:06
  • yeah...I was too lazy to fill it with links and so on, will rephrase tonight to make it an answer.
    – geozelot
    Commented Oct 11, 2019 at 9:50
  • that sounds great! Anyway thanks already for the hints!
    – humanityANDpeace
    Commented Oct 11, 2019 at 10:12

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.