TT TXT 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
Field Delimeter
ÿ
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 | 39 | traveltimeTime | 15:58:00 |
| 1.1.4.2.3 | 40 | traveltimeEpoch | 1460156280 |
| 1.1.4.3 | 41 | routeTravelTime | 29 |
| 1.1.4.4 | 42 | traveltimeUpdateFrequency | 60 |
| 1.1.4.5 | 43 | traveltimeAccuracy | 99.9 |