CCTV TXT File Layout Example
Header
indexÿrecordDateÿrecordTimeÿdistrictÿlocationNameÿnearbyPlaceÿlongitudeÿlatitudeÿelevationÿdirectionÿcountyÿrouteÿrouteSuffixÿ postmilePrefixÿpostmileÿalignmentÿmilepostÿinserviceÿimageDescriptionÿstreamingVideoURLÿcurrentImageUpdateFrequencyÿcurrentImageURLÿ referenceImageUpdateFrequencyÿreferenceImage1UpdateAgoURLÿreferenceImage2UpdatesAgoURLÿreferenceImage3UpdatesAgoURLÿ referenceImage4UpdatesAgoURLÿreferenceImage5UpdatesAgoURLÿreferenceImage6UpdatesAgoURLÿreferenceImage7UpdatesAgoURLÿ referenceImage8UpdatesAgoURLÿreferenceImage9UpdatesAgoURLÿreferenceImage10UpdatesAgoURLÿreferenceImage11UpdatesAgoURLÿreferenceImage12UpdatesAgoURL
Data
17ÿ2012-01-12ÿ16:08:00ÿ2ÿVollmersÿYrekaÿ-122.426311ÿ40.940782ÿ1338ÿNorthÿShastaÿI-5ÿÿRÿ45.76ÿÿ706.56ÿtrueÿLooking NorthÿNot Reportedÿ 60ÿhttps://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/vollmers.jpgÿ60ÿhttps://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-1.jpgÿ https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-2.jpgÿhttps://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-3.jpgÿ https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-4.jpgÿhttps://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-5.jpgÿ https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-6.jpgÿhttps://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-7.jpgÿ https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-8.jpgÿNot ReportedÿNot ReportedÿNot ReportedÿNot Reported
Field Delimeter
ÿ
Layout
| Field Number | TXT Column | Header | Data |
|---|---|---|---|
| 1.1.1 | 1 | index | 17 |
| 1.1.2.1 | 2 | recordDate | 2012-01-12 |
| 1.1.2.2 | 3 | recordTime | 16:08:00 |
| 1.1.3.1 | 4 | district | 2 |
| 1.1.3.2 | 5 | locationName | Vollmers |
| 1.1.3.3 | 6 | nearbyPlace | Yreka |
| 1.1.3.4 | 7 | longitude | -122.426311 |
| 1.1.3.5 | 8 | latitude | 40.940782 |
| 1.1.3.6 | 9 | elevation | 1338 |
| 1.1.3.7 | 10 | direction | North |
| 1.1.3.8 | 11 | county | Shasta |
| 1.1.3.9 | 12 | route | I-5 |
| 1.1.3.10 | 13 | routeSuffix | |
| 1.1.3.11 | 14 | postmilePrefix | R |
| 1.1.3.12 | 15 | postmile | 45.76 |
| 1.1.3.13 | 16 | alignment | |
| 1.1.3.14 | 17 | milepost | 706.56 |
| 1.1.4 | 18 | inService | true |
| 1.1.5.1 | 19 | imageDescription | Looking North |
| 1.1.5.2 | 20 | streamingVideoURL | Not Reported |
| 1.1.5.3.1 | 21 | currentImageUpdateFrequency | 60 |
| 1.1.5.3.2 | 22 | currentImageURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/vollmers.jpg |
| 1.1.5.3.3 | 23 | referenceImageUpdateFrequency | 60 |
| 1.1.5.3.4 | 24 | referenceImage1UpdateAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-1.jpg |
| 1.1.5.3.5 | 25 | referenceImage2UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-2.jpg |
| 1.1.5.3.6 | 26 | referenceImage3UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-3.jpg |
| 1.1.5.3.7 | 27 | referenceImage4UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-4.jpg |
| 1.1.5.3.8 | 28 | referenceImage5UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-5.jpg |
| 1.1.5.3.9 | 29 | referenceImage6UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-6.jpg |
| 1.1.5.3.10 | 30 | referenceImage7UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-7.jpg |
| 1.1.5.3.11 | 31 | referenceImage8UpdatesAgoURL | https://www.dot.ca.gov/cwwp2/data/d2/cctv/image/vollmers/previous/vollmers-8.jpg |
| 1.1.5.3.12 | 32 | referenceImage9UpdatesAgoURL | Not Reported |
| 1.1.5.3.13 | 33 | referenceImage10UpdatesAgoURL | Not Reported |
| 1.1.5.3.14 | 34 | referenceImage11UpdatesAgoURL | Not Reported |
| 1.1.5.3.15 | 35 | referenceImage12UpdatesAgoURL | Not Reported |