This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Nominatin only for brazil reverse geocoding

0

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


2 Answers:

1

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.

answered 29 Feb '12, 15:51

Harry%20Wood's gravatar image

Harry Wood
9.5k2588128
accept rate: 14%

0

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.

answered 29 Feb '12, 12:00

Vincent%20de%20Phily's gravatar image

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

Source code available on GitHub .