Getting OSM maps in Equirectangular Projection via osm2pgsql

Question

I'm trying to import some OSM data into psql as equirectangular projection using osm2pgsql with the following command:

osm2pgsql -c -d osm -S /usr/local/share/osm2pgsql/default.style -l /OPENSTREETMAP/south-america-latest.osm.pbf

However, it fails with this error:

Projection code failed to initialise

I have installed the latest version of the PROJ framework from here.

What am I doing wrong?

EDIT 1:

Running 'select * from spatial_ref_sys where srid=4326;' on the database produces this:

 srid | auth_name | auth_srid |                                                                                                                              srtext                                                                                                                              |              proj4text               
------+-----------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------
 4326 | EPSG      |      4326 | GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]] | +proj=longlat +datum=WGS84 +no_defs 
(1 row)

Answer 1

Make sure that your version of osm2pgsql is built for the version of postgis you have.

There were some major changes in postgis 2.0.

It might help to run the legacy.sql to add the old functions again, see

https://postgis.net/docs/PostGIS_FAQ.html#legacy_faq

---

EDIT

Second choice:

https://help.openstreetmap.org/questions/16175/nominatim-installation-problem-projection-code-failed

https://www.mail-archive.com/[email protected]/msg09334.html

comes with the same error, because the proj lib can not be found. This was a Windows system, but make sure osm2pgsql can find the proj lib.

Answer 2

AFAIK the most OSM tools rely on a 4326 projection, so it's not a wise idea to change the DB schema to a different one. Instead you could write a small wrapper or use e.g. Geoserver to reproject the geometries per request.