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


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%

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%

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,378 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