aboutsummaryrefslogtreecommitdiff
path: root/database_files
diff options
context:
space:
mode:
Diffstat (limited to 'database_files')
-rw-r--r--database_files/GlobalLandTemperaturesByCity.csv3
-rw-r--r--database_files/dbcreation.ipynb4381
-rw-r--r--database_files/pythonproject.db3
3 files changed, 0 insertions, 4387 deletions
diff --git a/database_files/GlobalLandTemperaturesByCity.csv b/database_files/GlobalLandTemperaturesByCity.csv
deleted file mode 100644
index b980b00..0000000
--- a/database_files/GlobalLandTemperaturesByCity.csv
+++ /dev/null
@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:9be86b51487f10e811a0ab43a75946739dfe7bea2342ddcd1f6bc48d51b8c493
-size 532830464
diff --git a/database_files/dbcreation.ipynb b/database_files/dbcreation.ipynb
deleted file mode 100644
index 95e6ba0..0000000
--- a/database_files/dbcreation.ipynb
+++ /dev/null
@@ -1,4381 +0,0 @@
-{
- "cells": [
- {
- "cell_type": "code",
- "execution_count": 1,
- "id": "50043e80",
- "metadata": {},
- "outputs": [],
- "source": [
- "from IPython.display import display, HTML\n",
- "import pandas as pd\n",
- "import sqlite3\n",
- "from sqlite3 import Error\n",
- "\n",
- "def create_connection(db_file, delete_db=False):\n",
- " import os\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\n",
- "\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)\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": [
- "import pandas as pd\n",
- "df=pd.read_csv(\"GlobalLandTemperaturesByCity.csv\")\n",
- "data=df[df.dt>\"1949-12-31\"]\n",
- "data\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": [
- "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)\n",
- "result_data_for_loc_table"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 4,
- "id": "e635279c",
- "metadata": {},
- "outputs": [],
- "source": [
- "records=data.to_records(index=False)\n",
- "result=list(records)\n",
- "req_resut=[]\n",
- "#j=0\n",
- "for i in result:\n",
- " # j=j+1\n",
- " req_resut.append((i[4],))\n",
- " #if j==10:\n",
- " # break\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": [
- "req_resut=list((set(req_resut)))\n",
- "req_resut"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 6,
- "id": "0551a70c",
- "metadata": {},
- "outputs": [],
- "source": [
- "#req_result_2=[]\n",
- "#j=0\n",
- "#for i in result:\n",
- "# j=j+1\n",
- " \n",
- "# req_result_2.append((i[3],i[4]))\n",
- "# if j==10:\n",
- " # break\n",
- "#print(req_result_2)\n"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 8,
- "id": "21eca337",
- "metadata": {},
- "outputs": [],
- "source": [
- "conn = create_connection('pythonproject.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": [
- "execute_sql_statement(\"DROP TABLE IF EXISTS City_Table\",conn)\n",
- "execute_sql_statement(\"DROP TABLE IF EXISTS Country_Table\",conn)\n",
- "#execute_sql_statement(\"DROP TABLE IF EXISTS City_Table\",conn)\n",
- "#execute_sql_statement(\"DROP TABLE IF EXISTS Temperature_Table\",conn)\n",
- "create_table(conn,'''CREATE TABLE Country_Table (PK INTEGER PRIMARY KEY, Country_Name VARCHAR)''')\n",
- "#create_table(conn,'''CREATE TABLE City_Table (PK INTEGER PRIMARY KEY, City_Name VARCHAR , Country_Name VARCHAR,\n",
- "#FOREIGN KEY(Country_Name) REFERENCES Country_Table(Country_Name))''')\n",
- "#create_table(conn,'''CREATE TABLE Temperature_Table (PK INTEGER PRIMARY KEY, DATE VARCHAR , Avg_Temp VARCHAR , City_Name VARCHAR , Country_Name VARCHAR,\n",
- "#FOREIGN KEY(City_Name) REFERENCES City_Table(City_Name),FOREIGN KEY(Country_Name) REFERENCES Country_Table(Country_Name))''')\n",
- "# for i in result:\n",
- "# a,b,c=i[4],i[5],i[6]\n",
- " #print(type(a),type(b),type(c))\n",
- " #print(a,b,c)\n",
- " #print(\"\"\"INSERT INTO Country_Table ('Country_Name','LAT','LONG') Values ('\"\"\"+i[4]+\"'\"+\",'\"+i[5]+\"','\"+i[6]+\"')\")\n",
- " #print(a,b,c)\n",
- " #print(f'''INSERT INTO Country_Table ('Country_Name','LAT','LONG') Values ('{i[4]}','{i[5]}','{i[6]}')''')\n",
- "cur.executemany(\"INSERT INTO Country_Table ('Country_Name') Values (?)\",req_resut)\n",
- "#cur.executemany(\"INSERT INTO City_Table ('City_Name','Country_Name') Values (?,?)\",req_result_2)\n",
- "#cur.executemany(\"INSERT INTO Temperature_Table ('DATE','Avg_Temp','City_Name','Country_Name') Values (?,?,?,?)\",req_result_3)\n",
- "\n",
- "\n",
- " \n"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 10,
- "id": "59930452",
- "metadata": {},
- "outputs": [],
- "source": [
- "abc=execute_sql_statement(\"Select * from Country_Table\", conn)\n",
- "abc1={}\n",
- "for i in abc:\n",
- " abc1[i[1]]=i[0]\n",
- "#abc1\n"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 11,
- "id": "52c77691",
- "metadata": {},
- "outputs": [],
- "source": [
- "req_result_2=[]\n",
- "#j=0\n",
- "for i in result:\n",
- " \n",
- " #j=j+1\n",
- " req_result_2.append((i[3],abc1[i[4]]))\n",
- " # if j==10:\n",
- " #break\n",
- "#print(req_result_2)\n",
- "\n"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 12,
- "id": "f5b64360",
- "metadata": {},
- "outputs": [],
- "source": [
- "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": [
- "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)))\n",
- "\n",
- "#for i in city_country_unique:\n",
- " # i[1]=abc1[i[1]]\n",
- "#city_country_unique "
- ]
- },
- {
- "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": [
- "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": 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": [
- "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": [
- "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_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_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": [
- "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]]))\n",
- "#temp_table_values"
- ]
- },
- {
- "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": [
- "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": [
- "df1=pd.read_sql_query(\"Select * from Temperature\", conn)\n",
- "display(df1)"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 24,
- "id": "f08f8148",
- "metadata": {},
- "outputs": [],
- "source": [
- "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": [
- "#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": [
- "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": [
- "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": 15,
- "id": "3fd0999a",
- "metadata": {},
- "outputs": [],
- "source": [
- "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": 29,
- "id": "cbc5ad63",
- "metadata": {},
- "outputs": [],
- "source": [
- "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
-}
diff --git a/database_files/pythonproject.db b/database_files/pythonproject.db
deleted file mode 100644
index 055da59..0000000
--- a/database_files/pythonproject.db
+++ /dev/null
@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:4e543fc52dfaba299c76e4eaf8451a1291487ac2af315cc600975d244cbb7e5b
-size 156913664
generated by cgit v1.2.3 (git 2.25.1) at 2026-06-06 05:16:54 +0000