[OSM-dev] Nominatim installation

Adrian Chapela achapela.rexistros at gmail.com
Thu Feb 24 12:34:43 GMT 2011


Hello I am trying to install Nominatim. I am following steps from
http://wiki.openstreetmap.org/wiki/Nominatim/Installation and finally I
get the next error:

2011-02-24 09:26:46 CET ERROR:  column "parent_place_id" does not exist
at character 17
2011-02-24 09:26:46 CET STATEMENT:  select place_id,parent_place_id from
placex WHERE
ST_DWithin(ST_SetSRID(ST_Point(-1.8160209864499,52.548742971495),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(-1.8160209864499,52.548742971495),4326),
ST_Centroid(geometry), 0.0002)) ORDER BY
ST_distance(ST_SetSRID(ST_Point(-1.8160209864499,52.548742971495),4326),
geometry) ASC limit 1

This error appears when I try to get a reverse geocoding from
reverse.php script. I don't know what could be the reason of this error
but I can't see the column writed in any sql script of the instructions.
Need I to execute some other scripts ?


Thank you!



More information about the dev mailing list