{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Mosquito Bundler" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The purpose of this notebook is to allow the user to select a data range and polygon on a map to retrieve all the data from the mosquito bundle protocols for the selection." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Select \"Restart & Run All\" from the \"Kernel\" menu and confirm \"Restart and Run All Cells.\"" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Open any *** settings -----> sections with the ^ button in the tool bar above." ] }, { "cell_type": "markdown", "metadata": { "heading_collapsed": true }, "source": [ "### Importing Modules and Tools" ] }, { "cell_type": "markdown", "metadata": { "hidden": true }, "source": [ "The following code imports needed modules and subroutines." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for designation: designating hidden code blocks)\n" ] } ], "source": [ "# subroutine for designating a code block\n", "def designate(title, section='main'):\n", " \"\"\"Designate a code block with a title so that the code may be hidden and reopened.\n", " \n", " Arguments:\n", " title: str, title for code block\n", " section='main': str, section title\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", " \n", " # begin designation\n", " designation = ' ' * 20\n", " \n", " # if marked for user parameters\n", " if section == 'settings':\n", " \n", " # begin designation with indicator\n", " designation = '*** settings -----> '\n", " \n", " # add code designator\n", " designation += '^ [code] (for {}: {})'.format(section, title)\n", " \n", " # print\n", " print(designation)\n", " \n", " return None\n", "\n", "# apply to itself\n", "designate('designating hidden code blocks', 'designation')" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: importing Python modules)\n" ] } ], "source": [ "designate('importing Python modules')\n", "\n", "# import os and sys modules for system controls\n", "import os\n", "import sys\n", "\n", "# import requests and json modules for making API requests\n", "import requests\n", "import json\n", "\n", "# set runtime warnings to ignore\n", "import warnings\n", "\n", "# import datetime module for manipulating date and time formats\n", "from datetime import datetime\n", "\n", "# import iPython for javascript based notebook controls\n", "from IPython.display import Javascript, display, FileLink\n", "\n", "# import ipywidgets for additional widgets\n", "from ipywidgets import Button\n", "\n", "# import ipyleaflet for the map\n", "from ipyleaflet import Map, DrawControl, basemaps, GeoJSON\n", "\n", "# import geopy to get country from coordinates\n", "from geopy.geocoders import Nominatim\n", "from geopy.exc import GeocoderQueryError\n", "\n", "# import pandas to create csv files and display tables\n", "import pandas\n", "\n", "# import zipfile to create zip files\n", "from zipfile import ZipFile" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: defining global variables)\n" ] } ], "source": [ "designate('defining global variables')\n", "\n", "# disable runtime warnings\n", "warnings.filterwarnings('ignore')\n", "\n", "# set pandas optinos\n", "pandas.set_option(\"display.max_rows\", None)\n", "pandas.set_option(\"display.max_columns\", None)\n", "\n", "# default link\n", "link = None" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "hidden": true, "hide_input": true, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for introspection: scanning notebook for cells)\n" ] } ], "source": [ "designate('scanning notebook for cells', 'introspection')\n", "\n", "# scan notebook for cell information\n", "def scan():\n", " \"\"\"Scan the notebook and collect cell information.\n", "\n", " Arguments:\n", " None\n", "\n", " Returns:\n", " list of dicts\n", " \"\"\"\n", "\n", " # open the notebook file \n", " with open('bundler.ipynb', 'r', encoding='utf-8') as pointer:\n", " \n", " # and read its contents\n", " contents = json.loads(pointer.read())\n", "\n", " # get all cells\n", " cells = contents['cells']\n", "\n", " return cells" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for navigation: looking for particular cell)\n" ] } ], "source": [ "designate('looking for particular cell', 'navigation')\n", "\n", "# function to look for cells with a particular text snippet\n", "def look(text):\n", " \"\"\"Look for a particular text amongst the cells.\n", " \n", " Arguments:\n", " text: str, the text to search for\n", " \n", " Returns:\n", " list of int, the cell indices.\n", " \"\"\"\n", " \n", " # get cells\n", " cells = scan()\n", " \n", " # search for cells \n", " indices = []\n", " for index, cell in enumerate(cells):\n", " \n", " # search for text in source\n", " if any([text in line for line in cell['source']]):\n", " \n", " # but disregard if text is in quotes\n", " if all([\"'{}'\".format(text) not in line for line in cell['source']]):\n", " \n", " # add to list\n", " indices.append(index)\n", " \n", " return indices" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for navigation: executing cell range by text)\n" ] } ], "source": [ "designate('executing cell range by text', 'navigation')\n", "\n", "# execute cell range command\n", "def execute(start, finish):\n", " \"\"\"Execute a cell range based on text snippets.\n", " \n", " Arguments:\n", " start: str, text from beginning cell of range\n", " finish: str, text from ending cell of range\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", " \n", " # find start and finish indices, adding 1 to be inclusive\n", " opening = look(start)[0] \n", " closing = look(finish)[0]\n", " bracket = (opening, closing)\n", " \n", " # make command\n", " command = 'IPython.notebook.execute_cell_range' + str(bracket)\n", " \n", " # perform execution\n", " display(Javascript(command))\n", " \n", " return None" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for navigation: refreshing cells by relative position)\n" ] } ], "source": [ "designate('refreshing cells by relative position', 'navigation')\n", "\n", "# execute cell range command\n", "def refresh(start, finish=None):\n", " \"\"\"Refresh a particular cell relative to current cell.\n", " \n", " Arguments:\n", " start: int, the first cell offset\n", " finish=None: int, the second cell offset\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", " \n", " # make offset into a string\n", " stringify = lambda offset: str(offset) if offset < 0 else '+' + str(offset)\n", " \n", " # default finish to start\n", " finish = finish or start\n", " \n", " # make command\n", " command = 'IPython.notebook.execute_cell_range('\n", " command += 'IPython.notebook.get_selected_index()' + stringify(start) + ','\n", " command += 'IPython.notebook.get_selected_index()' + stringify(finish + 1) + ')'\n", " \n", " # perform execution\n", " display(Javascript(command))\n", " \n", " return None" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for mapping: ridding polygons)\n" ] } ], "source": [ "designate('ridding polygons', 'mapping')\n", "\n", "# function to clear old polygons with drawing of newone\n", "def rid(self, action, geo_json):\n", " \"\"\"Rid the map of previous polygons, keeping only the one drawn.\n", " \n", " Arguments:\n", " self: self\n", " action: action\n", " geo_json: dict\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", " \n", " # clear polygons and rectanges from draw control\n", " chart.controls[-1].clear_polygons()\n", " chart.controls[-1].clear_rectangles()\n", " \n", " # remove all previous layers\n", " chart.layers = chart.layers[:1]\n", " \n", " # add polygon to chart\n", " chart.add_layer(GeoJSON(data=geo_json))\n", " \n", " return None" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for mapping: forcing rectanges)\n" ] } ], "source": [ "designate('forcing rectanges', 'mapping')\n", "\n", "# force a polygon on the map\n", "def force(south, north, west, east):\n", " \"\"\"Force a rectangle onto the map.\n", " \n", " Arguments:\n", " south: float\n", " north: float\n", " west: float\n", " east: float\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", " \n", " # check for values\n", " if all([cardinal is not None for cardinal in [south, north, west, east]]):\n", " \n", " # construct coordinates\n", " coordinates = [[[west, south], [west, north], [east, north], [east, south], [west, south]]]\n", " \n", " # construct geo_json\n", " geo_json = {'type': 'Feature'}\n", " geo_json['properties'] = {'style': chart.controls[-1].rectangle['shapeOptions']}\n", " geo_json['geometry'] = {'type': 'Polygon', 'coordinates': coordinates}\n", " \n", " # add rectangle to chart\n", " chart.add_layer(GeoJSON(data=geo_json))\n", " \n", " return None" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for mapping: locating country from geocoordinates)\n" ] } ], "source": [ "designate('locating country from geocoordinates', 'mapping')\n", "\n", "# locate function\n", "def locate(longitude, latitude):\n", " \"\"\"Locate the country from a geocoordinate pair:\n", " \n", " Arguments:\n", " latitude: float\n", " longitude: float\n", " \n", " Returns:\n", " str\n", " \"\"\"\n", "\n", " # try to get country\n", " country = ''\n", " try:\n", " \n", " # get country name\n", " locator = Nominatim(user_agent=\"GLOBE\")\n", " query = ', '.join([str(latitude), str(longitude)])\n", " location = locator.reverse(query, language='english')\n", " country = location.raw['address']['country']\n", " country = '{}'.format(country.encode('ascii', errors='ignore').decode())\n", " \n", " # otherwise\n", " except (KeyError, GeocoderQueryError):\n", " \n", " # pass\n", " pass\n", " \n", " return country" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "hidden": true, "hide_input": true, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for mapping: retrieving the surrounding polygon)\n" ] } ], "source": [ "designate('retrieving the surrounding polygon', 'mapping')\n", "\n", "# getting polygon from map routine\n", "def surround(chart):\n", " \"\"\"Get the polygon surrounding the area on the map\n", " \n", " Arguments:\n", " chart: ipyleaflet chart\n", " \n", " Returns:\n", " list of points, polygon\n", " \"\"\"\n", "\n", " # try to retrieve the polygon\n", " try:\n", "\n", " # get polygon\n", " polygon = chart.layers[1].data['geometry']['coordinates'][0]\n", "\n", " # unless it is not available\n", " except IndexError:\n", " \n", " # set to message\n", " polygon = ['no polygon drawn yet, please draw one on the map']\n", " \n", " return polygon" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for processing: record flattening)\n" ] } ], "source": [ "designate('record flattening', 'processing')\n", "\n", "# function to flatten a nested list into a single-level structure\n", "def flatten(record, label=None):\n", " \"\"\"Flatten each record into a single level.\n", "\n", " Arguments:\n", " record: dict, a record\n", " label: str, key from last nesting\n", "\n", " Returns:\n", " dict\n", " \"\"\"\n", "\n", " # initiate dictionary\n", " flattened = {}\n", "\n", " # try to flatten the record\n", " try:\n", "\n", " # go through each field\n", " for field, info in record.items():\n", "\n", " # and flatten the smaller records found there\n", " flattened.update(flatten(info, field))\n", "\n", " # otherwise record is a terminal entry\n", " except AttributeError:\n", "\n", " # so update the dictionary with the record\n", " flattened.update({label: record})\n", "\n", " return flattened" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "hidden": true, "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for api: calling the api subroutine)\n" ] } ], "source": [ "designate('calling the api subroutine', 'api')\n", "\n", "# call the api with protocol and country code\n", "def call(protocol, beginning, ending, polygon):\n", " \"\"\"Call the api:\n", " \n", " Arguments:\n", " protocol: str, the protocol\n", " beginning: str, the beginning date\n", " ending: str, the ending date\n", " polygon: list of points\n", " \n", " Returns:\n", " list of dicts, the records\n", " \"\"\"\n", " \n", " # assemble the url for the API call \n", " url = 'https://api.globe.gov/search/v1/measurement/protocol/measureddate/polygon/geojson/'\n", " url += '?protocols=' + protocol\n", " url += '&startdate=' + beginning \n", " url += '&enddate=' + ending\n", " \n", " # begin with first point, and continue\n", " coordinates = '%5B%5B' + str(polygon[0][0]) + '%2C%20' + str(polygon[0][1])\n", " for point in polygon[1:]:\n", " \n", " # add points\n", " coordinates += '%5D%2C%20%5B' + str(point[0]) + '%2C%20' + str(point[1])\n", " \n", " # end with cap\n", " coordinates += '%5D%5D'\n", " url += '&coordinates=' + coordinates\n", "\n", " # geojson parameter toggles between formats\n", " url += '&geojson=FALSE'\n", " \n", " # sample parameter returns small sample set if true\n", " url += '&sample=FALSE'\n", " \n", " # make the API call and return the raw results\n", " request = requests.get(url)\n", " raw = json.loads(request.text)\n", " \n", " return raw" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "hidden": true, "hide_input": false, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for api: collecting results from all protocols)\n" ] } ], "source": [ "designate('collecting results from all protocols', 'api')\n", "\n", "# collecting results\n", "def collect(polygon):\n", " \"\"\"Collect all data from within dates and polygon on map.\n", " \n", " Arguments:\n", " polygon: list of points\n", " \n", " Returns:\n", " list of panda frames\n", " \"\"\"\n", " \n", " # check polygon\n", " assert polygon[0] != str(polygon[0]), 'no polygon drawn on map yet'\n", " \n", " # set protocol list\n", " mosquitoes = 'mosquito_habitat_mapper'\n", " protocols = [mosquitoes] + secondaries\n", " \n", " # begin zipfile\n", " date = str(datetime.now().date()).replace('-', '')\n", " now = str(int(datetime.now().timestamp()))\n", " bundle = 'mosquitoes_bundle_' + date + '_' + now +'.zip'\n", " album = ZipFile(bundle, 'w')\n", "\n", " # collect results\n", " for protocol in protocols:\n", "\n", " # make call\n", " print('\\nmaking request from {}...'.format(protocol))\n", " raw = call(protocol, beginning, ending, polygon)\n", " result = raw['results']\n", " length = len(result)\n", " message = '{} results returned from {}.\\n'.format(length, protocol)\n", " summary.append(message)\n", " print(message)\n", "\n", " # flatten all records\n", " records = [flatten(record) for record in result]\n", " panda = pandas.DataFrame(records)\n", " \n", " # write dataframe to file\n", " name = protocol + '_' + date + '_' + now + '.csv'\n", " panda.to_csv(name) \n", " album.write(name)\n", " \n", " # delete file\n", " os.remove(name)\n", " \n", " # display sample\n", " display(panda.head(5))\n", " \n", " # create summary\n", " path = 'summary_' + date + '_' + now + '.txt'\n", " with open(path, 'w') as pointer:\n", " \n", " # write summary file\n", " pointer.writelines(summary)\n", " \n", " # add to album and remove from main directory\n", " album.write(path)\n", " os.remove(path)\n", " \n", " # make link\n", " link = FileLink(bundle)\n", "\n", " return link" ] }, { "cell_type": "code", "execution_count": 108, "metadata": { "hidden": true, "hide_input": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: import status)\n", "modules imported.\n" ] } ], "source": [ "designate('import status')\n", "\n", "# print status\n", "print('modules imported.')" ] }, { "cell_type": "markdown", "metadata": { "heading_collapsed": true }, "source": [ "### MyBinder Link" ] }, { "cell_type": "markdown", "metadata": { "hidden": true }, "source": [ "This notebook is available at the following link hosted by MyBinder:" ] }, { "cell_type": "markdown", "metadata": { "hidden": true }, "source": [ "https://mybinder.org/v2/git/https%3A%2F%2Fmattbandel%40bitbucket.org%2Fmattbandel%2Fglobe-mosquitoes-bundler.git/master?filepath=bundler.ipynb" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Mosquito Bundle Protocols" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Data from the following GLOBE protocols are considered part of the mosquitoes bundle." ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "hide_input": true, "scrolled": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: table of mosquito bundle protocols)\n", "21 mosquito bundle protocols:\n" ] }, { "data": { "text/plain": [ "['air_temp_dailies',\n", " 'air_temp_monthlies',\n", " 'air_temp_noons',\n", " 'air_temps',\n", " 'conductivities',\n", " 'dissolved_oxygens',\n", " 'freshwater_macroinvertebrates',\n", " 'humidities',\n", " 'humidity_monthlies',\n", " 'humidity_noons',\n", " 'hydrology_alkalinities',\n", " 'hydrology_phs',\n", " 'land_covers',\n", " 'precipitation_monthlies',\n", " 'precipitations',\n", " 'salinities',\n", " 'surface_temperature_noons',\n", " 'surface_temperatures',\n", " 'transparencies',\n", " 'vegatation_covers',\n", " 'water_temperatures']" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "designate('table of mosquito bundle protocols')\n", "\n", "# get from secondaries file\n", "with open('protocols.txt', 'r') as pointer:\n", " \n", " # get all secondaries\n", " secondaries = [protocol.strip('\\n') for protocol in pointer.readlines()]\n", " secondaries = [protocol for protocol in secondaries if 'X' in protocol]\n", " secondaries = [protocol.strip('X').strip() for protocol in secondaries]\n", "\n", "# print as list\n", "print('{} mosquito bundle protocols:'.format(len(secondaries)))\n", "secondaries" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Setting the Geographic Area" ] }, { "cell_type": "markdown", "metadata": { "hide_input": true }, "source": [ "Set latitude and longitude boundaries for the study area and click Apply." ] }, { "cell_type": "code", "execution_count": 111, "metadata": { "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "*** settings -----> ^ [code] (for settings: setting the latitude and longitude)\n" ] } ], "source": [ "designate('setting the latitude and longitude', 'settings')\n", "\n", "# set the latitude and longitude boundaries\n", "south = None\n", "north = None\n", "west = None\n", "east = None" ] }, { "cell_type": "code", "execution_count": 112, "metadata": { "hide_input": true }, "outputs": [ { "data": { "application/javascript": [ "IPython.notebook.execute_cell_range(27, 33)" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: button to apply rectangle)\n" ] }, { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "afd01f547ca0478381e1528568850f94", "version_major": 2, "version_minor": 0 }, "text/plain": [ "Button(description='Apply', style=ButtonStyle())" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "designate('button to apply rectangle')\n", "\n", "# function to retrieve all data\n", "def retrieve(_):\n", " \"\"\"Retrieve the data from the api.\n", " \n", " Arguments:\n", " None\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", "\n", " # refresh cells\n", " execute('### Setting the Geographic Area', '### Setting the Date Range')\n", " \n", " return None\n", "\n", "# create button\n", "button = Button(description=\"Apply\")\n", "button.on_click(retrieve)\n", "display(button)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Or use the pentagon tool or rectangle tool to draw a polygon on the map." ] }, { "cell_type": "code", "execution_count": 113, "metadata": { "hide_input": true, "scrolled": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: constructing map)\n", "constructing map...\n" ] }, { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "4e8fbb2183f54c41a0177e927cd0b82b", "version_major": 2, "version_minor": 0 }, "text/plain": [ "Map(center=[0, 0], controls=(ZoomControl(options=['position', 'zoom_in_text', 'zoom_in_title', 'zoom_out_text'…" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "designate('constructing map')\n", "\n", "# print status\n", "print('constructing map...')\n", "\n", "# set up map with topographical basemap\n", "chart = Map(basemap=basemaps.Esri.WorldTopoMap, center=(0, 0), zoom=3)\n", "\n", "# initiate draw control\n", "control = DrawControl()\n", "\n", "# specify polygon\n", "control.polygon = {'shapeOptions': {'fillColor': '#00ff00', 'color': '#ffffff', 'fillOpacity': 0.1}}\n", "control.polygon['shapeOptions'].update({'color': '#ffffff', 'weight': 4, 'opacity': 0.5, 'stroke': True})\n", "control.polygon['drawError'] = {'color': '#dd253b', 'message': 'Oops!'}\n", "control.polygon['allowIntersection'] = False\n", "\n", "# specify rectange marker\n", "control.rectangle = {'shapeOptions': {'fillColor': '#00ff00', 'color': '#ffffff', 'fillOpacity': 0.1}}\n", "control.rectangle['shapeOptions'].update({'color': '#ffffff', 'weight': 4, 'opacity': 0.5, 'stroke': True})\n", "\n", "# remove default polyline and circlemarker\n", "control.polyline = {}\n", "control.circlemarker = {}\n", "\n", "# specify clear function\n", "control.on_draw(rid)\n", "\n", "# add draw control\n", "chart.add_control(control)\n", "\n", "# force a rectange onto the map\n", "force(south, north, west, east)\n", "\n", "# display chart\n", "chart" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Setting the Date Range" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Set the date range below. Leaving the beginning date blank will default to Earth Day 1995. Leaving the ending date blank will default to today's date." ] }, { "cell_type": "code", "execution_count": 103, "metadata": { "hide_input": true, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "*** settings -----> ^ [code] (for settings: setting date range)\n" ] } ], "source": [ "designate('setting date range', 'settings')\n", "\n", "# set beginning and ending dates in 'YYYY-mm-dd' format, None for ending date defaults to now\n", "beginning = '2019-01-01'\n", "ending = '2020-01-01'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Retrieving the Data" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Press the Retrieve button believe to retrieve the data. A link will appear to a zip file below." ] }, { "cell_type": "code", "execution_count": 104, "metadata": { "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: resolving default dates)\n", "Summary of Mosquito Bundle Query at 18:07:19 on 2020-06-18:\n", "\n", "date range: 2019-01-01 to 2020-01-01\n", "\n", "polygon:\n", "\n", "[-20, 34]: \n", "[-20, 59]: \n", "[41, 59]: \n", "[41, 34]: Iraq\n", "[-20, 34]: \n" ] } ], "source": [ "designate('resolving default dates')\n", "\n", "# default beginning to 1995 and ending to current date if unspecified\n", "beginning = beginning or '1995-04-22'\n", "ending = ending or str(datetime.now().date())\n", "\n", "# begin summary\n", "today = datetime.now().date()\n", "clock = datetime.now().time().replace(microsecond=0)\n", "message = 'Summary of Mosquito Bundle Query at {} on {}:\\n'.format(clock, today)\n", "summary = [message]\n", "print(message)\n", "\n", "# print date range\n", "message = 'date range: {} to {}\\n'.format(beginning, ending)\n", "summary.append(message)\n", "print(message)\n", "\n", "# retrieve polygon from map\n", "message = 'polygon:\\n'\n", "polygon = surround(chart)\n", "summary.append(message)\n", "print(message)\n", "for pair in polygon:\n", "\n", " # print and add to summary\n", " country = locate(pair[0], pair[1])\n", " message = '{}: {}'.format(pair, country)\n", " summary.append(message + '\\n')\n", " print(message)" ] }, { "cell_type": "code", "execution_count": 105, "metadata": { "hide_input": true, "scrolled": true }, "outputs": [ { "data": { "application/javascript": [ "IPython.notebook.execute_cell_range(29, 38)" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: button to retrieve data)\n" ] }, { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "5e273540f61140c6a87afb0a237c81de", "version_major": 2, "version_minor": 0 }, "text/plain": [ "Button(description='Retrieve', style=ButtonStyle())" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "designate('button to retrieve data')\n", "\n", "# function to retrieve all data\n", "def retrieve(_):\n", " \"\"\"Retrieve the data from the api.\n", " \n", " Arguments:\n", " None\n", " \n", " Returns:\n", " None\n", " \"\"\"\n", "\n", " # refresh cells\n", " execute('### Setting the Date Range', '### Thanks!')\n", " \n", " return None\n", "\n", "# create button\n", "button = Button(description=\"Retrieve\")\n", "button.on_click(retrieve)\n", "display(button)" ] }, { "cell_type": "code", "execution_count": 106, "metadata": { "hide_input": true, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: collecting data)\n", "\n", "making request from mosquito_habitat_mapper...\n", "74 results returned from mosquito_habitat_mapper.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidmosquitohabitatmapperBreedingGroundEliminatedmosquitohabitatmapperExtraDatamosquitohabitatmapperAbdomenCloseupPhotoUrlsmosquitohabitatmapperMeasuredAtmosquitohabitatmapperMeasurementElevationmosquitohabitatmapperUseridmosquitohabitatmapperLarvaeCountmosquitohabitatmapperMosquitoEggsmosquitohabitatmapperMosquitoEggCountmosquitohabitatmapperGenusmosquitohabitatmapperWaterSourcemosquitohabitatmapperMosquitoAdultsmosquitohabitatmapperSpeciesmosquitohabitatmapperCommentsmosquitohabitatmapperMosquitoPupaemosquitohabitatmapperWaterSourcePhotoUrlsmosquitohabitatmapperDataSourcemosquitohabitatmapperLarvaFullBodyPhotoUrlsmosquitohabitatmapperMeasurementLatitudemosquitohabitatmapperLastIdentifyStagemosquitohabitatmapperWaterSourceTypemosquitohabitatmapperMosquitoHabitatMapperIdmosquitohabitatmapperMeasurementLongitude
0mosquito_habitat_mapper2019-04-082020-01-25T18:24:272020-01-25T18:24:272020-03-20T22:19:4831759627Osnovna škola Rugvica10478333TWL957671CroatiaHRV45.75083316.230409101.0159355552TrueNoneNone2019-04-08T15:10:000317591480FalseNoneNonedish or potTrueNoneNoneFalsehttps://data.globe.gov/system/photos/2019/04/0...GLOBE Observer AppNone45.7512Nonecontainer: artificial1050116.2314
1mosquito_habitat_mapper2019-04-162020-01-25T18:24:272020-01-25T18:24:272020-03-20T22:19:4817769359Croatia Citizen Science10769833TWL430385NoneNone45.49870615.550375111.5159355969TrueNoneNone2019-04-16T11:24:00049124038NoneNoneNoneNonetireNoneNoneNoneFalseNoneGLOBE Observer AppNone45.4990identifycontainer: artificial1171915.5516
2mosquito_habitat_mapper2019-04-162020-01-25T18:24:272020-01-25T18:24:272020-03-20T22:19:4817769359Croatia Citizen Science10769833TWL430385NoneNone45.49870615.550375111.5159355969FalseNoneNone2019-04-16T11:32:00049124038NoneNoneNoneNonetireNoneNoneNoneFalseNoneGLOBE Observer AppNone45.4992identifycontainer: artificial1172015.5515
3mosquito_habitat_mapper2019-02-282020-01-25T18:16:362020-01-25T18:16:362020-03-20T22:19:48107657OS prof. Franje Viktora Signjara11255433TXM542034CroatiaHRV46.06678216.993831132.6159354429FalseNoneNone2019-02-28T13:32:0003080584NoneNoneNoneNoneswamp or wetlandNoneNoneNoneFalseNoneGLOBE Observer AppNone46.0671identifystill: lake/pond/swamp804816.9951
4mosquito_habitat_mapper2019-04-112020-01-25T18:24:272020-01-25T18:24:272020-03-20T22:19:4817769359Croatia Citizen Science13079633TXH769545NoneNone42.92260817.16757317.6159355645TrueNoneNone2019-04-11T17:29:00054462226NoneNoneNoneNonecement, metal or plastic tankNoneNoneNoneFalseNoneGLOBE Observer AppNone42.9233identify-latercontainer: artificial1085517.1687
\n", "
" ], "text/plain": [ " protocol measuredDate createDate \\\n", "0 mosquito_habitat_mapper 2019-04-08 2020-01-25T18:24:27 \n", "1 mosquito_habitat_mapper 2019-04-16 2020-01-25T18:24:27 \n", "2 mosquito_habitat_mapper 2019-04-16 2020-01-25T18:24:27 \n", "3 mosquito_habitat_mapper 2019-02-28 2020-01-25T18:16:36 \n", "4 mosquito_habitat_mapper 2019-04-11 2020-01-25T18:24:27 \n", "\n", " updateDate publishDate organizationId \\\n", "0 2020-01-25T18:24:27 2020-03-20T22:19:48 31759627 \n", "1 2020-01-25T18:24:27 2020-03-20T22:19:48 17769359 \n", "2 2020-01-25T18:24:27 2020-03-20T22:19:48 17769359 \n", "3 2020-01-25T18:16:36 2020-03-20T22:19:48 107657 \n", "4 2020-01-25T18:24:27 2020-03-20T22:19:48 17769359 \n", "\n", " organizationName siteId siteName countryName \\\n", "0 Osnovna škola Rugvica 104783 33TWL957671 Croatia \n", "1 Croatia Citizen Science 107698 33TWL430385 None \n", "2 Croatia Citizen Science 107698 33TWL430385 None \n", "3 OS prof. Franje Viktora Signjara 112554 33TXM542034 Croatia \n", "4 Croatia Citizen Science 130796 33TXH769545 None \n", "\n", " countryCode latitude longitude elevation pid \\\n", "0 HRV 45.750833 16.230409 101.0 159355552 \n", "1 None 45.498706 15.550375 111.5 159355969 \n", "2 None 45.498706 15.550375 111.5 159355969 \n", "3 HRV 46.066782 16.993831 132.6 159354429 \n", "4 None 42.922608 17.167573 17.6 159355645 \n", "\n", " mosquitohabitatmapperBreedingGroundEliminated \\\n", "0 True \n", "1 True \n", "2 False \n", "3 False \n", "4 True \n", "\n", " mosquitohabitatmapperExtraData mosquitohabitatmapperAbdomenCloseupPhotoUrls \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " mosquitohabitatmapperMeasuredAt mosquitohabitatmapperMeasurementElevation \\\n", "0 2019-04-08T15:10:00 0 \n", "1 2019-04-16T11:24:00 0 \n", "2 2019-04-16T11:32:00 0 \n", "3 2019-02-28T13:32:00 0 \n", "4 2019-04-11T17:29:00 0 \n", "\n", " mosquitohabitatmapperUserid mosquitohabitatmapperLarvaeCount \\\n", "0 31759148 0 \n", "1 49124038 None \n", "2 49124038 None \n", "3 3080584 None \n", "4 54462226 None \n", "\n", " mosquitohabitatmapperMosquitoEggs mosquitohabitatmapperMosquitoEggCount \\\n", "0 False None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " mosquitohabitatmapperGenus mosquitohabitatmapperWaterSource \\\n", "0 None dish or pot \n", "1 None tire \n", "2 None tire \n", "3 None swamp or wetland \n", "4 None cement, metal or plastic tank \n", "\n", " mosquitohabitatmapperMosquitoAdults mosquitohabitatmapperSpecies \\\n", "0 True None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " mosquitohabitatmapperComments mosquitohabitatmapperMosquitoPupae \\\n", "0 None False \n", "1 None False \n", "2 None False \n", "3 None False \n", "4 None False \n", "\n", " mosquitohabitatmapperWaterSourcePhotoUrls \\\n", "0 https://data.globe.gov/system/photos/2019/04/0... \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " mosquitohabitatmapperDataSource mosquitohabitatmapperLarvaFullBodyPhotoUrls \\\n", "0 GLOBE Observer App None \n", "1 GLOBE Observer App None \n", "2 GLOBE Observer App None \n", "3 GLOBE Observer App None \n", "4 GLOBE Observer App None \n", "\n", " mosquitohabitatmapperMeasurementLatitude \\\n", "0 45.7512 \n", "1 45.4990 \n", "2 45.4992 \n", "3 46.0671 \n", "4 42.9233 \n", "\n", " mosquitohabitatmapperLastIdentifyStage mosquitohabitatmapperWaterSourceType \\\n", "0 None container: artificial \n", "1 identify container: artificial \n", "2 identify container: artificial \n", "3 identify still: lake/pond/swamp \n", "4 identify-later container: artificial \n", "\n", " mosquitohabitatmapperMosquitoHabitatMapperId \\\n", "0 10501 \n", "1 11719 \n", "2 11720 \n", "3 8048 \n", "4 10855 \n", "\n", " mosquitohabitatmapperMeasurementLongitude \n", "0 16.2314 \n", "1 15.5516 \n", "2 15.5515 \n", "3 16.9951 \n", "4 17.1687 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from air_temp_dailies...\n", "32974 results returned from air_temp_dailies.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidairtempdailiesSolarMeasuredAtairtempdailiesSolarNoonAtairtempdailiesCurrentTempairtempdailiesMeasuredAtairtempdailiesMaximumTempairtempdailiesMinimumTempairtempdailiesCommentsairtempdailiesUserid
0air_temp_dailies2019-01-012020-01-23T16:04:392020-01-23T16:04:392020-03-20T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01495062452019-01-01T11:35:002019-01-01T11:24:003.22019-01-01T11:00:004.82.9None2971264.0
1air_temp_dailies2019-01-022020-01-23T16:04:392020-01-23T16:04:392020-03-20T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01495062462019-01-02T11:34:002019-01-02T11:25:002.42019-01-02T11:00:005.41.3None2971264.0
2air_temp_dailies2019-01-032020-01-23T16:04:392020-01-23T16:04:392020-03-20T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01495062472019-01-03T11:34:002019-01-03T11:25:00-0.32019-01-03T11:00:002.8-2.5None2971264.0
3air_temp_dailies2019-01-042020-01-23T16:04:392020-01-23T16:04:392020-03-20T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01495062482019-01-04T11:33:002019-01-04T11:25:000.42019-01-04T11:00:000.5-2.0None2971264.0
4air_temp_dailies2019-01-052020-01-23T16:04:392020-01-23T16:04:392020-03-20T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01495062492019-01-05T11:33:002019-01-05T11:26:00-0.32019-01-05T11:00:001.4-0.3None2971264.0
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 air_temp_dailies 2019-01-01 2020-01-23T16:04:39 2020-01-23T16:04:39 \n", "1 air_temp_dailies 2019-01-02 2020-01-23T16:04:39 2020-01-23T16:04:39 \n", "2 air_temp_dailies 2019-01-03 2020-01-23T16:04:39 2020-01-23T16:04:39 \n", "3 air_temp_dailies 2019-01-04 2020-01-23T16:04:39 2020-01-23T16:04:39 \n", "4 air_temp_dailies 2019-01-05 2020-01-23T16:04:39 2020-01-23T16:04:39 \n", "\n", " publishDate organizationId \\\n", "0 2020-03-20T21:00:00 61017 \n", "1 2020-03-20T21:00:00 61017 \n", "2 2020-03-20T21:00:00 61017 \n", "3 2020-03-20T21:00:00 61017 \n", "4 2020-03-20T21:00:00 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid airtempdailiesSolarMeasuredAt \\\n", "0 403.0 149506245 2019-01-01T11:35:00 \n", "1 403.0 149506246 2019-01-02T11:34:00 \n", "2 403.0 149506247 2019-01-03T11:34:00 \n", "3 403.0 149506248 2019-01-04T11:33:00 \n", "4 403.0 149506249 2019-01-05T11:33:00 \n", "\n", " airtempdailiesSolarNoonAt airtempdailiesCurrentTemp \\\n", "0 2019-01-01T11:24:00 3.2 \n", "1 2019-01-02T11:25:00 2.4 \n", "2 2019-01-03T11:25:00 -0.3 \n", "3 2019-01-04T11:25:00 0.4 \n", "4 2019-01-05T11:26:00 -0.3 \n", "\n", " airtempdailiesMeasuredAt airtempdailiesMaximumTemp \\\n", "0 2019-01-01T11:00:00 4.8 \n", "1 2019-01-02T11:00:00 5.4 \n", "2 2019-01-03T11:00:00 2.8 \n", "3 2019-01-04T11:00:00 0.5 \n", "4 2019-01-05T11:00:00 1.4 \n", "\n", " airtempdailiesMinimumTemp airtempdailiesComments airtempdailiesUserid \n", "0 2.9 None 2971264.0 \n", "1 1.3 None 2971264.0 \n", "2 -2.5 None 2971264.0 \n", "3 -2.0 None 2971264.0 \n", "4 -0.3 None 2971264.0 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from air_temp_monthlies...\n", "1074 results returned from air_temp_monthlies.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidairtempmonthliesMaximumTempCairtempmonthliesAveragedMonthairtempmonthliesNumberOfObsairtempmonthliesNumberOfDaysReportedairtempmonthliesAverageTempCairtempmonthliesMinimumTempCairtempmonthliesUserid
0air_temp_monthlies2019-01-012019-01-27T00:50:012019-03-19T17:11:332020-02-17T21:10:1661017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0827221926.72019-01-0131310.9-7.02971264.0
1air_temp_monthlies2019-02-012019-03-02T00:50:012019-03-19T17:11:332020-02-17T21:10:1661017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.08290444615.12019-02-0128284.1-5.32971264.0
2air_temp_monthlies2019-03-012019-03-26T00:50:012019-04-04T00:50:012020-02-17T21:10:1661017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010546559619.72019-03-0131318.6-0.42971264.0
3air_temp_monthlies2019-04-012019-04-29T00:50:012019-05-04T00:50:012020-02-17T21:10:1661017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010564652225.42019-04-01303011.61.62971264.0
4air_temp_monthlies2019-05-012019-05-25T00:50:012019-06-08T00:50:012020-02-17T21:10:1661017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010572827923.32019-05-01313112.31.72971264.0
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 air_temp_monthlies 2019-01-01 2019-01-27T00:50:01 2019-03-19T17:11:33 \n", "1 air_temp_monthlies 2019-02-01 2019-03-02T00:50:01 2019-03-19T17:11:33 \n", "2 air_temp_monthlies 2019-03-01 2019-03-26T00:50:01 2019-04-04T00:50:01 \n", "3 air_temp_monthlies 2019-04-01 2019-04-29T00:50:01 2019-05-04T00:50:01 \n", "4 air_temp_monthlies 2019-05-01 2019-05-25T00:50:01 2019-06-08T00:50:01 \n", "\n", " publishDate organizationId \\\n", "0 2020-02-17T21:10:16 61017 \n", "1 2020-02-17T21:10:16 61017 \n", "2 2020-02-17T21:10:16 61017 \n", "3 2020-02-17T21:10:16 61017 \n", "4 2020-02-17T21:10:16 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid airtempmonthliesMaximumTempC \\\n", "0 403.0 82722192 6.7 \n", "1 403.0 82904446 15.1 \n", "2 403.0 105465596 19.7 \n", "3 403.0 105646522 25.4 \n", "4 403.0 105728279 23.3 \n", "\n", " airtempmonthliesAveragedMonth airtempmonthliesNumberOfObs \\\n", "0 2019-01-01 31 \n", "1 2019-02-01 28 \n", "2 2019-03-01 31 \n", "3 2019-04-01 30 \n", "4 2019-05-01 31 \n", "\n", " airtempmonthliesNumberOfDaysReported airtempmonthliesAverageTempC \\\n", "0 31 0.9 \n", "1 28 4.1 \n", "2 31 8.6 \n", "3 30 11.6 \n", "4 31 12.3 \n", "\n", " airtempmonthliesMinimumTempC airtempmonthliesUserid \n", "0 -7.0 2971264.0 \n", "1 -5.3 2971264.0 \n", "2 -0.4 2971264.0 \n", "3 1.6 2971264.0 \n", "4 1.7 2971264.0 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from air_temp_noons...\n", "40040 results returned from air_temp_noons.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidairtempnoonsUseridairtempnoonsMeasuredAtairtempnoonsCurrentTempCairtempnoonsSolarMeasuredAtairtempnoonsCommentsairtempnoonsSolarNoonAt
0air_temp_noons2019-01-012020-01-23T18:41:362020-01-23T18:41:362020-04-02T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.015224052729712642019-01-01T11:00:003.22019-01-01T11:35:00None2019-01-01T11:24:32
1air_temp_noons2019-01-022020-01-23T18:41:362020-01-23T18:41:362020-04-02T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.015224052829712642019-01-02T11:00:002.42019-01-02T11:34:00None2019-01-02T11:25:00
2air_temp_noons2019-01-032020-01-23T18:41:362020-01-23T18:41:362020-04-02T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.015224052929712642019-01-03T11:00:00-0.32019-01-03T11:34:00None2019-01-03T11:25:28
3air_temp_noons2019-01-042020-01-23T18:41:362020-01-23T18:41:362020-04-02T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.015224053029712642019-01-04T11:00:000.42019-01-04T11:33:00None2019-01-04T11:25:56
4air_temp_noons2019-01-052020-01-23T18:41:362020-01-23T18:41:362020-04-02T21:00:0061017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.015224053129712642019-01-05T11:00:00-0.32019-01-05T11:33:00None2019-01-05T11:26:23
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 air_temp_noons 2019-01-01 2020-01-23T18:41:36 2020-01-23T18:41:36 \n", "1 air_temp_noons 2019-01-02 2020-01-23T18:41:36 2020-01-23T18:41:36 \n", "2 air_temp_noons 2019-01-03 2020-01-23T18:41:36 2020-01-23T18:41:36 \n", "3 air_temp_noons 2019-01-04 2020-01-23T18:41:36 2020-01-23T18:41:36 \n", "4 air_temp_noons 2019-01-05 2020-01-23T18:41:36 2020-01-23T18:41:36 \n", "\n", " publishDate organizationId \\\n", "0 2020-04-02T21:00:00 61017 \n", "1 2020-04-02T21:00:00 61017 \n", "2 2020-04-02T21:00:00 61017 \n", "3 2020-04-02T21:00:00 61017 \n", "4 2020-04-02T21:00:00 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid airtempnoonsUserid airtempnoonsMeasuredAt \\\n", "0 403.0 152240527 2971264 2019-01-01T11:00:00 \n", "1 403.0 152240528 2971264 2019-01-02T11:00:00 \n", "2 403.0 152240529 2971264 2019-01-03T11:00:00 \n", "3 403.0 152240530 2971264 2019-01-04T11:00:00 \n", "4 403.0 152240531 2971264 2019-01-05T11:00:00 \n", "\n", " airtempnoonsCurrentTempC airtempnoonsSolarMeasuredAt airtempnoonsComments \\\n", "0 3.2 2019-01-01T11:35:00 None \n", "1 2.4 2019-01-02T11:34:00 None \n", "2 -0.3 2019-01-03T11:34:00 None \n", "3 0.4 2019-01-04T11:33:00 None \n", "4 -0.3 2019-01-05T11:33:00 None \n", "\n", " airtempnoonsSolarNoonAt \n", "0 2019-01-01T11:24:32 \n", "1 2019-01-02T11:25:00 \n", "2 2019-01-03T11:25:28 \n", "3 2019-01-04T11:25:56 \n", "4 2019-01-05T11:26:23 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from air_temps...\n", "0 results returned from air_temps.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
\n", "
" ], "text/plain": [ "Empty DataFrame\n", "Columns: []\n", "Index: []" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from conductivities...\n", "1131 results returned from conductivities.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidconductivitiesElectricalConductivityModelconductivitiesMeasuredAtconductivitiesCommentsconductivitiesUseridconductivitiesWaterBodyStateconductivitiesConductivityMicroSiemensPerCmconductivitiesElectricalConductivityMfg
0conductivities2019-01-072020-01-23T01:36:572020-01-23T01:36:572020-05-01T21:16:49192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.413886960414302019-01-07T11:05:00None2877088normal560.0None
1conductivities2019-01-082020-01-23T01:36:572020-01-23T01:36:572020-05-01T21:16:49192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.413886960214302019-01-08T11:05:00None2877088normal550.0None
2conductivities2019-01-142020-01-23T01:36:572020-01-23T01:36:572020-05-01T21:16:49192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.413886960114302019-01-14T11:05:00None2877088normal520.0None
3conductivities2019-01-152020-01-23T01:36:572020-01-23T01:36:572020-05-01T21:16:49192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.413886960314302019-01-15T11:05:00None2877088normal520.0None
4conductivities2019-01-172020-01-23T01:36:572020-01-23T01:36:572020-05-01T21:16:49192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.413886960514302019-01-17T11:05:00None2877088normal500.0None
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 conductivities 2019-01-07 2020-01-23T01:36:57 2020-01-23T01:36:57 \n", "1 conductivities 2019-01-08 2020-01-23T01:36:57 2020-01-23T01:36:57 \n", "2 conductivities 2019-01-14 2020-01-23T01:36:57 2020-01-23T01:36:57 \n", "3 conductivities 2019-01-15 2020-01-23T01:36:57 2020-01-23T01:36:57 \n", "4 conductivities 2019-01-17 2020-01-23T01:36:57 2020-01-23T01:36:57 \n", "\n", " publishDate organizationId organizationName \\\n", "0 2020-05-01T21:16:49 192076 Alexander von Humboldt Gymnasium \n", "1 2020-05-01T21:16:49 192076 Alexander von Humboldt Gymnasium \n", "2 2020-05-01T21:16:49 192076 Alexander von Humboldt Gymnasium \n", "3 2020-05-01T21:16:49 192076 Alexander von Humboldt Gymnasium \n", "4 2020-05-01T21:16:49 192076 Alexander von Humboldt Gymnasium \n", "\n", " siteId siteName countryName countryCode latitude \\\n", "0 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "1 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "2 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "3 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "4 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "\n", " longitude elevation pid conductivitiesElectricalConductivityModel \\\n", "0 9.1745 360.4 138869604 1430 \n", "1 9.1745 360.4 138869602 1430 \n", "2 9.1745 360.4 138869601 1430 \n", "3 9.1745 360.4 138869603 1430 \n", "4 9.1745 360.4 138869605 1430 \n", "\n", " conductivitiesMeasuredAt conductivitiesComments conductivitiesUserid \\\n", "0 2019-01-07T11:05:00 None 2877088 \n", "1 2019-01-08T11:05:00 None 2877088 \n", "2 2019-01-14T11:05:00 None 2877088 \n", "3 2019-01-15T11:05:00 None 2877088 \n", "4 2019-01-17T11:05:00 None 2877088 \n", "\n", " conductivitiesWaterBodyState conductivitiesConductivityMicroSiemensPerCm \\\n", "0 normal 560.0 \n", "1 normal 550.0 \n", "2 normal 520.0 \n", "3 normal 520.0 \n", "4 normal 500.0 \n", "\n", " conductivitiesElectricalConductivityMfg \n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from dissolved_oxygens...\n", "2065 results returned from dissolved_oxygens.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpiddissolvedoxygensCommentsdissolvedoxygensMeasuredAtdissolvedoxygensOxygenKitMfgdissolvedoxygensWaterBodyStatedissolvedoxygensSalinityViaDokitPptdissolvedoxygensOxygenKitModeldissolvedoxygensOxygenProbeModeldissolvedoxygensDissolvedOxygenViaKitMgldissolvedoxygensUseriddissolvedoxygensDissolvedOxygenViaProbeMgldissolvedoxygensOxygenProbeMfg
0dissolved_oxygens2019-01-072020-01-23T01:40:252020-01-23T01:40:252020-04-07T21:05:42192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4138970771None2019-01-07T11:05:00othernormalNaNNoneNone10.02877088NaNNone
1dissolved_oxygens2019-01-082020-01-23T01:40:252020-01-23T01:40:252020-04-07T21:05:42192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4138970772None2019-01-08T11:05:00othernormalNaNNoneNone10.02877088NaNNone
2dissolved_oxygens2019-01-092020-01-23T01:40:252020-01-23T01:40:252020-04-07T21:05:42192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4138970773None2019-01-09T11:05:00othernormalNaNNoneNone10.02877088NaNNone
3dissolved_oxygens2019-01-142020-01-23T01:40:252020-01-23T01:40:252020-04-07T21:05:42192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4138970774None2019-01-14T11:05:00othernormalNaNNoneNone10.02877088NaNNone
4dissolved_oxygens2019-01-152020-01-23T01:40:252020-01-23T01:40:252020-04-07T21:05:42192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4138970775None2019-01-15T11:05:00othernormalNaNNoneNone10.02877088NaNNone
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 dissolved_oxygens 2019-01-07 2020-01-23T01:40:25 2020-01-23T01:40:25 \n", "1 dissolved_oxygens 2019-01-08 2020-01-23T01:40:25 2020-01-23T01:40:25 \n", "2 dissolved_oxygens 2019-01-09 2020-01-23T01:40:25 2020-01-23T01:40:25 \n", "3 dissolved_oxygens 2019-01-14 2020-01-23T01:40:25 2020-01-23T01:40:25 \n", "4 dissolved_oxygens 2019-01-15 2020-01-23T01:40:25 2020-01-23T01:40:25 \n", "\n", " publishDate organizationId organizationName \\\n", "0 2020-04-07T21:05:42 192076 Alexander von Humboldt Gymnasium \n", "1 2020-04-07T21:05:42 192076 Alexander von Humboldt Gymnasium \n", "2 2020-04-07T21:05:42 192076 Alexander von Humboldt Gymnasium \n", "3 2020-04-07T21:05:42 192076 Alexander von Humboldt Gymnasium \n", "4 2020-04-07T21:05:42 192076 Alexander von Humboldt Gymnasium \n", "\n", " siteId siteName countryName countryCode latitude \\\n", "0 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "1 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "2 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "3 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "4 2334 Seerheinufer Konstanz AVH:SWS-01 Germany DEU 47.6683 \n", "\n", " longitude elevation pid dissolvedoxygensComments \\\n", "0 9.1745 360.4 138970771 None \n", "1 9.1745 360.4 138970772 None \n", "2 9.1745 360.4 138970773 None \n", "3 9.1745 360.4 138970774 None \n", "4 9.1745 360.4 138970775 None \n", "\n", " dissolvedoxygensMeasuredAt dissolvedoxygensOxygenKitMfg \\\n", "0 2019-01-07T11:05:00 other \n", "1 2019-01-08T11:05:00 other \n", "2 2019-01-09T11:05:00 other \n", "3 2019-01-14T11:05:00 other \n", "4 2019-01-15T11:05:00 other \n", "\n", " dissolvedoxygensWaterBodyState dissolvedoxygensSalinityViaDokitPpt \\\n", "0 normal NaN \n", "1 normal NaN \n", "2 normal NaN \n", "3 normal NaN \n", "4 normal NaN \n", "\n", " dissolvedoxygensOxygenKitModel dissolvedoxygensOxygenProbeModel \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " dissolvedoxygensDissolvedOxygenViaKitMgl dissolvedoxygensUserid \\\n", "0 10.0 2877088 \n", "1 10.0 2877088 \n", "2 10.0 2877088 \n", "3 10.0 2877088 \n", "4 10.0 2877088 \n", "\n", " dissolvedoxygensDissolvedOxygenViaProbeMgl dissolvedoxygensOxygenProbeMfg \n", "0 NaN None \n", "1 NaN None \n", "2 NaN None \n", "3 NaN None \n", "4 NaN None " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from freshwater_macroinvertebrates...\n", "58 results returned from freshwater_macroinvertebrates.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidfreshwatermacroinvertebratesCommentsfreshwatermacroinvertebratesTaxonomicRankLevelTwoAbovefreshwatermacroinvertebratesSeasonfreshwatermacroinvertebratesNumberOfCollectionSamplesfreshwatermacroinvertebratesNumberOfOrganismsInTaxonfreshwatermacroinvertebratesMeasuredOnfreshwatermacroinvertebratesAreaPercentfreshwatermacroinvertebratesTaxonLatinNameLevelOneAbovefreshwatermacroinvertebratesHabitatTypefreshwatermacroinvertebratesTaxonLatinNamefreshwatermacroinvertebratesUseridfreshwatermacroinvertebratesYearfreshwatermacroinvertebratesTaxonLatinNameLevelTwoAbovefreshwatermacroinvertebratesTaxonomicRankfreshwatermacroinvertebratesTaxonomicRankLevelOneAbovefreshwatermacroinvertebratesIsSubsampledfreshwatermacroinvertebratesNumberOfTaxaReportedForHabitatType
0freshwater_macroinvertebrates2019-03-072020-01-23T01:46:382020-01-23T01:46:382020-02-03T18:14:56224800OS Ivane Brlic Mazuranic6182Martinova postaja:SWS-01CroatiaHRV45.8338617.3788773.7138978842Noneclassspring2032019-03-07T00:00:0030.0Trichopteravegetated banksOdontoceridae31510112019InsectafamilyorderFalse6
1freshwater_macroinvertebrates2019-03-072020-01-23T01:46:382020-01-23T01:46:382020-02-03T18:14:56224800OS Ivane Brlic Mazuranic6182Martinova postaja:SWS-01CroatiaHRV45.8338617.3788773.7138978842Noneclassspring20102019-03-07T00:00:0030.0Dipteravegetated banksCulicidae31510112019InsectafamilyorderFalse6
2freshwater_macroinvertebrates2019-03-072020-01-23T01:46:382020-01-23T01:46:382020-02-03T18:14:56224800OS Ivane Brlic Mazuranic6182Martinova postaja:SWS-01CroatiaHRV45.8338617.3788773.7138978842NoneNonespring2032019-03-07T00:00:0030.0Molluscavegetated banksBivalvia31510112019NoneclassphylumFalse6
3freshwater_macroinvertebrates2019-03-072020-01-23T01:46:382020-01-23T01:46:382020-02-03T18:14:56224800OS Ivane Brlic Mazuranic6182Martinova postaja:SWS-01CroatiaHRV45.8338617.3788773.7138978842NoneNonespring2032019-03-07T00:00:0030.0Annelidavegetated banksOligochaeta31510112019NoneclassphylumFalse6
4freshwater_macroinvertebrates2019-03-072020-01-23T01:46:382020-01-23T01:46:382020-02-03T18:14:56224800OS Ivane Brlic Mazuranic6182Martinova postaja:SWS-01CroatiaHRV45.8338617.3788773.7138978842Nonephylumspring20302019-03-07T00:00:0030.0Malacostracavegetated banksAmphipoda31510112019ArthropodaorderclassFalse6
\n", "
" ], "text/plain": [ " protocol measuredDate createDate \\\n", "0 freshwater_macroinvertebrates 2019-03-07 2020-01-23T01:46:38 \n", "1 freshwater_macroinvertebrates 2019-03-07 2020-01-23T01:46:38 \n", "2 freshwater_macroinvertebrates 2019-03-07 2020-01-23T01:46:38 \n", "3 freshwater_macroinvertebrates 2019-03-07 2020-01-23T01:46:38 \n", "4 freshwater_macroinvertebrates 2019-03-07 2020-01-23T01:46:38 \n", "\n", " updateDate publishDate organizationId \\\n", "0 2020-01-23T01:46:38 2020-02-03T18:14:56 224800 \n", "1 2020-01-23T01:46:38 2020-02-03T18:14:56 224800 \n", "2 2020-01-23T01:46:38 2020-02-03T18:14:56 224800 \n", "3 2020-01-23T01:46:38 2020-02-03T18:14:56 224800 \n", "4 2020-01-23T01:46:38 2020-02-03T18:14:56 224800 \n", "\n", " organizationName siteId siteName countryName \\\n", "0 OS Ivane Brlic Mazuranic 6182 Martinova postaja:SWS-01 Croatia \n", "1 OS Ivane Brlic Mazuranic 6182 Martinova postaja:SWS-01 Croatia \n", "2 OS Ivane Brlic Mazuranic 6182 Martinova postaja:SWS-01 Croatia \n", "3 OS Ivane Brlic Mazuranic 6182 Martinova postaja:SWS-01 Croatia \n", "4 OS Ivane Brlic Mazuranic 6182 Martinova postaja:SWS-01 Croatia \n", "\n", " countryCode latitude longitude elevation pid \\\n", "0 HRV 45.83386 17.37887 73.7 138978842 \n", "1 HRV 45.83386 17.37887 73.7 138978842 \n", "2 HRV 45.83386 17.37887 73.7 138978842 \n", "3 HRV 45.83386 17.37887 73.7 138978842 \n", "4 HRV 45.83386 17.37887 73.7 138978842 \n", "\n", " freshwatermacroinvertebratesComments \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " freshwatermacroinvertebratesTaxonomicRankLevelTwoAbove \\\n", "0 class \n", "1 class \n", "2 None \n", "3 None \n", "4 phylum \n", "\n", " freshwatermacroinvertebratesSeason \\\n", "0 spring \n", "1 spring \n", "2 spring \n", "3 spring \n", "4 spring \n", "\n", " freshwatermacroinvertebratesNumberOfCollectionSamples \\\n", "0 20 \n", "1 20 \n", "2 20 \n", "3 20 \n", "4 20 \n", "\n", " freshwatermacroinvertebratesNumberOfOrganismsInTaxon \\\n", "0 3 \n", "1 10 \n", "2 3 \n", "3 3 \n", "4 30 \n", "\n", " freshwatermacroinvertebratesMeasuredOn \\\n", "0 2019-03-07T00:00:00 \n", "1 2019-03-07T00:00:00 \n", "2 2019-03-07T00:00:00 \n", "3 2019-03-07T00:00:00 \n", "4 2019-03-07T00:00:00 \n", "\n", " freshwatermacroinvertebratesAreaPercent \\\n", "0 30.0 \n", "1 30.0 \n", "2 30.0 \n", "3 30.0 \n", "4 30.0 \n", "\n", " freshwatermacroinvertebratesTaxonLatinNameLevelOneAbove \\\n", "0 Trichoptera \n", "1 Diptera \n", "2 Mollusca \n", "3 Annelida \n", "4 Malacostraca \n", "\n", " freshwatermacroinvertebratesHabitatType \\\n", "0 vegetated banks \n", "1 vegetated banks \n", "2 vegetated banks \n", "3 vegetated banks \n", "4 vegetated banks \n", "\n", " freshwatermacroinvertebratesTaxonLatinName \\\n", "0 Odontoceridae \n", "1 Culicidae \n", "2 Bivalvia \n", "3 Oligochaeta \n", "4 Amphipoda \n", "\n", " freshwatermacroinvertebratesUserid freshwatermacroinvertebratesYear \\\n", "0 3151011 2019 \n", "1 3151011 2019 \n", "2 3151011 2019 \n", "3 3151011 2019 \n", "4 3151011 2019 \n", "\n", " freshwatermacroinvertebratesTaxonLatinNameLevelTwoAbove \\\n", "0 Insecta \n", "1 Insecta \n", "2 None \n", "3 None \n", "4 Arthropoda \n", "\n", " freshwatermacroinvertebratesTaxonomicRank \\\n", "0 family \n", "1 family \n", "2 class \n", "3 class \n", "4 order \n", "\n", " freshwatermacroinvertebratesTaxonomicRankLevelOneAbove \\\n", "0 order \n", "1 order \n", "2 phylum \n", "3 phylum \n", "4 class \n", "\n", " freshwatermacroinvertebratesIsSubsampled \\\n", "0 False \n", "1 False \n", "2 False \n", "3 False \n", "4 False \n", "\n", " freshwatermacroinvertebratesNumberOfTaxaReportedForHabitatType \n", "0 6 \n", "1 6 \n", "2 6 \n", "3 6 \n", "4 6 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from humidities...\n", "0 results returned from humidities.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
\n", "
" ], "text/plain": [ "Empty DataFrame\n", "Columns: []\n", "Index: []" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from humidity_monthlies...\n", "1049 results returned from humidity_monthlies.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidhumiditymonthliesMinRelativeHumidityPercenthumiditymonthliesMaximumDewpointChumiditymonthliesAveragedMonthhumiditymonthliesMinimumDewpointChumiditymonthliesMaxRelativeHumidityPercenthumiditymonthliesNumberOfObshumiditymonthliesAverageRelativeHumidityPercenthumiditymonthliesNumberOfDaysReportedhumiditymonthliesAverageDewpointChumiditymonthliesUserid
0humidity_monthlies2019-01-012019-01-27T00:50:202019-03-19T17:11:592020-02-17T22:06:5461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.08272220665.02.62019-01-01-6.195.03082.830-1.32971264
1humidity_monthlies2019-02-012019-03-02T00:50:202019-03-19T17:11:592020-02-17T22:06:5461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.08290446755.06.72019-02-01-3.894.02877.6281.82971264
2humidity_monthlies2019-03-012019-03-26T00:50:222019-04-04T00:50:222020-02-17T22:06:5461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010546560748.011.12019-03-01-4.787.03170.0314.62971264
3humidity_monthlies2019-04-012019-04-29T00:50:222019-05-04T00:50:222020-02-17T22:06:5461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010564652831.09.52019-04-012.590.03066.9306.12971264
4humidity_monthlies2019-05-012019-05-25T00:50:202019-06-08T00:50:242020-02-17T22:06:5461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010572828837.013.22019-05-01-0.695.03071.7308.62971264
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 humidity_monthlies 2019-01-01 2019-01-27T00:50:20 2019-03-19T17:11:59 \n", "1 humidity_monthlies 2019-02-01 2019-03-02T00:50:20 2019-03-19T17:11:59 \n", "2 humidity_monthlies 2019-03-01 2019-03-26T00:50:22 2019-04-04T00:50:22 \n", "3 humidity_monthlies 2019-04-01 2019-04-29T00:50:22 2019-05-04T00:50:22 \n", "4 humidity_monthlies 2019-05-01 2019-05-25T00:50:20 2019-06-08T00:50:24 \n", "\n", " publishDate organizationId \\\n", "0 2020-02-17T22:06:54 61017 \n", "1 2020-02-17T22:06:54 61017 \n", "2 2020-02-17T22:06:54 61017 \n", "3 2020-02-17T22:06:54 61017 \n", "4 2020-02-17T22:06:54 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid humiditymonthliesMinRelativeHumidityPercent \\\n", "0 403.0 82722206 65.0 \n", "1 403.0 82904467 55.0 \n", "2 403.0 105465607 48.0 \n", "3 403.0 105646528 31.0 \n", "4 403.0 105728288 37.0 \n", "\n", " humiditymonthliesMaximumDewpointC humiditymonthliesAveragedMonth \\\n", "0 2.6 2019-01-01 \n", "1 6.7 2019-02-01 \n", "2 11.1 2019-03-01 \n", "3 9.5 2019-04-01 \n", "4 13.2 2019-05-01 \n", "\n", " humiditymonthliesMinimumDewpointC \\\n", "0 -6.1 \n", "1 -3.8 \n", "2 -4.7 \n", "3 2.5 \n", "4 -0.6 \n", "\n", " humiditymonthliesMaxRelativeHumidityPercent humiditymonthliesNumberOfObs \\\n", "0 95.0 30 \n", "1 94.0 28 \n", "2 87.0 31 \n", "3 90.0 30 \n", "4 95.0 30 \n", "\n", " humiditymonthliesAverageRelativeHumidityPercent \\\n", "0 82.8 \n", "1 77.6 \n", "2 70.0 \n", "3 66.9 \n", "4 71.7 \n", "\n", " humiditymonthliesNumberOfDaysReported humiditymonthliesAverageDewpointC \\\n", "0 30 -1.3 \n", "1 28 1.8 \n", "2 31 4.6 \n", "3 30 6.1 \n", "4 30 8.6 \n", "\n", " humiditymonthliesUserid \n", "0 2971264 \n", "1 2971264 \n", "2 2971264 \n", "3 2971264 \n", "4 2971264 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from humidity_noons...\n", "30924 results returned from humidity_noons.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidhumiditynoonsMeasuredAthumiditynoonsCommentshumiditynoonsUseridhumiditynoonsDewpointhumiditynoonsHumidityMethodhumiditynoonsSolarNoonAthumiditynoonsRelativeHumidityPercenthumiditynoonsSolarMeasuredAt
0humidity_noons2019-01-012020-01-23T07:20:372020-01-23T07:20:372020-03-25T21:57:2461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01424121682019-01-01T11:00:00None29712642.3digital hygrometer2019-01-01T11:24:0094.02019-01-01T11:35:00
1humidity_noons2019-01-022020-01-23T07:20:372020-01-23T07:20:372020-03-25T21:57:2461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01424121692019-01-02T11:00:00None29712641.1digital hygrometer2019-01-02T11:25:0091.02019-01-02T11:34:00
2humidity_noons2019-01-032020-01-23T07:20:372020-01-23T07:20:372020-03-25T21:57:2461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01424121702019-01-03T11:00:00None2971264-2.8digital hygrometer2019-01-03T11:25:0083.02019-01-03T11:34:00
3humidity_noons2019-01-042020-01-23T07:20:372020-01-23T07:20:372020-03-25T21:57:2461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01424121712019-01-04T11:00:00None2971264-2.1digital hygrometer2019-01-04T11:25:0083.02019-01-04T11:33:00
4humidity_noons2019-01-052020-01-23T07:20:372020-01-23T07:20:372020-03-25T21:57:2461017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.01424121722019-01-05T11:00:00None2971264-1.6digital hygrometer2019-01-05T11:26:0091.02019-01-05T11:33:00
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 humidity_noons 2019-01-01 2020-01-23T07:20:37 2020-01-23T07:20:37 \n", "1 humidity_noons 2019-01-02 2020-01-23T07:20:37 2020-01-23T07:20:37 \n", "2 humidity_noons 2019-01-03 2020-01-23T07:20:37 2020-01-23T07:20:37 \n", "3 humidity_noons 2019-01-04 2020-01-23T07:20:37 2020-01-23T07:20:37 \n", "4 humidity_noons 2019-01-05 2020-01-23T07:20:37 2020-01-23T07:20:37 \n", "\n", " publishDate organizationId \\\n", "0 2020-03-25T21:57:24 61017 \n", "1 2020-03-25T21:57:24 61017 \n", "2 2020-03-25T21:57:24 61017 \n", "3 2020-03-25T21:57:24 61017 \n", "4 2020-03-25T21:57:24 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid humiditynoonsMeasuredAt humiditynoonsComments \\\n", "0 403.0 142412168 2019-01-01T11:00:00 None \n", "1 403.0 142412169 2019-01-02T11:00:00 None \n", "2 403.0 142412170 2019-01-03T11:00:00 None \n", "3 403.0 142412171 2019-01-04T11:00:00 None \n", "4 403.0 142412172 2019-01-05T11:00:00 None \n", "\n", " humiditynoonsUserid humiditynoonsDewpoint humiditynoonsHumidityMethod \\\n", "0 2971264 2.3 digital hygrometer \n", "1 2971264 1.1 digital hygrometer \n", "2 2971264 -2.8 digital hygrometer \n", "3 2971264 -2.1 digital hygrometer \n", "4 2971264 -1.6 digital hygrometer \n", "\n", " humiditynoonsSolarNoonAt humiditynoonsRelativeHumidityPercent \\\n", "0 2019-01-01T11:24:00 94.0 \n", "1 2019-01-02T11:25:00 91.0 \n", "2 2019-01-03T11:25:00 83.0 \n", "3 2019-01-04T11:25:00 83.0 \n", "4 2019-01-05T11:26:00 91.0 \n", "\n", " humiditynoonsSolarMeasuredAt \n", "0 2019-01-01T11:35:00 \n", "1 2019-01-02T11:34:00 \n", "2 2019-01-03T11:34:00 \n", "3 2019-01-04T11:33:00 \n", "4 2019-01-05T11:33:00 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from hydrology_alkalinities...\n", "1283 results returned from hydrology_alkalinities.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidhydrologyalkalinitiesAlkalinityKitMfghydrologyalkalinitiesUseridhydrologyalkalinitiesDropsAlkalinityKitModelhydrologyalkalinitiesMeasuredAthydrologyalkalinitiesDropsAlkalinityKitMfghydrologyalkalinitiesAlkalinityViaDirectMglhydrologyalkalinitiesWaterBodyStatehydrologyalkalinitiesAlkalinityViaDropMglhydrologyalkalinitiesAlkalinityKitModelhydrologyalkalinitiesComments
0hydrology_alkalinities2019-01-072020-01-23T01:52:252020-01-23T01:52:252020-03-09T21:00:10192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4139107213other2877088None2019-01-07T11:05:00None161.0normalNaNNoneNone
1hydrology_alkalinities2019-01-082020-01-23T01:52:252020-01-23T01:52:252020-03-09T21:00:10192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4139107214other2877088None2019-01-08T11:05:00None178.0normalNaNNoneNone
2hydrology_alkalinities2019-01-092020-01-23T01:52:252020-01-23T01:52:252020-03-09T21:00:10192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4139107215other2877088None2019-01-09T11:05:00None161.0normalNaNNoneNone
3hydrology_alkalinities2019-01-142020-01-23T01:52:252020-01-23T01:52:252020-03-09T21:00:10192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4139107216other2877088None2019-01-14T11:05:00None161.0normalNaNNoneNone
4hydrology_alkalinities2019-01-152020-01-23T01:52:252020-01-23T01:52:252020-03-09T21:00:10192076Alexander von Humboldt Gymnasium2334Seerheinufer Konstanz AVH:SWS-01GermanyDEU47.66839.1745360.4139107217other2877088None2019-01-15T11:05:00None178.0normalNaNNoneNone
\n", "
" ], "text/plain": [ " protocol measuredDate createDate \\\n", "0 hydrology_alkalinities 2019-01-07 2020-01-23T01:52:25 \n", "1 hydrology_alkalinities 2019-01-08 2020-01-23T01:52:25 \n", "2 hydrology_alkalinities 2019-01-09 2020-01-23T01:52:25 \n", "3 hydrology_alkalinities 2019-01-14 2020-01-23T01:52:25 \n", "4 hydrology_alkalinities 2019-01-15 2020-01-23T01:52:25 \n", "\n", " updateDate publishDate organizationId \\\n", "0 2020-01-23T01:52:25 2020-03-09T21:00:10 192076 \n", "1 2020-01-23T01:52:25 2020-03-09T21:00:10 192076 \n", "2 2020-01-23T01:52:25 2020-03-09T21:00:10 192076 \n", "3 2020-01-23T01:52:25 2020-03-09T21:00:10 192076 \n", "4 2020-01-23T01:52:25 2020-03-09T21:00:10 192076 \n", "\n", " organizationName siteId siteName \\\n", "0 Alexander von Humboldt Gymnasium 2334 Seerheinufer Konstanz AVH:SWS-01 \n", "1 Alexander von Humboldt Gymnasium 2334 Seerheinufer Konstanz AVH:SWS-01 \n", "2 Alexander von Humboldt Gymnasium 2334 Seerheinufer Konstanz AVH:SWS-01 \n", "3 Alexander von Humboldt Gymnasium 2334 Seerheinufer Konstanz AVH:SWS-01 \n", "4 Alexander von Humboldt Gymnasium 2334 Seerheinufer Konstanz AVH:SWS-01 \n", "\n", " countryName countryCode latitude longitude elevation pid \\\n", "0 Germany DEU 47.6683 9.1745 360.4 139107213 \n", "1 Germany DEU 47.6683 9.1745 360.4 139107214 \n", "2 Germany DEU 47.6683 9.1745 360.4 139107215 \n", "3 Germany DEU 47.6683 9.1745 360.4 139107216 \n", "4 Germany DEU 47.6683 9.1745 360.4 139107217 \n", "\n", " hydrologyalkalinitiesAlkalinityKitMfg hydrologyalkalinitiesUserid \\\n", "0 other 2877088 \n", "1 other 2877088 \n", "2 other 2877088 \n", "3 other 2877088 \n", "4 other 2877088 \n", "\n", " hydrologyalkalinitiesDropsAlkalinityKitModel \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " hydrologyalkalinitiesMeasuredAt hydrologyalkalinitiesDropsAlkalinityKitMfg \\\n", "0 2019-01-07T11:05:00 None \n", "1 2019-01-08T11:05:00 None \n", "2 2019-01-09T11:05:00 None \n", "3 2019-01-14T11:05:00 None \n", "4 2019-01-15T11:05:00 None \n", "\n", " hydrologyalkalinitiesAlkalinityViaDirectMgl \\\n", "0 161.0 \n", "1 178.0 \n", "2 161.0 \n", "3 161.0 \n", "4 178.0 \n", "\n", " hydrologyalkalinitiesWaterBodyState \\\n", "0 normal \n", "1 normal \n", "2 normal \n", "3 normal \n", "4 normal \n", "\n", " hydrologyalkalinitiesAlkalinityViaDropMgl \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "\n", " hydrologyalkalinitiesAlkalinityKitModel hydrologyalkalinitiesComments \n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from hydrology_phs...\n", "3048 results returned from hydrology_phs.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidhydrologyphsPhBuffer10hydrologyphsMeasuredAthydrologyphsPhBuffer4hydrologyphsPhBuffer7hydrologyphsPhMeterModelhydrologyphsUseridhydrologyphsPhhydrologyphsPhMethodhydrologyphsPhMeterMfghydrologyphsWaterBodyStatehydrologyphsComments
0hydrology_phs2019-01-062020-01-23T04:03:422020-01-23T04:03:422020-04-07T21:06:02103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0140764632False2019-01-06T08:00:00FalseFalseNone30815886.0meterNonenormalNone
1hydrology_phs2019-01-132020-01-23T04:03:422020-01-23T04:03:422020-04-07T21:06:02103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0140764634False2019-01-13T08:00:00FalseFalseNone30815885.0meterNonenormalNone
2hydrology_phs2019-01-212020-01-23T04:03:422020-01-23T04:03:422020-04-07T21:06:02103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0140764631False2019-01-21T08:00:00FalseFalseNone30815885.0meterNonenormalNone
3hydrology_phs2019-01-272020-01-23T04:03:422020-01-23T04:03:422020-04-07T21:06:02103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0140764633False2019-01-27T08:00:00FalseFalseNone30815885.0meterNonenormalNone
4hydrology_phs2019-02-032020-01-23T04:03:442020-01-23T04:03:442020-04-07T21:06:02103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0140765508False2019-02-03T08:00:00FalseFalseNone30815885.5paperNonenormalNone
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 hydrology_phs 2019-01-06 2020-01-23T04:03:42 2020-01-23T04:03:42 \n", "1 hydrology_phs 2019-01-13 2020-01-23T04:03:42 2020-01-23T04:03:42 \n", "2 hydrology_phs 2019-01-21 2020-01-23T04:03:42 2020-01-23T04:03:42 \n", "3 hydrology_phs 2019-01-27 2020-01-23T04:03:42 2020-01-23T04:03:42 \n", "4 hydrology_phs 2019-02-03 2020-01-23T04:03:44 2020-01-23T04:03:44 \n", "\n", " publishDate organizationId organizationName siteId \\\n", "0 2020-04-07T21:06:02 103048 ZS Bystrice nad Pernstejnem 1960 \n", "1 2020-04-07T21:06:02 103048 ZS Bystrice nad Pernstejnem 1960 \n", "2 2020-04-07T21:06:02 103048 ZS Bystrice nad Pernstejnem 1960 \n", "3 2020-04-07T21:06:02 103048 ZS Bystrice nad Pernstejnem 1960 \n", "4 2020-04-07T21:06:02 103048 ZS Bystrice nad Pernstejnem 1960 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "1 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "2 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "3 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "4 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "\n", " elevation pid hydrologyphsPhBuffer10 hydrologyphsMeasuredAt \\\n", "0 570.0 140764632 False 2019-01-06T08:00:00 \n", "1 570.0 140764634 False 2019-01-13T08:00:00 \n", "2 570.0 140764631 False 2019-01-21T08:00:00 \n", "3 570.0 140764633 False 2019-01-27T08:00:00 \n", "4 570.0 140765508 False 2019-02-03T08:00:00 \n", "\n", " hydrologyphsPhBuffer4 hydrologyphsPhBuffer7 hydrologyphsPhMeterModel \\\n", "0 False False None \n", "1 False False None \n", "2 False False None \n", "3 False False None \n", "4 False False None \n", "\n", " hydrologyphsUserid hydrologyphsPh hydrologyphsPhMethod \\\n", "0 3081588 6.0 meter \n", "1 3081588 5.0 meter \n", "2 3081588 5.0 meter \n", "3 3081588 5.0 meter \n", "4 3081588 5.5 paper \n", "\n", " hydrologyphsPhMeterMfg hydrologyphsWaterBodyState hydrologyphsComments \n", "0 None normal None \n", "1 None normal None \n", "2 None normal None \n", "3 None normal None \n", "4 None normal None " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from land_covers...\n", "1216 results returned from land_covers.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidlandcoversDownwardPhotoUrllandcoversEastExtraDatalandcoversEastPhotoUrllandcoversMucCodelandcoversUpwardPhotoUrllandcoversEastCaptionlandcoversWestClassificationslandcoversNorthCaptionlandcoversNorthExtraDatalandcoversDataSourcelandcoversDryGroundlandcoversSouthClassificationslandcoversWestCaptionlandcoversNorthPhotoUrllandcoversUpwardCaptionlandcoversDownwardExtraDatalandcoversEastClassificationslandcoversMucDetailslandcoversMeasuredAtlandcoversDownwardCaptionlandcoversSouthPhotoUrllandcoversMuddylandcoversWestPhotoUrllandcoversStandingWaterlandcoversLeavesOnTreeslandcoversUseridlandcoversSouthExtraDatalandcoversSouthCaptionlandcoversRainingSnowinglandcoversUpwardExtraDatalandcoversWestExtraDatalandcoversLandCoverIdlandcoversMucDescriptionlandcoversSnowIcelandcoversNorthClassificationslandcoversFieldNoteslandcoversMeasurementLatitudelandcoversMeasurementElevationlandcoversMeasurementLongitude
0land_covers2019-05-142020-01-25T17:32:002020-01-25T17:32:002020-05-11T21:05:49236592OS Valentin Klarin5031HRAST CRNIKACroatiaHRV44.0820015.17860031.0159342917NoneNoneNoneM0112NoneNoneNoneNoneNoneGLOBE Data Entry Site DefinitionNoneNoneNoneNoneNoneNoneNoneNone2019-05-14T12:15:49.295325NoneNoneNoneNoneNoneNoneNaNNoneNoneNoneNoneNone23382Closed Forest, Mainly Evergreen, Tropical Wet ...NoneNoneit is submontaneNaNNaNNaN
1land_covers2019-03-152020-01-25T17:31:392020-01-25T17:31:392020-05-11T21:05:49193099Srednja skola Petrinja5229Lovro:GRN-01CroatiaHRV45.4419016.28010061.0159341778NoneNoneNoneM821NoneNoneNoneNoneNoneGLOBE Data Entry Site DefinitionNoneNoneNoneNoneNoneNoneNoneNone2019-03-15T09:17:21.465512NoneNoneNoneNoneNoneNoneNaNNoneNoneNoneNoneNone21005Cultivated Land, Non-Agriculture, Parks and At...NoneNoneNoneNaNNaNNaN
2land_covers2019-03-152020-01-25T17:31:392020-01-25T17:31:392020-05-11T21:05:4988451XV. Gimnazija5461Biometrija ŠkolaCroatiaHRV45.8190716.006884119.2159341779NoneNoneNoneM91NoneNoneNoneNoneNoneGLOBE Data Entry Site DefinitionNoneNoneNoneNoneNoneNoneNoneNone2019-03-15T10:20:57.849497NoneNoneNoneNoneNoneNoneNaNNoneNoneNoneNoneNone21007Urban, ResidentialNoneNoneUrban, Residential :: THE SIDE IS BACKYARD OF ...NaNNaNNaN
3land_covers2019-06-212020-01-25T17:32:082020-01-25T17:32:082020-05-11T21:05:49290789OS Ljubo Babic5648skolski vrt:LCS-01CroatiaHRV45.6652515.64731076.8159343716NoneNoneNoneM821NoneNoneNoneNoneNoneGLOBE Data Entry Site DefinitionNoneNoneNoneNoneNoneNoneNoneNone2019-06-21T07:26:38.7145NoneNoneNoneNoneNoneNoneNaNNoneNoneNoneNoneNone24508Cultivated Land, Non-Agriculture, Parks and At...NoneNoneWe want to aviod ?, #269NaNNaNNaN
4land_covers2019-01-312020-01-25T17:31:302020-01-25T17:31:302020-05-11T21:05:49188930OS Dubovac6006KOZJACA - SUMA:LCS-01CroatiaHRV45.4869015.53350069.7159341230NoneNoneNoneM1123https://data.globe.gov/system/photos/2018/06/0...NoneNoneNoneNoneGLOBE Data Entry Site DefinitionNoneNoneNoneNoneNoneNoneNoneNone2019-01-31T18:39:22.879692NoneNoneNoneNoneNoneNoneNaNNoneNoneNonenullNone20851Woodland, Mainly Evergreen, Needle-Leaved, Cyl...NoneNone:: FOREST IN KARLOVAC, CROATIA. DECIDOUS FOREST.NaNNaNNaN
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 land_covers 2019-05-14 2020-01-25T17:32:00 2020-01-25T17:32:00 \n", "1 land_covers 2019-03-15 2020-01-25T17:31:39 2020-01-25T17:31:39 \n", "2 land_covers 2019-03-15 2020-01-25T17:31:39 2020-01-25T17:31:39 \n", "3 land_covers 2019-06-21 2020-01-25T17:32:08 2020-01-25T17:32:08 \n", "4 land_covers 2019-01-31 2020-01-25T17:31:30 2020-01-25T17:31:30 \n", "\n", " publishDate organizationId organizationName siteId \\\n", "0 2020-05-11T21:05:49 236592 OS Valentin Klarin 5031 \n", "1 2020-05-11T21:05:49 193099 Srednja skola Petrinja 5229 \n", "2 2020-05-11T21:05:49 88451 XV. Gimnazija 5461 \n", "3 2020-05-11T21:05:49 290789 OS Ljubo Babic 5648 \n", "4 2020-05-11T21:05:49 188930 OS Dubovac 6006 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 HRAST CRNIKA Croatia HRV 44.08200 15.178600 \n", "1 Lovro:GRN-01 Croatia HRV 45.44190 16.280100 \n", "2 Biometrija Škola Croatia HRV 45.81907 16.006884 \n", "3 skolski vrt:LCS-01 Croatia HRV 45.66525 15.647310 \n", "4 KOZJACA - SUMA:LCS-01 Croatia HRV 45.48690 15.533500 \n", "\n", " elevation pid landcoversDownwardPhotoUrl landcoversEastExtraData \\\n", "0 31.0 159342917 None None \n", "1 61.0 159341778 None None \n", "2 119.2 159341779 None None \n", "3 76.8 159343716 None None \n", "4 69.7 159341230 None None \n", "\n", " landcoversEastPhotoUrl landcoversMucCode \\\n", "0 None M0112 \n", "1 None M821 \n", "2 None M91 \n", "3 None M821 \n", "4 None M1123 \n", "\n", " landcoversUpwardPhotoUrl landcoversEastCaption \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 https://data.globe.gov/system/photos/2018/06/0... None \n", "\n", " landcoversWestClassifications landcoversNorthCaption \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " landcoversNorthExtraData landcoversDataSource \\\n", "0 None GLOBE Data Entry Site Definition \n", "1 None GLOBE Data Entry Site Definition \n", "2 None GLOBE Data Entry Site Definition \n", "3 None GLOBE Data Entry Site Definition \n", "4 None GLOBE Data Entry Site Definition \n", "\n", " landcoversDryGround landcoversSouthClassifications landcoversWestCaption \\\n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "\n", " landcoversNorthPhotoUrl landcoversUpwardCaption landcoversDownwardExtraData \\\n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "\n", " landcoversEastClassifications landcoversMucDetails \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " landcoversMeasuredAt landcoversDownwardCaption \\\n", "0 2019-05-14T12:15:49.295325 None \n", "1 2019-03-15T09:17:21.465512 None \n", "2 2019-03-15T10:20:57.849497 None \n", "3 2019-06-21T07:26:38.7145 None \n", "4 2019-01-31T18:39:22.879692 None \n", "\n", " landcoversSouthPhotoUrl landcoversMuddy landcoversWestPhotoUrl \\\n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "\n", " landcoversStandingWater landcoversLeavesOnTrees landcoversUserid \\\n", "0 None None NaN \n", "1 None None NaN \n", "2 None None NaN \n", "3 None None NaN \n", "4 None None NaN \n", "\n", " landcoversSouthExtraData landcoversSouthCaption landcoversRainingSnowing \\\n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "\n", " landcoversUpwardExtraData landcoversWestExtraData landcoversLandCoverId \\\n", "0 None None 23382 \n", "1 None None 21005 \n", "2 None None 21007 \n", "3 None None 24508 \n", "4 null None 20851 \n", "\n", " landcoversMucDescription landcoversSnowIce \\\n", "0 Closed Forest, Mainly Evergreen, Tropical Wet ... None \n", "1 Cultivated Land, Non-Agriculture, Parks and At... None \n", "2 Urban, Residential None \n", "3 Cultivated Land, Non-Agriculture, Parks and At... None \n", "4 Woodland, Mainly Evergreen, Needle-Leaved, Cyl... None \n", "\n", " landcoversNorthClassifications \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " landcoversFieldNotes \\\n", "0 it is submontane \n", "1 None \n", "2 Urban, Residential :: THE SIDE IS BACKYARD OF ... \n", "3 We want to aviod ?, #269 \n", "4 :: FOREST IN KARLOVAC, CROATIA. DECIDOUS FOREST. \n", "\n", " landcoversMeasurementLatitude landcoversMeasurementElevation \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "\n", " landcoversMeasurementLongitude \n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from precipitation_monthlies...\n", "494 results returned from precipitation_monthlies.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidprecipitationmonthliesLiquidAccumulationMmprecipitationmonthliesLiquidAccumulationFlagprecipitationmonthliesAveragedMonthprecipitationmonthliesUseridprecipitationmonthliesNumberOfObsprecipitationmonthliesNumberOfDaysReported
0precipitation_monthlies2019-01-012019-02-01T00:54:552019-03-19T17:17:072020-02-17T22:17:4261017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.082745022215.3None2019-01-0129712643131
1precipitation_monthlies2019-02-012019-03-02T00:55:032019-03-19T17:17:072020-02-17T22:17:4261017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.08290447741.5None2019-02-0129712642828
2precipitation_monthlies2019-03-012019-04-04T00:55:062019-04-04T00:55:062020-02-17T22:17:4261017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010554070346.4None2019-03-0129712643131
3precipitation_monthlies2019-04-012019-05-04T00:55:192019-05-04T00:55:192020-02-17T22:17:4261017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.010566326660.0None2019-04-0129712643030
4precipitation_monthlies2019-05-012019-06-08T00:55:162019-06-08T00:55:162020-02-17T22:17:4261017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0105771709247.3None2019-05-0129712643131
\n", "
" ], "text/plain": [ " protocol measuredDate createDate \\\n", "0 precipitation_monthlies 2019-01-01 2019-02-01T00:54:55 \n", "1 precipitation_monthlies 2019-02-01 2019-03-02T00:55:03 \n", "2 precipitation_monthlies 2019-03-01 2019-04-04T00:55:06 \n", "3 precipitation_monthlies 2019-04-01 2019-05-04T00:55:19 \n", "4 precipitation_monthlies 2019-05-01 2019-06-08T00:55:16 \n", "\n", " updateDate publishDate organizationId \\\n", "0 2019-03-19T17:17:07 2020-02-17T22:17:42 61017 \n", "1 2019-03-19T17:17:07 2020-02-17T22:17:42 61017 \n", "2 2019-04-04T00:55:06 2020-02-17T22:17:42 61017 \n", "3 2019-05-04T00:55:19 2020-02-17T22:17:42 61017 \n", "4 2019-06-08T00:55:16 2020-02-17T22:17:42 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid precipitationmonthliesLiquidAccumulationMm \\\n", "0 403.0 82745022 215.3 \n", "1 403.0 82904477 41.5 \n", "2 403.0 105540703 46.4 \n", "3 403.0 105663266 60.0 \n", "4 403.0 105771709 247.3 \n", "\n", " precipitationmonthliesLiquidAccumulationFlag \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " precipitationmonthliesAveragedMonth precipitationmonthliesUserid \\\n", "0 2019-01-01 2971264 \n", "1 2019-02-01 2971264 \n", "2 2019-03-01 2971264 \n", "3 2019-04-01 2971264 \n", "4 2019-05-01 2971264 \n", "\n", " precipitationmonthliesNumberOfObs \\\n", "0 31 \n", "1 28 \n", "2 31 \n", "3 30 \n", "4 31 \n", "\n", " precipitationmonthliesNumberOfDaysReported \n", "0 31 \n", "1 28 \n", "2 31 \n", "3 30 \n", "4 31 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from precipitations...\n", "26863 results returned from precipitations.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidprecipitationsSnowfallAccumulationFlagprecipitationsLiquidAccumulationFlagprecipitationsPhMethodprecipitationsVisSnowDepthprecipitationsSnowfallAccumulationprecipitationsPhprecipitationsMeasuredAtprecipitationsSolarMeasuredAtprecipitationsCommentsprecipitationsDaysAccumulatedprecipitationsUseridprecipitationsLiquidAccumulationprecipitationsVisTotalLiquidEquivalentprecipitationsOccurrenceTypeprecipitationsVisRainDepthprecipitationsSolarNoonAt
0precipitations2019-01-012020-01-23T09:53:302020-01-23T09:53:302020-03-25T22:07:2361017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0144534698NoneNoneNaNNaNNaN2019-01-01T11:00:002019-01-01T11:35:00129712640.40.4rain0.42019-01-01T11:24:00
1precipitations2019-01-022020-01-23T09:53:302020-01-23T09:53:302020-03-25T22:07:2361017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0144534704NoneNoneNaNNaNNaN2019-01-02T11:00:002019-01-02T11:34:00129712640.90.9rain0.92019-01-02T11:25:00
2precipitations2019-01-032020-01-23T09:53:302020-01-23T09:53:302020-03-25T22:07:2361017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0144534699NoneNoneNaNNaNNaN2019-01-03T11:00:002019-01-03T11:34:00129712640.70.7rain0.72019-01-03T11:25:00
3precipitations2019-01-042020-01-23T09:53:302020-01-23T09:53:302020-03-25T22:07:2361017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0144534700NoneNoneNaNNaNNaN2019-01-04T11:00:002019-01-04T11:33:00129712640.90.9rain0.92019-01-04T11:25:00
4precipitations2019-01-052020-01-23T09:53:302020-01-23T09:53:302020-03-25T22:07:2361017Bundeshandelsakademie und Bundeshandelsschule ...208School Location:ATM-01AustriaAUT47.491399.72331403.0144534701NoneNoneNaNNaNNaN2019-01-05T11:00:002019-01-05T11:33:00129712647.57.5rain7.52019-01-05T11:26:00
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 precipitations 2019-01-01 2020-01-23T09:53:30 2020-01-23T09:53:30 \n", "1 precipitations 2019-01-02 2020-01-23T09:53:30 2020-01-23T09:53:30 \n", "2 precipitations 2019-01-03 2020-01-23T09:53:30 2020-01-23T09:53:30 \n", "3 precipitations 2019-01-04 2020-01-23T09:53:30 2020-01-23T09:53:30 \n", "4 precipitations 2019-01-05 2020-01-23T09:53:30 2020-01-23T09:53:30 \n", "\n", " publishDate organizationId \\\n", "0 2020-03-25T22:07:23 61017 \n", "1 2020-03-25T22:07:23 61017 \n", "2 2020-03-25T22:07:23 61017 \n", "3 2020-03-25T22:07:23 61017 \n", "4 2020-03-25T22:07:23 61017 \n", "\n", " organizationName siteId \\\n", "0 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "1 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "2 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "3 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "4 Bundeshandelsakademie und Bundeshandelsschule ... 208 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "1 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "2 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "3 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "4 School Location:ATM-01 Austria AUT 47.49139 9.72331 \n", "\n", " elevation pid precipitationsSnowfallAccumulationFlag \\\n", "0 403.0 144534698 None \n", "1 403.0 144534704 None \n", "2 403.0 144534699 None \n", "3 403.0 144534700 None \n", "4 403.0 144534701 None \n", "\n", " precipitationsLiquidAccumulationFlag precipitationsPhMethod \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " precipitationsVisSnowDepth precipitationsSnowfallAccumulation \\\n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN \n", "3 NaN NaN \n", "4 NaN NaN \n", "\n", " precipitationsPh precipitationsMeasuredAt precipitationsSolarMeasuredAt \\\n", "0 NaN 2019-01-01T11:00:00 2019-01-01T11:35:00 \n", "1 NaN 2019-01-02T11:00:00 2019-01-02T11:34:00 \n", "2 NaN 2019-01-03T11:00:00 2019-01-03T11:34:00 \n", "3 NaN 2019-01-04T11:00:00 2019-01-04T11:33:00 \n", "4 NaN 2019-01-05T11:00:00 2019-01-05T11:33:00 \n", "\n", " precipitationsComments precipitationsDaysAccumulated precipitationsUserid \\\n", "0 1 2971264 \n", "1 1 2971264 \n", "2 1 2971264 \n", "3 1 2971264 \n", "4 1 2971264 \n", "\n", " precipitationsLiquidAccumulation precipitationsVisTotalLiquidEquivalent \\\n", "0 0.4 0.4 \n", "1 0.9 0.9 \n", "2 0.7 0.7 \n", "3 0.9 0.9 \n", "4 7.5 7.5 \n", "\n", " precipitationsOccurrenceType precipitationsVisRainDepth \\\n", "0 rain 0.4 \n", "1 rain 0.9 \n", "2 rain 0.7 \n", "3 rain 0.9 \n", "4 rain 7.5 \n", "\n", " precipitationsSolarNoonAt \n", "0 2019-01-01T11:24:00 \n", "1 2019-01-02T11:25:00 \n", "2 2019-01-03T11:25:00 \n", "3 2019-01-04T11:25:00 \n", "4 2019-01-05T11:26:00 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from salinities...\n", "561 results returned from salinities.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidsalinitiesWaterBodyStatesalinitiesAfterSalinityMeasurementTideAtsalinitiesTideLongitudesalinitiesTidePointsalinitiesMeasuredAtsalinitiesTideLatitudesalinitiesBeforeSalinityMeasurementTideTypesalinitiesUseridsalinitiesAfterSalinityMeasurementTideTypesalinitiesCommentssalinitiesSalinityViaHydrometerPptsalinitiesSalinityViaTitrationPptsalinitiesSalinityKitMfgsalinitiesSalinityKitModelsalinitiesTideLocationDescriptionsalinitiesBeforeSalinityMeasurementTideAt
0salinities2019-01-052020-01-23T02:06:282020-01-23T02:06:282020-04-07T21:06:15312299Srednja skola Vela Luka5009Vela LukaCroatiaHRV42.961716.718610.0139251766normalNoneNaNNone2019-01-05T12:00:00NaNNone5776534NoneNone37.5NaNNoneNoneNoneNone
1salinities2019-01-122020-01-23T02:06:282020-01-23T02:06:282020-04-07T21:06:15312299Srednja skola Vela Luka5009Vela LukaCroatiaHRV42.961716.718610.0139251768normalNoneNaNNone2019-01-12T12:00:00NaNNone5776534NoneNone37.5NaNNoneNoneNoneNone
2salinities2019-01-192020-01-23T02:06:282020-01-23T02:06:282020-04-07T21:06:15312299Srednja skola Vela Luka5009Vela LukaCroatiaHRV42.961716.718610.0139251769normalNoneNaNNone2019-01-19T12:00:00NaNNone5776534NoneNone36.0NaNNoneNoneNoneNone
3salinities2019-01-262020-01-23T02:06:282020-01-23T02:06:282020-04-07T21:06:15312299Srednja skola Vela Luka5009Vela LukaCroatiaHRV42.961716.718610.0139251767normalNoneNaNNone2019-01-26T12:00:00NaNNone5776534NoneNone36.0NaNNoneNoneNoneNone
4salinities2019-02-032020-01-23T02:06:292020-01-23T02:06:292020-04-07T21:06:15312299Srednja skola Vela Luka5009Vela LukaCroatiaHRV42.961716.718610.0139253018normalNoneNaNNone2019-02-03T12:00:00NaNNone5776534NoneNone36.0NaNNoneNoneNoneNone
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 salinities 2019-01-05 2020-01-23T02:06:28 2020-01-23T02:06:28 \n", "1 salinities 2019-01-12 2020-01-23T02:06:28 2020-01-23T02:06:28 \n", "2 salinities 2019-01-19 2020-01-23T02:06:28 2020-01-23T02:06:28 \n", "3 salinities 2019-01-26 2020-01-23T02:06:28 2020-01-23T02:06:28 \n", "4 salinities 2019-02-03 2020-01-23T02:06:29 2020-01-23T02:06:29 \n", "\n", " publishDate organizationId organizationName siteId \\\n", "0 2020-04-07T21:06:15 312299 Srednja skola Vela Luka 5009 \n", "1 2020-04-07T21:06:15 312299 Srednja skola Vela Luka 5009 \n", "2 2020-04-07T21:06:15 312299 Srednja skola Vela Luka 5009 \n", "3 2020-04-07T21:06:15 312299 Srednja skola Vela Luka 5009 \n", "4 2020-04-07T21:06:15 312299 Srednja skola Vela Luka 5009 \n", "\n", " siteName countryName countryCode latitude longitude elevation \\\n", "0 Vela Luka Croatia HRV 42.9617 16.7186 10.0 \n", "1 Vela Luka Croatia HRV 42.9617 16.7186 10.0 \n", "2 Vela Luka Croatia HRV 42.9617 16.7186 10.0 \n", "3 Vela Luka Croatia HRV 42.9617 16.7186 10.0 \n", "4 Vela Luka Croatia HRV 42.9617 16.7186 10.0 \n", "\n", " pid salinitiesWaterBodyState \\\n", "0 139251766 normal \n", "1 139251768 normal \n", "2 139251769 normal \n", "3 139251767 normal \n", "4 139253018 normal \n", "\n", " salinitiesAfterSalinityMeasurementTideAt salinitiesTideLongitude \\\n", "0 None NaN \n", "1 None NaN \n", "2 None NaN \n", "3 None NaN \n", "4 None NaN \n", "\n", " salinitiesTidePoint salinitiesMeasuredAt salinitiesTideLatitude \\\n", "0 None 2019-01-05T12:00:00 NaN \n", "1 None 2019-01-12T12:00:00 NaN \n", "2 None 2019-01-19T12:00:00 NaN \n", "3 None 2019-01-26T12:00:00 NaN \n", "4 None 2019-02-03T12:00:00 NaN \n", "\n", " salinitiesBeforeSalinityMeasurementTideType salinitiesUserid \\\n", "0 None 5776534 \n", "1 None 5776534 \n", "2 None 5776534 \n", "3 None 5776534 \n", "4 None 5776534 \n", "\n", " salinitiesAfterSalinityMeasurementTideType salinitiesComments \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " salinitiesSalinityViaHydrometerPpt salinitiesSalinityViaTitrationPpt \\\n", "0 37.5 NaN \n", "1 37.5 NaN \n", "2 36.0 NaN \n", "3 36.0 NaN \n", "4 36.0 NaN \n", "\n", " salinitiesSalinityKitMfg salinitiesSalinityKitModel \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " salinitiesTideLocationDescription salinitiesBeforeSalinityMeasurementTideAt \n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from surface_temperature_noons...\n", "3255 results returned from surface_temperature_noons.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidsurfacetemperaturenoonsCommentssurfacetemperaturenoonsAverageSurfaceTemperatureCsurfacetemperaturenoonsUseridsurfacetemperaturenoonsHomogeneousSiteLongLengthMsurfacetemperaturenoonsSurfaceConditionsurfacetemperaturenoonsSiteAreaMSquaredsurfacetemperaturenoonsMeasuredAtsurfacetemperaturenoonsSolarMeasuredAtsurfacetemperaturenoonsNumberOfSamplesTakensurfacetemperaturenoonsSurfaceCoverTypesurfacetemperaturenoonsHomogeneousSiteShortLengthMsurfacetemperaturenoonsSolarNoonAtsurfacetemperaturenoonsAverageSnowDepthMmsurfacetemperaturenoonsSnowDepthFlag
0surface_temperature_noons2019-01-172020-02-13T21:35:432020-02-13T21:35:432020-03-20T23:12:3994039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162626517None-4.0290074230.0snow300.02019-01-17T10:00:002019-01-17T11:28:001short grass (< 0.5m)10.02019-01-17T10:30:00300.0measurable
1surface_temperature_noons2019-01-312020-02-13T21:35:432020-02-13T21:35:432020-03-20T23:12:3994039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162626518None-10.0290074230.0snow300.02019-01-31T10:30:002019-01-31T11:54:002short grass (< 0.5m)10.02019-01-31T10:33:00245.0measurable
2surface_temperature_noons2019-02-202020-02-13T21:35:482020-02-13T21:35:482020-03-20T23:12:3994039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162627631None0.6290074230.0wet300.02019-02-20T10:35:002019-02-20T11:58:003short grass (< 0.5m)10.02019-02-20T10:33:00NaNNone
3surface_temperature_noons2019-03-042020-02-13T21:35:532020-02-13T21:35:532020-03-20T23:12:3994039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162628502None-0.8290074230.0snow300.02019-03-04T11:11:002019-03-04T12:36:001short grass (< 0.5m)10.02019-03-04T10:31:00120.0measurable
4surface_temperature_noons2019-03-182020-02-13T21:35:532020-02-13T21:35:532020-03-20T23:12:3994039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162628503None4.1290074230.0wet300.02019-03-18T10:14:002019-03-18T11:44:002short grass (< 0.5m)10.02019-03-18T10:28:00NaNNone
\n", "
" ], "text/plain": [ " protocol measuredDate createDate \\\n", "0 surface_temperature_noons 2019-01-17 2020-02-13T21:35:43 \n", "1 surface_temperature_noons 2019-01-31 2020-02-13T21:35:43 \n", "2 surface_temperature_noons 2019-02-20 2020-02-13T21:35:48 \n", "3 surface_temperature_noons 2019-03-04 2020-02-13T21:35:53 \n", "4 surface_temperature_noons 2019-03-18 2020-02-13T21:35:53 \n", "\n", " updateDate publishDate organizationId \\\n", "0 2020-02-13T21:35:43 2020-03-20T23:12:39 94039 \n", "1 2020-02-13T21:35:43 2020-03-20T23:12:39 94039 \n", "2 2020-02-13T21:35:48 2020-03-20T23:12:39 94039 \n", "3 2020-02-13T21:35:53 2020-03-20T23:12:39 94039 \n", "4 2020-02-13T21:35:53 2020-03-20T23:12:39 94039 \n", "\n", " organizationName siteId siteName countryName \\\n", "0 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "1 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "2 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "3 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "4 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "\n", " countryCode latitude longitude elevation pid \\\n", "0 EST 58.1432 24.9428 58.0 162626517 \n", "1 EST 58.1432 24.9428 58.0 162626518 \n", "2 EST 58.1432 24.9428 58.0 162627631 \n", "3 EST 58.1432 24.9428 58.0 162628502 \n", "4 EST 58.1432 24.9428 58.0 162628503 \n", "\n", " surfacetemperaturenoonsComments \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "\n", " surfacetemperaturenoonsAverageSurfaceTemperatureC \\\n", "0 -4.0 \n", "1 -10.0 \n", "2 0.6 \n", "3 -0.8 \n", "4 4.1 \n", "\n", " surfacetemperaturenoonsUserid \\\n", "0 2900742 \n", "1 2900742 \n", "2 2900742 \n", "3 2900742 \n", "4 2900742 \n", "\n", " surfacetemperaturenoonsHomogeneousSiteLongLengthM \\\n", "0 30.0 \n", "1 30.0 \n", "2 30.0 \n", "3 30.0 \n", "4 30.0 \n", "\n", " surfacetemperaturenoonsSurfaceCondition \\\n", "0 snow \n", "1 snow \n", "2 wet \n", "3 snow \n", "4 wet \n", "\n", " surfacetemperaturenoonsSiteAreaMSquared surfacetemperaturenoonsMeasuredAt \\\n", "0 300.0 2019-01-17T10:00:00 \n", "1 300.0 2019-01-31T10:30:00 \n", "2 300.0 2019-02-20T10:35:00 \n", "3 300.0 2019-03-04T11:11:00 \n", "4 300.0 2019-03-18T10:14:00 \n", "\n", " surfacetemperaturenoonsSolarMeasuredAt \\\n", "0 2019-01-17T11:28:00 \n", "1 2019-01-31T11:54:00 \n", "2 2019-02-20T11:58:00 \n", "3 2019-03-04T12:36:00 \n", "4 2019-03-18T11:44:00 \n", "\n", " surfacetemperaturenoonsNumberOfSamplesTaken \\\n", "0 1 \n", "1 2 \n", "2 3 \n", "3 1 \n", "4 2 \n", "\n", " surfacetemperaturenoonsSurfaceCoverType \\\n", "0 short grass (< 0.5m) \n", "1 short grass (< 0.5m) \n", "2 short grass (< 0.5m) \n", "3 short grass (< 0.5m) \n", "4 short grass (< 0.5m) \n", "\n", " surfacetemperaturenoonsHomogeneousSiteShortLengthM \\\n", "0 10.0 \n", "1 10.0 \n", "2 10.0 \n", "3 10.0 \n", "4 10.0 \n", "\n", " surfacetemperaturenoonsSolarNoonAt \\\n", "0 2019-01-17T10:30:00 \n", "1 2019-01-31T10:33:00 \n", "2 2019-02-20T10:33:00 \n", "3 2019-03-04T10:31:00 \n", "4 2019-03-18T10:28:00 \n", "\n", " surfacetemperaturenoonsAverageSnowDepthMm \\\n", "0 300.0 \n", "1 245.0 \n", "2 NaN \n", "3 120.0 \n", "4 NaN \n", "\n", " surfacetemperaturenoonsSnowDepthFlag \n", "0 measurable \n", "1 measurable \n", "2 None \n", "3 measurable \n", "4 None " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from surface_temperatures...\n", "4727 results returned from surface_temperatures.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidsurfacetemperaturesSiteAreaMSquaredsurfacetemperaturesHomogeneousSiteLongLengthMsurfacetemperaturesCommentssurfacetemperaturesAverageSnowDepthMmsurfacetemperaturesSurfaceCoverTypesurfacetemperaturesSurfaceConditionsurfacetemperaturesNumberOfSamplesTakensurfacetemperaturesUseridsurfacetemperaturesSolarMeasuredAtsurfacetemperaturesHomogeneousSiteShortLengthMsurfacetemperaturesSolarNoonAtsurfacetemperaturesSnowDepthFlagsurfacetemperaturesMeasuredAtsurfacetemperaturesAverageSurfaceTemperatureC
0surface_temperatures2019-01-172020-02-13T21:40:142020-02-13T21:40:142020-03-20T23:12:5794039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162685020300.030.0None300.0short grass (< 0.5m)snow129007422019-01-17T11:28:0010.02019-01-17T10:30:00measurable2019-01-17T10:00:00-4.0
1surface_temperatures2019-01-312020-02-13T21:40:142020-02-13T21:40:142020-03-20T23:12:5794039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162685021300.030.0None245.0short grass (< 0.5m)snow229007422019-01-31T11:54:0010.02019-01-31T10:33:00measurable2019-01-31T10:30:00-10.0
2surface_temperatures2019-02-202020-02-13T21:40:172020-02-13T21:40:172020-03-20T23:12:5794039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162686760300.030.0NoneNaNshort grass (< 0.5m)wet329007422019-02-20T11:58:0010.02019-02-20T10:33:00None2019-02-20T10:35:000.6
3surface_temperatures2019-03-042020-02-13T21:40:192020-02-13T21:40:192020-03-20T23:12:5794039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162688190300.030.0None120.0short grass (< 0.5m)snow129007422019-03-04T12:36:0010.02019-03-04T10:31:00measurable2019-03-04T11:11:00-0.8
4surface_temperatures2019-03-182020-02-13T21:40:192020-02-13T21:40:192020-03-20T23:12:5794039Kilingi-Nomme Gymnasium3363School Location:ATM-01EstoniaEST58.143224.942858.0162688191300.030.0NoneNaNshort grass (< 0.5m)wet329007422019-03-18T13:45:0010.02019-03-18T10:28:00None2019-03-18T12:15:003.5
\n", "
" ], "text/plain": [ " protocol measuredDate createDate \\\n", "0 surface_temperatures 2019-01-17 2020-02-13T21:40:14 \n", "1 surface_temperatures 2019-01-31 2020-02-13T21:40:14 \n", "2 surface_temperatures 2019-02-20 2020-02-13T21:40:17 \n", "3 surface_temperatures 2019-03-04 2020-02-13T21:40:19 \n", "4 surface_temperatures 2019-03-18 2020-02-13T21:40:19 \n", "\n", " updateDate publishDate organizationId \\\n", "0 2020-02-13T21:40:14 2020-03-20T23:12:57 94039 \n", "1 2020-02-13T21:40:14 2020-03-20T23:12:57 94039 \n", "2 2020-02-13T21:40:17 2020-03-20T23:12:57 94039 \n", "3 2020-02-13T21:40:19 2020-03-20T23:12:57 94039 \n", "4 2020-02-13T21:40:19 2020-03-20T23:12:57 94039 \n", "\n", " organizationName siteId siteName countryName \\\n", "0 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "1 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "2 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "3 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "4 Kilingi-Nomme Gymnasium 3363 School Location:ATM-01 Estonia \n", "\n", " countryCode latitude longitude elevation pid \\\n", "0 EST 58.1432 24.9428 58.0 162685020 \n", "1 EST 58.1432 24.9428 58.0 162685021 \n", "2 EST 58.1432 24.9428 58.0 162686760 \n", "3 EST 58.1432 24.9428 58.0 162688190 \n", "4 EST 58.1432 24.9428 58.0 162688191 \n", "\n", " surfacetemperaturesSiteAreaMSquared \\\n", "0 300.0 \n", "1 300.0 \n", "2 300.0 \n", "3 300.0 \n", "4 300.0 \n", "\n", " surfacetemperaturesHomogeneousSiteLongLengthM surfacetemperaturesComments \\\n", "0 30.0 None \n", "1 30.0 None \n", "2 30.0 None \n", "3 30.0 None \n", "4 30.0 None \n", "\n", " surfacetemperaturesAverageSnowDepthMm surfacetemperaturesSurfaceCoverType \\\n", "0 300.0 short grass (< 0.5m) \n", "1 245.0 short grass (< 0.5m) \n", "2 NaN short grass (< 0.5m) \n", "3 120.0 short grass (< 0.5m) \n", "4 NaN short grass (< 0.5m) \n", "\n", " surfacetemperaturesSurfaceCondition \\\n", "0 snow \n", "1 snow \n", "2 wet \n", "3 snow \n", "4 wet \n", "\n", " surfacetemperaturesNumberOfSamplesTaken surfacetemperaturesUserid \\\n", "0 1 2900742 \n", "1 2 2900742 \n", "2 3 2900742 \n", "3 1 2900742 \n", "4 3 2900742 \n", "\n", " surfacetemperaturesSolarMeasuredAt \\\n", "0 2019-01-17T11:28:00 \n", "1 2019-01-31T11:54:00 \n", "2 2019-02-20T11:58:00 \n", "3 2019-03-04T12:36:00 \n", "4 2019-03-18T13:45:00 \n", "\n", " surfacetemperaturesHomogeneousSiteShortLengthM \\\n", "0 10.0 \n", "1 10.0 \n", "2 10.0 \n", "3 10.0 \n", "4 10.0 \n", "\n", " surfacetemperaturesSolarNoonAt surfacetemperaturesSnowDepthFlag \\\n", "0 2019-01-17T10:30:00 measurable \n", "1 2019-01-31T10:33:00 measurable \n", "2 2019-02-20T10:33:00 None \n", "3 2019-03-04T10:31:00 measurable \n", "4 2019-03-18T10:28:00 None \n", "\n", " surfacetemperaturesMeasuredAt surfacetemperaturesAverageSurfaceTemperatureC \n", "0 2019-01-17T10:00:00 -4.0 \n", "1 2019-01-31T10:30:00 -10.0 \n", "2 2019-02-20T10:35:00 0.6 \n", "3 2019-03-04T11:11:00 -0.8 \n", "4 2019-03-18T12:15:00 3.5 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from transparencies...\n", "1895 results returned from transparencies.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidtransparenciesCommentstransparenciesWaterBodyStatetransparenciesTransparencyDiskDoesNotDisappeartransparenciesUseridtransparenciesMeasuredAttransparenciesTransparencyDiskImageDisappearanceMtransparenciesTubeImageDisappearanceCmtransparenciesTubeImageDoesNotDisappear
0transparencies2019-01-062020-01-23T02:46:002020-01-23T02:46:002020-04-25T21:34:07103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0139487377NonenormalFalse30815882019-01-06T08:00:00NaN31.0False
1transparencies2019-01-132020-01-23T02:46:002020-01-23T02:46:002020-04-25T21:34:07103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0139487379NonenormalFalse30815882019-01-13T08:00:00NaN53.0False
2transparencies2019-01-212020-01-23T02:46:002020-01-23T02:46:002020-04-25T21:34:07103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0139487378NonenormalFalse30815882019-01-21T08:00:00NaN40.0False
3transparencies2019-01-272020-01-23T02:46:002020-01-23T02:46:002020-04-25T21:34:07103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0139487380NonenormalFalse30815882019-01-27T08:00:00NaN120.0True
4transparencies2019-02-032020-01-23T02:46:012020-01-23T02:46:012020-04-25T21:34:07103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0139488649NonenormalFalse30815882019-02-03T08:00:00NaN15.0False
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 transparencies 2019-01-06 2020-01-23T02:46:00 2020-01-23T02:46:00 \n", "1 transparencies 2019-01-13 2020-01-23T02:46:00 2020-01-23T02:46:00 \n", "2 transparencies 2019-01-21 2020-01-23T02:46:00 2020-01-23T02:46:00 \n", "3 transparencies 2019-01-27 2020-01-23T02:46:00 2020-01-23T02:46:00 \n", "4 transparencies 2019-02-03 2020-01-23T02:46:01 2020-01-23T02:46:01 \n", "\n", " publishDate organizationId organizationName siteId \\\n", "0 2020-04-25T21:34:07 103048 ZS Bystrice nad Pernstejnem 1960 \n", "1 2020-04-25T21:34:07 103048 ZS Bystrice nad Pernstejnem 1960 \n", "2 2020-04-25T21:34:07 103048 ZS Bystrice nad Pernstejnem 1960 \n", "3 2020-04-25T21:34:07 103048 ZS Bystrice nad Pernstejnem 1960 \n", "4 2020-04-25T21:34:07 103048 ZS Bystrice nad Pernstejnem 1960 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "1 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "2 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "3 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "4 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "\n", " elevation pid transparenciesComments transparenciesWaterBodyState \\\n", "0 570.0 139487377 None normal \n", "1 570.0 139487379 None normal \n", "2 570.0 139487378 None normal \n", "3 570.0 139487380 None normal \n", "4 570.0 139488649 None normal \n", "\n", " transparenciesTransparencyDiskDoesNotDisappear transparenciesUserid \\\n", "0 False 3081588 \n", "1 False 3081588 \n", "2 False 3081588 \n", "3 False 3081588 \n", "4 False 3081588 \n", "\n", " transparenciesMeasuredAt transparenciesTransparencyDiskImageDisappearanceM \\\n", "0 2019-01-06T08:00:00 NaN \n", "1 2019-01-13T08:00:00 NaN \n", "2 2019-01-21T08:00:00 NaN \n", "3 2019-01-27T08:00:00 NaN \n", "4 2019-02-03T08:00:00 NaN \n", "\n", " transparenciesTubeImageDisappearanceCm \\\n", "0 31.0 \n", "1 53.0 \n", "2 40.0 \n", "3 120.0 \n", "4 15.0 \n", "\n", " transparenciesTubeImageDoesNotDisappear \n", "0 False \n", "1 False \n", "2 False \n", "3 True \n", "4 False " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from vegatation_covers...\n", "2290 results returned from vegatation_covers.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidvegatationcoversCanopyCoverEvergreenPercentvegatationcoversDwarfShrubCoverMinusCountvegatationcoversCanopyCoverShrubCountvegatationcoversUseridvegatationcoversCanopyCoverObservationsCountvegatationcoversDwarfShrubCoverPlusCountvegatationcoversDwarfShrubCoverPlusPercentvegatationcoversGroundCoverBrownCountvegatationcoversCanopyCoverEvergreenCountvegatationcoversCanopyCoverPlusPercentvegatationcoversGroundCoverOtherPercentvegatationcoversGroundCoverGreenPercentvegatationcoversCanopyCoverShrubPercentvegatationcoversGroundCoverShrubPercentvegatationcoversGroundCoverObservationsCountvegatationcoversGroundCoverGraminoidCountvegatationcoversGroundCoverDwarfShrubCountvegatationcoversCanopyCoverPlusCountvegatationcoversShrubCoverPlusPercentvegatationcoversShrubCoverMinusCountvegatationcoversGroundCoverOtherCountvegatationcoversGroundCoverForbPercentvegatationcoversDwarfShrubCoverObservationsCountvegatationcoversMeasuredOnvegatationcoversGroundCoverGreenCountvegatationcoversCanopyCoverTreeCountvegatationcoversCanopyCoverDeciduousCountvegatationcoversCanopyCoverDeciduousPercentvegatationcoversShrubCoverPlusCountvegatationcoversGroundCoverBrownPercentvegatationcoversShrubCoverObservationsCountvegatationcoversCommentsvegatationcoversGroundCoverMinusCountvegatationcoversCanopyCoverMinusCountvegatationcoversGroundCoverShrubCountvegatationcoversGroundCoverDwarfShrubPercentvegatationcoversGroundCoverPlusCountvegatationcoversGroundCoverForbCountvegatationcoversGroundCoverPlusPercentvegatationcoversCanopyCoverTreePercentvegatationcoversGroundCoverGraminoidPercent
0vegatation_covers2019-04-012020-01-23T02:47:292020-01-23T02:47:292020-06-15T21:18:08104203IES Esteban Manuel de Villegas3886ERA CAZUELA:BIO-02SpainESP42.355000-2.655200780.01395027960.019.00.0312929620.01.00.00.00.00.00.00.00.00.020.012.01.014.00.019.00.00.020.02019-04-01T00:00:0014.014.014.0100.01.00.020.0None6.06.01.00.014.00.00.00.00.0
1vegatation_covers2019-02-012020-01-23T02:47:272020-01-23T02:47:272020-06-15T21:18:08236592OS Valentin Klarin5031HRAST CRNIKACroatiaHRV44.08200015.17860031.0139500996100.040.00.0307406040.00.00.02.033.00.00.00.00.00.040.02.00.033.00.040.02.00.040.02019-02-01T00:00:002.033.00.00.00.00.040.0None36.07.00.00.04.00.00.00.00.0
2vegatation_covers2019-10-112020-01-23T02:47:352020-01-23T02:47:352020-06-15T21:18:08236592OS Valentin Klarin5031HRAST CRNIKACroatiaHRV44.08200015.17860031.0139506391100.040.00.0307406040.00.00.02.033.00.00.00.00.00.040.02.00.033.00.040.02.00.040.02019-10-11T00:00:002.033.00.00.00.00.040.0None36.07.00.00.04.00.00.00.00.0
3vegatation_covers2019-04-082020-01-23T02:47:292020-01-23T02:47:292020-06-15T21:18:08143492OS Hugo Badalic5100BMjerenja:BIO-01CroatiaHRV45.18733318.000309155.5139502797NaN0.00.0119536610.00.0NaN0.00.0NaNNaNNaNNaNNaN0.00.00.00.0NaN0.00.0NaN0.02019-04-08T00:00:000.00.00.0NaN0.0NaN0.0None0.00.00.0NaN0.00.0NaNNaNNaN
4vegatation_covers2019-04-182020-01-23T02:47:292020-01-23T02:47:292020-06-15T21:18:08143492OS Hugo Badalic5100BMjerenja:BIO-01CroatiaHRV45.18733318.000309155.5139502798NaN0.00.0119536610.00.0NaN0.00.0NaNNaNNaNNaNNaN0.00.00.00.0NaN0.00.0NaN0.02019-04-18T00:00:000.00.00.0NaN0.0NaN0.0None0.00.00.0NaN0.00.0NaNNaNNaN
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 vegatation_covers 2019-04-01 2020-01-23T02:47:29 2020-01-23T02:47:29 \n", "1 vegatation_covers 2019-02-01 2020-01-23T02:47:27 2020-01-23T02:47:27 \n", "2 vegatation_covers 2019-10-11 2020-01-23T02:47:35 2020-01-23T02:47:35 \n", "3 vegatation_covers 2019-04-08 2020-01-23T02:47:29 2020-01-23T02:47:29 \n", "4 vegatation_covers 2019-04-18 2020-01-23T02:47:29 2020-01-23T02:47:29 \n", "\n", " publishDate organizationId organizationName \\\n", "0 2020-06-15T21:18:08 104203 IES Esteban Manuel de Villegas \n", "1 2020-06-15T21:18:08 236592 OS Valentin Klarin \n", "2 2020-06-15T21:18:08 236592 OS Valentin Klarin \n", "3 2020-06-15T21:18:08 143492 OS Hugo Badalic \n", "4 2020-06-15T21:18:08 143492 OS Hugo Badalic \n", "\n", " siteId siteName countryName countryCode latitude longitude \\\n", "0 3886 ERA CAZUELA:BIO-02 Spain ESP 42.355000 -2.655200 \n", "1 5031 HRAST CRNIKA Croatia HRV 44.082000 15.178600 \n", "2 5031 HRAST CRNIKA Croatia HRV 44.082000 15.178600 \n", "3 5100 BMjerenja:BIO-01 Croatia HRV 45.187333 18.000309 \n", "4 5100 BMjerenja:BIO-01 Croatia HRV 45.187333 18.000309 \n", "\n", " elevation pid vegatationcoversCanopyCoverEvergreenPercent \\\n", "0 780.0 139502796 0.0 \n", "1 31.0 139500996 100.0 \n", "2 31.0 139506391 100.0 \n", "3 155.5 139502797 NaN \n", "4 155.5 139502798 NaN \n", "\n", " vegatationcoversDwarfShrubCoverMinusCount \\\n", "0 19.0 \n", "1 40.0 \n", "2 40.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverShrubCount vegatationcoversUserid \\\n", "0 0.0 3129296 \n", "1 0.0 3074060 \n", "2 0.0 3074060 \n", "3 0.0 11953661 \n", "4 0.0 11953661 \n", "\n", " vegatationcoversCanopyCoverObservationsCount \\\n", "0 20.0 \n", "1 40.0 \n", "2 40.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversDwarfShrubCoverPlusCount \\\n", "0 1.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversDwarfShrubCoverPlusPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverBrownCount \\\n", "0 0.0 \n", "1 2.0 \n", "2 2.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverEvergreenCount \\\n", "0 0.0 \n", "1 33.0 \n", "2 33.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverPlusPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverOtherPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverGreenPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversCanopyCoverShrubPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverShrubPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverObservationsCount \\\n", "0 20.0 \n", "1 40.0 \n", "2 40.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverGraminoidCount \\\n", "0 12.0 \n", "1 2.0 \n", "2 2.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverDwarfShrubCount \\\n", "0 1.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverPlusCount \\\n", "0 14.0 \n", "1 33.0 \n", "2 33.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversShrubCoverPlusPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversShrubCoverMinusCount \\\n", "0 19.0 \n", "1 40.0 \n", "2 40.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverOtherCount \\\n", "0 0.0 \n", "1 2.0 \n", "2 2.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverForbPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversDwarfShrubCoverObservationsCount \\\n", "0 20.0 \n", "1 40.0 \n", "2 40.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversMeasuredOn vegatationcoversGroundCoverGreenCount \\\n", "0 2019-04-01T00:00:00 14.0 \n", "1 2019-02-01T00:00:00 2.0 \n", "2 2019-10-11T00:00:00 2.0 \n", "3 2019-04-08T00:00:00 0.0 \n", "4 2019-04-18T00:00:00 0.0 \n", "\n", " vegatationcoversCanopyCoverTreeCount \\\n", "0 14.0 \n", "1 33.0 \n", "2 33.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverDeciduousCount \\\n", "0 14.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverDeciduousPercent \\\n", "0 100.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversShrubCoverPlusCount \\\n", "0 1.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverBrownPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversShrubCoverObservationsCount vegatationcoversComments \\\n", "0 20.0 None \n", "1 40.0 None \n", "2 40.0 None \n", "3 0.0 None \n", "4 0.0 None \n", "\n", " vegatationcoversGroundCoverMinusCount \\\n", "0 6.0 \n", "1 36.0 \n", "2 36.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversCanopyCoverMinusCount \\\n", "0 6.0 \n", "1 7.0 \n", "2 7.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverShrubCount \\\n", "0 1.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "\n", " vegatationcoversGroundCoverDwarfShrubPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverPlusCount vegatationcoversGroundCoverForbCount \\\n", "0 14.0 0.0 \n", "1 4.0 0.0 \n", "2 4.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "\n", " vegatationcoversGroundCoverPlusPercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversCanopyCoverTreePercent \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN \n", "\n", " vegatationcoversGroundCoverGraminoidPercent \n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 NaN \n", "4 NaN " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "making request from water_temperatures...\n", "3119 results returned from water_temperatures.\n", "\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
protocolmeasuredDatecreateDateupdateDatepublishDateorganizationIdorganizationNamesiteIdsiteNamecountryNamecountryCodelatitudelongitudeelevationpidwatertemperaturesThermometerProbeMfgwatertemperaturesWaterBodyStatewatertemperaturesThermometerProbeModelwatertemperaturesCommentswatertemperaturesWaterTempCwatertemperaturesTemperatureMethodwatertemperaturesUseridwatertemperaturesMeasuredAt
0water_temperatures2019-01-062020-01-23T04:41:222020-01-23T04:41:222020-04-25T21:34:26103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0141312498NonenormalNoneNone1.0probe30815882019-01-06T08:00:00
1water_temperatures2019-01-132020-01-23T04:41:222020-01-23T04:41:222020-04-25T21:34:26103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0141312501NonenormalNoneNone2.0probe30815882019-01-13T08:00:00
2water_temperatures2019-01-212020-01-23T04:41:222020-01-23T04:41:222020-04-25T21:34:26103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0141312500NonenormalNoneNone0.0probe30815882019-01-21T08:00:00
3water_temperatures2019-01-272020-01-23T04:41:222020-01-23T04:41:222020-04-25T21:34:26103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0141312499NonenormalNoneNone0.0probe30815882019-01-27T08:00:00
4water_temperatures2019-02-032020-01-23T04:41:242020-01-23T04:41:242020-04-25T21:34:26103048ZS Bystrice nad Pernstejnem1960School Location:SWS-01Czech RepublicCZE49.51916.26570.0141314163NonenormalNoneNone2.0alcohol-filled thermometer30815882019-02-03T08:00:00
\n", "
" ], "text/plain": [ " protocol measuredDate createDate updateDate \\\n", "0 water_temperatures 2019-01-06 2020-01-23T04:41:22 2020-01-23T04:41:22 \n", "1 water_temperatures 2019-01-13 2020-01-23T04:41:22 2020-01-23T04:41:22 \n", "2 water_temperatures 2019-01-21 2020-01-23T04:41:22 2020-01-23T04:41:22 \n", "3 water_temperatures 2019-01-27 2020-01-23T04:41:22 2020-01-23T04:41:22 \n", "4 water_temperatures 2019-02-03 2020-01-23T04:41:24 2020-01-23T04:41:24 \n", "\n", " publishDate organizationId organizationName siteId \\\n", "0 2020-04-25T21:34:26 103048 ZS Bystrice nad Pernstejnem 1960 \n", "1 2020-04-25T21:34:26 103048 ZS Bystrice nad Pernstejnem 1960 \n", "2 2020-04-25T21:34:26 103048 ZS Bystrice nad Pernstejnem 1960 \n", "3 2020-04-25T21:34:26 103048 ZS Bystrice nad Pernstejnem 1960 \n", "4 2020-04-25T21:34:26 103048 ZS Bystrice nad Pernstejnem 1960 \n", "\n", " siteName countryName countryCode latitude longitude \\\n", "0 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "1 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "2 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "3 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "4 School Location:SWS-01 Czech Republic CZE 49.519 16.26 \n", "\n", " elevation pid watertemperaturesThermometerProbeMfg \\\n", "0 570.0 141312498 None \n", "1 570.0 141312501 None \n", "2 570.0 141312500 None \n", "3 570.0 141312499 None \n", "4 570.0 141314163 None \n", "\n", " watertemperaturesWaterBodyState watertemperaturesThermometerProbeModel \\\n", "0 normal None \n", "1 normal None \n", "2 normal None \n", "3 normal None \n", "4 normal None \n", "\n", " watertemperaturesComments watertemperaturesWaterTempC \\\n", "0 None 1.0 \n", "1 None 2.0 \n", "2 None 0.0 \n", "3 None 0.0 \n", "4 None 2.0 \n", "\n", " watertemperaturesTemperatureMethod watertemperaturesUserid \\\n", "0 probe 3081588 \n", "1 probe 3081588 \n", "2 probe 3081588 \n", "3 probe 3081588 \n", "4 alcohol-filled thermometer 3081588 \n", "\n", " watertemperaturesMeasuredAt \n", "0 2019-01-06T08:00:00 \n", "1 2019-01-13T08:00:00 \n", "2 2019-01-21T08:00:00 \n", "3 2019-01-27T08:00:00 \n", "4 2019-02-03T08:00:00 " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "designate('collecting data')\n", "\n", "# collect data\n", "link = collect(polygon)" ] }, { "cell_type": "code", "execution_count": 107, "metadata": { "hide_input": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " ^ [code] (for main: displaying link)\n" ] }, { "data": { "text/html": [ "mosquitoes_bundle_20200618_1592528842.zip
" ], "text/plain": [ "/Users/matthewbandel/PycharmProjects/globe-mosquitoes-bundler/mosquitoes_bundle_20200618_1592528842.zip" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "designate('displaying link')\n", "\n", "# attemmpt to display link\n", "if link:\n", " \n", " # display last link\n", " display(link)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Thanks!" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Please feel free to direct questions or feedback to Matthew Bandel at matthew.bandel@ssaihq.com" ] } ], "metadata": { "hide_input": true, "kernelspec": { "display_name": "Python 3", "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.6.5" } }, "nbformat": 4, "nbformat_minor": 4 }