RoutingApi, RouteMode, MatrixRoutingType, MatrixSummaryAttribute, RoutingTransportMode, RoutingMode, RoutingApiReturnField, RoutingMetric, RoutingApiSpanField, ) routing_api = RoutingApi(api_key="api_key") # fetches a bicycle route between two points response = routing_api.bicycle_route( waypoint_a=[41.9798, -87.8801], waypoint_b=[41.9043, -87.9216] ) print(response.as_dict()) # fetches a driving route between two points response = routing_api.car_route( waypoint_a=[11.0, 12.0], waypoint_b=[22.0, 23.0], modes=[RouteMode.car, RouteMode.fastest], ) print(response.as_dict()) # fetches a pedastrian route between two points response = routing_api.pedastrian_route( waypoint_a=[11.0, 12.0], waypoint_b=[22.0, 23.0],
connection = connect_to_db("localhost", "5432", "SMA", "postgres", "password") # using RoutingAPI routing_api = RoutingApi(api_key=" ") # a while loop to bring coordinats from a specified number of rows at a time # and send it to the Api and insert the reponses in the table while (counter < id_final): # Convert to data_table the result Lists from the function select_row data_table = select_row(connection, id_min, id_max) id_min += 1000 id_max += 1000 if (id_max > id_final): id_max = id_final for row in data_table: cur = connection.cursor() # fetches a bicycle route between two points response = routing_api.bicycle_route(waypoint_a=[row[1], row[2]], waypoint_b=[row[3], row[4]]) response = response.as_dict() distance_bic = response['response']['route'][0]['summary']['distance'] time_bic = response['response']['route'][0]['summary']['baseTime'] # print("bicycle",distance_bic) # print("bicycle",time_bic) # fetches a driving route between two points response = routing_api.car_route( waypoint_a=[row[1], row[2]], waypoint_b=[row[3], row[4]], modes=[RouteMode.car, RouteMode.fastest], ) response = response.as_dict() distance_car = response['response']['route'][0]['summary']['distance'] time_car = response['response']['route'][0]['summary']['baseTime']