stop_id	stop_name	direction	stop_desc	stop_lat	stop_lon	zone_id	location_type	parent_station
4817	N Richmond & Syracuse	N	Northbound stop in Portland (Stop ID 4817)	45.587592	-122.751862	B	0

Service IDs for Thu Jul 18, 2019: 7.550, A.550, D.550, H.550, p.550, Q.550, W.550

t.route_id	r.route_short_name	r.route_long_name	st.stop_headsign	st.arrival_time	st.departure_time	t.service_id	t.block_id	st.trip_id	t.direction_id	st.timepoint	st.stop_sequence	st.pickup_type	st.drop_off_type	st.shape_dist_traveled
4	4	Fessenden	Portland	04:05:06	04:05:06	W.550	467	9226214	1	0	2	0	0	1584
4	4	Fessenden	Portland	04:33:14	04:33:14	W.550	469	9226215	1	0	2	0	0	1584
4	4	Fessenden	Portland	05:03:14	05:03:14	W.550	470	9226216	1	0	2	0	0	1584
4	4	Fessenden	Portland	05:30:22	05:30:22	W.550	401	9226217	1	0	2	0	0	1584
4	4	Fessenden	Portland	05:45:22	05:45:22	W.550	473	9226218	1	0	2	0	0	1584
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	05:59:24	05:59:24	W.550	1103	9227605	0	0	2	0	0	1584
4	4	Fessenden	Portland	06:00:22	06:00:22	W.550	402	9226219	1	0	2	0	0	1584
4	4	Fessenden	Portland	06:15:22	06:15:22	W.550	467	9226220	1	0	2	0	0	1584
4	4	Fessenden	Portland	06:29:22	06:29:22	W.550	414	9226221	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	06:32:22	06:32:22	W.550	4471	9232154	1	0	85	0	0	86029
4	4	Fessenden	Portland	06:39:22	06:39:22	W.550	468	9226222	1	0	2	0	0	1584
4	4	Fessenden	Portland	06:49:22	06:49:22	W.550	404	9226223	1	0	2	0	0	1584
4	4	Fessenden	Portland	06:58:22	06:58:22	W.550	416	9226224	1	0	2	0	0	1584
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	06:58:24	06:58:24	W.550	1101	9227606	0	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	07:02:54	07:02:54	W.550	4472	9232155	1	0	85	0	0	86029
4	4	Fessenden	Portland	07:08:22	07:08:22	W.550	469	9226225	1	0	2	0	0	1584
4	4	Fessenden	Portland	07:18:22	07:18:22	W.550	410	9226226	1	0	2	0	0	1584
4	4	Fessenden	Portland	07:27:30	07:27:30	W.550	470	9226227	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	07:32:54	07:32:54	W.550	4411	9232156	1	0	85	0	0	86029
4	4	Fessenden	Portland	07:38:30	07:38:30	W.550	471	9226228	1	0	2	0	0	1584
4	4	Fessenden	Portland	07:52:30	07:52:30	W.550	472	9226229	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	07:56:54	07:56:54	W.550	4413	9232157	1	0	85	0	0	86029
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	07:59:24	07:59:24	W.550	1103	9227607	0	0	2	0	0	1584
4	4	Fessenden	Portland	08:07:30	08:07:30	W.550	401	9226230	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	08:18:54	08:18:54	W.550	4467	9232158	1	0	85	0	0	86029
4	4	Fessenden	Portland	08:22:30	08:22:30	W.550	473	9226231	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	08:35:55	08:35:55	W.550	4405	9232159	1	0	85	0	0	86029
4	4	Fessenden	Portland	08:37:30	08:37:30	W.550	402	9226232	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	08:51:54	08:51:54	W.550	4468	9232160	1	0	85	0	0	86029
4	4	Fessenden	Portland	08:52:30	08:52:30	W.550	467	9226233	1	0	2	0	0	1584
4	4	Fessenden	Portland	09:07:30	09:07:30	W.550	403	9226234	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	09:08:54	09:08:54	W.550	4469	9232162	1	0	85	0	0	86029
4	4	Fessenden	Portland	09:22:30	09:22:30	W.550	468	9226235	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	09:31:54	09:31:54	W.550	4470	9232164	1	0	85	0	0	86029
4	4	Fessenden	Portland	09:37:30	09:37:30	W.550	404	9226236	1	0	2	0	0	1584
4	4	Fessenden	Portland	09:52:30	09:52:30	W.550	469	9226237	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	10:00:54	10:00:54	W.550	4471	9232166	1	0	85	0	0	86029
4	4	Fessenden	Portland	10:07:30	10:07:30	W.550	470	9226238	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	10:21:54	10:21:54	W.550	4402	9232167	1	0	85	0	0	86029
4	4	Fessenden	Portland	10:22:30	10:22:30	W.550	471	9226239	1	0	2	0	0	1584
4	4	Fessenden	Portland	10:37:30	10:37:30	W.550	472	9226240	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	10:43:54	10:43:54	W.550	4472	9232168	1	0	85	0	0	86029
4	4	Fessenden	Portland	10:52:30	10:52:30	W.550	401	9226241	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	11:05:54	11:05:54	W.550	4401	9232169	1	0	85	0	0	86029
4	4	Fessenden	Portland	11:07:30	11:07:30	W.550	473	9226242	1	0	2	0	0	1584
4	4	Fessenden	Portland	11:22:30	11:22:30	W.550	402	9226243	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	11:27:54	11:27:54	W.550	4473	9232170	1	0	85	0	0	86029
4	4	Fessenden	Portland	11:37:30	11:37:30	W.550	467	9226244	1	0	2	0	0	1584
4	4	Fessenden	Portland	11:51:30	11:51:30	W.550	403	9226245	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	11:53:54	11:53:54	W.550	4467	9232171	1	0	85	0	0	86029
4	4	Fessenden	Portland	12:06:30	12:06:30	W.550	468	9226246	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	12:15:54	12:15:54	W.550	4468	9232172	1	0	85	0	0	86029
4	4	Fessenden	Portland	12:21:30	12:21:30	W.550	404	9226247	1	0	2	0	0	1584
4	4	Fessenden	Portland	12:36:30	12:36:30	W.550	469	9226248	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	12:41:54	12:41:54	W.550	4469	9232173	1	0	85	0	0	86029
4	4	Fessenden	Portland	12:51:30	12:51:30	W.550	470	9226249	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	13:03:54	13:03:54	W.550	4470	9232174	1	0	85	0	0	86029
4	4	Fessenden	Portland	13:06:30	13:06:30	W.550	471	9226250	1	0	2	0	0	1584
4	4	Fessenden	Portland	13:19:30	13:19:30	W.550	472	9226251	1	0	2	0	0	1584
4	4	Fessenden	Portland	13:29:30	13:29:30	W.550	407	9226252	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	13:29:54	13:29:54	W.550	4471	9232175	1	0	85	0	0	86029
4	4	Fessenden	Portland	13:39:30	13:39:30	W.550	401	9226253	1	0	2	0	0	1584
4	4	Fessenden	Portland	13:49:30	13:49:30	W.550	473	9226254	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	13:51:54	13:51:54	W.550	4402	9232176	1	0	85	0	0	86029
4	4	Fessenden	Portland	14:04:30	14:04:30	W.550	409	9226255	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	14:18:26	14:18:26	W.550	4472	9232177	1	0	85	0	0	86029
4	4	Fessenden	Portland	14:19:30	14:19:30	W.550	402	9226256	1	0	2	0	0	1584
4	4	Fessenden	Portland	14:29:30	14:29:30	W.550	467	9226257	1	0	2	0	0	1584
4	4	Fessenden	Portland	14:39:30	14:39:30	W.550	403	9226258	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	14:41:58	14:41:58	W.550	4401	9232178	1	0	85	0	0	86029
4	4	Fessenden	Portland	14:49:30	14:49:30	W.550	411	9226259	1	0	2	0	0	1584
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	14:59:24	14:59:24	W.550	1102	9227608	0	0	2	0	0	1584
4	4	Fessenden	Portland	14:59:30	14:59:30	W.550	468	9226260	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	15:06:58	15:06:58	W.550	4473	9232179	1	0	85	0	0	86029
4	4	Fessenden	Portland	15:08:38	15:08:38	W.550	404	9226261	1	0	2	0	0	1584
4	4	Fessenden	Portland	15:18:38	15:18:38	W.550	405	9226262	1	0	2	0	0	1584
4	4	Fessenden	Portland	15:28:38	15:28:38	W.550	469	9226263	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	15:32:30	15:32:30	W.550	4467	9232180	1	0	85	0	0	86029
4	4	Fessenden	Portland	15:43:38	15:43:38	W.550	470	9226264	1	0	2	0	0	1584
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	15:50:32	15:50:32	W.550	1104	9227609	0	0	2	0	0	1584
4	4	Fessenden	Portland	15:53:38	15:53:38	W.550	471	9226265	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	15:57:03	15:57:03	W.550	4468	9232181	1	0	85	0	0	86029
4	4	Fessenden	Portland	15:58:38	15:58:38	W.550	474	9226266	1	0	2	0	0	1584
4	4	Fessenden	Portland	16:03:38	16:03:38	W.550	406	9226267	1	0	2	0	0	1584
4	4	Fessenden	Portland	16:08:38	16:08:38	W.550	472	9226268	1	0	2	0	0	1584
4	4	Fessenden	Portland	16:18:38	16:18:38	W.550	407	9226269	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	16:23:03	16:23:03	W.550	4469	9232182	1	0	85	0	0	86029
4	4	Fessenden	Portland	16:33:38	16:33:38	W.550	401	9226270	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	16:39:35	16:39:35	W.550	4404	9232183	1	0	85	0	0	86029
4	4	Fessenden	Portland	16:43:38	16:43:38	W.550	473	9226271	1	0	2	0	0	1584
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	16:44:32	16:44:32	W.550	1102	9227610	0	0	2	0	0	1584
4	4	Fessenden	Portland	16:54:38	16:54:38	W.550	415	9226272	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	16:58:35	16:58:35	W.550	4470	9232184	1	0	85	0	0	86029
4	4	Fessenden	Portland	17:04:38	17:04:38	W.550	409	9226273	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	17:14:35	17:14:35	W.550	4471	9232185	1	0	85	0	0	86029
4	4	Fessenden	Portland	17:14:38	17:14:38	W.550	402	9226274	1	0	2	0	0	1584
4	4	Fessenden	Portland	17:24:38	17:24:38	W.550	467	9226275	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	17:29:36	17:29:36	W.550	4410	9232186	1	0	85	0	0	86029
4	4	Fessenden	Portland	17:39:38	17:39:38	W.550	403	9226276	1	0	2	0	0	1584
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	17:41:24	17:41:24	W.550	1104	9227611	0	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	17:45:35	17:45:35	W.550	4402	9232187	1	0	85	0	0	86029
4	4	Fessenden	Portland	17:55:38	17:55:38	W.550	468	9226277	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	18:00:36	18:00:36	W.550	4406	9232188	1	0	85	0	0	86029
4	4	Fessenden	Portland	18:10:38	18:10:38	W.550	404	9226278	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	18:13:35	18:13:35	W.550	4472	9232189	1	0	85	0	0	86029
4	4	Fessenden	Portland	18:25:38	18:25:38	W.550	405	9226279	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	18:27:36	18:27:36	W.550	4408	9232190	1	0	85	0	0	86029
11	11	Rivergate/Marine Dr	Middlefield Rd, to Jubitz	18:35:16	18:35:16	W.550	1102	9227612	0	0	2	0	0	1584
4	4	Fessenden	Portland	18:41:38	18:41:38	W.550	470	9226280	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	18:42:58	18:42:58	W.550	4401	9232191	1	0	85	0	0	86029
44	44	Capitol Hwy/Mocks Crest	St Johns	18:55:59	18:55:59	W.550	4412	9232192	1	0	85	0	0	86029
4	4	Fessenden	Portland	18:56:38	18:56:38	W.550	406	9226281	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	19:11:27	19:11:27	W.550	4473	9232193	1	0	85	0	0	86029
4	4	Fessenden	Portland	19:12:30	19:12:30	W.550	407	9226282	1	0	2	0	0	1584
4	4	Fessenden	Portland	19:27:30	19:27:30	W.550	401	9226283	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	19:30:26	19:30:26	W.550	4467	9232194	1	0	85	0	0	86029
44	44	Capitol Hwy/Mocks Crest	St Johns	19:42:27	19:42:27	W.550	7513	9232195	1	0	85	0	0	86029
4	4	Fessenden	Portland	19:43:30	19:43:30	W.550	473	9226284	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	19:56:27	19:56:27	W.550	4468	9232196	1	0	85	0	0	86029
4	4	Fessenden	Portland	19:58:30	19:58:30	W.550	402	9226285	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	20:15:26	20:15:26	W.550	4404	9232197	1	0	85	0	0	86029
4	4	Fessenden	Portland	20:19:22	20:19:22	W.550	467	9226286	1	0	2	0	0	1584
4	4	Fessenden	Portland	20:39:22	20:39:22	W.550	468	9226287	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	20:44:26	20:44:26	W.550	4471	9232198	1	0	85	0	0	86029
4	4	Fessenden	Portland	21:00:22	21:00:22	W.550	404	9226288	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	21:15:27	21:15:27	W.550	4402	9232199	1	0	85	0	0	86029
4	4	Fessenden	Portland	21:20:22	21:20:22	W.550	405	9226289	1	0	2	0	0	1584
4	4	Fessenden	Portland	21:40:22	21:40:22	W.550	406	9226290	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	21:43:27	21:43:27	W.550	4472	9232200	1	0	85	0	0	86029
4	4	Fessenden	Portland	22:01:22	22:01:22	W.550	407	9226291	1	0	2	0	0	1584
44	44	Capitol Hwy/Mocks Crest	St Johns	22:12:55	22:12:55	W.550	4401	9232201	1	0	85	0	0	86029
4	4	Fessenden	Portland	22:31:22	22:31:22	W.550	473	9226292	1	0	2	0	0	1584
4	4	Fessenden	Portland	23:01:22	23:01:22	W.550	402	9226293	1	0	2	0	0	1584
4	4	Fessenden	Portland	23:31:22	23:31:22	W.550	468	9226294	1	0	2	0	0	1584
4	4	Fessenden	Portland	24:40:14	24:40:14	W.550	407	9226295	1	0	2	0	0	1584