! 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|1309 feet|snowfall|2012-06-27 00|0.000|in|24|hours|97502| 9515O_MADIS|CONCORD 0.8 WNW, CA|37.97832|-122.01340|135 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94519| 8237H_MADIS|GOLETA 3.7 WNW, CA|34.43967|-119.89610|174 feet|snowfall|2012-06-26 13|0.000|in|24|hours|93117| 7885S_MADIS|BELMONT 0.7 WSW, CA|37.51041|-122.30570|446 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94002| 7871C_MADIS|WINDSOR 0.6 NNE, CA|38.55336|-122.79290|151 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95492| 7869C_MADIS|SANTA ROSA 1.3 NW, CA|38.46403|-122.71500|167 feet|snowfall|2012-06-26 12|0.000|in|24|hours|95404| 7824S_MADIS|BUTTE COUNTY, CA|39.49320|-121.47700|669 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95966| 7700C_MADIS|BOONVILLE 2.2 WSW, CA|39.00623|-123.40840|1109 feet|snowfall|2012-06-26 16|0.000|in|24|hours|95415| 6690S_MADIS|GOLD HILL 0.2 WSW, OR|42.43347|-123.05310|1115 feet|snowfall|2012-06-26 14|0.000|in|24|hours|97525| 6687S_MADIS|CENTRAL POINT 5.7 NW, OR|42.43344|-122.98690|1542 feet|snowfall|2012-06-26 14|0.000|in|24|hours|97502| 6686S_MADIS|ASHLAND 2.4 ESE, OR|42.17530|-122.65720|2047 feet|snowfall|2012-06-26 14|0.000|in|24|hours|97520| 6649A_MADIS|KNIGHTS FERRY 5.2 WSW, CA|37.78925|-120.75180|177 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95361| 6646A_MADIS|ROHNERT PARK 0.9 ESE, CA|38.34507|-122.68120|121 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94928| 6640S_MADIS|BROOKINGS 4.2 ENE, OR|42.07067|-124.21020|108 feet|snowfall|2012-06-26 14|0.000|in|24|hours|97415| 6638A_MADIS|ROHNERT PARK 0.9 SW, CA|38.33921|-122.71130|92 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94928| 6637A_MADIS|GLEN ELLEN 1.9 WNW, CA|38.36513|-122.57180|1014 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95404| 6625A_MADIS|SANTA ROSA 2.6 NE, CA|38.47276|-122.66400|272 feet|snowfall|2012-06-26 12|0.000|in|24|hours|95409| 6621A_MADIS|SEBASTOPOL 1.1 SSE, CA|38.38421|-122.81910|171 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95472| 6617A_MADIS|MONTE RIO 1.6 W, CA|38.46356|-123.04160|39 feet|snowfall|2012-06-26 16|0.000|in|24|hours|95462| 6604A_MADIS|SEBASTOPOL 2.6 SSE, CA|38.36626|-122.80370|213 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95472| 6602A_MADIS|CLOVERDALE 3.2 ESE, CA|38.78100|-122.96300|794 feet|snowfall|2012-06-26 13|0.000|in|24|hours|95425| 6596A_MADIS|WINDSOR 1.4 SE, CA|38.53173|-122.78000|131 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95492| 6593A_MADIS|PETALUMA 1.0 N, CA|38.25612|-122.62290|49 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94954| 6590A_MADIS|SEBASTOPOL 4.5 WSW, CA|38.37526|-122.90350|449 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95472| 6576A_MADIS|ROHNERT PARK 1.6 WNW, CA|38.35222|-122.72740|89 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94928| 6572A_MADIS|YREKA 4.5 S, CA|41.66513|-122.62080|2946 feet|snowfall|2012-06-26 13|0.000|in|24|hours|96097| 6552A_MADIS|REDDING 2.7 NNW, CA|40.61044|-122.38020|712 feet|snowfall|2012-06-26 03|0.000|in|24|hours|96003| 6538A_MADIS|APTOS 2.6 E, CA|36.99610|-121.85360|394 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95003| 6536A_MADIS|SCOTTS VALLEY 1.7 SW, CA|37.03955|-122.02950|581 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95066| 6535A_MADIS|BOULDER CREEK 3.6 NE, CA|37.18110|-122.09110|1709 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95006| 6519A_MADIS|SARATOGA 0.5 N, CA|37.27482|-122.02270|361 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95070| 6513A_MADIS|SAN JOSE 4.6 NE, CA|37.35433|-121.79550|299 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95127| 6511A_MADIS|MONTE SERENO 0.4 SSW, CA|37.23244|-121.99020|476 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95030| 6509A_MADIS|SUNNYVALE 1.9 SE, CA|37.36471|-122.00420|69 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94086| 6502A_MADIS|HALF MOON BAY 0.5 SSW, CA|37.46300|-122.44080|43 feet|snowfall|2012-06-26 16|0.000|in|24|hours|94019| 6495A_MADIS|TRACY 2.1 W, CA|37.73535|-121.46990|52 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95377| 6494A_MADIS|STOCKTON 3.3 SE, CA|37.94172|-121.25850|16 feet|snowfall|2012-06-26 13|0.000|in|24|hours|95206| 6492A_MADIS|STOCKTON 5.8 NNE, CA|38.03812|-121.25470|39 feet|snowfall|2012-06-26 13|0.000|in|24|hours|95212| 6489A_MADIS|LINDEN 5.8 ENE, CA|38.06269|-121.00790|151 feet|snowfall|2012-06-26 12|0.000|in|24|hours|95236| 6435A_MADIS|SACRAMENTO 5.7 SSE, CA|38.49278|-121.41950|30 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95828| 6428A_MADIS|SACRAMENTO 4.1 NE, CA|38.60861|-121.41220|59 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95825| 6421A_MADIS|FOLSOM 1.2 SSE, CA|38.66002|-121.13950|367 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95630| 6419A_MADIS|CARMICHAEL 0.9 NE, CA|38.64294|-121.30590|131 feet|snowfall|2012-06-26 13|0.000|in|24|hours|95608| 6338A_MADIS|CALISTOGA 0.4 SSE, CA|38.57640|-122.57800|351 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94515| 6314A_MADIS|REDWOOD VALLEY 1.5 ENE, CA|39.27233|-123.17850|912 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95470| 6313A_MADIS|REDWOOD VALLEY 1.3 WNW, CA|39.27205|-123.22660|801 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95470| 6310A_MADIS|HOPLAND 2.4 WNW, CA|38.98439|-123.15800|571 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95449| 6309A_MADIS|UKIAH 0.6 ESE, CA|39.14133|-123.19940|594 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95482| 6307A_MADIS|UKIAH 1.2 NW, CA|39.15829|-123.22480|735 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95482| 6297A_MADIS|SAN ANSELMO 0.4 NE, CA|37.98723|-122.56430|105 feet|snowfall|2012-06-26 15|0.000|in|24|hours|94960| 6273A_MADIS|HANFORD 1.7 WNW, CA|36.33493|-119.67430|236 feet|snowfall|2012-06-26 23|0.000|in|24|hours|93230| 6272A_MADIS|HANFORD 3.6 N, CA|36.37689|-119.65270|266 feet|snowfall|2012-06-26 14|0.000|in|24|hours|93230| 6259A_MADIS|BAYVIEW 0.8 SE, CA|40.75630|-124.16610|187 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95503| 6249A_MADIS|ORICK 5.9 SSW, CA|41.20841|-124.10270|581 feet|snowfall|2012-06-26 13|0.000|in|24|hours|95570| 6243A_MADIS|CLOVIS 2.9 N, CA|36.86111|-119.69310|390 feet|snowfall|2012-06-26 14|0.000|in|24|hours|93611| 6233A_MADIS|ANTIOCH 2.2 WSW, CA|37.97856|-121.83810|184 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94509| 6232A_MADIS|MARTINEZ 2.2 SW, CA|37.97440|-122.13840|673 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94553| 6224A_MADIS|PLEASANT HILL 1.2 ESE, CA|37.94854|-122.05410|59 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94523| 6214A_MADIS|CASTRO VALLEY 0.4 NNE, CA|37.71690|-122.05850|541 feet|snowfall|2012-06-26 15|0.000|in|24|hours|94552| 5419H_MADIS|WILLOW CREEK 4.5 NNE, CA|40.93918|-123.62360|666 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95573| 4661S_MADIS|OCCIDENTAL 2.8 SW, CA|38.36528|-122.97380|673 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95465| 4643S_MADIS|FELTON 4.5 NNE, CA|37.10514|-122.04680|919 feet|snowfall|2012-06-26 12|0.000|in|24|hours|95018| 4621B_MADIS|DUBLIN 1.2 WNW, CA|37.72234|-121.93110|351 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94568| 4610S_MADIS|PINE MOUNTAIN CLUB 1.4 ENE, CA|34.85000|-119.13330|5305 feet|snowfall|2012-06-26 15|0.000|in|24|hours|93225| 4597S_MADIS|BERKELEY 3.8 ESE, CA|37.85567|-122.23010|846 feet|snowfall|2012-06-26 15|0.000|in|24|hours|94618| 4596S_MADIS|FREMONT 2.6 ESE, CA|37.51505|-121.95230|20 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94538| 4463C_MADIS|SANTA ROSA 3.1 W, CA|38.45143|-122.75770|105 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95403| 4459C_MADIS|SAN JOSE 3.5 ENE, CA|37.31905|-121.78870|197 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95148| 4458C_MADIS|FOSTER CITY 1.3 SW, CA|37.54883|-122.25870|-3 feet|snowfall|2012-06-26 15|0.000|in|24|hours|94404| 4227C_MADIS|SAN JUAN BAUTISTA 0.5 S, CA|36.83933|-121.53750|230 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95045| 4213S_MADIS|CAMPBELL 2.8 N, CA|37.31851|-121.96080|131 feet|snowfall|2012-06-26 15|0.000|in|24|hours|95117| 4209S_MADIS|CASTROVILLE 1.6 ENE, CA|36.77700|-121.72690|16 feet|snowfall|2012-06-26 15|0.000|in|24|hours|93907| 3747C_MADIS|PIEDMONT 1.0 SE, CA|37.81230|-122.21600|364 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94602| 3741B_MADIS|MORGAN HILL 1.4 SW, CA|37.11683|-121.65910|427 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95037| 3068O_MADIS|OROVILLE 2.7 ENE, CA|39.51400|-121.51800|538 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95966| 2640S_MADIS|CARMEL VALLEY VILLAGE 0.7 SSE,|36.47631|-121.71970|436 feet|snowfall|2012-06-26 14|0.000|in|24|hours|93924| 2638S_MADIS|HUMBOLDT COUNTY, CA|40.47343|-123.70130|2657 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95526| 2338O_MADIS|MILL VALLEY 1.5 S, CA|37.88630|-122.54400|256 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94941| 1984R_MADIS|UKIAH 4.3 S, CA|39.08327|-123.21910|728 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95482| 1982R_MADIS|SAN RAFAEL 3.9 NW, CA|38.02680|-122.54730|75 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94903| 1980R_MADIS|FRESNO 4.3 NNW, CA|36.83618|-119.82930|348 feet|snowfall|2012-06-26 13|0.000|in|24|hours|93711| 1814B_MADIS|MARYSVILLE 5.0 N, CA|39.22407|-121.59400|69 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95901| 1669R_MADIS|WALNUT CREEK 1.4 SSE, CA|37.88460|-122.02850|272 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94596| 1633O_MADIS|HANFORD 1.2 WNW, CA|36.33137|-119.66680|236 feet|snowfall|2012-06-26 16|0.000|in|24|hours|93230| 1590R_MADIS|SONOMA 1.9 NNW, CA|38.31627|-122.47260|272 feet|snowfall|2012-06-26 14|0.000|in|24|hours|95476| 1534B_MADIS|SUNNYVALE 3.6 S, CA|37.33445|-122.01800|177 feet|snowfall|2012-06-26 14|0.000|in|24|hours|94087| 1281B_MADIS|LOS OSOS 0.5 N, CA|35.32946|-120.83240|75 feet|snowfall|2012-06-26 14|0.000|in|24|hours|93402| 0525B_MADIS|LOS ALTOS HILLS 1.3 N, CA|37.38650|-122.13550|184 feet|snowfall|2012-06-26 15|0.000|in|24|hours|94022|