! THESE DATA ARE UNOFFICIAL AND PROVISIONAL Station_Id|Name|Latitude|Longitude|Elevation|Physical_Element|DateTime_Report(UTC)|Amount|Amount_Units|Duration|Duration_Units|Zip_Code| MFR|MEDFORD, OR|42.37420|-122.87330|399 meters|snowfall|2012-06-02 12|0.000|cm|24|hours|97502| 9515O_MADIS|CONCORD 0.8 WNW, CA|37.97832|-122.01340|41 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94519| 9122S_MADIS|STOCKTON 0.7 E, CA|37.96917|-121.29340|5 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95204| 8237H_MADIS|GOLETA 3.7 WNW, CA|34.43967|-119.89610|53 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93117| 7925S_MADIS|JACKSONVILLE 0.5 SSW, OR|42.30601|-122.97160|512 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|97530| 7887S_MADIS|HEALDSBURG 12.6 NNW, CA|38.78390|-122.96280|321 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95425| 7885S_MADIS|BELMONT 0.7 WSW, CA|37.51041|-122.30570|136 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94002| 7869C_MADIS|SANTA ROSA 1.3 NW, CA|38.46403|-122.71500|51 meters|snowfall|2012-06-01 13|0.000|cm|24|hours|95404| 7700C_MADIS|BOONVILLE 2.2 WSW, CA|39.00623|-123.40840|338 meters|snowfall|2012-06-01 16|0.000|cm|24|hours|95415| 6688S_MADIS|JACKSONVILLE 8.9 WSW, OR|42.27630|-123.13860|525 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97530| 6687S_MADIS|CENTRAL POINT 5.7 NW, OR|42.43344|-122.98690|470 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97502| 6684S_MADIS|SHADY COVE 0.2 S, OR|42.60890|-122.81890|424 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|97539| 6681S_MADIS|ASHLAND 1.0 SSE, OR|42.17565|-122.69550|781 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97520| 6674S_MADIS|ASHLAND 1 SE, OR|42.17830|-122.68810|668 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|97520| 6673S_MADIS|ASHLAND 1.4 ESE, OR|42.17940|-122.67640|638 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|97520| 6673A_MADIS|VISALIA 0.7 SSE, CA|36.31525|-119.31760|101 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93277| 6660S_MADIS|DAYS CREEK 1 N, OR|42.94190|-123.03060|313 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97429| 6657A_MADIS|DOUGLAS CITY 2.4 SW, CA|40.63264|-122.97770|516 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|96024| 6649A_MADIS|KNIGHTS FERRY 5.2 WSW, CA|37.78925|-120.75180|54 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95361| 6644S_MADIS|GOLD BEACH 4.8 NE, OR|42.50293|-124.36580|106 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|97444| 6643S_MADIS|PORT ORFORD 5.0 E, OR|42.73930|-124.39870|90 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97476| 6640S_MADIS|BROOKINGS 4.2 ENE, OR|42.07067|-124.21020|33 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97415| 6638A_MADIS|ROHNERT PARK 0.9 SW, CA|38.33921|-122.71130|28 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94928| 6637A_MADIS|GLEN ELLEN 1.9 WNW, CA|38.36513|-122.57180|309 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95404| 6621A_MADIS|SEBASTOPOL 1.1 SSE, CA|38.38421|-122.81910|52 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95472| 6602A_MADIS|CLOVERDALE 3.2 ESE, CA|38.78100|-122.96300|242 meters|snowfall|2012-06-01 13|0.000|cm|24|hours|95425| 6601A_MADIS|SANTA ROSA 3.1 NW, CA|38.47890|-122.74400|40 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95403| 6598A_MADIS|SANTA ROSA 4.7 S, CA|38.37807|-122.72530|29 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95407| 6596A_MADIS|WINDSOR 1.4 SE, CA|38.53173|-122.78000|40 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95492| 6590A_MADIS|SEBASTOPOL 4.5 WSW, CA|38.37526|-122.90350|137 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95472| 6576A_MADIS|ROHNERT PARK 1.6 WNW, CA|38.35222|-122.72740|27 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94928| 6573A_MADIS|WEED 5.4 N, CA|41.49489|-122.36970|933 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|96094| 6553A_MADIS|REDDING 7.9 NNE, CA|40.67211|-122.29130|215 meters|snowfall|2012-06-02 11|0.000|cm|24|hours|96003| 6547A_MADIS|COTTONWOOD 0.5 NNE, CA|40.39710|-122.27600|139 meters|snowfall|2012-06-01 13|0.000|cm|24|hours|96022| 6519A_MADIS|SARATOGA 0.5 N, CA|37.27482|-122.02270|110 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95070| 6503A_MADIS|REDWOOD CITY 2.5 SW, CA|37.49311|-122.23990|0 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94063| 6502A_MADIS|HALF MOON BAY 0.5 SSW, CA|37.46300|-122.44080|13 meters|snowfall|2012-06-01 16|0.000|cm|24|hours|94019| 6499A_MADIS|PACIFICA 0.3 W, CA|37.61211|-122.48250|65 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|94044| 6489A_MADIS|LINDEN 5.8 ENE, CA|38.06269|-121.00790|46 meters|snowfall|2012-06-02 12|0.000|cm|24|hours|95236| 6425A_MADIS|SACRAMENTO 2.0 SE, CA|38.54990|-121.43740|9 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95817| 6419A_MADIS|CARMICHAEL 0.9 NE, CA|38.64294|-121.30590|40 meters|snowfall|2012-06-01 13|0.000|cm|24|hours|95608| 6415A_MADIS|CARMICHAEL 1.6 SW, CA|38.61728|-121.34040|32 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95608| 6325A_MADIS|CASTROVILLE 1.6 ENE, CA|36.77642|-121.72840|7 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93907| 6313A_MADIS|REDWOOD VALLEY 1.3 WNW, CA|39.27205|-123.22660|244 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95470| 6312A_MADIS|WILLITS 6.0 WSW, CA|39.37000|-123.45000|556 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95490| 6310A_MADIS|HOPLAND 2.4 WNW, CA|38.98439|-123.15800|174 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95449| 6307A_MADIS|UKIAH 1.2 NW, CA|39.15829|-123.22480|224 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95482| 6305A_MADIS|ELK 1.8 NNE, CA|39.10543|-123.70620|52 meters|snowfall|2012-06-01 17|0.000|cm|24|hours|95466| 6297A_MADIS|SAN ANSELMO 0.4 NE, CA|37.98723|-122.56430|32 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|94960| 6277A_MADIS|LAKEPORT 2.5 N, CA|39.07893|-122.91690|417 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95453| 6272A_MADIS|HANFORD 3.6 N, CA|36.37689|-119.65270|81 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93230| 6257A_MADIS|MIRANDA 4.1 SW, CA|40.20927|-123.89410|182 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95554| 6256A_MADIS|REDWAY 4.8 WNW, CA|40.13869|-123.90610|566 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95560| 6252A_MADIS|MCKINLEYVILLE 2.3 NE, CA|40.97780|-124.08600|87 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95519| 6249A_MADIS|ORICK 5.9 SSW, CA|41.20841|-124.10270|177 meters|snowfall|2012-06-01 13|0.000|cm|24|hours|95570| 6248A_MADIS|BAYSIDE 1.8 SE, CA|40.82480|-124.03820|45 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95524| 6243A_MADIS|CLOVIS 2.9 N, CA|36.86111|-119.69310|119 meters|snowfall|2012-06-02 11|0.000|cm|24|hours|93611| 6233A_MADIS|ANTIOCH 2.2 WSW, CA|37.97856|-121.83810|56 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94509| 4661S_MADIS|OCCIDENTAL 2.8 SW, CA|38.36528|-122.97380|205 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95465| 4657S_MADIS|MONTAGUE 1.6 ESE, CA|41.71775|-122.50140|777 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|96064| 4648S_MADIS|IGO 0.2 S, CA|40.50318|-122.54130|331 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|96001| 4621B_MADIS|DUBLIN 1.2 WNW, CA|37.72234|-121.93110|107 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94568| 4619S_MADIS|CATHEYS VALLEY 1.2 S, CA|37.41525|-120.09980|362 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95306| 4610S_MADIS|PINE MOUNTAIN CLUB 1.4 ENE, CA|34.85000|-119.13330|1617 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|93225| 4603S_MADIS|HELM 2.7 NNE, CA|36.57017|-120.08920|57 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93630| 4597S_MADIS|BERKELEY 3.8 ESE, CA|37.85567|-122.23010|258 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|94618| 4463C_MADIS|SANTA ROSA 3.1 W, CA|38.45143|-122.75770|32 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95403| 4462C_MADIS|YREKA 0.9 WNW, CA|41.73260|-122.64950|823 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|96097| 4458C_MADIS|FOSTER CITY 1.3 SW, CA|37.54883|-122.25870|-1 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|94404| 4227C_MADIS|SAN JUAN BAUTISTA 0.5 S, CA|36.83933|-121.53750|70 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95045| 3747C_MADIS|PIEDMONT 1.0 SE, CA|37.81230|-122.21600|111 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94602| 3068O_MADIS|OROVILLE 2.7 ENE, CA|39.51400|-121.51800|164 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95966| 2751B_MADIS|CHICO 1.7 SW, CA|39.73851|-121.83200|65 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95926| 2640S_MADIS|CARMEL VALLEY VILLAGE 0.7 SSE,|36.47631|-121.71970|133 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93924| 2562O_MADIS|LAYTONVILLE 1.1 SW, CA|39.67242|-123.48980|499 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95454| 2338O_MADIS|MILL VALLEY 1.5 S, CA|37.88630|-122.54400|78 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94941| 1984R_MADIS|UKIAH 4.3 S, CA|39.08327|-123.21910|222 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|95482| 1983R_MADIS|LA GRANGE 7.8 ESE, CA|37.63544|-120.32730|339 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95329| 1980R_MADIS|FRESNO 4.3 NNW, CA|36.83618|-119.82930|106 meters|snowfall|2012-06-02 01|0.000|cm|24|hours|93711| 1975B_MADIS|BODEGA BAY 0.1 NNW, CA|38.32405|-123.03040|64 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|94923| 1815B_MADIS|SUTTER 0.3 W, CA|39.15962|-121.75110|24 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95982| 1814B_MADIS|MARYSVILLE 5.0 N, CA|39.22407|-121.59400|21 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|95901| 1747H_MADIS|AGNESS 6.4 NE, OR|42.65017|-124.01710|77 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|97406| 1281B_MADIS|LOS OSOS 0.5 N, CA|35.32946|-120.83240|23 meters|snowfall|2012-06-01 14|0.000|cm|24|hours|93402| 0525B_MADIS|LOS ALTOS HILLS 1.3 N, CA|37.38650|-122.13550|56 meters|snowfall|2012-06-01 15|0.000|cm|24|hours|94022|