This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

How to set up PostGIS database in “apidb” format?

0

I've just managed to compile & install the new openstreetmap-cgimap (issue).

But it needs a PostGIS database with apidb scheme. How can I import a .osm.pbf dump (or better: the coastline dump) into an apidb-compatible database?

The osmosis examples only explain how to export from a local PostgreSQL rails port database.

asked 28 Jan '19, 20:41

baerbock's gravatar image

baerbock
11112
accept rate: 0%


One Answer:

1

See https://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.47#--write-apidb_.28--wd.29 - also if you need to create the initial apidb schema, either you'll have to do a "rake db:migrate" in a local openstreetmap-website installation or you use one of the scripts in https://github.com/openstreetmap/osmosis/tree/master/package/script/contrib .

answered 29 Jan '19, 00:38

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

Source code available on GitHub .