In [5]:

    

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


    

    




Populating the interactive namespace from numpy and matplotlib

In [6]:

    

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 as 'latitudT', longitud as 'longitudT',UNIX_TIMESTAMP(fecha) as 'time'FROM posicionesgps WHERE latitud <> 0 AND longitud <> 0 AND recurso='12082781' 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
0






    




/usr/local/lib/python2.7/dist-packages/matplotlib/axes/_axes.py:519: UserWarning: No labelled objects found. Use label='...' kwarg on individual plots.
  warnings.warn("No labelled objects found. "






    













    

In [ ]:

    

print