LCS TXT 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ÿtypeOfWorkÿdurationOfClosureÿ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ÿÿHighway ConstructionÿStandardÿÿ30ÿ1ÿ2ÿfalseÿtrueÿ2016-04-12ÿ00:01:00ÿ1460444460ÿfalseÿÿÿÿfalseÿÿÿ
Field Delimeter
ÿ
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 |