<div>
<div>
I've tried with other extracts of Hungary, but the problem is still present.</div>
<div>
</div>
<div>
The importing gave me some strange notices about missing tables. Is it normal? :</div>
<div>
<span style="font-size:12px;"><br />
</span></div>
<div>
<div id="cke_pastebin">
<span style="font-size:10px;">osm2pgsql -lsc -O gazetteer -C 128 -d gazetteer hungary.osm.bz2</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">osm2pgsql SVN version 0.70.5</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><br />
</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Using projection SRS 4326 (Latlong)</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: table "place" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: type "keyvalue" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: type "wordscore" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: type "stringlanguagetype" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: type "keyvaluetype" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Mid: pgsql, scale=10000000, cache=128MB, maxblocks=16385*8192</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Setting up table: planet_osm_nodes</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: table "planet_osm_nodes" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Setting up table: planet_osm_ways</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: table "planet_osm_ways" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Setting up table: planet_osm_rels</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: table "planet_osm_rels" does not exist, skipping</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><br />
</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Reading in file: hungary.osm.bz2</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Processing: Node(1016k) Way(100k) Relation(3k) parse time: 97s</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><br />
</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Node stats: total(1016641), max(993003769)</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Way stats: total(100604), max(85604504)</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Relation stats: total(3690), max(1273073)</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">node cache: stored: 980078(96.40%), storage efficiency: 5.84%, hit rate: 96.28%</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Stopping table: planet_osm_nodes</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Stopped table: planet_osm_nodes</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Stopping table: planet_osm_ways</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Building index on table: planet_osm_ways</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Stopped table: planet_osm_ways</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Stopping table: planet_osm_rels</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Building index on table: planet_osm_rels</span></div>
<div id="cke_pastebin">
<span style="font-size:10px;">Stopped table: planet_osm_rels</span></div>
<div>
<span style="font-size:10px;"><br />
</span></div>
<div>
<span style="font-size:10px;">twain@fuge:~$</span></div>
<div>
<br />
B1t4ng <b1t4ng@freemail.hu> írta:</div>
</div>
<blockquote style="border-left:3px solid lightGray;padding-left:3px;">
<div>
<div>
Thanks for your help Brian! With the fresh osm2pgsql everything went fine. I've managed to configure the service.</div>
<div>
</div>
<div>
However the reverse geocoding doesn't work as I expected. I've imported the biggest sized extract I could find of Hungary (from <a class="external free" href="http://downloads.cloudmade.com/" rel="nofollow" style="text-decoration: none; color: rgb(51, 102, 187); background-image: url(http://wiki.openstreetmap.org/w/skins/vector/images/external-link-ltr-icon.png); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; padding-top: 0px; padding-right: 13px; padding-bottom: 0px; padding-left: 0px; background-position: 100% 50%; background-repeat: no-repeat no-repeat; " target="_blank">http://downloads.cloudmade.com/</a> , 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.</div>
<div>
</div>
<div>
I haven't experienced any strange behavior during the installation, but this message is written in the apache log after a lookup:</div>
<div>
<div id="cke_pastebin">
[Wed Nov 17 15:22:32 2010] [error] [client 10.0.100.25] PHP Notice: Use of undefined constant CONST_BulkU</div>
<div id="cke_pastebin">
serIPs - assumed 'CONST_BulkUserIPs' in /var/www/geokod_test/reverse.php on line 5</div>
<div>
</div>
<div>
What do you think? Should I try it with another extract?</div>
<div>
</div>
<div>
Kind regards,</div>
<div>
Gergõ</div>
<div>
</div>
<br />
Brian Quinion <openstreetmap@brian.quinion.co.uk> írta:</div>
<blockquote style="border-left:3px solid lightGray;padding-left:3px;">
> Now when I'm trying to import an extract of the planet.osm with osm2pgsql, I<br />
> get this error:<br />
> select update_place(place_id::integer) from placex where indexed=false and<br />
> class='place' and type='houses' failed: ERROR: relation "placex" does not<br />
> exist<br />
<br />
This bug was fixed some time ago so you are running an old version of osm2pgsql.<br />
<br />
I'd suggest you just update to the most recent version in svn.<br />
<br />
--<br />
Brian</blockquote>
</div>
<br />
<br />
Thanks for your help Brian! With the fresh osm2pgsql everything went fine. I've managed to configure the service.<br />
<br />
<br />
<br />
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.<br />
<br />
<br />
<br />
I haven't experienced any strange behavior during the installation, but this message is written in the apache log after a lookup:<br />
<br />
<br />
[Wed Nov 17 15:22:32 2010] [error] [client 10.0.100.25] PHP Notice: Use of undefined constant CONST_BulkU<br />
<br />
serIPs - assumed 'CONST_BulkUserIPs' in /var/www/geokod_test/reverse.php on line 5<br />
<br />
<br />
<br />
What do you think? Should I try it with another extract?<br />
<br />
<br />
<br />
Kind regards,<br />
<br />
Gergõ<br />
<br />
<br />
<br />
Brian Quinion írta:<br />
<br />
> Now when I'm trying to import an extract of the planet.osm with osm2pgsql, I<br />
> get this error:<br />
> select update_place(place_id::integer) from placex where indexed=false and<br />
> class='place' and type='houses' failed: ERROR: relation "placex" does not<br />
> exist<br />
<br />
This bug was fixed some time ago so you are running an old version of osm2pgsql.<br />
<br />
I'd suggest you just update to the most recent version in svn.<br />
<br />
--<br />
Brian<br />
<br />
_______________________________________________<br />
Geocoding mailing list<br />
Geocoding@openstreetmap.org<br />
http://lists.openstreetmap.org/listinfo/geocoding</blockquote>
</div>