Coding Assingment. 2 (Python/Sql)

Posted Under: Python

Ask A Question
DESCRIPTION
Posted
Modified
Viewed 16
The main assingment is called assingment-2-data-context, all other information is in CSV files. I need help complementing the assignment by the deadline.
Attachments
for_students/assignment2-data-context-content.ipynb { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "###### University of Chicago\n", "###### DATA 25900: Ethics, Fairness, Responsibility, and Privacy in Data Science, Spring 2022\n", "###### Course Staff: Raul Castro Fernandez, Zhiru Zhu" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Problem 1 - Warmup (5 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 1.1 The dataset `class-grades-mod.csv` represents grades for students of a class. What is the average grade on the 'Final' exam? In this case, when dealing with missing values an oracle tells you that any missing value is missing completely at random (MCAR). (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Problem 2 - Dealing with Missing Data (45 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "A self-driving company is testing a new concept for a self-driving car. As part of the pilot test, there is a human inside the vehicle every time the vehicle goes on for a trip. The vehicle is equipped with sensors that collect different data streams. Every time a trip is over, a computer collects data from the vehicle's sensors and some input from the human. The resulting dataset is then loaded into a database ([SQLite](https://www.sqlite.org/index.html), in this case), where it becomes available for analysis to other data scientists downstream.\n", "\n", "The data scientist who used to work with the database has left the company. Coincidentally, the database is down, so you cannot access it directly. Fortunately, the previous scientist did a good job in hardening the *pipeline* and there exists a backup copy of the database ('data/travel-times.sql') as a SQL script.\n", "\n", "Before leaving, the previous data scientist left a brief note: \"there are some missing values in this dataset\"." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.0 Open `travel-times.sql` (you can open it in plain text to read it) and get familiar with the content. Load the content into SQLite. You can work with the dataset using SQLite directly. Or you may want to transform it first into a dataframe and work with it from Pandas. If you choose the latter, you have many options. These are two for you to consider: i) [read the sql table from pandas](https://pandas.pydata.org/docs/reference/api/pandas.read_sql.html); ii) export the data in SQLite into a CSV file first, and then read it from pandas. " ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.1 How many cells have a missing value? Note the pipeline of stages here, from the moment where the data is generated to the moment where it gets to you is a bit more complex than in the past. Think carefully about what may go 'wrong' while the data flows through that pipeline. (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.2 We want to understand what is a typical distance travelled. We know the car reliably measures the 'Distance' travelled in kilometers. This data, however, cannot be directly fed into the database, so the analyst reads it and inputs it manually. However, the analyst apparently forgets inputting the data sometimes, leading to some missing values. Before analyzing the results, fix the data in the 'Distance' column using the following methods:" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.2.1 Fix 'Distance' by dropping missing values. (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.2.2 Fix 'Distance' by using LOCF (last observation carried forward) hot-deck imputation. (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.2.3 Fix 'Distance' by using mean imputation. (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.2.4 Fix 'Distance' by using multiple imputation. We suggest 'MICE', which has an implementation (IterativeImputer) with sklearn, [here](https://scikit-learn.org/stable/modules/generated/sklearn.impute.IterativeImputer.html#sklearn.impute.IterativeImputer) (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.3 All the above methods are common ways of dealing with missing values. Step back and concentrate on the original problem in 2.2. How would you fix the missing values? Which approach would you choose if you had to show this data to a decision-maker and you want to make the case that you have a reasonable and *interpretable* method? (You cannot drop values in this case and you may think of approaches beyond the ones in 2.2.2-2.2.4). (10 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.4 After deciding an imputation strategy, how would you present the 'fixed' dataset to the decision-maker? Note the decision-make may use the dataset directly, or have more components of a pipeline in use. Create the dataset you would present the decision maker and show it here along with a brief description of what you did. (5 points)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 2.5 The data in the 'Distance' column is missing because an analyst sometimes forgets inputting it from the vehicle. Every time this happens, the repercusions affect every other analysts downstream. You do not want to deal with missing data when it can be avoided. What changes would you make to the pipeline (hint: to the database schema) so that if the analyst inputing the data forgets to include 'Distance' they'll receive a notification/error or any other indication that they have not finished their job? (5 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 3. Data in the Wild (30 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### This is a snapshot from March 23 from a [dataset provided by the City of Chicago](https://data.cityofchicago.org/Parks-Recreation/Beach-Weather-Stations-Automated-Sensors/k7hf-8y75) through their open data portal. The dataset contains historial data up to March 23. Take a look." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "df1 = pd.read_csv(\"data/Beach_Weather_Stations_-_Automated_Sensors-03-23-22.csv\")" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Station Name</th>\n", " <th>Measurement Timestamp</th>\n", " <th>Air Temperature</th>\n", " <th>Wet Bulb Temperature</th>\n", " <th>Humidity</th>\n", " <th>Rain Intensity</th>\n", " <th>Interval Rain</th>\n", " <th>Total Rain</th>\n", " <th>Precipitation Type</th>\n", " <th>Wind Direction</th>\n", " <th>Wind Speed</th>\n", " <th>Maximum Wind Speed</th>\n", " <th>Barometric Pressure</th>\n", " <th>Solar Radiation</th>\n", " <th>Heading</th>\n", " <th>Battery Life</th>\n", " <th>Measurement Timestamp Label</th>\n", " <th>Measurement ID</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>0</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 10:00:00 AM</td>\n", " <td>16.40</td>\n", " <td>12.2</td>\n", " <td>61</td>\n", " <td>0.0</td>\n", " <td>0.00</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>231</td>\n", " <td>2.5</td>\n", " <td>4.7</td>\n", " <td>996.3</td>\n", " <td>484</td>\n", " <td>356.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 10:00 AM</td>\n", " <td>63rdStreetWeatherStation201809271000</td>\n", " </tr>\n", " <tr>\n", " <th>1</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 11:00:00 AM</td>\n", " <td>17.10</td>\n", " <td>11.5</td>\n", " <td>51</td>\n", " <td>0.0</td>\n", " <td>0.00</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>244</td>\n", " <td>3.6</td>\n", " <td>5.7</td>\n", " <td>995.4</td>\n", " <td>468</td>\n", " <td>356.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 11:00 AM</td>\n", " <td>63rdStreetWeatherStation201809271100</td>\n", " </tr>\n", " <tr>\n", " <th>2</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 01:00:00 PM</td>\n", " <td>18.20</td>\n", " <td>12.4</td>\n", " <td>51</td>\n", " <td>0.0</td>\n", " <td>0.00</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>248</td>\n", " <td>3.1</td>\n", " <td>5.3</td>\n", " <td>994.8</td>\n", " <td>377</td>\n", " <td>355.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 1:00 PM</td>\n", " <td>63rdStreetWeatherStation201809271300</td>\n", " </tr>\n", " <tr>\n", " <th>3</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/27/2018 01:00:00 PM</td>\n", " <td>17.89</td>\n", " <td>NaN</td>\n", " <td>39</td>\n", " <td>NaN</td>\n", " <td>0.00</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>249</td>\n", " <td>1.4</td>\n", " <td>2.3</td>\n", " <td>993.6</td>\n", " <td>0</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/27/2018 1:00 PM</td>\n", " <td>FosterWeatherStation201809271300</td>\n", " </tr>\n", " <tr>\n", " <th>4</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 03:00:00 PM</td>\n", " <td>19.50</td>\n", " <td>13.0</td>\n", " <td>47</td>\n", " <td>0.0</td>\n", " <td>0.00</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>249</td>\n", " <td>3.1</td>\n", " <td>5.7</td>\n", " <td>992.9</td>\n", " <td>461</td>\n", " <td>355.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 3:00 PM</td>\n", " <td>63rdStreetWeatherStation201809271500</td>\n", " </tr>\n", " <tr>\n", " <th>...</th>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " </tr>\n", " <tr>\n", " <th>131608</th>\n", " <td>Foster Weather Station</td>\n", " <td>03/23/2022 02:00:00 PM</td>\n", " <td>7.06</td>\n", " <td>NaN</td>\n", " <td>88</td>\n", " <td>NaN</td>\n", " <td>0.00</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>0</td>\n", " <td>3.3</td>\n", " <td>0.0</td>\n", " <td>974.9</td>\n", " <td>223</td>\n", " <td>NaN</td>\n", " <td>15.2</td>\n", " <td>03/23/2022 2:00 PM</td>\n", " <td>FosterWeatherStation202203231400</td>\n", " </tr>\n", " <tr>\n", " <th>131609</th>\n", " <td>Oak Street Weather Station</td>\n", " <td>03/23/2022 02:00:00 PM</td>\n", " <td>7.00</td>\n", " <td>6.6</td>\n", " <td>94</td>\n", " <td>0.0</td>\n", " <td>0.00</td>\n", " <td>67.3</td>\n", " <td>0.0</td>\n", " <td>48</td>\n", " <td>1.0</td>\n", " <td>1.3</td>\n", " <td>976.2</td>\n", " <td>203</td>\n", " <td>358.0</td>\n", " <td>11.8</td>\n", " <td>03/23/2022 2:00 PM</td>\n", " <td>OakStreetWeatherStation202203231400</td>\n", " </tr>\n", " <tr>\n", " <th>131610</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>03/23/2022 03:00:00 PM</td>\n", " <td>7.50</td>\n", " <td>7.5</td>\n", " <td>100</td>\n", " <td>0.0</td>\n", " <td>0.40</td>\n", " <td>9.3</td>\n", " <td>60.0</td>\n", " <td>335</td>\n", " <td>1.2</td>\n", " <td>1.8</td>\n", " <td>975.1</td>\n", " <td>18</td>\n", " <td>351.0</td>\n", " <td>11.9</td>\n", " <td>03/23/2022 3:00 PM</td>\n", " <td>63rdStreetWeatherStation202203231500</td>\n", " </tr>\n", " <tr>\n", " <th>131611</th>\n", " <td>Foster Weather Station</td>\n", " <td>03/23/2022 03:00:00 PM</td>\n", " <td>6.00</td>\n", " <td>NaN</td>\n", " <td>88</td>\n", " <td>NaN</td>\n", " <td>1.27</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>0</td>\n", " <td>3.3</td>\n", " <td>0.0</td>\n", " <td>974.3</td>\n", " <td>23</td>\n", " <td>NaN</td>\n", " <td>15.2</td>\n", " <td>03/23/2022 3:00 PM</td>\n", " <td>FosterWeatherStation202203231500</td>\n", " </tr>\n", " <tr>\n", " <th>131612</th>\n", " <td>Oak Street Weather Station</td>\n", " <td>03/23/2022 03:00:00 PM</td>\n", " <td>7.30</td>\n", " <td>6.9</td>\n", " <td>95</td>\n", " <td>9.0</td>\n", " <td>2.10</td>\n", " <td>69.4</td>\n", " <td>60.0</td>\n", " <td>17</td>\n", " <td>1.1</td>\n", " <td>1.6</td>\n", " <td>975.9</td>\n", " <td>15</td>\n", " <td>357.0</td>\n", " <td>11.9</td>\n", " <td>03/23/2022 3:00 PM</td>\n", " <td>OakStreetWeatherStation202203231500</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "<p>131613 rows � 18 columns</p>\n", "</div>" ], "text/plain": [ " Station Name Measurement Timestamp Air Temperature \\\n", "0 63rd Street Weather Station 09/27/2018 10:00:00 AM 16.40 \n", "1 63rd Street Weather Station 09/27/2018 11:00:00 AM 17.10 \n", "2 63rd Street Weather Station 09/27/2018 01:00:00 PM 18.20 \n", "3 Foster Weather Station 09/27/2018 01:00:00 PM 17.89 \n", "4 63rd Street Weather Station 09/27/2018 03:00:00 PM 19.50 \n", "... ... ... ... \n", "131608 Foster Weather Station 03/23/2022 02:00:00 PM 7.06 \n", "131609 Oak Street Weather Station 03/23/2022 02:00:00 PM 7.00 \n", "131610 63rd Street Weather Station 03/23/2022 03:00:00 PM 7.50 \n", "131611 Foster Weather Station 03/23/2022 03:00:00 PM 6.00 \n", "131612 Oak Street Weather Station 03/23/2022 03:00:00 PM 7.30 \n", "\n", " Wet Bulb Temperature Humidity Rain Intensity Interval Rain \\\n", "0 12.2 61 0.0 0.00 \n", "1 11.5 51 0.0 0.00 \n", "2 12.4 51 0.0 0.00 \n", "3 NaN 39 NaN 0.00 \n", "4 13.0 47 0.0 0.00 \n", "... ... ... ... ... \n", "131608 NaN 88 NaN 0.00 \n", "131609 6.6 94 0.0 0.00 \n", "131610 7.5 100 0.0 0.40 \n", "131611 NaN 88 NaN 1.27 \n", "131612 6.9 95 9.0 2.10 \n", "\n", " Total Rain Precipitation Type Wind Direction Wind Speed \\\n", "0 260.3 0.0 231 2.5 \n", "1 260.3 0.0 244 3.6 \n", "2 260.3 0.0 248 3.1 \n", "3 NaN NaN 249 1.4 \n", "4 260.3 0.0 249 3.1 \n", "... ... ... ... ... \n", "131608 NaN NaN 0 3.3 \n", "131609 67.3 0.0 48 1.0 \n", "131610 9.3 60.0 335 1.2 \n", "131611 NaN NaN 0 3.3 \n", "131612 69.4 60.0 17 1.1 \n", "\n", " Maximum Wind Speed Barometric Pressure Solar Radiation Heading \\\n", "0 4.7 996.3 484 356.0 \n", "1 5.7 995.4 468 356.0 \n", "2 5.3 994.8 377 355.0 \n", "3 2.3 993.6 0 NaN \n", "4 5.7 992.9 461 355.0 \n", "... ... ... ... ... \n", "131608 0.0 974.9 223 NaN \n", "131609 1.3 976.2 203 358.0 \n", "131610 1.8 975.1 18 351.0 \n", "131611 0.0 974.3 23 NaN \n", "131612 1.6 975.9 15 357.0 \n", "\n", " Battery Life Measurement Timestamp Label \\\n", "0 11.9 09/27/2018 10:00 AM \n", "1 11.9 09/27/2018 11:00 AM \n", "2 11.9 09/27/2018 1:00 PM \n", "3 15.1 09/27/2018 1:00 PM \n", "4 11.9 09/27/2018 3:00 PM \n", "... ... ... \n", "131608 15.2 03/23/2022 2:00 PM \n", "131609 11.8 03/23/2022 2:00 PM \n", "131610 11.9 03/23/2022 3:00 PM \n", "131611 15.2 03/23/2022 3:00 PM \n", "131612 11.9 03/23/2022 3:00 PM \n", "\n", " Measurement ID \n", "0 63rdStreetWeatherStation201809271000 \n", "1 63rdStreetWeatherStation201809271100 \n", "2 63rdStreetWeatherStation201809271300 \n", "3 FosterWeatherStation201809271300 \n", "4 63rdStreetWeatherStation201809271500 \n", "... ... \n", "131608 FosterWeatherStation202203231400 \n", "131609 OakStreetWeatherStation202203231400 \n", "131610 63rdStreetWeatherStation202203231500 \n", "131611 FosterWeatherStation202203231500 \n", "131612 OakStreetWeatherStation202203231500 \n", "\n", "[131613 rows x 18 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df1" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### This is an updated dataset from April 1st." ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "df2 = pd.read_csv(\"data/Beach_Weather_Stations_-_Automated_Sensors_UPDATE_APRIL_1st.csv\")" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Station Name</th>\n", " <th>Measurement Timestamp</th>\n", " <th>Air Temperature</th>\n", " <th>Wet Bulb Temperature</th>\n", " <th>Humidity</th>\n", " <th>Rain Intensity</th>\n", " <th>Interval Rain</th>\n", " <th>Total Rain</th>\n", " <th>Precipitation Type</th>\n", " <th>Wind Direction</th>\n", " <th>Wind Speed</th>\n", " <th>Maximum Wind Speed</th>\n", " <th>Barometric Pressure</th>\n", " <th>Solar Radiation</th>\n", " <th>Heading</th>\n", " <th>Battery Life</th>\n", " <th>Measurement Timestamp Label</th>\n", " <th>Measurement ID</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>0</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 10:00:00 AM</td>\n", " <td>16.40</td>\n", " <td>12.2</td>\n", " <td>61</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>231</td>\n", " <td>2.5</td>\n", " <td>4.7</td>\n", " <td>996.3</td>\n", " <td>484</td>\n", " <td>356.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 10:00 AM</td>\n", " <td>63rdStreetWeatherStation201809271000</td>\n", " </tr>\n", " <tr>\n", " <th>1</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 11:00:00 AM</td>\n", " <td>17.10</td>\n", " <td>11.5</td>\n", " <td>51</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>244</td>\n", " <td>3.6</td>\n", " <td>5.7</td>\n", " <td>995.4</td>\n", " <td>468</td>\n", " <td>356.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 11:00 AM</td>\n", " <td>63rdStreetWeatherStation201809271100</td>\n", " </tr>\n", " <tr>\n", " <th>2</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 01:00:00 PM</td>\n", " <td>18.20</td>\n", " <td>12.4</td>\n", " <td>51</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>248</td>\n", " <td>3.1</td>\n", " <td>5.3</td>\n", " <td>994.8</td>\n", " <td>377</td>\n", " <td>355.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 1:00 PM</td>\n", " <td>63rdStreetWeatherStation201809271300</td>\n", " </tr>\n", " <tr>\n", " <th>3</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/27/2018 01:00:00 PM</td>\n", " <td>17.89</td>\n", " <td>NaN</td>\n", " <td>39</td>\n", " <td>NaN</td>\n", " <td>0.0</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>249</td>\n", " <td>1.4</td>\n", " <td>2.3</td>\n", " <td>993.6</td>\n", " <td>0</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/27/2018 1:00 PM</td>\n", " <td>FosterWeatherStation201809271300</td>\n", " </tr>\n", " <tr>\n", " <th>4</th>\n", " <td>63rd Street Weather Station</td>\n", " <td>09/27/2018 03:00:00 PM</td>\n", " <td>19.50</td>\n", " <td>13.0</td>\n", " <td>47</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>260.3</td>\n", " <td>0.0</td>\n", " <td>249</td>\n", " <td>3.1</td>\n", " <td>5.7</td>\n", " <td>992.9</td>\n", " <td>461</td>\n", " <td>355.0</td>\n", " <td>11.9</td>\n", " <td>09/27/2018 3:00 PM</td>\n", " <td>63rdStreetWeatherStation201809271500</td>\n", " </tr>\n", " <tr>\n", " <th>...</th>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " <td>...</td>\n", " </tr>\n", " <tr>\n", " <th>620</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/25/2015 07:00:00 AM</td>\n", " <td>18.56</td>\n", " <td>NaN</td>\n", " <td>81</td>\n", " <td>NaN</td>\n", " <td>0.0</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>68</td>\n", " <td>1.3</td>\n", " <td>1.4</td>\n", " <td>1001.4</td>\n", " <td>24</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/25/2015 7:00 AM</td>\n", " <td>FosterWeatherStation201509250700</td>\n", " </tr>\n", " <tr>\n", " <th>621</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/25/2015 08:00:00 AM</td>\n", " <td>18.39</td>\n", " <td>NaN</td>\n", " <td>86</td>\n", " <td>NaN</td>\n", " <td>0.0</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>37</td>\n", " <td>1.4</td>\n", " <td>1.6</td>\n", " <td>1001.4</td>\n", " <td>97</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/25/2015 8:00 AM</td>\n", " <td>FosterWeatherStation201509250800</td>\n", " </tr>\n", " <tr>\n", " <th>622</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/25/2015 09:00:00 AM</td>\n", " <td>18.89</td>\n", " <td>NaN</td>\n", " <td>84</td>\n", " <td>NaN</td>\n", " <td>0.0</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>40</td>\n", " <td>1.7</td>\n", " <td>2.0</td>\n", " <td>1002.0</td>\n", " <td>275</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/25/2015 9:00 AM</td>\n", " <td>FosterWeatherStation201509250900</td>\n", " </tr>\n", " <tr>\n", " <th>623</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/25/2015 10:00:00 AM</td>\n", " <td>18.78</td>\n", " <td>NaN</td>\n", " <td>82</td>\n", " <td>NaN</td>\n", " <td>0.0</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>56</td>\n", " <td>2.6</td>\n", " <td>2.9</td>\n", " <td>1002.0</td>\n", " <td>280</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/25/2015 10:00 AM</td>\n", " <td>FosterWeatherStation201509251000</td>\n", " </tr>\n", " <tr>\n", " <th>624</th>\n", " <td>Foster Weather Station</td>\n", " <td>09/25/2015 11:00:00 AM</td>\n", " <td>18.67</td>\n", " <td>NaN</td>\n", " <td>83</td>\n", " <td>NaN</td>\n", " <td>0.0</td>\n", " <td>NaN</td>\n", " <td>NaN</td>\n", " <td>5</td>\n", " <td>3.1</td>\n", " <td>3.8</td>\n", " <td>1002.0</td>\n", " <td>604</td>\n", " <td>NaN</td>\n", " <td>15.1</td>\n", " <td>09/25/2015 11:00 AM</td>\n", " <td>FosterWeatherStation201509251100</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "<p>625 rows � 18 columns</p>\n", "</div>" ], "text/plain": [ " Station Name Measurement Timestamp Air Temperature \\\n", "0 63rd Street Weather Station 09/27/2018 10:00:00 AM 16.40 \n", "1 63rd Street Weather Station 09/27/2018 11:00:00 AM 17.10 \n", "2 63rd Street Weather Station 09/27/2018 01:00:00 PM 18.20 \n", "3 Foster Weather Station 09/27/2018 01:00:00 PM 17.89 \n", "4 63rd Street Weather Station 09/27/2018 03:00:00 PM 19.50 \n", ".. ... ... ... \n", "620 Foster Weather Station 09/25/2015 07:00:00 AM 18.56 \n", "621 Foster Weather Station 09/25/2015 08:00:00 AM 18.39 \n", "622 Foster Weather Station 09/25/2015 09:00:00 AM 18.89 \n", "623 Foster Weather Station 09/25/2015 10:00:00 AM 18.78 \n", "624 Foster Weather Station 09/25/2015 11:00:00 AM 18.67 \n", "\n", " Wet Bulb Temperature Humidity Rain Intensity Interval Rain \\\n", "0 12.2 61 0.0 0.0 \n", "1 11.5 51 0.0 0.0 \n", "2 12.4 51 0.0 0.0 \n", "3 NaN 39 NaN 0.0 \n", "4 13.0 47 0.0 0.0 \n", ".. ... ... ... ... \n", "620 NaN 81 NaN 0.0 \n", "621 NaN 86 NaN 0.0 \n", "622 NaN 84 NaN 0.0 \n", "623 NaN 82 NaN 0.0 \n", "624 NaN 83 NaN 0.0 \n", "\n", " Total Rain Precipitation Type Wind Direction Wind Speed \\\n", "0 260.3 0.0 231 2.5 \n", "1 260.3 0.0 244 3.6 \n", "2 260.3 0.0 248 3.1 \n", "3 NaN NaN 249 1.4 \n", "4 260.3 0.0 249 3.1 \n", ".. ... ... ... ... \n", "620 NaN NaN 68 1.3 \n", "621 NaN NaN 37 1.4 \n", "622 NaN NaN 40 1.7 \n", "623 NaN NaN 56 2.6 \n", "624 NaN NaN 5 3.1 \n", "\n", " Maximum Wind Speed Barometric Pressure Solar Radiation Heading \\\n", "0 4.7 996.3 484 356.0 \n", "1 5.7 995.4 468 356.0 \n", "2 5.3 994.8 377 355.0 \n", "3 2.3 993.6 0 NaN \n", "4 5.7 992.9 461 355.0 \n", ".. ... ... ... ... \n", "620 1.4 1001.4 24 NaN \n", "621 1.6 1001.4 97 NaN \n", "622 2.0 1002.0 275 NaN \n", "623 2.9 1002.0 280 NaN \n", "624 3.8 1002.0 604 NaN \n", "\n", " Battery Life Measurement Timestamp Label \\\n", "0 11.9 09/27/2018 10:00 AM \n", "1 11.9 09/27/2018 11:00 AM \n", "2 11.9 09/27/2018 1:00 PM \n", "3 15.1 09/27/2018 1:00 PM \n", "4 11.9 09/27/2018 3:00 PM \n", ".. ... ... \n", "620 15.1 09/25/2015 7:00 AM \n", "621 15.1 09/25/2015 8:00 AM \n", "622 15.1 09/25/2015 9:00 AM \n", "623 15.1 09/25/2015 10:00 AM \n", "624 15.1 09/25/2015 11:00 AM \n", "\n", " Measurement ID \n", "0 63rdStreetWeatherStation201809271000 \n", "1 63rdStreetWeatherStation201809271100 \n", "2 63rdStreetWeatherStation201809271300 \n", "3 FosterWeatherStation201809271300 \n", "4 63rdStreetWeatherStation201809271500 \n", ".. ... \n", "620 FosterWeatherStation201509250700 \n", "621 FosterWeatherStation201509250800 \n", "622 FosterWeatherStation201509250900 \n", "623 FosterWeatherStation201509251000 \n", "624 FosterWeatherStation201509251100 \n", "\n", "[625 rows x 18 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df2" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Imagine you are responsible for this dataset. Use the [Great Expectations library in Python](https://greatexpectations.io) to create \"context\" for this data. This library will allow you to create rules (aka \"Expectations\") that the data should follow and then check later if those are invalidated. In this exercise, we ask you to use the library to create rules *automatically*. We want to concentrate on four columns: `Solar Radiation`, `Air Temperature`, `Wet Bulb Temperature`, and `Total Rain`. After creating the rules on the older file `Beach_Weather_Stations_-_Automated_Sensors-03-23-22.csv`, validate them on the newer one `Beach_Weather_Stations_-_Automated_Sensors_UPDATE_APRIL_1st.csv`. \n", "\n", "#### *Note*: follow the [getting started tutorial](https://docs.greatexpectations.io/docs/tutorials/getting_started/tutorial_overview) using the provided dataset instead of the dataset from the tutorial (so you don't need to clone the ge_tutorials repository), and eventually you should able to see the validation results in the Data Docs webpage." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 3.1 As a sanity check, for your validation results, what are the \"Evaluated Expectations\" and \"Success Percent\"? You should find the numbers in the \"Statistics\" section. (10 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 3.2 Describe the Expectations you created. Can you explain some of the 'anomalies' detected? What are your thoughts on the validation results? Include a free text response no longer than a reading response (10 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### 3.3 How do you imagine this software (the techniques behind it) could be used in practice? Include a free text response no longer than a reading response. (10 points)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.9" } }, "nbformat": 4, "nbformat_minor": 4 } for_students/data/class-grades-mod.csv Prefix Assignment Tutorial Midterm TakeHome Final padding 05 57.14 34.09 64.38 51.48 52.50 0 08 95.05 105.49 67.50 99.07 68.33 0 08 83.70 83.17 30.0 63.15 0 07 81.22 96.06 49.38 105.93 80.56 0 08 91.32 93.64 95.0 107.41 73.89 0 07 95.0 92.58 93.12 97.78 68.06 0 08 95.05 102.99 56.25 99.07 50.0 0 07 72.85 86.85 60.0 66 56.11 0 08 84.26 93.10 47.50 18.52 0 07 90.10 97.55 51.25 88.89 63.61 0 07 80.44 90.20 75.0 91.48 39.72 0 06 86.26 80.60 74.38 87.59 77.50 0 08 97.16 103.71 72.50 93.52 63.33 0 07 91.28 83.53 81.25 99.81 88 0 08 84.80 89.08 44.38 16.91 90 0 07 93.83 95.43 88.12 80.93 90.0 0 08 84.80 89.08 47.50 16.91 53.33 0 04 92.01 102.52 38.75 86.11 49.17 0 08 55.14 81.85 75.0 56.11 62.50 0 08 93.04 82.93 79.38 83.33 91.11 0 for_students/data/Beach_Weather_Stations_-_Automated_Sensors_UPDATE_APRIL_1st.csv Station Name Measurement Timestamp Air Temperature Wet Bulb Temperature Humidity Rain Intensity Interval Rain Total Rain Precipitation Type Wind Direction Wind Speed Maximum Wind Speed Barometric Pressure Solar Radiation Heading Battery Life Measurement Timestamp Label Measurement ID 63rd Street Weather Station 09/27/2018 10:00:00 AM 16.40 12.2 61 0.0 0.00 260.3 0 231 2.5 4.7 996.3 484 356 11.9 09/27/2018 10:00 AM 63rdStreetWeatherStation201809271000 63rd Street Weather Station 09/27/2018 11:00:00 AM 17.10 11.5 51 0.0 0.00 260.3 0 244 3.6 5.7 995.4 468 356 11.9 09/27/2018 11:00 AM 63rdStreetWeatherStation201809271100 63rd Street Weather Station 09/27/2018 01:00:00 PM 18.20 12.4 51 0.0 0.00 260.3 0 248 3.1 5.3 994.8 377 355 11.9 09/27/2018 1:00 PM 63rdStreetWeatherStation201809271300 Foster Weather Station 09/27/2018 01:00:00 PM 17.89 39 0.00 249 1.4 2.3 993.6 0 15.1 09/27/2018 1:00 PM FosterWeatherStation201809271300 63rd Street Weather Station 09/27/2018 03:00:00 PM 19.50 13.0 47 0.0 0.00 260.3 0 249 3.1 5.7 992.9 461 355 11.9 09/27/2018 3:00 PM 63rdStreetWeatherStation201809271500 Foster Weather Station 09/27/2018 03:00:00 PM 19.39 37 0.00 209 4.0 4.6 991.9 0 15.0 09/27/2018 3:00 PM FosterWeatherStation201809271500 63rd Street Weather Station 09/27/2018 04:00:00 PM 20.20 12.2 38 0.0 0.00 260.3 0 212 4.1 9.2 992.3 412 355 11.9 09/27/2018 4:00 PM 63rdStreetWeatherStation201809271600 Foster Weather Station 09/27/2018 04:00:00 PM 19.78 33 0.00 178 2.4 4.4 991.5 0 15.1 09/27/2018 4:00 PM FosterWeatherStation201809271600 63rd Street Weather Station 09/27/2018 05:00:00 PM 20.40 12.4 38 0.0 0.00 260.3 0 212 2.7 6.0 991.7 37 355 11.9 09/27/2018 5:00 PM 63rdStreetWeatherStation201809271700 Foster Weather Station 09/27/2018 05:00:00 PM 20.00 33 0.00 200 2.5 3.1 990.9 0 15.1 09/27/2018 5:00 PM FosterWeatherStation201809271700 63rd Street Weather Station 09/27/2018 06:00:00 PM 20.10 11.9 36 0.0 0.00 260.3 0 250 4.0 5.2 991.7 51 355 11.9 09/27/2018 6:00 PM 63rdStreetWeatherStation201809271800 Foster Weather Station 09/27/2018 06:00:00 PM 19.56 34 0.00 211 2.2 2.4 990.9 0 15.1 09/27/2018 6:00 PM FosterWeatherStation201809271800 63rd Street Weather Station 09/27/2018 08:00:00 PM 18.70 11.9 44 0.0 0.00 260.3 0 203 2.7 6.3 991.6 1 355 11.8 09/27/2018 8:00 PM 63rdStreetWeatherStation201809272000 63rd Street Weather Station 09/27/2018 11:00:00 PM 16.70 11.0 50 0.0 0.00 260.3 0 219 2.3 4.6 993.0 2 355 11.9 09/27/2018 11:00 PM 63rdStreetWeatherStation201809272300 Foster Weather Station 09/27/2018 11:00:00 PM 17.50 38 0.00 211 1.7 2.2 991.9 0 15.1 09/27/2018 11:00 PM FosterWeatherStation201809272300 63rd Street Weather Station 09/28/2018 12:00:00 AM 16.10 10.9 53 0.0 0.00 260.3 0 233 2.7 4.4 993.0 2 355 11.9 09/28/2018 12:00 AM 63rdStreetWeatherStation201809282400 Foster Weather Station 09/28/2018 12:00:00 AM 17.06 40 0.00 224 2.5 2.7 991.9 0 15.1 09/28/2018 12:00 AM FosterWeatherStation201809282400 63rd Street Weather Station 09/28/2018 01:00:00 AM 15.60 11.0 57 0.0 0.00 260.3 0 234 3.0 4.8 992.9 2 355 11.9 09/28/2018 1:00 AM 63rdStreetWeatherStation201809280100 Foster Weather Station 09/28/2018 01:00:00 AM 16.78 42 0.00 219 1.2 1.5 991.9 0 15.1 09/28/2018 1:00 AM FosterWeatherStation201809280100 63rd Street Weather Station 09/28/2018 03:00:00 AM 15.20 11.2 62 0.0 0.00 260.3 0 247 2.7 4.0 993.4 2 355 11.8 09/28/2018 3:00 AM 63rdStreetWeatherStation201809280300 Foster Weather Station 09/28/2018 03:00:00 AM 15.67 48 0.00 223 1.9 2.3 992.2 0 15.1 09/28/2018 3:00 AM FosterWeatherStation201809280300 63rd Street Weather Station 09/28/2018 04:00:00 AM 14.60 11.1 66 0.0 0.00 260.3 0 243 2.6 3.6 993.4 2 355 11.9 09/28/2018 4:00 AM 63rdStreetWeatherStation201809280400 Foster Weather Station 09/28/2018 04:00:00 AM 15.06 51 0.00 187 1.1 1.4 992.2 0 15.1 09/28/2018 4:00 AM FosterWeatherStation201809280400 63rd Street Weather Station 09/28/2018 05:00:00 AM 14.10 11.2 70 0.0 0.00 260.3 0 255 2.9 4.9 994.0 2 355 11.9 09/28/2018 5:00 AM 63rdStreetWeatherStation201809280500 Foster Weather Station 09/28/2018 05:00:00 AM 14.50 55 0.00 210 1.8 2.2 993.2 0 15.1 09/28/2018 5:00 AM FosterWeatherStation201809280500 63rd Street Weather Station 09/28/2018 06:00:00 AM 13.80 11.0 72 0.0 0.00 260.3 0 251 2.9 5.2 994.4 2 355 11.9 09/28/2018 6:00 AM 63rdStreetWeatherStation201809280600 Foster Weather Station 09/28/2018 06:00:00 AM 14.17 57 0.00 216 1.6 1.8 993.6 0 15.1 09/28/2018 6:00 AM FosterWeatherStation201809280600 63rd Street Weather Station 09/28/2018 07:00:00 AM 13.50 11.0 74 0.0 0.00 260.3 0 256 3.2 4.4 995.0 11 355 11.9 09/28/2018 7:00 AM 63rdStreetWeatherStation201809280700 Foster Weather Station 09/28/2018 07:00:00 AM 13.89 60 0.00 240 1.7 2.3 994.2 0 15.1 09/28/2018 7:00 AM FosterWeatherStation201809280700 63rd Street Weather Station 09/28/2018 08:00:00 AM 14.40 11.4 70 0.0 0.00 260.3 0 273 3.5 4.9 995.6 117 355 11.9 09/28/2018 8:00 AM 63rdStreetWeatherStation201809280800 Foster Weather Station 09/28/2018 08:00:00 AM 14.17 61 0.00 225 1.4 1.7 994.6 0 15.1 09/28/2018 8:00 AM FosterWeatherStation201809280800 63rd Street Weather Station 09/28/2018 09:00:00 AM 15.00 12.0 71 0.0 0.00 260.3 0 271 1.5 3.0 996.3 110 356 11.9 09/28/2018 9:00 AM 63rdStreetWeatherStation201809280900 Foster Weather Station 09/28/2018 09:00:00 AM 14.78 62 0.00 284 1.0 1.2 995.6 0 15.1 09/28/2018 9:00 AM FosterWeatherStation201809280900 63rd Street Weather Station 09/28/2018 10:00:00 AM 15.80 12.4 68 0.0 0.00 260.3 0 302 0.9 2.4 996.6 192 356 11.9 09/28/2018 10:00 AM 63rdStreetWeatherStation201809281000 Foster Weather Station 09/28/2018 10:00:00 AM 15.39 60 0.00 287 1.5 1.6 995.9 0 15.1 09/28/2018 10:00 AM FosterWeatherStation201809281000 63rd Street Weather Station 09/27/2018 09:00:00 PM 18.10 11.5 45 0.0 0.00 260.3 0 240 2.4 3.4 992.2 1 355 11.9 09/27/2018 9:00 PM 63rdStreetWeatherStation201809272100 63rd Street Weather Station 09/28/2018 11:00:00 AM 17.00 13.0 64 0.0 0.00 260.3 0 345 3.6 4.4 996.8 200 356 11.9 09/28/2018 11:00 AM 63rdStreetWeatherStation201809281100 Foster Weather Station 09/28/2018 11:00:00 AM 15.17 60 0.00 325 3.4 4.0 996.3 0 15.1 09/28/2018 11:00 AM FosterWeatherStation201809281100 Foster Weather Station 09/12/2015 03:00:00 PM 15.28 58 0.00 350 4.5 5.1 993.9 602 15.1 09/12/2015 3:00 PM FosterWeatherStation201509121500 Foster Weather Station 09/12/2015 04:00:00 PM 15.67 54 0.00 9 7.0 8.5 993.9 469 15.1 09/12/2015 4:00 PM FosterWeatherStation201509121600 Foster Weather Station 09/12/2015 05:00:00 PM 15.89 62 0.00 359 2.8 3.3 993.6 307 15.1 09/12/2015 5:00 PM FosterWeatherStation201509121700 Foster Weather Station 09/12/2015 06:00:00 PM 15.67 64 0.00 1 3.3 3.8 993.6 138 15.1 09/12/2015 6:00 PM FosterWeatherStation201509121800 Foster Weather Station 09/12/2015 07:00:00 PM 15.39 62 0.00 349 2.5 3.1 993.6 6 15.1 09/12/2015 7:00 PM FosterWeatherStation201509121900 Foster Weather Station 09/12/2015 08:00:00 PM 15.28 62 0.00 5 2.1 2.5 993.6 0 15.1 09/12/2015 8:00 PM FosterWeatherStation201509122000 Foster Weather Station 09/12/2015 09:00:00 PM 15.17 63 0.00 346 2.0 2.8 993.9 0 15.1 09/12/2015 9:00 PM FosterWeatherStation201509122100 Foster Weather Station 09/12/2015 10:00:00 PM 14.67 59 0.00 312 2.8 3.0 993.9 1 15.1 09/12/2015 10:00 PM FosterWeatherStation201509122200 Foster Weather Station 09/12/2015 11:00:00 PM 13.67 64 0.00 301 1.7 2.0 993.9 0 15.1 09/12/2015 11:00 PM FosterWeatherStation201509122300 Foster Weather Station 09/12/2015 12:00:00 AM 14.00 68 0.00 314 5.0 6.1 993.9 1 15.1 09/12/2015 12:00 AM FosterWeatherStation201509122400 Foster Weather Station 09/13/2015 02:00:00 AM 11.78 71 0.00 266 1.7 2.0 993.6 0 15.1 09/13/2015 2:00 AM FosterWeatherStation201509130200 Foster Weather Station 09/13/2015 03:00:00 AM 11.39 72 0.00 266 3.0 3.2 993.6 0 15.2 09/13/2015 3:00 AM FosterWeatherStation201509130300 Foster Weather Station 09/13/2015 04:00:00 AM 11.28 72 0.00 262 1.3 2.1 993.6 0 15.1 09/13/2015 4:00 AM FosterWeatherStation201509130400 Foster Weather Station 09/13/2015 05:00:00 AM 11.28 72 0.00 247 1.3 1.5 993.9 0 15.2 09/13/2015 5:00 AM FosterWeatherStation201509130500 Foster Weather Station 09/13/2015 06:00:00 AM 11.50 70 0.00 206 2.5 3.4 993.9 0 15.1 09/13/2015 6:00 AM FosterWeatherStation201509130600 Foster Weather Station 09/13/2015 07:00:00 AM 12.06 67 0.00 272 3.8 4.2 994.2 25 15.2 09/13/2015 7:00 AM FosterWeatherStation201509130700 Foster Weather Station 09/13/2015 08:00:00 AM 13.00 64 0.00 268 1.7 2.0 994.6 253 15.1 09/13/2015 8:00 AM FosterWeatherStation201509130800 Foster Weather Station 09/13/2015 09:00:00 AM 15.17 55 0.00 273 2.3 2.5 994.6 378 15.1 09/13/2015 9:00 AM FosterWeatherStation201509130900 Foster Weather Station 09/13/2015 10:00:00 AM 17.00 48 0.00 291 4.2 4.4 994.6 527 15.1 09/13/2015 10:00 AM FosterWeatherStation201509131000 Foster Weather Station 09/13/2015 11:00:00 AM 18.06 43 0.00 273 4.2 5.3 994.6 335 15.1 09/13/2015 11:00 AM FosterWeatherStation201509131100 Foster Weather Station 09/13/2015 12:00:00 PM 19.00 38 0.00 279 2.9 3.4 994.6 808 15.1 09/13/2015 12:00 PM FosterWeatherStation201509131200 Foster Weather Station 09/13/2015 01:00:00 PM 19.06 36 0.00 321 3.1 3.5 993.9 171 15.1 09/13/2015 1:00 PM FosterWeatherStation201509131300 Foster Weather Station 09/13/2015 02:00:00 PM 20.00 34 0.00 318 1.5 2.0 993.6 816 15.1 09/13/2015 2:00 PM FosterWeatherStation201509131400 Foster Weather Station 09/13/2015 03:00:00 PM 19.39 52 0.00 146 0.4 0.7 993.2 691 15.1 09/13/2015 3:00 PM FosterWeatherStation201509131500 Foster Weather Station 09/13/2015 04:00:00 PM 17.89 57 0.00 135 1.6 2.2 992.9 118 15.1 09/13/2015 4:00 PM FosterWeatherStation201509131600 Foster Weather Station 09/13/2015 05:00:00 PM 18.28 52 0.00 132 3.2 3.7 992.6 296 15.1 09/13/2015 5:00 PM FosterWeatherStation201509131700 Foster Weather Station 09/13/2015 06:00:00 PM 18.28 57 0.00 131 2.3 2.5 992.2 131 15.1 09/13/2015 6:00 PM FosterWeatherStation201509131800 Foster Weather Station 09/13/2015 07:00:00 PM 18.28 54 0.00 152 1.8 2.0 992.2 5 15.1 09/13/2015 7:00 PM FosterWeatherStation201509131900 Foster Weather Station 09/13/2015 08:00:00 PM 18.78 43 0.00 197 1.5 1.7 992.2 0 15.1 09/13/2015 8:00 PM FosterWeatherStation201509132000 Foster Weather Station 09/13/2015 09:00:00 PM 18.39 45 0.00 190 1.7 2.4 992.6 1 15.1 09/13/2015 9:00 PM FosterWeatherStation201509132100 Foster Weather Station 09/13/2015 10:00:00 PM 18.06 46 0.00 190 1.8 2.3 992.9 0 15.1 09/13/2015 10:00 PM FosterWeatherStation201509132200 Foster Weather Station 09/13/2015 11:00:00 PM 17.39 49 0.00 220 1.3 1.4 992.9 0 15.1 09/13/2015 11:00 PM FosterWeatherStation201509132300 Foster Weather Station 09/13/2015 12:00:00 AM 12.67 67 0.00 277 2.7 3.1 993.9 0 15.2 09/13/2015 12:00 AM FosterWeatherStation201509132400 Foster Weather Station 09/14/2015 01:00:00 AM 16.00 54 0.00 206 2.8 3.0 993.2 0 15.1 09/14/2015 1:00 AM FosterWeatherStation201509140100 Foster Weather Station 09/14/2015 02:00:00 AM 15.56 54 0.00 210 3.2 3.4 993.6 1 15.1 09/14/2015 2:00 AM FosterWeatherStation201509140200 63rd Street Weather Station 09/28/2018 12:00:00 PM 16.90 12.5 61 0.0 0.00 260.3 0 332 2.6 4.1 997.7 255 355 11.9 09/28/2018 12:00 PM 63rdStreetWeatherStation201809281200 Foster Weather Station 09/28/2018 12:00:00 PM 15.39 60 0.00 308 1.7 2.2 996.6 0 15.1 09/28/2018 12:00 PM FosterWeatherStation201809281200 63rd Street Weather Station 09/28/2018 01:00:00 PM 16.50 12.3 62 0.0 0.00 260.3 0 305 1.4 3.2 997.5 156 355 11.9 09/28/2018 1:00 PM 63rdStreetWeatherStation201809281300 Foster Weather Station 09/28/2018 01:00:00 PM 15.39 57 0.00 301 2.8 3.2 997.0 0 15.1 09/28/2018 1:00 PM FosterWeatherStation201809281300 63rd Street Weather Station 09/28/2018 02:00:00 PM 16.20 12.3 64 0.0 0.00 260.3 0 284 1.1 3.8 997.9 75 355 11.8 09/28/2018 2:00 PM 63rdStreetWeatherStation201809281400 Foster Weather Station 09/28/2018 02:00:00 PM 14.78 64 0.00 298 3.5 4.3 997.6 0 15.1 09/28/2018 2:00 PM FosterWeatherStation201809281400 63rd Street Weather Station 09/28/2018 03:00:00 PM 15.50 11.3 61 0.0 0.00 260.3 0 320 2.6 6.5 998.9 31 356 11.9 09/28/2018 3:00 PM 63rdStreetWeatherStation201809281500 Foster Weather Station 09/28/2018 03:00:00 PM 13.17 66 0.10 260 2.2 2.5 998.6 0 15.1 09/28/2018 3:00 PM FosterWeatherStation201809281500 63rd Street Weather Station 09/28/2018 04:00:00 PM 12.80 9.5 66 0.0 0.40 260.7 60 326 2.2 5.1 1000.2 26 355 11.9 09/28/2018 4:00 PM 63rdStreetWeatherStation201809281600 Foster Weather Station 09/28/2018 04:00:00 PM 11.28 71 1.68 308 4.7 5.3 1000.0 0 15.1 09/28/2018 4:00 PM FosterWeatherStation201809281600 63rd Street Weather Station 09/28/2018 05:00:00 PM 11.30 9.4 79 0.6 1.90 262.6 60 315 2.4 5.3 1000.8 28 355 11.9 09/28/2018 5:00 PM 63rdStreetWeatherStation201809281700 Foster Weather Station 09/28/2018 05:00:00 PM 10.28 73 0.61 265 2.6 4.1 999.7 0 15.1 09/28/2018 5:00 PM FosterWeatherStation201809281700 63rd Street Weather Station 09/28/2018 07:00:00 PM 10.80 9.2 81 0.0 0.00 263.2 0 290 1.8 3.5 1001.0 3 355 11.8 09/28/2018 7:00 PM 63rdStreetWeatherStation201809281900 Foster Weather Station 09/28/2018 07:00:00 PM 10.17 76 0.05 242 1.1 1.3 1000.0 0 15.1 09/28/2018 7:00 PM FosterWeatherStation201809281900 63rd Street Weather Station 09/28/2018 08:00:00 PM 10.90 9.3 82 0.0 0.00 263.2 0 272 2.0 3.8 1001.7 3 355 11.9 09/28/2018 8:00 PM 63rdStreetWeatherStation201809282000 Foster Weather Station 09/28/2018 08:00:00 PM 10.17 71 0.00 270 1.8 2.0 1000.7 0 15.1 09/28/2018 8:00 PM FosterWeatherStation201809282000 63rd Street Weather Station 09/29/2018 01:00:00 AM 9.60 7.7 77 0.0 0.00 263.2 0 322 0.8 2.2 1003.5 3 355 11.9 09/29/2018 1:00 AM 63rdStreetWeatherStation201809290100 Foster Weather Station 09/29/2018 01:00:00 AM 8.56 71 0.00 257 1.3 1.6 1002.4 0 15.1 09/29/2018 1:00 AM FosterWeatherStation201809290100 63rd Street Weather Station 07/31/2019 09:00:00 AM 20.60 16.6 67 0.0 0.00 406.7 0 40 3.5 6.6 999.9 443 357 11.9 07/31/2019 9:00 AM 63rdStreetWeatherStation201907310900 Foster Weather Station 07/31/2019 09:00:00 AM 20.06 58 0.00 54 3.0 3.8 999.7 0 15.1 07/31/2019 9:00 AM FosterWeatherStation201907310900 Oak Street Weather Station 07/31/2019 09:00:00 AM 20.80 15.7 59 0.0 0.00 153.5 0 91 4.6 6.2 1001.0 485 320 12.1 07/31/2019 9:00 AM OakStreetWeatherStation201907310900 63rd Street Weather Station 07/31/2019 10:00:00 AM 20.40 17.1 72 0.0 0.00 406.7 0 41 3.8 8.2 1000.3 590 357 11.9 07/31/2019 10:00 AM 63rdStreetWeatherStation201907311000 Foster Weather Station 07/31/2019 10:00:00 AM 20.17 53 0.00 22 3.3 3.6 1000.0 0 15.1 07/31/2019 10:00 AM FosterWeatherStation201907311000 Oak Street Weather Station 07/31/2019 10:00:00 AM 20.70 16.2 64 0.0 0.00 153.5 0 94 4.0 6.0 1001.4 633 320 12.1 07/31/2019 10:00 AM OakStreetWeatherStation201907311000 63rd Street Weather Station 07/31/2019 11:00:00 AM 20.40 17.0 72 0.0 0.00 406.7 0 52 2.0 5.1 1000.8 705 356 11.9 07/31/2019 11:00 AM 63rdStreetWeatherStation201907311100 Foster Weather Station 07/31/2019 11:00:00 AM 20.06 54 0.00 52 1.3 1.8 1000.3 0 15.1 07/31/2019 11:00 AM FosterWeatherStation201907311100 Oak Street Weather Station 07/31/2019 11:00:00 AM 20.90 16.1 61 0.0 0.00 153.5 0 85 3.7 4.6 1001.7 752 320 12.0 07/31/2019 11:00 AM OakStreetWeatherStation201907311100 63rd Street Weather Station 07/31/2019 12:00:00 PM 20.50 15.9 62 0.0 0.00 406.7 0 49 2.8 6.4 1000.7 785 356 11.9 07/31/2019 12:00 PM 63rdStreetWeatherStation201907311200 Foster Weather Station 07/31/2019 12:00:00 PM 20.39 51 0.00 34 2.1 2.6 1000.0 0 15.1 07/31/2019 12:00 PM FosterWeatherStation201907311200 Oak Street Weather Station 07/31/2019 12:00:00 PM 21.10 15.5 56 0.0 0.00 153.5 0 82 4.0 4.8 1001.6 821 320 12.0 07/31/2019 12:00 PM OakStreetWeatherStation201907311200 63rd Street Weather Station 07/31/2019 01:00:00 PM 20.40 15.9 63 0.0 0.00 406.7 0 39 4.1 6.8 1000.4 809 356 11.9 07/31/2019 1:00 PM 63rdStreetWeatherStation201907311300 Foster Weather Station 07/31/2019 01:00:00 PM 20.39 57 0.00 52 2.3 2.9 1000.0 0 15.1 07/31/2019 1:00 PM FosterWeatherStation201907311300 Oak Street Weather Station 07/31/2019 01:00:00 PM 21.30 15.7 56 0.0 0.00 153.5 0 82 3.7 5.0 1001.4 848 320 12.1 07/31/2019 1:00 PM OakStreetWeatherStation201907311300 63rd Street Weather Station 07/31/2019 02:00:00 PM 20.70 16.9 69 0.0 0.00 406.7 0 31 4.8 6.6 1000.4 787 355 11.9 07/31/2019 2:00 PM 63rdStreetWeatherStation201907311400 Foster Weather Station 07/31/2019 02:00:00 PM 20.56 62 0.00 13 2.4 3.4 1000.0 0 15.0 07/31/2019 2:00 PM FosterWeatherStation201907311400 63rd Street Weather Station 09/28/2018 09:00:00 PM 10.30 8.4 78 0.0 0.00 263.2 0 281 2.2 4.7 1002.1 3 355 11.8 09/28/2018 9:00 PM 63rdStreetWeatherStation201809282100 Foster Weather Station 09/28/2018 09:00:00 PM 10.00 73 0.00 263 1.7 1.9 1001.4 0 15.1 09/28/2018 9:00 PM FosterWeatherStation201809282100 63rd Street Weather Station 09/29/2018 02:00:00 AM 9.50 7.0 70 0.0 0.00 263.2 0 294 1.2 2.5 1003.8 3 355 11.8 09/29/2018 2:00 AM 63rdStreetWeatherStation201809290200 Foster Weather Station 09/14/2015 03:00:00 AM 15.06 55 0.00 208 3.8 4.5 993.6 0 15.1 09/14/2015 3:00 AM FosterWeatherStation201509140300 Foster Weather Station 09/14/2015 04:00:00 AM 14.78 57 0.00 199 2.1 2.6 993.6 0 15.2 09/14/2015 4:00 AM FosterWeatherStation201509140400 Foster Weather Station 09/14/2015 05:00:00 AM 14.50 57 0.00 200 4.9 5.3 993.6 0 15.1 09/14/2015 5:00 AM FosterWeatherStation201509140500 Foster Weather Station 09/14/2015 06:00:00 AM 14.67 57 0.00 212 3.3 3.7 993.9 1 15.1 09/14/2015 6:00 AM FosterWeatherStation201509140600 Foster Weather Station 09/14/2015 07:00:00 AM 14.50 59 0.00 222 5.2 6.6 994.6 58 15.1 09/14/2015 7:00 AM FosterWeatherStation201509140700 Foster Weather Station 09/14/2015 08:00:00 AM 15.06 60 0.00 206 6.0 6.8 994.9 78 15.1 09/14/2015 8:00 AM FosterWeatherStation201509140800 Foster Weather Station 09/14/2015 09:00:00 AM 17.06 55 0.00 213 4.5 5.1 995.3 112 15.1 09/14/2015 9:00 AM FosterWeatherStation201509140900 Foster Weather Station 09/14/2015 10:00:00 AM 19.39 49 0.00 203 1.7 2.9 995.6 497 15.1 09/14/2015 10:00 AM FosterWeatherStation201509141000 Foster Weather Station 09/14/2015 11:00:00 AM 21.50 47 0.00 208 6.5 7.2 995.3 604 15.1 09/14/2015 11:00 AM FosterWeatherStation201509141100 Foster Weather Station 09/14/2015 12:00:00 PM 23.67 41 0.00 195 5.2 5.7 994.9 669 15.1 09/14/2015 12:00 PM FosterWeatherStation201509141200 Foster Weather Station 09/14/2015 01:00:00 PM 25.17 38 0.00 160 2.8 3.3 994.6 686 15.1 09/14/2015 1:00 PM FosterWeatherStation201509141300 Foster Weather Station 09/14/2015 02:00:00 PM 26.39 36 0.00 206 6.1 7.1 994.2 648 15.1 09/14/2015 2:00 PM FosterWeatherStation201509141400 Foster Weather Station 09/14/2015 03:00:00 PM 27.00 36 0.00 203 3.0 4.0 993.9 560 15.1 09/14/2015 3:00 PM FosterWeatherStation201509141500 Foster Weather Station 09/14/2015 04:00:00 PM 27.28 36 0.00 178 2.2 2.6 993.9 427 15.1 09/14/2015 4:00 PM FosterWeatherStation201509141600 Foster Weather Station 09/14/2015 05:00:00 PM 27.28 36 0.00 185 1.1 1.5 993.9 270 15.1 09/14/2015 5:00 PM FosterWeatherStation201509141700 Foster Weather Station 09/14/2015 06:00:00 PM 27.06 36 0.00 196 4.9 5.7 993.6 115 15.1 09/14/2015 6:00 PM FosterWeatherStation201509141800 Foster Weather Station 09/14/2015 07:00:00 PM 26.06 38 0.00 165 2.2 2.5 994.2 5 15.1 09/14/2015 7:00 PM FosterWeatherStation201509141900 Foster Weather Station 09/14/2015 08:00:00 PM 25.00 42 0.00 218 3.0 3.6 994.6 0 15.1 09/14/2015 8:00 PM FosterWeatherStation201509142000 Foster Weather Station 09/14/2015 09:00:00 PM 24.06 43 0.00 191 2.9 4.9 994.9 0 15.1 09/14/2015 9:00 PM FosterWeatherStation201509142100 Foster Weather Station 09/14/2015 10:00:00 PM 23.28 44 0.00 221 6.3 6.8 995.3 1 15.1 09/14/2015 10:00 PM FosterWeatherStation201509142200 Foster Weather Station 09/14/2015 11:00:00 PM 22.56 47 0.00 212 4.4 5.6 996.3 0 15.1 09/14/2015 11:00 PM FosterWeatherStation201509142300 Foster Weather Station 09/14/2015 12:00:00 AM 16.89 50 0.00 222 2.3 2.8 993.2 0 15.1 09/14/2015 12:00 AM FosterWeatherStation201509142400 Foster Weather Station 09/15/2015 01:00:00 AM 21.28 53 0.00 204 6.6 7.2 996.6 1 15.1 09/15/2015 1:00 AM FosterWeatherStation201509150100 Foster Weather Station 09/15/2015 02:00:00 AM 20.78 56 0.00 201 7.4 8.2 997.0 0 15.1 09/15/2015 2:00 AM FosterWeatherStation201509150200 Foster Weather Station 09/15/2015 03:00:00 AM 20.28 58 0.00 194 3.9 5.1 997.3 0 15.1 09/15/2015 3:00 AM FosterWeatherStation201509150300 Foster Weather Station 09/15/2015 04:00:00 AM 19.89 59 0.00 203 4.3 4.6 998.0 0 15.1 09/15/2015 4:00 AM FosterWeatherStation201509150400 Foster Weather Station 09/15/2015 05:00:00 AM 19.39 60 0.00 202 2.8 3.3 998.6 1 15.1 09/15/2015 5:00 AM FosterWeatherStation201509150500 Foster Weather Station 09/15/2015 06:00:00 AM 18.78 62 0.00 238 3.4 3.8 999.0 0 15.1 09/15/2015 6:00 AM FosterWeatherStation201509150600 Foster Weather Station 09/15/2015 07:00:00 AM 18.78 60 0.00 205 2.7 3.0 999.7 52 15.1 09/15/2015 7:00 AM FosterWeatherStation201509150700 Foster Weather Station 09/15/2015 08:00:00 AM 19.50 57 0.00 206 2.9 3.0 1000.0 140 15.1 09/15/2015 8:00 AM FosterWeatherStation201509150800 Foster Weather Station 09/15/2015 09:00:00 AM 20.67 53 0.00 204 3.5 3.6 1000.3 364 15.1 09/15/2015 9:00 AM FosterWeatherStation201509150900 Foster Weather Station 09/15/2015 10:00:00 AM 22.17 49 0.00 194 3.6 4.1 1000.7 455 15.1 09/15/2015 10:00 AM FosterWeatherStation201509151000 Foster Weather Station 09/15/2015 11:00:00 AM 23.28 46 0.00 198 1.2 1.9 1000.7 592 15.1 09/15/2015 11:00 AM FosterWeatherStation201509151100 Foster Weather Station 09/15/2015 12:00:00 PM 25.00 42 0.00 210 3.2 3.6 1000.3 674 15.1 09/15/2015 12:00 PM FosterWeatherStation201509151200 Foster Weather Station 09/15/2015 01:00:00 PM 25.89 39 0.00 201 3.3 3.5 1000.0 365 15.1 09/15/2015 1:00 PM FosterWeatherStation201509151300 63rd Street Weather Station 09/28/2018 10:00:00 PM 10.10 8.5 82 0.0 0.00 263.2 0 281 1.3 2.1 1002.5 3 355 11.9 09/28/2018 10:00 PM 63rdStreetWeatherStation201809282200 Foster Weather Station 09/28/2018 10:00:00 PM 9.50 77 0.00 265 1.7 2.0 1001.7 0 15.1 09/28/2018 10:00 PM FosterWeatherStation201809282200 Foster Weather Station 09/29/2018 02:00:00 AM 8.17 69 0.00 261 2.0 2.3 1002.7 0 15.1 09/29/2018 2:00 AM FosterWeatherStation201809290200 63rd Street Weather Station 09/29/2018 03:00:00 AM 9.00 6.7 73 0.0 0.00 263.2 0 285 1.6 3.4 1004.0 3 355 11.9 09/29/2018 3:00 AM 63rdStreetWeatherStation201809290300 Foster Weather Station 09/29/2018 03:00:00 AM 7.67 70 0.00 293 1.5 2.1 1003.4 0 15.2 09/29/2018 3:00 AM FosterWeatherStation201809290300 Oak Street Weather Station 07/31/2019 02:00:00 PM 21.00 16.5 63 0.0 0.00 153.5 0 79 3.3 4.7 1001.5 820 320 11.9 07/31/2019 2:00 PM OakStreetWeatherStation201907311400 63rd Street Weather Station 05/31/2020 06:00:00 AM 12.60 9.4 66 0.0 0.00 231.4 0 79 7.2 9.2 1005.3 56 351 11.9 05/31/2020 6:00 AM 63rdStreetWeatherStation202005310600 Oak Street Weather Station 05/31/2020 06:00:00 AM 12.30 8.9 65 0.0 0.00 13.4 0 78 3.9 5.1 1006.3 78 357 12.0 05/31/2020 6:00 AM OakStreetWeatherStation202005310600 63rd Street Weather Station 05/31/2020 09:00:00 AM 12.20 8.5 61 0.0 0.00 231.4 0 81 5.3 6.5 1006.8 541 352 11.9 05/31/2020 9:00 AM 63rdStreetWeatherStation202005310900 Oak Street Weather Station 05/31/2020 09:00:00 AM 12.30 8.1 57 0.0 0.00 13.4 0 98 2.0 3.0 1007.8 570 357 12.0 05/31/2020 9:00 AM OakStreetWeatherStation202005310900 63rd Street Weather Station 05/31/2020 11:00:00 AM 12.70 8.6 58 0.0 0.00 231.4 0 89 2.8 4.0 1006.9 783 351 11.9 05/31/2020 11:00 AM 63rdStreetWeatherStation202005311100 Oak Street Weather Station 05/31/2020 11:00:00 AM 12.20 7.7 53 0.0 0.00 13.4 0 106 1.4 2.1 1007.8 816 357 12.1 05/31/2020 11:00 AM OakStreetWeatherStation202005311100 63rd Street Weather Station 05/31/2020 12:00:00 PM 12.50 8.8 61 0.0 0.00 231.4 0 67 2.2 5.2 1006.7 826 351 11.8 05/31/2020 12:00 PM 63rdStreetWeatherStation202005311200 Oak Street Weather Station 05/31/2020 12:00:00 PM 12.40 8.0 55 0.0 0.00 13.4 0 102 1.2 1.8 1007.5 874 357 12.0 05/31/2020 12:00 PM OakStreetWeatherStation202005311200 63rd Street Weather Station 05/31/2020 02:00:00 PM 12.60 8.7 60 0.0 0.00 231.4 0 62 1.8 3.6 1006.1 808 350 11.8 05/31/2020 2:00 PM 63rdStreetWeatherStation202005311400 Oak Street Weather Station 05/31/2020 02:00:00 PM 12.40 7.9 53 0.0 0.00 13.4 0 80 2.0 3.4 1006.6 863 357 12.0 05/31/2020 2:00 PM OakStreetWeatherStation202005311400 63rd Street Weather Station 05/31/2020 04:00:00 PM 13.70 9.7 60 0.0 0.00 231.4 0 87 3.2 5.1 1004.7 621 350 11.8 05/31/2020 4:00 PM 63rdStreetWeatherStation202005311600 Oak Street Weather Station 05/31/2020 04:00:00 PM 13.00 8.7 57 0.0 0.00 13.4 0 108 1.6 2.5 1005.5 662 357 11.9 05/31/2020 4:00 PM OakStreetWeatherStation202005311600 63rd Street Weather Station 05/31/2020 07:00:00 PM 14.60 10.6 61 0.0 0.00 231.4 0 122 2.0 3.3 1003.4 155 349 11.9 05/31/2020 7:00 PM 63rdStreetWeatherStation202005311900 Oak Street Weather Station 05/31/2020 07:00:00 PM 13.90 9.8 59 0.0 0.00 13.4 0 118 1.8 3.6 1004.1 23 357 12.0 05/31/2020 7:00 PM OakStreetWeatherStation202005311900 63rd Street Weather Station 05/31/2020 08:00:00 PM 14.60 10.7 62 0.0 0.00 231.4 0 135 1.3 2.6 1003.5 11 351 11.8 05/31/2020 8:00 PM 63rdStreetWeatherStation202005312000 Oak Street Weather Station 05/31/2020 08:00:00 PM 14.30 10.0 58 0.0 0.00 13.4 0 111 1.4 2.6 1004.1 8 357 12.1 05/31/2020 8:00 PM OakStreetWeatherStation202005312000 63rd Street Weather Station 05/31/2020 09:00:00 PM 15.10 11.3 64 0.0 0.00 231.4 0 150 0.7 1.6 1003.2 2 350 11.8 05/31/2020 9:00 PM 63rdStreetWeatherStation202005312100 Oak Street Weather Station 05/31/2020 09:00:00 PM 14.90 10.4 57 0.0 0.00 13.4 0 98 0.9 2.6 1003.8 0 357 11.9 05/31/2020 9:00 PM OakStreetWeatherStation202005312100 63rd Street Weather Station 05/31/2020 11:00:00 PM 15.80 11.4 59 0.0 0.00 231.4 0 164 2.0 4.1 1002.8 2 350 11.8 05/31/2020 11:00 PM 63rdStreetWeatherStation202005312300 Oak Street Weather Station 05/31/2020 11:00:00 PM 16.10 10.4 48 0.0 0.00 13.4 0 114 1.3 2.5 1003.5 0 357 11.9 05/31/2020 11:00 PM OakStreetWeatherStation202005312300 63rd Street Weather Station 06/01/2020 12:00:00 AM 15.40 10.3 52 0.0 0.00 231.4 0 188 1.6 2.7 1003.1 2 349 11.9 06/01/2020 12:00 AM 63rdStreetWeatherStation202006012400 Oak Street Weather Station 06/01/2020 12:00:00 AM 16.20 11.0 53 0.0 0.00 13.4 0 115 0.9 1.1 1003.6 0 357 12.0 06/01/2020 12:00 AM OakStreetWeatherStation202006012400 63rd Street Weather Station 06/01/2020 02:00:00 AM 14.30 9.3 52 0.0 0.00 231.4 0 190 2.3 3.9 1003.4 2 351 11.9 06/01/2020 2:00 AM 63rdStreetWeatherStation202006010200 Oak Street Weather Station 06/01/2020 02:00:00 AM 16.40 10.0 44 0.0 0.00 13.4 0 72 1.0 2.4 1003.8 0 357 12.0 06/01/2020 2:00 AM OakStreetWeatherStation202006010200 63rd Street Weather Station 06/01/2020 03:00:00 AM 14.30 9.2 51 0.0 0.00 231.4 0 190 1.9 2.5 1003.2 2 351 11.8 06/01/2020 3:00 AM 63rdStreetWeatherStation202006010300 Oak Street Weather Station 06/01/2020 03:00:00 AM 16.40 9.6 40 0.0 0.00 13.4 0 102 0.5 1.8 1003.8 0 357 11.9 06/01/2020 3:00 AM OakStreetWeatherStation202006010300 63rd Street Weather Station 06/01/2020 04:00:00 AM 13.50 8.7 53 0.0 0.00 231.4 0 209 1.4 2.4 1003.0 2 350 11.8 06/01/2020 4:00 AM 63rdStreetWeatherStation202006010400 Oak Street Weather Station 06/01/2020 04:00:00 AM 16.80 9.3 36 0.0 0.00 13.4 0 318 1.1 3.6 1003.6 0 357 12.0 06/01/2020 4:00 AM OakStreetWeatherStation202006010400 63rd Street Weather Station 09/28/2018 11:00:00 PM 9.70 8.4 85 0.0 0.00 263.2 0 294 1.2 2.6 1003.0 3 355 11.9 09/28/2018 11:00 PM 63rdStreetWeatherStation201809282300 Foster Weather Station 09/28/2018 11:00:00 PM 9.17 75 0.00 279 3.0 3.3 1002.0 0 15.1 09/28/2018 11:00 PM FosterWeatherStation201809282300 63rd Street Weather Station 09/29/2018 04:00:00 AM 8.80 6.6 74 0.0 0.00 263.2 0 294 1.5 3.0 1004.2 3 355 11.8 09/29/2018 4:00 AM 63rdStreetWeatherStation201809290400 Foster Weather Station 09/29/2018 04:00:00 AM 7.39 70 0.00 268 2.4 2.6 1003.4 0 15.1 09/29/2018 4:00 AM FosterWeatherStation201809290400 63rd Street Weather Station 09/29/2018 05:00:00 AM 8.20 6.3 76 0.0 0.00 263.2 0 288 1.3 3.5 1004.7 3 355 11.9 09/29/2018 5:00 AM 63rdStreetWeatherStation201809290500 Foster Weather Station 09/29/2018 05:00:00 AM 7.17 71 0.00 279 3.3 4.6 1003.7 0 15.2 09/29/2018 5:00 AM FosterWeatherStation201809290500 Foster Weather Station 09/15/2015 02:00:00 PM 27.00 37 0.00 206 2.0 2.9 999.7 660 15.1 09/15/2015 2:00 PM FosterWeatherStation201509151400 Foster Weather Station 09/15/2015 03:00:00 PM 27.39 30 0.00 170 4.0 4.8 999.0 580 15.1 09/15/2015 3:00 PM FosterWeatherStation201509151500 Foster Weather Station 09/15/2015 04:00:00 PM 28.06 29 0.00 187 3.4 4.1 999.0 446 15.1 09/15/2015 4:00 PM FosterWeatherStation201509151600 Foster Weather Station 09/15/2015 05:00:00 PM 27.06 27 0.00 267 1.2 2.1 998.6 288 15.1 09/15/2015 5:00 PM FosterWeatherStation201509151700 Foster Weather Station 09/15/2015 06:00:00 PM 26.78 29 0.00 142 6.3 7.2 998.6 71 15.1 09/15/2015 6:00 PM FosterWeatherStation201509151800 Foster Weather Station 09/15/2015 07:00:00 PM 25.78 33 0.00 198 4.1 5.8 998.6 5 15.1 09/15/2015 7:00 PM FosterWeatherStation201509151900 Foster Weather Station 09/15/2015 08:00:00 PM 24.50 36 0.00 176 3.2 3.6 999.0 1 15.1 09/15/2015 8:00 PM FosterWeatherStation201509152000 Foster Weather Station 09/15/2015 09:00:00 PM 24.67 36 0.00 179 1.4 1.7 999.3 1 15.1 09/15/2015 9:00 PM FosterWeatherStation201509152100 Foster Weather Station 09/15/2015 10:00:00 PM 24.17 37 0.00 161 1.3 1.6 1000.0 2 15.1 09/15/2015 10:00 PM FosterWeatherStation201509152200 Foster Weather Station 09/15/2015 11:00:00 PM 23.00 40 0.00 162 1.9 2.1 1000.3 0 15.1 09/15/2015 11:00 PM FosterWeatherStation201509152300 Foster Weather Station 09/15/2015 12:00:00 AM 21.89 50 0.00 208 6.7 7.9 996.3 0 15.1 09/15/2015 12:00 AM FosterWeatherStation201509152400 Foster Weather Station 09/16/2015 01:00:00 AM 21.50 45 0.00 201 4.5 5.2 1000.3 0 15.1 09/16/2015 1:00 AM FosterWeatherStation201509160100 Foster Weather Station 09/16/2015 02:00:00 AM 20.89 46 0.00 210 2.1 3.3 1000.0 0 15.1 09/16/2015 2:00 AM FosterWeatherStation201509160200 Foster Weather Station 09/16/2015 03:00:00 AM 20.17 48 0.00 180 1.7 1.9 999.7 0 15.1 09/16/2015 3:00 AM FosterWeatherStation201509160300 Foster Weather Station 09/16/2015 04:00:00 AM 20.17 48 0.00 200 2.1 2.4 999.3 0 15.1 09/16/2015 4:00 AM FosterWeatherStation201509160400 Foster Weather Station 09/16/2015 05:00:00 AM 19.39 51 0.00 227 2.1 2.4 1000.0 0 15.1 09/16/2015 5:00 AM FosterWeatherStation201509160500 Foster Weather Station 09/16/2015 06:00:00 AM 18.06 57 0.00 153 1.2 1.5 1000.7 0 15.1 09/16/2015 6:00 AM FosterWeatherStation201509160600 Foster Weather Station 09/16/2015 07:00:00 AM 18.50 57 0.00 199 2.1 2.2 1000.7 39 15.1 09/16/2015 7:00 AM FosterWeatherStation201509160700 Foster Weather Station 09/16/2015 08:00:00 AM 19.56 55 0.00 153 2.2 2.7 1000.7 187 15.1 09/16/2015 8:00 AM FosterWeatherStation201509160800 Foster Weather Station 09/16/2015 09:00:00 AM 20.67 51 0.00 216 4.1 4.4 1000.7 346 15.1 09/16/2015 9:00 AM FosterWeatherStation201509160900 Foster Weather Station 09/16/2015 10:00:00 AM 22.67 46 0.00 205 5.2 5.9 1000.7 492 15.1 09/16/2015 10:00 AM FosterWeatherStation201509161000 Foster Weather Station 09/16/2015 11:00:00 AM 24.78 42 0.00 214 4.2 5.6 1000.7 604 15.1 09/16/2015 11:00 AM FosterWeatherStation201509161100 Foster Weather Station 09/16/2015 12:00:00 PM 25.50 40 0.00 207 8.4 9.1 1000.0 669 15.1 09/16/2015 12:00 PM FosterWeatherStation201509161200 Foster Weather Station 09/16/2015 01:00:00 PM 26.50 40 0.00 201 2.8 3.2 999.7 680 15.1 09/16/2015 1:00 PM FosterWeatherStation201509161300 Foster Weather Station 09/16/2015 02:00:00 PM 27.28 36 0.00 203 4.2 4.4 998.6 644 15.1 09/16/2015 2:00 PM FosterWeatherStation201509161400 Foster Weather Station 09/16/2015 03:00:00 PM 27.78 34 0.00 203 5.5 6.1 997.6 550 15.1 09/16/2015 3:00 PM FosterWeatherStation201509161500 Foster Weather Station 09/16/2015 04:00:00 PM 27.78 33 0.00 169 4.7 5.3 997.0 422 15.1 09/16/2015 4:00 PM FosterWeatherStation201509161600 Foster Weather Station 09/16/2015 05:00:00 PM 27.89 35 0.00 164 3.4 4.2 996.6 267 15.1 09/16/2015 5:00 PM FosterWeatherStation201509161700 Foster Weather Station 09/16/2015 06:00:00 PM 27.50 34 0.00 187 2.7 3.7 996.3 34 15.1 09/16/2015 6:00 PM FosterWeatherStation201509161800 Foster Weather Station 09/16/2015 07:00:00 PM 26.78 36 0.00 166 3.0 3.2 996.3 4 15.1 09/16/2015 7:00 PM FosterWeatherStation201509161900 Foster Weather Station 09/16/2015 08:00:00 PM 25.78 39 0.00 152 1.4 2.0 996.3 1 15.1 09/16/2015 8:00 PM FosterWeatherStation201509162000 Foster Weather Station 09/16/2015 09:00:00 PM 25.00 42 0.00 163 1.4 1.7 996.3 1 15.1 09/16/2015 9:00 PM FosterWeatherStation201509162100 63rd Street Weather Station 09/29/2018 06:00:00 AM 8.00 6.1 76 0.0 0.00 263.2 0 284 1.2 3.1 1005.2 3 355 11.9 09/29/2018 6:00 AM 63rdStreetWeatherStation201809290600 Foster Weather Station 09/29/2018 06:00:00 AM 7.06 68 0.00 291 3.0 3.4 1004.4 0 15.2 09/29/2018 6:00 AM FosterWeatherStation201809290600 63rd Street Weather Station 07/31/2019 03:00:00 PM 20.70 17.6 74 0.0 0.00 406.7 0 21 5.0 8.0 1000.5 722 355 11.9 07/31/2019 3:00 PM 63rdStreetWeatherStation201907311500 Foster Weather Station 07/31/2019 03:00:00 PM 20.78 61 0.05 12 2.0 2.3 1000.0 0 15.1 07/31/2019 3:00 PM FosterWeatherStation201907311500 Oak Street Weather Station 07/31/2019 03:00:00 PM 21.40 17.0 65 0.0 0.00 153.5 0 66 3.5 4.2 1001.4 745 320 12.1 07/31/2019 3:00 PM OakStreetWeatherStation201907311500 63rd Street Weather Station 07/31/2019 04:00:00 PM 20.80 17.6 74 0.0 0.00 406.7 0 29 5.3 7.4 1000.2 614 355 12.0 07/31/2019 4:00 PM 63rdStreetWeatherStation201907311600 Foster Weather Station 07/31/2019 04:00:00 PM 20.78 60 0.00 31 2.9 3.6 999.7 0 15.1 07/31/2019 4:00 PM FosterWeatherStation201907311600 Oak Street Weather Station 07/31/2019 04:00:00 PM 21.50 17.1 65 0.0 0.00 153.5 0 79 3.3 4.4 1001.1 624 320 12.0 07/31/2019 4:00 PM OakStreetWeatherStation201907311600 63rd Street Weather Station 07/31/2019 05:00:00 PM 20.70 17.5 74 0.0 0.00 406.7 0 41 4.6 8.1 999.3 481 355 11.9 07/31/2019 5:00 PM 63rdStreetWeatherStation201907311700 Foster Weather Station 07/31/2019 05:00:00 PM 20.50 62 0.00 40 2.5 2.9 999.0 0 15.0 07/31/2019 5:00 PM FosterWeatherStation201907311700 Oak Street Weather Station 07/31/2019 05:00:00 PM 20.90 16.8 67 0.0 0.00 153.5 0 90 3.9 5.0 1000.4 43 320 12.1 07/31/2019 5:00 PM OakStreetWeatherStation201907311700 63rd Street Weather Station 07/31/2019 07:00:00 PM 20.90 16.9 67 0.0 0.00 406.7 0 34 3.7 6.7 999.2 147 355 11.9 07/31/2019 7:00 PM 63rdStreetWeatherStation201907311900 Foster Weather Station 07/31/2019 07:00:00 PM 20.56 54 0.00 44 1.4 1.6 998.6 0 15.1 07/31/2019 7:00 PM FosterWeatherStation201907311900 Oak Street Weather Station 07/31/2019 07:00:00 PM 21.40 15.9 57 0.0 0.00 153.5 0 80 2.9 3.9 1000.0 147 320 12.1 07/31/2019 7:00 PM OakStreetWeatherStation201907311900 63rd Street Weather Station 07/31/2019 08:00:00 PM 21.00 15.9 59 0.0 0.00 406.7 0 22 3.3 5.3 998.7 12 355 11.9 07/31/2019 8:00 PM 63rdStreetWeatherStation201907312000 Foster Weather Station 07/31/2019 08:00:00 PM 20.28 51 0.00 21 1.3 2.0 998.3 0 15.1 07/31/2019 8:00 PM FosterWeatherStation201907312000 Oak Street Weather Station 07/31/2019 08:00:00 PM 21.60 15.5 53 0.0 0.00 153.5 0 61 3.2 4.0 999.8 6 320 12.0 07/31/2019 8:00 PM OakStreetWeatherStation201907312000 63rd Street Weather Station 07/31/2019 09:00:00 PM 21.20 16.0 58 0.0 0.00 406.7 0 24 3.7 6.3 999.4 1 356 11.8 07/31/2019 9:00 PM 63rdStreetWeatherStation201907312100 Foster Weather Station 07/31/2019 09:00:00 PM 20.28 52 0.00 359 0.9 1.1 998.6 0 15.1 07/31/2019 9:00 PM FosterWeatherStation201907312100 Oak Street Weather Station 07/31/2019 09:00:00 PM 21.70 15.2 51 0.0 0.00 153.5 0 59 3.4 4.7 1000.2 -3 320 12.0 07/31/2019 9:00 PM OakStreetWeatherStation201907312100 63rd Street Weather Station 07/31/2019 11:00:00 PM 21.20 15.8 57 0.0 0.00 406.7 0 47 1.8 3.4 999.8 1 356 11.9 07/31/2019 11:00 PM 63rdStreetWeatherStation201907312300 Foster Weather Station 07/31/2019 11:00:00 PM 20.56 52 0.00 7 2.1 2.3 999.0 0 15.1 07/31/2019 11:00 PM FosterWeatherStation201907312300 Oak Street Weather Station 07/31/2019 11:00:00 PM 21.70 15.5 52 0.0 0.00 153.5 0 86 2.8 3.5 1000.6 -3 320 12.0 07/31/2019 11:00 PM OakStreetWeatherStation201907312300 63rd Street Weather Station 08/01/2019 12:00:00 AM 21.00 16.6 64 0.0 0.00 406.7 0 64 2.4 4.6 999.5 1 356 11.8 08/01/2019 12:00 AM 63rdStreetWeatherStation201908012400 Foster Weather Station 08/01/2019 12:00:00 AM 20.06 59 0.00 10 1.4 2.1 999.0 0 15.1 08/01/2019 12:00 AM FosterWeatherStation201908012400 Oak Street Weather Station 08/01/2019 12:00:00 AM 21.30 16.1 59 0.0 0.00 153.5 0 83 2.2 3.1 1000.4 -3 320 12.0 08/01/2019 12:00 AM OakStreetWeatherStation201908012400 63rd Street Weather Station 08/01/2019 01:00:00 AM 21.00 16.7 65 0.0 0.00 406.7 0 64 2.4 4.0 999.6 1 356 11.9 08/01/2019 1:00 AM 63rdStreetWeatherStation201908010100 Foster Weather Station 08/01/2019 01:00:00 AM 20.00 59 0.00 25 1.6 1.9 999.0 0 15.1 08/01/2019 1:00 AM FosterWeatherStation201908010100 Oak Street Weather Station 08/01/2019 01:00:00 AM 21.00 16.5 64 0.0 0.00 153.5 0 90 2.2 2.8 1000.5 -3 320 12.1 08/01/2019 1:00 AM OakStreetWeatherStation201908010100 63rd Street Weather Station 08/01/2019 02:00:00 AM 20.80 17.4 71 0.0 0.00 406.7 0 60 1.8 3.4 999.5 1 356 12.0 08/01/2019 2:00 AM 63rdStreetWeatherStation201908010200 Foster Weather Station 08/01/2019 02:00:00 AM 19.78 65 0.00 64 1.0 1.7 999.0 0 15.1 08/01/2019 2:00 AM FosterWeatherStation201908010200 Oak Street Weather Station 08/01/2019 02:00:00 AM 21.10 16.7 64 0.0 0.00 153.5 0 97 2.7 3.5 1000.3 -4 320 12.0 08/01/2019 2:00 AM OakStreetWeatherStation201908010200 63rd Street Weather Station 08/01/2019 03:00:00 AM 20.90 17.4 71 0.0 0.00 406.7 0 64 1.7 3.4 999.7 1 356 11.9 08/01/2019 3:00 AM 63rdStreetWeatherStation201908010300 Foster Weather Station 08/01/2019 03:00:00 AM 19.89 65 0.00 30 1.7 1.8 999.0 0 15.1 08/01/2019 3:00 AM FosterWeatherStation201908010300 Oak Street Weather Station 08/01/2019 03:00:00 AM 21.20 16.7 64 0.0 0.00 153.5 0 92 2.2 2.6 1000.4 -4 320 12.1 08/01/2019 3:00 AM OakStreetWeatherStation201908010300 Foster Weather Station 09/16/2015 12:00:00 AM 22.28 43 0.00 202 3.7 4.2 1000.3 0 15.1 09/16/2015 12:00 AM FosterWeatherStation201509162400 Foster Weather Station 09/17/2015 01:00:00 AM 22.00 53 0.00 176 3.7 4.0 996.3 0 15.1 09/17/2015 1:00 AM FosterWeatherStation201509170100 Foster Weather Station 09/17/2015 02:00:00 AM 21.39 56 0.00 182 2.1 2.3 996.3 1 15.1 09/17/2015 2:00 AM FosterWeatherStation201509170200 Foster Weather Station 09/17/2015 03:00:00 AM 20.78 59 0.00 189 5.2 6.8 995.9 0 15.1 09/17/2015 3:00 AM FosterWeatherStation201509170300 Foster Weather Station 09/17/2015 04:00:00 AM 20.17 61 0.00 210 3.8 4.8 995.6 0 15.1 09/17/2015 4:00 AM FosterWeatherStation201509170400 Foster Weather Station 09/17/2015 05:00:00 AM 19.89 64 0.00 203 4.0 5.1 995.6 0 15.1 09/17/2015 5:00 AM FosterWeatherStation201509170500 Foster Weather Station 09/17/2015 06:00:00 AM 20.06 63 0.00 198 4.7 5.1 995.3 0 15.1 09/17/2015 6:00 AM FosterWeatherStation201509170600 Foster Weather Station 09/17/2015 07:00:00 AM 20.56 60 0.00 202 5.1 5.9 994.9 18 15.1 09/17/2015 7:00 AM FosterWeatherStation201509170700 Foster Weather Station 09/17/2015 08:00:00 AM 21.28 58 0.00 198 3.7 4.0 994.6 80 15.1 09/17/2015 8:00 AM FosterWeatherStation201509170800 Foster Weather Station 09/17/2015 09:00:00 AM 22.56 56 0.00 206 3.4 4.2 994.6 346 15.1 09/17/2015 9:00 AM FosterWeatherStation201509170900 Foster Weather Station 09/17/2015 10:00:00 AM 24.00 54 0.00 212 2.5 3.0 994.2 485 15.1 09/17/2015 10:00 AM FosterWeatherStation201509171000 Foster Weather Station 09/17/2015 11:00:00 AM 25.67 51 0.00 223 3.0 3.4 993.6 667 15.1 09/17/2015 11:00 AM FosterWeatherStation201509171100 Foster Weather Station 09/17/2015 12:00:00 PM 26.56 51 0.00 196 3.8 5.7 993.2 630 15.1 09/17/2015 12:00 PM FosterWeatherStation201509171200 Foster Weather Station 09/17/2015 01:00:00 PM 27.67 49 0.00 192 3.8 4.5 992.6 666 15.1 09/17/2015 1:00 PM FosterWeatherStation201509171300 Foster Weather Station 09/17/2015 02:00:00 PM 28.67 47 0.00 174 4.7 5.4 991.9 646 15.1 09/17/2015 2:00 PM FosterWeatherStation201509171400 Foster Weather Station 09/17/2015 03:00:00 PM 29.00 47 0.00 210 3.2 4.0 990.9 268 15.1 09/17/2015 3:00 PM FosterWeatherStation201509171500 Foster Weather Station 09/17/2015 04:00:00 PM 29.00 47 0.00 195 2.5 3.2 990.2 128 15.1 09/17/2015 4:00 PM FosterWeatherStation201509171600 Foster Weather Station 09/17/2015 05:00:00 PM 24.89 54 1.32 252 3.1 4.0 991.2 9 15.1 09/17/2015 5:00 PM FosterWeatherStation201509171700 Foster Weather Station 09/17/2015 06:00:00 PM 21.06 76 1.88 93 0.4 0.9 989.8 6 15.1 09/17/2015 6:00 PM FosterWeatherStation201509171800 Foster Weather Station 09/17/2015 07:00:00 PM 24.17 68 0.33 170 3.8 4.3 988.8 0 15.1 09/17/2015 7:00 PM FosterWeatherStation201509171900 Foster Weather Station 09/17/2015 08:00:00 PM 26.28 57 0.00 175 2.1 2.6 989.2 1 15.1 09/17/2015 8:00 PM FosterWeatherStation201509172000 Foster Weather Station 09/17/2015 09:00:00 PM 26.17 55 0.05 180 4.9 5.9 988.5 1 15.1 09/17/2015 9:00 PM FosterWeatherStation201509172100 Foster Weather Station 09/18/2015 01:00:00 AM 24.56 63 0.00 201 3.5 4.2 987.8 1 15.1 09/18/2015 1:00 AM FosterWeatherStation201509180100 Foster Weather Station 09/18/2015 02:00:00 AM 18.67 92 29.79 36 2.8 3.0 988.5 0 15.1 09/18/2015 2:00 AM FosterWeatherStation201509180200 Foster Weather Station 09/18/2015 03:00:00 AM 18.67 92 19.61 105 0.5 0.9 987.5 0 15.1 09/18/2015 3:00 AM FosterWeatherStation201509180300 Foster Weather Station 09/18/2015 04:00:00 AM 19.28 93 4.75 346 1.0 1.1 987.8 0 15.1 09/18/2015 4:00 AM FosterWeatherStation201509180400 Foster Weather Station 09/18/2015 05:00:00 AM 19.17 92 3.45 191 0.6 0.8 987.5 0 15.1 09/18/2015 5:00 AM FosterWeatherStation201509180500 Foster Weather Station 09/18/2015 06:00:00 AM 20.28 92 0.81 218 2.7 3.3 987.1 0 15.1 09/18/2015 6:00 AM FosterWeatherStation201509180600 Foster Weather Station 09/18/2015 07:00:00 AM 19.56 89 0.00 255 2.2 2.8 987.5 22 15.1 09/18/2015 7:00 AM FosterWeatherStation201509180700 Foster Weather Station 09/18/2015 08:00:00 AM 20.00 84 0.00 250 1.2 1.7 988.1 112 15.1 09/18/2015 8:00 AM FosterWeatherStation201509180800 Foster Weather Station 09/18/2015 10:00:00 AM 22.78 75 0.00 197 4.9 5.3 987.8 432 15.1 09/18/2015 10:00 AM FosterWeatherStation201509181000 Foster Weather Station 09/18/2015 11:00:00 AM 24.00 74 0.00 219 1.6 2.9 987.8 174 15.1 09/18/2015 11:00 AM FosterWeatherStation201509181100 Foster Weather Station 09/18/2015 12:00:00 PM 23.78 77 0.00 222 2.7 3.3 988.1 93 15.1 09/18/2015 12:00 PM FosterWeatherStation201509181200 Foster Weather Station 09/18/2015 01:00:00 PM 24.06 77 0.00 200 0.6 0.9 987.5 186 15.1 09/18/2015 1:00 PM FosterWeatherStation201509181300 Foster Weather Station 09/18/2015 02:00:00 PM 21.00 82 0.00 340 1.3 1.4 988.1 53 15.1 09/18/2015 2:00 PM FosterWeatherStation201509181400 Foster Weather Station 09/18/2015 03:00:00 PM 19.50 90 0.00 33 0.8 1.0 987.5 94 15.1 09/18/2015 3:00 PM FosterWeatherStation201509181500 Foster Weather Station 09/18/2015 04:00:00 PM 19.56 90 0.05 9 0.9 1.1 986.1 110 15.1 09/18/2015 4:00 PM FosterWeatherStation201509181600 Foster Weather Station 09/18/2015 05:00:00 PM 20.06 91 0.00 131 1.4 1.7 986.8 3 15.1 09/18/2015 5:00 PM FosterWeatherStation201509181700 63rd Street Weather Station 09/29/2018 07:00:00 AM 7.90 6.1 77 0.0 0.00 263.2 0 271 1.5 2.9 1005.7 14 355 11.9 09/29/2018 7:00 AM 63rdStreetWeatherStation201809290700 Foster Weather Station 09/29/2018 07:00:00 AM 7.17 70 0.00 269 1.6 1.7 1004.7 0 15.2 09/29/2018 7:00 AM FosterWeatherStation201809290700 63rd Street Weather Station 09/29/2018 08:00:00 AM 8.90 6.9 75 0.0 0.00 263.2 0 264 1.4 1.9 1005.6 44 355 11.9 09/29/2018 8:00 AM 63rdStreetWeatherStation201809290800 Foster Weather Station 09/29/2018 08:00:00 AM 8.28 68 0.00 248 1.6 1.7 1004.7 0 15.1 09/29/2018 8:00 AM FosterWeatherStation201809290800 63rd Street Weather Station 09/29/2018 09:00:00 AM 12.40 9.3 68 0.0 0.00 263.2 0 336 1.1 2.1 1005.9 309 356 11.8 09/29/2018 9:00 AM 63rdStreetWeatherStation201809290900 Foster Weather Station 09/29/2018 09:00:00 AM 11.28 61 0.00 209 0.8 1.1 1005.4 0 15.1 09/29/2018 9:00 AM FosterWeatherStation201809290900 63rd Street Weather Station 09/29/2018 10:00:00 AM 13.30 8.9 55 0.0 0.00 263.2 0 38 2.4 3.2 1006.1 457 356 11.9 09/29/2018 10:00 AM 63rdStreetWeatherStation201809291000 Foster Weather Station 09/29/2018 10:00:00 AM 12.78 45 0.00 343 2.5 2.9 1005.4 0 15.1 09/29/2018 10:00 AM FosterWeatherStation201809291000 63rd Street Weather Station 09/29/2018 11:00:00 AM 13.80 8.9 52 0.0 0.00 263.2 0 58 1.9 3.5 1005.7 566 356 11.9 09/29/2018 11:00 AM 63rdStreetWeatherStation201809291100 Foster Weather Station 09/29/2018 11:00:00 AM 13.50 41 0.00 67 1.4 1.7 1004.7 0 15.1 09/29/2018 11:00 AM FosterWeatherStation201809291100 63rd Street Weather Station 09/29/2018 12:00:00 PM 14.30 8.6 45 0.0 0.00 263.2 0 73 3.1 4.8 1005.7 921 355 11.9 09/29/2018 12:00 PM 63rdStreetWeatherStation201809291200 Foster Weather Station 09/29/2018 12:00:00 PM 13.67 49 0.00 9 3.1 3.7 1004.7 0 15.1 09/29/2018 12:00 PM FosterWeatherStation201809291200 63rd Street Weather Station 09/29/2018 01:00:00 PM 14.10 8.7 48 0.0 0.00 263.2 0 49 1.4 2.4 1005.3 417 355 11.8 09/29/2018 1:00 PM 63rdStreetWeatherStation201809291300 Foster Weather Station 09/29/2018 01:00:00 PM 13.89 42 0.00 3 3.3 3.6 1004.7 0 15.1 09/29/2018 1:00 PM FosterWeatherStation201809291300 63rd Street Weather Station 09/29/2018 02:00:00 PM 14.10 8.7 48 0.0 0.00 263.2 0 67 2.9 5.4 1004.4 135 356 11.9 09/29/2018 2:00 PM 63rdStreetWeatherStation201809291400 Foster Weather Station 09/29/2018 02:00:00 PM 13.17 48 0.00 2 1.7 2.2 1004.1 0 15.1 09/29/2018 2:00 PM FosterWeatherStation201809291400 63rd Street Weather Station 09/29/2018 03:00:00 PM 14.10 8.3 44 0.0 0.00 263.2 0 78 2.1 3.3 1004.1 145 355 11.9 09/29/2018 3:00 PM 63rdStreetWeatherStation201809291500 Foster Weather Station 09/29/2018 03:00:00 PM 13.17 51 0.00 62 1.5 1.9 1003.4 0 15.1 09/29/2018 3:00 PM FosterWeatherStation201809291500 63rd Street Weather Station 09/29/2018 04:00:00 PM 14.10 8.8 49 0.0 0.00 263.2 0 92 1.7 3.3 1004.1 68 355 11.9 09/29/2018 4:00 PM 63rdStreetWeatherStation201809291600 Foster Weather Station 09/29/2018 04:00:00 PM 13.39 47 0.00 87 2.7 3.0 1003.4 0 15.1 09/29/2018 4:00 PM FosterWeatherStation201809291600 63rd Street Weather Station 09/29/2018 05:00:00 PM 14.20 9.1 50 0.0 0.00 263.2 0 74 2.8 4.3 1003.5 33 356 11.9 09/29/2018 5:00 PM 63rdStreetWeatherStation201809291700 Foster Weather Station 09/29/2018 05:00:00 PM 13.50 47 0.00 94 1.8 2.2 1002.7 0 15.1 09/29/2018 5:00 PM FosterWeatherStation201809291700 63rd Street Weather Station 09/29/2018 06:00:00 PM 14.40 9.2 50 0.0 0.00 263.2 0 86 3.1 4.2 1003.1 6 355 11.9 09/29/2018 6:00 PM 63rdStreetWeatherStation201809291800 Foster Weather Station 09/29/2018 06:00:00 PM 13.67 45 0.00 37 3.0 3.4 1003.0 0 15.1 09/29/2018 6:00 PM FosterWeatherStation201809291800 63rd Street Weather Station 09/29/2018 07:00:00 PM 14.60 9.9 55 0.0 0.00 263.2 0 97 2.8 4.9 1002.7 2 356 11.9 09/29/2018 7:00 PM 63rdStreetWeatherStation201809291900 Foster Weather Station 09/29/2018 07:00:00 PM 13.89 51 0.00 98 0.8 1.2 1002.4 0 15.1 09/29/2018 7:00 PM FosterWeatherStation201809291900 63rd Street Weather Station 07/31/2019 06:00:00 PM 20.80 16.9 68 0.0 0.00 406.7 0 41 4.2 7.6 999.2 309 354 12.0 07/31/2019 6:00 PM 63rdStreetWeatherStation201907311800 Foster Weather Station 07/31/2019 06:00:00 PM 20.28 62 0.00 33 2.0 2.1 998.6 0 15.1 07/31/2019 6:00 PM FosterWeatherStation201907311800 Oak Street Weather Station 07/31/2019 06:00:00 PM 20.80 16.8 67 0.0 0.00 153.5 0 81 3.6 4.8 1000.2 24 320 12.0 07/31/2019 6:00 PM OakStreetWeatherStation201907311800 63rd Street Weather Station 07/31/2019 10:00:00 PM 21.60 14.8 48 0.0 0.00 406.7 0 31 4.6 6.2 999.6 1 356 11.8 07/31/2019 10:00 PM 63rdStreetWeatherStation201907312200 Foster Weather Station 07/31/2019 10:00:00 PM 20.50 47 0.00 347 1.5 2.0 999.0 0 15.1 07/31/2019 10:00 PM FosterWeatherStation201907312200 Oak Street Weather Station 07/31/2019 10:00:00 PM 22.00 15.6 51 0.0 0.00 153.5 0 61 3.1 3.8 1000.6 -3 320 12.0 07/31/2019 10:00 PM OakStreetWeatherStation201907312200 63rd Street Weather Station 08/01/2019 04:00:00 AM 21.20 17.7 71 0.0 0.00 406.7 0 67 2.8 4.6 999.2 1 356 11.9 08/01/2019 4:00 AM 63rdStreetWeatherStation201908010400 Foster Weather Station 08/01/2019 04:00:00 AM 20.00 67 0.00 36 1.1 1.4 998.6 0 15.1 08/01/2019 4:00 AM FosterWeatherStation201908010400 Oak Street Weather Station 08/01/2019 04:00:00 AM 21.20 17.0 66 0.0 0.00 153.5 0 104 2.4 2.8 1000.2 -3 320 12.0 08/01/2019 4:00 AM OakStreetWeatherStation201908010400 63rd Street Weather Station 09/29/2018 08:00:00 PM 14.70 10.0 52 0.0 0.00 263.2 0 66 3.1 5.1 1003.4 2 356 11.9 09/29/2018 8:00 PM 63rdStreetWeatherStation201809292000 Foster Weather Station 09/18/2015 06:00:00 PM 19.78 88 1.09 68 1.0 1.3 986.8 3 15.1 09/18/2015 6:00 PM FosterWeatherStation201509181800 Foster Weather Station 09/18/2015 07:00:00 PM 19.78 87 0.15 172 2.1 2.3 986.5 0 15.1 09/18/2015 7:00 PM FosterWeatherStation201509181900 Foster Weather Station 09/18/2015 08:00:00 PM 20.17 89 4.65 96 1.2 1.4 986.8 0 15.1 09/18/2015 8:00 PM FosterWeatherStation201509182000 Foster Weather Station 09/18/2015 09:00:00 PM 19.56 92 7.39 164 2.4 2.8 986.1 0 15.1 09/18/2015 9:00 PM FosterWeatherStation201509182100 Foster Weather Station 09/18/2015 10:00:00 PM 19.28 92 0.13 159 1.9 2.1 985.4 0 15.1 09/18/2015 10:00 PM FosterWeatherStation201509182200 Foster Weather Station 09/18/2015 11:00:00 PM 20.39 91 0.10 188 2.4 2.6 984.4
Explanations and Answers 0

No answers posted

Post your Answer - free or at a fee

Login to your tutor account to post an answer

Posting a free answer earns you +20 points.

Login

NB: Post a homework question for free and get answers - free or paid homework help.

Get answers to: Coding Assingment. 2 (Python/Sql) or similar questions only at Tutlance.

Related Questions