From b8e66f213d0df36cb584685a34276d8c45882e71 Mon Sep 17 00:00:00 2001
From: Roman Bazalevsky <rvb@rvb.name>
Date: Thu, 31 Jul 2014 14:29:23 +0400
Subject: [PATCH 1/1] OSM tile rendering queue added

---
 render_tiles.py | 52 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 52 insertions(+)
 create mode 100644 render_tiles.py

diff --git a/render_tiles.py b/render_tiles.py
new file mode 100644
index 0000000..1c57b0b
--- /dev/null
+++ b/render_tiles.py
@@ -0,0 +1,52 @@
+#!/usr/bin/env python
+# coding: UTF-8
+
+import sqlite3
+
+import math
+
+def queue_render(db,filename):
+
+  conn = sqlite3.connect(db)
+  cur = conn.cursor()
+    
+  cur.execute("select minlat,minlon,maxlat,maxlon from tracks where filename=?" , (filename.decode('UTF-8'),))
+  
+  minlat,minlon,maxlat,maxlon=cur.fetchone()  
+  
+  # определяем примерный стартовый зум
+  
+  minlatrad = math.radians(minlat)
+  maxlatrad = math.radians(maxlat)
+  
+  minx = (minlon + 180.0)/360.0
+  maxx = (maxlon + 180.0)/360.0
+  
+  miny = (1.0 - math.log(math.tan(minlatrad) + (1 / math.cos(minlatrad))) / math.pi) / 2.0
+  maxy = (1.0 - math.log(math.tan(maxlatrad) + (1 / math.cos(maxlatrad))) / math.pi) / 2.0
+
+  if minx>maxx:
+    minx,maxx = maxx,minx
+    
+  if miny>maxy:
+    miny,maxy = maxy,miny
+  
+  for zoom in range(9,16):
+    
+    n = 2 ** zoom
+    
+    minxt = int(minx * n)
+    minyt = int(miny * n)
+    maxxt = int(maxx * n)
+    maxyt = int(maxy * n)
+    
+    ins = conn.cursor()
+    print zoom,minxt,maxxt,minyt,maxyt
+    ins.execute('insert into render_queue(zoom,minx,maxx,miny,maxy) values(?,?,?,?,?)',(zoom,minxt,maxxt,minyt,maxyt))
+
+    if (maxxt-minxt>16) or (maxyt-minyt>12):
+      conn.commit()
+      break
+
+  conn.commit()        
+  
\ No newline at end of file
-- 
2.34.1