[pgrouting-users] osm2pgrouting import problem

Mon Aug 31 13:12:10 EDT 2009

 I took now a smaller area, using osmosis to cut it out, so I have 360 MB
OSM file. But now I've run into another issue: result ways are just not
split. So the situation is that importing using unpatched osm2pgrouting ran
out of memory, patched osm2pgrouting one imports, but without proper
topology. So it is quite useless this way also. I tried twice, each import
took quite a few hours.

Is there any way to fix it after import?

/Jaak

 I'm trying to do exactly same as Kai, with Germany.osm (6.4G). I

> applied last osm2pgrouting patch without obvious errors (tried also
> http://pgrouting.postlbs.org/ticket/161 but this gave patch errors), I
> did make and tried import. My current result was same as without
> patch: last message is "Trying to parse data" and it stops
> immediately. It seems to work with some other, much smaller osm file.
> I have 512M in my (virtual) machine, could this be a problem?
>
> Or maybe someone is ready to share ready DB dump for Germany ? I just
> need table "ways" for some experiments.
>
> Thank you!
>
> /Jaak Laineste
>
>
> > Dear users,
> >
> >
> > The amount of roads,ways,tracks,footways is the same (with patch or
> without patch).
> >
> >
> > but the way I did I get unfortunately wrong results (you can see it in
> the screenshot in the attachment).
> >
> >
> > Maybe I did something wrong?
> >
> > Well, integrating the patch worked, but I`m not sure how to use
> > "osm2pgrouting-with-the-patch" then?
> >
> > As I said: If I don`t have the table-structure (nodes ....etc.)
> > I get a couple of errors while doing:
> >
> > "./osm2pgrouting -file your-OSM-XML-File.osm -conf mapconfig.xml -dbname
> routing -user postgres"
> >
> > If I have the table-structure data are written in (but in that case with
> wrong vertices)
> >
> > (I made the tests described here:
> > http://pgrouting.postlbs.org/wiki/Understandingandtestingthedata )
> >
> >
> >
> > Has anybody an idea what could be the reason?
> >
> > Thank you very much, Kai
> >
> >
> >
> >
> >
> > -------- Original-Nachricht --------
> >> Datum: Wed, 15 Jul 2009 14:46:30 +0200
> >> Von: "Kai Behncke" <Kai-Behncke at gmx.de>
> >> An: pgrouting-users at lists.postlbs.org
> >> Betreff: Re: [pgrouting-users] osm2pgrouting import problem
> >
> >> I have tried the patch now while the table-structure existed alredy
> >> (emplty tables):
> >>
> >> http://www.kneipenculture.de/database.png
> >>
> >>
> >> That time it worked well and I got routing-data in the database, but far
> >> less then I had without the patch
> >>
> >> (without the patch I had 16300 ways, with the patch I have 9000 ways) (I
> >> tested it with the osm-data of the City "Osnabrueck").
> >>
> >> Might it be that only special types are transformed?
> >>
> >> I will try to analyze what makes the difference.......
> >>
> >>
> >>
> >>
> >> -------- Original-Nachricht --------
> >> > Datum: Wed, 15 Jul 2009 14:22:03 +0200
> >> > Von: "Kai Behncke" <Kai-Behncke at gmx.de>
> >> > An: Vladislav Shikhov <vladshikhov at gmail.com>,
> >> pgrouting-users at lists.postlbs.org
> >> > Betreff: Re: [pgrouting-users] osm2pgrouting import problem
> >>
> >> > Hi Vladislay, Hi Stephen,
> >> >
> >> > thank you for your patient help.
> >> >
> >> > Well, I nearly got it.
> >> >
> >> > The following steps:
> >> >
> >> > >
> >> > > 1. svn checkout -r 334
> >> > >
> http://pgrouting.postlbs.org/svn/pgrouting/tools/osm2pgrouting/trunk
> >> > > osm2pgrouting
> >> > > 2. copy someway a patch from this email into osm2pgrouting just
> >> created
> >> > > 3. cd into osm2pgrouting
> >> > > 4. patch -p0 -i db.patch
> >> > > 5. make
> >> >
> >> > .....work well.
> >> >
> >> > I have created a database with pg_routing-functions (so far it has the
> >> > tables spatial_ref_sys and geometry_columns), but when
> >> > I start:
> >> >
> >> > ./osm2pgrouting -file your-OSM-XML-File.osm -conf mapconfig.xml
> -dbname
> >> > routing -user postgres
> >> >
> >> > I get many error-messages like:
> >> >
> >> >
> >> > Reference nd=57017125 has no corresponding Node Entry (Maybe Node
> entry
> >> > after Reference?)
> >> > ERROR: ?relation "nodes" does not exist
> >> > STATEMENT: ?SELECT id,lon,lat FROM nodes WHERE id ='57017123';
> >> > SELECT id,lon,lat FROM nodes WHERE id ='57017123'; ERROR: ?relation
> >> > "nodes" does not exist
> >> >
> >> > Reference nd=57017123 has no corresponding Node Entry (Maybe Node
> entry
> >> > after Reference?)
> >> > ERROR: ?relation "nodes" does not exist
> >> > STATEMENT: ?SELECT id,lon,lat FROM nodes WHERE id ='57017127';
> >> > LOG: ?unexpected EOF on client connection
> >> >
> >> > .........
> >> > ..........
> >> >
> >> > Do I need a special table-structure in the db to start the patch
> >> > succesfully?
> >> >
> >> > Thank you again, Kai
> >> >
> >> >
> >> > --
> >> > Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox
> 3
> >> -
> >> > sicherer, schneller und einfacher!
> http://portal.gmx.net/de/go/atbrowser
> >> > _______________________________________________
> >> > Pgrouting-users mailing list
> >> > Pgrouting-users at lists.postlbs.org
> >> > http://lists.postlbs.org/mailman/listinfo/pgrouting-users
> >>
> >> --
> >> Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
> >> f?r nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
> >> _______________________________________________
> >> Pgrouting-users mailing list
> >> Pgrouting-users at lists.postlbs.org
> >> http://lists.postlbs.org/mailman/listinfo/pgrouting-users
> >
> > --
> > Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
> > f?r nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
> > -------------- next part --------------
> > A non-text attachment was scrubbed...
> > Name: question_patch_osm2pgrouting.png
> > Type: image/png
> > Size: 163393 bytes
> > Desc: not available
> > Url :
> http://lists.postlbs.org/pipermail/pgrouting-users/attachments/20090715/13774bec/attachment.png
> >
> > ------------------------------
> >
> > _______________________________________________
> > Pgrouting-users mailing list
> > Pgrouting-users at lists.postlbs.org
> > http://lists.postlbs.org/mailman/listinfo/pgrouting-users
> >
> >
> > End of Pgrouting-users Digest, Vol 11, Issue 11
> > ***********************************************
> >
>
>
>
> --
> Jaak Laineste
> www.nutiteq.com
> Skype: jaakl3000
> Mobile: +372 509 2586
>
>
>
> ------------------------------
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.postlbs.org
> http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>
>
> End of Pgrouting-users Digest, Vol 12, Issue 11
> ***********************************************
>

-- 
Jaak Laineste
www.nutiteq.com
Skype: jaakl3000
Mobile: +372 509 2586
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20090831/67ae59c8/attachment.html