CMS CSV File Layout Example
Header
index,recordDate,recordTime,district,locationName,nearbyPlace,longitude,latitude,elevation,direction,county,route,routeSuffix,postmilePrefix, postmile,alignment,milepost,inservice,messageDate,messageTime,display,displayTime,phase1Font,phase1Line1,phase1Line2,phase1Line3, phase2Font,phase2Line1,phase2Line2,phase2Line3
Data
5,2012-01-12,16:08:00,2,"5 - Walters Lane N/B - Yreka",Yreka,-122.635373,41.685655,2805,North,Siskiyou,I-5,,R,44.31,,771.54,true,2012-01-12,06:27:47,"Two Pages",3.5,"Single Stroke", "CLICK IT",OR,TICKET,"Single Stroke",SLOW,"FOR THE","CONE ZONE"
Layout
| Field Number | CSV Column | Header | Data |
|---|---|---|---|
| 1.1.1 | 1 | index | 5 |
| 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 | 5 - Walters Lane N/B - Yreka |
| 1.1.3.3 | 6 | nearbyPlace | Yreka |
| 1.1.3.4 | 7 | longitude | -122.635373 |
| 1.1.3.5 | 8 | latitude | 41.685655 |
| 1.1.3.6 | 9 | elevation | 2805 |
| 1.1.3.7 | 10 | direction | North |
| 1.1.3.8 | 11 | county | Siskiyou |
| 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 | 44.31 |
| 1.1.3.13 | 16 | alignment | |
| 1.1.3.14 | 17 | milepost | 771.54 |
| 1.1.4 | 18 | inService | true |
| 1.1.5.1.1 | 19 | messageDate | 2012-01-12 |
| 1.1.5.1.2 | 20 | messageTime | 06:27:47 |
| 1.1.5.2 | 21 | display | Two Pages |
| 1.1.5.3 | 22 | displayTime | 3.5 |
| 1.1.5.4.1 | 23 | phase1Font | Single Stroke |
| 1.1.5.4.2 | 24 | phase1Line1 | CLICK IT |
| 1.1.5.4.3 | 25 | phase1Line2 | OR |
| 1.1.5.4.4 | 26 | phase1Line3 | TICKET |
| 1.1.5.5.1 | 27 | phase2Font | Single Stroke |
| 1.1.5.5.2 | 28 | phase2Line1 | SLOW |
| 1.1.5.5.3 | 29 | phase2Line2 | FOR THE |
| 1.1.5.5.4 | 30 | phase2Line3 | CONE ZONE |