stop_id	stop_name	direction	stop_desc	stop_lat	stop_lon	zone_id	location_type	parent_station
7642	SW 5th & Washington	S	Southbound stop in Portland (Stop ID 7642)	45.520270	-122.676855	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	SW 5th & Jefferson	04:51:57	04:51:57	W.550	467	9226214	1	0	68	0	0	57128
4	4	Fessenden	SW 5th & Jefferson	05:22:41	05:22:41	W.550	469	9226215	1	0	68	0	0	57128
2	2	Division	Gresham TC	05:29:48	05:29:48	W.550	201	9225591	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	05:53:41	05:53:41	W.550	470	9226216	1	0	68	0	0	57128
2	2	Division	Gresham TC	05:59:48	05:59:48	W.550	236	9225592	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	06:24:26	06:24:26	W.550	401	9226217	1	0	68	0	0	57128
2	2	Division	Gresham TC	06:27:48	06:27:48	W.550	238	9225593	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	06:36:48	06:36:48	W.550	7241	9239810	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	06:39:26	06:39:26	W.550	473	9226218	1	0	68	0	0	57128
2	2	Division	Gresham TC	06:42:48	06:42:48	W.550	203	9225594	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	06:55:26	06:55:26	W.550	402	9226219	1	0	68	0	0	57128
2	2	Division	Gresham TC	06:57:48	06:57:48	W.550	240	9225595	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	07:07:29	07:07:29	W.550	9909	9239811	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	07:10:26	07:10:26	W.550	467	9226220	1	0	68	0	0	57128
2	2	Division	Gresham TC	07:11:48	07:11:48	W.550	252	9225596	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	07:23:29	07:23:29	W.550	9913	9239812	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	07:25:26	07:25:26	W.550	414	9226221	1	0	68	0	0	57128
2	2	Division	Gresham TC	07:26:48	07:26:48	W.550	242	9225597	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	07:36:26	07:36:26	W.550	468	9226222	1	0	68	0	0	57128
2	2	Division	Gresham TC	07:36:48	07:36:48	W.550	243	9225598	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	07:38:29	07:38:29	W.550	9915	9239813	0	0	3	0	0	2828
2	2	Division	Gresham TC	07:46:48	07:46:48	W.550	258	9225599	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	07:47:26	07:47:26	W.550	404	9226223	1	0	68	0	0	57128
2	2	Division	Gresham TC	07:56:48	07:56:48	W.550	204	9225600	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	07:57:26	07:57:26	W.550	416	9226224	1	0	68	0	0	57128
2	2	Division	Gresham TC	08:06:48	08:06:48	W.550	201	9225601	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	08:07:26	08:07:26	W.550	469	9226225	1	0	68	0	0	57128
2	2	Division	Gresham TC	08:16:48	08:16:48	W.550	264	9225602	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	08:17:26	08:17:26	W.550	410	9226226	1	0	68	0	0	57128
2	2	Division	Gresham TC	08:26:48	08:26:48	W.550	245	9225603	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	08:27:26	08:27:26	W.550	470	9226227	1	0	68	0	0	57128
2	2	Division	Gresham TC	08:38:29	08:38:29	W.550	234	9225604	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	08:39:26	08:39:26	W.550	471	9226228	1	0	68	0	0	57128
4	4	Fessenden	SW 5th & Jefferson	08:53:26	08:53:26	W.550	472	9226229	1	0	68	0	0	57128
2	2	Division	Gresham TC	08:53:29	08:53:29	W.550	235	9225605	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	09:08:26	09:08:26	W.550	401	9226230	1	0	68	0	0	57128
2	2	Division	Gresham TC	09:08:29	09:08:29	W.550	236	9225606	0	0	4	0	0	2828
2	2	Division	Gresham TC	09:22:29	09:22:29	W.550	237	9225607	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	09:23:26	09:23:26	W.550	473	9226231	1	0	68	0	0	57128
2	2	Division	Gresham TC	09:37:29	09:37:29	W.550	238	9225608	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	09:38:26	09:38:26	W.550	402	9226232	1	0	68	0	0	57128
2	2	Division	Gresham TC	09:52:29	09:52:29	W.550	203	9225609	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	09:53:26	09:53:26	W.550	467	9226233	1	0	68	0	0	57128
2	2	Division	Gresham TC	10:07:29	10:07:29	W.550	240	9225610	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	10:08:26	10:08:26	W.550	403	9226234	1	0	68	0	0	57128
2	2	Division	Gresham TC	10:22:29	10:22:29	W.550	241	9225611	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	10:23:26	10:23:26	W.550	468	9226235	1	0	68	0	0	57128
2	2	Division	Gresham TC	10:37:29	10:37:29	W.550	242	9225612	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	10:39:26	10:39:26	W.550	404	9226236	1	0	68	0	0	57128
2	2	Division	Gresham TC	10:52:29	10:52:29	W.550	243	9225613	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	10:54:26	10:54:26	W.550	469	9226237	1	0	68	0	0	57128
2	2	Division	Gresham TC	11:07:29	11:07:29	W.550	204	9225614	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	11:09:26	11:09:26	W.550	470	9226238	1	0	68	0	0	57128
2	2	Division	Gresham TC	11:22:29	11:22:29	W.550	201	9225615	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	11:24:26	11:24:26	W.550	471	9226239	1	0	68	0	0	57128
2	2	Division	Gresham TC	11:37:29	11:37:29	W.550	245	9225616	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	11:39:26	11:39:26	W.550	472	9226240	1	0	68	0	0	57128
2	2	Division	Gresham TC	11:52:29	11:52:29	W.550	234	9225617	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	11:54:26	11:54:26	W.550	401	9226241	1	0	68	0	0	57128
2	2	Division	Gresham TC	12:07:29	12:07:29	W.550	235	9225618	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	12:09:26	12:09:26	W.550	473	9226242	1	0	68	0	0	57128
2	2	Division	Gresham TC	12:22:29	12:22:29	W.550	236	9225619	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	12:24:26	12:24:26	W.550	402	9226243	1	0	68	0	0	57128
2	2	Division	Gresham TC	12:36:29	12:36:29	W.550	237	9225620	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	12:39:26	12:39:26	W.550	467	9226244	1	0	68	0	0	57128
2	2	Division	Gresham TC	12:51:29	12:51:29	W.550	238	9225621	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	12:54:26	12:54:26	W.550	403	9226245	1	0	68	0	0	57128
2	2	Division	Gresham TC	13:06:29	13:06:29	W.550	203	9225622	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	13:09:26	13:09:26	W.550	468	9226246	1	0	68	0	0	57128
2	2	Division	Gresham TC	13:21:29	13:21:29	W.550	240	9225623	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	13:24:26	13:24:26	W.550	404	9226247	1	0	68	0	0	57128
2	2	Division	Gresham TC	13:36:29	13:36:29	W.550	241	9225624	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	13:39:26	13:39:26	W.550	469	9226248	1	0	68	0	0	57128
2	2	Division	Gresham TC	13:51:29	13:51:29	W.550	242	9225625	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	13:54:26	13:54:26	W.550	470	9226249	1	0	68	0	0	57128
2	2	Division	Gresham TC	14:05:29	14:05:29	W.550	243	9225626	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	14:09:26	14:09:26	W.550	471	9226250	1	0	68	0	0	57128
2	2	Division	Gresham TC	14:20:29	14:20:29	W.550	204	9225627	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	14:23:11	14:23:11	W.550	472	9226251	1	0	68	0	0	57128
2	2	Division	Gresham TC	14:29:29	14:29:29	W.550	201	9225628	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	14:33:11	14:33:11	W.550	407	9226252	1	0	68	0	0	57128
2	2	Division	Gresham TC	14:39:27	14:39:27	W.550	251	9225629	0	0	4	0	0	2779
4	4	Fessenden	SW 5th & Jefferson	14:43:11	14:43:11	W.550	401	9226253	1	0	68	0	0	57128
2	2	Division	Gresham TC	14:49:29	14:49:29	W.550	245	9225630	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	14:53:11	14:53:11	W.550	473	9226254	1	0	68	0	0	57128
2	2	Division	Gresham TC	14:59:29	14:59:29	W.550	234	9225631	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	15:01:29	15:01:29	W.550	9902	9239814	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	15:08:11	15:08:11	W.550	409	9226255	1	0	68	0	0	57128
2	2	Division	Gresham TC	15:09:29	15:09:29	W.550	235	9225632	0	0	4	0	0	2828
2	2	Division	Gresham TC	15:18:27	15:18:27	W.550	253	9225633	0	0	4	0	0	2779
4	4	Fessenden	SW 5th & Jefferson	15:23:11	15:23:11	W.550	402	9226256	1	0	68	0	0	57128
2	2	Division	Gresham TC	15:28:29	15:28:29	W.550	236	9225634	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	15:32:29	15:32:29	W.550	9906	9239815	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	15:33:11	15:33:11	W.550	467	9226257	1	0	68	0	0	57128
2	2	Division	Gresham TC	15:38:29	15:38:29	W.550	247	9225635	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	15:43:55	15:43:55	W.550	403	9226258	1	0	68	0	0	57128
2	2	Division	Gresham TC	15:47:27	15:47:27	W.550	202	9225636	0	0	4	0	0	2779
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	15:48:29	15:48:29	W.550	9908	9239816	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	15:53:55	15:53:55	W.550	411	9226259	1	0	68	0	0	57128
2	2	Division	Gresham TC	15:57:29	15:57:29	W.550	237	9225637	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	16:02:27	16:02:27	W.550	9912	9239817	0	0	3	0	0	2779
4	4	Fessenden	SW 5th & Jefferson	16:03:55	16:03:55	W.550	468	9226260	1	0	68	0	0	57128
2	2	Division	Gresham TC	16:07:29	16:07:29	W.550	249	9225638	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	16:13:55	16:13:55	W.550	404	9226261	1	0	68	0	0	57128
2	2	Division	Gresham TC	16:17:29	16:17:29	W.550	238	9225639	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	16:18:27	16:18:27	W.550	9914	9239818	0	0	3	0	0	2779
4	4	Fessenden	SW 5th & Jefferson	16:23:55	16:23:55	W.550	405	9226262	1	0	68	0	0	57128
2	2	Division	Gresham TC	16:27:29	16:27:29	W.550	203	9225640	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	16:33:55	16:33:55	W.550	469	9226263	1	0	68	0	0	57128
2	2	Division	Gresham TC	16:35:08	16:35:08	W.550	257	9225641	0	0	4	0	0	2779
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	16:39:08	16:39:08	W.550	9916	9239819	0	0	3	0	0	2779
2	2	Division	Gresham TC	16:41:08	16:41:08	W.550	259	9225642	0	0	4	0	0	2779
2	2	Division	Gresham TC	16:47:10	16:47:10	W.550	240	9225643	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	16:48:55	16:48:55	W.550	470	9226264	1	0	68	0	0	57128
2	2	Division	Gresham TC	16:53:10	16:53:10	W.550	241	9225644	0	0	4	0	0	2828
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	16:54:10	16:54:10	W.550	9901	9239820	0	0	3	0	0	2828
2	2	Division	Gresham TC	16:57:11	16:57:11	W.550	251	9225645	0	0	4	0	0	2840
4	4	Fessenden	SW 5th & Jefferson	16:58:55	16:58:55	W.550	471	9226265	1	0	68	0	0	57128
2	2	Division	Gresham TC	17:01:08	17:01:08	W.550	261	9225646	0	0	4	0	0	2779
4	4	Fessenden	SW 5th & Jefferson	17:03:55	17:03:55	W.550	474	9226266	1	0	68	0	0	57128
2	2	Division	Gresham TC	17:06:10	17:06:10	W.550	255	9225647	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	17:08:55	17:08:55	W.550	406	9226267	1	0	68	0	0	57128
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	17:09:10	17:09:10	W.550	9903	9239821	0	0	3	0	0	2828
2	2	Division	Gresham TC	17:11:08	17:11:08	W.550	263	9225648	0	0	4	0	0	2779
4	4	Fessenden	SW 5th & Jefferson	17:13:55	17:13:55	W.550	472	9226268	1	0	68	0	0	57128
2	2	Division	Gresham TC	17:16:10	17:16:10	W.550	242	9225649	0	0	4	0	0	2828
30	30	Estacada	30E Estacada Express via Milwaukie via Webster Rd	17:16:48	17:16:48	W.550	3002	9231009	0	0	3	0	0	1138
4	4	Fessenden	SW 5th & Jefferson	17:23:55	17:23:55	W.550	407	9226269	1	0	68	0	0	57128
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	17:24:10	17:24:10	W.550	801	9239822	0	0	3	0	0	2828
2	2	Division	Gresham TC	17:28:08	17:28:08	W.550	265	9225650	0	0	4	0	0	2779
2	2	Division	Gresham TC	17:38:10	17:38:10	W.550	243	9225651	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	17:38:55	17:38:55	W.550	401	9226270	1	0	68	0	0	57128
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	17:42:10	17:42:10	W.550	9904	9239823	0	0	3	0	0	2828
2	2	Division	Gresham TC	17:48:10	17:48:10	W.550	204	9225652	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	17:48:55	17:48:55	W.550	473	9226271	1	0	68	0	0	57128
2	2	Division	Gresham TC	17:58:10	17:58:10	W.550	201	9225653	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	17:58:11	17:58:11	W.550	415	9226272	1	0	68	0	0	57128
99	99	Macadam/McLoughlin	Clackamas Community College via Sellwood	18:04:10	18:04:10	W.550	9910	9239824	0	0	3	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	18:08:11	18:08:11	W.550	409	9226273	1	0	68	0	0	57128
2	2	Division	Gresham TC	18:08:29	18:08:29	W.550	245	9225654	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	18:17:11	18:17:11	W.550	402	9226274	1	0	68	0	0	57128
2	2	Division	Gresham TC	18:19:29	18:19:29	W.550	234	9225655	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	18:27:11	18:27:11	W.550	467	9226275	1	0	68	0	0	57128
2	2	Division	Gresham TC	18:29:29	18:29:29	W.550	235	9225656	0	0	4	0	0	2828
2	2	Division	Gresham TC	18:40:29	18:40:29	W.550	253	9225657	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	18:42:11	18:42:11	W.550	403	9226276	1	0	68	0	0	57128
2	2	Division	Gresham TC	18:51:29	18:51:29	W.550	236	9225658	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	18:57:11	18:57:11	W.550	468	9226277	1	0	68	0	0	57128
2	2	Division	Gresham TC	19:06:29	19:06:29	W.550	202	9225659	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	19:12:11	19:12:11	W.550	404	9226278	1	0	68	0	0	57128
2	2	Division	Gresham TC	19:22:29	19:22:29	W.550	238	9225660	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	19:26:26	19:26:26	W.550	405	9226279	1	0	68	0	0	57128
2	2	Division	Gresham TC	19:38:29	19:38:29	W.550	203	9225661	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	19:40:26	19:40:26	W.550	470	9226280	1	0	68	0	0	57128
2	2	Division	Gresham TC	19:53:29	19:53:29	W.550	241	9225662	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	19:55:26	19:55:26	W.550	406	9226281	1	0	68	0	0	57128
2	2	Division	Gresham TC	20:08:29	20:08:29	W.550	255	9225663	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	20:10:26	20:10:26	W.550	407	9226282	1	0	68	0	0	57128
2	2	Division	Gresham TC	20:23:29	20:23:29	W.550	265	9225664	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	20:25:26	20:25:26	W.550	401	9226283	1	0	68	0	0	57128
2	2	Division	Gresham TC	20:38:29	20:38:29	W.550	243	9225665	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	20:40:26	20:40:26	W.550	473	9226284	1	0	68	0	0	57128
2	2	Division	Gresham TC	20:53:29	20:53:29	W.550	204	9225666	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	20:55:26	20:55:26	W.550	402	9226285	1	0	68	0	0	57128
2	2	Division	Gresham TC	21:08:29	21:08:29	W.550	245	9225667	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	21:15:26	21:15:26	W.550	467	9226286	1	0	68	0	0	57128
2	2	Division	Gresham TC	21:26:29	21:26:29	W.550	235	9225668	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	21:35:26	21:35:26	W.550	468	9226287	1	0	68	0	0	57128
2	2	Division	Gresham TC	21:46:29	21:46:29	W.550	253	9225669	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	21:54:26	21:54:26	W.550	404	9226288	1	0	68	0	0	57128
2	2	Division	Gresham TC	22:08:29	22:08:29	W.550	202	9225670	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	22:14:26	22:14:26	W.550	405	9226289	1	0	68	0	0	57128
2	2	Division	Gresham TC	22:28:48	22:28:48	W.550	238	9225671	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	22:34:26	22:34:26	W.550	406	9226290	1	0	68	0	0	57128
4	4	Fessenden	SW 5th & Jefferson	22:54:26	22:54:26	W.550	407	9226291	1	0	68	0	0	57128
2	2	Division	Gresham TC	22:58:48	22:58:48	W.550	255	9225672	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	23:23:26	23:23:26	W.550	473	9226292	1	0	68	0	0	57128
2	2	Division	Gresham TC	23:28:48	23:28:48	W.550	265	9225673	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	23:53:26	23:53:26	W.550	402	9226293	1	0	68	0	0	57128
2	2	Division	Gresham TC	23:59:48	23:59:48	W.550	245	9225674	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	24:21:41	24:21:41	W.550	468	9226294	1	0	68	0	0	57128
2	2	Division	Gresham TC	24:29:48	24:29:48	W.550	235	9225675	0	0	4	0	0	2828
4	4	Fessenden	SW 5th & Jefferson	25:27:41	25:27:41	W.550	407	9226295	1	0	68	0	0	57128
2	2	Division	Gresham TC	25:44:48	25:44:48	W.550	265	9225676	0	0	4	0	0	2828