Skip to content

Instantly share code, notes, and snippets.

View eldang's full-sized avatar

Eldan Goldenberg eldang

View GitHub Profile
gistup
@eldang
eldang / buoy_data_by_day.csv
Last active August 29, 2015 14:18
How does surface water pH vary over time in Elliott Bay?
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 28 columns, instead of 26. in line 2.
Date,topDepth_m,bottomDepth_m,topTemp_degC,bottom_temp_degC,topSalinity_ppt,bottomSalinity_ppt,topChlorophyll_micro_g_per_l,bottomChlorophyll_micro_g_per_l,topDissolvedOxygen_mg_per_l,bottomDissolvedOxygen_mg_per_l,topDissolvedOxygen_percent,bottomDissolvedOxygen_percent,topTurbidity_NTU,bottomTurbidity_NTU,top_pH,bottom_pH,airTemp_degF,solarRadiation_w_per_sq_m,rainFall_in,relativeHumidity,windDir_deg,windSpeed_m_per_s,atmosPressure_in_Hg,topBattery_V,bottomBattery_V,battery24C_V,paramsOutOfRange
3/20/14,1.17534375,10.12034375,7.991770833,8.106770833,23.72,28.53260417,1.66875,1.595833333,8.923125,8.172916667,87.846875,83.27604167,1,1,7.675104167,8.194479167,44.06041667,,0,63.30729167,197.1145833,2.565625,30.28479167,12.88958333,12.83229167,12.496875,
3/21/14,1.196010417,10.14557292,8.197083333,8.0946875,24.93489583,28.60739583,1.2875,1.546875,8.786041667,8.162083333,87.61666667,83.19166667,0.626041667,0.973958333,7.676041667,8.195,45.24583333,,0,61.87604167,259.625,2.473958333,30.30916667,12.88645833,12.8479
@eldang
eldang / airdata.csv
Created April 1, 2015 23:03
One year of weather data from Elliott Bay. And an SVG illustration of typical conditions.
We can't make this file beautiful and searchable because it's too large.
Date,AirTemp_degF,RainFall_in,WindDir_deg,WindSpeed_m_s,AtmosPressure_inHg
3/20/14 0:00,42.2,0,113,2.5,30.19
3/20/14 0:15,42.4,0,124,2.3,30.19
3/20/14 0:30,42,0,139,2.1,30.2
3/20/14 0:45,42,0,135,2.7,30.2
3/20/14 1:00,42,0,122,2.5,30.2
3/20/14 1:15,41.9,0,110,3.9,30.2
3/20/14 1:30,41.5,0,113,3.5,30.21
3/20/14 1:45,41.3,0,120,2.7,30.21
3/20/14 2:00,41.1,0,126,2.7,30.22
@eldang
eldang / Cleaned up data
Created March 21, 2015 00:14
Seattle Aquarium buoy, cleanest columns only
This file has been truncated, but you can view the full file.
Date,Air Temperature (�F),Rain Fall (inch),Wind Direction (degrees),Wind Speed (m/sec),Atmosphere Pressure (in Hg)
3/20/14 0:00,42.2,0,113,2.5,30.19
3/20/14 0:15,42.4,0,124,2.3,30.19
3/20/14 0:30,42,0,139,2.1,30.2
3/20/14 0:45,42,0,135,2.7,30.2
3/20/14 1:00,42,0,122,2.5,30.2
3/20/14 1:15,41.9,0,110,3.9,30.2
3/20/14 1:30,41.5,0,113,3.5,30.21
3/20/14 1:45,41.3,0,120,2.7,30.21
3/20/14 2:00,41.1,0,126,2.7,30.22
@eldang
eldang / Seattle Aquarium buoy 20140320 - 20150320
Created March 20, 2015 23:59
Elliott Bay water monitoring data
This file has been truncated, but you can view the full file.
Date,Top Depth (m),Bottom Depth (m),Top Temperature (°C),Bottom Temperature (°C),Top Salinity (ppt),Bottom Salinity (ppt),Top Chlorophyll (µg/l),Bottom Chlorophyll (µg/l),Top Dissolved Oxygen (mg/l),Bottom Dissolved Oxygen (mg/l),Top Dissolved Oxygen (%),Bottom Dissolved Oxygen (%),Top Turbidity (NTU),Bottom Turbidity (NTU),Top pH,Bottom pH,Air Temperature (°F),Solar Radiation (watts/sq meter),Rain Fall (inch),Relative Humidity (%),Wind Direction (degrees),Wind Speed (m/sec),Atmosphere Pressure (in Hg),Top Battery (V),Bottom Battery (V),Battery 24C (V),EndCheckCondition,Parameters Out Of Range
3/20/14 0:00,1.034,10.019,7.69,8.19,18.45,27.9,1.4,1,9.47,8.45,89.5,86,2.4,1,7.66,8.21,42.2,,0,68.4,113,2.5,30.19,12.9,12.8,12.4,Top DO (Good); Bottom DO (N/A); Top Chlorophyll (Fair); Bottom Chlorophyll (N/A); Top Turbidity (Good); Bottom Turbidity (N/A); Top pH (Good); Bottom pH (N/A); ,
3/20/14 0:15,0.989,9.983,7.7,8.19,18.46,27.89,2.8,2.4,9.46,8.46,89.4,86,2.5,1.1,7.66,8.22,42.4,,0,68.8,124,2.3,30.19,12.9,12.8,12.5,