Modelo Emergência Input (UCD Lab)
Câmara Municipal de Lisboa
@ptgov.modelo_emergencia_input
Câmara Municipal de Lisboa
@ptgov.modelo_emergencia_input
CREATE TABLE input_emergency_analytical_model (
"road_id" VARCHAR,
"period" BIGINT,
"off_day" BIGINT,
"temperature" BIGINT,
"precipitation" BIGINT,
"sum" BIGINT,
"count" BIGINT,
"probability" DOUBLE,
"n_1" BIGINT,
"n_2" BIGINT,
"n_3" BIGINT,
"n_4" BIGINT,
"n_5" BIGINT,
"n_6" BIGINT,
"n_7" BIGINT,
"waze" BIGINT,
"slope" DOUBLE,
"lane_n" BIGINT,
"bus_l" BIGINT,
"oneway_c" BIGINT,
"truck_c" BIGINT,
"bus_c" BIGINT,
"taxi_c" BIGINT,
"bike_c" BIGINT,
"ped_c" BIGINT,
"res_c" BIGINT,
"del_c" BIGINT,
"eme_c" BIGINT,
"fow" BIGINT,
"vel_max" DOUBLE,
"comp" DOUBLE,
"candeeiro" BIGINT,
"radar" BIGINT,
"semaforo" BIGINT,
"prob_cat" DOUBLE
);
Anyone who has the link will be able to view this.