LCS CSV 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,closureID,logNumber,closureRequestDate,closureRequestTime,closureRequestEpoch,closureStartDate,closureStartTime,closureStartEpoch,closureEndDate,closureEndTime,closureEndEpoch, isClosureEndIndefinite,facility,typeOfClosure,durationOfClosure,typeOfWork,estimatedDelay,lanesClosed,totalExistingLanes,isCHINReportable,isCode1097,code1097Date,code1097Time,code1097Epoch,isCode1098, code1098Date,code1098Time,code1098Epoch,isCode1022,code1022Date,code1022Time,code1022Epoch
Data
C299CA-0004-2016-04-12-00:01:00,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,C299CA,4,2016-04-08,15:58:00,1460156280,2016-04-12, 00:01:00,1460444471,2016-04-30,23:59:00,1462085940,false,"Conventional Hwy",Lane,Standard,"Highway Construction",30,1,2,false,true,2016-04-12,00:01:00,1460444460,false,,,,false,,,
Layout
| Field Number | CSV Column | Header | Data |
|---|---|---|---|
| 1.1.1 | 1 | index | C299CA-0004-2016-04-12-00:01:00 |
| 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 | closureID | C299CA |
| 1.1.4.2 | 37 | logNumber | 4 |
| 1.1.4.3.1 | 38 | closureRequestDate | 4/8/2016 |
| 1.1.4.3.2 | 39 | closureRequestTime | 15:58:00 |
| 1.1.4.3.3 | 40 | closureRequestEpoch | 1460156280 |
| 1.1.4.3.4 | 41 | closureStartDate | 4/12/2016 |
| 1.1.4.3.5 | 42 | closureStartTime | 00:01:00 |
| 1.1.4.3.6 | 43 | closureStartEpoch | 1460444471 |
| 1.1.4.3.7 | 44 | closureEndDate | 4/30/2016 |
| 1.1.4.3.8 | 45 | closureEndTime | 23:59:00 |
| 1.1.4.3.9 | 46 | closureEndEpoch | 1462085940 |
| 1.1.4.3.10 | 47 | isClosureEndIndefinite | false |
| 1.1.4.4 | 48 | facility | Conventional Hwy |
| 1.1.4.5 | 49 | typeOfClosure | Lane |
| 1.1.4.6 | 50 | typeOfWork | Highway Construction |
| 1.1.4.7 | 51 | durationOfClosure | Standard |
| 1.1.4.8 | 52 | estimatedDelay | 30 |
| 1.1.4.9 | 53 | lanesClosed | 1 |
| 1.1.4.10 | 54 | totalExistingLanes | 2 |
| 1.1.4.11 | 55 | isCHINReportable | false |
| 1.1.4.12.1 | 56 | isCode1097 | true |
| 1.1.4.12.2.1 | 57 | code1097Date | 4/12/2016 |
| 1.1.4.12.2.2 | 58 | code1097Time | 0:01:00 |
| 1.1.4.12.2.3 | 59 | code1097Epoch | 1460444460 |
| 1.1.4.13.1 | 60 | isCode1098 | false |
| 1.1.4.13.2.1 | 61 | code1098Date | |
| 1.1.4.13.2.2 | 62 | code1098Time | |
| 1.1.4.13.2.3 | 63 | code1098Epoch | |
| 1.1.4.14.1 | 64 | isCode1022 | false |
| 1.1.4.14.2.1 | 65 | code1022Date | |
| 1.1.4.14.2.2 | 66 | code1022Time | |
| 1.1.4.14.2.3 | 67 | code1022Epoch |