[pgrouting-users] osm2pgrouting import problem

[Kai Behncke]

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.osgeo.org/pipermail/pgrouting-users/attachments/20090715/13774bec/question_patch_osm2pgrouting.png