diff --git a/SQLCreate.ipynb b/SQLCreate-SQLMagic.ipynb similarity index 100% rename from SQLCreate.ipynb rename to SQLCreate-SQLMagic.ipynb diff --git a/SpatialSQL.ipynb b/SpatialSQL.ipynb index 80dd170..e462d5e 100644 --- a/SpatialSQL.ipynb +++ b/SpatialSQL.ipynb @@ -1,93 +1,225 @@ { "cells": [ { "cell_type": "code", - "execution_count": null, + "execution_count": 1, "id": "18414ef7-739d-47b9-b3ef-ffe8ff29cfa8", "metadata": {}, "outputs": [], "source": [ "# Importing libraries\n", "import sqlite3\n", "import pandas" ] }, { "cell_type": "markdown", "id": "39742f38-5f10-4088-8423-27798c3235ac", "metadata": {}, "source": [ "D'abord on établit une connexion à la base de données :" ] }, { "cell_type": "code", - "execution_count": null, + "execution_count": 2, "id": "40eb692d-b7f0-4c1f-96f5-8e99e54d2921", "metadata": {}, "outputs": [], "source": [ "# Etablir la connexion à la base de données\n", "con = sqlite3.connect(\"india.sqlite\")" ] }, { "cell_type": "code", - "execution_count": null, + "execution_count": 3, "id": "7a8829ae-6f4a-45a7-b8d5-3f84751cbca0", "metadata": {}, "outputs": [], "source": [ "# Charger l'extension spatialite\n", "con.enable_load_extension(True)\n", "con.load_extension(\"mod_spatialite\")" ] }, { "cell_type": "code", - "execution_count": null, + "execution_count": 4, "id": "2799208d-39ee-48af-bc2c-c3ceca3c3f06", "metadata": {}, - "outputs": [], + "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", + "
ID
03593.0
13594.0
23604.0
33605.0
43635.0
53666.0
63682.0
73694.0
83734.0
93735.0
103747.0
113757.0
123758.0
133760.0
143762.0
153763.0
163764.0
173826.0
183827.0
\n", + "
" + ], + "text/plain": [ + " ID\n", + "0 3593.0\n", + "1 3594.0\n", + "2 3604.0\n", + "3 3605.0\n", + "4 3635.0\n", + "5 3666.0\n", + "6 3682.0\n", + "7 3694.0\n", + "8 3734.0\n", + "9 3735.0\n", + "10 3747.0\n", + "11 3757.0\n", + "12 3758.0\n", + "13 3760.0\n", + "14 3762.0\n", + "15 3763.0\n", + "16 3764.0\n", + "17 3826.0\n", + "18 3827.0" + ] + }, + "metadata": {}, + "output_type": "display_data" + } + ], "source": [ "# Donner la requête à executer\n", "query = 'SELECT DISTINCT Cultivated_Fields.ID FROM Cultivated_Fields, Roads WHERE Distance(Cultivated_Fields.Geometry, Roads.Geometry) <10 and Roads.Type=\"double\"'\n", "\n", "# Executer la requête et récupérer la table résultat\n", "resulttable = pandas.read_sql_query(query, con)\n", "\n", "# Afficher la table résultat\n", "display(resulttable)" ] }, { "cell_type": "code", "execution_count": null, "id": "0450c8de-85d0-4e19-96e9-7bd942e8b410", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.10" } }, "nbformat": 4, "nbformat_minor": 5 }