{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "ab8655e8-3a16-4481-9ffb-0e4bcfeada62",
"metadata": {},
"outputs": [],
"source": [
"from requests.auth import HTTPBasicAuth\n",
"from requests.packages.urllib3.exceptions import InsecureRequestWarning\n",
"import matplotlib.pyplot as plt\n",
"import requests, json, os\n",
"from dotenv import load_dotenv\n",
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "d351a581-662d-44c7-881d-e827821fbbd7",
"metadata": {},
"outputs": [],
"source": [
"requests.packages.urllib3.disable_warnings(InsecureRequestWarning)\n",
"\n",
"#create a file envViewer.txt with \n",
"#USER='XXXX'\n",
"#PASSWORD='XXXX'\n",
"load_dotenv('envViewer.txt')\n",
"user = os.getenv('ISTSOSUSER')\n",
"password = os.getenv('ISTSOSPASSWORD')\n",
"\n",
"auth = HTTPBasicAuth(user, password)"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "94dd302a-071d-4c7f-a211-9fcfdd8835dd",
"metadata": {},
"outputs": [],
"source": [
"url = 'https://apps.hatarilabs.com/istsos'\n",
"service = 'temperature'\n",
"procedure = 'genericSensor'\n",
"off = 'tempnetwork'"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "f83f18d4-32e5-44ff-b83e-bafee3d444f3",
"metadata": {},
"outputs": [],
"source": [
"beginTime = \"2023-06-01T00:00:00-05:00\"\n",
"endTime = \"2023-06-02T20:00:00-05:00\"\n",
"# Preparing \"io\" object to send\n",
"observedProperties = requests.get(\n",
" '%s/wa/istsos/services/%s/operations/getobservation/offerings/'\n",
" '%s/procedures/%s/observedproperties/:/eventtime/%s/%s' % (\n",
" url, service, off, procedure,beginTime,endTime),\n",
" params={\n",
" \"qualityIndex\": \"False\"\n",
" }, auth=auth)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "9ee581d9-e2cd-4cf7-b702-851a5db38fa5",
"metadata": {},
"outputs": [],
"source": [
"observedList = observedProperties.json()['data'][0]['result']['DataArray']['values']"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "f95a8df8-6eb2-4c24-a1c5-c57b155b7b48",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[['2023-06-01T10:49:04.650563-05:00', 23.625],\n",
" ['2023-06-01T10:50:04.170496-05:00', 23.625],\n",
" ['2023-06-01T10:51:05.050523-05:00', 30.5],\n",
" ['2023-06-01T10:52:04.490570-05:00', 29.125],\n",
" ['2023-06-01T10:53:04.810532-05:00', 28.0]]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"observedList[:5]"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "4772aabd-eb5d-4bac-8c03-d6c481d905bb",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Date | \n",
" Temp | \n",
"
\n",
" \n",
" \n",
" \n",
"
\n",
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Temp | \n",
"
\n",
" \n",
" | Date | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" | 2023-06-01 10:49:04.650563-05:00 | \n",
" 23.625 | \n",
"
\n",
" \n",
" | 2023-06-01 10:50:04.170496-05:00 | \n",
" 23.625 | \n",
"
\n",
" \n",
" | 2023-06-01 10:51:05.050523-05:00 | \n",
" 30.500 | \n",
"
\n",
" \n",
" | 2023-06-01 10:52:04.490570-05:00 | \n",
" 29.125 | \n",
"
\n",
" \n",
" | 2023-06-01 10:53:04.810532-05:00 | \n",
" 28.000 | \n",
"
\n",
" \n",
"
\n",
"