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

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