Welcome to the geofictician wiki.

User:Luciano/Sandbox/CommunityLists and Transportes Tarrasenses/GTFS: Difference between pages

From Geofictician
< User:Luciano‎ | Sandbox(Difference between pages)
Jump to navigationJump to search
imported>Luciano
(Created page with "Below are some lists of communities I have generated using scripts. Quality of lists is thus driven by data-quality in the OGF map database. = List of Tables = Here is a l...")
 
imported>Luciano
(Created page with "= BEGIN GTFS DATA = <pre> agency.txt agency_id,agency_name,agency_url,agency_timezone DT.TT,"Transportes Tarrasenses",http://wiki.opengeofiction.net/wiki/index.php/User:Lucia...")
 
Line 1: Line 1:
Below are some lists of communities I have generated using scripts. Quality of lists is thus driven by data-quality in the OGF map database.  
= BEGIN GTFS DATA =
<pre>
agency.txt


= List of Tables =
agency_id,agency_name,agency_url,agency_timezone
DT.TT,"Transportes Tarrasenses",http://wiki.opengeofiction.net/wiki/index.php/User:Luciano/Sandbox/Work-in-Progress/Tárrases,Mahhal


Here is a listing of community listings I have made so far - see note at bottom of this page if you want me to work on adding your own country or territory.
calendar.txt


*{{Ardisphere}}
service_id,monday,tuesday,wednesday,thursday,friday,saturday,sunday,start_date,end_date
**[[Communities in Colonia Coreana (Ardisphere)]]
DF,0,0,0,0,0,0,1,20170801,20171231
**[[Communities in Colonia Galesa (Ardisphere)]]
DL,1,1,1,1,1,1,0,20170801,20171231
**[[Communities in Departamento Boreal (Ardisphere)]]
**[[Communities in Departamento de Montañas (Ardisphere)]]
**[[Communities in Departamento de Páramos (Ardisphere)]]
**[[Communities in Departamento del Centro (Ardisphere)]]
**[[Communities in Departamento del Sur (Ardisphere)]]
**[[Communities in Departamento Libertad (Ardisphere)]]
**[[Communities in Departamento Occidental (Ardisphere)]]
**[[Communities in Distrito Federal (Ardisphere)]]
*{{Drull}}
**[[User:Luciano/Sandbox/CommunityLists/Communities in Drull Free State|Communities in Drull Free State]]
*{{Gobrassanya}}
**[[User:Luciano/Sandbox/CommunityLists/Communities in Gobrassanya|Communities in Gobrassanya]]
*{{Mahhal}}
**[[User:Luciano/Sandbox/CommunityLists/Communities in Puh Kingdom|Communities in Puh Kingdom]]
*{{West Commonia}}
**[[West Commonia|Communities in West Commonia (pasted into the WC main article)]]
*<nowiki>{{</nowiki>'''''Add your country to this list (see below first!)'''''<nowiki>}}</nowiki>
**<nowiki>[[</nowiki>''put a wiki-link to a blank wiki-page where you want me to build your list HERE''<nowiki>]]</nowiki>


= Clarification (''updated'') =
calendar_dates.txt


I think I need to do a better job explaining how this works.
service_id,date,exception_type
DL,20170826,2
DF,20170826,1
DL,20170923,2
DF,20170923,1
DL,20171103,2
DF,20171103,1
DL,20171104,2
DF,20171104,1
DL,20171222,2
DF,20171222,1
DL,20171223,2
DF,20171223,1
DL,20171225,2
DF,20171225,1


This is not like the [[User:Luciano/Sandbox/Polygons|polygons project]] I have been working on. The polygons project pulls information from the relations for administrative areas. This project ignores the relations, and relies instead on the "label" nodes made for places: place=hamlet, place=village, place=town, place=city.  
frequencies.txt


In fact, I have another version that uses relations - this isn't hard to do. However, it's not useful given even in a well-developed country like the Ardisphere, fewer than 5% of communities have boundary relations. Most communities are just nodes - even for fairly important cities like Ciudad Trece Templos I still have not drawn boundary relations.
trip_id,start_time,end_time,headway_secs
G-02-DL01,04:30:00,06:30:00,1440
G-02-DL01,06:30:00,18:30:00,540
G-02-DL01,18:30:00,23:30:00,840
G-02-DL01,23:30:00,27:30:00,1440


That is why I decided to use nodes. Using nodes, even a fairly undeveloped country like West Commonia can be "cleaned up" a little bit and a community listing can be produced.
stop_times.txt


= How this works (''updated'') =
trip_id,arrival_time,departure_time,stop_id,stop_sequence
G-02-DL01,04:30:00,04:30:00,46378027,1
G-02-DL01,04:31:30,04:32:20,46407528,2
G-02-DL01,04:33:50,04:34:40,46407526,3
G-02-DL01,04:36:10,04:37:00,45610516,4
G-02-DL01,04:38:30,04:39:20,45608814,5
G-02-DL01,04:40:50,04:41:40,40581443,6
G-02-DL01,04:43:10,04:44:00,46378335,7
G-02-DL01,04:45:30,04:46:20,46387454,8
G-02-DL01,04:47:50,04:48:40,11597466,9
G-02-DL01,04:50:10,04:51:00,46387457,10
G-02-DL01,04:52:30,04:53:20,40572522,11
G-02-DL01,04:54:50,04:55:40,46381502,12
G-02-DL01,04:57:10,04:58:00,46378020,13
G-02-DL01,04:59:30,05:00:20,46378016,14
G-02-DL01,05:01:50,05:02:40,46378022,15
G-02-DL01,05:04:10,05:05:00,46378018,16
G-02-DL01,05:06:30,05:07:20,45324655,17
G-02-DL01,05:08:50,05:09:40,45324297,18
G-02-DL01,05:11:10,05:12:00,45324086,19
G-02-DL01,05:13:30,05:13:30,45324031,20
G-02-DL02,04:59:00,04:59:00,46378027,1
G-02-DL02,05:00:30,05:01:20,46407528,2
G-02-DL02,05:02:50,05:03:40,46407526,3
G-02-DL02,05:05:10,05:06:00,45610516,4
G-02-DL02,05:07:30,05:08:20,45608814,5
G-02-DL02,05:09:50,05:10:40,40581443,6
G-02-DL02,05:12:10,05:13:00,46378335,7
G-02-DL02,05:14:30,05:15:20,46387454,8
G-02-DL02,05:16:50,05:17:40,11597466,9
G-02-DL02,05:19:10,05:20:00,46387457,10
G-02-DL02,05:21:30,05:22:20,40572522,11
G-02-DL02,05:23:50,05:24:40,46381502,12
G-02-DL02,05:26:10,05:27:00,46378020,13
G-02-DL02,05:28:30,05:29:20,46378016,14
G-02-DL02,05:30:50,05:31:40,46378022,15
G-02-DL02,05:33:10,05:34:00,46378018,16
G-02-DL02,05:35:30,05:36:20,45324655,17
G-02-DL02,05:37:50,05:38:40,45324297,18
G-02-DL02,05:40:10,05:41:00,45324086,19
G-02-DL02,05:42:30,05:42:30,45324031,20
G-02-DL03,05:28:00,05:28:00,46378027,1
G-02-DL03,05:29:30,05:30:20,46407528,2
G-02-DL03,05:31:50,05:32:40,46407526,3
G-02-DL03,05:34:10,05:35:00,45610516,4
G-02-DL03,05:36:30,05:37:20,45608814,5
G-02-DL03,05:38:50,05:39:40,40581443,6
G-02-DL03,05:41:10,05:42:00,46378335,7
G-02-DL03,05:43:30,05:44:20,46387454,8
G-02-DL03,05:45:50,05:46:40,11597466,9
G-02-DL03,05:48:10,05:49:00,46387457,10
G-02-DL03,05:50:30,05:51:20,40572522,11
G-02-DL03,05:52:50,05:53:40,46381502,12
G-02-DL03,05:55:10,05:56:00,46378020,13
G-02-DL03,05:57:30,05:58:20,46378016,14
G-02-DL03,05:59:50,06:00:40,46378022,15
G-02-DL03,06:02:10,06:03:00,46378018,16
G-02-DL03,06:04:30,06:05:20,45324655,17
G-02-DL03,06:06:50,06:07:40,45324297,18
G-02-DL03,06:09:10,06:10:00,45324086,19
G-02-DL03,06:11:30,06:11:30,45324031,20
G-02-DL04,05:57:00,05:57:00,46378027,1
G-02-DL04,05:58:30,05:59:20,46407528,2
G-02-DL04,06:00:50,06:01:40,46407526,3
G-02-DL04,06:03:10,06:04:00,45610516,4
G-02-DL04,06:05:30,06:06:20,45608814,5
G-02-DL04,06:07:50,06:08:40,40581443,6
G-02-DL04,06:10:10,06:11:00,46378335,7
G-02-DL04,06:12:30,06:13:20,46387454,8
G-02-DL04,06:14:50,06:15:40,11597466,9
G-02-DL04,06:17:10,06:18:00,46387457,10
G-02-DL04,06:19:30,06:20:20,40572522,11
G-02-DL04,06:21:50,06:22:40,46381502,12
G-02-DL04,06:24:10,06:25:00,46378020,13
G-02-DL04,06:26:30,06:27:20,46378016,14
G-02-DL04,06:28:50,06:29:40,46378022,15
G-02-DL04,06:31:10,06:32:00,46378018,16
G-02-DL04,06:33:30,06:34:20,45324655,17
G-02-DL04,06:35:50,06:36:40,45324297,18
G-02-DL04,06:38:10,06:39:00,45324086,19
G-02-DL04,06:40:30,06:40:30,45324031,20
G-02-DL05,06:20:00,06:20:00,46378027,1
G-02-DL05,06:21:30,06:22:20,46407528,2
G-02-DL05,06:23:50,06:24:40,46407526,3
G-02-DL05,06:26:10,06:27:00,45610516,4
G-02-DL05,06:28:30,06:29:20,45608814,5
G-02-DL05,06:30:50,06:31:40,40581443,6
G-02-DL05,06:33:10,06:34:00,46378335,7
G-02-DL05,06:35:30,06:36:20,46387454,8
G-02-DL05,06:37:50,06:38:40,11597466,9
G-02-DL05,06:40:10,06:41:00,46387457,10
G-02-DL05,06:42:30,06:43:20,40572522,11
G-02-DL05,06:44:50,06:45:40,46381502,12
G-02-DL05,06:47:10,06:48:00,46378020,13
G-02-DL05,06:49:30,06:50:20,46378016,14
G-02-DL05,06:51:50,06:52:40,46378022,15
G-02-DL05,06:54:10,06:55:00,46378018,16
G-02-DL05,06:56:30,06:57:20,45324655,17
G-02-DL05,06:58:50,06:59:40,45324297,18
G-02-DL05,07:01:10,07:02:00,45324086,19
G-02-DL05,07:03:30,07:03:30,45324031,20
G-02-DL06,06:39:00,06:39:00,46378027,1
G-02-DL06,06:40:30,06:41:20,46407528,2
G-02-DL06,06:42:50,06:43:40,46407526,3
G-02-DL06,06:45:10,06:46:00,45610516,4
G-02-DL06,06:47:30,06:48:20,45608814,5
G-02-DL06,06:49:50,06:50:40,40581443,6
G-02-DL06,06:52:10,06:53:00,46378335,7
G-02-DL06,06:54:30,06:55:20,46387454,8
G-02-DL06,06:56:50,06:57:40,11597466,9
G-02-DL06,06:59:10,07:00:00,46387457,10
G-02-DL06,07:01:30,07:02:20,40572522,11
G-02-DL06,07:03:50,07:04:40,46381502,12
G-02-DL06,07:06:10,07:07:00,46378020,13
G-02-DL06,07:08:30,07:09:20,46378016,14
G-02-DL06,07:10:50,07:11:40,46378022,15
G-02-DL06,07:13:10,07:14:00,46378018,16
G-02-DL06,07:15:30,07:16:20,45324655,17
G-02-DL06,07:17:50,07:18:40,45324297,18
G-02-DL06,07:20:10,07:21:00,45324086,19
G-02-DL06,07:22:30,07:22:30,45324031,20
G-02-DL07,06:55:00,06:55:00,46378027,1
G-02-DL07,06:56:30,06:57:20,46407528,2
G-02-DL07,06:58:50,06:59:40,46407526,3
G-02-DL07,07:01:10,07:02:00,45610516,4
G-02-DL07,07:03:30,07:04:20,45608814,5
G-02-DL07,07:05:50,07:06:40,40581443,6
G-02-DL07,07:08:10,07:09:00,46378335,7
G-02-DL07,07:10:30,07:11:20,46387454,8
G-02-DL07,07:12:50,07:13:40,11597466,9
G-02-DL07,07:15:10,07:16:00,46387457,10
G-02-DL07,07:17:30,07:18:20,40572522,11
G-02-DL07,07:19:50,07:20:40,46381502,12
G-02-DL07,07:22:10,07:23:00,46378020,13
G-02-DL07,07:24:30,07:25:20,46378016,14
G-02-DL07,07:26:50,07:27:40,46378022,15
G-02-DL07,07:29:10,07:30:00,46378018,16
G-02-DL07,07:31:30,07:32:20,45324655,17
G-02-DL07,07:33:50,07:34:40,45324297,18
G-02-DL07,07:36:10,07:37:00,45324086,19
G-02-DL07,07:38:30,07:38:30,45324031,20
G-02-DL08,07:10:00,07:10:00,46378027,1
G-02-DL08,07:11:30,07:12:20,46407528,2
G-02-DL08,07:13:50,07:14:40,46407526,3
G-02-DL08,07:16:10,07:17:00,45610516,4
G-02-DL08,07:18:30,07:19:20,45608814,5
G-02-DL08,07:20:50,07:21:40,40581443,6
G-02-DL08,07:23:10,07:24:00,46378335,7
G-02-DL08,07:25:30,07:26:20,46387454,8
G-02-DL08,07:27:50,07:28:40,11597466,9
G-02-DL08,07:30:10,07:31:00,46387457,10
G-02-DL08,07:32:30,07:33:20,40572522,11
G-02-DL08,07:34:50,07:35:40,46381502,12
G-02-DL08,07:37:10,07:38:00,46378020,13
G-02-DL08,07:39:30,07:40:20,46378016,14
G-02-DL08,07:41:50,07:42:40,46378022,15
G-02-DL08,07:44:10,07:45:00,46378018,16
G-02-DL08,07:46:30,07:47:20,45324655,17
G-02-DL08,07:48:50,07:49:40,45324297,18
G-02-DL08,07:51:10,07:52:00,45324086,19
G-02-DL08,07:53:30,07:53:30,45324031,20
G-02-DL09,07:19:00,07:19:00,46378027,1
G-02-DL09,07:20:30,07:21:20,46407528,2
G-02-DL09,07:22:50,07:23:40,46407526,3
G-02-DL09,07:25:10,07:26:00,45610516,4
G-02-DL09,07:27:30,07:28:20,45608814,5
G-02-DL09,07:29:50,07:30:40,40581443,6
G-02-DL09,07:32:10,07:33:00,46378335,7
G-02-DL09,07:34:30,07:35:20,46387454,8
G-02-DL09,07:36:50,07:37:40,11597466,9
G-02-DL09,07:39:10,07:40:00,46387457,10
G-02-DL09,07:41:30,07:42:20,40572522,11
G-02-DL09,07:43:50,07:44:40,46381502,12
G-02-DL09,07:46:10,07:47:00,46378020,13
G-02-DL09,07:48:30,07:49:20,46378016,14
G-02-DL09,07:50:50,07:51:40,46378022,15
G-02-DL09,07:53:10,07:54:00,46378018,16
G-02-DL09,07:55:30,07:56:20,45324655,17
G-02-DL09,07:57:50,07:58:40,45324297,18
G-02-DL09,08:00:10,08:01:00,45324086,19
G-02-DL09,08:02:30,08:02:30,45324031,20
G-02-DL10,07:28:00,07:28:00,46378027,1
G-02-DL10,07:29:30,07:30:20,46407528,2
G-02-DL10,07:31:50,07:32:40,46407526,3
G-02-DL10,07:34:10,07:35:00,45610516,4
G-02-DL10,07:36:30,07:37:20,45608814,5
G-02-DL10,07:38:50,07:39:40,40581443,6
G-02-DL10,07:41:10,07:42:00,46378335,7
G-02-DL10,07:43:30,07:44:20,46387454,8
G-02-DL10,07:45:50,07:46:40,11597466,9
G-02-DL10,07:48:10,07:49:00,46387457,10
G-02-DL10,07:50:30,07:51:20,40572522,11
G-02-DL10,07:52:50,07:53:40,46381502,12
G-02-DL10,07:55:10,07:56:00,46378020,13
G-02-DL10,07:57:30,07:58:20,46378016,14
G-02-DL10,07:59:50,08:00:40,46378022,15
G-02-DL10,08:02:10,08:03:00,46378018,16
G-02-DL10,08:04:30,08:05:20,45324655,17
G-02-DL10,08:06:50,08:07:40,45324297,18
G-02-DL10,08:09:10,08:10:00,45324086,19
G-02-DL10,08:11:30,08:11:30,45324031,20
G-02-DL11,07:37:00,07:37:00,46378027,1
G-02-DL11,07:38:30,07:39:20,46407528,2
G-02-DL11,07:40:50,07:41:40,46407526,3
G-02-DL11,07:43:10,07:44:00,45610516,4
G-02-DL11,07:45:30,07:46:20,45608814,5
G-02-DL11,07:47:50,07:48:40,40581443,6
G-02-DL11,07:50:10,07:51:00,46378335,7
G-02-DL11,07:52:30,07:53:20,46387454,8
G-02-DL11,07:54:50,07:55:40,11597466,9
G-02-DL11,07:57:10,07:58:00,46387457,10
G-02-DL11,07:59:30,08:00:20,40572522,11
G-02-DL11,08:01:50,08:02:40,46381502,12
G-02-DL11,08:04:10,08:05:00,46378020,13
G-02-DL11,08:06:30,08:07:20,46378016,14
G-02-DL11,08:08:50,08:09:40,46378022,15
G-02-DL11,08:11:10,08:12:00,46378018,16
G-02-DL11,08:13:30,08:14:20,45324655,17
G-02-DL11,08:15:50,08:16:40,45324297,18
G-02-DL11,08:18:10,08:19:00,45324086,19
G-02-DL11,08:20:30,08:20:30,45324031,20


== Fix the tags on ''place'' nodes on your map ==
stops.txt


The first step is to "clean up" the tags for hamlets, villages, towns and cities in a given country. This includes adding or fixing tags such as
stop_id,stop_name
* ''place''
45324084,"Serpiente Ascendente (dir. Estoque)"
* ''admin_level''
46374407,"Politécnico (dir. Estoque)"
* ''is_in:country''
45324326,"Ixekkodew (dir. Estoque)"
* ''is_in:state''
46374406,"Parque McKay (dir. Estoque)"
* ''is_in:county''
11599057,"Gobierno (dir. Estoque)"
* ''ref''
46378023,"Mezquita (dir. Estoque)"
* ''population''
46378017,"Espada de Bronce (dir. Estoque)"
* ''ogf:text'' ... any kind of "note" you might want to attach
46378021,"Juegos - Parque Nuevo (dir. Estoque)"
* ''ogf:wiki_article'' ... this is if you have unicode characters in your location name and want to ensure there is a working link for the article in the table (see table for Ardisphere Depto. de Páramos Lagartópolis, which uses Farsi characters, for example)
46381503,"Ensalada (dir. Estoque)"
* ''ogf:label_for_relation'' ... this supports a MAP link back to the relation that the place node is in the "label" role for (see table for Ardisphere Depto. de Páramos Lagartópolis for example)
40572509,"Catedral (dir. Estoque)"
* ''etc.''
46387458,"Universidad (dir. Estoque)"
40573758,"Piratas (dir. Estoque)"
46387455,"Gautama Azulejos (dir. Estoque)"
46378358,"Aérodromo (dir. Estoque)"
46387456,"Transbordadores (dir. Estoque)"
46389414,"Cruceros (dir. Estoque)"
46389415,"Metropolitana (dir. Estoque)"
46407525,"Cerro de Humos (dir. Estoque)"
45610669,"Submarino (dir. Estoque)"
46378026,"Terminal del Estoque (Fin)"
46378027,"Terminal del Estoque (dir. Serpiente)"
46407528,"Submarino (dir. Serpiente)"
46407526,"Cerro de Humos (dir. Serpiente)"
45610516,"Metropolitana (dir. Serpiente)"
45608814,"Cruceros (dir. Serpiente)"
40581443,"Transbordadores (dir. Serpiente)"
46378335,"Aérodromo (dir. Serpiente)"
46387454,"Gautama Azulejos (dir. Serpiente)"
11597466,"Piratas (dir. Serpiente)"
46387457,"Universidad (dir. Serpiente)"
40572522,"Catedral (dir. Serpiente)"
46381502,"Ensalada (dir. Serpiente)"
46378020,"Juegos - Parque Nuevo (dir. Serpiente)"
46378016,"Espada de Bronce (dir. Serpiente)"
46378022,"Mezquita (dir. Serpiente)"
46378018,"Gobierno (dir. Serpiente)"
45324655,"Parque McKay (dir. Serpiente)"
45324297,"Ixekkodew (dir. Serpiente)"
45324086,"Politécnico (dir. Serpiente)"
45324031,"Serpiente Ascendente (Fin)"


Below, I show the contrast of "before" and "after" for Gautig, Gobrassanya. When I looked at Gobrassanya for this project, the ''place'' nodes had only ''name'' and ''place''. Here is a screenshot of the city of Gautig, Arcois, Gobrassanya, before I added the extra tags required:
routes.txt


=== BEFORE ===
route_id,route_short_name,route_long_name,route_desc,route_type
<br />''in JOSM''<br />
44135,G-01,"Línea Gris - dir. Estoque","Tren ligero desde Serpiente Ascendente hacia Terminal del Estoque",0
[[File:Luciano_Screenshot_JOSM_Gautig_Before.jpg|1000px]]
44261,G-02,"Línea Gris - dir. Serpiente","Tren ligero desde Terminal del Estoque hacia Serpiente Ascendente",0
<br />''in Potlatch''<br />
[[File:Luciano_Screenshot_Potlatch_Gautig_Before.jpg|1000px]]


=== AFTER ===
trips.txt
Here is a screenshot after I added the extra tags (I only added the absolute minimum required - I did not add population or extra notes, etc.):
<br />''in JOSM''<br />
[[File:Luciano_Screenshot_JOSM_Gautig_After.jpg|1000px]]
<br />''in Potlatch''<br />
[[File:Luciano_Screenshot_Potlatch_Gautig_After.jpg|1000px]]


route_id,service_id,trip_id,trip_headsign
44261,DL,G-02-DL01,"Serpiente"
44261,DL,G-02-DL02,"Serpiente"
44261,DL,G-02-DL03,"Serpiente"
44261,DL,G-02-DL04,"Serpiente"
44261,DL,G-02-DL05,"Serpiente"
44261,DL,G-02-DL06,"Serpiente"
44261,DL,G-02-DL07,"Serpiente"
44261,DL,G-02-DL08,"Serpiente"
44261,DL,G-02-DL09,"Serpiente"
44261,DL,G-02-DL10,"Serpiente"
44261,DL,G-02-DL11,"Serpiente"


I had to do this for ''all'' the nodes in Gobrassanya, in order to generate the list. But moving forward, into the future, it will be easier, since the new tags only need to be added as new community nodes are added.
</pre>
 
= END GTFS DATA =
Once the data is cleaned up and I have a .OSM with the cleaned data (saved locally or extracted from the .PBF OGF backup file), then I can run my script. It's very quick, even on my lousy Korean Jooyontech PC. A few seconds for hundreds of locations. Then there is an output text file: ''wikitable.txt''. I open the file, and cut-and-paste into a wiki edit window. Samples linked below. If the data is clean I can do it in less than 10 minutes.
 
= Tables-я-Us =
 
''If you want me to try to make a list for your country, then have a try at cleaning up your place nodes (for examples of how to do this, take a look at data for locations already completed above - West Commonia is a good example because it has low data density so it's easy to download and look at a part of the map).''
 
''Then, after you've cleaned up your data, add your country to my list above, with an "empty" page for me to fill, and when I get a chance, I will give it a try (there must be a delay, since I have to wait for a new, successful backup file that includes your fixed data).''

Latest revision as of 23:39, 1 May 2019

BEGIN GTFS DATA

agency.txt

agency_id,agency_name,agency_url,agency_timezone
DT.TT,"Transportes Tarrasenses",http://wiki.opengeofiction.net/wiki/index.php/User:Luciano/Sandbox/Work-in-Progress/Tárrases,Mahhal

calendar.txt

service_id,monday,tuesday,wednesday,thursday,friday,saturday,sunday,start_date,end_date
DF,0,0,0,0,0,0,1,20170801,20171231
DL,1,1,1,1,1,1,0,20170801,20171231

calendar_dates.txt

service_id,date,exception_type
DL,20170826,2
DF,20170826,1
DL,20170923,2
DF,20170923,1
DL,20171103,2
DF,20171103,1
DL,20171104,2
DF,20171104,1
DL,20171222,2
DF,20171222,1
DL,20171223,2
DF,20171223,1
DL,20171225,2
DF,20171225,1

frequencies.txt

trip_id,start_time,end_time,headway_secs
G-02-DL01,04:30:00,06:30:00,1440
G-02-DL01,06:30:00,18:30:00,540
G-02-DL01,18:30:00,23:30:00,840
G-02-DL01,23:30:00,27:30:00,1440

stop_times.txt

trip_id,arrival_time,departure_time,stop_id,stop_sequence
G-02-DL01,04:30:00,04:30:00,46378027,1
G-02-DL01,04:31:30,04:32:20,46407528,2
G-02-DL01,04:33:50,04:34:40,46407526,3
G-02-DL01,04:36:10,04:37:00,45610516,4
G-02-DL01,04:38:30,04:39:20,45608814,5
G-02-DL01,04:40:50,04:41:40,40581443,6
G-02-DL01,04:43:10,04:44:00,46378335,7
G-02-DL01,04:45:30,04:46:20,46387454,8
G-02-DL01,04:47:50,04:48:40,11597466,9
G-02-DL01,04:50:10,04:51:00,46387457,10
G-02-DL01,04:52:30,04:53:20,40572522,11
G-02-DL01,04:54:50,04:55:40,46381502,12
G-02-DL01,04:57:10,04:58:00,46378020,13
G-02-DL01,04:59:30,05:00:20,46378016,14
G-02-DL01,05:01:50,05:02:40,46378022,15
G-02-DL01,05:04:10,05:05:00,46378018,16
G-02-DL01,05:06:30,05:07:20,45324655,17
G-02-DL01,05:08:50,05:09:40,45324297,18
G-02-DL01,05:11:10,05:12:00,45324086,19
G-02-DL01,05:13:30,05:13:30,45324031,20
G-02-DL02,04:59:00,04:59:00,46378027,1
G-02-DL02,05:00:30,05:01:20,46407528,2
G-02-DL02,05:02:50,05:03:40,46407526,3
G-02-DL02,05:05:10,05:06:00,45610516,4
G-02-DL02,05:07:30,05:08:20,45608814,5
G-02-DL02,05:09:50,05:10:40,40581443,6
G-02-DL02,05:12:10,05:13:00,46378335,7
G-02-DL02,05:14:30,05:15:20,46387454,8
G-02-DL02,05:16:50,05:17:40,11597466,9
G-02-DL02,05:19:10,05:20:00,46387457,10
G-02-DL02,05:21:30,05:22:20,40572522,11
G-02-DL02,05:23:50,05:24:40,46381502,12
G-02-DL02,05:26:10,05:27:00,46378020,13
G-02-DL02,05:28:30,05:29:20,46378016,14
G-02-DL02,05:30:50,05:31:40,46378022,15
G-02-DL02,05:33:10,05:34:00,46378018,16
G-02-DL02,05:35:30,05:36:20,45324655,17
G-02-DL02,05:37:50,05:38:40,45324297,18
G-02-DL02,05:40:10,05:41:00,45324086,19
G-02-DL02,05:42:30,05:42:30,45324031,20
G-02-DL03,05:28:00,05:28:00,46378027,1
G-02-DL03,05:29:30,05:30:20,46407528,2
G-02-DL03,05:31:50,05:32:40,46407526,3
G-02-DL03,05:34:10,05:35:00,45610516,4
G-02-DL03,05:36:30,05:37:20,45608814,5
G-02-DL03,05:38:50,05:39:40,40581443,6
G-02-DL03,05:41:10,05:42:00,46378335,7
G-02-DL03,05:43:30,05:44:20,46387454,8
G-02-DL03,05:45:50,05:46:40,11597466,9
G-02-DL03,05:48:10,05:49:00,46387457,10
G-02-DL03,05:50:30,05:51:20,40572522,11
G-02-DL03,05:52:50,05:53:40,46381502,12
G-02-DL03,05:55:10,05:56:00,46378020,13
G-02-DL03,05:57:30,05:58:20,46378016,14
G-02-DL03,05:59:50,06:00:40,46378022,15
G-02-DL03,06:02:10,06:03:00,46378018,16
G-02-DL03,06:04:30,06:05:20,45324655,17
G-02-DL03,06:06:50,06:07:40,45324297,18
G-02-DL03,06:09:10,06:10:00,45324086,19
G-02-DL03,06:11:30,06:11:30,45324031,20
G-02-DL04,05:57:00,05:57:00,46378027,1
G-02-DL04,05:58:30,05:59:20,46407528,2
G-02-DL04,06:00:50,06:01:40,46407526,3
G-02-DL04,06:03:10,06:04:00,45610516,4
G-02-DL04,06:05:30,06:06:20,45608814,5
G-02-DL04,06:07:50,06:08:40,40581443,6
G-02-DL04,06:10:10,06:11:00,46378335,7
G-02-DL04,06:12:30,06:13:20,46387454,8
G-02-DL04,06:14:50,06:15:40,11597466,9
G-02-DL04,06:17:10,06:18:00,46387457,10
G-02-DL04,06:19:30,06:20:20,40572522,11
G-02-DL04,06:21:50,06:22:40,46381502,12
G-02-DL04,06:24:10,06:25:00,46378020,13
G-02-DL04,06:26:30,06:27:20,46378016,14
G-02-DL04,06:28:50,06:29:40,46378022,15
G-02-DL04,06:31:10,06:32:00,46378018,16
G-02-DL04,06:33:30,06:34:20,45324655,17
G-02-DL04,06:35:50,06:36:40,45324297,18
G-02-DL04,06:38:10,06:39:00,45324086,19
G-02-DL04,06:40:30,06:40:30,45324031,20
G-02-DL05,06:20:00,06:20:00,46378027,1
G-02-DL05,06:21:30,06:22:20,46407528,2
G-02-DL05,06:23:50,06:24:40,46407526,3
G-02-DL05,06:26:10,06:27:00,45610516,4
G-02-DL05,06:28:30,06:29:20,45608814,5
G-02-DL05,06:30:50,06:31:40,40581443,6
G-02-DL05,06:33:10,06:34:00,46378335,7
G-02-DL05,06:35:30,06:36:20,46387454,8
G-02-DL05,06:37:50,06:38:40,11597466,9
G-02-DL05,06:40:10,06:41:00,46387457,10
G-02-DL05,06:42:30,06:43:20,40572522,11
G-02-DL05,06:44:50,06:45:40,46381502,12
G-02-DL05,06:47:10,06:48:00,46378020,13
G-02-DL05,06:49:30,06:50:20,46378016,14
G-02-DL05,06:51:50,06:52:40,46378022,15
G-02-DL05,06:54:10,06:55:00,46378018,16
G-02-DL05,06:56:30,06:57:20,45324655,17
G-02-DL05,06:58:50,06:59:40,45324297,18
G-02-DL05,07:01:10,07:02:00,45324086,19
G-02-DL05,07:03:30,07:03:30,45324031,20
G-02-DL06,06:39:00,06:39:00,46378027,1
G-02-DL06,06:40:30,06:41:20,46407528,2
G-02-DL06,06:42:50,06:43:40,46407526,3
G-02-DL06,06:45:10,06:46:00,45610516,4
G-02-DL06,06:47:30,06:48:20,45608814,5
G-02-DL06,06:49:50,06:50:40,40581443,6
G-02-DL06,06:52:10,06:53:00,46378335,7
G-02-DL06,06:54:30,06:55:20,46387454,8
G-02-DL06,06:56:50,06:57:40,11597466,9
G-02-DL06,06:59:10,07:00:00,46387457,10
G-02-DL06,07:01:30,07:02:20,40572522,11
G-02-DL06,07:03:50,07:04:40,46381502,12
G-02-DL06,07:06:10,07:07:00,46378020,13
G-02-DL06,07:08:30,07:09:20,46378016,14
G-02-DL06,07:10:50,07:11:40,46378022,15
G-02-DL06,07:13:10,07:14:00,46378018,16
G-02-DL06,07:15:30,07:16:20,45324655,17
G-02-DL06,07:17:50,07:18:40,45324297,18
G-02-DL06,07:20:10,07:21:00,45324086,19
G-02-DL06,07:22:30,07:22:30,45324031,20
G-02-DL07,06:55:00,06:55:00,46378027,1
G-02-DL07,06:56:30,06:57:20,46407528,2
G-02-DL07,06:58:50,06:59:40,46407526,3
G-02-DL07,07:01:10,07:02:00,45610516,4
G-02-DL07,07:03:30,07:04:20,45608814,5
G-02-DL07,07:05:50,07:06:40,40581443,6
G-02-DL07,07:08:10,07:09:00,46378335,7
G-02-DL07,07:10:30,07:11:20,46387454,8
G-02-DL07,07:12:50,07:13:40,11597466,9
G-02-DL07,07:15:10,07:16:00,46387457,10
G-02-DL07,07:17:30,07:18:20,40572522,11
G-02-DL07,07:19:50,07:20:40,46381502,12
G-02-DL07,07:22:10,07:23:00,46378020,13
G-02-DL07,07:24:30,07:25:20,46378016,14
G-02-DL07,07:26:50,07:27:40,46378022,15
G-02-DL07,07:29:10,07:30:00,46378018,16
G-02-DL07,07:31:30,07:32:20,45324655,17
G-02-DL07,07:33:50,07:34:40,45324297,18
G-02-DL07,07:36:10,07:37:00,45324086,19
G-02-DL07,07:38:30,07:38:30,45324031,20
G-02-DL08,07:10:00,07:10:00,46378027,1
G-02-DL08,07:11:30,07:12:20,46407528,2
G-02-DL08,07:13:50,07:14:40,46407526,3
G-02-DL08,07:16:10,07:17:00,45610516,4
G-02-DL08,07:18:30,07:19:20,45608814,5
G-02-DL08,07:20:50,07:21:40,40581443,6
G-02-DL08,07:23:10,07:24:00,46378335,7
G-02-DL08,07:25:30,07:26:20,46387454,8
G-02-DL08,07:27:50,07:28:40,11597466,9
G-02-DL08,07:30:10,07:31:00,46387457,10
G-02-DL08,07:32:30,07:33:20,40572522,11
G-02-DL08,07:34:50,07:35:40,46381502,12
G-02-DL08,07:37:10,07:38:00,46378020,13
G-02-DL08,07:39:30,07:40:20,46378016,14
G-02-DL08,07:41:50,07:42:40,46378022,15
G-02-DL08,07:44:10,07:45:00,46378018,16
G-02-DL08,07:46:30,07:47:20,45324655,17
G-02-DL08,07:48:50,07:49:40,45324297,18
G-02-DL08,07:51:10,07:52:00,45324086,19
G-02-DL08,07:53:30,07:53:30,45324031,20
G-02-DL09,07:19:00,07:19:00,46378027,1
G-02-DL09,07:20:30,07:21:20,46407528,2
G-02-DL09,07:22:50,07:23:40,46407526,3
G-02-DL09,07:25:10,07:26:00,45610516,4
G-02-DL09,07:27:30,07:28:20,45608814,5
G-02-DL09,07:29:50,07:30:40,40581443,6
G-02-DL09,07:32:10,07:33:00,46378335,7
G-02-DL09,07:34:30,07:35:20,46387454,8
G-02-DL09,07:36:50,07:37:40,11597466,9
G-02-DL09,07:39:10,07:40:00,46387457,10
G-02-DL09,07:41:30,07:42:20,40572522,11
G-02-DL09,07:43:50,07:44:40,46381502,12
G-02-DL09,07:46:10,07:47:00,46378020,13
G-02-DL09,07:48:30,07:49:20,46378016,14
G-02-DL09,07:50:50,07:51:40,46378022,15
G-02-DL09,07:53:10,07:54:00,46378018,16
G-02-DL09,07:55:30,07:56:20,45324655,17
G-02-DL09,07:57:50,07:58:40,45324297,18
G-02-DL09,08:00:10,08:01:00,45324086,19
G-02-DL09,08:02:30,08:02:30,45324031,20
G-02-DL10,07:28:00,07:28:00,46378027,1
G-02-DL10,07:29:30,07:30:20,46407528,2
G-02-DL10,07:31:50,07:32:40,46407526,3
G-02-DL10,07:34:10,07:35:00,45610516,4
G-02-DL10,07:36:30,07:37:20,45608814,5
G-02-DL10,07:38:50,07:39:40,40581443,6
G-02-DL10,07:41:10,07:42:00,46378335,7
G-02-DL10,07:43:30,07:44:20,46387454,8
G-02-DL10,07:45:50,07:46:40,11597466,9
G-02-DL10,07:48:10,07:49:00,46387457,10
G-02-DL10,07:50:30,07:51:20,40572522,11
G-02-DL10,07:52:50,07:53:40,46381502,12
G-02-DL10,07:55:10,07:56:00,46378020,13
G-02-DL10,07:57:30,07:58:20,46378016,14
G-02-DL10,07:59:50,08:00:40,46378022,15
G-02-DL10,08:02:10,08:03:00,46378018,16
G-02-DL10,08:04:30,08:05:20,45324655,17
G-02-DL10,08:06:50,08:07:40,45324297,18
G-02-DL10,08:09:10,08:10:00,45324086,19
G-02-DL10,08:11:30,08:11:30,45324031,20
G-02-DL11,07:37:00,07:37:00,46378027,1
G-02-DL11,07:38:30,07:39:20,46407528,2
G-02-DL11,07:40:50,07:41:40,46407526,3
G-02-DL11,07:43:10,07:44:00,45610516,4
G-02-DL11,07:45:30,07:46:20,45608814,5
G-02-DL11,07:47:50,07:48:40,40581443,6
G-02-DL11,07:50:10,07:51:00,46378335,7
G-02-DL11,07:52:30,07:53:20,46387454,8
G-02-DL11,07:54:50,07:55:40,11597466,9
G-02-DL11,07:57:10,07:58:00,46387457,10
G-02-DL11,07:59:30,08:00:20,40572522,11
G-02-DL11,08:01:50,08:02:40,46381502,12
G-02-DL11,08:04:10,08:05:00,46378020,13
G-02-DL11,08:06:30,08:07:20,46378016,14
G-02-DL11,08:08:50,08:09:40,46378022,15
G-02-DL11,08:11:10,08:12:00,46378018,16
G-02-DL11,08:13:30,08:14:20,45324655,17
G-02-DL11,08:15:50,08:16:40,45324297,18
G-02-DL11,08:18:10,08:19:00,45324086,19
G-02-DL11,08:20:30,08:20:30,45324031,20

stops.txt

stop_id,stop_name
45324084,"Serpiente Ascendente (dir. Estoque)"
46374407,"Politécnico (dir. Estoque)"
45324326,"Ixekkodew (dir. Estoque)"
46374406,"Parque McKay (dir. Estoque)"
11599057,"Gobierno (dir. Estoque)"
46378023,"Mezquita (dir. Estoque)"
46378017,"Espada de Bronce (dir. Estoque)"
46378021,"Juegos - Parque Nuevo (dir. Estoque)"
46381503,"Ensalada (dir. Estoque)"
40572509,"Catedral (dir. Estoque)"
46387458,"Universidad (dir. Estoque)"
40573758,"Piratas (dir. Estoque)"
46387455,"Gautama Azulejos (dir. Estoque)"
46378358,"Aérodromo (dir. Estoque)"
46387456,"Transbordadores (dir. Estoque)"
46389414,"Cruceros (dir. Estoque)"
46389415,"Metropolitana (dir. Estoque)"
46407525,"Cerro de Humos (dir. Estoque)"
45610669,"Submarino (dir. Estoque)"
46378026,"Terminal del Estoque (Fin)"
46378027,"Terminal del Estoque (dir. Serpiente)"
46407528,"Submarino (dir. Serpiente)"
46407526,"Cerro de Humos (dir. Serpiente)"
45610516,"Metropolitana (dir. Serpiente)"
45608814,"Cruceros (dir. Serpiente)"
40581443,"Transbordadores (dir. Serpiente)"
46378335,"Aérodromo (dir. Serpiente)"
46387454,"Gautama Azulejos (dir. Serpiente)"
11597466,"Piratas (dir. Serpiente)"
46387457,"Universidad (dir. Serpiente)"
40572522,"Catedral (dir. Serpiente)"
46381502,"Ensalada (dir. Serpiente)"
46378020,"Juegos - Parque Nuevo (dir. Serpiente)"
46378016,"Espada de Bronce (dir. Serpiente)"
46378022,"Mezquita (dir. Serpiente)"
46378018,"Gobierno (dir. Serpiente)"
45324655,"Parque McKay (dir. Serpiente)"
45324297,"Ixekkodew (dir. Serpiente)"
45324086,"Politécnico (dir. Serpiente)"
45324031,"Serpiente Ascendente (Fin)"

routes.txt

route_id,route_short_name,route_long_name,route_desc,route_type
44135,G-01,"Línea Gris - dir. Estoque","Tren ligero desde Serpiente Ascendente hacia Terminal del Estoque",0
44261,G-02,"Línea Gris - dir. Serpiente","Tren ligero desde Terminal del Estoque hacia Serpiente Ascendente",0

trips.txt

route_id,service_id,trip_id,trip_headsign
44261,DL,G-02-DL01,"Serpiente"
44261,DL,G-02-DL02,"Serpiente"
44261,DL,G-02-DL03,"Serpiente"
44261,DL,G-02-DL04,"Serpiente"
44261,DL,G-02-DL05,"Serpiente"
44261,DL,G-02-DL06,"Serpiente"
44261,DL,G-02-DL07,"Serpiente"
44261,DL,G-02-DL08,"Serpiente"
44261,DL,G-02-DL09,"Serpiente"
44261,DL,G-02-DL10,"Serpiente"
44261,DL,G-02-DL11,"Serpiente"

END GTFS DATA