[GIS] OSM Nominatim Server Installation Projection Error

osm2pgsql

Environment:

Ubuntu 12.4
Postgresql 9.1.4
PostGIS 2.0.1
Latest Nominatim installation instructions posted at http://wiki.openstreetmap.org/wiki/Nominatim/Installation

The installation is failing with (command built by the Nominatim php build script):

/osm2pgsql/osm2pgsql -lsc -O gazetteer –hstore -C 1100 -d nominatim /home/user/osm_data/central-america.osm

The -l tag is causing the following error:

Projection code failed to initialise

osm2pgsql SVN version 0.80.0 (64bit id space)

ERROR: Error executing external command: /home/user/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer –hstore -C 1059 -d nominatim /home/user/osm_data/central-america.osm.pbf

In trying to troubleshoot, where is the -l tag pulling the projection code from? I can get the import to run without the -l but the import later fails with an SRID error which I can only suppose results from this initial error.

Can anyone enlighten me on what I should be looking at to fix the issue?

Thanks in advance.

Best Answer

Found a discussion about a similar problem at http://web.archiveorange.com/archive/v/wQWIbp8uENgQyNoCJGQz. Even though the discussion happened several years ago the information provided to troubleshoot is still relevant.

In doing some of the troubleshooting listed in this discussion I was able to identify and resolve the problem.

Thanks to Jon Burgess for providing the level of detail that he did in that discussion.

JAM

Related Solutions

[GIS] Nominatim installation error: Out of memory for node cache dense index

I have resolved this issue.

Go through this link and follow all the instructions posted there.

Problem Resolved

[GIS] Error on basic usage of osm2pgsql

I used the osm2pgsql command (installed with synaptic) in my Debian system in a different way. After creating and connecting the sandbox database (at a bash console):

su
********* [password]
su - postgres
psql
postgres=# CREATE DATABASE sandbox OWNER my_owner;
CREATE DATABASE
postgres=# \connect sandbox
You are now connected to database "sandbox" as user "postgres".

I created postgis and hstore extensions with these instructions:

sandbox=#CREATE EXTENSION postgis;
CREATE EXTENSION
sandbox=# CREATE EXTENSION hstore;
CREATE EXTENSION

The last one extension implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value. This is especially useful when you are working with OpenStreetMap data.

After downloading brazil-latest.osm.pbf, as it was specified above, I used this command (in a bash console):

osm2pgsql -d sandbox -s -W --hstore brazil-latest.osm.pbf

to load the layers to sandbox database.

An extract of all process at the bash console (my password was required):

osm2pgsql SVN version 0.86.0 (64bit id space)

Password:
Using projection SRS 900913 (Spherical Mercator)
.
.
.

Reading in file: brazil-latest.osm.pbf
Processing: Node(35458k 124.9k/s) Way(3307k 8.82k/s) Relation(71370 41.45/s)  parse time: 2381s
.
.
.
Stopped table: planet_osm_ways in 2613s

Osm2pgsql took 5697s overall

After finished the process, I loaded the planet_osm_polygon layer by using 'Add PostGIS Layers' button in the 'Manage Layers Toolbar' of QGIS:

It works!

Best Answer

Related Solutions

[GIS] Nominatim installation error: Out of memory for node cache dense index

[GIS] Error on basic usage of osm2pgsql

Related Question