[ gpsdrive ] Vector data (OSM, WDB) failed to insert to mysql and displaying in gpsdrive

Tamas Szabo klt29 at freemail.hu
Thu Aug 9 12:55:06 AKDT 2007


Hi,

I'm using gpsdrive-2.10svn15113909, and I would like to try vector map.

I followed instruction in README.OpenStreetMap-Vektordata:

geoinfo.pl --db-user=root --db-password='mypwd' --create-db --fill-defaults

finishes successfully, but when I execute

geoinfo.pl --db-user=root --db-password='mypwd' --osm

I got the following:

Import OSM Data(world)
Delete old 'OSM node' Data
Delete old 'OSM segment' Data
Delete old 'OSM way' Data
Import OSM Data ''
Download planet-xxxxxx.osm
Mirror /home/tszabo/osm/planet/planet-070801.osm complete

than geoinfo stucks. It quicky eats my 1GB RAM that slowly occupy ~700MB 
of swap memory (this case was after ~14 hours). During CPU runs at 100% 
(until eats all RAM, than HDD using goes up to 100%). However df -h does 
not show any disk space reduction and no data imported to 'streets'.

I also tried:

geoinfo.pl --db-user=root --db-password='mypwd' 
--osm=download:muenchen_part --show-traffic

result:

Import OSM Data(world)
Delete old 'OSM node' Data
Delete old 'OSM segment' Data
Delete old 'OSM way' Data
Import OSM Data 'download:muenchen_part'
Download OSM Data
Download OSM Area muenchen_part (11.5,48,     11.6,48.1)
Get 11.5,48                        Got 11.5,48             345 Bytes
/home/tszabo/.gpsdrive/MIRROR/osm/Streets_osm_48.00,011.50,48.10,011.60.osm: 
345 Bytes

Download and import of OSM Data FINISHED

however Streets_osm_48.00,011.50,48.10,011.60.osm contains:

<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
   <title>403 - Forbidden</title>
  </head>
  <body>
   <h1>403 - Forbidden</h1>
  </body>
</html>

I think API 0.3 is not usable, so I modified to 0.4:

my $osm_base_url="http://www.openstreetmap.org/api/0.4/map?bbox=";

the result is a lot of "cannot determine streets_type_id for way 
(xxxxxxxx)".

In case of WDB the case is better, data is dowloaded and inserted into 
database, however in gpsdrive nothing displayed, although it can connect 
to geoinfo db as gast with pwd=gast.

Have anybody any idea what I make wrong?

Thx,

/sza2



More information about the GPSdrive mailing list