I always get the following message during import of downloaded compressed osm data into my database (version 8.4). I can connect to the db via pgadmin tool. I have gone through the installation steps of the Mapnik Wiki Page (http://wiki.openstreetmap.org/wiki/Mapnik). Database is cool. But where are the missing table? postgres@oli-VirtualBox:~$ osm2pgsql -m -d gis /oli/Downloads/baden-wuerttemberg.osm.bz2 osm2pgsql SVN version 0.69- Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point ADVICE: Tabelle »planet_osm_point« doesn't exist, skipping ADVICE: Tabelle »planet_osm_point_tmp« doesn't exist, skipping SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 ); failed: ERROR: AddGeometryColumns() - invalid SRID CONTEXT: SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 , $5 )" PL/pgSQL-Function »addgeometrycolumn« Zeile 4 at SQL-Statement Error occurred, cleaning up Maybe the path to my downloaded osm files could be a problem? rights? Thanx for helping Oliver I have added the missing table via SQL from an other osm database, but the errors are still the same!! Strange! asked 28 Apr '11, 13:53  nicioli edited 28 Apr '11, 14:18 |
One Answer:
I'm no expert, but your error message looks similar to the one described here. Have you seen and tried that solution to see if it helps in your case? answered 28 Apr '11, 14:38  EdLoach ♦ 1 You can try SELECT * FROM geometry_columns WHERE srid = 900913. If you get no rows back then this is indeed your problem. (28 Apr '11, 14:53) SK53 ♦ Thank you EdLoach for you advice, this was the solution. But now i got a error while opening file - message. Sorry i'am a newbie in Ubuntu but i think i should find a solution for this.. (29 Apr '11, 10:49) nicioli |
The message about the non-existing tables is not critical and can be ignored. The relevant error message is "invalid SRID".
Thank you Frederik, you was right with your advice and i now have a solution for my problem but how it comes that the mercartor projection (epsg 900913) is missing?