[pgrouting-users] osm2pgrouting import problem

[Kai Behncke]

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