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's gravatar image

nicioli
1111
accept rate: 0%

edited 28 Apr '11, 14:18

1

The message about the non-existing tables is not critical and can be ignored. The relevant error message is "invalid SRID".

(28 Apr '11, 15:24) Frederik Ramm ♦

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?

(29 Apr '11, 10:51) nicioli

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?

permanent link

answered 28 Apr '11, 14:38

EdLoach's gravatar image

EdLoach ♦
18.1k14147262
accept rate: 23%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×211

question asked: 28 Apr '11, 13:53

question was seen: 6,161 times

last updated: 29 Apr '11, 11:50

powered by OSQA