In [ ]:

    

from senpy.toemme.psql import write_emme_routes_file

conPsql = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "gtfs_carris"
}

db_schema = {
    "ROUTES" : {
        "TNAME"  : "routes", #TABLE NAME
        "ID"     : "route_id", # FIELD NAME
        "SHORT"  : "route_short_name", # FIELD NAME
        "LONG"   : "route_long_name",
        "AGENCY" : "agency_id"
    },
    "STOP_TIMES" : {
        "TNAME"     : "stop_times_original",
        "TRIP"      : "trip_id",
        "STOP"      : "stop_id",
        "SEQUENCE"  : "stop_sequence",
        "DEPARTURE" : "departure_time"
    },
    "TRIPS" : {
        "TNAME"   : "trips",
        "TRIP"    : "trip_id",
        "ROUTE"   : "route_id",
        "SERVICE" : "service_id"
    },
    "AGENCY" : {
        "TNAME" : "agency",
        "ID"    : "agency_id",
        "NAME"  : "agency_name"
    },
    "CALENDAR" : {
        "TNAME"   : "calendar_dates",
        "SERVICE" : "service_id",
        "DATE"    : "date"
    },
    "ROUTES_EXTRA" : {
        "TNAME" : "percursos_v3",
        "ROUTE" : "fid_percurso",
        "STOP"  : "paragem",
        "ORDER" : "ordem"
    },
    "TRIP_VEHICLE" : {
        "TNAME" : "veiculo_by_circ_1801",
        "TRIP"  : "trip_id",
        "CAR"   : "id_emme"
    }
}

MODES = {
    # Route short_name : mode to be designated
    '12E' : 'e', '15E' : 'e', '18E' : 'e',
    '25E' : 'e', '28E' : 'e'
}


    

In [ ]:

    

routes = write_emme_routes_file(
    conPsql, db_schema, "20180222",
    "2018-02-22 07:30:00", "2018-02-22 09:30:00",
    r'D:\TRENMO_JASP\CARRIS\emme\emme_files_jasp\d221.in',
    OtherModes=MODES
)


    

In [ ]:

    

from senpy.toemme.psql import roads_to_emme
stops = r'D:\TRENMO_JASP\CARRIS\emme\snap_paragens.shp'
rdv   = r'D:\TRENMO_JASP\CARRIS\emme\rdv_emmev3.shp'
centros = r'D:\TRENMO_JASP\CARRIS\emme\zonamento\zona_cntr.shp'
centroId = "EMME"

rdvId     = "cat"
rdvModes  = "modo"
travelCol = "dir_travel"
stopsId   = "id"
rdvType   = "tipo_via"
rdvlanes  = "lanes"

conParam = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin", "USER" : "postgres",
    "TEMPLATE" : "postgis_template", "DB" : "rdv_emme"
}

SRS_EPSG = 3763

outfile = r'D:\TRENMO_JASP\CARRIS\emme\emme_files_jasp\d211.in'

roads_to_emme(
    stops, stopsId, rdv, rdvId, rdvModes, travelCol,
    rdvType, rdvlanes, centros, centroId, conParam, SRS_EPSG, outfile,
    date=u"18-07-09 12:30"
)


    

In [ ]: