TT CSV File Layout Example
Header
index,recordDate,recordTime,recordEpoch,beginDistrict,beginLocationName,beginFreeFormDescription,beginNearbyPlace,beginLongitude,beginLatitude, beginElevation,beginDirection,beginCounty,beginRoute,beginRouteSuffix,beginPostmilePrefix,beginPostmile,beginAlignment,beginMilepost,endDistrict,endLocationName, endFreeFormDescription,endNearbyPlace,endLongitude,endLatitude,endElevation,endDirection,endCounty,endRoute,endRouteSuffix,endPostmilePrefix,endPostmile,endAlignment, endMilepost,routeID,traveltimeDate,traveltimeTime,traveltimeEpoch,routeTravelTime,traveltimeUpdateFrequency,traveltimeAccuracy
Data
"676-1216823-1214701-CA-905 VIA 5",2016-04-19,14:51:04,1461102664000,East,2,"Route 299",,Lewiston,-122.733841,40.635122,3277,East,Shasta,SR-299,,,0.000,, 114.190,2,"0.6 mi west of Crystal Creek Rd",,"French Gulch",-122.654384,40.672010,1427,East,Shasta,SR-299,,,7.500,,121.633,9609,2016-04-08,15:58:00,1460156280,29,60,99.9
Layout
| Field Number | CSV Column | Header | Data |
|---|---|---|---|
| 1.1.1 | 1 | index | 676-1216823-1214701-CA-905 VIA 5 |
| 1.1.2.1 | 2 | recordDate | 4/19/2016 |
| 1.1.2.2 | 3 | recordTime | 14:51:04 |
| 1.1.2.3 | 4 | recordEpoch | 1461102664 |
| 1.1.3.1 | 5 | travelFlowDirection | East |
| 1.1.3.2.1 | 6 | beginDistrict | 2 |
| 1.1.3.2.2 | 7 | beginLocationName | Route 299 |
| 1.1.3.2.3 | 8 | beginFreeFormDescription | |
| 1.1.3.2.4 | 9 | beginNearbyPlace | Lewiston |
| 1.1.3.2.5 | 10 | beginLongitude | -122.733841 |
| 1.1.3.2.6 | 11 | beginLatitude | 40.635122 |
| 1.1.3.2.7 | 12 | beginElevation | 3277 |
| 1.1.3.2.8 | 13 | beginDirection | East |
| 1.1.3.2.9 | 14 | beginCounty | Shasta |
| 1.1.3.2.10 | 15 | beginRoute | SR-299 |
| 1.1.3.2.11 | 16 | beginRouteSuffix | |
| 1.1.3.2.12 | 17 | beginPostmilePrefix | |
| 1.1.3.2.13 | 18 | beginPostmile | 0 |
| 1.1.3.2.14 | 19 | beginAlignment | |
| 1.1.3.2.15 | 20 | beginMilepost | 114.19 |
| 1.1.3.3.1 | 21 | endDistrict | 2 |
| 1.1.3.3.2 | 22 | endLocationName | 0.6 mi west of Crystal Creek Rd |
| 1.1.3.3.3 | 23 | endFreeFormDescription | |
| 1.1.3.3.4 | 24 | endNearbyPlace | French Gulch |
| 1.1.3.3.5 | 25 | endLongitude | -122.654384 |
| 1.1.3.3.6 | 26 | endLatitude | 40.67201 |
| 1.1.3.3.7 | 27 | endElevation | 1427 |
| 1.1.3.3.8 | 28 | endDirection | East |
| 1.1.3.3.9 | 29 | endCounty | Shasta |
| 1.1.3.3.10 | 30 | endRoute | SR-299 |
| 1.1.3.3.11 | 31 | endRouteSuffix | |
| 1.1.3.3.12 | 32 | endPostmilePrefix | |
| 1.1.3.3.13 | 33 | endPostmile | 7.5 |
| 1.1.3.3.14 | 34 | endAlignment | |
| 1.1.3.3.15 | 35 | endMilepost | 121.633 |
| 1.1.4.1 | 36 | routeID | 9609 |
| 1.1.4.2.1 | 37 | traveltimeDate | 4/8/2016 |
| 1.1.4.2.2 | 38 | traveltimeTime | 15:58:00 |
| 1.1.4.2.3 | 39 | traveltimeEpoch | 1460156280 |
| 1.1.4.3 | 40 | routeTravelTime | 29 |
| 1.1.4.4 | 41 | traveltimeUpdateFrequency | 60 |
| 1.1.4.5 | 42 | traveltimeAccuracy | 99.9 |