-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathtestingdb.sql
232 lines (209 loc) · 123 KB
/
testingdb.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
-- This script builds a testing database by creating tables and inserting
-- the content to test against into them.
--
-- Before running this script you'll need to create your testing database
-- (CREATE DATABASE portal_testing; as a user with permissions to do so.)
-- and make sure it's a postgis database. (CREATE EXTENSION postgis; in
-- the newly created database.)
--
-- NOTE: This script does not create any of our changes in the database,
-- so you'll also need to make sure that migrations.sql is run, and
-- that it is run again if the migrations.sql file changes!
--
-- Run this script with something like:
-- psql portal_testing < testingdb.sql
-- psql portal_testing < migrations.sql
--
-- This script does *NOT* drop database or clear existing data, so the very
-- worst that could happen should you run it on the wrong database is inserting
-- junk data. This is very intentional. If you need to reset yoru testing
-- database completely use "DROP TABLE" commands manually.
--
-- Name: highways; Type: TABLE; Schema: portal; Tablespace:
--
CREATE EXTENSION postgis;
CREATE TABLE highways (
highwayid smallint PRIMARY KEY,
direction character(6) NOT NULL,
highwaylength double precision,
highwayname character(20),
startmp real,
endmp real,
bound text
);
--
-- Data for Name: highways; Type: TABLE DATA; Schema: portal;
--
INSERT INTO highways (highwayid, direction, highwaylength, highwayname, startmp, endmp, bound) VALUES (9, 'NORTH ', 6.94000000000000039, 'OR 217 ', 0.25999999, 7.19999981, 'NB');
INSERT INTO highways (highwayid, direction, highwaylength, highwayname, startmp, endmp, bound) VALUES (10, 'SOUTH ', 10.7799999999999994, 'OR 217 ', NULL, NULL, 'SB');
--
-- Name: stations; Type: TABLE; Schema: portal; Tablespace:
--
CREATE TABLE stations (
stationid smallint PRIMARY KEY,
localjurisdiction smallint,
controljurisdiction smallint,
highwayid smallint,
enabledflag smallint,
milepost real,
milelog real,
milenumber real,
locationtext text,
length real,
upstream smallint,
downstream smallint,
stationclass smallint,
segment_odot smallint,
numberlanes smallint,
gisname text,
smoothingconstant real,
bridginglimit smallint,
length_mid real,
segment smallint,
downstream_mile real,
upstream_mile real,
agencyid text,
opposite_stationid smallint,
segment_raw public.geometry,
segment_50k public.geometry,
segment_100k public.geometry,
segment_250k public.geometry,
segment_500k public.geometry,
segment_1000k public.geometry,
point public.geometry
);
--
-- Data for Name: stations; Type: TABLE DATA; Schema: portal;
--
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5037, 300, 300, 10, 1, 7, 7, 7, 'ORE 217 WB to SB', 0, 5036, 5038, 5, 0, 1, NULL, 0.5, 3, 0, 7, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1064, 300, 300, 9, 1, 1.34000003, 1.34000003, 1.34000003, 'TV Hwy NB', 0.419999987, 3155, 1063, 1, 0, 2, '-122.78933:45.48095:-122.78922:45.49406', 0.5, 3, NULL, NULL, NULL, NULL, '9', NULL, '0102000020110F000007000000C364AAD854126AC1989999298ABE554163EE5A2256126AC10019737370BE554177BE9FA257126AC198900F8256BE5541081B9E7458126AC1B8627FB947BE55412675020C5C126AC1F05A42DA14BE5541623255BA62126AC140575B75ABBD554102BC05FC62126AC1B88D061CA7BD5541', '0102000020110F0000070000002AA913C04B126AC10088F45388BE55419A99990B4D126AC180C0CA796EBE5541F46C568D4E126AC1408B6C6F54BE554175029A624F126AC1E826316C45BE55419A779CFC52126AC1E0A59B6812BE5541E8FBA9A759126AC1E0240639A9BD554130992AE859126AC1B025E4F3A4BD5541', '0102000020110F000007000000B09465FA3D126AC1D0CCCC8C85BE55417CF2B0483F126AC150DA1B7C6BBE554155C1A8CC40126AC1D856EC4B51BE5541F775E0A641126AC1F897DDEF41BE55413EE8D94445126AC1582041B50EBE55416A4DF3EA4B126AC1881F63D6A5BD5541C286A7294C126AC11851DAAFA1BD5541', '0102000020110F000007000000C64B37912C126AC1C0CAA10982BE5541B8AF03E32D126AC1E04603B467BE5541A835CD692F126AC1E04603544DBE5541F016484A30126AC1C086A7873DBE5541EF3845ED33126AC1204A7B070ABE5541BE9F1A8D3A126AC10893A98EA1BD55414C3789C93A126AC118FBCB8E9DBD5541', '0102000020110F000007000000FFB27B1A05126AC1E0E00B137ABE55417EFB3A7406126AC1A01A2F215FBE5541B072680108126AC118B7D15444BE5541BEC117F008126AC12085EB8933BE554121B0729E0C126AC128A9136CFFBD55412AA9133013126AC1285C8FDA97BD5541D0B3596713126AC1F84A593294BD5541', NULL, '0101000020110F0000540F264360126AC15DA87D5AD2BD5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5063, 300, 300, 9, 1, 0.660000026, 0.660000026, 0.660000026, 'Walker Rd NB', 0, 5064, 0, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5064, 300, 300, 9, 1, 1.34000003, 1.34000003, 1.34000003, 'TV Hwy NB', 0, 5065, 5063, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5065, 300, 300, 9, 1, 2.16000009, 2.16000009, 2.16000009, 'Allen Blvd NB', 0, 5066, 5064, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5066, 300, 300, 9, 1, 2.68000007, 2.68000007, 2.68000007, 'Denney Rd NB', 0, 5067, 5065, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5067, 300, 300, 9, 1, 3.8499999, 3.8499999, 3.8499999, 'Scholls Fy NB', 0, 5068, 5066, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5068, 300, 300, 9, 1, 4.6500001, 4.6500001, 4.6500001, 'Greenburg NB', 0, 5069, 5067, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5069, 300, 300, 9, 1, 5.8499999, 5.8499999, 5.8499999, '99W WB to NB', 0, 5070, 5068, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5070, 300, 300, 9, 1, 5.9000001, 5.9000001, 5.9000001, '99W EB to NB', 0, 5071, 5069, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5071, 300, 300, 9, 1, 6.61000013, 6.61000013, 6.61000013, '72nd Ave NB to NB', 0, 0, 5070, 5, 0, 2, NULL, 0.5, 3, 0, 8, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5072, 300, 300, 10, 1, 6.76999998, 6.76999998, 6.76999998, '72nd SB', 0, 5073, 0, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5073, 300, 300, 10, 1, 5.94999981, 5.94999981, 5.94999981, '99W EB to SB', 0, 5074, 5072, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5074, 300, 300, 10, 1, 5.11000013, 5.11000013, 5.11000013, 'Greenburg SB', 0, 5075, 5073, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5075, 300, 300, 10, 1, 4.3499999, 4.3499999, 4.3499999, 'Scholls Fy SB', 0, 5076, 5074, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5076, 300, 300, 10, 1, 3.5, 3.5, 3.5, 'Hall Blvd SB', 0, 5077, 5075, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5077, 300, 300, 10, 1, 3.11999989, 3.11999989, 3.11999989, 'Denney Rd SB', 0, 5078, 5076, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5078, 300, 300, 10, 1, 2.54999995, 2.54999995, 2.54999995, 'Allen Blvd SB', 0, 5079, 5077, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5079, 300, 300, 10, 1, 1.91999996, 1.91999996, 1.91999996, 'B-H Hwy SB', 0, 5080, 5078, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5080, 300, 300, 10, 1, 0.75999999, 0.75999999, 0.75999999, 'Walker Rd SB', 0, 5111, 5079, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5106, 300, 300, 10, 1, 7.1500001, 1, 1, 'Kruse Way SB', 0, 5072, 0, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5111, 300, 300, 10, 1, 0.449999988, 0.449999988, 0.449999988, 'Wilshire to ORE 217 SB', 0.600000024, 0, 5080, 5, 0, 2, NULL, 0.5, 3, 0.600000024, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (5118, 300, 300, 10, 1, 0.100000001, 0.100000001, 0.100000001, 'Barnes SB', 0, 0, 0, 5, 0, 2, NULL, 0.5, 3, 0, 9, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1074, 300, 300, 10, 1, 5.11000013, 5.11000013, 5.11000013, 'Greenburg SB', 0.800000012, 1075, 1073, 1, 0, 2, '-122.7828:45.4463:-122.76935:45.43901', 0.5, 3, NULL, NULL, NULL, NULL, '19', NULL, '0102000020110F00000C0000005CFE4300C9116AC1A0CDAA4B7FB65541168C4ACCBB116AC168226C606DB65541AE69DE9795116AC1F8EDEBC839B65541C7BAB83194116AC1805149E537B655410AF9A0F96D116AC188855AC304B655418E75716769116AC1B88D0688FEB55541394547844C116AC1F0F44AF5D6B55541D88173AA33116AC1986E12F3B4B5554186C9541127116AC1903A0161A4B555413480B71C1E116AC1585BB16798B555416EA3012A14116AC130992AA889B55541CC7F489D0B116AC1E8FBA9797CB55541', '0102000020110F00000C000000C7BAB80BCF116AC100F7755C6DB6554174B515D5C1116AC108B5A66D5BB655414872F99D9B116AC17836ABD227B655413EE8D9329A116AC1603255E825B6554188F4DBFF73116AC1B0FA5CCDF2B555419F3C2C7A6F116AC1E05817A3ECB5554101DE029952116AC1E8C03913C5B555417E8CB9A939116AC1F02FBBF3A2B55541529621042D116AC1D03B4E5192B555416B2BF64F24116AC1A0F831AE86B55541BEC117A81A116AC108B5A65D78B55541DA8AFD2F12116AC170C5FE4E6BB55541', '0102000020110F00000C0000003EE8D936D3116AC1A86054FE60B6554165AA60FEC5116AC170F90F0D4FB655411E166AC59F116AC17814AE6F1BB65541AC8BDB569E116AC13880B78019B65541F8E4612778116AC1B8B88D6AE6B55541CE1951AA73116AC100780B4CE0B5554128A089CA56116AC1A08026BEB8B55541D88173CC3D116AC1900F7A8A96B55541EE5A421E31116AC1A89BC4DC85B55541022B879628116AC108CE19757AB5554114D044221F116AC1982A18716CB5554141F163B816116AC140F163785FB55541', '0102000020110F00000C000000529621B2DF116AC1D89AE6F53BB655410C242874D2116AC118AE47FD29B655412E6EA335AC116AC15839B458F6B55541A913D0BCAA116AC14082E25BF4B55541643BDF9784116AC130211F54C1B555419A779C3480116AC1885AD358BBB55541B437F85863116AC160A1D6D093B5554106A3922E4A116AC110C7BA6071B555412E90A0663D116AC15820419160B55541D9CEF76335116AC1B89690DB55B55541A4703D8A2C116AC1806ABCBC48B55541B37BF24A24116AC1C832C4053CB55541', '0102000020110F00000C000000A679C795ED116AC120B9FCBF12B65541E9B7AF51E0116AC158EC2FBF00B65541FF21FD0CBA116AC198779C12CDB55541C898BB88B8116AC1B0D85F06CBB5554193A9826F92116AC1E861A10E98B55541FE65F7288E116AC19087853A92B55541FBCBEE5171116AC178711BB96AB55541105839F657116AC18048BF0548B555415227A0114B116AC1E895B21037B55541DFE00BA343116AC108560E212DB555415EDC46753B116AC1A0923A0121B55541D26F5F6533116AC16844699314B55541', NULL, '0101000020110F00007499049A6E116AC10056EF9905B65541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1118, 300, 300, 10, 1, 0.0799999982, 0.0799999982, 0.0799999982, 'Barnes SB', 0.170000002, 0, 3154, 1, 0, 2, '-122.77936:45.50776:-122.78249:45.50552', 0.5, 3, NULL, NULL, NULL, NULL, '11', NULL, '0102000020110F000008000000D42B659BA2116AC130E6AEC552C0554110E9B7FFA3116AC12875022A4EC05541FC87F469A5116AC11083C07A49C055418C6CE7B1A6116AC16809F93C45C05541705F07ACA7116AC1A89BC40042C0554152962180AB116AC150E3A55335C055414CC80745B6116AC1D088D20E12C055412063EE9CBB116AC1C832C43D01C05541', '0102000020110F000008000000E86A2BD8AB116AC1F0EBC0015EC0554124287E3CAD116AC198900F6659C05541363CBDA6AE116AC11083C0B654C05541A223B9EEAF116AC1885AD37850C05541AC8BDBE8B0116AC12818953C4DC055416ABC74B9B4116AC1480C029B40C05541F853E36DBF116AC1B09DEF8B1DC05541900F7AB8C4116AC15839B4E40CC05541', '0102000020110F000008000000D8F0F436B2116AC178711BC165C055415EDC469BB3116AC1B072682561C0554194658805B5116AC198900F765CC05541BADA8A4DB6116AC198D4093858C0554132E6AE47B7116AC11061C3FB54C05541F697DD15BB116AC1A080266248C0554145D8F0BEC5116AC15852277825C05541AC1C5A00CB116AC1608FC2ED14C05541', '0102000020110F000008000000C2F5284AC5116AC1F897DDF37CC05541DA3D79AEC6116AC15852275878C055415CB1BF18C8116AC1104FAFA873C05541F4FDD460C9116AC1B0D85F6A6FC055412497FF5ACA116AC1482EFF2D6CC055416A6FF021CE116AC1F09E3CAC5FC05541265305A9D8116AC1F07C3F313DC0554145D8F0CEDD116AC1C84B37FD2CC05541', '0102000020110F00000800000066666684DA116AC1E0B584C496C05541A167B3E8DB116AC1F085C92892C05541923A0153DD116AC130772D798DC05541C4D32B9BDE116AC150158C3A89C05541F6285C95DF116AC128ED0DFE85C0554112143F54E3116AC11873D79679C05541B6627FB5ED116AC1205A649757C05541F4FDD4BCF2116AC1480378C347C05541', NULL, '0101000020110F000096690C44AE116AC17B4D39452CC05541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (3155, 300, 300, 9, 1, 1.5, 1.5, 1.5, '217-NB @ TV Hwy', 0.409999996, 1065, 1064, 1, 0, 2, NULL, 1, 3, NULL, NULL, NULL, NULL, '52', NULL, '0102000020110F00000A00000002BC05FC62126AC1B88D061CA7BD554111363CAF64126AC1A0B4374C8ABD55413255300E65126AC1302AA90384BD554175029AFC65126AC120EBE23A74BD55413480B7CE68126AC1683BDF4347BD554100917ECD6B126AC1585227BC13BD5541F697DDF76D126AC1F09E3C40F0BC55416F8104816E126AC1688863A9E3BC55417E8CB96F6F126AC148C807C1CDBC5541D8F0F48A6F126AC12085EB91C6BC5541', '0102000020110F00000A00000030992AE859126AC1B025E4F3A4BD55411E166A9B5B126AC1682BF62388BD5541AED85FFA5B126AC1B02E6EDB81BD554116D9CEE95C126AC128F6970172BD554110E9B7BB5F126AC15005A30E45BD554106F016BA62126AC1C810C78E11BD55412C6519E064126AC1F8A9F15AEEBC554176E09C6565126AC1F8DBD719E2BC554118B7D14E66126AC1186A4DB3CCBC55419CC4206866126AC1206C7806C6BC5541', '0102000020110F00000A000000C286A7294C126AC11851DAAFA1BD5541D8F0F4DC4D126AC1F02FBBDF84BD55418D28ED3B4E126AC1E8C039977EBD55411EA7E82C4F126AC1B89690A36EBD55414A9D80FE51126AC1383CBDB641BD5541A62C43FC54126AC1809ECD420EBD5541E8FBA91B57126AC1E0361A7CEBBC55410C71AC9B57126AC1885AD3BCDFBC554196438B7C58126AC18816D91ACBBC55418E06F09258126AC1A84E4033C5BC5541', '0102000020110F00000A0000004C3789C93A126AC118FBCB8E9DBD55411EA7E87C3C126AC1F83A70BE80BD5541F853E3DB3C126AC190A0F8757ABD55413C2CD4CE3D126AC1589FAB616ABD5541B88D06A040126AC1085F987C3DBD55414A0C029D43126AC110E9B7170ABD5541E0BE0EB445126AC10022FDDAE7BC554108CE192D46126AC1400AD7BFDCBC5541B22E6E0347126AC1D0915C16C9BC55412FDD241647126AC150DA1B28C4BC5541', '0102000020110F00000A000000D0B3596713126AC1F84A593294BD55416519E21A15126AC1208E756177BD5541F853E37915126AC170F90F1971BD55413867447116126AC1C810C7BA60BD554104C58F4119126AC160DC46E733BD5541F085C93C1C126AC198438BA400BD55414260E5401E126AC1B8FC87A0DFBC55412FDD24AA1E126AC1688863F9D5BC554197FF90681F126AC130BB2783C4BC5541D578E9721F126AC170D712CAC1BC5541', NULL, '0101000020110F00009D8C869165126AC1A815AE517BBD5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (3154, 300, 300, 10, 1, 0.25, 0.25, 0.25, '217-SB S. of US 26', 0.180000007, 1118, 1111, 1, 0, 3, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, '0102000020110F0000060000002063EE9CBB116AC1C832C43D01C05541A223B984C4116AC180AEB636E5BF5541ABCFD53CCB116AC198081B3ED2BF554166F7E40DD1116AC12063EEE2C3BF5541F241CF0AD6116AC1C8DCB598B9BF5541787AA59ADB116AC190A0F869AEBF5541', '0102000020110F000006000000900F7AB8C4116AC15839B4E40CC05541D200DE7ACD116AC1C8073D53F1BF55413B70CED6D3116AC1809ECD5EDFBF5541371AC021D9116AC1C030994ED2BF554148E17ABCDD116AC1888EE4CEC8BF55418CB96B21E3116AC1D0915CF6BDBF5541', '0102000020110F000006000000AC1C5A00CB116AC1608FC2ED14C055416A4DF3A8D3116AC1884160ADF9BF5541182653C5D9116AC1F8065F6CE8BF5541A679C7B3DE116AC120386740DCBF5541849ECD0AE3116AC118C05B4CD3BF5541C2F52852E8116AC138234AAFC8BF5541', '0102000020110F00000600000045D8F0CEDD116AC1C84B37FD2CC055411748502AE6116AC150E3A5AF12C0554163EE5A88EB116AC168B3EA8703C05541643BDF61EF116AC168446907FABF5541545227EEF2116AC1706891B5F2BF55412063EEDCF7116AC1002B87CAE8BF5541', '0102000020110F000006000000F4FDD4BCF2116AC1480378C347C0554114D044C2FA116AC130211F842EC05541006F814CFF116AC160764FB221C05541F4DBD7F101126AC140AD692A1BC0554126E4839C04126AC10044FAA915C055413480B72809126AC1E09C11850CC05541', NULL, '0101000020110F0000AB0DCB69C8116AC1D0938F37DABF5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1070, 300, 300, 9, 1, 5.9000001, 5.9000001, 5.9000001, '99W EB to NB', 0.379999995, 1071, 1069, 1, 0, 2, '-122.75375:45.43026:-122.76014:45.43609', 0.5, 3, NULL, NULL, NULL, NULL, '3', NULL, '0102000020110F00000400000004780BA4BC106AC1684DF30AEBB45541081B9ED4AF106AC1081B9EB6C7B45541068195F195106AC1001973277EB455415AD3BCFD88106AC168F7E43D57B45541', '0102000020110F00000400000065AA6056B5106AC108F0160CF6B45541022B8768A8106AC1F02FBB63D2B45541DBF97E6A8E106AC198DD938788B455413C4ED16581106AC1880D4F6B61B45541', '0102000020110F000004000000DCD78147AA106AC1903177B506B55541E2C7982B9D106AC1F853E38DE2B45541567DAE0483106AC1E88C283D98B4554126E483E675106AC1E0361AD470B45541', '0102000020110F0000040000005305A34C9C106AC18048BFC51BB5554192CB7FF68E106AC1F86C56FDF6B45541D49AE69B74106AC110363C19ACB4554193A9825D67106AC1E058174F84B45541', '0102000020110F00000400000043AD699C7C106AC140FAED834BB55541CC5D4BC26E106AC19006F04E25B55541BBB88DF253106AC1A89BC41CD9B45541E6D0226B46106AC108A39276B0B45541', NULL, '0101000020110F0000E0D0CCDAB9106AC1F482E45BE3B45541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (3156, 300, 300, 10, 1, 1.5, 1.5, 1.5, '217-SB @ TV Hwy', 0.579999983, 1080, 1079, 1, 0, 2, NULL, 1, 3, NULL, NULL, NULL, NULL, '51', NULL, '0102000020110F00000A0000005EDC46F159126AC118D9CEAB50BE554179E926955D126AC1F0F44AC516BE5541295C8F7460126AC148C807A1F0BD5541B4EA736364126AC170567D8EAEBD55416D567DA266126AC1605452EF88BD5541ABCFD50267126AC1589FABA182BD5541DFE00B3168126AC1A83E57DB6EBD5541DD2406DD6B126AC148E17AA830BD5541B07268656E126AC190ED7C4F0ABD55412A3A92CB6E126AC1A8CFD5AA03BD5541', '0102000020110F00000A0000007A36ABAC64126AC170D7121A53BE554134A2B44768126AC1009A08BF19BE55418E976E286B126AC1787AA588F3BD5541168C4A1C6F126AC1189E5E21B1BD5541ECC0395B71126AC1507424838BBD554104C58FBB71126AC1208E753585BD5541D9CEF7E972126AC168BC746B71BD5541D066D59376126AC198E61D5B33BD5541A835CD1B79126AC18004C5070DBD5541423EE88379126AC198779C4206BD5541', '0102000020110F00000A000000166A4D136C126AC1A05E29C754BE554112143FA86F126AC138014DCC1BBE55414082E28972126AC120166A89F5BD55419E5E298176126AC1C8FEB2E7B2BD5541B88D06C078126AC1C039234A8DBD5541D2915C2079126AC168226CFC86BD5541B003E74E7A126AC1B025E42F73BD55413CDF4FF77D126AC188855A3735BD55414850FC7E80126AC120C9E5E70EBD554144696FE880126AC16032550C08BD5541', '0102000020110F00000A000000006F813C82126AC11851DACB59BE5541EA0434BF85126AC12897FFF021BE554104C58FA388126AC1104FAF88FBBD55412B8716A58C126AC120B9FC37B8BD554112A5BDE38E126AC1B094659C92BD55414E6210448F126AC1C030994E8CBD5541923A017390126AC1D8F97E7A78BD55414D840D1794126AC110363CC93ABD55413FC6DC9D96126AC168006F8514BD55411826530B97126AC11083C0660DBD5541', '0102000020110F00000A0000005E4BC8E59A126AC1A0923A615FBE55417C832F549E126AC1D000DEC628BE55412A3A923BA1126AC120A7E83402BE5541DBF97E48A5126AC148BF7D21BEBD5541D578E986A7126AC1984C158898BD5541ECC039E7A7126AC1A0F8313A92BD554152499D16A9126AC1589FAB5D7EBD554116D9CEB5AC126AC1F02FBBFB40BD55417958A83BAF126AC1D0BCE3C41ABD55414FAF94ADAF126AC19865885B13BD5541', NULL, '0101000020110F00009F69F16367126AC1934705477CBD5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (3153, 300, 300, 9, 1, 0.25, 0.25, 0.25, '217-NB S. of US 26', 0.460000008, 1063, 0, 1, 0, 3, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, '0102000020110F0000140000003A234AAFA0116AC1B8627F2950C055412E90A0FAA1116AC1107A36DB4BC055413A234A45A3116AC1B8270F8F47C0554135EF3891A4116AC138B4C83E43C0554169006F9DA5116AC1384547C23FC05541842F4C86A6116AC1204A7BBB3CC055413CBD52F4AA116AC1708A8E582EC05541EA263176B1116AC1908785FA18C055410AF9A0EBB5116AC120F46C8E0AC05541865AD362BA116AC1F86C5675FBBF5541D6C56DE8BD116AC1B0BFECF6EFBF55411AC05B5AC2116AC1900F7AEAE2BF554140136165C8116AC1D8ACFA4CD1BF554182734618CE116AC1E82631D8C3BF5541903177E5D3116AC170689189B7BF554120D26F09DA116AC168B3EA03ABBF5541ADFA5CBFE0116AC1C8C342819EBF5541A9A44E42E8116AC168D5E7CE91BF55410AF9A0E7F0116AC170B515B384BF5541C7BAB83BF4116AC1182653697FBF5541', '0102000020110F0000140000004260E5DA98116AC1487B83AF46C05541EBE236269A116AC160984C6142C055416519E2709B116AC1E88C28153EC055415D6DC5BC9C116AC1280F0BC539C055416A4DF3C89D116AC1787AA54836C055411AC05BB89E116AC108F0162C33C055410000002AA3116AC100D578BD24C05541FF21FDACA9116AC11851DA5B0FC055416C9A771AAE116AC1287E8C0901C05541166A4D8FB2116AC190CB7FF8F1BF5541780B243CB6116AC108AC1CFAE5BF55419F3C2CD0BA116AC128F69789D8BF5541CDCCCC20C1116AC158204121C6BF5541280F0B49C7116AC190757197B7BF55418C4AEA50CD116AC168AA60CCAABF55414082E2A9D3116AC17836ABDA9DBF5541FBCBEEAFDA116AC1C820B0C290BF5541CEAACF8DE2116AC1A0EFA77683BF554148BF7D4FEB116AC1D0DEE02F76BF5541F4FDD48EEE116AC1C09F1A0771BF5541', '0102000020110F0000140000002C6519008D116AC1A860545638C055411C5A644B8E116AC11058390834C055414E6210968F116AC108F016BC2FC05541F853E3E190116AC1A0B4376C2BC05541B88D06EE91116AC120B9FCEF27C05541AB3E57E792116AC170567DB224C055418F53745E97116AC1C8B12E3216C05541E6D022E39D116AC1782D21CB00C0554106A39244A2116AC1F897DD9FF2BF55411895D4B5A6116AC1480C029BE3BF5541BC05129EAA116AC1A8CFD5DAD6BF55415AD3BC65AF116AC160E5D0D2C8BF55415C8FC21FB6116AC160CC5D37B5BF55410C71ACF9BC116AC108AC1C0AA5BF554141F1635AC3116AC15005A38297BF5541BF0E9C03CA116AC1601058ED89BF5541B437F882D1116AC1F03845F37BBF5541022B87EAD9116AC108A392BE6DBF55410A4625D7E2116AC11083C03660BF55412ACB10F7E5116AC168B3EA3F5BBF5541', '0102000020110F00001400000003098A037E116AC1C030993226C0554116FBCB4E7F116AC108D7A3E421C055416C787A9980116AC1701283981DC0554135EF38E581116AC148D8F04819C055415F984CF182116AC1D834EFCC15C055419CA223F783116AC1181DC96512C055417AA52C7588116AC130431CCF03C05541492EFFFB8E116AC110BE3061EEBF55417D3F354E93116AC160DC4667E0BF554145D8F0BA97116AC11895D471D1BF5541394547EE9B116AC1104FAFBCC3BF5541A3923AF7A0116AC1084625F5B4BF5541DBF97E36A8116AC1484772D59FBF5541265305F1AF116AC120FDF6958DBF554196900FC2B6116AC138014D207FBF554111C7BAD0BD116AC1381136BC70BF5541B4EA73E9C5116AC1184850A461BF55412ACB10FFCE116AC1B8627F4952BF554122FDF621D8116AC19075716F44BF55417AC7291ADB116AC1C876BEB73FBF5541', '0102000020110F0000140000000E2DB20B5C116AC1F00DBE14FDBF5541AE47E1565D116AC1C09F1AC7F8BF554198DD93A15E116AC1D868007BF4BF5541E6D022ED5F116AC150DA1B2CF0BF554174B515F960116AC1085F98B0ECBF5541F2B0501B62116AC1B8270FEBE8BF5541703D0AA966116AC130E6AE21DABF55417EAEB6346D116AC1C86D34A4C4BF55418CDB686471116AC1A080261AB7BF55411CEBE2C675116AC198559F47A8BF5541D88173A47A116AC1A84E406798BF55418941604180116AC178E09CED87BF55410C93A9AE88116AC120FDF65D6FBF55411748506692116AC15839B46C58BF55412041F1359A116AC1107A36DB47BF5541E02D902AA2116AC1B0506BA237BF5541B003E79EAB116AC158F5B90226BF5541029A083FB6116AC1F0F44A0D14BF5541FE65F7DCBF116AC188D2DE7805BF5541772D217BC2116AC158423E5001BF5541', NULL, '0101000020110F0000E52BB28EC7116AC17176C5BED3BF5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1063, 300, 300, 9, 1, 0.660000026, 0.660000026, 0.660000026, 'Walker Rd NB', 0.540000021, 1064, 3153, 1, 0, 2, '-122.7892:45.49399:-122.77699:45.50665', 0.5, 3, NULL, NULL, NULL, NULL, '10', NULL, '0102000020110F000013000000C7BAB83BF4116AC1182653697FBF55419CC420C0F8116AC1984C153C78BF5541F4FDD4F601126AC150499D606BBF554179E9260D0F126AC1D0F753DB58BF5541CC5D4B581D126AC1A0F8314E43BF5541F31FD28928126AC1B8DA8A4531BF554152499D962F126AC1A0CDAA0325BF5541F016489E36126AC160EE5AB617BF5541E2C7981F3D126AC160DC465F09BF55415C2041F342126AC148B6F3E1F9BE5541151DC9A745126AC1C0A8A4A2F0BE5541E0BE0E4048126AC130C4B17AE6BE5541DCD7812B4C126AC108A392B6D5BE55416E1283264F126AC1D88AFDBDC5BE554142CF66E34F126AC1F853E3C9C1BE5541C420B07C52126AC170B515D3ABBE55416ABC74C553126AC1603255D49CBE5541386744B954126AC148E17A9C8CBE5541C364AAD854126AC1989999298ABE5541', '0102000020110F000013000000F4FDD48EEE116AC1C09F1A0771BF55417C832F4CF3116AC188FD657F69BF5541A0F831B8FC116AC150AF94595CBF5541F8E461AB09126AC198900F064ABF5541F01648BC17126AC1D0CCCCD034BF5541F48E53AE22126AC1B8C8762E23BF554138F8C27429126AC1D8F0F46617BF5541E4839E1730126AC148696FD80ABF55418CDB681436126AC1483789A5FDBE5541287E8C553B126AC18048BFADEFBE5541506B9AA33D126AC180E2C7CCE7BE5541C364AA0A40126AC100D57865DEBE55417F6ABCBC43126AC1605DDC96CEBE5541143FC69646126AC170C5FE4EBFBE55415A86382047126AC198FF906EBCBE5541C0EC9E8649126AC128750226A8BE55416ADE71B84A126AC118E258339ABE5541567DAEA24B126AC1402CD49E8ABE55412AA913C04B126AC10088F45388BE5541', '0102000020110F0000130000002ACB10F7E5116AC168B3EA3F5BBF55410AD7A30AEB116AC1A84E402F53BF5541F6285CC7F4116AC1182FDD9845BF554188855A8501126AC178F2B09033BF5541BC05123E0F126AC1D83D79E01EBF5541492EFFCF19126AC108560ED90DBF5541D49AE62B20126AC1809ECDCA02BF5541E4F21F3626126AC1A0A2235DF7BE55413889416A2B126AC1A033A2E4EBBE55414EF38ECD2F126AC1081B9E3AE0BE554121B0728031126AC1C005126CDABE5541DC68009D33126AC120B07228D2BE5541A0F831F836126AC1287E8CCDC3BE55413CBD52A039126AC158204191B5BE5541AE69DEDB39126AC1803F3552B4BE5541C64B37F53B126AC128871695A2BE5541842F4C043D126AC1F08E533896BE5541273108E03D126AC1C09F1A9B87BE5541B09465FA3D126AC1D0CCCC8C85BE5541', '0102000020110F0000120000007AC7291ADB116AC1C876BEB73FBF5541363CBD9AE0116AC148B6F3F936BF554148BF7DBDEA116AC1F07C3FD528BF5541EC9E3C38F7116AC1F08E532C17BF5541FED4788104126AC1D05D4B2403BF5541AF25E4990E126AC13880B7E0F2BE554152B81E6F14126AC158C1A8BCE8BE554165AA60B819126AC1C0F528BCDEBE554162A1D6EE1D126AC1F831E672D5BE554132E6AE3921126AC1482575B2CCBE55418CDB682822126AC1B8C87682C9BE5541EFC9C3E623126AC1283A92AFC2BE5541764F1ED426126AC1508D972AB6BE5541C66D341629126AC1E8043411AABE5541C13923CE2A126AC1B896908B9BBE5541CC7F48B12B126AC190E4F22F91BE55410E4FAF7A2C126AC160CC5DCB83BE5541C64B37912C126AC1C0CAA10982BE5541', '0102000020110F000011000000772D217BC2116AC158423E5001BF5541A69BC4F2C8116AC198900F0AF7BE55413AB4C8FCD3116AC1D088D2A2E7BE55412C431CDFDF116AC1A879C7D1D6BE55417958A82BEC116AC1B0BFEC46C4BE55410C93A930F5116AC1107A36BFB5BE55415305A3D4F9116AC148B6F3ADADBE55414B598668FD116AC1288716E9A6BE5541925CFE5FFF116AC1A83E5793A2BE5541627FD9DDFF116AC13870CE44A1BE554195D4094A00126AC1F85C6D9D9FBE554143AD693E02126AC190A9824197BE55419F3C2C1203126AC1B8AF03D392BE554114AE47ED03126AC110E9B7978BBE554118B7D16C04126AC1E8482EC785BE55410AD7A30C05126AC1E8C039277BBE5541FFB27B1A05126AC1E0E00B137ABE5541', NULL, '0101000020110F00001B2B6EAC24126AC1C0EB8C7F37BF5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1065, 300, 300, 9, 1, 2.16000009, 2.16000009, 2.16000009, 'Allen Blvd NB', 0.589999974, 1066, 3155, 1, 0, 2, '-122.78445:45.47383:-122.78939:45.48089', 0.5, 3, NULL, NULL, NULL, NULL, '8', NULL, '0102000020110F000012000000D8F0F48A6F126AC12085EB91C6BC55414A7B83C36F126AC1802F4CA6B7BC55411E166AF36F126AC1A045B6BBA4BC554104780BDA6F126AC1F08E536097BC554135EF38936F126AC188C954E98ABC55411A51DA9B6E126AC16007CE9568BC5541022B87126D126AC15817B7154CBC5541D4BCE3C26B126AC1789CA2B33ABC5541865AD37C69126AC12865191A24BC554190C2F5C266126AC1D834EFF80CBC55417F6ABC1E64126AC160E5D092F9BB5541302AA9B360126AC1684469C7E3BB5541F775E0045E126AC19028ED41D3BB55418BFD65375A126AC128A089A4C0BB55412506818356126AC108A39222B0BB5541FA5C6D9350126AC1205A64CB92BB55415A643BE34A126AC1E851B8767CBB554150FC184546126AC1B07BF2686CBB5541', '0102000020110F0000120000009CC4206866126AC1206C7806C6BC554163EE5AA066126AC120FDF631B7BC554180D93DCF66126AC100780BB0A4BC5541923A01B766126AC1808CB9EB97BC55411AC05B7266126AC178C729D68BBC55417C61327F65126AC1F831E6166ABC55417CD0B30164126AC1C8BAB8714EBC5541BEC117C262126AC140FAEDE33DBC5541703D0A8F60126AC130BB270728BC5541F8E461E75D126AC1C8E53F8011BC5541068195595B126AC1A067B3BEFEBB5541234A7BFF57126AC1F8285C5FE9BB5541A2D6346F55126AC1C042AD95D9BB55417958A8D151126AC1809ECDE2C7BB55417D3F351C4E126AC1D0AACF59B7BB5541B7D1004248126AC108A3926E9ABB55410EBE30DB42126AC188B0E13985BB5541D200DE5A3E126AC1585BB19375BB5541', '0102000020110F0000120000008E06F09258126AC1A84E4033C5BC55413108ACCA58126AC1608FC281B6BC5541941804F858126AC1D019519EA4BC554100917EE158126AC1E851B8BE98BC5541780B24A058126AC13008AC3C8DBC55411AE258B357126AC1D89AE65D6CBC55415C8FC24756126AC130992A0452BC5541FA7E6A2055126AC1A835CDB742BC5541E6AE250A53126AC160A1D6F82DBC5541721B0D7E50126AC190ED7C5B18BC5541341136124E126AC198E61D9306BC5541A835CDD14A126AC1B0B662D7F1BB5541355EBA6F48126AC170D7122AE3BB5541363CBD1A45126AC1C8A145DAD2BB55416891ED6241126AC15005A346C2BB5541ACADD8A93B126AC1A8CFD5FEA5BB55410A6822B236126AC1C8B12E7E92BB5541211FF45E32126AC160A1D67483BB5541', '0102000020110F0000120000002FDD241647126AC150DA1B28C4BC5541EE7C3F4D47126AC1B047E1A2B5BC5541C2A8A47847126AC1604BC887A4BC5541A7E8486447126AC1601058C999BC55412B87162747126AC138D6C5018FBC554187A7574246126AC160E5D03E6FBC55411C5A64ED44126AC17893188856BC55413480B7E443126AC1E07A14D248BC5541ABCFD5F241126AC1B00C717C35BC554198DD93893F126AC140355E0621BC55410C93A9483D126AC100DE027910BC55417F6ABC283A126AC198C4208CFCBB5541BB270F0138126AC1D0195146EFBB55413A92CB0735126AC1684469B7E0BB5541923A014D31126AC140BD5216D0BB554183C0CABD2B126AC1A0A2239DB4BB554170CE885227126AC1C876BE43A3BB5541FA7E6A3823126AC1104FAF0095BB5541', '0102000020110F000012000000D578E9721F126AC170D712CAC1BC5541508D97A81F126AC130772DA9B3BC554196218ECF1F126AC1E8263154A4BC5541984C15C01F126AC158302A259CBC55413A014D8C1F126AC160BA490493BC5541151DC9B91E126AC1C0EC9EC475BC554151DA1B981D126AC1302AA9C360BC5541D634EFD41C126AC1E851B8A656BC554193A982351B126AC1984C158446BC55413333331B19126AC138234AAB34BC55417268913B17126AC120B9FCE726BC5541A44E406514126AC1D8CEF7CF14BC55418D28EDC112126AC1B86B09B90ABC5541BBB88D9810126AC150E3A52300BC55414A0C02D70C126AC1C0051264EFBB5541C420B0A607126AC158643BBFD5BB55411461C37904126AC1B0B66247C9BB55414850FCE000126AC180C0CAC5BCBB5541', NULL, '0101000020110F0000E0CAC5D364126AC1987F54C4FEBB5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1111, 300, 300, 10, 1, 0.449999988, 0.449999988, 0.449999988, 'Wilshire to ORE 217 SB', 0.25999999, 3154, 1080, 1, 0, 2, '-122.78253:45.50553:-122.78645:45.50362', 0.5, 3, NULL, NULL, NULL, NULL, '12', NULL, '0102000020110F00000A000000787AA59ADB116AC190A0F869AEBF5541363CBD28E1116AC1285305EBA3BF554160764F52E8116AC1C8B12EE297BF55413411361EF3116AC1B8270FEB86BF5541DA1B7C77FC116AC1E0B5840C78BF5541E4141DCD05126AC1D80968826ABF55414CA60AF00F126AC1E07A14165CBF5541E6D0227718126AC1409B55E34FBF5541DDB584581F126AC1809ECD1645BF55411CEBE22E24126AC1B8AF03333DBF5541', '0102000020110F00000A0000008CB96B21E3116AC1D0915CF6BDBF55419B559F55E8116AC1A0923A21B4BF5541A223B91EEF116AC1F83A70BAA8BF5541ADFA5CCDF9116AC180D93DF197BF5541D8F0F4FC02126AC1201FF45489BF55417EAEB6160C126AC108B5A6217CBF5541A0F8313216126AC1683BDFBF6DBF55410C2428EE1E126AC19031774161BF554188635D1426126AC1F875E00856BF554118B7D1FE2A126AC1A8A44E044EBF5541', '0102000020110F00000A000000C2F52852E8116AC138234AAFC8BF5541F6065F48ED116AC110F2414FBFBF5541B37BF2CEF3116AC110583958B4BF5541F9A06769FE116AC1A067B3AEA3BF5541EE5A427C07126AC1E0361A4095BF5541A223B96C10126AC158C1A84888BF5541E09C11831A126AC178C729EE79BF554148BF7D6323126AC1283A923B6DBF554155302AB92A126AC100F775B861BF5541470378B12F126AC118AE479D59BF5541', '0102000020110F00000A0000002063EEDCF7116AC1002B87CAE8BF554170F08519FC116AC158302AC9E0BF5541F831E6D801126AC180E2C720D7BF55412063EE360C126AC198081BD6C6BF55415917B7F314126AC1184850F0B8BF55414C158C681D126AC1086822ACACBF554193A9826F27126AC120D26F679EBF554176711BBD30126AC1085F981891BF5541B003E7A038126AC1180456B684BF55417CF2B0C23D126AC1907571577CBF5541', '0102000020110F00000A0000003480B72809126AC1E09C11850CC05541A4DFBE960C126AC1B059F50906C055416ADE717811126AC1B8D100D6FDBF554111363C931B126AC16819E2F4EDBF55415B423EF023126AC118E258A7E0BF5541DA1B7CDB2B126AC10893A92AD5BF55413D9B55D135126AC1588638FEC6BF55411FF46C983F126AC1D81B7C01B9BF55411C7C611A48126AC120EBE2A6ABBF5541AA60546A4D126AC108D7A3FCA2BF5541', NULL, '0101000020110F0000CBBA52CCF6116AC1085E9D1081BF5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1066, 300, 300, 9, 1, 2.68000007, 2.68000007, 2.68000007, 'Denney Rd NB', 0.620000005, 3157, 1065, 1, 0, 2, '-122.7844:45.46292:-122.7844:45.4738', 0.5, 3, NULL, NULL, NULL, NULL, '7', NULL, '0102000020110F00001700000050FC184546126AC1B07BF2686CBB554164CC5DD944126AC12038677867BB5541386744CF40126AC1084625C559BB55412C431C413E126AC1489D801A51BB55419487853638126AC100E78CE43BBB5541B0E1E96331126AC178E09C8125BB5541F01648DA2B126AC198FF905613BB55410C022B3B24126AC1A813D080FABA554155C1A8A820126AC1C05296DDEDBA5541CEAACFD31D126AC11851DA8FE4BA5541D26F5FAB1B126AC198B20C79DCBA5541A44E406B19126AC1F0F44A95D3BA55415C20412D17126AC180D0B31DCABA5541FE65F70815126AC1201FF410C0BA5541431CEB5C13126AC1E82631CCB7BA5541168C4AFE11126AC13870CE6CAFBA554121B0727810126AC140E8D9E0A1BA55411CEBE2280F126AC1B88D063093BA5541721B0D280E126AC10000007877BA554104C58F1B0E126AC1088195735EBA5541EA73B55F0E126AC1400AD71B43BA55415D6DC57A0E126AC1204A7B2F3BBA5541180456C00E126AC1E0718ACA26BA5541', '0102000020110F000017000000D200DE5A3E126AC1585BB19375BB55418E7571F53C126AC170F90FB970BB5541F0A7C6F138126AC150F38E1B63BB5541567DAE5A36126AC1B8B88D525ABB5541BE30995830126AC1B0D85F3A45BB55419CC4209829126AC1D000DE122FBB55411E38671024126AC1482EFFED1CBB5541E258175D1C126AC1F84A59D603BB554121B072C818126AC1487B832BF7BA5541C420B0E415126AC1F00DBEACEDBA55412ACB109113126AC1B88D06F4E4BA5541506B9A3711126AC130211FACDBBA55416E1283D80E126AC1A89BC4A8D1BA5541234A7B990C126AC14825751EC7BA5541333333C70A126AC1C074931CBEBA5541AC8BDB2C09126AC178931850B4BA55416C09F98207126AC1F8A06783A5BA5541081B9E1406126AC1C8C3427995BA5541098A1F0505126AC1B0B6622B78BA55415B423EF804126AC1F831E64E5EBA55419BE61D3D05126AC110022BAF42BA554143AD695805126AC19028EDB13ABA55416B2BF69D05126AC1A835CD4F26BA5541', '0102000020110F000017000000211FF45E32126AC160A1D67483BB55410612140331126AC1D06F5FBB7EBB5541C21726092D126AC1F041CF3E71BB554126E483642A126AC1A8ADD84768BB55413CDF4F6F24126AC1C854C15C53BB5541A9A44ECA1D126AC158643B8F3DBB5541228E754518126AC1C8FEB2732BBB5541E10B937310126AC1807346F811BB5541C6FEB2DB0C126AC1B0E1E94105BB55413E575BE109126AC14060E578FBBA554163EE5A4C07126AC198F606CBF1BA5541948785CC04126AC100917EEBE7BA55413D9B553B02126AC148598614DDBA554116D9CED3FF116AC150DA1BCCD1BA55412E6EA3C7FD116AC1D0DEE0ABC7BA5541D4BCE3D2FB116AC1C03099B6BBBA5541B20C71F2F9116AC1A82C4304ABBA554190317755F8116AC138234AEF98BA55415E4BC82FF7116AC1401CEB3A79BA5541F2D24D22F7116AC138234A175EBA5541A7E84868F7116AC1285C8F0A42BA5541FBCBEE83F7116AC1C876BEF339BA55416ABC74C9F7116AC168F7E49525BA5541', '0102000020110F000017000000FA7E6A3823126AC1104FAF0095BB554152499DE821126AC1E88C287190BB5541B6F3FDFA1D126AC110143F1E83BB5541A44E40451B126AC1C0D32BED79BB5541F48E536015126AC1986E123B65BB554195D409DE0E126AC1880D4FDF4FBB5541F4FDD45C09126AC1E0C798CF3DBB5541CC5D4B6401126AC100BC05D623BB5541623255C8FD116AC108CE191117BB5541454772B1FA116AC1803F35EA0CBB554183C0CAC9F7116AC140AD690602BB5541B4EA7319F5116AC1E8482E67F7BA5541D634EF48F2116AC1A0ABAD84EBBA5541A2B437AEEF116AC168B3EA4BDFBA5541D200DE58ED116AC1589FABC1D3BA5541D066D5F1EA116AC148378911C5BA554143AD69CCE8116AC1F07C3FF9B1BA5541B84082F4E6116AC1186A4D4F9DBA55413AB4C8B2E5116AC1083411927ABA5541295C8FA4E5116AC1182FDDD05DBA55416A6FF0EBE5116AC11804563A41BA5541DE020908E6116AC13033330339BA554126C2864DE6116AC1A8DFBEAA24BA5541', '0102000020110F0000170000004850FCE000126AC180C0CAC5BCBB55414C158CACFF116AC188C95495B8BB5541865AD3DAFB116AC118B7D1A0ABBB5541842F4CFEF8116AC1B88D06ECA1BB5541CBA1453EF3116AC1782D21BB8DBB55413108AC0AED116AC110363C6179BB5541C7BAB891E7116AC160BA496C67BB55414FAF9441DF116AC1183FC6544CBB5541AC1C5A9CDB116AC18816D96E3FBB55415D6DC544D8116AC110022B7334BB55415E4BC8A1D4116AC140E8D9D026BB5541DCD78183D1116AC10812147F1ABB554145477223CE116AC178C7293E0CBB55410F0BB514CB116AC150499DE4FDBA5541DCD78119C8116AC1A879C725EFBA5541D85F76AFC4116AC148378945DABA55415AD3BCEDC1116AC1083D9BBDC1BA55413A014D90BF116AC1208E7539A7BA5541BB270F0FBE116AC188855A9B7DBA5541C4D32BFFBD116AC1A023B9305DBA55417E8CB949BE116AC140C6DC613FBA554162A1D666BE116AC1208E75E136BA5541388941ACBE116AC180D93D9522BA5541', NULL, '0101000020110F00002479596020126AC15E37FDEFECBA5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1067, 300, 300, 9, 1, 3.8499999, 3.8499999, 3.8499999, 'Scholls Fy NB', 0.620000005, 1068, 3157, 1, 0, 2, '-122.78062:45.44746:-122.78364:45.46292', 0.5, 3, NULL, NULL, NULL, NULL, '6', NULL, '0102000020110F000011000000FF21FDA605126AC1183FC638E2B855410C022B0905126AC1A8C64BE7DCB85541645DDC6201126AC1285305FBBAB8554190C2F5ACFE116AC1489D8042A3B85541FA7E6A40FD116AC1B02E6EDB91B85541A4DFBE0CFC116AC188FD659B81B855410EBE3077FB116AC1186A4D8F77B855415E29CB2CFB116AC180D0B38D6FB85541A089B07DFA116AC1104FAFB45CB855416C787AFDF9116AC1A0703D324AB855415B423EB8F9116AC1D809687A37B8554132772DE1F9116AC1706891C50FB8554188855AF1F9116AC1608FC291E6B7554162A1D6B6F9116AC1B8DA8A19C4B7554120D26FD3F9116AC1C8BAB8DDACB75541772D21C7F9116AC1D0AACF259AB75541C8293AD2F9116AC1A03C2C248DB75541', '0102000020110F000011000000D8F0F4C0FC116AC1E0BE0E60E6B85541FAEDEB1EFC116AC1C8B12EEAE0B85541643BDF77F8116AC17836ABF6BEB85541211FF4B4F5116AC1E04603CCA6B85541789CA239F4116AC198C420B094B85541FE43FAFDF2116AC140FAED0384B855413CBD525EF2116AC188B0E14979B855415B423E10F2116AC198FF90E270B855417424975FF1116AC1A86054DE5DB8554177BE9FDCF0116AC100D578F54AB85541A8C64B95F0116AC1907571AB37B85541BC7493BEF0116AC1D06F5FAB0FB855417EAEB6CEF0116AC110A5BDA9E6B75541C1392394F0116AC198081B22C4B755418716D9B0F0116AC1A05E29D3ACB75541BC7493A4F0116AC1305530229AB755415E4BC8AFF0116AC1A89BC4048DB75541', '0102000020110F000011000000A835CD47EF116AC1F853E3A9ECB855416688639FEE116AC120A7E8FCE6B85541C64B37F7EA116AC168DE71FEC4B8554199BB9620E8116AC1B837F826ACB85541F831E68EE6116AC138DF4FF998B85541E78C2847E5116AC1D0B359A987B85541C66D3498E4116AC168B3EAE77BB8554104E78C44E4116AC1C03099E672B8554196218E91E3116AC1904AEAA05FB855411FF46C0AE3116AC1B8F3FD1C4CB8554144FAEDBFE2116AC1E8839EF537B85541EC2FBBE9E2116AC1789CA2830FB855413C4ED1F9E2116AC10044FACDE6B75541E6D022BFE2116AC1D868002FC4B7554102BC05DCE2116AC150FC18C3ACB7554116D9CECFE2116AC108D7A31C9AB755417AA52CDBE2116AC178E926D58CB75541', '0102000020110F000011000000CFF7533FDE116AC1B07BF29CF4B855418716D98EDD116AC1802F4CAAEEB855415C2041E5D9116AC170E7FB9DCCB855415917B7F5D6116AC1B88D06ECB2B85541371AC047D5116AC1388941649EB855417F6ABCF0D3116AC1386744458CB85541D881732ED3116AC1F8B9DA367FB85541371AC0D3D2116AC11873D77275B85541CCEEC91DD2116AC190976EDA61B855418BFD6591D1116AC1206C78924DB8554167D5E742D1116AC160DC465338B8554164CC5D6DD1116AC1A80A46510FB85541F8E4617DD1116AC1A0CDAAFBE6B75541BC749342D1116AC1E8482E3FC4B7554132E6AE5FD1116AC17836ABAEACB7554103098A53D1116AC1B8627F159AB755412C431C5FD1116AC1885AD3988CB75541', '0102000020110F0000110000005227A0A3B7116AC1C84B37A106B9554140A4DFE0B6116AC1787AA51000B95541E0BE0E34B3116AC148D8F0E4DDB855414E62100CB0116AC11061C343C2B8554102BC051EAE116AC1B8A679ABAAB85541B09465A4AC116AC1A0D634B796B85541CE1951B6AB116AC128ED0DB686B85541C286A74BAB116AC110C7BA387BB85541917EFB8EAA116AC1A813D0E466B855413108ACF6A9116AC190CB7FE050B855412EFF219FA9116AC1703D0A2739B8554108CE19CBA9116AC198779CDE0EB85541211FF4DAA9116AC1100BB562E7B7554188F4DB9FA9116AC118E25863C4B75541B5A679BDA9116AC188F4DB7FACB7554192ED7CB1A9116AC1D0CCCC049AB7554170F085BDA9116AC10881950F8CB75541', NULL, '0101000020110F00008350ACFDFA116AC10F364A7B6AB85541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1068, 300, 300, 9, 1, 4.6500001, 4.6500001, 4.6500001, 'Greenburg NB', 1, 1069, 1067, 1, 0, 2, '-122.76768:45.44111:-122.78057:45.44749', 0.5, 3, NULL, NULL, NULL, NULL, '5', NULL, '0102000020110F00001A000000C8293AD2F9116AC1A03C2C248DB755418D28EDD5F9116AC1802F4CCE88B75541AF25E485F9116AC1F84A597A7AB7554104780B66F9116AC1306EA37976B7554174B51501F9116AC1F00DBECC69B75541053411D2F7116AC16819E2B857B7554140A4DF54F5116AC1986588833FB75541226C78C0F3116AC1E0718AE632B755419465885DF2116AC1E024064529B7554160545211EE116AC1B069DE910CB7554126E48304E8116AC1F0D24DBEE1B655412A18953AE5116AC100E78C3CD1B655411CEBE2A4E3116AC1A80A4629C8B65541F6065FCCE1116AC138DF4F6DBFB655416C09F9F2DF116AC1C8293A9EB7B65541787AA514DE116AC1D0BCE328B1B65541287E8C39DB116AC1C00512F0A7B65541394547CAD7116AC108F9A09B9FB65541302AA939D2116AC1F8B9DA3A94B655417EAEB62CC8116AC198081B1E84B65541984C1520C2116AC1C05B20217CB65541F0A7C611BC116AC110143F7274B6554196438BD094116AC1D0D556F43EB655414CA60ACC72116AC13090A09810B65541CB10C76A56116AC1B88D0674EAB555416519E2B651116AC190C2F508E4B55541', '0102000020110F00001A0000005E4BC8AFF0116AC1A89BC4048DB75541E25817B3F0116AC13867442589B75541BE309966F0116AC1285305737BB7554151DA1B48F0116AC1D022DB9D77B75541780B24E8EF116AC1288716916BB75541C2A8A4CEEE116AC1083D9BC55AB75541F085C96CEC116AC1403EE89943B75541728A8EEEEA116AC1B069DEAD37B755418F53749AE9116AC1D0F753732EB75541075F984CE5116AC148D8F0B411B75541DAACFA4ADF116AC180734630E7B65541AF25E497DC116AC1A011A535D7B65541B003E71EDB116AC1E851B8C6CEB65541DFE00B77D9116AC1D8ACFAF0C6B6554188635DDCD7116AC1A067B32AC0B6554196900F40D6116AC1B8DA8A99BAB6554172F90FCBD3116AC1881F63AAB2B655416B2BF6FFD0116AC1506210E4ABB65541A835CD17CC116AC1585BB1DBA1B65541894160CDC2116AC1A8DFBEF692B65541DDB5842CBD116AC1506210888BB65541AE69DE0FB7116AC120DBF9C683B6554145D8F0AE8F116AC110A5BD1D4EB65541E61DA7B06D116AC1187C61CA1FB65541C898BB4E51116AC13870CEA4F9B5554190A0F8934C116AC118C05B30F3B55541', '0102000020110F00001A0000007AA52CDBE2116AC178E926D58CB75541F853E3DDE2116AC16819E2A889B755418026C296E2116AC168BC74EB7CB755413CBD527AE2116AC180FB3A5879B7554168B3EA21E2116AC1B0E1E93D6EB755416EC5FE28E1116AC198559F635FB755414B5986F0DE116AC130DD24CA49B75541F697DD93DD116AC1705F07EA3EB7554110583956DC116AC1D8E76A4B36B75541F697DD05D8116AC1E046037C19B7554157EC2F15D2116AC1809ECD6EEFB65541C420B084CF116AC138F8C240E0B6554155302A37CE116AC1587DAECAD8B655414850FCD8CC116AC1E0938751D2B6554113F2419DCB116AC1E826311CCDB65541D578E964CA116AC1485986E4C8B65541DBF97E8AC8116AC1E0B584E8C2B655416B2BF6B7C6116AC17081047DBEB65541645DDCCEC2116AC198081B7EB6B6554190C2F5AABA116AC1A80A4671A9B655415EDC46ADB5116AC150A60ADAA2B65541FAEDEB7AAF116AC1688863FD9AB65541492EFFE987116AC1B8B88D1265B65541E4141DF565116AC1D066D5CB36B65541C66D349249116AC1F085C9A410B65541DFE00BCD44116AC1784F1E220AB65541', '0102000020110F00001A0000002C431C5FD1116AC1885AD3988CB75541986E1261D1116AC130BB274F8AB755417EAEB620D1116AC158643BC77EB7554140A4DF06D1116AC1F8285C877BB755414AEA04B8D0116AC170AC8B9F71B75541CBA145E8CF116AC1A8F1D23965B755412E211FE4CD116AC160A1D69C51B755411DC9E5B1CC116AC19075710F48B75541304CA690CB116AC1B059F53540B75541C05B203DC7116AC198B20C5123B75541F697DD61C1116AC1F8B9DADAF9B65541E25817FDBE116AC1001973AFEBB6554126E483E6BD116AC1D8CEF773E5B65541470378E5BC116AC1487B83B3E0B65541F0A7C621BC116AC1E09C1179DDB65541F263CC67BB116AC1C8B12EF6DAB655413B70CE50BA116AC138EF3871D7B65541B84082B8B9116AC1400AD7FFD5B655411A51DA11B7116AC1E8263194D0B65541CC5D4B62B0116AC180FB3ADCC5B65541B003E732AC116AC168886355C0B6554176711BE5A5116AC188B0E155B8B65541250681177E116AC150DA1B1882B65541B840822E5C116AC1884160E153B65541F54A59CA3F116AC100F775B82DB6554104780BF83A116AC160C3D32327B65541', '0102000020110F00001300000070F085BDA9116AC10881950F8CB75541CA32C4BDA9116AC1D8D781C78BB75541ED0DBE8CA9116AC150B81EFD82B755413AB4C878A9116AC1109C337A80B75541BC96903FA9116AC150B81E4979B755412C431CCDA8116AC1E8AE257472B7554193A9823FA7116AC1A8BDC15763B75541D85F766DA6116AC1784F1ECA5CB75541728A8E8CA5116AC1D85F76AF56B75541643BDF31A1116AC16007CE9939B755410A4625879B116AC12085EB7911B75541EA2631D899116AC1B8B88D8207B755415D6DC51299116AC1E002094606B7554123DBF9B696116AC1E81DA72803B7554123DBF92A90116AC1509621DAFAB65541D066D5D367116AC1407958E0C3B65541CCEEC90546116AC1D022DBCD95B6554116FBCB9E29116AC1A023B9A06FB6554133C4B1AE24116AC118E258E368B65541', NULL, '0101000020110F0000C799B562DD116AC1E12D4EEAAEB65541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1069, 300, 300, 9, 1, 5.8499999, 5.8499999, 5.8499999, '99W WB to NB', 0.629999995, 1070, 1068, 1, 0, 2, '-122.76018:45.43613:-122.76824:45.4414', 0.5, 3, NULL, NULL, NULL, NULL, '4', NULL, '0102000020110F0000120000006519E2B651116AC190C2F508E4B5554168226C6434116AC1F897DD03BCB5554118B7D14C22116AC1D044D8ECA3B5554195D409E612116AC1285C8F0E8DB55541D409686808116AC128ED0DB27CB555414AEA0476FF106AC1B01C5A5C6FB55541431CEBE0F8106AC1B8AF036364B5554104C58FD9F1106AC1B00C718058B55541D812F253F0106AC110022BC755B55541022B87DCEA106AC1489D80FE4BB55541749318B8E4106AC1C810C7E23FB55541B07268D1D5106AC1E024061D23B55541E10B9397CD106AC1085F982812B55541168C4A7AC9106AC1E0718A9209B555410612147FC5106AC1705F07CE00B55541211FF448C1106AC1501E1612F7B45541DA3D7962BD106AC178832FF8ECB4554104780BA4BC106AC1684DF30AEBB45541', '0102000020110F00001200000090A0F8934C116AC118C05B30F3B5554197FF904C2F116AC180B7403ACBB55541C9E53F0E1D116AC130B29DEFB2B55541C05B20610D116AC160A1D6A89BB55541D066D5E102116AC180D0B3498BB555411CEBE2D0F9106AC1D80968C67DB5554175029A04F3106AC1280F0B7172B5554144FAEDDDEB106AC1D81B7C5966B555415E4BC83FEA106AC1A8A44E7463B55541842F4C9EE4106AC188EB516059B555416232555ADE106AC1686666064DB555416519E260CF106AC14079581C30B555418BFD6507C7106AC1081B9EE61EB55541ADFA5CCFC2106AC15839B41816B5554108AC1CACBE106AC1000000FC0CB555418716D938BA106AC180AEB6B202B555418CDB682AB6106AC180514931F8B4554165AA6056B5106AC108F0160CF6B45541', '0102000020110F000012000000DFE00BCD44116AC1784F1E220AB65541AED85F9627116AC1100BB542E2B555418E75711D15116AC1F8CBEEA9C9B5554161C3D30505116AC1D834EFC4B1B55541DC460384FA106AC1D0AACF61A1B555415E29CB44F1106AC1B8627F9993B5554190C2F524EA106AC1F085C9B887B5554189D2DECEE2106AC1B8F3FD507BB555414FAF940BE1106AC1F86C562978B555411E38672ADB106AC1880D4FA36DB555417CF2B0B6D4106AC1107A36EB60B5554162A1D6A0C5106AC1305530CA43B5554169006F17BD106AC1083D9B3132B555411CEBE2B6B8106AC198E61D0F29B555416F810457B4106AC188D2DE6C1FB555410EBE3087AF106AC1E00B934D14B5554112143F3CAB106AC1F8A0672F09B55541DCD78147AA106AC1903177B506B55541', '0102000020110F00001200000004780BF83A116AC160C3D32327B65541B9FC87D61D116AC178711B61FFB55541B6627F130B116AC1B8DA8A65E6B5554136AB3E75FA106AC1701283B8CDB5554112143FF0EF106AC1D0D55650BDB55541B9FC8776E6106AC138F8C230AFB55541E09C11EDDE106AC1B025E49FA2B55541029A085BD7106AC17836ABD295B55541A857CA68D5106AC14894F65692B55541992A1837CF106AC1C854C14087B555416F810487C8106AC128F697117AB55541CAC3424DB9106AC128CB10AB5CB55541EF384587B0106AC1004D84954AB555414A7B83F3AB106AC17893180841B55541923A0147A7106AC100DE02BD36B555410C242802A2106AC130BB278F2AB5554111C7BA6A9D106AC160E5D0AA1EB555415305A34C9C106AC18048BFC51BB55541', '0102000020110F00001200000033C4B1AE24116AC118E258E368B655419CA223BD07116AC1E8FBA96141B65541C1392352F4106AC178C7298627B65541C6DCB582E2106AC1585BB1130DB65541DBF97EF6D7106AC1984C15A0FCB55541325530F8CD106AC180AEB6BAEDB55541166A4D7FC5106AC1489D809ADFB5554166886365BD106AC118E258E7D1B55541EC51B808BB106AC150B81EADCDB555416E128320B4106AC108F01650C1B555412DB29DE7AC106AC1009A0813B3B55541226C785C9D106AC120DBF90E95B555419E5E290D94106AC1509621DE81B55541182653058F106AC1A860545E77B55541E4141DAB89106AC128A089946BB55541DD24065D83106AC1F8E461015DB5554136CD3B187E106AC1400AD75B4FB5554143AD699C7C106AC140FAED834BB55541', NULL, '0101000020110F0000C46B3D64C2106AC14F7ADDA0F9B45541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1079, 300, 300, 10, 1, 1.91999996, 1.91999996, 1.91999996, 'B-H Hwy SB', 0.529999971, 3156, 1078, 1, 0, 2, '-122.79298:45.4912:-122.79298:45.48246', 0.5, 3, NULL, NULL, NULL, NULL, '14', NULL, '0102000020110F0000120000002A3A92CB6E126AC1A8CFD5AA03BD554152499D2870126AC1807346F8ECBC55415917B79F70126AC1903A0195E3BC55416C9A770071126AC1D8C56DF4DBBC5541287E8C9171126AC1C8293A1EC5BC55410E2DB21B72126AC188F4DB9FB0BC55416519E23272126AC1B81E853B9CBC554108CE19EB71126AC170567D6E8ABC55419A99998571126AC1E873B5DD78BC554176E09CE170126AC1782D21DF68BC5541F853E31B70126AC1A8CFD5B65ABC5541FA0FE90D6F126AC16032551847BC554104780B226B126AC108F9A0B71EBC55415AD3BCD768126AC1B8A679A709BC55414C37893366126AC1B02E6E7BF5BB55414850FC6C63126AC1D8A3705DE3BB5541F853E3BB60126AC1F853E35DD3BB5541F697DDDF5F126AC108C58F51CEBB5541', '0102000020110F000012000000423EE88379126AC198779C4206BD5541F6065FE47A126AC1C0A8A456EFBC55411748505E7B126AC1D0AACFB9E5BC554116D9CEC57B126AC14850FC90DDBC554104780B5A7C126AC14825753AC6BC55410A4625E77C126AC14894F64AB1BC55411AE258FF7C126AC1C07493FC9BBC554132772DB57C126AC1B0FA5C9989BC554152499D4C7C126AC1D812F28177BC5541287E8CA17B126AC128CB10D366BC554134A2B4D77A126AC108F9A05F58BC5541CFF753BD79126AC1B837F8DA43BC5541265305B575126AC168F7E4551ABC5541A089B05773126AC12853059704BC55410C24289670126AC13033338BEFBB5541C6FEB2B36D126AC1107A36B7DCBB5541F831E6F46A126AC160EE5A66CCBB5541EF3845176A126AC150499D50C7BB5541', '0102000020110F00001200000044696FE880126AC16032550C08BD554113F2414B82126AC1A89BC4F8F0BC5541E78C28C782126AC158423E34E7BC55415F984C3383126AC1B0EA73ADDEBC5541A245B6C983126AC168DE71FEC6BC55413EE8D95884126AC1D834EFC0B1BC5541371AC07184126AC130FF21D19BBC5541FBCBEE2584126AC160EE5A0689BC554113F241BB83126AC12865199276BC5541840D4F0B83126AC1C0CAA16965BC55412E90A03E82126AC1187C61C256BC5541C6FEB21B81126AC1D868009F41BC554138D6C5FF7C126AC138014D5017BC5541605452957A126AC148D8F01801BC554104C58FBF77126AC1F041CF72EBBB55413FC6DCC974126AC138DF4F21D8BB554176E09C0172126AC1D04D6298C7BB554140A4DF2271126AC15852277CC2BB5541', '0102000020110F0000120000001826530B97126AC11083C0660DBD554158A8357598126AC108D7A3DCF5BC55416C09F9F698126AC1C8C342A1EBBC55414CC8077199126AC178711B01E2BC5541FC87F40D9A126AC130FF2149C9BC554157EC2FA39A126AC128750222B3BC5541E86A2BBE9A126AC1D878E94E9BBC5541D6E76A6D9A126AC19018044E87BC554143AD69FC99126AC1A8BDC1C373BC55418638D63D99126AC138AB3E2F61BC5541304CA66898126AC1885AD3EC51BC5541C07D1D2C97126AC1A0F831EE3ABC554120D26FD592126AC1F0A7C6430EBC55410E2DB24390126AC1E83FA4A3F6BB554164CC5D318D126AC120D26F2FDFBB5541DE0209028A126AC130DD2466CABB554148BF7D1D87126AC118265335B9BB5541FA5C6D3B86126AC1306EA305B4BB5541', '0102000020110F0000120000004FAF94ADAF126AC19865885B13BD55416054521FB1126AC148BF7D4DFBBC5541BF0E9CA7B1126AC18838D68DF0BC55410A462531B2126AC1281895B4E5BC5541840D4FD5B2126AC1F0EBC0D5CBBC5541AA825171B3126AC10893A9AAB4BC5541E4A59B8EB3126AC1A001BCBD9ABC554163EE5A38B3126AC158D3BC6385BC5541F2D24DC0B2126AC150DA1BA470BC5541D7A370F1B1126AC1900F7A7A5CBC55413AB4C812B1126AC1205A648B4CBC5541C876BEB9AF126AC1886CE77B33BC55410C71AC21AB126AC1E8FBA93104BC554158CA3264A8126AC1701B0D00EBBB55414625750EA5126AC108B5A689D1BB5541FF21FD9EA1126AC1580E2D1EBBBB5541211FF49A9E126AC170CE8832A9BB554157EC2FB59D126AC1E80434EDA3BB5541', NULL, '0101000020110F0000CD05E4DA71126AC1A0E955A087BC5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1071, 300, 300, 9, 1, 6.61000013, 6.61000013, 6.61000013, '72nd Ave NB to NB', 0.959999979, 0, 1070, 1, 0, 2, '-122.74732:45.42603:-122.75382:45.43028', 0.5, 3, NULL, NULL, NULL, NULL, '2', NULL, '0102000020110F00001F0000005AD3BCFD88106AC168F7E43D57B45541EA95B27083106AC178F2B09046B4554110E9B7AF71106AC118D9CEF314B45541721B0DAA66106AC1E895B2B4F7B35541EA95B2285F106AC1109C33FEE4B355416B2BF63759106AC140BD5246D7B3554155302ACF55106AC110E02D6CCFB3554114AE47F351106AC1D8E76AFFC7B35541B7D1009A46106AC150962152B3B35541A913D0923F106AC13889411CA8B355419C33A26836106AC1701283149AB35541A0F8311231106AC1F02FBB9791B355411E38676230106AC1A03C2C8090B3554104E78C1029106AC1C07493C085B3554180B740741C106AC1C039232671B3554128A0898E19106AC1287502A66BB355416EC5FE1417106AC1B0506B3E66B35541D812F21715106AC1E8C0394B61B355413945471A12106AC150499D4459B355410F0BB5B20C106AC150AF94B54FB35541FCA9F1E203106AC1B837F8363BB355412C6519F4EE0F6AC1E0361A5CFAB255412FDD2472EC0F6AC168226C8CF2B255411C5A6475E90F6AC188855AC3EAB25541BC96909BE60F6AC1D0CCCC2CE4B25541EE5A42C4E30F6AC1009A084FDEB25541FC3A70D4DF0F6AC188635D4CD7B255410BB5A695D80F6AC1A8ADD853CAB255414ED19186CA0F6AC1B003E710BDB25541029A08F1C90F6AC1F0D24D82BCB25541BC74936EC80F6AC150A60A12BBB25541', '0102000020110F00001F0000003C4ED16581106AC1880D4F6B61B4554182E2C7EE7B106AC130992A0051B45541F263CC556A106AC140A4DFD21FB4554140A4DF765F106AC1B8C876FA02B45541F1F44A2758106AC148EA04C0F0B35541B840825452106AC15820414DE3B355419D11A5314F106AC158522714DCB355411FF46CB84B106AC158A83565D5B35541B4EA73AF40106AC1580E2D4AC1B355414A9D80F639106AC1C0E31491B6B35541C876BECD30106AC1204A7B8BA8B355411E3867662B106AC1A835CDF39FB35541CA32C4D92A106AC1780B24149FB3554192ED7C7B23106AC1C8A1454294B35541FF21FD6C16106AC1A01A2FED7EB3554133C4B10C13106AC16032558478B35541304CA62810106AC10868223472B355416C787AE10D106AC1203867886CB35541EE7C3F5B0B106AC1C8A145C265B355413CDF4F3106106AC1105839A05CB35541F54A5990FC0F6AC1907EFB3A46B355415CB1BF48E70F6AC1182FDD4C04B35541D2915CFAE40F6AC1F063CC1DFDB2554145477263E20F6AC1784F1E5EF6B25541C7BAB8E1DF0F6AC150742493F0B25541F0164874DD0F6AC190E4F28FEBB255418026C2C2D90F6AC158CA32FCE4B2554100917E7FD30F6AC1D812F2C5D9B25541F263CC9FC60F6AC1084625A1CDB255410A682206C60F6AC130D49A0ECDB255414872F983C40F6AC1E861A19ECBB25541', '0102000020110F00001F00000026E483E675106AC1E0361AD470B45541849ECD9070106AC1D8ACFACC60B45541AED85F345F106AC1E81DA74830B4554108AC1C9054106AC1A8BDC10B14B4554166F7E48B4D106AC1C05B208D02B4554121B072E647106AC1B8AF0383F5B35541FED4782D45106AC1F0EBC03DEFB355412E6EA34942106AC1E8E236AEE9B3554180B740BA37106AC108D7A370D6B355418204C57731106AC1689A7774CCB3554155302A5128106AC198081B72BEB35541EC9E3CD022106AC180D0B3B1B5B3554118B7D17822106AC1587DAE26B5B35541355EBA071B106AC108462539AAB3554185EB514C0D106AC1208E75C993B355418E976E3209106AC180FB3A008CB355412EFF21AD05106AC160C3D34F84B35541EC2FBBF502106AC178F2B08C7DB35541D0D5562401106AC1A835CDAB78B3554110E9B757FC0F6AC18026C22E70B355414AEA047AF10F6AC178F2B0E856B35541B88D06ACDB0F6AC1A8F1D25913B35541C7BAB8ABD90F6AC1D812F21D0DB355416EC5FEAED70F6AC108F016F007B355417A36ABB2D50F6AC1B0FA5C5903B35541B81E85E5D30F6AC130FF21A1FFB2554117485092D00F6AC1A88251B5F9B255418AB0E1CBCB0F6AC118B7D128F1B25541287E8CB7C00F6AC1805149B5E6B25541C0CAA117C00F6AC1F085C91CE6B255411E85EB95BE0F6AC110363CADE4B25541', '0102000020110F00001F00000093A9825D67106AC1E058174F84B455418D28ED3162106AC190976EC674B45541BA490C2251106AC130A2B41745B45541D812F2C746106AC1408B6C9F29B45541DC68002340106AC1A0703D0E19B45541F775E0B63A106AC1D8C56D880CB45541CA32C48338106AC10019737707B455413AB4C85C36106AC1F038455303B455412C431C672C106AC17858A82DF1B35541F8C264BA26106AC1D0D55620E8B3554126E483961D106AC1E07A1422DAB355415A643BF517106AC13055302ED1B3554108CE19E117106AC1E86A2B0ED1B35541C8293A5810106AC17858A8FDC5B355415A8638C201106AC1E895B228AEB3554134A2B4BDFC0F6AC120FDF6A1A4B3554104E78C6CF80F6AC1D05D4B349BB3554138674427F50F6AC1886CE70F93B355416D567D3AF40F6AC128287E9490B355413E0AD7E3EF0F6AC1506210E888B355415917B775E30F6AC1B8C876FE6BB355411895D4FDCC0F6AC1A023B96026B3554136CD3B60CB0F6AC160BA495821B3554144696F26CA0F6AC190976E261EB355415CB1BFD2C80F6AC120166A151BB35541A4703DD0C70F6AC1506B9AFF18B35541827346F4C40F6AC1E0361AE813B355415F984C0FC20F6AC170F085B90EB3554134A2B43FB90F6AC1608FC26906B355418AB0E197B80F6AC1C8BAB8C905B35541363CBD16B70F6AC1A067B35A04B35541', '0102000020110F000018000000E6D0226B46106AC108A39276B0B455414CC8079F41106AC100E78C0CA2B455410C93A93C31106AC1705F074274B45541E61DA78A27106AC1D8E76A875AB455410BB5A6BD21106AC1689A77104CB45541FC1873D31C106AC150158CB640B45541A5BDC1CF1B106AC1D04D62603EB45541ABCFD5541B106AC11851DA733DB45541E10B93BB12106AC16819E2C82DB455413CBD52620E106AC14850FCD826B45541C0EC9E4405106AC1B88D06E418B45541081B9EDEFF0F6AC1F0D24D4E10B45541BF0E9C1FF80F6AC1E86A2BEE04B45541764F1E9AE70F6AC1D0F753EFE9B35541CCEEC981E00F6AC1A8DFBE76DCB35541295C8F62DA0F6AC1808CB917CFB3554189D2DE40D70F6AC1400AD74BC7B35541F4DBD7A9D30F6AC180B740F2C0B35541C07D1DB0C30F6AC1C0E314C99BB35541E78C28B7AB0F6AC1B86B098151B3554141F163B4AB0F6AC188DB687851B35541E0BE0E52A80F6AC1507424474EB3554117485098A70F6AC1B8D100964DB35541FDF67518A60F6AC158CA32284CB35541', NULL, '0101000020110F00008DBF9CE547106AC19EF14EAEB5B35541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1072, 300, 300, 10, 1, 6.76999998, 6.76999998, 6.76999998, '72nd SB', 0.529999971, 1073, 1037, 1, 0, 3, '-122.7565:45.4291:-122.74866:45.42282', 0.5, 3, NULL, NULL, NULL, NULL, '21', NULL, '0102000020110F0000110000003CDF4FC974106AC1903A019D14B4554111363CA373106AC1F8A0675711B45541E4A59B7868106AC13870CE10F2B355413CBD52485E106AC130DD2412D9B355415E4BC83F56106AC1984C1530C8B35541A69BC4AC4E106AC1F8285CDFBAB35541E9B7AFCB47106AC15886380EAFB3554166F7E48137106AC1E07A14FE93B355418F53741431106AC1E8E236728AB35541FFB27B1A2D106AC138CD3B8A84B355416D567D4A25106AC1D0CCCCA478B35541BA6B09F721106AC1004D848172B355417EFB3A9E1E106AC1084625A16BB355418EE4F2C516106AC138014DF85AB3554190C2F55A14106AC190A9820555B35541C7BAB85712106AC1004D84F94EB355413E0AD7F30B106AC1E07A145A3AB35541', '0102000020110F00001100000038F8C29A7D106AC19899992508B4554165AA606E7C106AC1B8490CCE04B45541FBCBEE0971106AC1A011A5E5E4B355419EEFA75E66106AC1D0B359B9CAB3554122FDF6B75D106AC1907EFB8AB8B35541FFB27BBC55106AC10893A982AAB35541560E2DBE4E106AC188855A7F9EB35541DFE00B293E106AC1E8F21FF282B355417E1D387F37106AC178029A0C79B3554126E4839233106AC1D0D5563873B35541BD5296372C106AC18061320568B35541A0ABAD7A29106AC1381AC0F762B3554171AC8B6526106AC1F83A70A25CB35541273108E21E106AC1E8FBA9AD4CB3554144FAED091D106AC13889412448B355413EE8D9681B106AC158EC2F3F43B355415839B41C15106AC1B00C71EC2EB35541', '0102000020110F00001100000093A982AF83106AC138F8C28CFFB35541143FC67E82106AC1885AD328FCB35541462575F276106AC1D044D8D0DBB35541D2915CF26B106AC100E78CD4C0B35541E4A59BDE62106AC1708104C1ADB35541E258179B5A106AC1C0C1173A9FB355412E90A08853106AC1E826311493B3554171AC8BBF42106AC1E895B23077B3554173D712EC3B106AC16010580D6DB35541DDB5840838106AC1C820B04667B3554185EB51FE30106AC1489D808E5CB35541A3923AA92E106AC108D7A34058B3554138F8C2C22B106AC1E8C0394B52B3554134A2B47924106AC1E861A1D242B35541F831E60623106AC120F46C423FB3554193A982A921106AC1806ABC283BB35541EC2FBB6D1B106AC1B047E10A27B35541', '0102000020110F00001100000089D2DEE495106AC1304CA6CEE5B355412C431CA794106AC108B5A645E2B3554142CF66A388106AC1E04F8D9FC0B355413D9B55A57C106AC100F77534A3B35541923A014B72106AC1606DC5728DB35541A679C72F69106AC1C854C1707DB35541FE65F7E061106AC1F03845E370B3554185EB517C50106AC148BF7DFD53B355419E80262C49106AC100DE022149B35541DA8AFD6345106AC1986E128343B3554126C2864B3F106AC1009A083B3AB35541F1F44A2D3E106AC11873D72A38B3554197FF90D23B106AC1708A8E5433B3554104E78C3835106AC1F0A7C64F25B3554172F90FF534106AC1F0EBC0A924B3554188635D6234106AC1280F0BF122B35541506B9A572E106AC1287E8C710FB35541', '0102000020110F00000E000000B7D10028AA106AC190C2F528C9B355418048BFDBA8106AC1100BB576C5B35541C4D32B539C106AC1F0FDD45CA2B35541DA3D793A8F106AC1C8DCB53C82B355415AF5B97483106AC190ED7C7F69B35541D85F766979106AC1E83FA4D757B3554192ED7CD771106AC120EBE2D64AB35541355EBAC55F106AC1E873B5D12CB3554116FBCBEA57106AC1E8C0392721B3554152B81E4154106AC1C03099B61BB35541E6D0224D4F106AC10088F42B14B35541529621B24D106AC1782497DF10B3554196438BA648106AC10066F72806B3554176E09C6343106AC19087852EF5B25541', NULL, '0101000020110F000006CDD10B21106AC1ACEB3E9E70B35541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1073, 300, 300, 10, 1, 5.94999981, 5.94999981, 5.94999981, '99W EB to SB', 0.829999983, 1074, 1072, 1, 0, 2, '-122.76939:45.43895:-122.75651:45.42908', 0.5, 3, NULL, NULL, NULL, NULL, '20', NULL, '0102000020110F000014000000CC7F489D0B116AC1E8FBA9797CB55541DF4F8D1909116AC158302A9978B555411895D44D00116AC1D088D26A6AB555415839B4F0F8106AC1C0D32BD55DB55541295C8F48F3106AC1782D214F54B55541D4BCE364F0106AC1400AD7B34EB555418A8EE4E8EC106AC108560EF147B55541847CD053E5106AC1D878E96E3AB55541A2D634E1D9106AC10066F71825B5554140A4DFA8CF106AC160FE43820FB5554126C28677C4106AC1900F7ACEF5B45541787AA5DABF106AC1D066D57BEAB4554116FBCB28BE106AC160E5D052E6B45541645DDCE0B5106AC170B515BFCFB45541F0A7C6D3AB106AC14837893DB4B45541168C4AD0A4106AC1C8B12E829FB45541075F98C090106AC1587DAE9E64B45541D85F76B586106AC1B8F3FD9047B45541E6AE251881106AC1880D4FAB37B455413CDF4FC974106AC1903A019D14B45541', '0102000020110F000014000000DA8AFD2F12116AC170C5FE4E6BB55541705F07C40F116AC1A05E299367B5554148E17A2E07116AC158CA32BC59B55541302AA9E7FF106AC1E895B24C4DB5554188635D82FA106AC1E8C0393744B5554111C7BAE4F7106AC188F4DB233FB555414625753EF4106AC1986E120F38B5554175029A94EC106AC10088F4672AB5554126750278E1106AC1F8C264B215B55541C6DCB5A2D7106AC190C2F5EC00B55541B437F8B4CC106AC1E0B584D4E7B455413C2CD434C8106AC100F775C8DCB455418BFD65AFC6106AC128287E0CD9B4554124287E92BE106AC178C729EEC2B45541DBF97EA4B4106AC1F063CCC1A7B455419C33A2BAAD106AC1C8A1455293B45541029A08A399106AC1D066D55758B45541E02D908A8F106AC11071AC233BB455411E166AE789106AC170F0852D2BB4554138F8C29A7D106AC19899992508B45541', '0102000020110F00001400000041F163B816116AC140F163785FB55541CE88D25C14116AC18838D6D55BB55541E561A1EC0B116AC1E8D0223B4EB555410EBE30B504116AC1D812F2E541B55541925CFE7DFF106AC198081B1E39B5554155C1A810FD106AC1D83D796834B55541A3923A4DF9106AC1088A1F1B2DB55541280F0B95F1106AC1B840825A1FB55541F0A7C6B3E6106AC150F38E130BB55541A69BC422DD106AC190976EDEF6B455410BB5A663D2106AC1E0141D31DEB4554186C954F7CD106AC1385EBA55D3B45541B9FC8790CC106AC10066F7E4CFB455415F984C91C4106AC1E0C79817BAB45541363CBDB8BA106AC10044FA259FB455414C158CE0B3106AC1383CBDEA8AB4554100917EC39F106AC1D83D79E04FB4554161C3D3A195106AC180C0CA9132B45541E61DA7FA8F106AC160BA499022B4554193A982AF83106AC138F8C28CFFB35541', '0102000020110F000014000000B37BF24A24116AC1C832C4053CB555416C9A772022116AC1401CEBAE38B555419CC420201A116AC13090A0C82BB555411283C01613116AC138CD3BC21FB55541068195690E116AC1D088D2E217B55541F775E08C0C116AC1607FD94514B55541E6AE257208116AC110022B4F0CB5554104560E8F00116AC1803F3542FEB45541D6E76A5FF6106AC1F83A7046EBB45541F831E69AED106AC1D02B65C1D8B4554166886367E3106AC1885AD354C1B4554143AD6936DF106AC1C88F310BB7B45541F46C562BDE106AC1C00E9C7BB4B4554190C2F584D6106AC158C1A8A09FB45541508D97ECCC106AC1B0BFEC5E85B455413CDF4F49C6106AC1A82C43C071B455416A6FF01BB2106AC130D49A8636B4554111C7BADEA7106AC1701283E818B45541B6627F2BA2106AC1708104C508B4554189D2DEE495106AC1304CA6CEE5B35541', '0102000020110F000014000000D26F5F6533116AC16844699314B55541B81E857131116AC1D0CCCC9011B555417958A8ED29116AC1F038457305B555414C37891723116AC100E78CC4F9B4554190A0F8031F116AC1604BC8E7F2B455417D3F35C81D116AC130431C83F0B45541F48E534C19116AC1905CFECFE7B4554148BF7D3911116AC1C0C1176ED9B45541014D84CF07116AC11873D7E2C7B45541E02D90EEFF106AC130D49A3EB7B455418CDB6856F6106AC1D8F0F436A1B45541B5A67967F2106AC1D8D7818F97B45541226C78C2F1106AC170567DFA95B4554123DBF97EEA106AC1F0F44A2D82B4554104780B2EE1106AC160DC46AF68B4554154E3A5C5DA106AC18816D9BE55B4554108AC1C86C6106AC100F775501AB45541C9E53F2ABC106AC1B8D1005AFCB35541083D9B69B6106AC1A0ABAD10ECB35541B7D10028AA106AC190C2F528C9B35541', NULL, '0101000020110F000011C8BE71B7106AC1D45A0B04D4B45541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1075, 300, 300, 10, 1, 4.3499999, 4.3499999, 4.3499999, 'Scholls Fy SB', 0.800000012, 1076, 1074, 1, 0, 2, '-122.78506:45.45567:-122.78282:45.44625', 0.5, 3, NULL, NULL, NULL, NULL, '18', NULL, '0102000020110F00001D0000007AA52CF9FB116AC1888EE45E34B85541CD3B4EEFFB116AC1409B555B31B85541627FD913FC116AC158EC2FE316B855418273464EFC116AC1E83FA4D7FFB755418048BF2BFC116AC1401CEBC6EAB755410AD7A30EFC116AC1283108B8D3B75541A089B09FFC116AC1F0164894A4B7554188635DEAFC116AC1A01A2F1D92B7554143AD69D0FC116AC158C1A85485B755416C787A93FC116AC108B5A6D17AB75541B29DEF51FC116AC1009A082372B75541C2A8A42CFC116AC1C09F1A1B6EB75541226C78C8FB116AC12853054763B75541F48E532AFA116AC190ED7C3B4FB7554152B81E2DF8116AC1A0F8315A3DB7554162A1D688F5116AC1684DF36229B7554176E09C1BED116AC1B8A679EBF3B655419A779C32EC116AC100DE02C1EDB655415839B45EE8116AC1905CFEA3D3B65541DFE00B37E6116AC1E04F8D2BC8B65541AA82510BE4116AC1784F1E4ABEB65541E09C11F9E1116AC178931854B5B6554187A7578EDF116AC168F7E441ADB65541819543CFDC116AC1F0B0507FA4B6554127310814D9116AC170C5FEB69AB655419EEFA768D5116AC15040130D93B655410F0BB59CD0116AC1C0A8A4AA8AB655412ACB10CBC9116AC1F831E65E80B655415CFE4300C9116AC1A0CDAA4B7FB65541', '0102000020110F00001D000000DAACFAC206126AC13090A0D033B85541666666BA06126AC1580E2D3231B8554136CD3BDE06126AC180FB3A3817B8554114AE471907126AC170B515EBFFB75541A0F831F606126AC188F4DB87EAB75541726891D906126AC1D8E76ADFD3B755417AA52C6907126AC168D5E72EA5B7554198DD93B507126AC120A7E84892B755411E85EB9907126AC1C820B0AA84B75541A62C435A07126AC1984C15B079B75541B840821607126AC1809ECDB670B755414082E2EF06126AC178C7298A6CB755416519E28206126AC1109C33C260B755417C832FC404126AC198559F234BB75541C4D32BA902126AC1E0E9953638B75541C13923E6FF116AC1E8D0225723B755412497FF6CF7116AC148E17A94EDB65541D656EC8BF6116AC1C8EEC99FE7B6554134A2B49BF2116AC1607FD9C1CCB6554106121435F0116AC1A86054FABFB655415A8638E0ED116AC138D6C55DB5B65541CB10C784EB116AC1E8D0222BABB655418E7571BFE8116AC1881F63EAA1B65541A679C7ADE5116AC1B00C712098B6554181954347E1116AC198E61D978CB65541234A7BDBDC116AC1D06F5F5B83B65541DA3D7968D7116AC190C2F5D479B6554158CA3210D0116AC1B059F5BD6EB65541C7BAB80BCF116AC100F7755C6DB65541', '0102000020110F00001D000000287E8C330E126AC100B37B6E33B8554188F4DB2B0E126AC1608FC21531B85541EA04344F0E126AC18816D97217B85541A0ABAD8A0E126AC100F775F8FFB7554158A835670E126AC1D0D5565CEAB75541D578E94A0E126AC1B8B88DFAD3B7554126C286D90E126AC128068199A5B75541098A1F270F126AC198F6066792B75541F016480A0F126AC1B0EA733584B755415CB1BFC80E126AC188635DE878B75541903177830E126AC1E0C798BB6FB75541D656EC5B0E126AC1306EA3756BB75541ABCFD5E80D126AC1280681055FB7554132E6AE130C126AC1D8ACFA5048B7554108AC1CE409126AC1186A4DAB34B75541643BDF0B07126AC110E9B72B1FB7554126E4838AFE116AC1A0923A35E9B655411EA7E8AEFD116AC1083D9B65E3B655410C022BABF9116AC15005A302C8B655419BE61D19F7116AC100780B54BAB655411DC9E5A7F4116AC168DE7136AFB655414872F919F2116AC190317729A4B655419E802616EF116AC1984C15189AB655414C3789CBEB116AC1E0B584988FB65541B003E7EEE6116AC108C58FD982B6554144696FFEE1116AC110C7BA8878B65541A2B43718DC116AC190C2F5386EB6554150FC1863D4116AC1F063CC9562B655413EE8D936D3116AC1A86054FE60B65541', '0102000020110F00001D000000DA3D797A24126AC1B8847C4832B855416ABC747524126AC1B8FC87C030B855413D9B559724126AC1E8E2362218B8554106F016D424126AC118C05B2000B85541B5A679AF24126AC188B0E1D9E9B7554130992A9424126AC1A0CDAA4BD4B75541CEAACF1F25126AC100E78CD8A6B755416C09F97025126AC108560EC192B7554199BB965025126AC1A0703DD682B75541B22E6E0925126AC1C8B12E9276B7554198DD93BF24126AC1A84E40CB6CB75541CC7F489524126AC170787A3968B75541FC87F40F24126AC138D6C5D159B75541726891F721126AC1903A01DD3FB75541D6C56D8A1F126AC14825750E2AB755410E4FAF721C126AC1401361AF12B75541EC51B8D813126AC1C042AD1DDCB6554192ED7C0D13126AC170F90FBDD6B655415EDC46CF0E126AC1381AC0CBB9B65541C58F31BB0B126AC138674469A9B65541280F0BF508126AC1A80A46C99CB655416B2BF6CF05126AC1002B872E8FB6554194F6061102126AC1D8C56DAC82B65541D2DEE01BFE116AC198B20C0D76B65541DF4F8DDDF7116AC10022FDAE65B65541A679C75FF1116AC148E17A2058B65541508D9720EA116AC16007CE754BB6554147037855E1116AC1907EFB2E3EB65541529621B2DF116AC1D89AE6F53BB65541', '0102000020110F00001D00000016FBCB443D126AC108560E0131B855411283C0423D126AC190B96B6130B85541923A01633D126AC178711BE518B85541A01A2FA13D126AC128287E4C00B855418251497B3D126AC120B07248E9B755412B8716613D126AC17858A8A5D4B75541B22E6EE93D126AC1D0F7533BA8B75541BBB88D3E3E126AC1B8F3FD2493B755415A86381A3E126AC1C017264F81B7554116FBCBCC3D126AC1388941F873B755411A51DA7D3D126AC1C832C48569B7554124287E503D126AC198559F9F64B75541645DDCB63C126AC100098A0754B755410AF9A0533A126AC1787AA57436B7554190A0F8A137126AC1605DDC3E1EB75541BADA8A4334126AC1E8E236CA04B75541EA26318E2B126AC1604BC88BCDB65541E8482ED52A126AC1100BB5A6C8B655411DC9E55526126AC108AC1CFAA9B6554150FC18B122126AC180D0B39596B65541D6C56D8C1F126AC158D3BC4788B65541772D21BF1B126AC148BF7DD577B6554122FDF62F17126AC180FB3A9C68B65541029A087D12126AC1A045B69F59B65541BE9F1AB50A126AC1482EFF3945B655413333337D02126AC1A82C431034B655419CC420BEF9116AC1100BB5C624B655419D11A5BDEF116AC1B003E7AC15B65541A679C795ED116AC120B9FCBF12B65541', NULL, '0101000020110F0000134D7B8CF8116AC1346968B340B75541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1077, 300, 300, 10, 1, 3.11999989, 3.11999989, 3.11999989, 'Denney Rd SB', 0.419999987, 1078, 3177, 1, 0, 2, '-122.78757:45.47396:-122.78612:45.46343', 0.5, 3, NULL, NULL, NULL, NULL, '16', NULL, '0102000020110F00000A0000005474242B13126AC178249703A2BA55419A081B9612126AC1C017261B9DBA5541ECC0395B11126AC198779CDE8CBA55417A36ABDA10126AC1D0DEE0AB7ABA554190A0F8B710126AC1B837F8A66ABA5541FA5C6DCB10126AC1E8AE25AC58BA554138F8C21C11126AC1E8D0223742BA55415839B42E11126AC120EBE2163BBA55416C09F97C11126AC1C09F1A031CBA5541A835CD8112126AC1F8EDEB44D1B95541', '0102000020110F00000A00000048BF7DAB1D126AC1487B83FF9CBA55414694F6301D126AC1C03099F698BA5541772D211B1C126AC1880D4FA38ABA55413AB4C8A41B126AC1B02E6EE379BA5541726891831B126AC188FD658F6ABA5541DA3D79961B126AC1D019511259BA55413D9B55E71B126AC190CB7FBC42BA5541DCD781F91B126AC1D05D4B843BBA5541DE9387471C126AC178E09C851CBA5541BC74934C1D126AC108560EB1D1B95541', '0102000020110F00000A0000008BFD65E924126AC190A0F88999BA554179E9268124126AC1A0D6341B96BA554189D2DE8423126AC1D03B4E1989BA55412A3A921523126AC158302A5979BA5541D26F5FF522126AC130431C7F6ABA55411DC9E50723126AC158B1BF5859BA5541FC3A705823126AC1B00C711843BA5541EFC9C36A23126AC1A045B6CF3BBA5541C0EC9EB823126AC198DD93DF1CBA5541847CD0BD24126AC1506B9AFBD1B95541', '0102000020110F00000A000000BE3099983A126AC1C8293A2E8FBA554108CE19673A126AC1E024068D8DBA55413D9B55B739126AC18841607D84BA55415474245D39126AC1480C02BB77BA55416EA3014039126AC13055304E6ABA55411C5A645139126AC190ED7C2B5ABA5541FE65F7A039126AC17824972B44BA55411461C3B339126AC140CF66B13CBA5541E4141D013A126AC1885AD3EC1DBA55415CB1BF063B126AC10893A9DAD2B95541', '0102000020110F000009000000D85F76C552126AC17034800784BA5541D200DE6A52126AC15062105C7FBA55410DE02D2852126AC1D022DBED75BA55418F53740E52126AC190ED7C176ABA5541E2E9951E52126AC110A5BD155BBA554174B5156D52126AC1004D845D45BA55416666668052126AC1F01648AC3DBA55410EBE30CD52126AC178832F181FBA5541AA8251D353126AC178BE9FD2D3B95541', NULL, '0101000020110F00002F0B9D8E11126AC1BA2300F516BA5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1078, 300, 300, 10, 1, 2.54999995, 2.54999995, 2.54999995, 'Allen Blvd SB', 0.600000024, 1079, 1077, 1, 0, 2, '-122.79257:45.48246:-122.78753:45.47394', 0.5, 3, NULL, NULL, NULL, NULL, '15', NULL, '0102000020110F000012000000F697DDDF5F126AC108C58F51CEBB554161C3D3B95D126AC1A857CAB2C1BB55413E7958C452126AC17081045D90BB5541789CA2CB49126AC128C286236DBB5541423EE83944126AC1A80A46D559BB5541BC74930440126AC1E861A13E4BBB5541295C8FE036126AC150B81E292EBB554154E3A5152F126AC1285C8FF613BB5541DE0209A227126AC138EF38D1FCBA554101DE022B22126AC1D8F97ED6E8BA55411C5A64DF1E126AC1D812F261DDBA554154E3A5251C126AC178BE9F1AD3BA554138F8C2A019126AC100780B10C8BA55415AF5B9C618126AC1F07C3F35C4BA55411E3867A017126AC1E04F8D63BEBA5541A167B37015126AC108A3927EB2BA554126E4832814126AC170AC8B5BAABA55415474242B13126AC178249703A2BA5541', '0102000020110F000012000000EF3845176A126AC150499D50C7BB5541D634EFC867126AC1F07C3FC5B9BB55411283C0825C126AC148E17A0487BB5541E9B7AF4753126AC1C0A8A4C662BB5541EEEBC0914D126AC170C5FEFA4EBB55415452274249126AC1D0B3590940BB5541C8293A1440126AC1B00C71D422BB554196218E4138126AC168B3EA8708BB5541280F0BE930126AC140A4DFB6F1BA5541F1F44A932B126AC188B0E135DEBA5541E561A15028126AC1701283E0D2BA5541B88D06D425126AC1F01FD27FC9BA554140355E7823126AC1482EFF29BFBA5541668863BB22126AC1100BB5D2BBBA55410AF9A0B521126AC1F853E3A5B6BA554124B9FCA71F126AC13845477AABBA5541C286A7911E126AC1C876BE93A4BA554148BF7DAB1D126AC1487B83FF9CBA5541', '0102000020110F00001200000040A4DF2271126AC15852277CC2BB5541ED0DBEB86E126AC1C0CAA14DB4BB5541D578E93A63126AC1E0718A9280BB5541984C15D259126AC1C0D32BA15BBB5541A01A2F0354126AC1E0E00B7F47BB5541470378A14F126AC1A0EFA74E38BB55410F0BB56C46126AC108F016041BBB5541567DAE943E126AC17858A8A500BB55411A2FDD4E37126AC1383CBD0EEABA5541E0BE0E1032126AC180D0B3E1D6BA55412A3A92D32E126AC18838D6A1CBBA55412EFF21812C126AC178832FE0C2BA5541D49AE6412A126AC1480C0207B9BA554190C2F59829126AC140AD690AB6BA5541302AA9A928126AC1A8C64B4FB1BA5541DCD781B326126AC1487B83A3A6BA55414EF38EBF25126AC1C8073D97A0BA55418BFD65E924126AC190A0F88999BA5541', '0102000020110F000012000000FA5C6D3B86126AC1306EA305B4BB55412AA9137E83126AC1E0E995EEA3BB55412CF6975977126AC120FDF6456DBB5541A401BC676D126AC198F6063B46BB55412AA9134E67126AC120FDF61531BB5541C07D1DB662126AC130E6AE2921BB55411CEBE26C59126AC13845479E03BB554162A1D68451126AC138CD3B0AE9BA55414850FC764A126AC1B0FA5C21D3BA55411CEBE27C45126AC1585BB1EFC0BA55414260E55242126AC180FB3AF0B5BA55413480B77E40126AC1C810C70AAFBA5541C0EC9E943E126AC1402CD4A6A6BA5541C442AD273E126AC16007CEB9A4BA5541789CA27B3D126AC1088A1F53A1BA5541847CD0CB3B126AC198081B2698BA55413C2CD43E3B126AC188855AA794BA5541BE3099983A126AC1C8293A2E8FBA5541', '0102000020110F00001100000057EC2FB59D126AC1E80434EDA3BB554135EF389B9A126AC128E483B691BB5541A60A46BD8D126AC160C3D3CB57BB55418C4AEA3283126AC130C4B16A2EBB554196900FC67C126AC12806812518BB5541355EBAF177126AC1780B246807BB55417E8CB9916E126AC128189594E9BA5541F4DBD79766126AC16819E2C4CEBA5541827346C85F126AC130E6AE9DB9BA55410AD7A31A5B126AC1808CB983A8BA55415A643B0558126AC140FAEDCB9DBA554104C58FBD56126AC168AA60F898BA55417D3F353255126AC1A8BDC13392BA554195D4090855126AC1F8EDEB7491BA55418716D9A654126AC1C0E314898FBA5541D578E93253126AC148B6F3A187BA5541D85F76C552126AC17034800784BA5541', NULL, '0101000020110F0000961C375838126AC1573963D432BB5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1080, 300, 300, 10, 1, 0.75999999, 0.75999999, 0.75999999, 'Walker Rd SB', 0.519999981, 1111, 3156, 1, 0, 3, '-122.78644:45.50367:-122.79227:45.49134', 0.5, 3, NULL, NULL, NULL, NULL, '13', NULL, '0102000020110F0000110000001CEBE22E24126AC1B8AF03333DBF554158A8350B2C126AC1F875E06030BF55411C0DE06532126AC1A0703D3A25BF5541FA7E6A9C37126AC1B003E72C1BBF5541744694D83A126AC1585BB1B713BF554172F90F4741126AC1F853E32905BF55412C65191C45126AC150158C32FABE55412E6EA30948126AC1306EA3F5F0BE5541FA0FE9A14A126AC1C042ADCDE6BE5541AE69DEF34D126AC188EB51D0D7BE55415CB1BFE250126AC1D0915CE6C6BE5541D0B359CD51126AC15817B79DC1BE5541A9A44EE653126AC1C876BE97B0BE55415AF5B9D255126AC1B047E1169ABE5541842F4CBC57126AC14859866C79BE554133C4B1D258126AC1C87F483767BE55415EDC46F159126AC118D9CEAB50BE5541', '0102000020110F00001100000018B7D1FE2A126AC1A8A44E044EBF55413E0AD70133126AC1480C02F340BF5541AC8BDBB239126AC1D0CCCC3435BF554101DE02713F126AC12085EB212ABF55417CD0B3F542126AC1D81B7C0522BF55413A014DC449126AC1784F1E9E12BF55419B559F174E126AC1B0FA5C3D06BF554120D26F6B51126AC1102DB2BDFBBE5541A3923A6154126AC150E3A527F0BE55410C022B0158126AC1784F1ECADFBE5541423EE8155B126AC1C8BAB805CEBE5541728A8E2A5C126AC1E0E995CAC7BE5541F016487A5E126AC1F80FE907B5BE5541492EFF8360126AC1D8CEF72F9DBE5541575BB17562126AC1803F35FA7BBE5541B437F88E63126AC188DB689469BE55417A36ABAC64126AC170D7121A53BE5541', '0102000020110F000011000000470378B12F126AC118AE479D59BF55417AA52CCF37126AC1D8C56D604CBF554112A5BDBB3E126AC1102DB23940BF55411E166AD744126AC14825757234BF5541E4F21F8E48126AC130C4B1E22BBF5541923A019F4F126AC1F0F44AE51BBF55416744694954126AC138234A8B0EBF5541EEEBC0E357126AC198B20C2D03BF5541DE02091A5B126AC1E0718A9AF6BE5541EEEBC0EF5E126AC1C039234AE5BE554175029A1E62126AC1C09F1AEFD2BE55415B423E5063126AC1F00DBE0CCCBE55415AD3BCC565126AC1205A6417B8BE5541C286A7E367126AC1D000DE529FBE5541B37BF2DA69126AC190C2F5BC7DBE55417D3F35F66A126AC1C042AD356BBE5541166A4D136C126AC1A05E29C754BE5541', '0102000020110F0000110000007CF2B0C23D126AC1907571577CBF5541842F4C3046126AC110E02D986EBF554132772DCF4D126AC1D8C56D3861BF5541F775E00255126AC1E0141D5553BF554188855A4F59126AC10000006C49BF5541C6DCB52661126AC188C954AD37BF5541AE69DED566126AC14850FC6827BF5541F9A067436B126AC1A82C437019BF554182E2C73A6F126AC1A879C7E909BF5541B81E85B173126AC1E8F21FC2F5BE554170CE882E77126AC1B88D06A4E1BE55416EC5FEB678126AC16891EDCCD8BE55417268919D7B126AC1C8C34241C1BE55416B2BF6F77D126AC1A8A44EB8A5BE55414AEA040080126AC170CE880283BE554135EF382181126AC14894F61670BE5541006F813C82126AC11851DACB59BE5541', '0102000020110F000011000000AA60546A4D126AC108D7A3FCA2BF55413EE8D93056126AC158423EAC94BF55417AC729965E126AC1780B24F085BF5541DA1B7C0167126AC1F0A7C6B375BF554177BE9FF46B126AC11804564A6ABF55411973D7A874126AC1E8B7AF9756BF5541E86A2B7A7B126AC138F8C21443BF5541C6DCB5D280126AC140BD523632BF554190C2F5A085126AC1E0718A661FBF554140A4DFCA8A126AC17068911508BF55411A2FDD9E8E126AC148BF7D01F2BE55418D28ED8790126AC178E926FDE6BE5541CE1951EC93126AC1E04F8D73CBBE55410000008A96126AC138CD3BD6ACBE55410F0BB5A498126AC1C07D1DE088BE5541DDB584CC99126AC148D8F08475BE55415E4BC8E59A126AC1A0923A615FBE5541', NULL, '0101000020110F000071F88A5540126AC1845A6B4C07BF5541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1076, 300, 300, 10, 1, 3.5, 3.5, 3.5, 'Hall Blvd SB', 0.479999989, 3177, 1075, 1, 0, 3, '-122.78616:45.46328:-122.78616:45.45567', 0.5, 3, NULL, NULL, NULL, NULL, '54', NULL, '0102000020110F00000E00000058A8352512126AC110143F124BB95541CE88D20212126AC150D1914C48B95541894160450F126AC148E17A5C22B955417AC7296A0D126AC1F02FBB5B0EB95541925CFED30B126AC150158C26FEB855413480B73E06126AC1587DAE0AD5B855413255305203126AC1B0EA7375BAB855414AEA042401126AC150DA1B60A5B85541E2581765FF116AC1986E12978DB85541605452F3FD116AC130431C1773B855413E575B49FD116AC1706891E966B855418CB96B0BFD116AC1D03B4E7962B85541BADA8A41FC116AC1201FF4784AB855417AA52CF9FB116AC1888EE45E34B85541', '0102000020110F00000E0000003A234AE31C126AC17858A8F948B9554152499DBA1C126AC1384547B245B95541F4DBD7EB19126AC1907EFBD21EB955418EE4F20318126AC1607FD9490AB95541D656EC5716126AC1E8FBA935F9B855412FDD24BA10126AC128C286DBCFB855418AB0E1DF0D126AC1104FAFECB5B855415227A0C50B126AC1E0361A98A1B85541FBCBEE190A126AC1280681D58AB85541EC2FBBAD08126AC1388941BC70B85541371AC00308126AC1A067B38E64B855415EBA49CC07126AC160984C9560B8554146B6F30907126AC188855A7B49B85541DAACFAC206126AC13090A0D033B85541', '0102000020110F00000E0000008204C54B24126AC17824978747B95541CA54C11E24126AC1F0C9C3E643B9554195D4094421126AC1B84082621CB955418BFD65531F126AC1409B557B07B95541F2D24D981D126AC140575BCDF5B855419EEFA7F417126AC160BA4948CCB855416EC5FE2615126AC110E02DCCB2B855416C9A771A13126AC1485986FC9EB8554195D4097C11126AC168D5E7EE88B85541C442AD1310126AC1B8847C1C6FB85541E9B7AF690F126AC1B0BFECEE62B85541C420B0360F126AC100917E475FB8554196218E790E126AC148696FCC48B85541287E8C330E126AC100B37B6E33B85541', '0102000020110F00000E0000006C9A777A3A126AC1409B553343B95541FDF675403A126AC1587DAE863EB955416B2BF64137126AC128287E1415B95541772D213735126AC130A2B413FFB85541B003E74E33126AC110363C99EBB8554132E6AE992D126AC1506B9A93C1B85541EEEBC0F12A126AC1B8270F6FA9B855413E79580E29126AC14847722D97B8554154E3A59727126AC1C8BAB83D83B85541F085C93A26126AC188FD653F6AB8554138F8C29025126AC1F063CC115EB855419CA2236B25126AC1887CD05F5BB85541742497BD24126AC1485986C046B85541DA3D797A24126AC1B8847C4832B85541', '0102000020110F00000E00000016D9CE2953126AC180C0CA613EB95541F46C56E152126AC1E058178B38B955414A0C02BB4F126AC110F241F30CB95541DD2406934D126AC1288716B9F5B85541E02D90784B126AC1580E2D3EE0B85541CCEEC9AF45126AC1D81B7CA9B5B855411A51DA3143126AC110F241039FB85541EBE2367C41126AC1C074937C8EB8554112A5BD3140126AC1B025E4E77CB855417B14AEE13E126AC1E00B93D564B85541E4839E373E126AC12041F1A758B855411CEBE2203E126AC1C09F1A0757B855417CF2B0843D126AC180D93D7944B8554116FBCB443D126AC108560E0131B85541', NULL, '0101000020110F00002667881A10126AC1C8C3CEE32DB95541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (1037, 300, 300, 10, 1, 7, 7, 7, 'ORE 217 WB to SB', 0.610000014, 1072, 0, 1, 0, 2, '-122.74868:45.42279:-122.74476:45.41651', 0.5, 3, NULL, NULL, NULL, NULL, NULL, NULL, '0102000020110F0000140000003E0AD7F30B106AC1E07A145A3AB35541AC1C5A6E0A106AC1E09C117135B355410AD7A30AFF0F6AC12063EEFA0EB35541CE1951DCF90F6AC148E17A08FEB25541ECC03959F30F6AC168DE7106EAB2554126E483BAE50F6AC158204165C3B255415C8FC239E30F6AC16819E2F0BBB25541AC1C5A3CE00F6AC170348073B2B2554120D26F5DDD0F6AC17893182CA8B255411826534BD50F6AC1186A4DDF8AB255411C0DE035D30F6AC19087851281B255412B871615D20F6AC1B8847C9C7AB2554199BB96CCD00F6AC138EF385572B25541FA5C6D81CF0F6AC1A001BC4569B255415A86387ECE0F6AC198F606C361B25541B6847CBECD0F6AC168BC747F5AB2554187A75740CD0F6AC170787AF552B25541174850E4CC0F6AC120B072AC4BB255416B2BF651CC0F6AC150158CF240B255410E2DB2C9C90F6AC1283A928BFEB15541', '0102000020110F0000140000005839B41C15106AC1B00C71EC2EB35541643BDFA513106AC18026C2322AB3554140355E4608106AC1B8AF03CB03B355411E166AF902106AC190537474F2B25541645DDC44FC0F6AC170CE88DADDB255410E4FAF9AEE0F6AC14850FC18B7B255416EA30142EC0F6AC148EA041CB0B2554130BB2781E90F6AC140A4DF5EA7B255412041F1C9E60F6AC1E8FBA9A59DB25541E8FBA9FFDE0F6AC16007CE5D81B2554113F24145DD0F6AC180D93D3D79B25541D578E952DC0F6AC1582041D173B255419F3C2C22DB0F6AC1D0F753236CB25541A2D634E5D90F6AC1409B557763B25541BA6B09FDD80F6AC110363CBD5CB2554111C7BA62D80F6AC13880B7E456B2554192ED7CF7D70F6AC198C4207C50B255415839B49ED70F6AC14060E57449B2554176E09C0FD70F6AC100F775F83EB255416ADE718AD40F6AC140E8D9E4FCB15541', '0102000020110F000014000000EC2FBB6D1B106AC1B047E10A27B355414A0C02011A106AC11895D47122B355411E3867A40E106AC170A30114FCB25541AA60544209106AC188DB6878EAB255419ECDAA6B02106AC1608FC275D5B25541068195B9F40F6AC1D89AE69DAEB2554196438B7CF20F6AC1F03845F3A7B25541B4EA73E5EF0F6AC130C4B1BA9FB25541E4839E49ED0F6AC170AC8B6396B25541AE47E1B0E50F6AC198559FCF7AB2554113F24135E40F6AC160EE5AD673B25541FCA9F162E30F6AC11895D4216FB2554199BB9642E20F6AC17858A8DD67B255416744690FE10F6AC1384547765FB255414082E239E00F6AC1B840824659B25541668863B9DF0F6AC118C05B6854B255410EBE305BDF0F6AC1409B55C74EB255415305A304DF0F6AC100D578ED47B25541F263CC77DE0F6AC1B02E6E9B3DB25541A69BC4F4DB0F6AC1D03B4EC1FBB15541', '0102000020110F000014000000506B9A572E106AC1287E8C710FB35541547424092D106AC1803F353A0BB35541A3923AB521106AC1286519FAE4B25541423EE8131C106AC13892CB8FD2B25541BE9F1AD714106AC100098A53BCB255416210580D07106AC1F875E03895B25541E09C112305106AC1183FC6848FB255412653050903106AC1A0A223D988B255417AA52CBF00106AC198559FA780B25541CB10C7BAF90F6AC170567D2E67B255419E5E29FBF80F6AC120166AA963B255418026C288F80F6AC1A0703D1A61B25541FED47899F70F6AC180AEB6125BB25541BF0E9C83F60F6AC1A89BC47853B2554168B3EAE5F50F6AC1107A36E74EB255413480B7B2F50F6AC1C898BBF64CB25541E10B937BF50F6AC138234AAB49B25541EA73B52BF50F6AC118AE475943B25541BF0E9CA5F40F6AC178C7298639B255414850FC28F20F6AC1A03C2C58F8B15541', '0102000020110F00001000000076E09C6343106AC19087852EF5B25541F4FDD43642106AC1F80FE963F1B2554199BB96EC36106AC1182FDD44CBB25541AE47E10431106AC128A089F4B7B255418CDB685629106AC1F0B0505BA0B25541A9A44E721B106AC160764FF678B25541529621E419106AC100E78C5474B2554180D93D5518106AC198779C626FB255419C33A26616106AC1400AD77768B255418273461010106AC11083C07651B25541E4A59B580F106AC170D712D64CB2554164CC5D630E106AC110C7BA2046B2554146B6F31B0E106AC1782D210F44B25541E02D90D20D106AC1281895403EB25541D9CEF7530D106AC1100BB5FA34B25541DA3D79DE0A106AC18073468CF4B15541', NULL, '0101000020110F0000F5ABF9BEFB0F6AC1F8FA453304B35541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (3177, 300, 300, 10, 1, 3.4000001, 3.4000001, 3.4000001, '217SB S. of Denney Rd.', 0.189999998, 1077, 1076, 1, 0, 3, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, '0102000020110F000006000000A835CD8112126AC1F8EDEB44D1B9554155302AC912126AC178A52C57A1B95541EF38451D13126AC198218EF17FB955410534115213126AC1D856EC736AB955410A4625D112126AC1C03099EE58B9554158A8352512126AC110143F124BB95541', '0102000020110F000006000000BC74934C1D126AC108560EB1D1B95541B7D100941D126AC1E8E236AEA1B9554188F4DBE71D126AC178E09C5D80B95541C420B01E1E126AC1D81B7C096AB9554192CB7F941D126AC1D8F97E4257B955413A234AE31C126AC17858A8F948B95541', '0102000020110F000006000000847CD0BD24126AC1506B9AFBD1B95541CC7F480525126AC1803F35EAA1B955416C09F95825126AC150DA1BA880B955413333339125126AC1E0BE0EC069B95541081B9E0025126AC138AB3E1B56B955418204C54B24126AC17824978747B95541', '0102000020110F0000060000005CB1BF063B126AC10893A9DAD2B95541AC1C5A4E3B126AC180D0B39DA2B95541DE9387A13B126AC1480C028781B95541D812F2DD3B126AC1B88D06E468B955417D3F353A3B126AC1480C02A752B955416C9A777A3A126AC1409B553343B95541', '0102000020110F000006000000AA8251D353126AC178BE9FD2D3B95541E09C111B54126AC110BE3065A3B955417B14AE6D54126AC118FBCB7E82B95541ED0DBEAE54126AC1D878E9EE67B955417B14AEF553126AC18026C2CE4EB9554116D9CE2953126AC180C0CA613EB95541', NULL, '0101000020110F00008CE6904813126AC1F8BCFB516EB95541');
INSERT INTO stations (stationid, localjurisdiction, controljurisdiction, highwayid, enabledflag, milepost, milelog, milenumber, locationtext, length, upstream, downstream, stationclass, segment_odot, numberlanes, gisname, smoothingconstant, bridginglimit, length_mid, segment, downstream_mile, upstream_mile, agencyid, opposite_stationid, segment_raw, segment_50k, segment_100k, segment_250k, segment_500k, segment_1000k, point) VALUES (3157, 300, 300, 9, 1, 3.4000001, 3.4000001, 3.4000001, '217NB S. of Denney Rd.', 0.589999974, 1067, 1066, 1, 0, 3, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, '0102000020110F00000D000000180456C00E126AC1E0718ACA26BA55417EAEB62A0F126AC1304CA62E06BA55417E8CB9AB0F126AC148D8F078E6B95541CE88D2C60F126AC110583990D1B955419D11A5B110126AC138AB3EEB8FB95541431CEBBC10126AC100E78CE068B95541D044D86610126AC1C8DCB5C45CB95541BA6B090F10126AC1708A8E5851B955414ED1914A0F126AC170A301B442B95541501E164E0E126AC15817B72533B95541CD3B4E670B126AC1A879C7AD16B95541BA6B099908126AC1E8839EA1FBB85541FF21FDA605126AC1183FC638E2B85541', '0102000020110F00000D0000006B2BF69D05126AC1A835CD4F26BA55414B59860806126AC160C3D3A705BA5541B6F3FD8806126AC1F05A4216E6B95541053411A406126AC170469436D1B95541EA95B28E07126AC130211FA48FB9554183C0CA9907126AC1180DE05D69B9554183C0CA4707126AC1B09465D45DB95541454772F306126AC1409B55DB52B95541E4141D3706126AC1E8FBA9D144B9554190C2F54805126AC10846252536B95541E61DA77402126AC1580E2D621AB95541849ECDACFF116AC130B29D93FFB85541D8F0F4C0FC116AC1E0BE0E60E6B85541', '0102000020110F00000D0000006ABC74C9F7116AC168F7E49525BA5541F2D24D34F8116AC1789CA2DB04BA554146B6F3B3F8116AC1F085C980E5B95541FF21FDCEF8116AC1606DC5AED0B95541CFF753B9F9116AC1F8065F388FB95541780B24C4F9116AC1B896901B6AB9554160764F78F9116AC1585BB16F5FB95541C64B3729F9116AC1F875E02455B95541C58F3179F8116AC15817B70548B95541C898BBA0F7116AC1009A08AF3AB9554141F163E8F4116AC198900FFE1FB955413889412AF2116AC138F8C28C05B95541A835CD47EF116AC1F853E3A9ECB85541', '0102000020110F00000D00000026C2864DE6116AC1A8DFBEAA24BA5541C898BBB8E6116AC1B0FA5CD903BA5541AB3E5737E7116AC1C8FEB2C3E4B9554162325552E7116AC1B837F802D0B95541F2D24D3CE8116AC1283108B08EB955418026C246E8116AC1A84E400B6BB95541A223B902E8116AC19865887761B95541EE5A42BAE7116AC12897FF0858B955413A92CB19E7116AC160764F124CB955411283C05CE6116AC1C8EEC96B40B955411461C3C7E3116AC158A8351527B95541423EE815E1116AC16007CE190DB95541CFF7533FDE116AC1B07BF29CF4B85541', '0102000020110F00000D000000388941ACBE116AC180D93D9522BA554139454718BF116AC168BC748F01BA5541022B8794BF116AC1508D9716E3B95541674469AFBF116AC1280F0B7DCEB9554196438B98C0116AC100B37B7A8DB9554130992AA2C0116AC100BC052A6DB955415E4BC86FC0116AC1D03B4E1166B9554118045636C0116AC1501E16965EB95541098A1FB9BF116AC188FD653F55B955410E9C333ABF116AC168226C6C4DB95541605452F5BC116AC1480C022737B95541A8C64B5FBA116AC1F8B9DA361EB955415227A0A3B7116AC1C84B37A106B95541', NULL, '0101000020110F0000A7F15E7A10126AC1BD4CEB835FB95541');
--
-- Name: detectors; Type: TABLE; Schema: portal; Tablespace:
--
CREATE TABLE detectors (
detectorid integer PRIMARY KEY,
highwayid smallint,
enabledflag smallint,
locationtext text,
detectortype smallint,
detectorclass smallint,
detectortitle text,
detectorstatus smallint,
lanenumber smallint,
stationid smallint,
rampid smallint,
controllerid smallint,
end_date timestamp with time zone,
start_date timestamp with time zone,
milepost real
);
--
-- Data for Name: detectors; Type: TABLE DATA; Schema: portal;
--
-- Detector data for Highway 9
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100059, 9, 1, 'TV Hwy NB', 8, 1, '100059/2', 0, 1, 1064, 1064, 1064, NULL, '2014-05-01 00:00:00-07', 1.34000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100058, 9, 1, 'TV Hwy NB', 8, 1, '100058/1', 0, 2, 1064, 1064, 1064, NULL, '2014-05-01 00:00:00-07', 1.34000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100005, 9, 1, '99W EB to NB', 8, 1, '100005/2', 0, 1, 1070, 1070, 1070, NULL, '2014-05-01 00:00:00-07', 5.90000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100004, 9, 1, '99W EB to NB', 8, 1, '100004/1', 0, 2, 1070, 1070, 1070, NULL, '2014-05-01 00:00:00-07', 5.90000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100051, 9, 1, 'Allen Blvd NB', 8, 1, '100051/2', 0, 1, 1065, 1065, 1065, NULL, '2014-05-01 00:00:00-07', 2.16000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100050, 9, 1, 'Allen Blvd NB', 8, 1, '100050/1', 0, 2, 1065, 1065, 1065, NULL, '2014-05-01 00:00:00-07', 2.16000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100035, 9, 1, 'Scholls Ferry NB', 8, 1, '100035/2', 0, 1, 1067, 1067, 1067, NULL, '2014-05-01 00:00:00-07', 3.85000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100034, 9, 1, 'Scholls Ferry NB', 8, 1, '100034/1', 0, 2, 1067, 1067, 1067, NULL, '2014-05-01 00:00:00-07', 3.85000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100027, 9, 1, 'Greenburg NB', 8, 1, '100027/2', 0, 1, 1068, 1068, 1068, NULL, '2014-05-01 00:00:00-07', 4.65000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100026, 9, 1, 'Greenburg NB', 8, 1, '100026/1', 0, 2, 1068, 1068, 1068, NULL, '2014-05-01 00:00:00-07', 4.65000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100019, 9, 1, '99W WB to NB', 8, 1, '100019/2', 0, 1, 1069, 1069, 1069, NULL, '2014-05-01 00:00:00-07', 5.85000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100018, 9, 1, '99W WB to NB', 8, 1, '100018/1', 0, 2, 1069, 1069, 1069, NULL, '2014-05-01 00:00:00-07', 5.85000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100003, 9, 1, '72nd Ave NB to NB', 8, 1, '100003/2', 0, 1, 1071, 1071, 1071, NULL, '2014-05-01 00:00:00-07', 6.61000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100002, 9, 1, '72nd Ave NB to NB', 8, 1, '100003/1', 0, 2, 1071, 1071, 1071, NULL, '2014-05-01 00:00:00-07', 6.61000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100302, 9, 1, '217-NB @ TV Hwy', 8, 1, '100302/2', 0, 1, 3155, 3155, 3155, NULL, '2014-05-01 00:00:00-07', 1.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100301, 9, 1, '217-NB @ TV Hwy', 8, 1, '100302/1', 0, 2, 3155, 3155, 3155, NULL, '2014-05-01 00:00:00-07', 1.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100043, 9, 1, 'Denney Rd NB', 8, 1, '100043/2', 0, 1, 1066, 1066, 1066, NULL, '2014-05-01 00:00:00-07', 2.68000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100042, 9, 1, 'Denney Rd NB', 8, 1, '100043/1', 0, 2, 1066, 1066, 1066, NULL, '2014-05-01 00:00:00-07', 2.68000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (1499, 9, 1, '99W EB to NB', 8, 5, 'ORG217N5.90-ENTD1', 0, 1, 5070, 5070, 5070, NULL, '2014-05-01 00:00:00-07', 5.90000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100067, 9, 1, 'Walker Rd NB', 8, 1, '100067/2', 0, 1, 1063, 1063, 1063, NULL, '2014-05-01 00:00:00-07', 0.66000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100066, 9, 1, 'Walker Rd NB', 8, 1, '100067/1', 0, 2, 1063, 1063, 1063, NULL, '2014-05-01 00:00:00-07', 0.66000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (1523, 9, 1, 'Denney Rd NB', 8, 1, 'ORG217N2.68-ML1', 0, 1, 1066, 1066, 1066, '2014-04-30 00:00:00-07', '2004-01-01 00:00:00-08', 2.68000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (1524, 9, 1, 'Denney Rd NB', 8, 1, 'ORG217N2.68-ML2', 0, 2, 1066, 1066, 1066, '2014-04-30 00:00:00-07', '2004-01-01 00:00:00-08', 2.68000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (3061, 9, 1, '217-NB S. of US 26 ML1', 8, 1, '217-NB S. of US 26 ML1', 0, 1, 3153, 3153, 103, NULL, '2004-01-01 00:00:00-08', 0.25000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (3062, 9, 1, '217-NB S. of US 26 ML2', 8, 1, '217-NB S. of US 26 ML2', 0, 2, 3153, 3153, 103, NULL, '2004-01-01 00:00:00-08', 0.25000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (3063, 9, 1, '217-NB S. of US 26 ML3', 8, 1, '217-NB S. of US 26 ML3', 0, 3, 3153, 3153, 103, NULL, '2004-01-01 00:00:00-08', 0.25000003);
--- Detector Data for Highway 10
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100308, 10, 1, 'Hall Blvd SB', 8, 1, '100308/3', 0, 1, 1076, 1076, 1076, NULL, '2014-05-01 00:00:00-07', 3.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100307, 10, 1, 'Hall Blvd SB', 8, 1, '100307/2', 0, 2, 1076, 1076, 1076, NULL, '2014-05-01 00:00:00-07', 3.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100306, 10, 1, 'Hall Blvd SB', 8, 1, '100306/1', 0, 3, 1076, 1076, 1076, NULL, '2014-05-01 00:00:00-07', 3.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100071, 10, 1, 'Barnes SB', 8, 1, '100071/1', 0, 2, 1118, 1118, 1118, NULL, '2014-05-01 00:00:00-07', 0.08000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100072, 10, 1, 'Barnes SB', 8, 1, '100072/2', 0, 1, 1118, 1118, 1118, NULL, '2014-05-01 00:00:00-07', 0.08000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100085, 10, 1, 'Wilshire to ORE 217 SB', 8, 1, '100085/1', 0, 3, 1111, 1111, 1111, NULL, '2014-05-01 00:00:00-07', 0.45000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100150, 10, 1, 'Greenburg SB', 8, 1, '100150/2', 0, 1, 1074, 1074, 1074, NULL, '2014-05-01 00:00:00-07', 5.11000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100149, 10, 1, 'Greenburg SB', 8, 1, '100149/1', 0, 2, 1074, 1074, 1074, NULL, '2014-05-01 00:00:00-07', 5.11000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100104, 10, 1, 'B-H Hwy SB', 8, 1, '100104/2', 0, 1, 1079, 1079, 1079, NULL, '2014-05-01 00:00:00-07', 1.92000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100103, 10, 1, 'B-H Hwy SB', 8, 1, '100103/1', 0, 2, 1079, 1079, 1079, NULL, '2014-05-01 00:00:00-07', 1.92000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100157, 10, 1, '99W EB to SB', 8, 1, '100157/1', 0, 2, 1073, 1073, 1073, NULL, '2014-05-01 00:00:00-07', 5.95000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100142, 10, 1, 'Scholls Fy SB', 8, 1, '100142/2', 0, 1, 1075, 1075, 1075, NULL, '2014-05-01 00:00:00-07', 4.35000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100141, 10, 1, 'Scholls Fy SB', 8, 1, '100141/1', 0, 2, 1075, 1075, 1075, NULL, '2014-05-01 00:00:00-07', 4.35000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100167, 10, 1, '72nd SB', 8, 1, '100167/3', 0, 1, 1072, 1072, 1072, NULL, '2014-05-01 00:00:00-07', 6.77000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100087, 10, 1, 'Wilshire to ORE 217 SB', 8, 1, '100087/3', 0, 1, 1111, 1111, 1111, NULL, '2014-05-01 00:00:00-07', 0.45000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100086, 10, 1, 'Wilshire to ORE 217 SB', 8, 1, '100086/2', 0, 2, 1111, 1111, 1111, NULL, '2014-05-01 00:00:00-07', 0.45000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100127, 10, 1, 'Hall Blvd SB', 8, 1, '100127/1', 0, 1, NULL, NULL, 1076, NULL, '2014-05-01 00:00:00-07', NULL);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100128, 10, 1, 'Hall Blvd SB', 8, 1, '100128/2', 0, 2, NULL, NULL, 1076, NULL, '2014-05-01 00:00:00-07', NULL);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100117, 10, 1, 'Allen Blvd SB', 8, 1, '100117/1', 0, 2, 1078, 1078, 1078, NULL, '2014-05-01 00:00:00-07', 2.55000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100166, 10, 1, '72nd SB', 8, 1, '100166/2', 0, 2, 1072, 1072, 1072, NULL, '2014-05-01 00:00:00-07', 6.77000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100165, 10, 1, '72nd SB', 8, 1, '100165/1', 0, 3, 1072, 1072, 1072, NULL, '2014-05-01 00:00:00-07', 6.77000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100158, 10, 1, '99W EB to SB', 8, 1, '100158/2', 0, 1, 1073, 1073, 1073, NULL, '2014-05-01 00:00:00-07', 5.95000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100300, 10, 1, '217-SB @ TV Hwy', 8, 1, '100300/2', 0, 1, 3156, 3156, 3156, NULL, '2014-05-01 00:00:00-07', 1.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100299, 10, 1, '217-SB @ TV Hwy', 8, 1, '100299/1', 0, 2, 3156, 3156, 3156, NULL, '2014-05-01 00:00:00-07', 1.50000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100120, 10, 1, 'Denney Rd SB', 8, 1, '100120/2', 0, 1, 1077, 1077, 1077, NULL, '2014-05-01 00:00:00-07', 3.12000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100119, 10, 1, 'Denney Rd SB', 8, 1, '100119/1', 0, 2, 1077, 1077, 1077, NULL, '2014-05-01 00:00:00-07', 3.12000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100096, 10, 1, 'Walker Rd SB', 8, 1, '100096/3', 0, 1, 1080, 1080, 1080, NULL, '2014-05-01 00:00:00-07', 0.76000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100095, 10, 1, 'Walker Rd SB', 8, 1, '100095/2', 0, 2, 1080, 1080, 1080, NULL, '2014-05-01 00:00:00-07', 0.76000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (100094, 10, 1, 'Walker Rd SB', 8, 1, '100094/1', 0, 3, 1080, 1080, 1080, NULL, '2014-05-01 00:00:00-07', 0.76000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (1081, 10, 1, 'ORE 217 WB to SB', 8, 1, 'ORE217S7.0-ML1', 0, 1, 1037, 1037, 1037, NULL, '2014-05-01 00:00:00-07', 7.00000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (1082, 10, 1, 'ORE 217 WB to SB', 8, 1, 'ORE217S7.0-ML2', 0, 2, 1037, 1037, 1037, NULL, '2014-05-01 00:00:00-07', 7.00000003);
INSERT INTO detectors (detectorid, highwayid, enabledflag, locationtext, detectortype, detectorclass, detectortitle, detectorstatus, lanenumber, stationid, rampid, controllerid, end_date, start_date, milepost) VALUES (1086, 10, 1, 'ORE 217 WB to SB', 8, 1, 'ORE217S7.0-ENTD1', 0, 1, 5037, 1037, 1037, NULL, '2014-05-01 00:00:00-07', 7.00000003);