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", + " | ID | \n", + "
---|---|
0 | \n", + "3593.0 | \n", + "
1 | \n", + "3594.0 | \n", + "
2 | \n", + "3604.0 | \n", + "
3 | \n", + "3605.0 | \n", + "
4 | \n", + "3635.0 | \n", + "
5 | \n", + "3666.0 | \n", + "
6 | \n", + "3682.0 | \n", + "
7 | \n", + "3694.0 | \n", + "
8 | \n", + "3734.0 | \n", + "
9 | \n", + "3735.0 | \n", + "
10 | \n", + "3747.0 | \n", + "
11 | \n", + "3757.0 | \n", + "
12 | \n", + "3758.0 | \n", + "
13 | \n", + "3760.0 | \n", + "
14 | \n", + "3762.0 | \n", + "
15 | \n", + "3763.0 | \n", + "
16 | \n", + "3764.0 | \n", + "
17 | \n", + "3826.0 | \n", + "
18 | \n", + "3827.0 | \n", + "