aboutsummaryrefslogtreecommitdiff
path: root/dbcreation.ipynb
diff options
context:
space:
mode:
authorPriyansh <[email protected]>2021-11-17 13:43:10 -0500
committerPriyansh <[email protected]>2021-11-17 13:43:10 -0500
commit5e072de9b1853f3854f2972b4213cc955cb02477 (patch)
tree7241ef149042525cd6ab8dcb071c37304945816b /dbcreation.ipynb
parent80cf1b3f9228a7e08b127275bc46a0727fa245eb (diff)
downloadtemp_pred_arima-5e072de9b1853f3854f2972b4213cc955cb02477.tar.xz
temp_pred_arima-5e072de9b1853f3854f2972b4213cc955cb02477.zip
Restructred the file structure and Fixed the Notebook File with Comments
Diffstat (limited to 'dbcreation.ipynb')
-rw-r--r--dbcreation.ipynb4395
1 files changed, 4395 insertions, 0 deletions
diff --git a/dbcreation.ipynb b/dbcreation.ipynb
new file mode 100644
index 0000000..7f0f642
--- /dev/null
+++ b/dbcreation.ipynb
@@ -0,0 +1,4395 @@
+{
+ "cells": [
+ {
+ "cell_type": "code",
+ "execution_count": null,
+ "id": "660de5e8",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Imports\n",
+ "\n",
+ "from IPython.display import display, HTML\n",
+ "import pandas as pd\n",
+ "import sqlite3\n",
+ "from sqlite3 import Error\n",
+ "import os"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": null,
+ "id": "1dc168cb",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Function to create a connection to the database\n",
+ "\n",
+ "def create_connection(db_file, delete_db=False):\n",
+ " \n",
+ " if delete_db and os.path.exists(db_file):\n",
+ " os.remove(db_file)\n",
+ "\n",
+ " conn = None\n",
+ " try:\n",
+ " conn = sqlite3.connect(db_file)\n",
+ " conn.execute(\"PRAGMA foreign_keys = 1\")\n",
+ " except Error as e:\n",
+ " print(e)\n",
+ "\n",
+ " return conn"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": null,
+ "id": "910875f4",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Function to create a database\n",
+ "\n",
+ "def create_table(conn, create_table_sql):\n",
+ " try:\n",
+ " c = conn.cursor()\n",
+ " c.execute(create_table_sql)\n",
+ " except Error as e:\n",
+ " print(e)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": null,
+ "id": "36907a1c",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Execute SQL statement\n",
+ "\n",
+ "def execute_sql_statement(sql_statement, conn):\n",
+ " cur = conn.cursor()\n",
+ " cur.execute(sql_statement)\n",
+ "\n",
+ " rows = cur.fetchall()\n",
+ "\n",
+ " return rows"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 2,
+ "id": "a0dfa189",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/html": [
+ "<div>\n",
+ "<style scoped>\n",
+ " .dataframe tbody tr th:only-of-type {\n",
+ " vertical-align: middle;\n",
+ " }\n",
+ "\n",
+ " .dataframe tbody tr th {\n",
+ " vertical-align: top;\n",
+ " }\n",
+ "\n",
+ " .dataframe thead th {\n",
+ " text-align: right;\n",
+ " }\n",
+ "</style>\n",
+ "<table border=\"1\" class=\"dataframe\">\n",
+ " <thead>\n",
+ " <tr style=\"text-align: right;\">\n",
+ " <th></th>\n",
+ " <th>dt</th>\n",
+ " <th>AverageTemperature</th>\n",
+ " <th>AverageTemperatureUncertainty</th>\n",
+ " <th>City</th>\n",
+ " <th>Country</th>\n",
+ " <th>Latitude</th>\n",
+ " <th>Longitude</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>2474</th>\n",
+ " <td>1950-01-01</td>\n",
+ " <td>-0.712</td>\n",
+ " <td>0.280</td>\n",
+ " <td>Århus</td>\n",
+ " <td>Denmark</td>\n",
+ " <td>57.05N</td>\n",
+ " <td>10.33E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2475</th>\n",
+ " <td>1950-02-01</td>\n",
+ " <td>1.423</td>\n",
+ " <td>0.218</td>\n",
+ " <td>Århus</td>\n",
+ " <td>Denmark</td>\n",
+ " <td>57.05N</td>\n",
+ " <td>10.33E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2476</th>\n",
+ " <td>1950-03-01</td>\n",
+ " <td>4.166</td>\n",
+ " <td>0.266</td>\n",
+ " <td>Århus</td>\n",
+ " <td>Denmark</td>\n",
+ " <td>57.05N</td>\n",
+ " <td>10.33E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2477</th>\n",
+ " <td>1950-04-01</td>\n",
+ " <td>6.743</td>\n",
+ " <td>0.310</td>\n",
+ " <td>Århus</td>\n",
+ " <td>Denmark</td>\n",
+ " <td>57.05N</td>\n",
+ " <td>10.33E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2478</th>\n",
+ " <td>1950-05-01</td>\n",
+ " <td>12.714</td>\n",
+ " <td>0.246</td>\n",
+ " <td>Århus</td>\n",
+ " <td>Denmark</td>\n",
+ " <td>57.05N</td>\n",
+ " <td>10.33E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>...</th>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8599207</th>\n",
+ " <td>2013-05-01</td>\n",
+ " <td>11.464</td>\n",
+ " <td>0.236</td>\n",
+ " <td>Zwolle</td>\n",
+ " <td>Netherlands</td>\n",
+ " <td>52.24N</td>\n",
+ " <td>5.26E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8599208</th>\n",
+ " <td>2013-06-01</td>\n",
+ " <td>15.043</td>\n",
+ " <td>0.261</td>\n",
+ " <td>Zwolle</td>\n",
+ " <td>Netherlands</td>\n",
+ " <td>52.24N</td>\n",
+ " <td>5.26E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8599209</th>\n",
+ " <td>2013-07-01</td>\n",
+ " <td>18.775</td>\n",
+ " <td>0.193</td>\n",
+ " <td>Zwolle</td>\n",
+ " <td>Netherlands</td>\n",
+ " <td>52.24N</td>\n",
+ " <td>5.26E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8599210</th>\n",
+ " <td>2013-08-01</td>\n",
+ " <td>18.025</td>\n",
+ " <td>0.298</td>\n",
+ " <td>Zwolle</td>\n",
+ " <td>Netherlands</td>\n",
+ " <td>52.24N</td>\n",
+ " <td>5.26E</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8599211</th>\n",
+ " <td>2013-09-01</td>\n",
+ " <td>NaN</td>\n",
+ " <td>NaN</td>\n",
+ " <td>Zwolle</td>\n",
+ " <td>Netherlands</td>\n",
+ " <td>52.24N</td>\n",
+ " <td>5.26E</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "<p>2685150 rows × 7 columns</p>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " dt AverageTemperature AverageTemperatureUncertainty \\\n",
+ "2474 1950-01-01 -0.712 0.280 \n",
+ "2475 1950-02-01 1.423 0.218 \n",
+ "2476 1950-03-01 4.166 0.266 \n",
+ "2477 1950-04-01 6.743 0.310 \n",
+ "2478 1950-05-01 12.714 0.246 \n",
+ "... ... ... ... \n",
+ "8599207 2013-05-01 11.464 0.236 \n",
+ "8599208 2013-06-01 15.043 0.261 \n",
+ "8599209 2013-07-01 18.775 0.193 \n",
+ "8599210 2013-08-01 18.025 0.298 \n",
+ "8599211 2013-09-01 NaN NaN \n",
+ "\n",
+ " City Country Latitude Longitude \n",
+ "2474 Århus Denmark 57.05N 10.33E \n",
+ "2475 Århus Denmark 57.05N 10.33E \n",
+ "2476 Århus Denmark 57.05N 10.33E \n",
+ "2477 Århus Denmark 57.05N 10.33E \n",
+ "2478 Århus Denmark 57.05N 10.33E \n",
+ "... ... ... ... ... \n",
+ "8599207 Zwolle Netherlands 52.24N 5.26E \n",
+ "8599208 Zwolle Netherlands 52.24N 5.26E \n",
+ "8599209 Zwolle Netherlands 52.24N 5.26E \n",
+ "8599210 Zwolle Netherlands 52.24N 5.26E \n",
+ "8599211 Zwolle Netherlands 52.24N 5.26E \n",
+ "\n",
+ "[2685150 rows x 7 columns]"
+ ]
+ },
+ "execution_count": 2,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Read the Non-Normalized Data\n",
+ "\n",
+ "df=pd.read_csv(\"GlobalLandTemperaturesByCity.csv\")\n",
+ "data=df[df.dt>\"1949-12-31\"]\n",
+ " "
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 3,
+ "id": "77341f9c",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "[('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Århus', '57.05N', '10.33E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ('Çorlu', '40.99N', '27.69E'),\n",
+ " ...]"
+ ]
+ },
+ "execution_count": 3,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Extract cities and their latitude and longitude\n",
+ "\n",
+ "data_for_loc_table=data[['City','Latitude','Longitude']]\n",
+ "data_for_loc_table=data_for_loc_table.to_records(index=False)\n",
+ "result_data_for_loc_table=list(data_for_loc_table)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 4,
+ "id": "e635279c",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Extract Countries\n",
+ "\n",
+ "records=data.to_records(index=False)\n",
+ "result=list(records)\n",
+ "req_resut=[]\n",
+ "for i in result:\n",
+ " req_resut.append((i[4],))\n"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 5,
+ "id": "74c13a5f",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "[('Cyprus',),\n",
+ " ('Pakistan',),\n",
+ " ('Latvia',),\n",
+ " ('Azerbaijan',),\n",
+ " ('Oman',),\n",
+ " ('Egypt',),\n",
+ " ('Ireland',),\n",
+ " ('Bahamas',),\n",
+ " ('Burkina Faso',),\n",
+ " ('Nepal',),\n",
+ " ('Haiti',),\n",
+ " ('Morocco',),\n",
+ " ('Singapore',),\n",
+ " ('Gabon',),\n",
+ " ('Hungary',),\n",
+ " ('Liberia',),\n",
+ " ('Iran',),\n",
+ " ('Sri Lanka',),\n",
+ " ('Reunion',),\n",
+ " ('Congo (Democratic Republic Of The)',),\n",
+ " ('Burundi',),\n",
+ " ('Guinea',),\n",
+ " ('France',),\n",
+ " ('Kazakhstan',),\n",
+ " ('Canada',),\n",
+ " ('Montenegro',),\n",
+ " ('Gambia',),\n",
+ " ('Cambodia',),\n",
+ " ('Russia',),\n",
+ " ('Saudi Arabia',),\n",
+ " ('Tunisia',),\n",
+ " ('Albania',),\n",
+ " ('Mauritius',),\n",
+ " ('Romania',),\n",
+ " ('Suriname',),\n",
+ " ('Uganda',),\n",
+ " ('Malaysia',),\n",
+ " ('Eritrea',),\n",
+ " ('Algeria',),\n",
+ " ('Colombia',),\n",
+ " ('Thailand',),\n",
+ " ('Burma',),\n",
+ " ('Ghana',),\n",
+ " ('Poland',),\n",
+ " ('Taiwan',),\n",
+ " ('China',),\n",
+ " ('Swaziland',),\n",
+ " ('Chad',),\n",
+ " ('Belgium',),\n",
+ " ('Nigeria',),\n",
+ " ('Brazil',),\n",
+ " ('Papua New Guinea',),\n",
+ " ('Uruguay',),\n",
+ " ('Afghanistan',),\n",
+ " ('Belarus',),\n",
+ " ('Israel',),\n",
+ " ('Iceland',),\n",
+ " ('Georgia',),\n",
+ " ('Hong Kong',),\n",
+ " ('South Africa',),\n",
+ " ('Portugal',),\n",
+ " ('Panama',),\n",
+ " ('Greece',),\n",
+ " ('Ethiopia',),\n",
+ " ('Madagascar',),\n",
+ " ('Equatorial Guinea',),\n",
+ " ('Rwanda',),\n",
+ " ('Zambia',),\n",
+ " ('Guatemala',),\n",
+ " ('Senegal',),\n",
+ " ('Puerto Rico',),\n",
+ " ('Czech Republic',),\n",
+ " ('United Arab Emirates',),\n",
+ " ('United Kingdom',),\n",
+ " ('Malawi',),\n",
+ " ('Namibia',),\n",
+ " ('Argentina',),\n",
+ " ('Bangladesh',),\n",
+ " ('Djibouti',),\n",
+ " ('Croatia',),\n",
+ " ('Ukraine',),\n",
+ " ('Jamaica',),\n",
+ " ('Ecuador',),\n",
+ " ('Bahrain',),\n",
+ " ('South Korea',),\n",
+ " ('Philippines',),\n",
+ " ('Sierra Leone',),\n",
+ " ('Germany',),\n",
+ " (\"Côte D'Ivoire\",),\n",
+ " ('Botswana',),\n",
+ " ('Estonia',),\n",
+ " ('Slovakia',),\n",
+ " ('Mongolia',),\n",
+ " ('Moldova',),\n",
+ " ('Syria',),\n",
+ " ('Armenia',),\n",
+ " ('Togo',),\n",
+ " ('Cameroon',),\n",
+ " ('Bosnia And Herzegovina',),\n",
+ " ('Norway',),\n",
+ " ('Denmark',),\n",
+ " ('Central African Republic',),\n",
+ " ('Mozambique',),\n",
+ " ('Bolivia',),\n",
+ " ('Guyana',),\n",
+ " ('Guinea Bissau',),\n",
+ " ('Costa Rica',),\n",
+ " ('Venezuela',),\n",
+ " ('Yemen',),\n",
+ " ('Austria',),\n",
+ " ('Honduras',),\n",
+ " ('Mali',),\n",
+ " ('Chile',),\n",
+ " ('Zimbabwe',),\n",
+ " ('Congo',),\n",
+ " ('Turkey',),\n",
+ " ('Turkmenistan',),\n",
+ " ('Australia',),\n",
+ " ('Tanzania',),\n",
+ " ('Italy',),\n",
+ " ('Tajikistan',),\n",
+ " ('Sweden',),\n",
+ " ('Libya',),\n",
+ " ('Vietnam',),\n",
+ " ('Paraguay',),\n",
+ " ('Qatar',),\n",
+ " ('Macedonia',),\n",
+ " ('Indonesia',),\n",
+ " ('Jordan',),\n",
+ " ('Nicaragua',),\n",
+ " ('El Salvador',),\n",
+ " ('Bulgaria',),\n",
+ " ('Serbia',),\n",
+ " ('Mauritania',),\n",
+ " ('Somalia',),\n",
+ " ('Dominican Republic',),\n",
+ " ('Finland',),\n",
+ " ('Lesotho',),\n",
+ " ('Kenya',),\n",
+ " ('Benin',),\n",
+ " ('Cuba',),\n",
+ " ('Sudan',),\n",
+ " ('Spain',),\n",
+ " ('Netherlands',),\n",
+ " ('Niger',),\n",
+ " ('Slovenia',),\n",
+ " ('United States',),\n",
+ " ('Peru',),\n",
+ " ('Japan',),\n",
+ " ('Angola',),\n",
+ " ('Laos',),\n",
+ " ('Uzbekistan',),\n",
+ " ('India',),\n",
+ " ('New Zealand',),\n",
+ " ('Lithuania',),\n",
+ " ('Iraq',),\n",
+ " ('Switzerland',),\n",
+ " ('Lebanon',),\n",
+ " ('Mexico',)]"
+ ]
+ },
+ "execution_count": 5,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Convert the list of cities into a list with unique names\n",
+ "\n",
+ "req_resut=list((set(req_resut)))"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 8,
+ "id": "21eca337",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Create a connection to the database\n",
+ "conn = create_connection('database.db')\n",
+ "cur=conn.cursor()"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 9,
+ "id": "af74cdef",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "<sqlite3.Cursor at 0x7f7d40c2cce0>"
+ ]
+ },
+ "execution_count": 9,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Drop City Table and the Country Table if they exist and create a new Country Table and Insert the data\n",
+ "\n",
+ "execute_sql_statement(\"DROP TABLE IF EXISTS City_Table\",conn)\n",
+ "execute_sql_statement(\"DROP TABLE IF EXISTS Country_Table\",conn)\n",
+ "create_table(conn,'''CREATE TABLE Country_Table (PK INTEGER PRIMARY KEY, Country_Name VARCHAR)''')\n",
+ "cur.executemany(\"INSERT INTO Country_Table ('Country_Name') Values (?)\",req_resut)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 10,
+ "id": "59930452",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Make a dictionary of the country data and their IDs\n",
+ "abc=execute_sql_statement(\"Select * from Country_Table\", conn)\n",
+ "abc1={}\n",
+ "for i in abc:\n",
+ " abc1[i[1]]=i[0]"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 11,
+ "id": "52c77691",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "req_result_2=[]\n",
+ "for i in result:\n",
+ " req_result_2.append((i[3],abc1[i[4]]))"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 12,
+ "id": "f5b64360",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Create the City Table\n",
+ "create_table(conn,'''CREATE TABLE City_Table (City_Id INTEGER PRIMARY KEY, City_Name VARCHAR , Country_ID INTEGER,\n",
+ "FOREIGN KEY(Country_ID) REFERENCES Country_Table(PK))''')"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 13,
+ "id": "1206d273",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Extract the data for City Table\n",
+ "city=[]\n",
+ "for i in result:\n",
+ " # j=j+1\n",
+ " city.append((i[3],abc1[i[4]]))\n",
+ "city_country_unique=list((set(city)))"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 14,
+ "id": "cfca5230",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "<sqlite3.Cursor at 0x7f7d40c2cce0>"
+ ]
+ },
+ "execution_count": 14,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Insert the data for City Table\n",
+ "cur.executemany(\"INSERT INTO City_Table ('City_Name','Country_ID') Values (?,?)\",city_country_unique)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 16,
+ "id": "d9f71f49",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/html": [
+ "<div>\n",
+ "<style scoped>\n",
+ " .dataframe tbody tr th:only-of-type {\n",
+ " vertical-align: middle;\n",
+ " }\n",
+ "\n",
+ " .dataframe tbody tr th {\n",
+ " vertical-align: top;\n",
+ " }\n",
+ "\n",
+ " .dataframe thead th {\n",
+ " text-align: right;\n",
+ " }\n",
+ "</style>\n",
+ "<table border=\"1\" class=\"dataframe\">\n",
+ " <thead>\n",
+ " <tr style=\"text-align: right;\">\n",
+ " <th></th>\n",
+ " <th>City_Id</th>\n",
+ " <th>City_Name</th>\n",
+ " <th>Country_ID</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1</td>\n",
+ " <td>Fuzhou</td>\n",
+ " <td>46</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>2</td>\n",
+ " <td>Panchiao</td>\n",
+ " <td>45</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>3</td>\n",
+ " <td>Tegal</td>\n",
+ " <td>128</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>4</td>\n",
+ " <td>Rongcheng</td>\n",
+ " <td>46</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>5</td>\n",
+ " <td>Santa Ana</td>\n",
+ " <td>147</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>...</th>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3485</th>\n",
+ " <td>3486</td>\n",
+ " <td>Shimonoseki</td>\n",
+ " <td>149</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3486</th>\n",
+ " <td>3487</td>\n",
+ " <td>Makasar</td>\n",
+ " <td>128</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3487</th>\n",
+ " <td>3488</td>\n",
+ " <td>Düsseldorf</td>\n",
+ " <td>88</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3488</th>\n",
+ " <td>3489</td>\n",
+ " <td>Phitsanulok</td>\n",
+ " <td>41</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3489</th>\n",
+ " <td>3490</td>\n",
+ " <td>Tasikmalaya</td>\n",
+ " <td>128</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "<p>3490 rows × 3 columns</p>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " City_Id City_Name Country_ID\n",
+ "0 1 Fuzhou 46\n",
+ "1 2 Panchiao 45\n",
+ "2 3 Tegal 128\n",
+ "3 4 Rongcheng 46\n",
+ "4 5 Santa Ana 147\n",
+ "... ... ... ...\n",
+ "3485 3486 Shimonoseki 149\n",
+ "3486 3487 Makasar 128\n",
+ "3487 3488 Düsseldorf 88\n",
+ "3488 3489 Phitsanulok 41\n",
+ "3489 3490 Tasikmalaya 128\n",
+ "\n",
+ "[3490 rows x 3 columns]"
+ ]
+ },
+ "metadata": {},
+ "output_type": "display_data"
+ }
+ ],
+ "source": [
+ "#df=execute_sql_statement(\"Select * from City_Table\", conn)\n",
+ "df=pd.read_sql_query(\"Select * from City_Table\", conn)\n",
+ "display(df)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": null,
+ "id": "3692d2ea",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Build a dictionary of the city data and their IDs\n",
+ "city_index=execute_sql_statement(\"Select * from City_Table\", conn)\n",
+ "city_indexes={}\n",
+ "for i in abc:\n",
+ " abc1[i[1]]=i[0]"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 17,
+ "id": "9dd4ef62",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/html": [
+ "<div>\n",
+ "<style scoped>\n",
+ " .dataframe tbody tr th:only-of-type {\n",
+ " vertical-align: middle;\n",
+ " }\n",
+ "\n",
+ " .dataframe tbody tr th {\n",
+ " vertical-align: top;\n",
+ " }\n",
+ "\n",
+ " .dataframe thead th {\n",
+ " text-align: right;\n",
+ " }\n",
+ "</style>\n",
+ "<table border=\"1\" class=\"dataframe\">\n",
+ " <thead>\n",
+ " <tr style=\"text-align: right;\">\n",
+ " <th></th>\n",
+ " <th>PK</th>\n",
+ " <th>Country_Name</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1</td>\n",
+ " <td>Cyprus</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>2</td>\n",
+ " <td>Pakistan</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>3</td>\n",
+ " <td>Latvia</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>4</td>\n",
+ " <td>Azerbaijan</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>5</td>\n",
+ " <td>Oman</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>...</th>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>154</th>\n",
+ " <td>155</td>\n",
+ " <td>Lithuania</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>155</th>\n",
+ " <td>156</td>\n",
+ " <td>Iraq</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>156</th>\n",
+ " <td>157</td>\n",
+ " <td>Switzerland</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>157</th>\n",
+ " <td>158</td>\n",
+ " <td>Lebanon</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>158</th>\n",
+ " <td>159</td>\n",
+ " <td>Mexico</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "<p>159 rows × 2 columns</p>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " PK Country_Name\n",
+ "0 1 Cyprus\n",
+ "1 2 Pakistan\n",
+ "2 3 Latvia\n",
+ "3 4 Azerbaijan\n",
+ "4 5 Oman\n",
+ ".. ... ...\n",
+ "154 155 Lithuania\n",
+ "155 156 Iraq\n",
+ "156 157 Switzerland\n",
+ "157 158 Lebanon\n",
+ "158 159 Mexico\n",
+ "\n",
+ "[159 rows x 2 columns]"
+ ]
+ },
+ "metadata": {},
+ "output_type": "display_data"
+ }
+ ],
+ "source": [
+ "# Displaying the country data\n",
+ "df1=pd.read_sql_query(\"Select * from Country_Table\", conn)\n",
+ "display(df1)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 18,
+ "id": "4c2a9868",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "[(8, 'Moga', 153, 153, 'India'),\n",
+ " (16, 'Tirunelveli', 153, 153, 'India'),\n",
+ " (17, 'Krishnanagar', 153, 153, 'India'),\n",
+ " (22, 'Belgaum', 153, 153, 'India'),\n",
+ " (30, 'Durg', 153, 153, 'India'),\n",
+ " (35, 'Ichalkaranji', 153, 153, 'India'),\n",
+ " (36, 'Kulti', 153, 153, 'India'),\n",
+ " (55, 'Munger', 153, 153, 'India'),\n",
+ " (68, 'Purnia', 153, 153, 'India'),\n",
+ " (77, 'Bidar', 153, 153, 'India')]"
+ ]
+ },
+ "execution_count": 18,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Join the data from the City Table and the Country Table and display the data\n",
+ "\n",
+ "execute_sql_statement(\"select * from City_Table join Country_Table on Country_Table.PK = City_Table.Country_ID AND Country_Table.Country_Name='India' LIMIT 10\",conn)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 19,
+ "id": "3932f5a5",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "{'Fuzhou': 1,\n",
+ " 'Panchiao': 2,\n",
+ " 'Tegal': 3,\n",
+ " 'Rongcheng': 4,\n",
+ " 'Santa Ana': 2133,\n",
+ " 'Chiclayo': 6,\n",
+ " 'Jinan': 7,\n",
+ " 'Moga': 8,\n",
+ " 'Binjai': 9,\n",
+ " 'Rafsanjan': 10,\n",
+ " 'Timisoara': 11,\n",
+ " 'Mytishchi': 12,\n",
+ " 'Piracicaba': 13,\n",
+ " 'Bharatpur': 335,\n",
+ " 'San Martin': 15,\n",
+ " 'Tirunelveli': 16,\n",
+ " 'Krishnanagar': 17,\n",
+ " 'Thaton': 18,\n",
+ " 'Bandundu': 19,\n",
+ " 'Chinandega': 20,\n",
+ " 'Buon Me Thuot': 21,\n",
+ " 'Belgaum': 22,\n",
+ " 'Nagoya': 23,\n",
+ " 'Lages': 24,\n",
+ " 'Taunggyi': 25,\n",
+ " 'Salt Lake City': 26,\n",
+ " 'Tartu': 27,\n",
+ " 'Zurich': 28,\n",
+ " 'Montalban': 29,\n",
+ " 'Durg': 30,\n",
+ " 'Yichang': 31,\n",
+ " 'Florence': 32,\n",
+ " 'Bogor': 33,\n",
+ " 'Ekibastuz': 34,\n",
+ " 'Ichalkaranji': 35,\n",
+ " 'Kulti': 36,\n",
+ " 'Kolomna': 37,\n",
+ " 'Paranaguá': 38,\n",
+ " 'Shaoxing': 39,\n",
+ " 'Pôrto Velho': 40,\n",
+ " 'Erzurum': 41,\n",
+ " 'Pôrto Seguro': 42,\n",
+ " 'Qalyub': 43,\n",
+ " 'Makurdi': 44,\n",
+ " 'Kedungwuni': 45,\n",
+ " 'Hampton': 46,\n",
+ " 'Lobito': 47,\n",
+ " 'Reims': 48,\n",
+ " 'Capiatá': 49,\n",
+ " 'Lembang': 50,\n",
+ " 'Villa Canales': 51,\n",
+ " 'Zanzibar': 52,\n",
+ " 'Wuzhou': 53,\n",
+ " 'Franco Da Rocha': 54,\n",
+ " 'Munger': 55,\n",
+ " 'Bafoussam': 56,\n",
+ " 'Aix En Provence': 57,\n",
+ " 'Fianarantsoa': 58,\n",
+ " 'Remscheid': 59,\n",
+ " 'Lansing': 60,\n",
+ " 'Cary': 61,\n",
+ " 'Bengkulu': 62,\n",
+ " 'Formosa': 63,\n",
+ " 'Kashihara': 64,\n",
+ " 'Concord': 65,\n",
+ " 'Zaporizhzhya': 66,\n",
+ " 'Fort Lauderdale': 67,\n",
+ " 'Purnia': 68,\n",
+ " 'Tehuacán': 69,\n",
+ " 'Antalya': 70,\n",
+ " 'Hami': 71,\n",
+ " 'Shekhupura': 72,\n",
+ " 'Taiyuan': 73,\n",
+ " 'San Juan': 2142,\n",
+ " 'Berbera': 75,\n",
+ " 'Tijuana': 76,\n",
+ " 'Bidar': 77,\n",
+ " 'Orël': 78,\n",
+ " 'Biysk': 79,\n",
+ " 'Chishtian Mandi': 80,\n",
+ " 'Faridpur': 81,\n",
+ " 'Torreón': 82,\n",
+ " 'Urdaneta': 83,\n",
+ " 'Godhra': 84,\n",
+ " 'Sepatan': 85,\n",
+ " 'Nanded': 86,\n",
+ " 'Monza': 87,\n",
+ " 'Yangjiang': 88,\n",
+ " 'Pucallpa': 89,\n",
+ " 'Gujrat': 90,\n",
+ " 'Kaithal': 91,\n",
+ " 'Victoria': 92,\n",
+ " 'Ikere': 93,\n",
+ " 'Seto': 94,\n",
+ " 'Tema': 95,\n",
+ " 'Pindiga': 96,\n",
+ " 'Ikare': 97,\n",
+ " 'Huainan': 98,\n",
+ " 'Owerri': 99,\n",
+ " 'Erlangen': 100,\n",
+ " 'Araraquara': 101,\n",
+ " 'Tokorozawa': 102,\n",
+ " 'Saint Louis': 2980,\n",
+ " 'Tonalá': 104,\n",
+ " 'Dalian': 105,\n",
+ " 'Birmingham': 1586,\n",
+ " 'Vicenza': 107,\n",
+ " 'Petrolina': 108,\n",
+ " 'Ambattur': 109,\n",
+ " 'Chigasaki': 110,\n",
+ " 'Ankara': 111,\n",
+ " 'Taranto': 112,\n",
+ " 'Burgas': 113,\n",
+ " 'Antipolo': 114,\n",
+ " 'Cúcuta': 115,\n",
+ " 'Gonda': 116,\n",
+ " 'Balashikha': 117,\n",
+ " 'Kumanovo': 118,\n",
+ " 'Kupang': 119,\n",
+ " 'Oslo': 120,\n",
+ " 'Jiaohe': 121,\n",
+ " 'Armavir': 122,\n",
+ " 'Manchester': 3242,\n",
+ " 'Valladolid': 124,\n",
+ " 'Constantine': 125,\n",
+ " 'Cuernavaca': 126,\n",
+ " 'Kerman': 127,\n",
+ " 'Blumenau': 128,\n",
+ " 'Narayanganj': 129,\n",
+ " 'Okara': 130,\n",
+ " 'Shiliguri': 131,\n",
+ " 'Chuzhou': 132,\n",
+ " 'Herat': 133,\n",
+ " 'Orai': 134,\n",
+ " 'Valdivia': 135,\n",
+ " 'Amsterdam': 136,\n",
+ " 'Bahadurgarh': 137,\n",
+ " 'Penza': 138,\n",
+ " 'Mogadishu': 139,\n",
+ " 'Anand': 140,\n",
+ " 'Liusha': 141,\n",
+ " 'Ishinomaki': 142,\n",
+ " 'Rajkot': 143,\n",
+ " 'Korba': 144,\n",
+ " 'Tumkur': 145,\n",
+ " 'Kunming': 146,\n",
+ " 'Palhoça': 147,\n",
+ " 'Feira De Santana': 148,\n",
+ " 'Tambun': 149,\n",
+ " 'Chitradurga': 150,\n",
+ " 'Barreiras': 151,\n",
+ " 'Clarksville': 152,\n",
+ " 'Qena': 153,\n",
+ " 'Fresno': 154,\n",
+ " 'Zhanjiang': 155,\n",
+ " 'Qiqihar': 156,\n",
+ " 'Jian': 157,\n",
+ " 'Colatina': 158,\n",
+ " 'San Luis Río Colorado': 159,\n",
+ " 'Yueyang': 160,\n",
+ " 'Carrollton': 161,\n",
+ " 'El Monte': 162,\n",
+ " 'Würzburg': 163,\n",
+ " 'Pulandian': 164,\n",
+ " 'Nadiad': 165,\n",
+ " 'Tacloban': 166,\n",
+ " 'Damaturu': 167,\n",
+ " 'Richmond': 168,\n",
+ " 'Ibirité': 169,\n",
+ " 'Qandahar': 170,\n",
+ " 'Mandalay': 171,\n",
+ " 'Bratsk': 172,\n",
+ " 'Bielsko Biala': 173,\n",
+ " 'Plovdiv': 174,\n",
+ " 'Carolina': 175,\n",
+ " 'Tangier': 176,\n",
+ " 'Yancheng': 177,\n",
+ " 'Uberlândia': 178,\n",
+ " 'Junagadh': 179,\n",
+ " 'Damascus': 180,\n",
+ " 'Fontana': 181,\n",
+ " 'Orizaba': 182,\n",
+ " 'Otukpo': 183,\n",
+ " 'Quchan': 184,\n",
+ " 'Tanta': 185,\n",
+ " 'Hadejia': 186,\n",
+ " 'Muzaffargarh': 187,\n",
+ " 'Susah': 188,\n",
+ " 'Khanewal': 189,\n",
+ " 'Chakwal': 190,\n",
+ " 'Toluca': 191,\n",
+ " 'Shillong': 192,\n",
+ " 'Xai Xai': 193,\n",
+ " 'Hangzhou': 194,\n",
+ " 'Jaipur': 195,\n",
+ " 'Kawaguchi': 196,\n",
+ " 'Rampur': 197,\n",
+ " 'Samarinda': 198,\n",
+ " 'Zhongshan': 199,\n",
+ " 'Liège': 200,\n",
+ " 'Metz': 201,\n",
+ " 'Bratislava': 202,\n",
+ " 'Dekernes': 203,\n",
+ " 'New Delhi': 204,\n",
+ " 'Niamey': 205,\n",
+ " 'Wuxi': 206,\n",
+ " 'Amroha': 207,\n",
+ " 'Ikot Ekpene': 208,\n",
+ " 'Baruta': 209,\n",
+ " 'Yavatmal': 210,\n",
+ " 'Shenyang': 211,\n",
+ " 'Aalborg': 212,\n",
+ " 'Lianran': 213,\n",
+ " 'Carúpano': 214,\n",
+ " 'São José Dos Pinhais': 215,\n",
+ " 'Badalona': 216,\n",
+ " 'Gera': 217,\n",
+ " 'Mainz': 218,\n",
+ " 'Lyubertsy': 219,\n",
+ " 'Gaozhou': 220,\n",
+ " 'Bordeaux': 221,\n",
+ " 'Chalco': 222,\n",
+ " 'Kinshasa': 223,\n",
+ " 'Morena': 224,\n",
+ " 'Los Teques': 225,\n",
+ " 'Wolverhampton': 226,\n",
+ " 'Gongzhuling': 227,\n",
+ " 'Varna': 228,\n",
+ " 'Cimahi': 229,\n",
+ " 'Cordoba': 230,\n",
+ " 'Macapá': 231,\n",
+ " 'Marbella': 232,\n",
+ " 'Moradabad': 233,\n",
+ " 'Messina': 234,\n",
+ " 'Khushab': 235,\n",
+ " 'Vologda': 236,\n",
+ " 'Mahajanga': 237,\n",
+ " 'Jixi': 238,\n",
+ " 'Cibitung': 239,\n",
+ " 'Farrukhabad': 240,\n",
+ " 'Myingyan': 241,\n",
+ " 'Neuss': 242,\n",
+ " 'Ballia': 243,\n",
+ " 'Lusaka': 244,\n",
+ " 'Bukit Mertajam': 245,\n",
+ " 'Carmen': 246,\n",
+ " 'Gandajika': 247,\n",
+ " 'Kabul': 248,\n",
+ " 'Novara': 249,\n",
+ " 'Kitami': 250,\n",
+ " 'San Diego': 251,\n",
+ " 'Norwalk': 252,\n",
+ " 'Rimini': 253,\n",
+ " 'Des Moines': 254,\n",
+ " 'Adiwerna': 255,\n",
+ " 'Caracas': 256,\n",
+ " 'Lira': 257,\n",
+ " 'Saskatoon': 258,\n",
+ " 'Machida': 259,\n",
+ " 'Ulan Ude': 260,\n",
+ " 'Virar': 261,\n",
+ " 'Tlalnepantla': 262,\n",
+ " 'Guacara': 263,\n",
+ " 'Leshan': 264,\n",
+ " 'Xuchang': 265,\n",
+ " 'Calabar': 266,\n",
+ " 'Naihati': 267,\n",
+ " 'Esenyurt': 268,\n",
+ " 'Delmas': 269,\n",
+ " 'Ede': 1116,\n",
+ " 'Motihari': 271,\n",
+ " 'Jingdezhen': 272,\n",
+ " 'West Jordan': 273,\n",
+ " 'Linxia': 274,\n",
+ " 'Arica': 275,\n",
+ " 'Iloilo': 276,\n",
+ " 'Ujjain': 277,\n",
+ " 'Sheffield': 278,\n",
+ " 'Habikino': 279,\n",
+ " 'Bangaon': 280,\n",
+ " 'Kolpino': 281,\n",
+ " 'Oshawa': 282,\n",
+ " 'Toledo': 2134,\n",
+ " 'Sadiqabad': 284,\n",
+ " 'Virginia': 285,\n",
+ " 'Zaoyang': 286,\n",
+ " 'Breda': 287,\n",
+ " 'Meycauayan': 288,\n",
+ " 'Paris': 289,\n",
+ " 'Witten': 290,\n",
+ " 'Iráklion': 291,\n",
+ " 'Serpukhov': 292,\n",
+ " 'Port Blair': 293,\n",
+ " 'Brazzaville': 294,\n",
+ " 'Puebla': 295,\n",
+ " 'Ebetsu': 296,\n",
+ " 'Torun': 297,\n",
+ " 'Várzea Grande': 298,\n",
+ " 'Alcalá De Henares': 299,\n",
+ " 'Philadelphia': 300,\n",
+ " 'Kishiwada': 301,\n",
+ " 'Munich': 302,\n",
+ " 'Ribeirão Das Neves': 303,\n",
+ " 'Bouaké': 304,\n",
+ " 'Djougou': 305,\n",
+ " 'Juarez': 306,\n",
+ " 'Culiacán': 307,\n",
+ " 'Newport': 308,\n",
+ " 'Cileunyi': 309,\n",
+ " 'Ciputat': 310,\n",
+ " 'Dasoguz': 311,\n",
+ " 'Denver': 312,\n",
+ " 'Huzhou': 313,\n",
+ " 'Jacareí': 314,\n",
+ " 'Kaolack': 315,\n",
+ " 'Acarigua': 316,\n",
+ " 'Bamako': 317,\n",
+ " 'Sandakan': 318,\n",
+ " 'Linxi': 319,\n",
+ " 'Ibadan': 320,\n",
+ " 'Gazipur': 321,\n",
+ " 'Hargeysa': 322,\n",
+ " 'Toulon': 323,\n",
+ " 'Toamasina': 324,\n",
+ " 'Chaohu': 325,\n",
+ " 'Tacna': 326,\n",
+ " 'Linz': 327,\n",
+ " 'Colorado Springs': 328,\n",
+ " 'Kamakura': 329,\n",
+ " 'Green Bay': 330,\n",
+ " 'Coral Springs': 331,\n",
+ " 'Campo Grande': 332,\n",
+ " 'Kalyan': 333,\n",
+ " 'San Pablo De Las Salinas': 334,\n",
+ " 'Wuxue': 336,\n",
+ " 'Ziguinchor': 337,\n",
+ " 'Aberdeen': 338,\n",
+ " 'Chapecó': 339,\n",
+ " 'Cherkasy': 340,\n",
+ " 'Dodoma': 341,\n",
+ " 'La Paz': 564,\n",
+ " 'Lakewood': 343,\n",
+ " 'Tubruq': 344,\n",
+ " 'Zaozhuang': 345,\n",
+ " 'Bloemfontein': 346,\n",
+ " 'Huangcun': 347,\n",
+ " 'Bojnurd': 348,\n",
+ " 'Jakarta': 349,\n",
+ " 'Ila': 350,\n",
+ " 'Puri': 351,\n",
+ " 'Astana': 352,\n",
+ " 'El Paso': 353,\n",
+ " 'Jilin': 354,\n",
+ " 'Aryanah': 355,\n",
+ " 'Garza García': 356,\n",
+ " 'Tachikawa': 357,\n",
+ " 'Batman': 358,\n",
+ " 'San Pedro': 359,\n",
+ " 'Huixquilucan': 360,\n",
+ " 'Ulm': 361,\n",
+ " 'Nanning': 362,\n",
+ " 'Resende': 363,\n",
+ " 'Tarragona': 364,\n",
+ " 'Ejido': 365,\n",
+ " 'Aachen': 366,\n",
+ " 'Pemba': 367,\n",
+ " 'Najran': 368,\n",
+ " 'Garut': 369,\n",
+ " 'Jaén': 370,\n",
+ " 'Shanghai': 371,\n",
+ " 'Cotonou': 372,\n",
+ " 'Olongapo': 373,\n",
+ " 'Bergisch Gladbach': 374,\n",
+ " 'Syracuse': 1799,\n",
+ " 'Ukhta': 376,\n",
+ " 'Bytom': 377,\n",
+ " 'Sholapur': 378,\n",
+ " 'Tula': 379,\n",
+ " 'Lakhimpur': 380,\n",
+ " 'Nancy': 381,\n",
+ " 'Zhumadian': 382,\n",
+ " 'Irving': 383,\n",
+ " 'Vina Del Mar': 384,\n",
+ " 'Mashhad': 385,\n",
+ " 'Granada': 386,\n",
+ " 'Lafia': 387,\n",
+ " 'Elizabeth': 388,\n",
+ " 'Ruiru': 389,\n",
+ " 'Caucaia': 390,\n",
+ " 'Fürth': 391,\n",
+ " 'Perth': 392,\n",
+ " 'Atibaia': 393,\n",
+ " 'Ciampea': 394,\n",
+ " 'Khon Kaen': 395,\n",
+ " 'Asansol': 396,\n",
+ " 'Jaboatão': 397,\n",
+ " 'Marabá': 398,\n",
+ " 'Pathein': 399,\n",
+ " 'Orsk': 400,\n",
+ " 'Pinsk': 401,\n",
+ " 'Shah Alam': 402,\n",
+ " 'Spokane': 403,\n",
+ " 'Tambov': 404,\n",
+ " 'Taraz': 405,\n",
+ " 'Urfa': 406,\n",
+ " 'Qinzhou': 407,\n",
+ " 'Modesto': 408,\n",
+ " 'Grenoble': 409,\n",
+ " 'Liverpool': 410,\n",
+ " 'Jackson': 411,\n",
+ " 'Wardha': 412,\n",
+ " 'Vryheid': 413,\n",
+ " 'Kalisz': 414,\n",
+ " 'Lexington Fayette': 415,\n",
+ " 'San Francisco': 416,\n",
+ " 'Yingzhong': 417,\n",
+ " 'Orléans': 418,\n",
+ " 'Chitungwiza': 419,\n",
+ " 'Sochi': 420,\n",
+ " 'João Pessoa': 421,\n",
+ " 'Mercedes': 422,\n",
+ " 'Espoo': 423,\n",
+ " 'Mbouda': 424,\n",
+ " 'Rabat': 425,\n",
+ " 'Sergiyev Posad': 426,\n",
+ " 'Buga': 427,\n",
+ " 'Santa Clara': 1364,\n",
+ " 'Palmdale': 429,\n",
+ " 'Sasaram': 430,\n",
+ " 'Magdeburg': 431,\n",
+ " 'Staryy Oskol': 432,\n",
+ " 'Ensenada': 433,\n",
+ " 'Himeji': 434,\n",
+ " 'Nazilli': 435,\n",
+ " 'Sosnowiec': 436,\n",
+ " 'Ismailia': 437,\n",
+ " 'Mezhdurechensk': 438,\n",
+ " 'Boa Vista': 439,\n",
+ " 'Elista': 440,\n",
+ " 'Blagoveshchensk': 441,\n",
+ " 'Eskisehir': 442,\n",
+ " 'Cachoeiro De Itapemirim': 443,\n",
+ " 'Stavropol': 444,\n",
+ " 'Thiruvananthapuram': 445,\n",
+ " 'Zamora': 446,\n",
+ " 'Bengbu': 447,\n",
+ " 'Suez': 448,\n",
+ " 'Purwokerto': 449,\n",
+ " 'Aracaju': 450,\n",
+ " 'Shishou': 451,\n",
+ " 'Ambur': 452,\n",
+ " 'Botshabelo': 453,\n",
+ " 'Stuttgart': 454,\n",
+ " 'Haifa': 455,\n",
+ " 'Montevideo': 456,\n",
+ " 'Banjaran': 457,\n",
+ " 'Vinnytsya': 458,\n",
+ " 'Iquique': 459,\n",
+ " 'Offenbach': 460,\n",
+ " 'Nantes': 461,\n",
+ " 'Barquisimeto': 462,\n",
+ " 'Oklahoma City': 463,\n",
+ " 'Santa Marta': 464,\n",
+ " 'Girardot': 465,\n",
+ " 'Kishi': 466,\n",
+ " 'Hachioji': 467,\n",
+ " 'Kassel': 468,\n",
+ " 'Mostar': 469,\n",
+ " 'Danshui': 470,\n",
+ " 'Longjiang': 471,\n",
+ " 'Yokosuka': 472,\n",
+ " 'Jandira': 473,\n",
+ " 'Langfang': 474,\n",
+ " 'Kolar': 475,\n",
+ " 'Jamnagar': 476,\n",
+ " 'Maturín': 477,\n",
+ " 'Shakhty': 478,\n",
+ " 'Andijon': 479,\n",
+ " 'Nehe': 480,\n",
+ " 'Vizianagaram': 481,\n",
+ " 'Elblag': 482,\n",
+ " 'Jining': 483,\n",
+ " 'Mojokerto': 484,\n",
+ " 'Buenaventura': 485,\n",
+ " 'Mexicali': 486,\n",
+ " 'Purwodadi': 487,\n",
+ " 'Botosani': 488,\n",
+ " 'Ordu': 489,\n",
+ " 'Qabis': 490,\n",
+ " 'Changchun': 491,\n",
+ " 'Visakhapatnam': 492,\n",
+ " 'Halifax': 493,\n",
+ " 'Lanzhou': 494,\n",
+ " 'Ambala': 495,\n",
+ " 'Shuangcheng': 496,\n",
+ " 'Harbin': 497,\n",
+ " 'Zhenjiang': 498,\n",
+ " 'Borujerd': 499,\n",
+ " 'Pouso Alegre': 500,\n",
+ " 'Parnamirim': 501,\n",
+ " 'Pimpri': 502,\n",
+ " 'Kandy': 503,\n",
+ " 'Nishio': 504,\n",
+ " 'Tanete': 505,\n",
+ " 'Barcelona': 855,\n",
+ " 'Serekunda': 507,\n",
+ " 'Ikire': 508,\n",
+ " 'Rubtsovsk': 509,\n",
+ " 'Ijero': 510,\n",
+ " 'Targu Mures': 511,\n",
+ " 'Matadi': 512,\n",
+ " 'Novotroitsk': 513,\n",
+ " 'Tarnow': 514,\n",
+ " 'San Pablo': 515,\n",
+ " 'Phan Thiet': 516,\n",
+ " 'Kovrov': 517,\n",
+ " 'South Bend': 518,\n",
+ " 'Thanh Hóa': 519,\n",
+ " 'Nagda': 520,\n",
+ " 'Metairie': 521,\n",
+ " 'Madanapalle': 522,\n",
+ " 'Norilsk': 523,\n",
+ " 'Daliang': 524,\n",
+ " 'Clermont Ferrand': 525,\n",
+ " 'San Luis Potosí': 526,\n",
+ " 'Dehui': 527,\n",
+ " 'Oshogbo': 528,\n",
+ " 'Mopti': 529,\n",
+ " 'Tuluá': 530,\n",
+ " 'Zhukovskiy': 531,\n",
+ " 'Luxor': 532,\n",
+ " 'Azamgarh': 533,\n",
+ " 'Silchar': 534,\n",
+ " 'Sivas': 535,\n",
+ " 'Chongqing': 536,\n",
+ " 'Khulna': 537,\n",
+ " 'Raichur': 538,\n",
+ " 'Cardiff': 539,\n",
+ " 'Navoi': 540,\n",
+ " 'Arjawinangun': 541,\n",
+ " 'Monclova': 542,\n",
+ " 'San Miguelito': 543,\n",
+ " 'Santo Domingo': 2591,\n",
+ " 'Lleida': 545,\n",
+ " 'Araruama': 546,\n",
+ " 'Nakhon Pathom': 547,\n",
+ " 'Batala': 548,\n",
+ " 'Auckland': 549,\n",
+ " 'Akita': 550,\n",
+ " 'Pembroke Pines': 551,\n",
+ " 'Chungho': 552,\n",
+ " 'Zhaoqing': 553,\n",
+ " 'Tsukuba': 554,\n",
+ " 'Cochabamba': 555,\n",
+ " 'Laoag': 556,\n",
+ " 'Rabak': 557,\n",
+ " 'Zuwarah': 558,\n",
+ " 'Haibowan': 559,\n",
+ " 'Kaohsiung': 560,\n",
+ " 'Guaymas': 561,\n",
+ " 'Thana': 562,\n",
+ " 'Maragheh': 563,\n",
+ " 'Daloa': 565,\n",
+ " 'Pingshan': 566,\n",
+ " 'Regina': 567,\n",
+ " 'Hakodate': 568,\n",
+ " 'Bihar': 569,\n",
+ " 'Budapest': 570,\n",
+ " 'Barakpur': 571,\n",
+ " 'Ajmer': 572,\n",
+ " 'Gbongan': 573,\n",
+ " 'Huaihua': 574,\n",
+ " 'Santa Cruz': 575,\n",
+ " 'Xuanhua': 576,\n",
+ " 'Sirajganj': 577,\n",
+ " 'Alagoinhas': 578,\n",
+ " 'Yushan': 579,\n",
+ " 'Ufa': 580,\n",
+ " 'Neijiang': 581,\n",
+ " 'Ranchi': 582,\n",
+ " 'Cam Ranh': 583,\n",
+ " 'Bayrut': 584,\n",
+ " 'Ust Ilimsk': 585,\n",
+ " 'Curitiba': 586,\n",
+ " 'Czestochowa': 587,\n",
+ " 'Jishou': 588,\n",
+ " 'Padalarang': 589,\n",
+ " 'Pietermaritzburg': 590,\n",
+ " 'Craiova': 591,\n",
+ " 'Antakya': 592,\n",
+ " 'Barrie': 593,\n",
+ " 'Rach Gia': 594,\n",
+ " 'Constanta': 595,\n",
+ " 'Jhelum': 596,\n",
+ " 'Mahesana': 597,\n",
+ " 'Jiupu': 598,\n",
+ " 'Rengasdengklok': 599,\n",
+ " 'Conakry': 600,\n",
+ " 'Ciego De Ávila': 601,\n",
+ " 'London': 2893,\n",
+ " 'Zhangjiakou': 603,\n",
+ " 'Churu': 604,\n",
+ " 'Swansea': 605,\n",
+ " 'Ilebo': 606,\n",
+ " 'Tadepallegudem': 607,\n",
+ " 'Worcester': 1421,\n",
+ " 'Pyatigorsk': 609,\n",
+ " 'Tighina': 610,\n",
+ " 'Mingaora': 611,\n",
+ " 'Khartoum': 612,\n",
+ " 'Hanover': 613,\n",
+ " 'Vitória Da Conquista': 614,\n",
+ " 'Zapopan': 615,\n",
+ " 'Gulbarga': 616,\n",
+ " 'Gandhinagar': 617,\n",
+ " 'Maisuru': 618,\n",
+ " 'Leiyang': 619,\n",
+ " 'Bottrop': 620,\n",
+ " 'Chula Vista': 621,\n",
+ " 'Port Moresby': 622,\n",
+ " 'Opole': 623,\n",
+ " 'Pachuca': 624,\n",
+ " 'Swindon': 625,\n",
+ " 'Phra Pradaeng': 626,\n",
+ " 'Potchefstroom': 627,\n",
+ " 'Inglewood': 628,\n",
+ " 'Stavanger': 629,\n",
+ " 'Yonago': 630,\n",
+ " 'Arusha': 631,\n",
+ " 'Kalmunai': 632,\n",
+ " 'Stara Zagora': 633,\n",
+ " 'Caxias': 634,\n",
+ " 'Floridablanca': 635,\n",
+ " 'Sambhal': 636,\n",
+ " 'Piura': 637,\n",
+ " 'Kosice': 638,\n",
+ " 'Laiyang': 639,\n",
+ " 'Bankura': 640,\n",
+ " 'Cikarang': 641,\n",
+ " 'Humen': 642,\n",
+ " 'Lengshuijiang': 643,\n",
+ " 'Tanza': 644,\n",
+ " 'Chorzow': 645,\n",
+ " 'Bielefeld': 646,\n",
+ " 'Mazatlán': 647,\n",
+ " 'Thiès': 648,\n",
+ " 'Cavite': 649,\n",
+ " 'Shuangyashan': 650,\n",
+ " 'Ipswich': 651,\n",
+ " 'San Antonio': 652,\n",
+ " 'Bitung': 653,\n",
+ " 'Sohag': 654,\n",
+ " 'Garden Grove': 655,\n",
+ " 'Brescia': 656,\n",
+ " 'Veracruz': 657,\n",
+ " 'Asfi': 658,\n",
+ " 'Guatemala City': 659,\n",
+ " 'Evansville': 660,\n",
+ " 'Gelsenkirchen': 661,\n",
+ " 'Musashino': 662,\n",
+ " 'Geneva': 663,\n",
+ " 'Hamamatsu': 664,\n",
+ " 'Pittsburgh': 665,\n",
+ " 'Managua': 666,\n",
+ " 'Surendranagar': 667,\n",
+ " 'Palmira': 668,\n",
+ " 'Pingdingshan': 669,\n",
+ " 'Livingstone': 670,\n",
+ " 'Bangalore': 671,\n",
+ " 'Kigali': 672,\n",
+ " 'Manbij': 673,\n",
+ " 'Parakou': 674,\n",
+ " 'Teluknaga': 675,\n",
+ " 'Tongchuan': 676,\n",
+ " 'Koszalin': 677,\n",
+ " 'Manta': 678,\n",
+ " 'Ankang': 679,\n",
+ " 'Las Vegas': 680,\n",
+ " 'Kpalimé': 681,\n",
+ " 'Botad': 682,\n",
+ " 'Pingtung': 683,\n",
+ " 'Akyab': 684,\n",
+ " 'Puerto Plata': 685,\n",
+ " 'San Fernando': 686,\n",
+ " 'Unnao': 687,\n",
+ " 'Usak': 688,\n",
+ " 'Zlatoust': 689,\n",
+ " 'Catanduva': 690,\n",
+ " 'Chandannagar': 691,\n",
+ " 'Pasto': 692,\n",
+ " 'Daska': 693,\n",
+ " 'Chifeng': 694,\n",
+ " 'Kendari': 695,\n",
+ " 'López Mateos': 696,\n",
+ " 'Muzaffarnagar': 697,\n",
+ " 'Odintsovo': 698,\n",
+ " 'Tianjin': 699,\n",
+ " 'Tajimi': 700,\n",
+ " 'Córdoba': 2887,\n",
+ " 'Zhezkazgan': 702,\n",
+ " 'Bern': 703,\n",
+ " 'Plano': 704,\n",
+ " 'Lumajang': 705,\n",
+ " 'La Plata': 706,\n",
+ " 'Rockford': 707,\n",
+ " 'Volgograd': 708,\n",
+ " 'Nakuru': 709,\n",
+ " 'Camagüey': 710,\n",
+ " 'Banja Luka': 711,\n",
+ " 'Nueva San Salvador': 712,\n",
+ " 'Plock': 713,\n",
+ " 'Isehara': 714,\n",
+ " 'Ashqelon': 715,\n",
+ " 'Ramat Gan': 716,\n",
+ " 'Kiel': 717,\n",
+ " 'Sikar': 718,\n",
+ " 'Torrance': 719,\n",
+ " 'Haicheng': 720,\n",
+ " 'Haldwani': 721,\n",
+ " 'Shiyan': 722,\n",
+ " 'Brahmapur': 723,\n",
+ " 'Funabashi': 724,\n",
+ " 'Bellevue': 725,\n",
+ " 'Comodoro Rivadavia': 726,\n",
+ " 'Gondar': 727,\n",
+ " 'Murmansk': 728,\n",
+ " 'Gaomi': 729,\n",
+ " 'Banyuwangi': 730,\n",
+ " 'Guaíba': 731,\n",
+ " 'Surat': 732,\n",
+ " 'Sabratah': 733,\n",
+ " 'Guatire': 734,\n",
+ " 'Sterlitamak': 735,\n",
+ " 'Gombe': 736,\n",
+ " 'Kananga': 737,\n",
+ " 'Lausanne': 738,\n",
+ " 'Baripada': 739,\n",
+ " 'Erzincan': 740,\n",
+ " 'Jalingo': 741,\n",
+ " 'Lakhnau': 742,\n",
+ " 'Longjing': 743,\n",
+ " 'Saitama': 744,\n",
+ " 'Shangrao': 745,\n",
+ " 'Mandya': 746,\n",
+ " 'Shulin': 747,\n",
+ " 'Touliu': 748,\n",
+ " 'Birganj': 749,\n",
+ " 'Cabanatuan': 750,\n",
+ " 'Sucre': 751,\n",
+ " 'Panamá': 752,\n",
+ " 'Temuco': 753,\n",
+ " 'Oviedo': 754,\n",
+ " 'Satu Mare': 755,\n",
+ " 'Inazawa': 756,\n",
+ " 'Otaru': 757,\n",
+ " 'Badaojiang': 758,\n",
+ " 'Erode': 759,\n",
+ " 'Apodaca': 760,\n",
+ " 'Gaya': 761,\n",
+ " 'Cabo Frio': 762,\n",
+ " 'Metepec': 763,\n",
+ " 'Rosario': 764,\n",
+ " 'Toyota': 765,\n",
+ " 'Ulaanbaatar': 766,\n",
+ " 'Bergen': 767,\n",
+ " 'Corpus Christi': 768,\n",
+ " 'Jagadhri': 769,\n",
+ " 'Surgut': 770,\n",
+ " 'Peristérion': 771,\n",
+ " 'Koidu': 772,\n",
+ " 'Waterbury': 773,\n",
+ " 'Machala': 774,\n",
+ " 'Rajpur': 775,\n",
+ " 'Shenzhen': 776,\n",
+ " 'Carrefour': 777,\n",
+ " 'Londrina': 778,\n",
+ " 'Tokyo': 779,\n",
+ " 'Oberhausen': 780,\n",
+ " 'Jamalpur': 1813,\n",
+ " 'Rangkasbitung': 782,\n",
+ " 'São José Dos Campos': 783,\n",
+ " 'Salihorsk': 784,\n",
+ " 'Hamm': 785,\n",
+ " 'Sirsa': 786,\n",
+ " 'Beira': 787,\n",
+ " 'Yelets': 788,\n",
+ " 'Turgutlu': 789,\n",
+ " 'Emmen': 790,\n",
+ " 'Takatsuki': 791,\n",
+ " 'Móstoles': 792,\n",
+ " 'Sobral': 793,\n",
+ " 'Bhind': 794,\n",
+ " 'Macaé': 795,\n",
+ " 'El Tigre': 796,\n",
+ " 'Kousséri': 797,\n",
+ " 'Little Rock': 798,\n",
+ " 'Moers': 799,\n",
+ " 'Payakumbuh': 800,\n",
+ " 'Podgorica': 801,\n",
+ " 'Yokkaichi': 802,\n",
+ " 'Ardabil': 803,\n",
+ " 'Boksburg': 804,\n",
+ " 'Ara': 805,\n",
+ " 'Foz Do Iguaçu': 806,\n",
+ " 'Huddersfield': 807,\n",
+ " 'Ogaki': 808,\n",
+ " 'Yaizu': 809,\n",
+ " 'Dindigul': 810,\n",
+ " 'Tainan': 811,\n",
+ " 'Lowell': 812,\n",
+ " 'Oradea': 813,\n",
+ " 'Lower Hutt': 814,\n",
+ " 'Bhatpara': 815,\n",
+ " 'Durrës': 816,\n",
+ " 'Baiyin': 817,\n",
+ " 'Newcastle': 2231,\n",
+ " 'Baliuag': 819,\n",
+ " 'Coro': 820,\n",
+ " 'Kallithéa': 821,\n",
+ " 'Gejiu': 822,\n",
+ " 'Tlaquepaque': 823,\n",
+ " 'Cincinnati': 824,\n",
+ " 'Ciudad Bolívar': 825,\n",
+ " 'Nouakchott': 826,\n",
+ " 'Catamarca': 827,\n",
+ " 'Dum Dum': 828,\n",
+ " 'Kolhapur': 829,\n",
+ " 'Gazni': 830,\n",
+ " 'Nassau': 831,\n",
+ " 'Chisinau': 832,\n",
+ " 'Nyíregyháza': 833,\n",
+ " 'Heidelberg': 834,\n",
+ " 'Soka': 835,\n",
+ " 'Haldia': 836,\n",
+ " 'Sabha': 837,\n",
+ " 'Kingston': 1485,\n",
+ " 'Tenali': 839,\n",
+ " 'Sanmenxia': 840,\n",
+ " 'San Rafael': 841,\n",
+ " 'Västerås': 842,\n",
+ " 'Anyang': 843,\n",
+ " 'São João De Meriti': 844,\n",
+ " 'Seremban': 845,\n",
+ " 'Scottsdale': 846,\n",
+ " 'Rio Grande': 847,\n",
+ " 'Darjiling': 848,\n",
+ " 'Medellín': 849,\n",
+ " 'Taizhou': 850,\n",
+ " 'Stamford': 851,\n",
+ " 'Aguascalientes': 852,\n",
+ " 'Magnitogorsk': 853,\n",
+ " 'Namangan': 854,\n",
+ " 'Latina': 856,\n",
+ " 'Loja': 857,\n",
+ " 'Nsukka': 858,\n",
+ " 'Shaoguan': 859,\n",
+ " 'Madiun': 860,\n",
+ " 'Komaki': 861,\n",
+ " 'Townsville': 862,\n",
+ " 'Simi Valley': 863,\n",
+ " 'Neyshabur': 864,\n",
+ " 'Poznan': 865,\n",
+ " 'Chelyabinsk': 866,\n",
+ " 'Mesa': 867,\n",
+ " 'Babol': 868,\n",
+ " 'Huangpu': 869,\n",
+ " 'Apeldoorn': 870,\n",
+ " 'Chandausi': 871,\n",
+ " 'Limeira': 872,\n",
+ " 'Marivan': 873,\n",
+ " 'Tempe': 874,\n",
+ " 'Balikpapan': 875,\n",
+ " 'Sawai Madhopur': 876,\n",
+ " 'Xinyang': 877,\n",
+ " 'Higüey': 878,\n",
+ " 'Iskenderun': 879,\n",
+ " 'Jambi': 880,\n",
+ " 'Dhule': 881,\n",
+ " 'Ludwigshafen': 882,\n",
+ " 'Cartagena': 2566,\n",
+ " 'Dawukou': 884,\n",
+ " 'Tarlac': 885,\n",
+ " 'Piatra Neamt': 886,\n",
+ " 'Pretoria': 887,\n",
+ " 'Meilu': 888,\n",
+ " 'Kikwit': 889,\n",
+ " 'Ghaziabad': 890,\n",
+ " 'Leicester': 891,\n",
+ " 'Salem': 892,\n",
+ " 'Mangaluru': 893,\n",
+ " 'Valencia': 1221,\n",
+ " 'Shahjahanpur': 895,\n",
+ " 'Tabuk': 896,\n",
+ " 'Chhindwara': 897,\n",
+ " 'Kurume': 898,\n",
+ " 'Novokuznetsk': 899,\n",
+ " 'Leninsk Kuznetskiy': 900,\n",
+ " 'Yangzhou': 901,\n",
+ " 'Kawasaki': 902,\n",
+ " 'Kariya': 903,\n",
+ " 'Hangu': 904,\n",
+ " 'Columbus': 905,\n",
+ " 'Sudbury': 906,\n",
+ " 'Bujumbura': 907,\n",
+ " 'Koshigaya': 908,\n",
+ " 'Lahore': 909,\n",
+ " 'Da Nang': 910,\n",
+ " 'Ribeirão Prêto': 911,\n",
+ " 'Catia La Mar': 912,\n",
+ " 'Tongliao': 913,\n",
+ " 'Cologne': 914,\n",
+ " 'Jolo': 915,\n",
+ " 'Do Rud': 916,\n",
+ " 'Drobeta Turnu Severin': 917,\n",
+ " 'Corrientes': 918,\n",
+ " 'Qinhuangdao': 919,\n",
+ " 'Norman': 920,\n",
+ " 'Tiruchchirappalli': 921,\n",
+ " 'Salatiga': 922,\n",
+ " 'Yüanlin': 923,\n",
+ " 'Derbent': 924,\n",
+ " 'Khujand': 925,\n",
+ " 'Reading': 926,\n",
+ " 'Tanjung Morawa': 927,\n",
+ " 'Maroua': 928,\n",
+ " 'Hailun': 929,\n",
+ " 'Newark': 930,\n",
+ " 'Southend On Sea': 931,\n",
+ " 'Cadiz': 1579,\n",
+ " 'Port Saint Lucie': 933,\n",
+ " 'Hafizabad': 934,\n",
+ " 'Lalitpur': 1241,\n",
+ " 'Ananindeua': 936,\n",
+ " 'Chaoyang': 937,\n",
+ " 'Bilbao': 938,\n",
+ " 'Freiburg': 939,\n",
+ " 'Miskolc': 940,\n",
+ " 'Thanesar': 941,\n",
+ " 'Campos': 942,\n",
+ " 'Santander': 943,\n",
+ " 'Nizamabad': 944,\n",
+ " 'Presidente Prudente': 945,\n",
+ " 'Udupi': 946,\n",
+ " 'Sanhsia': 947,\n",
+ " 'Kumasi': 948,\n",
+ " 'Fernando De La Mora': 949,\n",
+ " 'Tucson': 950,\n",
+ " 'Cusco': 951,\n",
+ " 'Maicao': 952,\n",
+ " 'Petrozavodsk': 953,\n",
+ " 'Guelph': 954,\n",
+ " 'Glazov': 955,\n",
+ " 'Aligarh': 956,\n",
+ " 'Samut Prakan': 957,\n",
+ " 'Sagar': 958,\n",
+ " 'Médéa': 959,\n",
+ " 'Duque De Caxias': 960,\n",
+ " 'Kodaira': 961,\n",
+ " 'Vigo': 962,\n",
+ " 'Florencia': 963,\n",
+ " 'Ciparay': 964,\n",
+ " 'Salalah': 965,\n",
+ " 'Kitakyushu': 966,\n",
+ " 'Murcia': 967,\n",
+ " 'Liaocheng': 968,\n",
+ " 'Akola': 969,\n",
+ " 'Split': 970,\n",
+ " 'Bamenda': 971,\n",
+ " 'Kazan': 972,\n",
+ " 'Asunción': 973,\n",
+ " 'Nanjing': 974,\n",
+ " 'Karang Tengah': 975,\n",
+ " 'Tacoma': 976,\n",
+ " 'Fresnillo': 977,\n",
+ " 'Imperatriz': 978,\n",
+ " 'El Mahalla El Kubra': 979,\n",
+ " 'Rouen': 980,\n",
+ " 'Islamabad': 981,\n",
+ " 'Birigui': 982,\n",
+ " 'San Cristóbal': 2638,\n",
+ " 'Dinajpur': 984,\n",
+ " 'Loudi': 985,\n",
+ " 'Udon Thani': 986,\n",
+ " 'Asahikawa': 987,\n",
+ " 'Horlivka': 988,\n",
+ " 'Miyakonojo': 989,\n",
+ " 'Salzgitter': 990,\n",
+ " 'Camaragibe': 991,\n",
+ " 'Chillan': 992,\n",
+ " 'Jember': 993,\n",
+ " 'Tripoli': 994,\n",
+ " 'Winnipeg': 995,\n",
+ " 'Panvel': 996,\n",
+ " 'Zoetermeer': 997,\n",
+ " 'Saharanpur': 998,\n",
+ " 'São Vicente': 999,\n",
+ " 'Abadan': 1000,\n",
+ " 'Volzhskiy': 1001,\n",
+ " 'Sialkot': 1002,\n",
+ " 'Indore': 1003,\n",
+ " ...}"
+ ]
+ },
+ "execution_count": 19,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# City IDs Dictionary\n",
+ "\n",
+ "city_table_values=execute_sql_statement(\"select * from City_Table \",conn)\n",
+ "city_ids={}\n",
+ "for i in city_table_values:\n",
+ " city_ids[i[1]]=i[0]\n",
+ "city_ids\n",
+ " "
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 20,
+ "id": "fcd18ad9",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Create the Temperature Table\n",
+ "\n",
+ "create_table(conn,'''CREATE TABLE Temperature (PK INTEGER PRIMARY KEY , Date VARCHAR, Avg_Temperature VARCHAR, City_ID INTEGER,\n",
+ "FOREIGN KEY(City_ID) REFERENCES City_Table(City_Id))''')"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 21,
+ "id": "e1a0d17e",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Allocate the data to the Temperature Table and their corresponding City IDs\n",
+ "\n",
+ "temp_table_values=[]\n",
+ "j=1\n",
+ "for i in result:\n",
+ " j=j+1\n",
+ " temp_table_values.append((i[0],i[1],city_ids[i[3]]))"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 22,
+ "id": "fb218911",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "<sqlite3.Cursor at 0x7f7d40c2cce0>"
+ ]
+ },
+ "execution_count": 22,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Insert the data into the Temperature Table\n",
+ "\n",
+ "cur.executemany(\"INSERT INTO Temperature ('Date','Avg_Temperature','City_ID') Values (?,?,?)\",temp_table_values)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 23,
+ "id": "8e34f625",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/html": [
+ "<div>\n",
+ "<style scoped>\n",
+ " .dataframe tbody tr th:only-of-type {\n",
+ " vertical-align: middle;\n",
+ " }\n",
+ "\n",
+ " .dataframe tbody tr th {\n",
+ " vertical-align: top;\n",
+ " }\n",
+ "\n",
+ " .dataframe thead th {\n",
+ " text-align: right;\n",
+ " }\n",
+ "</style>\n",
+ "<table border=\"1\" class=\"dataframe\">\n",
+ " <thead>\n",
+ " <tr style=\"text-align: right;\">\n",
+ " <th></th>\n",
+ " <th>PK</th>\n",
+ " <th>Date</th>\n",
+ " <th>Avg_Temperature</th>\n",
+ " <th>City_ID</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1</td>\n",
+ " <td>1950-01-01</td>\n",
+ " <td>-0.712</td>\n",
+ " <td>1031</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>2</td>\n",
+ " <td>1950-02-01</td>\n",
+ " <td>1.423</td>\n",
+ " <td>1031</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>3</td>\n",
+ " <td>1950-03-01</td>\n",
+ " <td>4.166</td>\n",
+ " <td>1031</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>4</td>\n",
+ " <td>1950-04-01</td>\n",
+ " <td>6.743</td>\n",
+ " <td>1031</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>5</td>\n",
+ " <td>1950-05-01</td>\n",
+ " <td>12.714</td>\n",
+ " <td>1031</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>...</th>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685145</th>\n",
+ " <td>2685146</td>\n",
+ " <td>2013-05-01</td>\n",
+ " <td>11.464</td>\n",
+ " <td>1239</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685146</th>\n",
+ " <td>2685147</td>\n",
+ " <td>2013-06-01</td>\n",
+ " <td>15.043</td>\n",
+ " <td>1239</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685147</th>\n",
+ " <td>2685148</td>\n",
+ " <td>2013-07-01</td>\n",
+ " <td>18.775</td>\n",
+ " <td>1239</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685148</th>\n",
+ " <td>2685149</td>\n",
+ " <td>2013-08-01</td>\n",
+ " <td>18.025</td>\n",
+ " <td>1239</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685149</th>\n",
+ " <td>2685150</td>\n",
+ " <td>2013-09-01</td>\n",
+ " <td>None</td>\n",
+ " <td>1239</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "<p>2685150 rows × 4 columns</p>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " PK Date Avg_Temperature City_ID\n",
+ "0 1 1950-01-01 -0.712 1031\n",
+ "1 2 1950-02-01 1.423 1031\n",
+ "2 3 1950-03-01 4.166 1031\n",
+ "3 4 1950-04-01 6.743 1031\n",
+ "4 5 1950-05-01 12.714 1031\n",
+ "... ... ... ... ...\n",
+ "2685145 2685146 2013-05-01 11.464 1239\n",
+ "2685146 2685147 2013-06-01 15.043 1239\n",
+ "2685147 2685148 2013-07-01 18.775 1239\n",
+ "2685148 2685149 2013-08-01 18.025 1239\n",
+ "2685149 2685150 2013-09-01 None 1239\n",
+ "\n",
+ "[2685150 rows x 4 columns]"
+ ]
+ },
+ "metadata": {},
+ "output_type": "display_data"
+ }
+ ],
+ "source": [
+ "# Displaying the Temperature Table\n",
+ "\n",
+ "df1=pd.read_sql_query(\"Select * from Temperature\", conn)\n",
+ "display(df1)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 24,
+ "id": "f08f8148",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Create the Location Table\n",
+ "\n",
+ "create_table(conn,'''CREATE TABLE Loc_Table (ID INTEGER PRIMARY KEY , City_ID INTEGER, LAT FLOAT,LONG FLOAT,\n",
+ "FOREIGN KEY(City_ID) REFERENCES City_Table(City_ID))''')"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 25,
+ "id": "ee98ee19",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "[(1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (1031, 57.05, 10.33),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " (3415, 40.99, 27.69),\n",
+ " ...]"
+ ]
+ },
+ "execution_count": 25,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Extract the data for the Location Table, Database consists of N,W,E,S notation, we are going to convert them to the decimal notation\n",
+ "\n",
+ "#Lat= North is positive, South is negative\n",
+ "#Long= West is negative, East is positive\n",
+ "data_to_check_loc=result_data_for_loc_table\n",
+ "data_to_input_loc_table=[]\n",
+ "j=0\n",
+ "for i in data_to_check_loc:\n",
+ " t=[0,0,0]\n",
+ " if i[1][-1]=='N':\n",
+ " t[1]=(float(i[1][:-1]))\n",
+ " if i[1][-1]=='S':\n",
+ " t[1]=float(i[1][:-1])*(-1)\n",
+ " if i[2][-1]=='E':\n",
+ " t[2]=float(i[2][:-1]) \n",
+ " if i[2][-1]=='W':\n",
+ " t[2]=float(i[2][:-1])*(-1)\n",
+ " t[0]=i[0]\n",
+ " tuple1=(city_ids[t[0]],t[1],t[2])\n",
+ " data_to_input_loc_table.append(tuple1)\n",
+ "data_to_input_loc_table"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 26,
+ "id": "cc0fba0c",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "<sqlite3.Cursor at 0x7f7d40c2cce0>"
+ ]
+ },
+ "execution_count": 26,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "# Insert the data into the Location Table\n",
+ "\n",
+ "cur.executemany(\"INSERT INTO Loc_Table ('City_ID','LAT','LONG') Values (?,?,?)\",data_to_input_loc_table)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 27,
+ "id": "aead2755",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/html": [
+ "<div>\n",
+ "<style scoped>\n",
+ " .dataframe tbody tr th:only-of-type {\n",
+ " vertical-align: middle;\n",
+ " }\n",
+ "\n",
+ " .dataframe tbody tr th {\n",
+ " vertical-align: top;\n",
+ " }\n",
+ "\n",
+ " .dataframe thead th {\n",
+ " text-align: right;\n",
+ " }\n",
+ "</style>\n",
+ "<table border=\"1\" class=\"dataframe\">\n",
+ " <thead>\n",
+ " <tr style=\"text-align: right;\">\n",
+ " <th></th>\n",
+ " <th>ID</th>\n",
+ " <th>City_ID</th>\n",
+ " <th>LAT</th>\n",
+ " <th>LONG</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1</td>\n",
+ " <td>1031</td>\n",
+ " <td>57.05</td>\n",
+ " <td>10.33</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>2</td>\n",
+ " <td>1031</td>\n",
+ " <td>57.05</td>\n",
+ " <td>10.33</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>3</td>\n",
+ " <td>1031</td>\n",
+ " <td>57.05</td>\n",
+ " <td>10.33</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>4</td>\n",
+ " <td>1031</td>\n",
+ " <td>57.05</td>\n",
+ " <td>10.33</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>5</td>\n",
+ " <td>1031</td>\n",
+ " <td>57.05</td>\n",
+ " <td>10.33</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>...</th>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " <td>...</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685145</th>\n",
+ " <td>2685146</td>\n",
+ " <td>1239</td>\n",
+ " <td>52.24</td>\n",
+ " <td>5.26</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685146</th>\n",
+ " <td>2685147</td>\n",
+ " <td>1239</td>\n",
+ " <td>52.24</td>\n",
+ " <td>5.26</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685147</th>\n",
+ " <td>2685148</td>\n",
+ " <td>1239</td>\n",
+ " <td>52.24</td>\n",
+ " <td>5.26</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685148</th>\n",
+ " <td>2685149</td>\n",
+ " <td>1239</td>\n",
+ " <td>52.24</td>\n",
+ " <td>5.26</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2685149</th>\n",
+ " <td>2685150</td>\n",
+ " <td>1239</td>\n",
+ " <td>52.24</td>\n",
+ " <td>5.26</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "<p>2685150 rows × 4 columns</p>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " ID City_ID LAT LONG\n",
+ "0 1 1031 57.05 10.33\n",
+ "1 2 1031 57.05 10.33\n",
+ "2 3 1031 57.05 10.33\n",
+ "3 4 1031 57.05 10.33\n",
+ "4 5 1031 57.05 10.33\n",
+ "... ... ... ... ...\n",
+ "2685145 2685146 1239 52.24 5.26\n",
+ "2685146 2685147 1239 52.24 5.26\n",
+ "2685147 2685148 1239 52.24 5.26\n",
+ "2685148 2685149 1239 52.24 5.26\n",
+ "2685149 2685150 1239 52.24 5.26\n",
+ "\n",
+ "[2685150 rows x 4 columns]"
+ ]
+ },
+ "metadata": {},
+ "output_type": "display_data"
+ }
+ ],
+ "source": [
+ "# Displaying the Location Table\n",
+ "\n",
+ "df1=pd.read_sql_query(\"Select * from Loc_Table \", conn)\n",
+ "display(df1)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 34,
+ "id": "f67e8d5b",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# df1=pd.read_sql_query(\"select * from Loc_Table join Temperature on Loc_Table.City_ID=Temperature.City_ID join city_table on city_table.city_id=Temperature.City_ID join country_table on country_table.pk=city_table.country_id group by Date LIMIT 10\", conn)\n",
+ "# display(df1)\n",
+ "#(\"select * from Loc_Table join Temperature on Loc_Table.City_ID=Temperature.City_ID join city_table on city_table.city_id=Temperature.City_ID join country_table on country_table.pk=city_table.country_id LIMIT 10\",conn)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 29,
+ "id": "cbc5ad63",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "# Commit the changes\n",
+ "\n",
+ "conn.commit()"
+ ]
+ }
+ ],
+ "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.8.8"
+ }
+ },
+ "nbformat": 4,
+ "nbformat_minor": 5
+}
generated by cgit v1.2.3 (git 2.25.1) at 2026-06-06 03:45:24 +0000