! 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-04-25 00|0.000|cm|24|hours|97502| 9515O_MADIS|CONCORD 0.8 WNW, CA|37.97832|-122.01340|41 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94519| 9122S_MADIS|STOCKTON 0.7 E, CA|37.96917|-121.29340|5 meters|snowfall|2012-04-24 16|0.000|cm|24|hours|95204| 8916S_MADIS|KNEELAND 0.4 NNW, CA|40.76588|-123.99850|622 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95549| 8240H_MADIS|SALYER 1.4 ESE, CA|40.88732|-123.55930|214 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95563| 8141S_MADIS|MCKINLEYVILLE 4.3 E, CA|40.95266|-124.03370|55 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95519| 7885S_MADIS|BELMONT 0.7 WSW, CA|37.51041|-122.30570|136 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94002| 6698S_MADIS|O'BRIEN 2 SW, OR|42.05250|-123.71360|452 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97523| 6687S_MADIS|CENTRAL POINT 5.7 NW, OR|42.43344|-122.98690|470 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97502| 6686S_MADIS|ASHLAND 2.4 ESE, OR|42.17530|-122.65720|624 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97520| 6684S_MADIS|SHADY COVE 0.2 S, OR|42.60890|-122.81890|424 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|97539| 6684A_MADIS|DAVIS 0.8 NE, CA|38.56185|-121.72410|14 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95616| 6678S_MADIS|JACKSONVILLE 10 S, OR|42.16900|-122.99120|596 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97530| 6657A_MADIS|DOUGLAS CITY 2.4 SW, CA|40.63264|-122.97770|516 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|96024| 6649A_MADIS|KNIGHTS FERRY 5.2 WSW, CA|37.78925|-120.75180|54 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95361| 6646S_MADIS|GOLD BEACH 0.6 S, OR|42.40462|-124.41810|25 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|97444| 6646A_MADIS|ROHNERT PARK 0.9 ESE, CA|38.34507|-122.68120|37 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94928| 6643S_MADIS|PORT ORFORD 5.0 E, OR|42.73930|-124.39870|90 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97476| 6640S_MADIS|BROOKINGS 4.2 ENE, OR|42.07067|-124.21020|33 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97415| 6593A_MADIS|PETALUMA 1.0 N, CA|38.25612|-122.62290|15 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94954| 6587A_MADIS|SANTA ROSA 2.7 WSW, CA|38.43229|-122.74550|38 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|95401| 6581A_MADIS|SEBASTOPOL 3.7 WSW, CA|38.38520|-122.89280|115 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95472| 6573A_MADIS|WEED 5.4 N, CA|41.49489|-122.36970|933 meters|snowfall|2012-04-24 16|0.000|cm|24|hours|96094| 6572A_MADIS|YREKA 4.5 S, CA|41.66513|-122.62080|898 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|96097| 6566A_MADIS|REDDING 4.1 N, CA|40.63123|-122.35840|187 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|96003| 6564A_MADIS|REDDING 2.6 NNE, CA|40.60747|-122.34720|187 meters|snowfall|2012-04-24 16|0.000|cm|24|hours|96003| 6553A_MADIS|REDDING 7.9 NNE, CA|40.67211|-122.29130|215 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|96003| 6551A_MADIS|REDDING 2.9 NNE, CA|40.60890|-122.33880|199 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|96003| 6532A_MADIS|DAVENPORT 4.2 NW, CA|37.06508|-122.21780|136 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95017| 6519A_MADIS|SARATOGA 0.5 N, CA|37.27482|-122.02270|110 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95070| 6504A_MADIS|PORTOLA VALLEY 1.3 ENE, CA|37.38189|-122.19760|163 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94028| 6503A_MADIS|REDWOOD CITY 2.5 SW, CA|37.49311|-122.23990|0 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94063| 6502A_MADIS|HALF MOON BAY 0.5 SSW, CA|37.46300|-122.44080|13 meters|snowfall|2012-04-24 16|0.000|cm|24|hours|94019| 6499A_MADIS|PACIFICA 0.3 W, CA|37.61211|-122.48250|65 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94044| 6495A_MADIS|TRACY 2.1 W, CA|37.73535|-121.46990|16 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95377| 6494A_MADIS|STOCKTON 3.3 SE, CA|37.94172|-121.25850|5 meters|snowfall|2012-04-24 12|0.000|cm|24|hours|95206| 6492A_MADIS|STOCKTON 5.8 NNE, CA|38.03812|-121.25470|12 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|95212| 6491A_MADIS|STOCKTON 2.1 NW, CA|37.99120|-121.33330|5 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95207| 6489A_MADIS|LINDEN 5.8 ENE, CA|38.06269|-121.00790|46 meters|snowfall|2012-04-24 12|0.000|cm|24|hours|95236| 6487A_MADIS|SAN FRANCISCO 2.8 WNW, CA|37.78340|-122.47010|54 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94118| 6428A_MADIS|SACRAMENTO 4.1 NE, CA|38.60861|-121.41220|18 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95825| 6421A_MADIS|FOLSOM 1.2 SSE, CA|38.66002|-121.13950|112 meters|snowfall|2012-04-24 12|0.000|cm|24|hours|95630| 6419A_MADIS|CARMICHAEL 0.9 NE, CA|38.64294|-121.30590|40 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|95608| 6416A_MADIS|SACRAMENTO 8.0 NE, CA|38.63500|-121.36110|32 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|95821| 6415A_MADIS|CARMICHAEL 1.6 SW, CA|38.61728|-121.34040|32 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95608| 6388A_MADIS|ROSEVILLE 4.7 WNW, CA|38.78023|-121.37660|29 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95747| 6313A_MADIS|REDWOOD VALLEY 1.3 WNW, CA|39.27205|-123.22660|244 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95470| 6295A_MADIS|SAN ANSELMO 1.2 NNW, CA|37.99706|-122.58050|119 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94960| 6277A_MADIS|LAKEPORT 2.5 N, CA|39.07893|-122.91690|417 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95453| 6273A_MADIS|HANFORD 1.7 WNW, CA|36.33493|-119.67430|72 meters|snowfall|2012-04-24 23|0.000|cm|24|hours|93230| 6272A_MADIS|HANFORD 3.6 N, CA|36.37689|-119.65270|81 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93230| 6259A_MADIS|BAYVIEW 0.8 SE, CA|40.75630|-124.16610|57 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95503| 6253A_MADIS|REDWAY 4.3 W, CA|40.10816|-123.90070|190 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95542| 6252A_MADIS|MCKINLEYVILLE 2.3 NE, CA|40.97780|-124.08600|87 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95519| 6251A_MADIS|TRINIDAD 1.5 NNW, CA|41.07833|-124.15170|72 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95570| 6250A_MADIS|MCKINLEYVILLE 7.3 ESE, CA|40.89619|-123.99840|124 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|95525| 6249A_MADIS|ORICK 5.9 SSW, CA|41.20841|-124.10270|177 meters|snowfall|2012-04-24 12|0.000|cm|24|hours|95570| 6248A_MADIS|BAYSIDE 1.8 SE, CA|40.82480|-124.03820|45 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95524| 6247A_MADIS|ARCATA 1.1 NE, CA|40.88092|-124.06920|122 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95521| 6243A_MADIS|CLOVIS 2.9 N, CA|36.86111|-119.69310|119 meters|snowfall|2012-04-24 12|0.000|cm|24|hours|93611| 6234A_MADIS|CRESCENT CITY 5.5 NNE, CA|41.82403|-124.14820|28 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95531| 6233A_MADIS|ANTIOCH 2.2 WSW, CA|37.97856|-121.83810|56 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94509| 6232A_MADIS|MARTINEZ 2.2 SW, CA|37.97440|-122.13840|205 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94553| 6231A_MADIS|LAFAYETTE 1.9 WSW, CA|37.88832|-122.15260|159 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94549| 6224A_MADIS|PLEASANT HILL 1.2 ESE, CA|37.94854|-122.05410|18 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94523| 6219A_MADIS|WALLACE 0.3 NE, CA|38.19666|-120.97280|96 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95252| 6215A_MADIS|PLEASANTON 1.8 SSE, CA|37.64827|-121.87450|107 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94566| 6214A_MADIS|CASTRO VALLEY 0.4 NNE, CA|37.71690|-122.05850|165 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94552| 5419H_MADIS|WILLOW CREEK 4.5 NNE, CA|40.93918|-123.62360|203 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95573| 4669S_MADIS|DAVIS 2.7 W, CA|38.55229|-121.78550|20 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95616| 4657S_MADIS|MONTAGUE 1.6 ESE, CA|41.71775|-122.50140|777 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|96064| 4643S_MADIS|FELTON 4.5 NNE, CA|37.10514|-122.04680|280 meters|snowfall|2012-04-24 12|0.000|cm|24|hours|95018| 4623S_MADIS|BIG SUR 9.5 NNW, CA|36.39802|-121.86850|349 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93923| 4610S_MADIS|PINE MOUNTAIN CLUB 1.4 ENE, CA|34.85000|-119.13330|1617 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|93225| 4596S_MADIS|FREMONT 2.6 ESE, CA|37.51505|-121.95230|6 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94538| 4462C_MADIS|YREKA 0.9 WNW, CA|41.73260|-122.64950|823 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|96097| 4459C_MADIS|SAN JOSE 3.5 ENE, CA|37.31905|-121.78870|60 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95148| 4458C_MADIS|FOSTER CITY 1.3 SW, CA|37.54883|-122.25870|-1 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94404| 4316C_MADIS|PETROLIA 7.4 SE, CA|40.25161|-124.18230|102 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95558| 4227C_MADIS|SAN JUAN BAUTISTA 0.5 S, CA|36.83933|-121.53750|70 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95045| 4213S_MADIS|CAMPBELL 2.8 N, CA|37.31851|-121.96080|40 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95117| 3923B_MADIS|SAN MATEO 3.4 SSW, CA|37.51848|-122.34320|176 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94402| 3803B_MADIS|UPPER LAKE 3.6 W, CA|39.16820|-122.97780|453 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95485| 3747C_MADIS|PIEDMONT 1.0 SE, CA|37.81230|-122.21600|111 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94602| 3741B_MADIS|MORGAN HILL 1.4 SW, CA|37.11683|-121.65910|130 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95037| 3677C_MADIS|MCKINLEYVILLE 2.7 SE, CA|40.92310|-124.08400|102 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95519| 3068O_MADIS|OROVILLE 2.7 ENE, CA|39.51400|-121.51800|164 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95966| 2950O_MADIS|PINE MOUNTAIN CLUB 0.9 SSW, CA|34.83532|-119.16310|1847 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93225| 2809O_MADIS|EUREKA 2.2 S, CA|40.76420|-124.14760|59 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95503| 2808O_MADIS|KNEELAND 4.8 WNW, CA|40.78951|-124.07950|51 meters|snowfall|2012-04-25 01|0.000|cm|24|hours|95503| 2751B_MADIS|CHICO 1.7 SW, CA|39.73851|-121.83200|65 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|95926| 2687B_MADIS|REDDING 3.8 S, CA|40.51805|-122.36920|137 meters|snowfall|2012-04-24 13|0.000|cm|24|hours|96001| 2669B_MADIS|DAVIS 2.4 W, CA|38.55919|-121.78020|17 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95616| 2640S_MADIS|CARMEL VALLEY VILLAGE 0.7 SSE,|36.47631|-121.71970|133 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93924| 2638S_MADIS|HUMBOLDT COUNTY, CA|40.47343|-123.70130|810 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95526| 2128S_MADIS|SAN BENITO COUNTY, CA|36.84224|-121.36500|120 meters|snowfall|2012-04-24 07|0.000|cm|24|hours|95023| 1982R_MADIS|SAN RAFAEL 3.9 NW, CA|38.02680|-122.54730|23 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94903| 1980R_MADIS|FRESNO 4.3 NNW, CA|36.83618|-119.82930|106 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93711| 1975B_MADIS|BODEGA BAY 0.1 NNW, CA|38.32405|-123.03040|64 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94923| 1952B_MADIS|WHEATLAND 0.1 ENE, CA|39.01347|-121.42430|24 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95692| 1907R_MADIS|FRESNO COUNTY, CA|36.79804|-119.55350|129 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93657| 1821R_MADIS|BOULDER CREEK 3.0 NW, CA|37.16930|-122.16410|268 meters|snowfall|2012-04-24 16|0.000|cm|24|hours|95006| 1814B_MADIS|MARYSVILLE 5.0 N, CA|39.22407|-121.59400|21 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95901| 1765H_MADIS|CAVE JUNCTION 3.7 E, OR|42.15733|-123.57270|472 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97523| 1747H_MADIS|AGNESS 6.4 NE, OR|42.65017|-124.01710|77 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|97406| 1669R_MADIS|WALNUT CREEK 1.4 SSE, CA|37.88460|-122.02850|83 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|94596| 1610B_MADIS|CHICO 1.2 NNW, CA|39.76970|-121.81380|77 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95973| 1590R_MADIS|SONOMA 1.9 NNW, CA|38.31627|-122.47260|83 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|95476| 1534B_MADIS|SUNNYVALE 3.6 S, CA|37.33445|-122.01800|54 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94087| 1281B_MADIS|LOS OSOS 0.5 N, CA|35.32946|-120.83240|23 meters|snowfall|2012-04-24 14|0.000|cm|24|hours|93402| 0525B_MADIS|LOS ALTOS HILLS 1.3 N, CA|37.38650|-122.13550|56 meters|snowfall|2012-04-24 15|0.000|cm|24|hours|94022|