[Geocoding] Nominatim installation

Adrian Chapela achapela.rexistros at gmail.com
Mon Feb 28 11:16:49 GMT 2011


I am trying to install Nominatim on a Debian PC.

Postgresql Version: 9.0.3 Debian Version
Osm2pgsql SVN last version
Nominatim SVN last version

After doing all instalation steps from
http://wiki.openstreetmap.org/wiki/Nominatim/Installation and trying to
get a reverse location
(website/reverse?format=xml&lat=42.26649&lon=-8.783147&zoom=18&addressdetails=1
) I get the next errors from Postgresql:

2011-02-28 11:56:41 CET ERROR:  column "parent_place_id" does not exist
at character 17
2011-02-28 11:56:41 CET STATEMENT:  select place_id,parent_place_id from
placex WHERE ST_DWithin(ST_SetSRID(ST_Point(-8.783147,42.26649),4326),
geometry, 0.0002) and rank_search != 28 and rank_search >= 30 and (name
is not null or housenumber is not null) and class not in ('waterway')
and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') 
OR ST_DWithin(ST_SetSRID(ST_Point(-8.783147,42.26649),4326),
ST_Centroid(geometry), 0.0002)) ORDER BY
ST_distance(ST_SetSRID(ST_Point(-8.783147,42.26649),4326), geometry) ASC
limit 1

And if I delete the unknown colunm parent_place_id from the query, I get
this other error:

2011-02-28 11:57:42 CET ERROR:  function get_addressdata(integer) does
not exist at character 392
2011-02-28 11:57:42 CET HINT:  No function matches the given name and
argument types. You might need to add explicit type casts.
2011-02-28 11:57:72 CET STATEMENT:  select
*,get_name_by_language(name,ARRAY['short_name:es-es','short_name:es','short_name:en-us','short_name:en','name:es-es','name:es','name:en-us','name:en','place_name:es-es','place_name:es','place_name:en-us','place_name:en','official_name:es-es','official_name:es','official_name:en-us','official_name:en','short_name','name','place_name','official_name','ref','type'])
as localname from get_addressdata(7456) WHERE isaddress OR type =
'country_code' order by rank_address desc,isaddress desc

I found that gazetteer-tables.sql doesn't have a create table for the
placex table with parent_place_id. I have found another sql from
Nominatim svn with a create table for the table placex with that column
but I have another strange errors and this sql aren't in the docs.

Do you have any idea what could be the reason of my error ?

Regards,



More information about the Geocoding mailing list