diff --git a/Alternative-spatial.ipynb b/Alternative-spatial.ipynb
new file mode 100644
index 0000000..d3836e0
--- /dev/null
+++ b/Alternative-spatial.ipynb
@@ -0,0 +1,134 @@
+{
+ "cells": [
+ {
+ "cell_type": "code",
+ "execution_count": 1,
+ "id": "18414ef7-739d-47b9-b3ef-ffe8ff29cfa8",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Importing libraries\n",
+ "import pysqlite3 as 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": 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": 3,
+ "id": "7a8829ae-6f4a-45a7-b8d5-3f84751cbca0",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "con.enable_load_extension(True)\n",
+ "con.load_extension(\"mod_spatialite\")"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 4,
+ "id": "2799208d-39ee-48af-bc2c-c3ceca3c3f06",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/html": [
+ "
\n",
+ "\n",
+ "
\n",
+ " \n",
+ " \n",
+ " | \n",
+ " geometry_wkt | \n",
+ "
\n",
+ " \n",
+ " \n",
+ " \n",
+ " 0 | \n",
+ " MULTIPOLYGON(((126129.082245 2482584.373409, 1... | \n",
+ "
\n",
+ " \n",
+ "
\n",
+ "
"
+ ],
+ "text/plain": [
+ " geometry_wkt\n",
+ "0 MULTIPOLYGON(((126129.082245 2482584.373409, 1..."
+ ]
+ },
+ "metadata": {},
+ "output_type": "display_data"
+ }
+ ],
+ "source": [
+ "# Donner la requête à executer\n",
+ "query = \"select AsText(geometry) as geometry_wkt from Village\"\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": "py_spatial",
+ "language": "python",
+ "name": "py_spatial"
+ },
+ "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
+}
diff --git a/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.dbf b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.dbf
new file mode 100644
index 0000000..a577bc9
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.dbf differ
diff --git a/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.prj b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.prj
new file mode 100644
index 0000000..a3cdcc9
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.prj
@@ -0,0 +1 @@
+PROJCS["Kalianpur_1975_UTM_zone_43N",GEOGCS["GCS_Kalianpur 1975",DATUM["D_Kalianpur_1975",SPHEROID["Everest_1830_1975_Definition",6377299.151,300.8017255]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["Meter",1]]
\ No newline at end of file
diff --git a/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.qpj b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.qpj
new file mode 100644
index 0000000..ce247bd
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.qpj
@@ -0,0 +1 @@
+PROJCS["Kalianpur 1975 / UTM zone 43N",GEOGCS["Kalianpur 1975",DATUM["Kalianpur_1975",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],TOWGS84[295,736,257,0,0,0,0],AUTHORITY["EPSG","6146"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4146"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","24343"]]
diff --git a/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.shp b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.shp
new file mode 100644
index 0000000..23a1667
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.shp differ
diff --git a/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.shx b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.shx
new file mode 100644
index 0000000..eff2588
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Cultivated_Fields.shx differ
diff --git a/Exercises/12 SQL spatial geom/Data/Roads.dbf b/Exercises/12 SQL spatial geom/Data/Roads.dbf
new file mode 100644
index 0000000..5f8e5c6
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Roads.dbf differ
diff --git a/Exercises/12 SQL spatial geom/Data/Roads.prj b/Exercises/12 SQL spatial geom/Data/Roads.prj
new file mode 100644
index 0000000..a3cdcc9
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Roads.prj
@@ -0,0 +1 @@
+PROJCS["Kalianpur_1975_UTM_zone_43N",GEOGCS["GCS_Kalianpur 1975",DATUM["D_Kalianpur_1975",SPHEROID["Everest_1830_1975_Definition",6377299.151,300.8017255]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["Meter",1]]
\ No newline at end of file
diff --git a/Exercises/12 SQL spatial geom/Data/Roads.qpj b/Exercises/12 SQL spatial geom/Data/Roads.qpj
new file mode 100644
index 0000000..ce247bd
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Roads.qpj
@@ -0,0 +1 @@
+PROJCS["Kalianpur 1975 / UTM zone 43N",GEOGCS["Kalianpur 1975",DATUM["Kalianpur_1975",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],TOWGS84[295,736,257,0,0,0,0],AUTHORITY["EPSG","6146"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4146"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","24343"]]
diff --git a/Exercises/12 SQL spatial geom/Data/Roads.shp b/Exercises/12 SQL spatial geom/Data/Roads.shp
new file mode 100644
index 0000000..29e5f26
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Roads.shp differ
diff --git a/Exercises/12 SQL spatial geom/Data/Roads.shx b/Exercises/12 SQL spatial geom/Data/Roads.shx
new file mode 100644
index 0000000..5c444ab
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Roads.shx differ
diff --git a/Exercises/12 SQL spatial geom/Data/Streams.dbf b/Exercises/12 SQL spatial geom/Data/Streams.dbf
new file mode 100644
index 0000000..10dccc5
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Streams.dbf differ
diff --git a/Exercises/12 SQL spatial geom/Data/Streams.prj b/Exercises/12 SQL spatial geom/Data/Streams.prj
new file mode 100644
index 0000000..a3cdcc9
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Streams.prj
@@ -0,0 +1 @@
+PROJCS["Kalianpur_1975_UTM_zone_43N",GEOGCS["GCS_Kalianpur 1975",DATUM["D_Kalianpur_1975",SPHEROID["Everest_1830_1975_Definition",6377299.151,300.8017255]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["Meter",1]]
\ No newline at end of file
diff --git a/Exercises/12 SQL spatial geom/Data/Streams.qpj b/Exercises/12 SQL spatial geom/Data/Streams.qpj
new file mode 100644
index 0000000..ce247bd
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Streams.qpj
@@ -0,0 +1 @@
+PROJCS["Kalianpur 1975 / UTM zone 43N",GEOGCS["Kalianpur 1975",DATUM["Kalianpur_1975",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],TOWGS84[295,736,257,0,0,0,0],AUTHORITY["EPSG","6146"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4146"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","24343"]]
diff --git a/Exercises/12 SQL spatial geom/Data/Streams.shp b/Exercises/12 SQL spatial geom/Data/Streams.shp
new file mode 100644
index 0000000..3424488
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Streams.shp differ
diff --git a/Exercises/12 SQL spatial geom/Data/Streams.shx b/Exercises/12 SQL spatial geom/Data/Streams.shx
new file mode 100644
index 0000000..f32d462
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Streams.shx differ
diff --git a/Exercises/12 SQL spatial geom/Data/Village.dbf b/Exercises/12 SQL spatial geom/Data/Village.dbf
new file mode 100644
index 0000000..f456769
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Village.dbf differ
diff --git a/Exercises/12 SQL spatial geom/Data/Village.prj b/Exercises/12 SQL spatial geom/Data/Village.prj
new file mode 100644
index 0000000..a3cdcc9
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Village.prj
@@ -0,0 +1 @@
+PROJCS["Kalianpur_1975_UTM_zone_43N",GEOGCS["GCS_Kalianpur 1975",DATUM["D_Kalianpur_1975",SPHEROID["Everest_1830_1975_Definition",6377299.151,300.8017255]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["Meter",1]]
\ No newline at end of file
diff --git a/Exercises/12 SQL spatial geom/Data/Village.qpj b/Exercises/12 SQL spatial geom/Data/Village.qpj
new file mode 100644
index 0000000..ce247bd
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Village.qpj
@@ -0,0 +1 @@
+PROJCS["Kalianpur 1975 / UTM zone 43N",GEOGCS["Kalianpur 1975",DATUM["Kalianpur_1975",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],TOWGS84[295,736,257,0,0,0,0],AUTHORITY["EPSG","6146"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4146"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","24343"]]
diff --git a/Exercises/12 SQL spatial geom/Data/Village.shp b/Exercises/12 SQL spatial geom/Data/Village.shp
new file mode 100644
index 0000000..3d6037a
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Village.shp differ
diff --git a/Exercises/12 SQL spatial geom/Data/Village.shx b/Exercises/12 SQL spatial geom/Data/Village.shx
new file mode 100644
index 0000000..1a530a2
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Village.shx differ
diff --git a/Exercises/12 SQL spatial geom/Data/Wells.dbf b/Exercises/12 SQL spatial geom/Data/Wells.dbf
new file mode 100644
index 0000000..147d1a4
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Wells.dbf differ
diff --git a/Exercises/12 SQL spatial geom/Data/Wells.prj b/Exercises/12 SQL spatial geom/Data/Wells.prj
new file mode 100644
index 0000000..a3cdcc9
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Wells.prj
@@ -0,0 +1 @@
+PROJCS["Kalianpur_1975_UTM_zone_43N",GEOGCS["GCS_Kalianpur 1975",DATUM["D_Kalianpur_1975",SPHEROID["Everest_1830_1975_Definition",6377299.151,300.8017255]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["Meter",1]]
\ No newline at end of file
diff --git a/Exercises/12 SQL spatial geom/Data/Wells.qpj b/Exercises/12 SQL spatial geom/Data/Wells.qpj
new file mode 100644
index 0000000..ce247bd
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/Wells.qpj
@@ -0,0 +1 @@
+PROJCS["Kalianpur 1975 / UTM zone 43N",GEOGCS["Kalianpur 1975",DATUM["Kalianpur_1975",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],TOWGS84[295,736,257,0,0,0,0],AUTHORITY["EPSG","6146"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4146"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",75],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","24343"]]
diff --git a/Exercises/12 SQL spatial geom/Data/Wells.shp b/Exercises/12 SQL spatial geom/Data/Wells.shp
new file mode 100644
index 0000000..52f3217
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Wells.shp differ
diff --git a/Exercises/12 SQL spatial geom/Data/Wells.shx b/Exercises/12 SQL spatial geom/Data/Wells.shx
new file mode 100644
index 0000000..c941325
Binary files /dev/null and b/Exercises/12 SQL spatial geom/Data/Wells.shx differ
diff --git a/Exercises/12 SQL spatial geom/Data/spatial_query.qgs b/Exercises/12 SQL spatial geom/Data/spatial_query.qgs
new file mode 100644
index 0000000..60823f1
--- /dev/null
+++ b/Exercises/12 SQL spatial geom/Data/spatial_query.qgs
@@ -0,0 +1,703 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ meters
+
+ 7944444.35757209174335003
+ 2559345.74172070994973183
+ 7948511.93448423407971859
+ 2563590.1698029451072216
+
+ 1
+
+
+ +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs
+ 3857
+ 3857
+ EPSG:3857
+ WGS 84 / Pseudo Mercator
+ merc
+ WGS84
+ false
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ - Village20140804154115290
+ - Cultivated_Fields20140804154115208
+ - Roads20140804154115228
+ - Streams20140804154115270
+ - Wells20140804154115332
+
+
+
+
+
+ Cultivated_Fields20140804154115208
+ ./Cultivated_Fields.shp
+
+
+
+
+
+ Cultivated_Fields
+
+
+ +proj=utm +zone=43 +a=6377299.151 +b=6356098.145120132 +towgs84=295,736,257,0,0,0,0 +units=m +no_defs
+ 2052
+ 24343
+ EPSG:24343
+ Kalianpur 1975 / UTM zone 43N
+ utm
+
+ false
+
+
+ ogr
+ COALESCE( "ID", '<NULL>' )
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ ID
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+ 0
+ .
+ generatedlayout
+
+
+
+
+
+ Roads20140804154115228
+ ./Roads.shp
+
+
+
+
+
+ Roads
+
+
+ +proj=utm +zone=43 +a=6377299.151 +b=6356098.145120132 +towgs84=295,736,257,0,0,0,0 +units=m +no_defs
+ 2052
+ 24343
+ EPSG:24343
+ Kalianpur 1975 / UTM zone 43N
+ utm
+
+ false
+
+
+ ogr
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ ID
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+ 0
+ .
+ generatedlayout
+
+
+
+
+
+ Streams20140804154115270
+ ./Streams.shp
+
+
+
+
+
+ Streams
+
+
+ +proj=utm +zone=43 +a=6377299.151 +b=6356098.145120132 +towgs84=295,736,257,0,0,0,0 +units=m +no_defs
+ 2052
+ 24343
+ EPSG:24343
+ Kalianpur 1975 / UTM zone 43N
+ utm
+
+ false
+
+
+ ogr
+ COALESCE( "ID", '<NULL>' )
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ ID
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+ 0
+ .
+ generatedlayout
+
+
+
+
+
+ Village20140804154115290
+ ./Village.shp
+
+
+
+
+
+ Village
+
+
+ +proj=utm +zone=43 +a=6377299.151 +b=6356098.145120132 +towgs84=295,736,257,0,0,0,0 +units=m +no_defs
+ 2052
+ 24343
+ EPSG:24343
+ Kalianpur 1975 / UTM zone 43N
+ utm
+
+ false
+
+
+ ogr
+ COALESCE( "ID", '<NULL>' )
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ ID
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+ 0
+ .
+ generatedlayout
+
+
+
+
+
+ Wells20140804154115332
+ ./Wells.shp
+
+
+
+
+
+ Wells
+
+
+ +proj=utm +zone=43 +a=6377299.151 +b=6356098.145120132 +towgs84=295,736,257,0,0,0,0 +units=m +no_defs
+ 2052
+ 24343
+ EPSG:24343
+ Kalianpur 1975 / UTM zone 43N
+ utm
+
+ false
+
+
+ ogr
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ 0
+ 0
+ ID
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ .
+
+ 0
+ .
+ generatedlayout
+
+
+
+
+
+
+
+ +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs
+ EPSG:3857
+ 3857
+ 1
+
+
+ false
+
+
+ 0
+ 255
+ 255
+ 255
+ 255
+ 255
+ 255
+
+
+
+ Cultivated_Fields20140804154115208
+ Roads20140804154115228
+ Streams20140804154115270
+ Village20140804154115290
+ Wells20140804154115332
+
+
+ disabled
+ disabled
+ disabled
+ disabled
+ disabled
+
+
+
+ 1
+ 1
+ 1
+ 1
+ 1
+
+
+ to_vertex_and_segment
+ to_vertex_and_segment
+ to_vertex_and_segment
+ to_vertex_and_segment
+ to_vertex_and_segment
+
+
+ 0.000000
+ 0.000000
+ 0.000000
+ 0.000000
+ 0.000000
+
+
+
+ 2
+ true
+
+
+
diff --git a/Exercises/12 SQL spatial geom/SQL spatial geom.docx b/Exercises/12 SQL spatial geom/SQL spatial geom.docx
new file mode 100644
index 0000000..cb19266
Binary files /dev/null and b/Exercises/12 SQL spatial geom/SQL spatial geom.docx differ
diff --git a/Exercises/13 SQL spatial topo/SQL spatial topo.docx b/Exercises/13 SQL spatial topo/SQL spatial topo.docx
new file mode 100644
index 0000000..001d57a
Binary files /dev/null and b/Exercises/13 SQL spatial topo/SQL spatial topo.docx differ
diff --git a/india.sqlite b/india.sqlite
new file mode 100644
index 0000000..f6939f0
Binary files /dev/null and b/india.sqlite differ