notebook.community

Edit and run



In [1]:

    
from dbscanner import dbscanner
from algorithms.db import connect_db
%pylab inline









    



Populating the interactive namespace from numpy and matplotlib

Nos conectamos a la base de datos y obtenemos los datos



In [2]:

    
cur= connect_db("bahia")
#recurso = "tetra:12086044"
recurso = "tetra:12082781"
limit = 2000
#cmd = "SELECT latitud, longitud, UNIX_TIMESTAMP(fecha) FROM posicionesgps WHERE latitud <> 0 and longitud <> 0 and recurso=\"{0}\" LIMIT {1};".format(recurso, limit)
cmd= "SELECT (latitud + 0.223)/0.022 as 'latitudT', (longitud + 0.665)/0.065 as 'longitudT',(UNIX_TIMESTAMP(fecha) - 1424174494.89)/104277.37 as 'time'FROM posicionesgps WHERE latitud <> 0 AND longitud <> 0 AND recurso='tetra:12082364' LIMIT 2000;"
cur.execute(cmd)

a=[]
for pos in cur.fetchall():
    a.append([pos[0], pos[1], pos[2]])

Data = a
eps = 0.001
MinPts=5

dbc = dbscanner()
dbc.dbscan(Data, eps, MinPts)









    



NUMERO DE ITERACIONES
111



In [ ]: