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 tw...@fuge:~$ B1t4ng <[email protected]> í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 <[email protected]> í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 >[email protected] >http://lists.openstreetmap.org/listinfo/geocoding
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
