RWIS CSV File Layout Example


Header

index,recordDate,recordTime,recordEpoch,district,locationName,nearbyPlace,longitude,latitude,elevation,direction,county,route,routeSuffix, postmilePrefix,postmile,alignment,milepost,inService,essAtmosphericPressure,essAvgWindDirection,essAvgWindSpeed,essSpotWindDirection,essSpotWindSpeed,essMaxWindGustSpeed, essMaxWindGustDir,essNumTemperatureSensors,essAirTemperature.1,essWetbulbTemp,essDewpointTemp,essMaxTemp,essMinTemp,essRelativeHumidity,essPrecipYesNo,essPrecipRate, essPrecipSituation,essPrecipitationStartTime,essPrecipitationEndTime,essPrecipitationOneHour,essPrecipitationThreeHours,essPrecipitationSixHours,essPrecipitationTwelveHours, essPrecipitation24Hours,essVisibility,essVisibilitySituation,numEssPavementSensors,essPavementSensorLocation.1,essPavementSensorLocation.2,essPavementSensorLocation.3, essPavementSensorLocation.4,essPavementSensorLocation.5,essPavementSensorLocation.6,essPavementSensorLocation.7,essPavementSensorLocation.8,essPavementType.1,essPavementType.2, essPavementType.3,essPavementType.4,essPavementType.5,essPavementType.6,essPavementType.7,essPavementType.8,essPavementSensorType.1,essPavementSensorType.2,essPavementSensorType.3, essPavementSensorType.4,essPavementSensorType.5,essPavementSensorType.6,essPavementSensorType.7,essPavementSensorType.8,essSurfaceStatus.1,essSurfaceStatus.2,essSurfaceStatus.3, essSurfaceStatus.4,essSurfaceStatus.5,essSurfaceStatus.6,essSurfaceStatus.7,essSurfaceStatus.8,essSurfaceTemperature.1,essSurfaceTemperature.2,essSurfaceTemperature.3, essSurfaceTemperature.4,essSurfaceTemperature.5,essSurfaceTemperature.6,essSurfaceTemperature.7,essSurfaceTemperature.8,essSurfaceSalinity.1,essSurfaceSalinity.2, essSurfaceSalinity.3,essSurfaceSalinity.4,essSurfaceSalinity.5,essSurfaceSalinity.6,essSurfaceSalinity.7,essSurfaceSalinity.8,essSurfaceFreezePoint.1,essSurfaceFreezePoint.2, essSurfaceFreezePoint.3,essSurfaceFreezePoint.4,essSurfaceFreezePoint.5,essSurfaceFreezePoint.6,essSurfaceFreezePoint.7,essSurfaceFreezePoint.8,essSurfaceBlackIceSignal.1, essSurfaceBlackIceSignal.2,essSurfaceBlackIceSignal.3,essSurfaceBlackIceSignal.4,essSurfaceBlackIceSignal.5,essSurfaceBlackIceSignal.6,essSurfaceBlackIceSignal.7, essSurfaceBlackIceSignal.8,essPavementSensorError.1,essPavementSensorError.2,essPavementSensorError.3,essPavementSensorError.4,essPavementSensorError.5,essPavementSensorError.6, essPavementSensorError.7,essPavementSensorError.8,essSurfaceIceOrWaterDepth.1,essSurfaceIceOrWaterDepth.2,essSurfaceIceOrWaterDepth.3,essSurfaceIceOrWaterDepth.4, essSurfaceIceOrWaterDepth.5,essSurfaceIceOrWaterDepth.6,essSurfaceIceOrWaterDepth.7,essSurfaceIceOrWaterDepth.8,essSurfaceConductivityV2.1,essSurfaceConductivityV2.2, essSurfaceConductivityV2.3,essSurfaceConductivityV2.4,essSurfaceConductivityV2.5,essSurfaceConductivityV2.6,essSurfaceConductivityV2.7,essSurfaceConductivityV2.8,numEssSubSurfaceSensors, essSubSurfaceSensorLocation.1,essSubSurfaceSensorLocation.2,essSubSurfaceSensorLocation.3,essSubSurfaceSensorLocation.4,essSubSurfaceSensorLocation.5,essSubSurfaceSensorLocation.6, essSubSurfaceSensorLocation.7,essSubSurfaceSensorLocation.8,essSubSurfaceType.1,essSubSurfaceType.2,essSubSurfaceType.3,essSubSurfaceType.4,essSubSurfaceType.5,essSubSurfaceType.6, essSubSurfaceType.7,essSubSurfaceType.8,essSubSurfaceDepth.1,essSubSurfaceDepth.2,essSubSurfaceDepth.3,essSubSurfaceDepth.4,essSubSurfaceDepth.5,essSubSurfaceDepth.6, essSubSurfaceDepth.7,essSubSurfaceDepth.8,essSubSurfaceTemperature.1,essSubSurfaceTemperature.2,essSubSurfaceTemperature.3,essSubSurfaceTemperature.4,essSubSurfaceTemperature.5, essSubSurfaceTemperature.6,essSubSurfaceTemperature.7,essSubSurfaceTemperature.8,essSubSurfaceMoisture.1,essSubSurfaceMoisture.2,essSubSurfaceMoisture.3,essSubSurfaceMoisture.4, essSubSurfaceMoisture.5,essSubSurfaceMoisture.6,essSubSurfaceMoisture.7,essSubSurfaceMoisture.8,essSubSurfaceSensorError.1,essSubSurfaceSensorError.2,essSubSurfaceSensorError.3, essSubSurfaceSensorError.4,essSubSurfaceSensorError.5,essSubSurfaceSensorError.6,essSubSurfaceSensorError.7,essSubSurfaceSensorError.8

Data

49,2016-04-04,12:20:20,1459797620,2,"Sims Road",Castella,-122.35592,41.07786,1804,North,Shasta,I-5,,R,57.87,,718.468,true,"Not Reported",1,25, 58,17,39,334,1,166,83,-17,244,101,28,2,0,3,1458606690,1458609120,0,0,0,0,0,"Not Reported","Not Reported",4,"2;Surf Shasta I-5 57.84;;-122.35598;41.07785;1807;;Shasta;I-5;;;57.84;;", "2;Surf Shasta I-5 57.85;;-122.35592;41.07789;1807;;Shasta;I-5;;;57.85;;","2;Surf Shasta I-5 57.83;;-122.35603;41.07764;1807;;Shasta;I-5;;;57.83;;", "2;Surf Shasta I-5 57.82;;-122.35603;41.07762;1807;;Shasta;I-5;;;57.82;;","Not Reported","Not Reported","Not Reported","Not Reported",3,3,3,3,"Not Reported","Not Reported", "Not Reported","Not Reported",2,2,2,2,"Not Reported","Not Reported","Not Reported","Not Reported",2,3,3,3,"Not Reported","Not Reported","Not Reported","Not Reported",1001,281,274, 271,"Not Reported","Not Reported","Not Reported","Not Reported",65535,65535,65535,65535,"Not Reported","Not Reported","Not Reported","Not Reported",1001,1001,1001,1001,"Not Reported", "Not Reported","Not Reported","Not Reported",1,1,1,1,"Not Reported","Not Reported","Not Reported","Not Reported",3,2,2,2,"Not Reported","Not Reported","Not Reported","Not Reported", 65535,65535,65535,65535,"Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported", "Not Reported","Not Reported",1,"2;Sub Shasta I-5 57.84;;-122.35597;41.07787;1807;;Shasta;I-5;;;57.84;;","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported", "Not Reported","Not Reported",2,"Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported",1001,"Not Reported","Not Reported", "Not Reported","Not Reported","Not Reported","Not Reported","Not Reported",1001,"Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported", "Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported","Not Reported",4,"Not Reported","Not Reported","Not Reported","Not Reported", "Not Reported","Not Reported","Not Reported"

Layout

RWIS CSV file layout by field number, csv column, header and sample data
Field Number CSV Column Header Data
1.1.1 1 index 49
1.1.2.1 2 recordDate 4/4/2016
1.1.2.2 3 recordTime 12:20:20
1.1.2.3 4 recordEpoch 1459797620
1.1.3.1 5 district 2
1.1.3.2 6 locationName Sims Road
1.1.3.3 7 nearbyPlace Castella
1.1.3.4 8 longitude -122.35592
1.1.3.5 9 latitude 41.07786
1.1.3.6 10 elevation 1804
1.1.3.7 11 direction North
1.1.3.8 12 county Shasta
1.1.3.9 13 route I-5
1.1.3.10 14 routeSuffix
1.1.3.11 15 postmilePrefix R
1.1.3.12 16 postmile 57.87
1.1.3.13 17 alignment
1.1.3.14 18 milepost 718.468
1.1.4 19 inService TRUE
1.1.5.1.1 20 essAtmosphericPressure Not Reported
1.1.5.2.1 21 essAvgWindDirection 1
1.1.5.2.2 22 essAvgWindSpeed 25
1.1.5.2.3 23 essSpotWindDirection 58
1.1.5.2.4 24 essSpotWindSpeed 17
1.1.5.2.5 25 essMaxWindGustSpeed 39
1.1.5.2.6 26 essMaxWindGustDir 334
1.1.5.3.1 27 essNumTemperatureSensors 1
1.1.5.3.2.1.2 28 essAirTemperature.1 166
1.1.5.3.3 29 essWetbulbTemp 83
1.1.5.3.4 30 essDewpointTemp -17
1.1.5.3.5 31 essMaxTemp 244
1.1.5.3.6 32 essMinTemp 101
1.1.5.4.1 33 essRelativeHumidity 28
1.1.5.4.2 34 essPrecipYesNo 2
1.1.5.4.3 35 essPrecipRate 0
1.1.5.4.4 36 essPrecipSituation 3
1.1.5.4.5 37 essPrecipitationStartTime 1458606690
1.1.5.4.6 38 essPrecipitationEndTime 1458609120
1.1.5.4.7 39 essPrecipitationOneHour 0
1.1.5.4.8 40 essPrecipitationThreeHours 0
1.1.5.4.9 41 essPrecipitationSixHours 0
1.1.5.4.10 42 essPrecipitationTwelveHours 0
1.1.5.4.11 43 essPrecipitation24Hours 0
1.1.5.6.1 44 essVisibility Not Reported
1.1.5.6.2 45 essVisibilitySituation Not Reported
1.1.5.7.1 46 numEssPavementSensors 4
1.1.5.7.2.1.2 47 essPavementSensorLocation.1 2;Surf Shasta I-5 57.84;;-122.35598;41.07785;1807;;Shasta;I-5;;;57.84;;
1.1.5.7.2.1.2 48 essPavementSensorLocation.2 2;Surf Shasta I-5 57.85;;-122.35592;41.07789;1807;;Shasta;I-5;;;57.85;;
1.1.5.7.2.1.2 49 essPavementSensorLocation.3 2;Surf Shasta I-5 57.83;;-122.35603;41.07764;1807;;Shasta;I-5;;;57.83;;
1.1.5.7.2.1.2 50 essPavementSensorLocation.4 2;Surf Shasta I-5 57.82;;-122.35603;41.07762;1807;;Shasta;I-5;;;57.82;;
1.1.5.7.2.1.2 51 essPavementSensorLocation.5 Not Reported
1.1.5.7.2.1.2 52 essPavementSensorLocation.6 Not Reported
1.1.5.7.2.1.2 53 essPavementSensorLocation.7 Not Reported
1.1.5.7.2.1.2 54 essPavementSensorLocation.8 Not Reported
1.1.5.7.2.1.3 55 essPavementType.1 3
1.1.5.7.2.1.3 56 essPavementType.2 3
1.1.5.7.2.1.3 57 essPavementType.3 3
1.1.5.7.2.1.3 58 essPavementType.4 3
1.1.5.7.2.1.3 59 essPavementType.5 Not Reported
1.1.5.7.2.1.3 60 essPavementType.6 Not Reported
1.1.5.7.2.1.3 61 essPavementType.7 Not Reported
1.1.5.7.2.1.3 62 essPavementType.8 Not Reported
1.1.5.7.2.1.4 63 essPavementSensorType.1 2
1.1.5.7.2.1.4 64 essPavementSensorType.2 2
1.1.5.7.2.1.4 65 essPavementSensorType.3 2
1.1.5.7.2.1.4 66 essPavementSensorType.4 2
1.1.5.7.2.1.4 67 essPavementSensorType.5 Not Reported
1.1.5.7.2.1.4 68 essPavementSensorType.6 Not Reported
1.1.5.7.2.1.4 69 essPavementSensorType.7 Not Reported
1.1.5.7.2.1.4 70 essPavementSensorType.8 Not Reported
1.1.5.7.2.1.5 71 essSurfaceStatus.1 2
1.1.5.7.2.1.5 72 essSurfaceStatus.2 3
1.1.5.7.2.1.5 73 essSurfaceStatus.3 3
1.1.5.7.2.1.5 74 essSurfaceStatus.4 3
1.1.5.7.2.1.5 75 essSurfaceStatus.5 Not Reported
1.1.5.7.2.1.5 76 essSurfaceStatus.6 Not Reported
1.1.5.7.2.1.5 77 essSurfaceStatus.7 Not Reported
1.1.5.7.2.1.5 78 essSurfaceStatus.8 Not Reported
1.1.5.7.2.1.6 79 essSurfaceTemperature.1 1001
1.1.5.7.2.1.6 80 essSurfaceTemperature.2 281
1.1.5.7.2.1.6 81 essSurfaceTemperature.3 274
1.1.5.7.2.1.6 82 essSurfaceTemperature.4 271
1.1.5.7.2.1.6 83 essSurfaceTemperature.5 Not Reported
1.1.5.7.2.1.6 84 essSurfaceTemperature.6 Not Reported
1.1.5.7.2.1.6 85 essSurfaceTemperature.7 Not Reported
1.1.5.7.2.1.6 86 essSurfaceTemperature.8 Not Reported
1.1.5.7.2.1.7 87 essSurfaceSalinity.1 65535
1.1.5.7.2.1.7 88 essSurfaceSalinity.2 65535
1.1.5.7.2.1.7 89 essSurfaceSalinity.3 65535
1.1.5.7.2.1.7 90 essSurfaceSalinity.4 65535
1.1.5.7.2.1.7 91 essSurfaceSalinity.5 Not Reported
1.1.5.7.2.1.7 92 essSurfaceSalinity.6 Not Reported
1.1.5.7.2.1.7 93 essSurfaceSalinity.7 Not Reported
1.1.5.7.2.1.7 94 essSurfaceSalinity.8 Not Reported
1.1.5.7.2.1.8 95 essSurfaceFreezePoint.1 1001
1.1.5.7.2.1.8 96 essSurfaceFreezePoint.2 1001
1.1.5.7.2.1.8 97 essSurfaceFreezePoint.3 1001
1.1.5.7.2.1.8 98 essSurfaceFreezePoint.4 1001
1.1.5.7.2.1.8 99 essSurfaceFreezePoint.5 Not Reported
1.1.5.7.2.1.8 100 essSurfaceFreezePoint.6 Not Reported
1.1.5.7.2.1.8 101 essSurfaceFreezePoint.7 Not Reported
1.1.5.7.2.1.8 102 essSurfaceFreezePoint.8 Not Reported
1.1.5.7.2.1.9 103 essSurfaceBlackIceSignal.1 1
1.1.5.7.2.1.9 104 essSurfaceBlackIceSignal.2 1
1.1.5.7.2.1.9 105 essSurfaceBlackIceSignal.3 1
1.1.5.7.2.1.9 106 essSurfaceBlackIceSignal.4 1
1.1.5.7.2.1.9 107 essSurfaceBlackIceSignal.5 Not Reported
1.1.5.7.2.1.9 108 essSurfaceBlackIceSignal.6 Not Reported
1.1.5.7.2.1.9 109 essSurfaceBlackIceSignal.7 Not Reported
1.1.5.7.2.1.9 110 essSurfaceBlackIceSignal.8 Not Reported
1.1.5.7.2.1.10 111 essPavementSensorError.1 3
1.1.5.7.2.1.10 112 essPavementSensorError.2 2
1.1.5.7.2.1.10 113 essPavementSensorError.3 2
1.1.5.7.2.1.10 114 essPavementSensorError.4 2
1.1.5.7.2.1.10 115 essPavementSensorError.5 Not Reported
1.1.5.7.2.1.10 116 essPavementSensorError.6 Not Reported
1.1.5.7.2.1.10 117 essPavementSensorError.7 Not Reported
1.1.5.7.2.1.10 118 essPavementSensorError.8 Not Reported
1.1.5.7.2.1.11 119 essSurfaceIceOrWaterDepth.1 65535
1.1.5.7.2.1.11 120 essSurfaceIceOrWaterDepth.2 65535
1.1.5.7.2.1.11 121 essSurfaceIceOrWaterDepth.3 65535
1.1.5.7.2.1.11 122 essSurfaceIceOrWaterDepth.4 65535
1.1.5.7.2.1.11 123 essSurfaceIceOrWaterDepth.5 Not Reported
1.1.5.7.2.1.11 124 essSurfaceIceOrWaterDepth.6 Not Reported
1.1.5.7.2.1.11 125 essSurfaceIceOrWaterDepth.7 Not Reported
1.1.5.7.2.1.11 126 essSurfaceIceOrWaterDepth.8 Not Reported
1.1.5.7.2.1.12 127 essSurfaceConductivityV2.1 Not Reported
1.1.5.7.2.1.12 128 essSurfaceConductivityV2.2 Not Reported
1.1.5.7.2.1.12 129 essSurfaceConductivityV2.3 Not Reported
1.1.5.7.2.1.12 130 essSurfaceConductivityV2.4 Not Reported
1.1.5.7.2.1.12 131 essSurfaceConductivityV2.5 Not Reported
1.1.5.7.2.1.12 132 essSurfaceConductivityV2.6 Not Reported
1.1.5.7.2.1.12 133 essSurfaceConductivityV2.7 Not Reported
1.1.5.7.2.1.12 134 essSurfaceConductivityV2.8 Not Reported
1.1.5.7.3 135 numEssSubSurfaceSensors 1
1.1.5.7.4.1.2 136 essSubSurfaceSensorLocation.1 2;Sub Shasta I-5 57.84;;-122.35597;41.07787;1807;;Shasta;I-5;;;57.84;;
1.1.5.7.4.1.2 137 essSubSurfaceSensorLocation.2 Not Reported
1.1.5.7.4.1.2 138 essSubSurfaceSensorLocation.3 Not Reported
1.1.5.7.4.1.2 139 essSubSurfaceSensorLocation.4 Not Reported
1.1.5.7.4.1.2 140 essSubSurfaceSensorLocation.5 Not Reported
1.1.5.7.4.1.2 141 essSubSurfaceSensorLocation.6 Not Reported
1.1.5.7.4.1.2 142 essSubSurfaceSensorLocation.7 Not Reported
1.1.5.7.4.1.2 143 essSubSurfaceSensorLocation.8 Not Reported
1.1.5.7.4.1.3 144 essSubSurfaceType.1 2
1.1.5.7.4.1.3 145 essSubSurfaceType.2 Not Reported
1.1.5.7.4.1.3 146 essSubSurfaceType.3 Not Reported
1.1.5.7.4.1.3 147 essSubSurfaceType.4 Not Reported
1.1.5.7.4.1.3 148 essSubSurfaceType.5 Not Reported
1.1.5.7.4.1.3 149 essSubSurfaceType.6 Not Reported
1.1.5.7.4.1.3 150 essSubSurfaceType.7 Not Reported
1.1.5.7.4.1.3 151 essSubSurfaceType.8 Not Reported
1.1.5.7.4.1.4 152 essSubSurfaceDepth.1 1001
1.1.5.7.4.1.4 153 essSubSurfaceDepth.2 Not Reported
1.1.5.7.4.1.4 154 essSubSurfaceDepth.3 Not Reported
1.1.5.7.4.1.4 155 essSubSurfaceDepth.4 Not Reported
1.1.5.7.4.1.4 156 essSubSurfaceDepth.5 Not Reported
1.1.5.7.4.1.4 157 essSubSurfaceDepth.6 Not Reported
1.1.5.7.4.1.4 158 essSubSurfaceDepth.7 Not Reported
1.1.5.7.4.1.4 159 essSubSurfaceDepth.8 Not Reported
1.1.5.7.4.1.5 160 essSubSurfaceTemperature.1 1001
1.1.5.7.4.1.5 161 essSubSurfaceTemperature.2 Not Reported
1.1.5.7.4.1.5 162 essSubSurfaceTemperature.3 Not Reported
1.1.5.7.4.1.5 163 essSubSurfaceTemperature.4 Not Reported
1.1.5.7.4.1.5 164 essSubSurfaceTemperature.5 Not Reported
1.1.5.7.4.1.5 165 essSubSurfaceTemperature.6 Not Reported
1.1.5.7.4.1.5 166 essSubSurfaceTemperature.7 Not Reported
1.1.5.7.4.1.5 167 essSubSurfaceTemperature.8 Not Reported
1.1.5.7.4.1.6 168 essSubSurfaceMoisture.1 Not Reported
1.1.5.7.4.1.6 169 essSubSurfaceMoisture.2 Not Reported
1.1.5.7.4.1.6 170 essSubSurfaceMoisture.3 Not Reported
1.1.5.7.4.1.6 171 essSubSurfaceMoisture.4 Not Reported
1.1.5.7.4.1.6 172 essSubSurfaceMoisture.5 Not Reported
1.1.5.7.4.1.6 173 essSubSurfaceMoisture.6 Not Reported
1.1.5.7.4.1.6 174 essSubSurfaceMoisture.7 Not Reported
1.1.5.7.4.1.6 175 essSubSurfaceMoisture.8 Not Reported
1.1.5.7.4.1.7 176 essSubSurfaceSensorError.1 4
1.1.5.7.4.1.7 177 essSubSurfaceSensorError.2 Not Reported
1.1.5.7.4.1.7 178 essSubSurfaceSensorError.3 Not Reported
1.1.5.7.4.1.7 179 essSubSurfaceSensorError.4 Not Reported
1.1.5.7.4.1.7 180 essSubSurfaceSensorError.5 Not Reported
1.1.5.7.4.1.7 181 essSubSurfaceSensorError.6 Not Reported
1.1.5.7.4.1.7 182 essSubSurfaceSensorError.7 Not Reported
1.1.5.7.4.1.7 183 essSubSurfaceSensorError.8 Not Reported