In [ ]:

    

"""
Returns a OD MATRIX using only ORIGINS registed in one table

Apply Trip-Chaining Method 
"""


    

In [1]:

    

# PARAMETERS
conParam = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "matrix_carris"
}

FILTER_DAY = [
    #'2018-01-08', '2018-01-09', '2018-01-10', '2018-01-11', '2018-01-12', '2018-01-15',
    #'2018-01-16', '2018-01-17', '2018-01-18', '2018-01-19', '2018-01-22', '2018-01-23',
    #'2018-01-24', '2018-01-25', '2018-01-26', '2018-01-29', '2018-01-30', '2018-01-31'
    '2018-01-18'
]

FILTER_TIME = ['04:00:00', '05:00:00']

TABLES_SCHEMA = {
    "VALIDATIONS" : {
        "TNAME"  : "idparesod",
        "DAY"    : "dia",
        "TIME"   : "tempo",
        "HOUR"   : "hora",
        "MINUTE" : "minuto",
        "SECOND" : "segundo",
        "ROUTE"  : "fid_percurso",
        "STOP"   : "paragem",
        "CLIENT" : "ncartao"
    },
    "ISOCHRONES" : {
        "TNAME"  : "isocronas",
        "STOP"   : "id",
        "GEOM"   : "geom"
    },
    "STOPS" : {
        "TNAME" : "percursos_geom_v2",
        "ROUTE" : "fid_percurso",
        "STOP"  : "paragem",
        "GEOM"  : "geom"
    }
}

output = r'D:\gis\matrix_od_v18012018_4as5.xlsx'


    

In [2]:

    

from senpy.pgsql.transportation.matrixod import trip_chain_meth
import datetime


    

In [3]:

    

time_a = datetime.datetime.now()


    

In [ ]:

    

trip_chain_meth(conParam, TABLES_SCHEMA, output, FILTER_DAY=FILTER_DAY, FILTER_TIME=FILTER_TIME)
time_b = datetime.datetime.now()
delta = time_b - time_a

print delta


    

In [ ]: