|
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! |
|
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? 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?