Problems with route narrative

57 views
Skip to first unread message

Filipe Valeriano

unread,
Nov 7, 2012, 5:47:48 AM11/7/12
to graph...@googlegroups.com
Hello,

I'm running Ubuntu 12.04 LTS on a virtual box virtual machine.
I've followed the instructions on http://graphserver.github.com/graphserver/ up to the point of the Route Narrative quere it says:

Get a route narrative

http://YOUR_DOMAIN_NAME/path?origin="osm-92011649"&dest="sta-3803"&currtime=1260839444

or

http://YOUR_DOMAIN_NAME/path_raw?origin="osm-92011649"&dest="sta-3803"&currtime=1260839444

My problem is that the first command doesn't work hadding out the following output:

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/servable-2009c-py2.7.egg/servable.py", line 107, in myapp
      rr = xstr( pfunc(self,**args) )
        File "/usr/local/lib/python2.7/dist-packages/graphserver-1.0.0-py2.7.egg/graphserver/ext/routeserver/routeserver.py", line 146, in path
            narrative = list(postprocess_path(vertices, edges, self.vertex_events, self.edge_events))
              File "/usr/local/lib/python2.7/dist-packages/graphserver-1.0.0-py2.7.egg/graphserver/ext/routeserver/routeserver.py", line 59, in postprocess_path
                  event = handler( vertex1, edge2, vertex2, context=context )
                    File "/usr/local/lib/python2.7/dist-packages/graphserver-1.0.0-py2.7.egg/graphserver/ext/routeserver/events.py", line 38, in __call__
                        route_desc = "-".join([str(x) for x in list( self.gtfsdb.execute( "SELECT routes.route_short_name, routes.route_long_name FROM routes, trips WHERE routes.route_id=trips.route_id AND trip_id=?", (trip_id,) ) )[0]])
                          File "/usr/local/lib/python2.7/dist-packages/graphserver-1.0.0-py2.7.egg/graphserver/ext/gtfs/gtfsdb.py", line 366, in execute
                              c.execute( query, args )
                              OperationalError: no such table: routes


The second command returns something that I'm having trouble to understand completely. I reckon it has a list of vertices you have to traverse in order to reach from the starting to the terminal node but I would like it very much if some one could elaborate on that. I was hoping to get more understanding data from the first command since the second is named "raw".

Thanks in advance,
Filipe Valeriano

Timothy Wu

unread,
Nov 27, 2012, 9:11:06 PM11/27/12
to graph...@googlegroups.com
The route table is a SQLite3 table from pre-processing of GTFS data. So you're missing the table. Have you encountered any error during gs_gtfsdb_compile (where it mistakenly says gs_gtfsdb_build on the home page)?

Filipe Valeriano於 2012年11月7日星期三UTC+8下午6時47分48秒寫道:
Reply all
Reply to author
Forward
0 new messages