[pgrouting-users] osm2pgrouting import problem

[Kai Behncke]

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