I converted GTFS data to MySQL database using OpenTransitTools .
I am just starting out with GTFS and would like to help with some basic SQL queries like:
- Given the current time, list the positions of all vehicles on a specific route. I'm not sure if it is possible to estimate the lat / long length for a point between two stops given the route and its shape? It may be more complicated or not required.
- List all stop locations (lat / long) along a specific route.
- List all transmission locations with parameters (lat / long) along a specific route.
It would also be great to get simpler SQL query examples or cookbooks with basic complex query examples.
Thank!
source
share