{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "GETTING STARTED\n", "
\n", "
\n", "To use this Jupyter Notebook you just run each cell of code one by one as you progress down the page.
\n", "To do this, just select the cell, then press the run button above (or use the shortcut keys shift+return).
\n", "The first cell imports some libraries you need. Don't edit this, just run it.
\n", "\n", "
\n", "
" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Requirement already satisfied: pyinaturalist in /Users/samuelrees/pyinaturalist (0.11.0)\n", "Requirement already satisfied: python-dateutil>=2.0 in /anaconda3/lib/python3.6/site-packages (from pyinaturalist) (2.8.1)\n", "Requirement already satisfied: python-forge in /anaconda3/lib/python3.6/site-packages (from pyinaturalist) (18.6.0)\n", "Requirement already satisfied: requests>=2.24.0 in /anaconda3/lib/python3.6/site-packages (from pyinaturalist) (2.25.1)\n", "Requirement already satisfied: six>=1.5 in /anaconda3/lib/python3.6/site-packages (from python-dateutil>=2.0->pyinaturalist) (1.15.0)\n", "Requirement already satisfied: idna<3,>=2.5 in /anaconda3/lib/python3.6/site-packages (from requests>=2.24.0->pyinaturalist) (2.10)\n", "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /anaconda3/lib/python3.6/site-packages (from requests>=2.24.0->pyinaturalist) (1.26.2)\n", "Requirement already satisfied: chardet<5,>=3.0.2 in /anaconda3/lib/python3.6/site-packages (from requests>=2.24.0->pyinaturalist) (4.0.0)\n", "Requirement already satisfied: certifi>=2017.4.17 in /anaconda3/lib/python3.6/site-packages (from requests>=2.24.0->pyinaturalist) (2020.12.5)\n", "Requirement already satisfied: pandas in /anaconda3/lib/python3.6/site-packages (0.24.2)\n", "Requirement already satisfied: python-dateutil>=2.5.0 in /anaconda3/lib/python3.6/site-packages (from pandas) (2.8.1)\n", "Requirement already satisfied: pytz>=2011k in /anaconda3/lib/python3.6/site-packages (from pandas) (2020.4)\n", "Requirement already satisfied: numpy>=1.12.0 in /anaconda3/lib/python3.6/site-packages (from pandas) (1.19.2)\n", "Requirement already satisfied: six>=1.5 in /anaconda3/lib/python3.6/site-packages (from python-dateutil>=2.5.0->pandas) (1.15.0)\n", "Requirement already satisfied: OSGridConverter in /anaconda3/lib/python3.6/site-packages (0.1.3)\n", "Libraries imported!\n" ] } ], "source": [ "!pip install pyinaturalist\n", "!pip install pandas\n", "!pip install OSGridConverter\n", "\n", "from pyinaturalist.node_api import get_all_observations\n", "import pandas as pd\n", "from OSGridConverter import latlong2grid\n", "\n", "print(\"Libraries imported!\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "CHOOSE OBSERVATIONS TO DOWNLOAD\n", "
\n", "
\n", "This next cell, is the one you need to edit.
\n", "
\n", "To choose which observations you want to download, get Place_id and Taxon IDs by looking at the iNaturalist URL in a browser when using Explore
\n", "e.g. If I wanted Empididae observations by Steve McWilliams in UK this is the URL in iNaturalist I would get:
\n", "https://www.inaturalist.org/observations?place_id=6857&subview=grid&taxon_id=49460&user_id=stevemcbill\n", "
\n", "
So from the URL I just take
\n", "taxon ID 49460
\n", "and
\n", "user ID stevemcbill \n", "
and replace these values in the multicoloured part below, making sure not to delete the comma or equal sign before or after.\n", "
\n", "
\n", "NOTE: Some cells will take a while to run. This is one of them! Be patient.
\n", "You can see if it is still running by looking at the browser tab - the book symbol changes to an eggtimer when its processing. \n", "
\n", "
\n", "\n" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Observations ready!\n" ] } ], "source": [ "observations = get_all_observations(\n", " user_id='sbushes', # Username ID\n", " taxon_id=326777, # Taxon ID for Syrphidae = 49995.... Hemiptera = 47744, Aculeata = 326777\n", " place_id=6857, # Location ID for UK = 6857\n", " d1='2020-01-01', # Get observations from Jan 1st 2020...\n", " d2='2020-12-12', # ...through Dec 12th 2020 (adjust these dates as needed)\n", " geo=True, # Only get observations with geospatial coordinates\n", " geoprivacy='open', # Only get observations with public coordinates (not obscured/private)\n", ")\n", "\n", "print(\"Observations ready!\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "MORE ADVANCED BIT\n", "
\n", "There are a lot of different data values connected to each observation
\n", "The code below grabs the relevant bits ready for the spreadsheet
\n", "
\n", "For now, you will probably want to just run this one as is.
\n", "But bear in mind you may need to edit this down the line if you want to pull off some bespoke information
\n", "e.g. IDs from a certain identifier
\n", "
" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Observations simplified!\n" ] } ], "source": [ "# \n", "\n", "def simplify_observation(obs):\n", "\n", " simplified_obs = {}\n", " \n", " # Top level values\n", " simplified_obs['Date'] = obs['observed_on']\n", " simplified_obs['Location Name'] = obs['place_guess']\n", " simplified_obs['URL'] = obs['uri']\n", " simplified_obs['location accuracy'] = obs['positional_accuracy']\n", " \n", " # Nested values\n", " simplified_obs['species name'] = obs['taxon']['name']\n", " simplified_obs['coordinates'] = obs['geojson']['coordinates'] \n", "\n", " \n", " # Range of values (photos)\n", " for i in range(len(obs['photos'])): \n", " # Change value here if you want more or less than 3 photos \n", " if(i<3):\n", " simplified_obs['x Media Path '+str(i)] = obs['photos'][i]['url'].replace('square', 'original')\n", "\n", " \n", " # Range of values (annotations) \n", " for i in range(len(obs['annotations'])): \n", " if (obs['annotations'][i]['controlled_value_id']==11):\n", " simplified_obs['Sex'] = 'Male'\n", " if (obs['annotations'][i]['controlled_value_id']==10):\n", " simplified_obs['Sex'] = 'Female'\n", "\n", " \n", " # Range of values (specific identifier) \n", " #for i in range(len(obs['identifications'])):\n", " # if obs['identifications'][i]['user']['name']==\"Ian Andrews\":\n", " # \n", " # simplified_obs['X Identified by Ian Andrews'] ='I.Andrews'\n", " # simplified_obs['Ian Andrews ID'] =obs['identifications'][i]['taxon']['name']\n", " # \n", " # if simplified_obs['Ian Andrews ID'] != obs['taxon']['name']:\n", " # print(\"Double check this URL\")\n", " # print(simplified_obs['URL'])\n", " \n", " \n", " # Range of values (observation fields) \n", " #for i in range(len(obs['ofvs'])): \n", " # if (obs['ofvs'][i]['name']==('Interaction->Visited ''flower ''of')):\n", " # simplified_obs['On flower'] = obs['ofvs'][i]['taxon']['name']\n", "\n", " \n", " #print(\"all done!\")\n", " \n", " return simplified_obs\n", "\n", "simpleObs = [simplify_observation(obs) for obs in observations]\n", "print(\"Observations simplified!\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "VIEWING THE DATA
\n", "Now we've got it ready, lets check it out inside a dataframe so its a bit more legible." ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
DateLocation NameSexURLcoordinateslocation accuracyspecies namex Media Path 0x Media Path 1x Media Path 2
02020-02-26Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39250370[-2.7604670279, 52.7066438765]22.0Bombus terrestrishttps://static.inaturalist.org/photos/62246856...https://static.inaturalist.org/photos/62246841...https://static.inaturalist.org/photos/62246865...
12020-02-26Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39250371[-2.7604670279, 52.7066438765]22.0Anthophora plumipeshttps://static.inaturalist.org/photos/62247532...https://static.inaturalist.org/photos/62247471...https://static.inaturalist.org/photos/62247483...
22020-02-26Shrewsbury, UKFemalehttps://www.inaturalist.org/observations/39251315[-2.7604574328, 52.7066129708]15.0Lasiushttps://static.inaturalist.org/photos/62248710...https://static.inaturalist.org/photos/62248693...https://static.inaturalist.org/photos/62248700...
32020-02-28Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39327032[-2.7500916986, 52.7109461712]4.0Bombushttps://static.inaturalist.org/photos/62376509...https://static.inaturalist.org/photos/62376512...https://static.inaturalist.org/photos/62376513...
42020-03-02Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39473701[-2.7616058102, 52.7069243192]9.0Lasiushttps://static.inaturalist.org/photos/62631721...https://static.inaturalist.org/photos/62631724...https://static.inaturalist.org/photos/62631727...
52020-03-03Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39552440[-2.7604800799, 52.7063194565]15.0Bombus terrestrishttps://static.inaturalist.org/photos/62761539...https://static.inaturalist.org/photos/62761549...https://static.inaturalist.org/photos/62761551...
62020-03-05Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39591074[-2.7498102277, 52.7109966051]24.0Bombushttps://static.inaturalist.org/photos/62825251...https://static.inaturalist.org/photos/62825253...https://static.inaturalist.org/photos/62825255...
72020-03-05Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39591086[-2.7496680706, 52.7110028629]33.0Bombus terrestrishttps://static.inaturalist.org/photos/62825288...https://static.inaturalist.org/photos/62825290...https://static.inaturalist.org/photos/62825295...
82020-03-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39625489[-2.758397269, 52.7076818904]15.0Vespula vulgarishttps://static.inaturalist.org/photos/62883645...https://static.inaturalist.org/photos/62883625...https://static.inaturalist.org/photos/62883630...
92020-03-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39631271[-2.7647844283, 52.7083963123]31.0Apis melliferahttps://static.inaturalist.org/photos/62893646...https://static.inaturalist.org/photos/62893648...https://static.inaturalist.org/photos/62893650...
102020-03-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39631276[-2.7647844283, 52.7083963123]31.0Apis melliferahttps://static.inaturalist.org/photos/62893663...https://static.inaturalist.org/photos/62893655...https://static.inaturalist.org/photos/62893669...
112020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715369[-2.7569291314, 52.7028849826]61.0Bombus terrestrishttps://static.inaturalist.org/photos/63035359...https://static.inaturalist.org/photos/63035545...NaN
122020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715378[-2.7569291314, 52.7028849826]61.0Bombus terrestrishttps://static.inaturalist.org/photos/63035375...https://static.inaturalist.org/photos/63035373...NaN
132020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715389[-2.7569291314, 52.7028849826]61.0Apis melliferahttps://static.inaturalist.org/photos/63035440...https://static.inaturalist.org/photos/63035435...NaN
142020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715393[-2.7569291314, 52.7028849826]61.0Apis melliferahttps://static.inaturalist.org/photos/63035455...NaNNaN
152020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715394[-2.7569291314, 52.7028849826]61.0Bombushttps://static.inaturalist.org/photos/63035475...https://static.inaturalist.org/photos/63035460...https://static.inaturalist.org/photos/63035469...
162020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715399[-2.7569291314, 52.7028849826]61.0Apis melliferahttps://static.inaturalist.org/photos/63035519...https://static.inaturalist.org/photos/63035516...NaN
172020-03-09Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39861383[-2.7563181454, 52.7085165526]2.0Lasiushttps://static.inaturalist.org/photos/63282543...https://static.inaturalist.org/photos/63282541...https://static.inaturalist.org/photos/63282547...
182020-03-03Quarry Park, Shrewsbury, England, GBNaNhttps://www.inaturalist.org/observations/39888544[-2.7606666667, 52.706445]NaNBombus terrestrishttps://static.inaturalist.org/photos/63330073...https://static.inaturalist.org/photos/63330050...NaN
192020-03-11Shrewsbury, UKMalehttps://www.inaturalist.org/observations/39898953[-2.7605249978, 52.7064674223]31.0Anthophora plumipeshttps://static.inaturalist.org/photos/63347643...https://static.inaturalist.org/photos/63347647...https://static.inaturalist.org/photos/63347650...
202020-03-11Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39898990[-2.7605249978, 52.7064674223]31.0Bombus terrestrishttps://static.inaturalist.org/photos/63347853...https://static.inaturalist.org/photos/63347857...https://static.inaturalist.org/photos/63347865...
212020-03-11Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39919985[-2.7648902527, 52.7070723145]7.0Lasiushttps://static.inaturalist.org/photos/63384135...https://static.inaturalist.org/photos/63384127...https://static.inaturalist.org/photos/63384129...
222020-03-12Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39939555[-2.7609032286, 52.7066735427]56.0Bombus terrestrishttps://static.inaturalist.org/photos/63417463...https://static.inaturalist.org/photos/63417443...https://static.inaturalist.org/photos/63417446...
232020-03-25Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40743094[-2.7597574646, 52.704213841]8.0Apis melliferahttps://static.inaturalist.org/photos/64590313...NaNNaN
242020-03-25Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40743101[-2.7596783395, 52.7041112097]19.0Andrenahttps://static.inaturalist.org/photos/64590349...NaNNaN
252020-03-25Shrewsbury, UKFemalehttps://www.inaturalist.org/observations/40743193[-2.7596514184, 52.7041182673]12.0Andrena fulvahttps://static.inaturalist.org/photos/64590668...https://static.inaturalist.org/photos/64590666...https://static.inaturalist.org/photos/64590665...
262020-03-23Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40852332[-2.7596218365, 52.7041255947]15.0Bombus terrestrishttps://static.inaturalist.org/photos/64764400...https://static.inaturalist.org/photos/64764392...https://static.inaturalist.org/photos/64764413...
272020-03-23Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40852590[-2.7596532334, 52.7040933672]14.0Bombus terrestrishttps://static.inaturalist.org/photos/64764892...https://static.inaturalist.org/photos/64764890...https://static.inaturalist.org/photos/64764904...
282020-03-26Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40950761[-2.7586800677, 52.7076822173]152.0Anthophora plumipeshttps://static.inaturalist.org/photos/64928260...NaNNaN
292020-04-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/41565696[-2.7586787939, 52.7069435758]15.0Andrena fulvahttps://static.inaturalist.org/photos/65946914...NaNNaN
.................................
2562020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55550221[-2.7444175986, 52.7068452203]8.0Apoideahttps://static.inaturalist.org/photos/88461322...https://static.inaturalist.org/photos/88461313...https://static.inaturalist.org/photos/88461307...
2572020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55550235[-2.7444175986, 52.7068452203]8.0Bombushttps://static.inaturalist.org/photos/88461484...https://static.inaturalist.org/photos/88461490...https://static.inaturalist.org/photos/88461497...
2582020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55551088[-2.7444063906, 52.706838604]8.0Lasioglossumhttps://static.inaturalist.org/photos/88462090...https://static.inaturalist.org/photos/88462051...https://static.inaturalist.org/photos/88462063...
2592020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55551101[-2.7444063906, 52.706838604]8.0Vespula vulgarishttps://static.inaturalist.org/photos/88462307...https://static.inaturalist.org/photos/88462301...https://static.inaturalist.org/photos/88462315...
2602020-08-05SWT garden, ShrewsburyNaNhttps://www.inaturalist.org/observations/55551525[-2.7444195992, 52.7068441846]8.0Vespulahttps://static.inaturalist.org/photos/88463479...https://static.inaturalist.org/photos/88463487...https://static.inaturalist.org/photos/88463498...
2612020-08-03Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55579733[-4.0516117158, 52.5427000656]103.0Pompilus cinereushttps://static.inaturalist.org/photos/88511938...https://static.inaturalist.org/photos/88511935...https://static.inaturalist.org/photos/88511943...
2622020-08-03Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55582241[-4.0522439439, 52.5426886535]116.0Cerceris arenariahttps://static.inaturalist.org/photos/88516361...https://static.inaturalist.org/photos/88516357...https://static.inaturalist.org/photos/88516353...
2632020-08-03Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55583899[-4.0523614646, 52.5425834931]110.0Pompilidaehttps://static.inaturalist.org/photos/88519190...https://static.inaturalist.org/photos/88519188...https://static.inaturalist.org/photos/88519196...
2642020-08-04Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55585163[-4.052850995, 52.5426283206]94.0Myrmicinaehttps://static.inaturalist.org/photos/88521702...NaNNaN
2652020-08-04Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55585578[-4.0527281259, 52.5425217443]148.0Formicinaehttps://static.inaturalist.org/photos/88522150...https://static.inaturalist.org/photos/88522153...NaN
2662020-08-04Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55585594[-4.0527281259, 52.5425217443]148.0Myrmicinaehttps://static.inaturalist.org/photos/88522272...https://static.inaturalist.org/photos/88522287...https://static.inaturalist.org/photos/88522281...
2672020-08-04Railway station car park, Aberdyfi, UKNaNhttps://www.inaturalist.org/observations/55585789[-4.0550763509, 52.5442857347]39.0Formicahttps://static.inaturalist.org/photos/88522958...https://static.inaturalist.org/photos/88522952...NaN
2682020-08-05SWT back garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55623697[-2.7444304993, 52.706843657]8.0Bombushttps://static.inaturalist.org/photos/88583184...https://static.inaturalist.org/photos/88583169...https://static.inaturalist.org/photos/88583201...
2692020-08-05SWT back garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55623716[-2.7444304993, 52.706843657]8.0Lasiushttps://static.inaturalist.org/photos/88583418...https://static.inaturalist.org/photos/88583321...https://static.inaturalist.org/photos/88583334...
2702020-07-28Path to Gravel Hill Ln, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56205550[-2.7576903997, 52.7161418169]132.0Colleteshttps://static.inaturalist.org/photos/89553081...https://static.inaturalist.org/photos/89553073...https://static.inaturalist.org/photos/89553076...
2712020-07-28Severn to Gravel hill path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56205835[-2.7587982265, 52.7164017425]158.0Lasioglossumhttps://static.inaturalist.org/photos/89554279...https://static.inaturalist.org/photos/89554284...NaN
2722020-07-28Coton Hill Reserve, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56248606[-2.7577263385, 52.721312341]31.0Vespula germanicahttps://static.inaturalist.org/photos/89623073...https://static.inaturalist.org/photos/89623012...https://static.inaturalist.org/photos/89623052...
2732020-07-28Coton Hill Reserve, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56249505[-2.7585791745, 52.7220442642]143.0Leptothorax acervorumhttps://static.inaturalist.org/photos/89624178...NaNNaN
2742020-07-28Coton Hill reserve, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56250275[-2.7584447141, 52.7221299936]107.0Gorytinahttps://static.inaturalist.org/photos/89625619...https://static.inaturalist.org/photos/89625609...https://static.inaturalist.org/photos/89625625...
2752020-07-29Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56269605[-2.7593843977, 52.7095748416]423.0Colleteshttps://static.inaturalist.org/photos/89658772...https://static.inaturalist.org/photos/89658764...https://static.inaturalist.org/photos/89658779...
2762020-07-31Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56272552[-2.7507654851, 52.7101099095]1170.0Formica fusca-grouphttps://static.inaturalist.org/photos/89663370...https://static.inaturalist.org/photos/89663320...https://static.inaturalist.org/photos/89663326...
2772020-08-07Ditherington to Haughmond path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56304972[-2.7192492441, 52.7237511702]943.0Myrmicahttps://static.inaturalist.org/photos/89718522...https://static.inaturalist.org/photos/89718495...https://static.inaturalist.org/photos/89718500...
2782020-08-07By weir, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56305331[-2.7374101708, 52.715746918]204.0Vespulahttps://static.inaturalist.org/photos/89719015...https://static.inaturalist.org/photos/89719007...https://static.inaturalist.org/photos/89719028...
2792020-08-27Water of Leith, Edinburgh, Scotland, GBNaNhttps://www.inaturalist.org/observations/58373777[-3.2268284265, 55.9492769244]178.0Bombus lucorumhttps://static.inaturalist.org/photos/93190269...NaNNaN
2802020-08-11Inside Darwins Garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66692754[-2.7637060481, 52.7132183425]21.0Aculeatahttps://static.inaturalist.org/photos/10757133...https://static.inaturalist.org/photos/10757132...https://static.inaturalist.org/photos/10757132...
2812020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66714889[-2.7580022621, 52.71623222]74.0Apis melliferahttps://static.inaturalist.org/photos/10761061...https://static.inaturalist.org/photos/10761061...NaN
2822020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66715568[-2.7580022621, 52.71623222]74.0Lasioglossumhttps://static.inaturalist.org/photos/10761345...https://static.inaturalist.org/photos/10761345...https://static.inaturalist.org/photos/10761344...
2832020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66752979[-2.7580022621, 52.71623222]74.0Mellinus arvensishttps://static.inaturalist.org/photos/10768097...https://static.inaturalist.org/photos/10768097...NaN
2842020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66753325[-2.7580022621, 52.71623222]74.0Mellinus arvensishttps://static.inaturalist.org/photos/10768166...https://static.inaturalist.org/photos/10768166...https://static.inaturalist.org/photos/10768165...
2852020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66753327[-2.7580022621, 52.71623222]74.0Crabronidaehttps://static.inaturalist.org/photos/10768167...https://static.inaturalist.org/photos/10768168...https://static.inaturalist.org/photos/10768167...
\n", "

286 rows × 10 columns

\n", "
" ], "text/plain": [ " Date Location Name Sex \\\n", "0 2020-02-26 Shrewsbury, UK NaN \n", "1 2020-02-26 Shrewsbury, UK NaN \n", "2 2020-02-26 Shrewsbury, UK Female \n", "3 2020-02-28 Shrewsbury, UK NaN \n", "4 2020-03-02 Shrewsbury, UK NaN \n", "5 2020-03-03 Shrewsbury, UK NaN \n", "6 2020-03-05 Shrewsbury, UK NaN \n", "7 2020-03-05 Shrewsbury, UK NaN \n", "8 2020-03-06 Shrewsbury, UK NaN \n", "9 2020-03-06 Shrewsbury, UK NaN \n", "10 2020-03-06 Shrewsbury, UK NaN \n", "11 2020-03-08 Shrewsbury, UK NaN \n", "12 2020-03-08 Shrewsbury, UK NaN \n", "13 2020-03-08 Shrewsbury, UK NaN \n", "14 2020-03-08 Shrewsbury, UK NaN \n", "15 2020-03-08 Shrewsbury, UK NaN \n", "16 2020-03-08 Shrewsbury, UK NaN \n", "17 2020-03-09 Shrewsbury, UK NaN \n", "18 2020-03-03 Quarry Park, Shrewsbury, England, GB NaN \n", "19 2020-03-11 Shrewsbury, UK Male \n", "20 2020-03-11 Shrewsbury, UK NaN \n", "21 2020-03-11 Shrewsbury, UK NaN \n", "22 2020-03-12 Shrewsbury, UK NaN \n", "23 2020-03-25 Shrewsbury, UK NaN \n", "24 2020-03-25 Shrewsbury, UK NaN \n", "25 2020-03-25 Shrewsbury, UK Female \n", "26 2020-03-23 Shrewsbury, UK NaN \n", "27 2020-03-23 Shrewsbury, UK NaN \n", "28 2020-03-26 Shrewsbury, UK NaN \n", "29 2020-04-06 Shrewsbury, UK NaN \n", ".. ... ... ... \n", "256 2020-08-05 SWT garden, Shrewsbury, UK NaN \n", "257 2020-08-05 SWT garden, Shrewsbury, UK NaN \n", "258 2020-08-05 SWT garden, Shrewsbury, UK NaN \n", "259 2020-08-05 SWT garden, Shrewsbury, UK NaN \n", "260 2020-08-05 SWT garden, Shrewsbury NaN \n", "261 2020-08-03 Aberdyfi dunes, Gwynedd, UK NaN \n", "262 2020-08-03 Aberdyfi dunes, Gwynedd, UK NaN \n", "263 2020-08-03 Aberdyfi dunes, Gwynedd, UK NaN \n", "264 2020-08-04 Aberdyfi dunes, Gwynedd, UK NaN \n", "265 2020-08-04 Aberdyfi dunes, Gwynedd, UK NaN \n", "266 2020-08-04 Aberdyfi dunes, Gwynedd, UK NaN \n", "267 2020-08-04 Railway station car park, Aberdyfi, UK NaN \n", "268 2020-08-05 SWT back garden, Shrewsbury, UK NaN \n", "269 2020-08-05 SWT back garden, Shrewsbury, UK NaN \n", "270 2020-07-28 Path to Gravel Hill Ln, Shrewsbury, UK NaN \n", "271 2020-07-28 Severn to Gravel hill path, Shrewsbury, UK NaN \n", "272 2020-07-28 Coton Hill Reserve, Shrewsbury, UK NaN \n", "273 2020-07-28 Coton Hill Reserve, Shrewsbury, UK NaN \n", "274 2020-07-28 Coton Hill reserve, Shrewsbury, UK NaN \n", "275 2020-07-29 Shrewsbury, UK NaN \n", "276 2020-07-31 Shrewsbury, UK NaN \n", "277 2020-08-07 Ditherington to Haughmond path, Shrewsbury, UK NaN \n", "278 2020-08-07 By weir, Shrewsbury, UK NaN \n", "279 2020-08-27 Water of Leith, Edinburgh, Scotland, GB NaN \n", "280 2020-08-11 Inside Darwins Garden, Shrewsbury, UK NaN \n", "281 2020-08-12 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "282 2020-08-12 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "283 2020-08-12 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "284 2020-08-12 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "285 2020-08-12 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "\n", " URL \\\n", "0 https://www.inaturalist.org/observations/39250370 \n", "1 https://www.inaturalist.org/observations/39250371 \n", "2 https://www.inaturalist.org/observations/39251315 \n", "3 https://www.inaturalist.org/observations/39327032 \n", "4 https://www.inaturalist.org/observations/39473701 \n", "5 https://www.inaturalist.org/observations/39552440 \n", "6 https://www.inaturalist.org/observations/39591074 \n", "7 https://www.inaturalist.org/observations/39591086 \n", "8 https://www.inaturalist.org/observations/39625489 \n", "9 https://www.inaturalist.org/observations/39631271 \n", "10 https://www.inaturalist.org/observations/39631276 \n", "11 https://www.inaturalist.org/observations/39715369 \n", "12 https://www.inaturalist.org/observations/39715378 \n", "13 https://www.inaturalist.org/observations/39715389 \n", "14 https://www.inaturalist.org/observations/39715393 \n", "15 https://www.inaturalist.org/observations/39715394 \n", "16 https://www.inaturalist.org/observations/39715399 \n", "17 https://www.inaturalist.org/observations/39861383 \n", "18 https://www.inaturalist.org/observations/39888544 \n", "19 https://www.inaturalist.org/observations/39898953 \n", "20 https://www.inaturalist.org/observations/39898990 \n", "21 https://www.inaturalist.org/observations/39919985 \n", "22 https://www.inaturalist.org/observations/39939555 \n", "23 https://www.inaturalist.org/observations/40743094 \n", "24 https://www.inaturalist.org/observations/40743101 \n", "25 https://www.inaturalist.org/observations/40743193 \n", "26 https://www.inaturalist.org/observations/40852332 \n", "27 https://www.inaturalist.org/observations/40852590 \n", "28 https://www.inaturalist.org/observations/40950761 \n", "29 https://www.inaturalist.org/observations/41565696 \n", ".. ... \n", "256 https://www.inaturalist.org/observations/55550221 \n", "257 https://www.inaturalist.org/observations/55550235 \n", "258 https://www.inaturalist.org/observations/55551088 \n", "259 https://www.inaturalist.org/observations/55551101 \n", "260 https://www.inaturalist.org/observations/55551525 \n", "261 https://www.inaturalist.org/observations/55579733 \n", "262 https://www.inaturalist.org/observations/55582241 \n", "263 https://www.inaturalist.org/observations/55583899 \n", "264 https://www.inaturalist.org/observations/55585163 \n", "265 https://www.inaturalist.org/observations/55585578 \n", "266 https://www.inaturalist.org/observations/55585594 \n", "267 https://www.inaturalist.org/observations/55585789 \n", "268 https://www.inaturalist.org/observations/55623697 \n", "269 https://www.inaturalist.org/observations/55623716 \n", "270 https://www.inaturalist.org/observations/56205550 \n", "271 https://www.inaturalist.org/observations/56205835 \n", "272 https://www.inaturalist.org/observations/56248606 \n", "273 https://www.inaturalist.org/observations/56249505 \n", "274 https://www.inaturalist.org/observations/56250275 \n", "275 https://www.inaturalist.org/observations/56269605 \n", "276 https://www.inaturalist.org/observations/56272552 \n", "277 https://www.inaturalist.org/observations/56304972 \n", "278 https://www.inaturalist.org/observations/56305331 \n", "279 https://www.inaturalist.org/observations/58373777 \n", "280 https://www.inaturalist.org/observations/66692754 \n", "281 https://www.inaturalist.org/observations/66714889 \n", "282 https://www.inaturalist.org/observations/66715568 \n", "283 https://www.inaturalist.org/observations/66752979 \n", "284 https://www.inaturalist.org/observations/66753325 \n", "285 https://www.inaturalist.org/observations/66753327 \n", "\n", " coordinates location accuracy species name \\\n", "0 [-2.7604670279, 52.7066438765] 22.0 Bombus terrestris \n", "1 [-2.7604670279, 52.7066438765] 22.0 Anthophora plumipes \n", "2 [-2.7604574328, 52.7066129708] 15.0 Lasius \n", "3 [-2.7500916986, 52.7109461712] 4.0 Bombus \n", "4 [-2.7616058102, 52.7069243192] 9.0 Lasius \n", "5 [-2.7604800799, 52.7063194565] 15.0 Bombus terrestris \n", "6 [-2.7498102277, 52.7109966051] 24.0 Bombus \n", "7 [-2.7496680706, 52.7110028629] 33.0 Bombus terrestris \n", "8 [-2.758397269, 52.7076818904] 15.0 Vespula vulgaris \n", "9 [-2.7647844283, 52.7083963123] 31.0 Apis mellifera \n", "10 [-2.7647844283, 52.7083963123] 31.0 Apis mellifera \n", "11 [-2.7569291314, 52.7028849826] 61.0 Bombus terrestris \n", "12 [-2.7569291314, 52.7028849826] 61.0 Bombus terrestris \n", "13 [-2.7569291314, 52.7028849826] 61.0 Apis mellifera \n", "14 [-2.7569291314, 52.7028849826] 61.0 Apis mellifera \n", "15 [-2.7569291314, 52.7028849826] 61.0 Bombus \n", "16 [-2.7569291314, 52.7028849826] 61.0 Apis mellifera \n", "17 [-2.7563181454, 52.7085165526] 2.0 Lasius \n", "18 [-2.7606666667, 52.706445] NaN Bombus terrestris \n", "19 [-2.7605249978, 52.7064674223] 31.0 Anthophora plumipes \n", "20 [-2.7605249978, 52.7064674223] 31.0 Bombus terrestris \n", "21 [-2.7648902527, 52.7070723145] 7.0 Lasius \n", "22 [-2.7609032286, 52.7066735427] 56.0 Bombus terrestris \n", "23 [-2.7597574646, 52.704213841] 8.0 Apis mellifera \n", "24 [-2.7596783395, 52.7041112097] 19.0 Andrena \n", "25 [-2.7596514184, 52.7041182673] 12.0 Andrena fulva \n", "26 [-2.7596218365, 52.7041255947] 15.0 Bombus terrestris \n", "27 [-2.7596532334, 52.7040933672] 14.0 Bombus terrestris \n", "28 [-2.7586800677, 52.7076822173] 152.0 Anthophora plumipes \n", "29 [-2.7586787939, 52.7069435758] 15.0 Andrena fulva \n", ".. ... ... ... \n", "256 [-2.7444175986, 52.7068452203] 8.0 Apoidea \n", "257 [-2.7444175986, 52.7068452203] 8.0 Bombus \n", "258 [-2.7444063906, 52.706838604] 8.0 Lasioglossum \n", "259 [-2.7444063906, 52.706838604] 8.0 Vespula vulgaris \n", "260 [-2.7444195992, 52.7068441846] 8.0 Vespula \n", "261 [-4.0516117158, 52.5427000656] 103.0 Pompilus cinereus \n", "262 [-4.0522439439, 52.5426886535] 116.0 Cerceris arenaria \n", "263 [-4.0523614646, 52.5425834931] 110.0 Pompilidae \n", "264 [-4.052850995, 52.5426283206] 94.0 Myrmicinae \n", "265 [-4.0527281259, 52.5425217443] 148.0 Formicinae \n", "266 [-4.0527281259, 52.5425217443] 148.0 Myrmicinae \n", "267 [-4.0550763509, 52.5442857347] 39.0 Formica \n", "268 [-2.7444304993, 52.706843657] 8.0 Bombus \n", "269 [-2.7444304993, 52.706843657] 8.0 Lasius \n", "270 [-2.7576903997, 52.7161418169] 132.0 Colletes \n", "271 [-2.7587982265, 52.7164017425] 158.0 Lasioglossum \n", "272 [-2.7577263385, 52.721312341] 31.0 Vespula germanica \n", "273 [-2.7585791745, 52.7220442642] 143.0 Leptothorax acervorum \n", "274 [-2.7584447141, 52.7221299936] 107.0 Gorytina \n", "275 [-2.7593843977, 52.7095748416] 423.0 Colletes \n", "276 [-2.7507654851, 52.7101099095] 1170.0 Formica fusca-group \n", "277 [-2.7192492441, 52.7237511702] 943.0 Myrmica \n", "278 [-2.7374101708, 52.715746918] 204.0 Vespula \n", "279 [-3.2268284265, 55.9492769244] 178.0 Bombus lucorum \n", "280 [-2.7637060481, 52.7132183425] 21.0 Aculeata \n", "281 [-2.7580022621, 52.71623222] 74.0 Apis mellifera \n", "282 [-2.7580022621, 52.71623222] 74.0 Lasioglossum \n", "283 [-2.7580022621, 52.71623222] 74.0 Mellinus arvensis \n", "284 [-2.7580022621, 52.71623222] 74.0 Mellinus arvensis \n", "285 [-2.7580022621, 52.71623222] 74.0 Crabronidae \n", "\n", " x Media Path 0 \\\n", "0 https://static.inaturalist.org/photos/62246856... \n", "1 https://static.inaturalist.org/photos/62247532... \n", "2 https://static.inaturalist.org/photos/62248710... \n", "3 https://static.inaturalist.org/photos/62376509... \n", "4 https://static.inaturalist.org/photos/62631721... \n", "5 https://static.inaturalist.org/photos/62761539... \n", "6 https://static.inaturalist.org/photos/62825251... \n", "7 https://static.inaturalist.org/photos/62825288... \n", "8 https://static.inaturalist.org/photos/62883645... \n", "9 https://static.inaturalist.org/photos/62893646... \n", "10 https://static.inaturalist.org/photos/62893663... \n", "11 https://static.inaturalist.org/photos/63035359... \n", "12 https://static.inaturalist.org/photos/63035375... \n", "13 https://static.inaturalist.org/photos/63035440... \n", "14 https://static.inaturalist.org/photos/63035455... \n", "15 https://static.inaturalist.org/photos/63035475... \n", "16 https://static.inaturalist.org/photos/63035519... \n", "17 https://static.inaturalist.org/photos/63282543... \n", "18 https://static.inaturalist.org/photos/63330073... \n", "19 https://static.inaturalist.org/photos/63347643... \n", "20 https://static.inaturalist.org/photos/63347853... \n", "21 https://static.inaturalist.org/photos/63384135... \n", "22 https://static.inaturalist.org/photos/63417463... \n", "23 https://static.inaturalist.org/photos/64590313... \n", "24 https://static.inaturalist.org/photos/64590349... \n", "25 https://static.inaturalist.org/photos/64590668... \n", "26 https://static.inaturalist.org/photos/64764400... \n", "27 https://static.inaturalist.org/photos/64764892... \n", "28 https://static.inaturalist.org/photos/64928260... \n", "29 https://static.inaturalist.org/photos/65946914... \n", ".. ... \n", "256 https://static.inaturalist.org/photos/88461322... \n", "257 https://static.inaturalist.org/photos/88461484... \n", "258 https://static.inaturalist.org/photos/88462090... \n", "259 https://static.inaturalist.org/photos/88462307... \n", "260 https://static.inaturalist.org/photos/88463479... \n", "261 https://static.inaturalist.org/photos/88511938... \n", "262 https://static.inaturalist.org/photos/88516361... \n", "263 https://static.inaturalist.org/photos/88519190... \n", "264 https://static.inaturalist.org/photos/88521702... \n", "265 https://static.inaturalist.org/photos/88522150... \n", "266 https://static.inaturalist.org/photos/88522272... \n", "267 https://static.inaturalist.org/photos/88522958... \n", "268 https://static.inaturalist.org/photos/88583184... \n", "269 https://static.inaturalist.org/photos/88583418... \n", "270 https://static.inaturalist.org/photos/89553081... \n", "271 https://static.inaturalist.org/photos/89554279... \n", "272 https://static.inaturalist.org/photos/89623073... \n", "273 https://static.inaturalist.org/photos/89624178... \n", "274 https://static.inaturalist.org/photos/89625619... \n", "275 https://static.inaturalist.org/photos/89658772... \n", "276 https://static.inaturalist.org/photos/89663370... \n", "277 https://static.inaturalist.org/photos/89718522... \n", "278 https://static.inaturalist.org/photos/89719015... \n", "279 https://static.inaturalist.org/photos/93190269... \n", "280 https://static.inaturalist.org/photos/10757133... \n", "281 https://static.inaturalist.org/photos/10761061... \n", "282 https://static.inaturalist.org/photos/10761345... \n", "283 https://static.inaturalist.org/photos/10768097... \n", "284 https://static.inaturalist.org/photos/10768166... \n", "285 https://static.inaturalist.org/photos/10768167... \n", "\n", " x Media Path 1 \\\n", "0 https://static.inaturalist.org/photos/62246841... \n", "1 https://static.inaturalist.org/photos/62247471... \n", "2 https://static.inaturalist.org/photos/62248693... \n", "3 https://static.inaturalist.org/photos/62376512... \n", "4 https://static.inaturalist.org/photos/62631724... \n", "5 https://static.inaturalist.org/photos/62761549... \n", "6 https://static.inaturalist.org/photos/62825253... \n", "7 https://static.inaturalist.org/photos/62825290... \n", "8 https://static.inaturalist.org/photos/62883625... \n", "9 https://static.inaturalist.org/photos/62893648... \n", "10 https://static.inaturalist.org/photos/62893655... \n", "11 https://static.inaturalist.org/photos/63035545... \n", "12 https://static.inaturalist.org/photos/63035373... \n", "13 https://static.inaturalist.org/photos/63035435... \n", "14 NaN \n", "15 https://static.inaturalist.org/photos/63035460... \n", "16 https://static.inaturalist.org/photos/63035516... \n", "17 https://static.inaturalist.org/photos/63282541... \n", "18 https://static.inaturalist.org/photos/63330050... \n", "19 https://static.inaturalist.org/photos/63347647... \n", "20 https://static.inaturalist.org/photos/63347857... \n", "21 https://static.inaturalist.org/photos/63384127... \n", "22 https://static.inaturalist.org/photos/63417443... \n", "23 NaN \n", "24 NaN \n", "25 https://static.inaturalist.org/photos/64590666... \n", "26 https://static.inaturalist.org/photos/64764392... \n", "27 https://static.inaturalist.org/photos/64764890... \n", "28 NaN \n", "29 NaN \n", ".. ... \n", "256 https://static.inaturalist.org/photos/88461313... \n", "257 https://static.inaturalist.org/photos/88461490... \n", "258 https://static.inaturalist.org/photos/88462051... \n", "259 https://static.inaturalist.org/photos/88462301... \n", "260 https://static.inaturalist.org/photos/88463487... \n", "261 https://static.inaturalist.org/photos/88511935... \n", "262 https://static.inaturalist.org/photos/88516357... \n", "263 https://static.inaturalist.org/photos/88519188... \n", "264 NaN \n", "265 https://static.inaturalist.org/photos/88522153... \n", "266 https://static.inaturalist.org/photos/88522287... \n", "267 https://static.inaturalist.org/photos/88522952... \n", "268 https://static.inaturalist.org/photos/88583169... \n", "269 https://static.inaturalist.org/photos/88583321... \n", "270 https://static.inaturalist.org/photos/89553073... \n", "271 https://static.inaturalist.org/photos/89554284... \n", "272 https://static.inaturalist.org/photos/89623012... \n", "273 NaN \n", "274 https://static.inaturalist.org/photos/89625609... \n", "275 https://static.inaturalist.org/photos/89658764... \n", "276 https://static.inaturalist.org/photos/89663320... \n", "277 https://static.inaturalist.org/photos/89718495... \n", "278 https://static.inaturalist.org/photos/89719007... \n", "279 NaN \n", "280 https://static.inaturalist.org/photos/10757132... \n", "281 https://static.inaturalist.org/photos/10761061... \n", "282 https://static.inaturalist.org/photos/10761345... \n", "283 https://static.inaturalist.org/photos/10768097... \n", "284 https://static.inaturalist.org/photos/10768166... \n", "285 https://static.inaturalist.org/photos/10768168... \n", "\n", " x Media Path 2 \n", "0 https://static.inaturalist.org/photos/62246865... \n", "1 https://static.inaturalist.org/photos/62247483... \n", "2 https://static.inaturalist.org/photos/62248700... \n", "3 https://static.inaturalist.org/photos/62376513... \n", "4 https://static.inaturalist.org/photos/62631727... \n", "5 https://static.inaturalist.org/photos/62761551... \n", "6 https://static.inaturalist.org/photos/62825255... \n", "7 https://static.inaturalist.org/photos/62825295... \n", "8 https://static.inaturalist.org/photos/62883630... \n", "9 https://static.inaturalist.org/photos/62893650... \n", "10 https://static.inaturalist.org/photos/62893669... \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 https://static.inaturalist.org/photos/63035469... \n", "16 NaN \n", "17 https://static.inaturalist.org/photos/63282547... \n", "18 NaN \n", "19 https://static.inaturalist.org/photos/63347650... \n", "20 https://static.inaturalist.org/photos/63347865... \n", "21 https://static.inaturalist.org/photos/63384129... \n", "22 https://static.inaturalist.org/photos/63417446... \n", "23 NaN \n", "24 NaN \n", "25 https://static.inaturalist.org/photos/64590665... \n", "26 https://static.inaturalist.org/photos/64764413... \n", "27 https://static.inaturalist.org/photos/64764904... \n", "28 NaN \n", "29 NaN \n", ".. ... \n", "256 https://static.inaturalist.org/photos/88461307... \n", "257 https://static.inaturalist.org/photos/88461497... \n", "258 https://static.inaturalist.org/photos/88462063... \n", "259 https://static.inaturalist.org/photos/88462315... \n", "260 https://static.inaturalist.org/photos/88463498... \n", "261 https://static.inaturalist.org/photos/88511943... \n", "262 https://static.inaturalist.org/photos/88516353... \n", "263 https://static.inaturalist.org/photos/88519196... \n", "264 NaN \n", "265 NaN \n", "266 https://static.inaturalist.org/photos/88522281... \n", "267 NaN \n", "268 https://static.inaturalist.org/photos/88583201... \n", "269 https://static.inaturalist.org/photos/88583334... \n", "270 https://static.inaturalist.org/photos/89553076... \n", "271 NaN \n", "272 https://static.inaturalist.org/photos/89623052... \n", "273 NaN \n", "274 https://static.inaturalist.org/photos/89625625... \n", "275 https://static.inaturalist.org/photos/89658779... \n", "276 https://static.inaturalist.org/photos/89663326... \n", "277 https://static.inaturalist.org/photos/89718500... \n", "278 https://static.inaturalist.org/photos/89719028... \n", "279 NaN \n", "280 https://static.inaturalist.org/photos/10757132... \n", "281 NaN \n", "282 https://static.inaturalist.org/photos/10761344... \n", "283 NaN \n", "284 https://static.inaturalist.org/photos/10768165... \n", "285 https://static.inaturalist.org/photos/10768167... \n", "\n", "[286 rows x 10 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_test = pd.DataFrame.from_records(simpleObs)\n", "df_test" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "-" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\n", "CONVERT FROM GPS TO UK OS GRID REFERENCE
\n", "This converts from GPS to OS. This shouldn't need editing, just run it.\n", "
" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Grid references converted!\n" ] } ], "source": [ "allOS = []\n", "\n", "for i in df_test['coordinates'].iteritems(): \n", " tempList = []\n", " for j in i[1]:\n", " tempList.append(j)\n", " #print(tempList[0],tempList[1]) \n", " l=latlong2grid(tempList[1], tempList[0])\n", " (l.N,l.E)\n", " str(l)\n", " #print(l)\n", " allOS.append(str(l))\n", "\n", "if 'Grid reference' in df_test.columns:\n", " print(\"You have already run this cell and converted the grid references!\")\n", "\n", "else:\n", " df_test.insert(0, \"Grid reference\", allOS, True) \n", " df_final = df_test.drop(columns=['coordinates'])\n", " print(\"Grid references converted!\")\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "-" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This takes the accuracy metric and roughly equates it to a 6 or 8 figure OS Grid reference.\n", "
\n", "Again, run it as is.
\n", "Ignore the error message! (will try and fix soon) \n", "
Just wait until its finished running...it takes a while." ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:15: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame\n", "\n", "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n", " from ipykernel import kernelapp as app\n", "/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:8: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame\n", "\n", "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n", " \n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "Grid references converted!\n" ] } ], "source": [ "\n", "for i in df_final['location accuracy'].iteritems(): \n", " \n", "\n", " if (i[1] > 80):\n", " \n", " temp = df_final['Grid reference'][i[0]]\n", " temp = temp[0:2]+temp[3:6]+temp[9:12]\n", " df_final['Grid reference'][i[0]] = temp\n", "\n", " \n", " else :\n", " \n", " tamp = df_final['Grid reference'][i[0]]\n", " tamp = tamp[0:2]+tamp[3:7]+tamp[9:13]\n", " df_final['Grid reference'][i[0]] = tamp\n", "\n", " \n", "df_final = df_final.drop(columns=['location accuracy']) \n", "\n", "print(\"Location accuracy taken into account!\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////\n", "
\n", " ADD IN YOUR ACTUAL RECORDED NAME IF YOU LIKE
\n", "Change the value below if you want to add a column for your name.\n", "Then run the cell and take a look at the final data before export" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Grid referenceDateLocation NameSexURLspecies namex Media Path 0x Media Path 1x Media Path 2Recorder Name
0SJ487112382020-02-26Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39250370Bombus terrestrishttps://static.inaturalist.org/photos/62246856...https://static.inaturalist.org/photos/62246841...https://static.inaturalist.org/photos/62246865...John Smith
1SJ487112382020-02-26Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39250371Anthophora plumipeshttps://static.inaturalist.org/photos/62247532...https://static.inaturalist.org/photos/62247471...https://static.inaturalist.org/photos/62247483...John Smith
2SJ487112372020-02-26Shrewsbury, UKFemalehttps://www.inaturalist.org/observations/39251315Lasiushttps://static.inaturalist.org/photos/62248710...https://static.inaturalist.org/photos/62248693...https://static.inaturalist.org/photos/62248700...John Smith
3SJ494212852020-02-28Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39327032Bombushttps://static.inaturalist.org/photos/62376509...https://static.inaturalist.org/photos/62376512...https://static.inaturalist.org/photos/62376513...John Smith
4SJ486312412020-03-02Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39473701Lasiushttps://static.inaturalist.org/photos/62631721...https://static.inaturalist.org/photos/62631724...https://static.inaturalist.org/photos/62631727...John Smith
5SJ487112342020-03-03Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39552440Bombus terrestrishttps://static.inaturalist.org/photos/62761539...https://static.inaturalist.org/photos/62761549...https://static.inaturalist.org/photos/62761551...John Smith
6SJ494412852020-03-05Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39591074Bombushttps://static.inaturalist.org/photos/62825251...https://static.inaturalist.org/photos/62825253...https://static.inaturalist.org/photos/62825255...John Smith
7SJ494512852020-03-05Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39591086Bombus terrestrishttps://static.inaturalist.org/photos/62825288...https://static.inaturalist.org/photos/62825290...https://static.inaturalist.org/photos/62825295...John Smith
8SJ488512492020-03-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39625489Vespula vulgarishttps://static.inaturalist.org/photos/62883645...https://static.inaturalist.org/photos/62883625...https://static.inaturalist.org/photos/62883630...John Smith
9SJ484212572020-03-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39631271Apis melliferahttps://static.inaturalist.org/photos/62893646...https://static.inaturalist.org/photos/62893648...https://static.inaturalist.org/photos/62893650...John Smith
10SJ484212572020-03-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39631276Apis melliferahttps://static.inaturalist.org/photos/62893663...https://static.inaturalist.org/photos/62893655...https://static.inaturalist.org/photos/62893669...John Smith
11SJ489511952020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715369Bombus terrestrishttps://static.inaturalist.org/photos/63035359...https://static.inaturalist.org/photos/63035545...NaNJohn Smith
12SJ489511952020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715378Bombus terrestrishttps://static.inaturalist.org/photos/63035375...https://static.inaturalist.org/photos/63035373...NaNJohn Smith
13SJ489511952020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715389Apis melliferahttps://static.inaturalist.org/photos/63035440...https://static.inaturalist.org/photos/63035435...NaNJohn Smith
14SJ489511952020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715393Apis melliferahttps://static.inaturalist.org/photos/63035455...NaNNaNJohn Smith
15SJ489511952020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715394Bombushttps://static.inaturalist.org/photos/63035475...https://static.inaturalist.org/photos/63035460...https://static.inaturalist.org/photos/63035469...John Smith
16SJ489511952020-03-08Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39715399Apis melliferahttps://static.inaturalist.org/photos/63035519...https://static.inaturalist.org/photos/63035516...NaNJohn Smith
17SJ489912582020-03-09Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39861383Lasiushttps://static.inaturalist.org/photos/63282543...https://static.inaturalist.org/photos/63282541...https://static.inaturalist.org/photos/63282547...John Smith
18SJ487012352020-03-03Quarry Park, Shrewsbury, England, GBNaNhttps://www.inaturalist.org/observations/39888544Bombus terrestrishttps://static.inaturalist.org/photos/63330073...https://static.inaturalist.org/photos/63330050...NaNJohn Smith
19SJ487112362020-03-11Shrewsbury, UKMalehttps://www.inaturalist.org/observations/39898953Anthophora plumipeshttps://static.inaturalist.org/photos/63347643...https://static.inaturalist.org/photos/63347647...https://static.inaturalist.org/photos/63347650...John Smith
20SJ487112362020-03-11Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39898990Bombus terrestrishttps://static.inaturalist.org/photos/63347853...https://static.inaturalist.org/photos/63347857...https://static.inaturalist.org/photos/63347865...John Smith
21SJ484112432020-03-11Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39919985Lasiushttps://static.inaturalist.org/photos/63384135...https://static.inaturalist.org/photos/63384127...https://static.inaturalist.org/photos/63384129...John Smith
22SJ486812382020-03-12Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/39939555Bombus terrestrishttps://static.inaturalist.org/photos/63417463...https://static.inaturalist.org/photos/63417443...https://static.inaturalist.org/photos/63417446...John Smith
23SJ487612102020-03-25Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40743094Apis melliferahttps://static.inaturalist.org/photos/64590313...NaNNaNJohn Smith
24SJ487612092020-03-25Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40743101Andrenahttps://static.inaturalist.org/photos/64590349...NaNNaNJohn Smith
25SJ487612092020-03-25Shrewsbury, UKFemalehttps://www.inaturalist.org/observations/40743193Andrena fulvahttps://static.inaturalist.org/photos/64590668...https://static.inaturalist.org/photos/64590666...https://static.inaturalist.org/photos/64590665...John Smith
26SJ487612092020-03-23Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40852332Bombus terrestrishttps://static.inaturalist.org/photos/64764400...https://static.inaturalist.org/photos/64764392...https://static.inaturalist.org/photos/64764413...John Smith
27SJ487612092020-03-23Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40852590Bombus terrestrishttps://static.inaturalist.org/photos/64764892...https://static.inaturalist.org/photos/64764890...https://static.inaturalist.org/photos/64764904...John Smith
28SJ4881242020-03-26Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/40950761Anthophora plumipeshttps://static.inaturalist.org/photos/64928260...NaNNaNJohn Smith
29SJ488312412020-04-06Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/41565696Andrena fulvahttps://static.inaturalist.org/photos/65946914...NaNNaNJohn Smith
.................................
256SJ498012392020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55550221Apoideahttps://static.inaturalist.org/photos/88461322...https://static.inaturalist.org/photos/88461313...https://static.inaturalist.org/photos/88461307...John Smith
257SJ498012392020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55550235Bombushttps://static.inaturalist.org/photos/88461484...https://static.inaturalist.org/photos/88461490...https://static.inaturalist.org/photos/88461497...John Smith
258SJ498012392020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55551088Lasioglossumhttps://static.inaturalist.org/photos/88462090...https://static.inaturalist.org/photos/88462051...https://static.inaturalist.org/photos/88462063...John Smith
259SJ498012392020-08-05SWT garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55551101Vespula vulgarishttps://static.inaturalist.org/photos/88462307...https://static.inaturalist.org/photos/88462301...https://static.inaturalist.org/photos/88462315...John Smith
260SJ498012392020-08-05SWT garden, ShrewsburyNaNhttps://www.inaturalist.org/observations/55551525Vespulahttps://static.inaturalist.org/photos/88463479...https://static.inaturalist.org/photos/88463487...https://static.inaturalist.org/photos/88463498...John Smith
261SN6099582020-08-03Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55579733Pompilus cinereushttps://static.inaturalist.org/photos/88511938...https://static.inaturalist.org/photos/88511935...https://static.inaturalist.org/photos/88511943...John Smith
262SN6099582020-08-03Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55582241Cerceris arenariahttps://static.inaturalist.org/photos/88516361...https://static.inaturalist.org/photos/88516357...https://static.inaturalist.org/photos/88516353...John Smith
263SN6099582020-08-03Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55583899Pompilidaehttps://static.inaturalist.org/photos/88519190...https://static.inaturalist.org/photos/88519188...https://static.inaturalist.org/photos/88519196...John Smith
264SN6089582020-08-04Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55585163Myrmicinaehttps://static.inaturalist.org/photos/88521702...NaNNaNJohn Smith
265SN6089582020-08-04Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55585578Formicinaehttps://static.inaturalist.org/photos/88522150...https://static.inaturalist.org/photos/88522153...NaNJohn Smith
266SN6089582020-08-04Aberdyfi dunes, Gwynedd, UKNaNhttps://www.inaturalist.org/observations/55585594Myrmicinaehttps://static.inaturalist.org/photos/88522272...https://static.inaturalist.org/photos/88522287...https://static.inaturalist.org/photos/88522281...John Smith
267SN607396032020-08-04Railway station car park, Aberdyfi, UKNaNhttps://www.inaturalist.org/observations/55585789Formicahttps://static.inaturalist.org/photos/88522958...https://static.inaturalist.org/photos/88522952...NaNJohn Smith
268SJ497912392020-08-05SWT back garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55623697Bombushttps://static.inaturalist.org/photos/88583184...https://static.inaturalist.org/photos/88583169...https://static.inaturalist.org/photos/88583201...John Smith
269SJ497912392020-08-05SWT back garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/55623716Lasiushttps://static.inaturalist.org/photos/88583418...https://static.inaturalist.org/photos/88583321...https://static.inaturalist.org/photos/88583334...John Smith
270SJ4891342020-07-28Path to Gravel Hill Ln, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56205550Colleteshttps://static.inaturalist.org/photos/89553081...https://static.inaturalist.org/photos/89553073...https://static.inaturalist.org/photos/89553076...John Smith
271SJ4881342020-07-28Severn to Gravel hill path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56205835Lasioglossumhttps://static.inaturalist.org/photos/89554279...https://static.inaturalist.org/photos/89554284...NaNJohn Smith
272SJ489114002020-07-28Coton Hill Reserve, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56248606Vespula germanicahttps://static.inaturalist.org/photos/89623073...https://static.inaturalist.org/photos/89623012...https://static.inaturalist.org/photos/89623052...John Smith
273SJ4881402020-07-28Coton Hill Reserve, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56249505Leptothorax acervorumhttps://static.inaturalist.org/photos/89624178...NaNNaNJohn Smith
274SJ4881412020-07-28Coton Hill reserve, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56250275Gorytinahttps://static.inaturalist.org/photos/89625619...https://static.inaturalist.org/photos/89625609...https://static.inaturalist.org/photos/89625625...John Smith
275SJ4871272020-07-29Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56269605Colleteshttps://static.inaturalist.org/photos/89658772...https://static.inaturalist.org/photos/89658764...https://static.inaturalist.org/photos/89658779...John Smith
276SJ4931272020-07-31Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56272552Formica fusca-grouphttps://static.inaturalist.org/photos/89663370...https://static.inaturalist.org/photos/89663320...https://static.inaturalist.org/photos/89663326...John Smith
277SJ5151422020-08-07Ditherington to Haughmond path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56304972Myrmicahttps://static.inaturalist.org/photos/89718522...https://static.inaturalist.org/photos/89718495...https://static.inaturalist.org/photos/89718500...John Smith
278SJ5021332020-08-07By weir, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/56305331Vespulahttps://static.inaturalist.org/photos/89719015...https://static.inaturalist.org/photos/89719007...https://static.inaturalist.org/photos/89719028...John Smith
279NT2347352020-08-27Water of Leith, Edinburgh, Scotland, GBNaNhttps://www.inaturalist.org/observations/58373777Bombus lucorumhttps://static.inaturalist.org/photos/93190269...NaNNaNJohn Smith
280SJ485013112020-08-11Inside Darwins Garden, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66692754Aculeatahttps://static.inaturalist.org/photos/10757133...https://static.inaturalist.org/photos/10757132...https://static.inaturalist.org/photos/10757132...John Smith
281SJ488913442020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66714889Apis melliferahttps://static.inaturalist.org/photos/10761061...https://static.inaturalist.org/photos/10761061...NaNJohn Smith
282SJ488913442020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66715568Lasioglossumhttps://static.inaturalist.org/photos/10761345...https://static.inaturalist.org/photos/10761345...https://static.inaturalist.org/photos/10761344...John Smith
283SJ488913442020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66752979Mellinus arvensishttps://static.inaturalist.org/photos/10768097...https://static.inaturalist.org/photos/10768097...NaNJohn Smith
284SJ488913442020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66753325Mellinus arvensishttps://static.inaturalist.org/photos/10768166...https://static.inaturalist.org/photos/10768166...https://static.inaturalist.org/photos/10768165...John Smith
285SJ488913442020-08-12Gravel Hill Lane River path, Shrewsbury, UKNaNhttps://www.inaturalist.org/observations/66753327Crabronidaehttps://static.inaturalist.org/photos/10768167...https://static.inaturalist.org/photos/10768168...https://static.inaturalist.org/photos/10768167...John Smith
\n", "

286 rows × 10 columns

\n", "
" ], "text/plain": [ " Grid reference Date \\\n", "0 SJ48711238 2020-02-26 \n", "1 SJ48711238 2020-02-26 \n", "2 SJ48711237 2020-02-26 \n", "3 SJ49421285 2020-02-28 \n", "4 SJ48631241 2020-03-02 \n", "5 SJ48711234 2020-03-03 \n", "6 SJ49441285 2020-03-05 \n", "7 SJ49451285 2020-03-05 \n", "8 SJ48851249 2020-03-06 \n", "9 SJ48421257 2020-03-06 \n", "10 SJ48421257 2020-03-06 \n", "11 SJ48951195 2020-03-08 \n", "12 SJ48951195 2020-03-08 \n", "13 SJ48951195 2020-03-08 \n", "14 SJ48951195 2020-03-08 \n", "15 SJ48951195 2020-03-08 \n", "16 SJ48951195 2020-03-08 \n", "17 SJ48991258 2020-03-09 \n", "18 SJ48701235 2020-03-03 \n", "19 SJ48711236 2020-03-11 \n", "20 SJ48711236 2020-03-11 \n", "21 SJ48411243 2020-03-11 \n", "22 SJ48681238 2020-03-12 \n", "23 SJ48761210 2020-03-25 \n", "24 SJ48761209 2020-03-25 \n", "25 SJ48761209 2020-03-25 \n", "26 SJ48761209 2020-03-23 \n", "27 SJ48761209 2020-03-23 \n", "28 SJ488124 2020-03-26 \n", "29 SJ48831241 2020-04-06 \n", ".. ... ... \n", "256 SJ49801239 2020-08-05 \n", "257 SJ49801239 2020-08-05 \n", "258 SJ49801239 2020-08-05 \n", "259 SJ49801239 2020-08-05 \n", "260 SJ49801239 2020-08-05 \n", "261 SN609958 2020-08-03 \n", "262 SN609958 2020-08-03 \n", "263 SN609958 2020-08-03 \n", "264 SN608958 2020-08-04 \n", "265 SN608958 2020-08-04 \n", "266 SN608958 2020-08-04 \n", "267 SN60739603 2020-08-04 \n", "268 SJ49791239 2020-08-05 \n", "269 SJ49791239 2020-08-05 \n", "270 SJ489134 2020-07-28 \n", "271 SJ488134 2020-07-28 \n", "272 SJ48911400 2020-07-28 \n", "273 SJ488140 2020-07-28 \n", "274 SJ488141 2020-07-28 \n", "275 SJ487127 2020-07-29 \n", "276 SJ493127 2020-07-31 \n", "277 SJ515142 2020-08-07 \n", "278 SJ502133 2020-08-07 \n", "279 NT234735 2020-08-27 \n", "280 SJ48501311 2020-08-11 \n", "281 SJ48891344 2020-08-12 \n", "282 SJ48891344 2020-08-12 \n", "283 SJ48891344 2020-08-12 \n", "284 SJ48891344 2020-08-12 \n", "285 SJ48891344 2020-08-12 \n", "\n", " Location Name Sex \\\n", "0 Shrewsbury, UK NaN \n", "1 Shrewsbury, UK NaN \n", "2 Shrewsbury, UK Female \n", "3 Shrewsbury, UK NaN \n", "4 Shrewsbury, UK NaN \n", "5 Shrewsbury, UK NaN \n", "6 Shrewsbury, UK NaN \n", "7 Shrewsbury, UK NaN \n", "8 Shrewsbury, UK NaN \n", "9 Shrewsbury, UK NaN \n", "10 Shrewsbury, UK NaN \n", "11 Shrewsbury, UK NaN \n", "12 Shrewsbury, UK NaN \n", "13 Shrewsbury, UK NaN \n", "14 Shrewsbury, UK NaN \n", "15 Shrewsbury, UK NaN \n", "16 Shrewsbury, UK NaN \n", "17 Shrewsbury, UK NaN \n", "18 Quarry Park, Shrewsbury, England, GB NaN \n", "19 Shrewsbury, UK Male \n", "20 Shrewsbury, UK NaN \n", "21 Shrewsbury, UK NaN \n", "22 Shrewsbury, UK NaN \n", "23 Shrewsbury, UK NaN \n", "24 Shrewsbury, UK NaN \n", "25 Shrewsbury, UK Female \n", "26 Shrewsbury, UK NaN \n", "27 Shrewsbury, UK NaN \n", "28 Shrewsbury, UK NaN \n", "29 Shrewsbury, UK NaN \n", ".. ... ... \n", "256 SWT garden, Shrewsbury, UK NaN \n", "257 SWT garden, Shrewsbury, UK NaN \n", "258 SWT garden, Shrewsbury, UK NaN \n", "259 SWT garden, Shrewsbury, UK NaN \n", "260 SWT garden, Shrewsbury NaN \n", "261 Aberdyfi dunes, Gwynedd, UK NaN \n", "262 Aberdyfi dunes, Gwynedd, UK NaN \n", "263 Aberdyfi dunes, Gwynedd, UK NaN \n", "264 Aberdyfi dunes, Gwynedd, UK NaN \n", "265 Aberdyfi dunes, Gwynedd, UK NaN \n", "266 Aberdyfi dunes, Gwynedd, UK NaN \n", "267 Railway station car park, Aberdyfi, UK NaN \n", "268 SWT back garden, Shrewsbury, UK NaN \n", "269 SWT back garden, Shrewsbury, UK NaN \n", "270 Path to Gravel Hill Ln, Shrewsbury, UK NaN \n", "271 Severn to Gravel hill path, Shrewsbury, UK NaN \n", "272 Coton Hill Reserve, Shrewsbury, UK NaN \n", "273 Coton Hill Reserve, Shrewsbury, UK NaN \n", "274 Coton Hill reserve, Shrewsbury, UK NaN \n", "275 Shrewsbury, UK NaN \n", "276 Shrewsbury, UK NaN \n", "277 Ditherington to Haughmond path, Shrewsbury, UK NaN \n", "278 By weir, Shrewsbury, UK NaN \n", "279 Water of Leith, Edinburgh, Scotland, GB NaN \n", "280 Inside Darwins Garden, Shrewsbury, UK NaN \n", "281 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "282 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "283 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "284 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "285 Gravel Hill Lane River path, Shrewsbury, UK NaN \n", "\n", " URL species name \\\n", "0 https://www.inaturalist.org/observations/39250370 Bombus terrestris \n", "1 https://www.inaturalist.org/observations/39250371 Anthophora plumipes \n", "2 https://www.inaturalist.org/observations/39251315 Lasius \n", "3 https://www.inaturalist.org/observations/39327032 Bombus \n", "4 https://www.inaturalist.org/observations/39473701 Lasius \n", "5 https://www.inaturalist.org/observations/39552440 Bombus terrestris \n", "6 https://www.inaturalist.org/observations/39591074 Bombus \n", "7 https://www.inaturalist.org/observations/39591086 Bombus terrestris \n", "8 https://www.inaturalist.org/observations/39625489 Vespula vulgaris \n", "9 https://www.inaturalist.org/observations/39631271 Apis mellifera \n", "10 https://www.inaturalist.org/observations/39631276 Apis mellifera \n", "11 https://www.inaturalist.org/observations/39715369 Bombus terrestris \n", "12 https://www.inaturalist.org/observations/39715378 Bombus terrestris \n", "13 https://www.inaturalist.org/observations/39715389 Apis mellifera \n", "14 https://www.inaturalist.org/observations/39715393 Apis mellifera \n", "15 https://www.inaturalist.org/observations/39715394 Bombus \n", "16 https://www.inaturalist.org/observations/39715399 Apis mellifera \n", "17 https://www.inaturalist.org/observations/39861383 Lasius \n", "18 https://www.inaturalist.org/observations/39888544 Bombus terrestris \n", "19 https://www.inaturalist.org/observations/39898953 Anthophora plumipes \n", "20 https://www.inaturalist.org/observations/39898990 Bombus terrestris \n", "21 https://www.inaturalist.org/observations/39919985 Lasius \n", "22 https://www.inaturalist.org/observations/39939555 Bombus terrestris \n", "23 https://www.inaturalist.org/observations/40743094 Apis mellifera \n", "24 https://www.inaturalist.org/observations/40743101 Andrena \n", "25 https://www.inaturalist.org/observations/40743193 Andrena fulva \n", "26 https://www.inaturalist.org/observations/40852332 Bombus terrestris \n", "27 https://www.inaturalist.org/observations/40852590 Bombus terrestris \n", "28 https://www.inaturalist.org/observations/40950761 Anthophora plumipes \n", "29 https://www.inaturalist.org/observations/41565696 Andrena fulva \n", ".. ... ... \n", "256 https://www.inaturalist.org/observations/55550221 Apoidea \n", "257 https://www.inaturalist.org/observations/55550235 Bombus \n", "258 https://www.inaturalist.org/observations/55551088 Lasioglossum \n", "259 https://www.inaturalist.org/observations/55551101 Vespula vulgaris \n", "260 https://www.inaturalist.org/observations/55551525 Vespula \n", "261 https://www.inaturalist.org/observations/55579733 Pompilus cinereus \n", "262 https://www.inaturalist.org/observations/55582241 Cerceris arenaria \n", "263 https://www.inaturalist.org/observations/55583899 Pompilidae \n", "264 https://www.inaturalist.org/observations/55585163 Myrmicinae \n", "265 https://www.inaturalist.org/observations/55585578 Formicinae \n", "266 https://www.inaturalist.org/observations/55585594 Myrmicinae \n", "267 https://www.inaturalist.org/observations/55585789 Formica \n", "268 https://www.inaturalist.org/observations/55623697 Bombus \n", "269 https://www.inaturalist.org/observations/55623716 Lasius \n", "270 https://www.inaturalist.org/observations/56205550 Colletes \n", "271 https://www.inaturalist.org/observations/56205835 Lasioglossum \n", "272 https://www.inaturalist.org/observations/56248606 Vespula germanica \n", "273 https://www.inaturalist.org/observations/56249505 Leptothorax acervorum \n", "274 https://www.inaturalist.org/observations/56250275 Gorytina \n", "275 https://www.inaturalist.org/observations/56269605 Colletes \n", "276 https://www.inaturalist.org/observations/56272552 Formica fusca-group \n", "277 https://www.inaturalist.org/observations/56304972 Myrmica \n", "278 https://www.inaturalist.org/observations/56305331 Vespula \n", "279 https://www.inaturalist.org/observations/58373777 Bombus lucorum \n", "280 https://www.inaturalist.org/observations/66692754 Aculeata \n", "281 https://www.inaturalist.org/observations/66714889 Apis mellifera \n", "282 https://www.inaturalist.org/observations/66715568 Lasioglossum \n", "283 https://www.inaturalist.org/observations/66752979 Mellinus arvensis \n", "284 https://www.inaturalist.org/observations/66753325 Mellinus arvensis \n", "285 https://www.inaturalist.org/observations/66753327 Crabronidae \n", "\n", " x Media Path 0 \\\n", "0 https://static.inaturalist.org/photos/62246856... \n", "1 https://static.inaturalist.org/photos/62247532... \n", "2 https://static.inaturalist.org/photos/62248710... \n", "3 https://static.inaturalist.org/photos/62376509... \n", "4 https://static.inaturalist.org/photos/62631721... \n", "5 https://static.inaturalist.org/photos/62761539... \n", "6 https://static.inaturalist.org/photos/62825251... \n", "7 https://static.inaturalist.org/photos/62825288... \n", "8 https://static.inaturalist.org/photos/62883645... \n", "9 https://static.inaturalist.org/photos/62893646... \n", "10 https://static.inaturalist.org/photos/62893663... \n", "11 https://static.inaturalist.org/photos/63035359... \n", "12 https://static.inaturalist.org/photos/63035375... \n", "13 https://static.inaturalist.org/photos/63035440... \n", "14 https://static.inaturalist.org/photos/63035455... \n", "15 https://static.inaturalist.org/photos/63035475... \n", "16 https://static.inaturalist.org/photos/63035519... \n", "17 https://static.inaturalist.org/photos/63282543... \n", "18 https://static.inaturalist.org/photos/63330073... \n", "19 https://static.inaturalist.org/photos/63347643... \n", "20 https://static.inaturalist.org/photos/63347853... \n", "21 https://static.inaturalist.org/photos/63384135... \n", "22 https://static.inaturalist.org/photos/63417463... \n", "23 https://static.inaturalist.org/photos/64590313... \n", "24 https://static.inaturalist.org/photos/64590349... \n", "25 https://static.inaturalist.org/photos/64590668... \n", "26 https://static.inaturalist.org/photos/64764400... \n", "27 https://static.inaturalist.org/photos/64764892... \n", "28 https://static.inaturalist.org/photos/64928260... \n", "29 https://static.inaturalist.org/photos/65946914... \n", ".. ... \n", "256 https://static.inaturalist.org/photos/88461322... \n", "257 https://static.inaturalist.org/photos/88461484... \n", "258 https://static.inaturalist.org/photos/88462090... \n", "259 https://static.inaturalist.org/photos/88462307... \n", "260 https://static.inaturalist.org/photos/88463479... \n", "261 https://static.inaturalist.org/photos/88511938... \n", "262 https://static.inaturalist.org/photos/88516361... \n", "263 https://static.inaturalist.org/photos/88519190... \n", "264 https://static.inaturalist.org/photos/88521702... \n", "265 https://static.inaturalist.org/photos/88522150... \n", "266 https://static.inaturalist.org/photos/88522272... \n", "267 https://static.inaturalist.org/photos/88522958... \n", "268 https://static.inaturalist.org/photos/88583184... \n", "269 https://static.inaturalist.org/photos/88583418... \n", "270 https://static.inaturalist.org/photos/89553081... \n", "271 https://static.inaturalist.org/photos/89554279... \n", "272 https://static.inaturalist.org/photos/89623073... \n", "273 https://static.inaturalist.org/photos/89624178... \n", "274 https://static.inaturalist.org/photos/89625619... \n", "275 https://static.inaturalist.org/photos/89658772... \n", "276 https://static.inaturalist.org/photos/89663370... \n", "277 https://static.inaturalist.org/photos/89718522... \n", "278 https://static.inaturalist.org/photos/89719015... \n", "279 https://static.inaturalist.org/photos/93190269... \n", "280 https://static.inaturalist.org/photos/10757133... \n", "281 https://static.inaturalist.org/photos/10761061... \n", "282 https://static.inaturalist.org/photos/10761345... \n", "283 https://static.inaturalist.org/photos/10768097... \n", "284 https://static.inaturalist.org/photos/10768166... \n", "285 https://static.inaturalist.org/photos/10768167... \n", "\n", " x Media Path 1 \\\n", "0 https://static.inaturalist.org/photos/62246841... \n", "1 https://static.inaturalist.org/photos/62247471... \n", "2 https://static.inaturalist.org/photos/62248693... \n", "3 https://static.inaturalist.org/photos/62376512... \n", "4 https://static.inaturalist.org/photos/62631724... \n", "5 https://static.inaturalist.org/photos/62761549... \n", "6 https://static.inaturalist.org/photos/62825253... \n", "7 https://static.inaturalist.org/photos/62825290... \n", "8 https://static.inaturalist.org/photos/62883625... \n", "9 https://static.inaturalist.org/photos/62893648... \n", "10 https://static.inaturalist.org/photos/62893655... \n", "11 https://static.inaturalist.org/photos/63035545... \n", "12 https://static.inaturalist.org/photos/63035373... \n", "13 https://static.inaturalist.org/photos/63035435... \n", "14 NaN \n", "15 https://static.inaturalist.org/photos/63035460... \n", "16 https://static.inaturalist.org/photos/63035516... \n", "17 https://static.inaturalist.org/photos/63282541... \n", "18 https://static.inaturalist.org/photos/63330050... \n", "19 https://static.inaturalist.org/photos/63347647... \n", "20 https://static.inaturalist.org/photos/63347857... \n", "21 https://static.inaturalist.org/photos/63384127... \n", "22 https://static.inaturalist.org/photos/63417443... \n", "23 NaN \n", "24 NaN \n", "25 https://static.inaturalist.org/photos/64590666... \n", "26 https://static.inaturalist.org/photos/64764392... \n", "27 https://static.inaturalist.org/photos/64764890... \n", "28 NaN \n", "29 NaN \n", ".. ... \n", "256 https://static.inaturalist.org/photos/88461313... \n", "257 https://static.inaturalist.org/photos/88461490... \n", "258 https://static.inaturalist.org/photos/88462051... \n", "259 https://static.inaturalist.org/photos/88462301... \n", "260 https://static.inaturalist.org/photos/88463487... \n", "261 https://static.inaturalist.org/photos/88511935... \n", "262 https://static.inaturalist.org/photos/88516357... \n", "263 https://static.inaturalist.org/photos/88519188... \n", "264 NaN \n", "265 https://static.inaturalist.org/photos/88522153... \n", "266 https://static.inaturalist.org/photos/88522287... \n", "267 https://static.inaturalist.org/photos/88522952... \n", "268 https://static.inaturalist.org/photos/88583169... \n", "269 https://static.inaturalist.org/photos/88583321... \n", "270 https://static.inaturalist.org/photos/89553073... \n", "271 https://static.inaturalist.org/photos/89554284... \n", "272 https://static.inaturalist.org/photos/89623012... \n", "273 NaN \n", "274 https://static.inaturalist.org/photos/89625609... \n", "275 https://static.inaturalist.org/photos/89658764... \n", "276 https://static.inaturalist.org/photos/89663320... \n", "277 https://static.inaturalist.org/photos/89718495... \n", "278 https://static.inaturalist.org/photos/89719007... \n", "279 NaN \n", "280 https://static.inaturalist.org/photos/10757132... \n", "281 https://static.inaturalist.org/photos/10761061... \n", "282 https://static.inaturalist.org/photos/10761345... \n", "283 https://static.inaturalist.org/photos/10768097... \n", "284 https://static.inaturalist.org/photos/10768166... \n", "285 https://static.inaturalist.org/photos/10768168... \n", "\n", " x Media Path 2 Recorder Name \n", "0 https://static.inaturalist.org/photos/62246865... John Smith \n", "1 https://static.inaturalist.org/photos/62247483... John Smith \n", "2 https://static.inaturalist.org/photos/62248700... John Smith \n", "3 https://static.inaturalist.org/photos/62376513... John Smith \n", "4 https://static.inaturalist.org/photos/62631727... John Smith \n", "5 https://static.inaturalist.org/photos/62761551... John Smith \n", "6 https://static.inaturalist.org/photos/62825255... John Smith \n", "7 https://static.inaturalist.org/photos/62825295... John Smith \n", "8 https://static.inaturalist.org/photos/62883630... John Smith \n", "9 https://static.inaturalist.org/photos/62893650... John Smith \n", "10 https://static.inaturalist.org/photos/62893669... John Smith \n", "11 NaN John Smith \n", "12 NaN John Smith \n", "13 NaN John Smith \n", "14 NaN John Smith \n", "15 https://static.inaturalist.org/photos/63035469... John Smith \n", "16 NaN John Smith \n", "17 https://static.inaturalist.org/photos/63282547... John Smith \n", "18 NaN John Smith \n", "19 https://static.inaturalist.org/photos/63347650... John Smith \n", "20 https://static.inaturalist.org/photos/63347865... John Smith \n", "21 https://static.inaturalist.org/photos/63384129... John Smith \n", "22 https://static.inaturalist.org/photos/63417446... John Smith \n", "23 NaN John Smith \n", "24 NaN John Smith \n", "25 https://static.inaturalist.org/photos/64590665... John Smith \n", "26 https://static.inaturalist.org/photos/64764413... John Smith \n", "27 https://static.inaturalist.org/photos/64764904... John Smith \n", "28 NaN John Smith \n", "29 NaN John Smith \n", ".. ... ... \n", "256 https://static.inaturalist.org/photos/88461307... John Smith \n", "257 https://static.inaturalist.org/photos/88461497... John Smith \n", "258 https://static.inaturalist.org/photos/88462063... John Smith \n", "259 https://static.inaturalist.org/photos/88462315... John Smith \n", "260 https://static.inaturalist.org/photos/88463498... John Smith \n", "261 https://static.inaturalist.org/photos/88511943... John Smith \n", "262 https://static.inaturalist.org/photos/88516353... John Smith \n", "263 https://static.inaturalist.org/photos/88519196... John Smith \n", "264 NaN John Smith \n", "265 NaN John Smith \n", "266 https://static.inaturalist.org/photos/88522281... John Smith \n", "267 NaN John Smith \n", "268 https://static.inaturalist.org/photos/88583201... John Smith \n", "269 https://static.inaturalist.org/photos/88583334... John Smith \n", "270 https://static.inaturalist.org/photos/89553076... John Smith \n", "271 NaN John Smith \n", "272 https://static.inaturalist.org/photos/89623052... John Smith \n", "273 NaN John Smith \n", "274 https://static.inaturalist.org/photos/89625625... John Smith \n", "275 https://static.inaturalist.org/photos/89658779... John Smith \n", "276 https://static.inaturalist.org/photos/89663326... John Smith \n", "277 https://static.inaturalist.org/photos/89718500... John Smith \n", "278 https://static.inaturalist.org/photos/89719028... John Smith \n", "279 NaN John Smith \n", "280 https://static.inaturalist.org/photos/10757132... John Smith \n", "281 NaN John Smith \n", "282 https://static.inaturalist.org/photos/10761344... John Smith \n", "283 NaN John Smith \n", "284 https://static.inaturalist.org/photos/10768165... John Smith \n", "285 https://static.inaturalist.org/photos/10768167... John Smith \n", "\n", "[286 rows x 10 columns]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_final['Recorder Name']='John Smith'\n", "df_final" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
\n", "
\n", "SAVE TO HARD DRIVE\n", "
\n", "Edit the name of the csv file here according to whatever you like.
\n", "It should save the file to the same place you have saved the .ipynb Jupyter Notebook file.
\n", "If you are using in the browser online, it will be visible in the home page browser tab and from there you can select and download." ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Spreadsheet ready to use! \n" ] } ], "source": [ "df_final.to_csv(r'empididae2020JSmith.csv', index = False, header=True)\n", "print(\"Spreadsheet ready to use! \")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
\n", "
\n", " TO IMPORT TO iRECORD \n", "
\n", "Go to https://www.brc.ac.uk/irecord/import-records and upload your new csv file.
\n", "Use survey name \"iRecord Import\".\n", "\n", "The column names should equate roughly to those in iRecord...
\n", "e.g. my column is named \"x Media Path 0\" and in iRecord there is an option for \"Media Path 1\"\n", "I have been adding the URL as Media Path 4 which is then illustrated as a link in my records.\n", "You can also rename the columns as you like in the code above, and ask iRecord to remember the mapping.\n", "\n", "NOTE - Start with just a few!
\n", "You can upload by the hundreds, but you have to delete them one at a time, as there is no other way. \n", " This is very time consuming, so start small.\n", " \n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "-" ] } ], "metadata": { "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.8" } }, "nbformat": 4, "nbformat_minor": 4 }