Drop sqared positions from database

[wifihood] / wifiscanner / wifimap / db.py

diff --git a/wifiscanner/wifimap/db.py b/wifiscanner/wifimap/db.py
index e5a4c45..20645ce 100644 (file)
--- a/wifiscanner/wifimap/db.py
+++ b/wifiscanner/wifimap/db.py
@@ -9,10 +9,7 @@ create_db = """
         n INTEGER DEFAULT 0,
         lat REAL DEFAULT 0,
         lon REAL DEFAULT 0,
-        alt REAL DEFAULT 0,
-        lat2 REAL DEFAULT 0,
-        lon2 REAL DEFAULT 0,
-        alt2 REAL DEFAULT 0
+        alt REAL DEFAULT 0
         );
 """
 
@@ -53,9 +50,9 @@ class database :
         query = []
         lat , lon , alt = gps
         if lat and lon :
-            query.append( "lat=lat+%f , lat2=lat2+%f , lon=lon+%f , lon2=lon2+%f" % ( lat , lat*lat , lon , lon*lon ) )
+            query.append( "lat=lat+%f , lon=lon+%f" % ( lat , lon ) )
         if alt :
-            query.append( "alt=alt+%f , alt2=alt2+%f" % ( alt , alt*alt ) )
+            query.append( "alt=alt+%f" % ( alt ) )
         return " , ".join( query )
 
     def add ( self , mac , rss , timestamp , gps ) :