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, _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
