| Field |
Right Justify |
From |
To |
Length |
Comments/Notes |
| Year |
|
1 |
4 |
4 |
|
| County Code |
|
5 |
6 |
2 |
|
| Municipality Code |
|
7 |
8 |
2 |
|
| Department Case Number |
|
9 |
31 |
23 |
Increased from 20 to 23 bytes |
|
|
32 |
32 |
1 |
|
| County Name |
|
33 |
44 |
12 |
|
|
|
45 |
45 |
1 |
|
| Municipality Name |
|
46 |
69 |
24 |
|
|
|
70 |
70 |
1 |
|
| Crash Date |
|
71 |
80 |
10 |
|
|
|
81 |
81 |
1 |
|
| Crash Day Of Week |
|
82 |
83 |
2 |
|
|
|
84 |
84 |
1 |
|
| Crash Time |
|
85 |
88 |
4 |
|
|
|
89 |
89 |
1 |
|
| Police Dept Code |
|
90 |
91 |
2 |
|
|
|
92 |
92 |
1 |
|
| Police Department |
|
93 |
117 |
25 |
|
|
|
118 |
118 |
1 |
|
| Police Station |
|
119 |
133 |
15 |
|
|
|
134 |
134 |
1 |
|
| Total Killed |
Y |
135 |
136 |
2 |
|
|
|
137 |
137 |
1 |
|
| Total Injured |
Y |
138 |
139 |
2 |
|
|
|
140 |
140 |
1 |
|
| Pedestrians Killed |
Y |
141 |
142 |
2 |
|
|
|
143 |
143 |
1 |
|
| Pedestrians Injured |
Y |
144 |
145 |
2 |
|
|
|
146 |
146 |
1 |
|
| Severity |
|
147 |
147 |
1 |
|
|
|
148 |
148 |
1 |
|
| Intersection |
|
149 |
149 |
1 |
|
|
|
150 |
150 |
1 |
|
| Alcohol Involved |
|
151 |
151 |
1 |
|
|
|
152 |
152 |
1 |
|
| HazMat Involved |
|
153 |
153 |
1 |
|
|
|
154 |
154 |
1 |
|
| Crash Type Code |
|
155 |
156 |
2 |
Previously named Collision w/MV Code; Increased to 2 bytes |
|
|
157 |
157 |
1 |
|
| Total Vehicles Involved |
Y |
158 |
159 |
2 |
|
|
|
160 |
160 |
1 |
|
| Crash Location |
|
161 |
210 |
50 |
|
|
|
211 |
211 |
1 |
|
| Location Direction |
|
212 |
212 |
1 |
New Field |
|
|
213 |
213 |
1 |
|
| Route |
Y |
214 |
217 |
4 |
|
|
|
218 |
218 |
1 |
|
| Route Suffix |
|
219 |
219 |
1 |
|
|
|
220 |
220 |
1 |
|
| SRI (Std Rte Identifier) |
|
221 |
236 |
16 |
|
|
|
237 |
237 |
1 |
|
| MilePost |
Y |
238 |
244 |
7 |
999.999 |
|
|
245 |
245 |
1 |
|
| Road System |
|
246 |
247 |
2 |
Increased to 2 bytes |
|
|
248 |
248 |
1 |
|
| Road Character |
|
249 |
250 |
2 |
Increased to 2 bytes |
|
|
251 |
251 |
1 |
|
| Road Surface Type |
|
252 |
253 |
2 |
Increased to 2 bytes |
|
|
254 |
254 |
1 |
|
| Surface Condition |
|
255 |
256 |
2 |
Increased to 2 bytes |
|
|
257 |
257 |
1 |
|
| Light Condition |
|
258 |
259 |
2 |
Increased to 2 bytes |
|
|
260 |
260 |
1 |
|
| Environmental Condition |
|
261 |
262 |
2 |
Previously named Weather; Increased to 2 bytes |
Comma |
|
263 |
263 |
1 |
|
| Road Divided By |
|
264 |
265 |
2 |
Increased to 2 bytes |
Comma |
|
266 |
266 |
1 |
|
| Temporary Traffic Control Zone |
|
267 |
268 |
2 |
Previously named Road Under Construction; Increased to 2 bytes |
Comma |
|
269 |
269 |
1 |
|
| Distance To Cross Street |
Y |
270 |
273 |
4 |
|
Comma |
|
274 |
274 |
1 |
|
| Unit Of Measurement |
|
275 |
276 |
2 |
|
Comma |
|
277 |
277 |
1 |
|
| Directn From Cross Street |
|
278 |
278 |
1 |
|
Comma |
|
279 |
279 |
1 |
|
| Cross Street Name |
|
280 |
314 |
35 |
|
Comma |
|
315 |
315 |
1 |
|
| Is Ramp |
|
316 |
316 |
1 |
No longer Y or N…now T (To) or F (From) |
Comma |
|
317 |
317 |
1 |
|
| Ramp To/From Route Name |
|
318 |
342 |
25 |
Previously was two fields...Ramp From Route Num and Ramp To Route Num; Increased from 4 to 25 bytes |
Comma |
|
343 |
343 |
1 |
|
| Ramp To/From Route Direction |
|
344 |
345 |
2 |
Previously was two fields...Ramp From Route Direction and Ramp To Route Direction |
Comma |
|
346 |
346 |
1 |
|
| Posted Speed |
Y |
347 |
348 |
2 |
|
Comma |
|
349 |
349 |
1 |
|
| Posted Speed Cross Street |
Y |
350 |
351 |
2 |
New Field |
Comma |
|
352 |
352 |
1 |
|
| Latitude |
Y |
353 |
360 |
8 |
New Field; Decimal Degrees (99.99999) |
Comma |
|
361 |
361 |
1 |
|
| Longitude |
Y |
362 |
369 |
8 |
New Field; Decimal Degrees (99.99999) |
Comma |
|
370 |
370 |
1 |
|
| Cell Phone In Use Flag |
|
371 |
371 |
1 |
New Field; Set to 'Y' if any driver, pedestrian or pedalcyclist was using a cell phone |
Comma |
|
372 |
372 |
1 |
|
| Other Property Damage |
|
373 |
452 |
80 |
|
Comma |
|
453 |
453 |
1 |
|
| Reporting Badge No. |
|
454 |
458 |
5 |
|