! 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-28 12|0.000|cm|24|hours|97502|
9515O_MADIS|CONCORD 0.8 WNW, CA|37.97832|-122.01340|41 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94519|
9122S_MADIS|STOCKTON 0.7 E, CA|37.96917|-121.29340|5 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95204|
8916S_MADIS|KNEELAND 0.4 NNW, CA|40.76588|-123.99850|622 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95549|
8240H_MADIS|SALYER 1.4 ESE, CA|40.88732|-123.55930|214 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95563|
8237H_MADIS|GOLETA 3.7 WNW, CA|34.43967|-119.89610|53 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|93117|
7925S_MADIS|JACKSONVILLE 0.5 SSW, OR|42.30601|-122.97160|512 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|97530|
7887S_MADIS|HEALDSBURG 12.6 NNW, CA|38.78390|-122.96280|321 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95425|
7885S_MADIS|BELMONT 0.7 WSW, CA|37.51041|-122.30570|136 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94002|
7877S_MADIS|SAN LORENZO 0.5 NNW, CA|37.68209|-122.13320|7 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94580|
7871C_MADIS|WINDSOR 0.6 NNE, CA|38.55336|-122.79290|46 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95492|
7869C_MADIS|SANTA ROSA 1.3 NW, CA|38.46403|-122.71500|51 meters|snowfall|2012-06-28 12|0.000|cm|24|hours|95404|
7824S_MADIS|BUTTE COUNTY, CA|39.49320|-121.47700|204 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95966|
7700C_MADIS|BOONVILLE 2.2 WSW, CA|39.00623|-123.40840|338 meters|snowfall|2012-06-27 16|0.000|cm|24|hours|95415|
6699S_MADIS|WILLIAMS 1 N, OR|42.26470|-123.25770|405 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|97544|
6698S_MADIS|O'BRIEN 2 SW, OR|42.05250|-123.71360|452 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97523|
6690S_MADIS|GOLD HILL 0.2 WSW, OR|42.43347|-123.05310|340 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97525|
6687S_MADIS|CENTRAL POINT 5.7 NW, OR|42.43344|-122.98690|470 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97502|
6680S_MADIS|ASHLAND 1 WNW, OR|42.19440|-122.71850|604 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97520|
6679S_MADIS|MEDFORD 3 SSE, OR|42.30389|-122.83470|480 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97504|
6678S_MADIS|JACKSONVILLE 10 S, OR|42.16900|-122.99120|596 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|97530|
6675S_MADIS|CENTRAL POINT 10 N, OR|42.48750|-122.94810|392 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|97502|
6674S_MADIS|ASHLAND 1 SE, OR|42.17830|-122.68810|668 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97520|
6673A_MADIS|VISALIA 0.7 SSE, CA|36.31525|-119.31760|101 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|93277|
6665A_MADIS|TRINITY CENTER 0.6 ESE, CA|40.98264|-122.69650|747 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|96091|
6657A_MADIS|DOUGLAS CITY 2.4 SW, CA|40.63264|-122.97770|516 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|96024|
6649A_MADIS|KNIGHTS FERRY 5.2 WSW, CA|37.78925|-120.75180|54 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95361|
6646A_MADIS|ROHNERT PARK 0.9 ESE, CA|38.34507|-122.68120|37 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94928|
6644S_MADIS|GOLD BEACH 4.8 NE, OR|42.50293|-124.36580|106 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|97444|
6642S_MADIS|BANDON 11.4 S, OR|42.94000|-124.44600|32 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97450|
6640S_MADIS|BROOKINGS 4.2 ENE, OR|42.07067|-124.21020|33 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97415|
6638A_MADIS|ROHNERT PARK 0.9 SW, CA|38.33921|-122.71130|28 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94928|
6637A_MADIS|GLEN ELLEN 1.9 WNW, CA|38.36513|-122.57180|309 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95404|
6625A_MADIS|SANTA ROSA 2.6 NE, CA|38.47276|-122.66400|83 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|95409|
6621A_MADIS|SEBASTOPOL 1.1 SSE, CA|38.38421|-122.81910|52 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95472|
6617A_MADIS|MONTE RIO 1.6 W, CA|38.46356|-123.04160|12 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|95462|
6604A_MADIS|SEBASTOPOL 2.6 SSE, CA|38.36626|-122.80370|65 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95472|
6602A_MADIS|CLOVERDALE 3.2 ESE, CA|38.78100|-122.96300|242 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|95425|
6601A_MADIS|SANTA ROSA 3.1 NW, CA|38.47890|-122.74400|40 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95403|
6598A_MADIS|SANTA ROSA 4.7 S, CA|38.37807|-122.72530|29 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95407|
6596A_MADIS|WINDSOR 1.4 SE, CA|38.53173|-122.78000|40 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95492|
6593A_MADIS|PETALUMA 1.0 N, CA|38.25612|-122.62290|15 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|94954|
6579A_MADIS|GEYSERVILLE 10.6 WNW, CA|38.73674|-123.09820|402 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95425|
6573A_MADIS|WEED 5.4 N, CA|41.49489|-122.36970|933 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|96094|
6572A_MADIS|YREKA 4.5 S, CA|41.66513|-122.62080|898 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|96097|
6554A_MADIS|REDDING 3.7 N, CA|40.62608|-122.35850|188 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|96003|
6553A_MADIS|REDDING 7.9 NNE, CA|40.67211|-122.29130|215 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|96003|
6538A_MADIS|APTOS 2.6 E, CA|36.99610|-121.85360|120 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95003|
6535A_MADIS|BOULDER CREEK 3.6 NE, CA|37.18110|-122.09110|521 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95006|
6519A_MADIS|SARATOGA 0.5 N, CA|37.27482|-122.02270|110 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95070|
6511A_MADIS|MONTE SERENO 0.4 SSW, CA|37.23244|-121.99020|145 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95030|
6509A_MADIS|SUNNYVALE 1.9 SE, CA|37.36471|-122.00420|21 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94086|
6503A_MADIS|REDWOOD CITY 2.5 SW, CA|37.49311|-122.23990|0 meters|snowfall|2012-06-27 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-27 16|0.000|cm|24|hours|94019|
6495A_MADIS|TRACY 2.1 W, CA|37.73535|-121.46990|16 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95377|
6492A_MADIS|STOCKTON 5.8 NNE, CA|38.03812|-121.25470|12 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|95212|
6489A_MADIS|LINDEN 5.8 ENE, CA|38.06269|-121.00790|46 meters|snowfall|2012-06-28 12|0.000|cm|24|hours|95236|
6487A_MADIS|SAN FRANCISCO 2.8 WNW, CA|37.78340|-122.47010|54 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|94118|
6421A_MADIS|FOLSOM 1.2 SSE, CA|38.66002|-121.13950|112 meters|snowfall|2012-06-28 12|0.000|cm|24|hours|95630|
6419A_MADIS|CARMICHAEL 0.9 NE, CA|38.64294|-121.30590|40 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|95608|
6417A_MADIS|FOLSOM 3.4 ESE, CA|38.65458|-121.09070|179 meters|snowfall|2012-06-28 12|0.000|cm|24|hours|95630|
6415A_MADIS|CARMICHAEL 1.6 SW, CA|38.61728|-121.34040|32 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95608|
6338A_MADIS|CALISTOGA 0.4 SSE, CA|38.57640|-122.57800|107 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94515|
6314A_MADIS|REDWOOD VALLEY 1.5 ENE, CA|39.27233|-123.17850|278 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95470|
6313A_MADIS|REDWOOD VALLEY 1.3 WNW, CA|39.27205|-123.22660|244 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95470|
6312A_MADIS|WILLITS 6.0 WSW, CA|39.37000|-123.45000|556 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95490|
6309A_MADIS|UKIAH 0.6 ESE, CA|39.14133|-123.19940|181 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95482|
6305A_MADIS|ELK 1.8 NNE, CA|39.10543|-123.70620|52 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95466|
6297A_MADIS|SAN ANSELMO 0.4 NE, CA|37.98723|-122.56430|32 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|94960|
6277A_MADIS|LAKEPORT 2.5 N, CA|39.07893|-122.91690|417 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95453|
6272A_MADIS|HANFORD 3.6 N, CA|36.37689|-119.65270|81 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|93230|
6257A_MADIS|MIRANDA 4.1 SW, CA|40.20927|-123.89410|182 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95554|
6253A_MADIS|REDWAY 4.3 W, CA|40.10816|-123.90070|190 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95542|
6251A_MADIS|TRINIDAD 1.5 NNW, CA|41.07833|-124.15170|72 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95570|
6249A_MADIS|ORICK 5.9 SSW, CA|41.20841|-124.10270|177 meters|snowfall|2012-06-27 12|0.000|cm|24|hours|95570|
6248A_MADIS|BAYSIDE 1.8 SE, CA|40.82480|-124.03820|45 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95524|
6243A_MADIS|CLOVIS 2.9 N, CA|36.86111|-119.69310|119 meters|snowfall|2012-06-28 12|0.000|cm|24|hours|93611|
6233A_MADIS|ANTIOCH 2.2 WSW, CA|37.97856|-121.83810|56 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94509|
6232A_MADIS|MARTINEZ 2.2 SW, CA|37.97440|-122.13840|205 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94553|
6224A_MADIS|PLEASANT HILL 1.2 ESE, CA|37.94854|-122.05410|18 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94523|
6219A_MADIS|WALLACE 0.3 NE, CA|38.19666|-120.97280|96 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95252|
6214A_MADIS|CASTRO VALLEY 0.4 NNE, CA|37.71690|-122.05850|165 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|94552|
5419H_MADIS|WILLOW CREEK 4.5 NNE, CA|40.93918|-123.62360|203 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95573|
4661S_MADIS|OCCIDENTAL 2.8 SW, CA|38.36528|-122.97380|205 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95465|
4657S_MADIS|MONTAGUE 1.6 ESE, CA|41.71775|-122.50140|777 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|96064|
4643S_MADIS|FELTON 4.5 NNE, CA|37.10514|-122.04680|280 meters|snowfall|2012-06-28 12|0.000|cm|24|hours|95018|
4631S_MADIS|FOLSOM 0.6 NE, CA|38.68232|-121.13750|120 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95630|
4623S_MADIS|BIG SUR 9.5 NNW, CA|36.39802|-121.86850|349 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|93923|
4622S_MADIS|CARMEL VALLEY VILLAGE 5.4 WNW,|36.52180|-121.81000|46 meters|snowfall|2012-06-27 16|0.000|cm|24|hours|93923|
4610S_MADIS|PINE MOUNTAIN CLUB 1.4 ENE, CA|34.85000|-119.13330|1617 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|93225|
4603S_MADIS|HELM 2.7 NNE, CA|36.57017|-120.08920|57 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|93630|
4596S_MADIS|FREMONT 2.6 ESE, CA|37.51505|-121.95230|6 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94538|
4462C_MADIS|YREKA 0.9 WNW, CA|41.73260|-122.64950|823 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|96097|
4459C_MADIS|SAN JOSE 3.5 ENE, CA|37.31905|-121.78870|60 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95148|
4458C_MADIS|FOSTER CITY 1.3 SW, CA|37.54883|-122.25870|-1 meters|snowfall|2012-06-27 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-27 14|0.000|cm|24|hours|95045|
3747C_MADIS|PIEDMONT 1.0 SE, CA|37.81230|-122.21600|111 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94602|
3741B_MADIS|MORGAN HILL 1.4 SW, CA|37.11683|-121.65910|130 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95037|
3677C_MADIS|MCKINLEYVILLE 2.7 SE, CA|40.92310|-124.08400|102 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95519|
3068O_MADIS|OROVILLE 2.7 ENE, CA|39.51400|-121.51800|164 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95966|
2950O_MADIS|PINE MOUNTAIN CLUB 0.9 SSW, CA|34.83532|-119.16310|1847 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|93225|
2809O_MADIS|EUREKA 2.2 S, CA|40.76420|-124.14760|59 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|95503|
2640S_MADIS|CARMEL VALLEY VILLAGE 0.7 SSE,|36.47631|-121.71970|133 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|93924|
2638S_MADIS|HUMBOLDT COUNTY, CA|40.47343|-123.70130|810 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95526|
2562O_MADIS|LAYTONVILLE 1.1 SW, CA|39.67242|-123.48980|499 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95454|
2338O_MADIS|MILL VALLEY 1.5 S, CA|37.88630|-122.54400|78 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94941|
1984R_MADIS|UKIAH 4.3 S, CA|39.08327|-123.21910|222 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95482|
1982R_MADIS|SAN RAFAEL 3.9 NW, CA|38.02680|-122.54730|23 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94903|
1980R_MADIS|FRESNO 4.3 NNW, CA|36.83618|-119.82930|106 meters|snowfall|2012-06-27 13|0.000|cm|24|hours|93711|
1952B_MADIS|WHEATLAND 0.1 ENE, CA|39.01347|-121.42430|24 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95692|
1814B_MADIS|MARYSVILLE 5.0 N, CA|39.22407|-121.59400|21 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95901|
1765H_MADIS|CAVE JUNCTION 3.7 E, OR|42.15733|-123.57270|472 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|97523|
1669R_MADIS|WALNUT CREEK 1.4 SSE, CA|37.88460|-122.02850|83 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94596|
1634B_MADIS|EUREKA 3.0 SSW, CA|40.75698|-124.18140|31 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95503|
1633O_MADIS|HANFORD 1.2 WNW, CA|36.33137|-119.66680|72 meters|snowfall|2012-06-27 16|0.000|cm|24|hours|93230|
1590R_MADIS|SONOMA 1.9 NNW, CA|38.31627|-122.47260|83 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|95476|
1534B_MADIS|SUNNYVALE 3.6 S, CA|37.33445|-122.01800|54 meters|snowfall|2012-06-27 14|0.000|cm|24|hours|94087|
0525B_MADIS|LOS ALTOS HILLS 1.3 N, CA|37.38650|-122.13550|56 meters|snowfall|2012-06-27 15|0.000|cm|24|hours|94022|