Chain Control CSV File Layout Example


Header

index,recordDate,recordTime,district,locationName,nearbyPlace,longitude,latitude,elevation,,county,route,routeSuffix,postmilePrefix, postmile,alignment,milepost,inservice,statusDate,statusTime,status,statusDescription

Data

9-MNO-395-69.9-S-D67,2013-10-15,10:15:02,9,"7 miles south of Bridgeport",Bridgeport,-119.19486,38.17515,6870,South,Mono,US-395,,,69.84,,303.41,true,2013-04-17,09:03:00,R-0,"No chain controls are in effect at this time."

Layout

Chain Control CSV file layout by field number, csv column, header and sample data
Field Number CSV Column Header Data
1.1.1 1 index 9-MNO-395-69.9-S-D67
1.1.2.1 2 recordDate 2013-10-15
1.1.2.2 3 recordTime 10:15:02
1.1.3.1 4 district 9
1.1.3.2 5 locationName 7 miles south of Bridgeport
1.1.3.3 6 nearbyPlace Bridgeport
1.1.3.4 7 longitude -119.19486
1.1.3.5 8 latitude 38.17515
1.1.3.6 9 elevation 6870
1.1.3.7 10 direction South
1.1.3.8 11 county Mono
1.1.3.9 12 route US-395
1.1.3.10 13 routeSuffix
1.1.3.11 14 postmilePrefix
1.1.3.12 15 postmile 69.84
1.1.3.13 16 alignment
1.1.3.14 17 milepost 303.41
1.1.4 18 inService true
1.1.5.1.1 19 statusDate 2013-04-17
1.1.5.1.2 20 statusTime 09:03:00
1.1.5.2 21 status R-0
1.1.5.3 22 statusDescription No chain controls are in effect at this time.