NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi. here i am with one more question.

I like to install nominatin on my server, but i only need this reverse geocode for Brazil.

So i download what i think was a part of database, but when i try to compile that a several errors appear for missing tables...

I download this file thinking that was a part of the entire planet database... but those errors appear:

postgres@webgiz:/root$ osm2pgsql -lsc -O gazetteer -C 2000 -d gazetteer brazil.osm.bz2 osm2pgsql SVN version 0.69-

Using projection SRS 4326 (Latlong) NOTICE: table "place" does not exist, skipping NOTICE: type "keyvalue" does not exist, skipping NOTICE: type "wordscore" does not exist, skipping NOTICE: type "stringlanguagetype" does not exist, skipping NOTICE: type "keyvaluetype" does not exist, skipping NOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist, skipping SELECT AddGeometryColumn('place', 'geometry', 4326, 'GEOMETRY', 2) failed: ERROR: function addgeometrycolumn(unknown, unknown, integer, unknown, integer) does not exist LINE 1: SELECT AddGeometryColumn('place', 'geometry', 4326, 'GEOMETR... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Error occurred, cleaning up

The link when i download this file is this: http://downloads.cloudmade.com/americas/south_america/brazil#downloads_breadcrumbs

So i have two questions: 1)Can i use nominatin with just a Brazil DataBase? 2)When exactly i can download this file?

Can you help me?

Thanks for all attentions!

asked 28 Feb '12, 19:57

rspilki's gravatar image

rspilki
11223
accept rate: 0%

edited 26 Jul '14, 14:27

SimonPoole's gravatar image

SimonPoole ♦
44.7k13326701


I do not know much about osm2pgsql but I can tell you that it has nothing to do with loading a brazil extract instead of the full planet. Looks more like a database setup step that need to happen before the data import step has not been done. Recheck the installation instructions.

permanent link

answered 29 Feb '12, 12:00

Vincent%20de%20Phily's gravatar image

Vincent de P... ♦
17.3k18152249
accept rate: 19%

Ignore the confusing skipping warnings. The actual error you need to pay attention to is

function addgeometrycolumn .... does not exist

Which means you are trying to run osm2pgsql on a plain postgres database rather than one which has been PostGIS enabled. See PostGIS installation instructions.

permanent link

answered 29 Feb '12, 15:51

Harry%20Wood's gravatar image

Harry Wood
9.5k2588128
accept rate: 14%

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:

×689
×1

question asked: 28 Feb '12, 19:57

question was seen: 4,115 times

last updated: 26 Jul '14, 14:27

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum