Hello, i am new to Postgis and pgRouting and i am trying to route over some data, but it doesnt work for me.
I installed a routing database with following commands as described in the pgrouting online tutorial (http://pgrouting.postlbs.org/wiki/Workshop-CreateRoutingDatabase). The data, which i want to use for routing, I got from the Openstreetmap projekt. I wrote me a program, which parse the xml file and write the data in a database. My Table with the name "subways" was created with the following command: CREATE TABLE subways (ID integer , startNode integer REFERENCES nodes(ID), endNode integer REFERENCES nodes(ID), cost double precision, name char(40), x1 double precision, y1 double precision, x2 double precision,y2 double precision, PRIMARY KEY(ID, startNode, endNode)); And the table looks like that: id= way id name = name of the street startnode, endnode are the IDs of the nodes x1,y1 are the coordinates of the startnode x2,y2 are the coordinates of the endnodenode cost = length of the way id | startnode | endnode | cost | name | x1 | y1 | x2 | y2 -------+-----------+-----------+----------------------+------------------------------------------+-----------+------------+-----------+------------ 0 | 140530 | 140555 | 8.5403091715829 | | 8.3889675 | 53.0587826 | 8.28445 | 53.1030248 2 | 206374638 | 26870008 | 0.320998562351643 | | 8.2145964 | 53.1430959 | 8.2168197 | 53.1405356 3 | 201754820 | 92909800 | 0.172230180241359 | Industriestraße | 8.1939216 | 53.1498095 | 8.1965042 | 53.1497966 5 | 26869963 | 165748872 | 0.0268226987132517 | Heiligengeistwall | 8.2087014 | 53.1412273 | 8.208876 | 53.1414446 6 | 165748872 | 26869964 | 0.0208274380181027 | Heiligengeistwall | 8.208876 | 53.1414446 | 8.2090004 | 53.1416164 (In another Table named nodes, i have every Point-ID with coordinates) If I try now the routing function A-Star..... SELECT * FROM shortest_path_astar('SELECT id, startnode as source, endnode as target, cost, x1, y1, x2, y2 from subways', 31567898, 96012788, false, false); ... I get following error code: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Succeeded. I hope you can help me, my system is: Gentoo Linux 64 Bit postgresql 8.0.15 postgis 1.3.1 pgrouting 1.02 Best regards, Daniel
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
