[Geocoding] Nominatim installation - Stuck at importing planet file
B1t4ng
b1t4ng at freemail.hu
Thu Nov 18 16:30:12 GMT 2010
I've tried with other extracts of Hungary, but the problem is still present. The importing gave me some strange notices about missing tables. Is it normal? :
osm2pgsql -lsc -O gazetteer -C 128 -d gazetteer hungary.osm.bz2osm2pgsql SVN version 0.70.5
Using projection SRS 4326 (Latlong)NOTICE: table "place" does not exist, skippingNOTICE: type "keyvalue" does not exist, skippingNOTICE: type "wordscore" does not exist, skippingNOTICE: type "stringlanguagetype" does not exist, skippingNOTICE: type "keyvaluetype" does not exist, skippingNOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist, skippingMid: pgsql, scale=10000000, cache=128MB, maxblocks=16385*8192Setting up table: planet_osm_nodesNOTICE: table "planet_osm_nodes" does not exist, skippingNOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"Setting up table: planet_osm_waysNOTICE: table "planet_osm_ways" does not exist, skippingNOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"Setting up table: planet_osm_relsNOTICE: table "planet_osm_rels" does not exist, skippingNOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"
Reading in file: hungary.osm.bz2Processing: Node(1016k) Way(100k) Relation(3k) parse time: 97s
Node stats: total(1016641), max(993003769)Way stats: total(100604), max(85604504)Relation stats: total(3690), max(1273073)node cache: stored: 980078(96.40%), storage efficiency: 5.84%, hit rate: 96.28%Stopping table: planet_osm_nodesStopped table: planet_osm_nodesStopping table: planet_osm_waysBuilding index on table: planet_osm_waysStopped table: planet_osm_waysStopping table: planet_osm_relsBuilding index on table: planet_osm_relsStopped table: planet_osm_rels
twain at fuge:~$
B1t4ng <b1t4ng at freemail.hu> írta:
>Thanks for your help Brian! With the fresh osm2pgsql everything went fine. I've managed to configure the service. However the reverse geocoding doesn't work as I expected. I've imported the biggest sized extract I could find of Hungary (from http://downloads.cloudmade.com/ , updated on 04 Nov), but It gives false result. I've tried different coordinates of the capitol Budapest (which is almost fully covered in the osm), but It gave me the same result always (a wrong address in Budapest). The same lookups work well in the official page, but not in my config. I haven't experienced any strange behavior during the installation, but this message is written in the apache log after a lookup:[Wed Nov 17 15:22:32 2010] [error] [client 10.0.100.25] PHP Notice: Use of undefined constant CONST_BulkUserIPs - assumed 'CONST_BulkUserIPs' in /var/www/geokod_test/reverse.php on line 5 What do you think? Should I try it with another extract? Kind regards,Gergő
>Brian Quinion <openstreetmap at brian.quinion.co.uk> írta:
>>> Now when I'm trying to import an extract of the planet.osm with osm2pgsql, I
>>> get this error:
>>> select update_place(place_id::integer) from placex where indexed=false and
>>> class='place' and type='houses' failed: ERROR: relation "placex" does not
>>> exist
>>
>>This bug was fixed some time ago so you are running an old version of osm2pgsql.
>>
>>I'd suggest you just update to the most recent version in svn.
>>
>>--
>> Brian
>
>
>Thanks for your help Brian! With the fresh osm2pgsql everything went fine. I've managed to configure the service.
>
>
>
>However the reverse geocoding doesn't work as I expected. I've imported the biggest sized extract I could find of Hungary (from http://downloads.cloudmade.com/ , updated on 04 Nov), but It gives false result. I've tried different coordinates of the capitol Budapest (which is almost fully covered in the osm), but It gave me the same result always (a wrong address in Budapest). The same lookups work well in the official page, but not in my config.
>
>
>
>I haven't experienced any strange behavior during the installation, but this message is written in the apache log after a lookup:
>
>
>[Wed Nov 17 15:22:32 2010] [error] [client 10.0.100.25] PHP Notice: Use of undefined constant CONST_BulkU
>
>serIPs - assumed 'CONST_BulkUserIPs' in /var/www/geokod_test/reverse.php on line 5
>
>
>
>What do you think? Should I try it with another extract?
>
>
>
>Kind regards,
>
>Gergő
>
>
>
>Brian Quinion írta:
>
>> Now when I'm trying to import an extract of the planet.osm with osm2pgsql, I
>> get this error:
>> select update_place(place_id::integer) from placex where indexed=false and
>> class='place' and type='houses' failed: ERROR: relation "placex" does not
>> exist
>
>This bug was fixed some time ago so you are running an old version of osm2pgsql.
>
>I'd suggest you just update to the most recent version in svn.
>
>--
> Brian
>
>_______________________________________________
>Geocoding mailing list
>Geocoding at openstreetmap.org
>http://lists.openstreetmap.org/listinfo/geocoding
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20101118/123a45ec/attachment.html>
More information about the Geocoding
mailing list