A little background:
I've got PostGIS 2.0 and all the TIGER2010 data loaded for a U.S. State California.
I've got a table with points stored as data type geometry. I've learned enough to get the distance "as the crow flies" between two of the points and my samples are satisfactory when comparing them with Google Earth.
Now, I'd like to generate distance via a street/highway route. The requirements on the route are that it be the shortest. I only need shortest travel distance as a numeric value. No pretty maps.
-I've got every TIGER 2010 shape files loaded for California in PostGIS 2.0. I'm such a newbie it's not clear to me if this is sufficient data for calculating a route using PgRouting. Is it?
-If TIGER 2010 data is sufficient, does it need to be prepared somehow for a shortest_distance query?
If there's a useful how-to somewhere, then please send that along as a reply.
As a total newbie, I didn't know that the roads data is already loaded in the 'edges' table. Thanks to the commenter below for pointing it out!
Now, follow the instructions here: http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/
That should satisfy the 'lines layer' requirement Fabien is referring to.