Get line routes from static GTFS

trasy_linek.sql

SELECT
	route_short_name, stop_name, route_long_name, stop_sequence, route_stops.route_id, route_stops.stop_id  
FROM
	read_csv_auto("route_stops.txt") as route_stops
INNER JOIN
	read_csv_auto("routes.txt") as routes ON route_stops.route_id = routes.route_id
INNER JOIN
	read_csv_auto("stops.txt") as stops ON route_stops.stop_id = stops.stop_id
WHERE
	route_stops.direction_id = 0
ORDER BY
	route_short_name ASC,
	route_stops.stop_sequence ASC