[pgrouting-users] osm2pgrouting import problem

Thu Aug 27 10:10:30 EDT 2009

Hello,
  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