NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

I would like to create my own local openstreetmap-website with iD editor and edit local postgres database which was imported with osm2pgsql.

Here is the list of tables osm2pgsql made:

gis=# \dt
              List of relations
 Schema |        Name        | Type  | Owner 
--------+--------------------+-------+-------
 public | planet_osm_line    | table | osm
 public | planet_osm_nodes   | table | osm
 public | planet_osm_point   | table | osm
 public | planet_osm_polygon | table | osm
 public | planet_osm_rels    | table | osm
 public | planet_osm_roads   | table | osm
 public | planet_osm_ways    | table | osm
 public | spatial_ref_sys    | table | osm

openstreetmap-website DB scheme is quite different:

current_relation_members
current_relation_tags
current_relations
current_way_nodes
current_way_tags
current_ways

How should I correspond the osm2pgsql and openstreetmap-website DB schemes?

asked 11 Aug '14, 11:49

kayrus's gravatar image

kayrus
31223
accept rate: 0%

edited 11 Aug '14, 12:58


It is not possible to run rendering and an OSM API from the same database. The OSM API needs an "APIDB" database that you create with Osmosis; it has history information and a full set of tags for every object, but no pre-computed geometries. Rendering, or other use cases that depend on osm2pgsql-imported data, depend on pre-computed geometries but do not need all tags and no history.

To update your rendering database, you will have to make a change dump from your APIDB database and import that into your rendering database with osm2pgsql (--append mode).

If this takes too long then you have to either run it on different machines or find other ways to improve your toolchain.

permanent link

answered 11 Aug '14, 13:41

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×263
×165
×39
×11
×1

question asked: 11 Aug '14, 11:49

question was seen: 3,882 times

last updated: 11 Aug '14, 13:41

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum