RWIS TXT 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

Delimeter

ÿ

Layout

RWIS TXT file layout by field number, 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