CCTV CSV 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"
Layout
| Field Number | CSV 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 |