29.10.2012, 11:15, "Sarah Hoffmann" <[email protected]>: > 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) _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
