[Geocoding] Empty search_name in Nominatim DB

[Dmitry Dzhus]

29.10.2012, 11:15, "Sarah Hoffmann" <lonvia at denofr.de>:
> Hi Dimitry,
> Could you give some more details. in particular what distribution, postgresql
> and postgis version you are using and which extract you are trying to import?

Ubuntu 12.04 server, PostGIS 1.5.3, PostgreSQL 9.1.

Originally I was importing RU.osm.pbf/RU-MOW.osm.pbf (Russia or Moscow
extracts) from http://data.gis-lab.info/osm_dump/dump/latest/. I also
tried using latvia.osm.pbf extract from
http://download.geofabrik.de/openstreetmap/europe/, but search_name
stays empty regardless.

> Those notices are ok. Could you check that the postgresql log does
> not contain any error messages from the import? (There will be lots
> of warnings about missing chars, you can ignore them.) If there are
> problems with permissions, they should show up there.

I checked for several extracts and the log for every import produces
mostly «column/sequence/table/type does not exist» messages.

--------8<---------
2012-10-29 12:20:01 MSK FATAL:  database "nominatim" does not exist
2012-10-29 12:20:02 MSK WARNING:  => is deprecated as an operator name
2012-10-29 12:20:02 MSK DETAIL:  This name may be disallowed altogether in future versions of PostgreSQL.
2012-10-29 12:20:25 MSK ERROR:  role "mqmgr" does not exist
2012-10-29 12:20:25 MSK STATEMENT:  ALTER TABLE public.us_postcode OWNER TO mqmgr;
2012-10-29 12:21:24 MSK ERROR:  type "addressline" does not exist
2012-10-29 12:21:24 MSK STATEMENT:  DROP TYPE addressline CASCADE;
2012-10-29 12:21:24 MSK ERROR:  type "place_boundingbox" does not exist
...
<«does not exist» errors>
...
2012-10-29 12:21:26 MSK ERROR:  Unexpected end of string at character 49
2012-10-29 12:21:26 MSK STATEMENT:  insert into country select iso3166::varchar(2), 'name:en'->cntry_name, null, 
	  ST_Transform(geometryn(the_geom, generate_series(1, numgeometries(the_geom))), 4326) from worldboundaries;
...
<«does not exist» errors>
-------->8---------

> First of all, compare the details pages of the official server and
> your installation for a few objects. (See
> http://wiki.openstreetmap.org/wiki/Nominatim/FAQ#My_data_is_still_missing_and_it.27s_been_several_days
> for the URL to use). In particular check if names, rank and address
> level are the same.

I've just checked several nodes and ways in Latvia. Names, ranks and
admin levels match. The differences are in «Address» and «Parent of»
sections. For example, for
http://nominatim.openstreetmap.org/details.php?place_id=86301365, on
my server I don't see «Parent of» section at all, and «Address»
contains only «Sudrabu Edžus iela …» and «Латвия (Type:
boundary:administrative…)» (without intermediate address chunks like
suburb, city and postcode).

> If that looks good, run the following two queries to confirm that
> transliteration works:
> select make_standard_name('new york');
> select make_keywords(hstore('name', 'new york'));
>
> They should not return empty results or errors.

Yes, these commands return results:

nominatim=# select make_standard_name('new york');
 make_standard_name 
--------------------
 new york
(1 row)

nominatim=# select make_keywords(hstore('name', 'new york'));
   make_keywords    
--------------------
 {35287,2000,35288}
(1 row)