[ 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