Search for the Bigquery platform using search bar
Hit +ADD to access datasets
Then hit public datasets
Then pick your set
Use Left hand side scroll bar to view climate datasets
Click into Climate to view available datasets
Select GHCN Daily
Click on Samples
Click on Run this query to Find Weather Stations
Find weather stations close to a specific location.
This query will return all the stations close to Chicago (latitude=41.88, longitude=-87.63). Run this query in the BigQuery UI.
Hit Run button to execute query
Click on Save results to save to a file
Select save method CSV (Local file)
File can now be viewed on Local drive
Create an email
Attach file
Hit SEND
id,name,state,latitude,longitude
USC00111562,CHICAGO SAN DIST OFC ,IL,41.9,-87.6333
US1ILCK0117,CHICAGO 3.0 NW ,IL,41.9125,-87.6695
US1ILCK0108,BEVERLY 0.3 N ,IL,41.7165,-87.671
US1ILCK0104,LINCOLNWOOD 5.1 SE ,IL,41.9494,-87.6703
US1ILCK0151,EVERGREEN PARK 0.5 NE ,IL,41.7274,-87.6949
US1ILCK0122,CHICAGO 6.5 NNE ,IL,41.9272,-87.6517
USC00111557,CHICAGO RACINE PUMP ,IL,41.8167,-87.65
US1ILCK0097,CHICAGO 6.8 NNE ,IL,41.9301,-87.6393
USC00111584,CHICAGO WB CITY 2 ,IL,41.8833,-87.6333
US1ILCK0010,CHICAGO 3.0 N ,IL,41.8798,-87.6823
USW00014892,CHICAGO UNIV ,IL,41.7833,-87.6
USC00111532,CHICAGO LAKEVIEW PUMP ,IL,41.9667,-87.6667
US1ILCK0204,BOOT CAMP-CHICAGO 4.2 SW ,IL,41.8421,-87.6891
US1ILCK0036,CHICAGO 4.7 NE ,IL,41.886,-87.621
USC00111550,CHICAGO NORTHERLY IS ,IL,41.8558,-87.6094
US1ILCK0168,RAVENSWOOD MANOR 0.1 ESE ,IL,41.9642,-87.6974
US1ILCK0032,CHICAGO 6.4 NNE ,IL,41.9266,-87.6562
USC00111564,CHICAGO S WTR FILT PLT ,IL,41.75,-87.55
US1ILCK0214,ROGERS PARK 1.5 SW ,IL,41.9957,-87.6918
US1ILCK0055,CHICAGO 6.0 NNE ,IL,41.917,-87.6386
US1ILCK0014,CHICAGO 5.5 ESE ,IL,41.8008,-87.5903
US1ILCK0179,CHICAGO 4.8 NNW ,IL,41.9481,-87.6588
US1ILCK0240,CHICAGO 2.7 WNW ,IL,41.9018,-87.6726
USC00111526,CHICAGO GRANT PARK ,IL,41.8833,-87.6167
USW00014881,FORT DEARBORN ,IL,41.8883,-87.6258
No comments:
Post a Comment