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

CCTV CSV file layout by field number, csv column, header and sample data
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