# To search efficiently
from sklearn.neighbors import KDTree
# To connect to databases
from helperFunctions import Graph
from helperFunctions import connectZEO
from helperFunctions import connectMySQL
from helperFunctions import connectMongo
from helperFunctions import containerWait
from helperFunctions import managementUpdate
from helperFunctions import managementCompare
##### Run Program
# Wait for the MySQL server to start
containerWait()
try:
# Connect to ZODB
root = connectZEO()
# Connect to MongoDb
cluster, db_mongo, collection = connectMongo(collection='shortest')
# Connect to MySQL and get cursor
db_mysql, cur = connectMySQL()
##### Iterate Over All Cities And Download OSM-Graph
# Iterate over all cities
import os
# To connect to databases
from helperFunctions import connectMySQL
from helperFunctions import containerWait
from helperFunctions import managementUpdate
##### Setup Program
# Folder for the data files to load
folder_data = 'data'
##### Run Program
# Wait for the MySQL server to start
containerWait(sleep=20)
try:
# Connect to MySQL and get cursor
db_mysql, cur = connectMySQL()
##### Check If Update Is Needed
# Get last insert-timestamp
sql_query = 'SELECT last_location_insert FROM management WHERE id=1'
cur.execute(sql_query)
time_insert = cur.fetchone()
# Get last file-timestamp
time_files = max([
