{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "01564245-66da-4368-bd0d-09b9669ab06c", "metadata": {}, "outputs": [], "source": [ "from shapely.wkt import loads\n", "geom = loads(\"POLYGON((-1.26 51.75, -1.25 51.75, -1.25 51.76, -1.26 51.76, -1.26 51.75))\")\n" ] }, { "cell_type": "code", "execution_count": 2, "id": "a7299dc8-dcb5-45a1-9a8e-1e1f7b371e41", "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "POLYGON ((-1.26 51.75, -1.25 51.75, -1.25 51.76, -1.26 51.76, -1.26 51.75))\n", "POLYGON ((451181.8067423534 205959.42761765362, 451872.1365434999 205966.47458434716, 451860.70613464457 207078.6670373804, 451170.5288039437 207071.62065761362, 451181.8067423534 205959.42761765362))\n" ] } ], "source": [ "import geopandas as gpd\n", "buffer_m=1000\n", "gdf_latlon = gpd.GeoDataFrame(geometry=[geom], crs=\"EPSG:4326\")\n", "print(gdf_latlon.iloc[0].geometry)\n", "gdf_ukgrid=gdf_latlon.to_crs(27700)\n", "print(gdf_ukgrid.iloc[0].geometry)\n" ] }, { "cell_type": "code", "execution_count": null, "id": "83b6c19e-5ce4-44fe-8eb0-18da642233bc", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 6, "id": "0adcd724-8b5d-4f7d-8d54-5843e59ef51e", "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "POLYGON ((449202.1904339386 203939.11526180914, 449150.35352661525 209051.0998678343, 453840.0482665709 209098.97940351022, 453892.58599731687 203986.99536384118, 449202.1904339386 203939.11526180914))\n" ] } ], "source": [ "gdf_ukgrid[\"geometry\"] = gdf_ukgrid.buffer(buffer_m,resolution=4, join_style=\"mitre\")\n", "print(gdf_ukgrid.iloc[0].geometry)\n" ] }, { "cell_type": "code", "execution_count": 7, "id": "06179dda-8765-4d8a-8a35-9cba58219cbf", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "POLYGON ((-1.2889586296821363 51.73201354199302, -1.2889880438846308 51.777976757023254, -1.2210119164828335 51.777976650545504, -1.2210413306757637 51.7320136485258, -1.2889586296821363 51.73201354199302))\n" ] } ], "source": [ "gdf_buffered_latlon = gdf_ukgrid.to_crs(4326)\n", "wkt_with_buffer = gdf_buffered_latlon.iloc[0].geometry\n", "print(wkt_with_buffer)\n" ] }, { "cell_type": "code", "execution_count": 9, "id": "8454068e-a274-486e-a0b7-97ec03aabec3", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
Make this Notebook Trusted to load map: File -> Trust Notebook
" ], "text/plain": [ "" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "gdf_buffered_latlon.explore()" ] }, { "cell_type": "markdown", "id": "333e112c-8e37-412f-800e-8ac4a3ea5732", "metadata": {}, "source": [ "These are teh recognisable lists we are interested in for the MVP\n", "\n", "Protected lists \n", "WCA Schedule 5 (dr2402)\n", "Schedule 1 (Birds) (dr2413)\n", "Schedule 8 (Plants) (dr2414)\n", "\n", "Priority lists\n", "NERC Section 41 (England) (dr590)\n", "UK BAP Priority Species (dr583)\n", "\n", "\n", "Now get the species counts for all these lists\n" ] }, { "cell_type": "code", "execution_count": 30, "id": "cc4194ef-9ed6-4773-85ac-0bd32ad0b8f2", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "https://records-ws.nbnatlas.org/occurrence/facets?facets=taxon_name&flimit=0&q=((species_list_uid%3A\"dr2402\" OR species_list_uid%3A\"dr2413\" OR species_list_uid%3A\"dr2414\" OR species_list_uid%3A\"dr590\" OR species_list_uid%3A\"dr583\") AND -(occurrence_status%3A\"absent\" OR identification_verification_status%3A\"Unconfirmed\" OR identification_verification_status%3A\"Unconfirmed - not reviewed\" OR identification_verification_status%3A\"Unconfirmed - plausible\"))&wkt=POLYGON((-1.26 51.75, -1.25 51.75, -1.25 51.76, -1.26 51.76, -1.26 51.75))\n" ] } ], "source": [ "import requests\n", "QUERY_A_TOP_SPECIES_COUNTS_BASE_URL = 'https://records-ws.nbnatlas.org/occurrence/facets?facets=taxon_name&flimit=2&q=((species_list_uid%3A\"dr2402\" OR species_list_uid%3A\"dr2413\" OR species_list_uid%3A\"dr2414\" OR species_list_uid%3A\"dr590\" OR species_list_uid%3A\"dr583\") AND -(occurrence_status%3A\"absent\" OR identification_verification_status%3A\"Unconfirmed\" OR identification_verification_status%3A\"Unconfirmed - not reviewed\" OR identification_verification_status%3A\"Unconfirmed - plausible\"))'\n", "url = QUERY_A_TOP_SPECIES_COUNTS_BASE_URL + '&wkt=POLYGON((-1.26 51.75, -1.25 51.75, -1.25 51.76, -1.26 51.76, -1.26 51.75))'\n", "print(url)\n", "\n" ] }, { "cell_type": "code", "execution_count": null, "id": "4a766bb4-681a-4eeb-848a-5b72dbc0fea8", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 31, "id": "810ddfa1-fc14-4a7c-b59b-7c6487024e85", "metadata": {}, "outputs": [], "source": [ "response = requests.get(url)\n", "data = response.json()\n", "\n", "for fieldResult in data[0][\"fieldResult\"]:\n", " print(f'{fieldResult[\"label\"]} {fieldResult[\"count\"]}')" ] }, { "cell_type": "code", "execution_count": 32, "id": "66474e6c-0b1f-4b41-8d59-7d418ae3369c", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[{'fieldName': 'taxon_name', 'fieldResult': [], 'count': 45}]\n" ] } ], "source": [ "print(data)" ] }, { "cell_type": "code", "execution_count": 33, "id": "5c7ed4bd-8993-4135-87c3-a910c822ac3b", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[{'fieldName': 'taxon_name', 'fieldResult': [], 'count': 45}]\n" ] } ], "source": [ "QUERY_A2_UNIQUE_SPECIES_COUNT_BASE_URL = 'https://records-ws.nbnatlas.org/occurrence/facets?facets=taxon_name&flimit=0&q=((species_list_uid%3A\"dr2402\" OR species_list_uid%3A\"dr2413\" OR species_list_uid%3A\"dr2414\" OR species_list_uid%3A\"dr590\" OR species_list_uid%3A\"dr583\") AND -(occurrence_status%3A\"absent\" OR identification_verification_status%3A\"Unconfirmed\" OR identification_verification_status%3A\"Unconfirmed - not reviewed\" OR identification_verification_status%3A\"Unconfirmed - plausible\"))'\n", "url = QUERY_A2_UNIQUE_SPECIES_COUNT_BASE_URL+f'&species_list_uid=dr2402&wkt={wkt_with_buffer}'\n", "response = requests.get(url)\n", "\n", "data = response.json()\n", "print(data)" ] }, { "cell_type": "code", "execution_count": 34, "id": "0d9d6966-4a4a-44c8-a099-dab566824920", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "{'firstname': 'john', 'lastname': 'jones', 'age': 21}\n" ] } ], "source": [ "tmp_dict = {'firstname':'john', 'lastname':'jones'}\n", "new_dict = {**tmp_dict,'age':21}\n", "print(new_dict)" ] }, { "cell_type": "code", "execution_count": null, "id": "7c98fc1d-9f68-4b21-b6b7-c90a77f54291", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python (species-alert-report)", "language": "python", "name": "species-alert-report" }, "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.9.6" } }, "nbformat": 4, "nbformat_minor": 5 }