Successfully logged in as: xyz
>>>>
sea = addresses[addresses['CTYNAME']=="SEATTLE"]
pd.set_option('display.max_columns', None)
df_o = pd.DataFrame(sea.sample(N), columns = ['LON', 'LAT'])
#print (df_o)
orders_sdf = pd.DataFrame.spatial.from_xy(df_o, 'LON', 'LAT')
orders_sdf = orders_sdf.drop(axis=1, labels=['LON', 'LAT'])
orders_fset = orders_sdf.spatial.to_featureset()
r = {'ObjectID': ['1','2'],
'Name': ['Route1', 'Route2'],
'StartDepotName': ['Warehouse', 'Warehouse'],
'EndDepotName': ['Warehouse', 'Warehouse'],
#'EarliestStartTime': [1.573546e+12, 1.573546e+12 ],
# 'LatestStartTime': [8.00, 8.00 ],
'Capacities':[200, 50],
'CostPerUnitTime': [1,1],
'MaxOrderCount':[200,50],
# 'MaxTotalTime': [8,8],
'AssignmentRule': [1,1]
}
df = pd.DataFrame(r, columns = ['ObjectID',
'Name',
'StartDepotName',
'EndDepotName',
# 'EarliestStartTime',
# 'LatestStartTime',
'Capacities',
'CostPerUnitTime',
'MaxOrderCount',
# 'MaxTotalTime',
'AssignmentRule'])
#df["LatestStartTime"] = df["LatestStartTime"].astype("int64")/ 10 ** 6
#df["EarliestStartTime"] = df["EarliestStartTime"].astype("int64")/ 10 ** 6
routes_fset = arcgis.features.FeatureSet.from_dataframe(df)
# 1 depot
w = {'Latitude': [47.618011],
'Longitude': [-122.329422],
'Name': ['Warehouse']
}
df_w = pd.DataFrame(w, columns = ['Latitude',
'Longitude',
'Name'])
depots_sdf = pd.DataFrame.spatial.from_xy(df_w, "Longitude", "Latitude")
depots_sdf = depots_sdf.drop(axis=1, labels=["Longitude", "Latitude"])
depots_fset = depots_sdf.spatial.to_featureset()
import datetime as dt
import arcgis.network as network
if_async = False
current_date = dt.datetime.now().date()
result1 = network.analysis.solve_vehicle_routing_problem(orders=orders_fset, depots=depots_fset,
default_date=current_date,
routes=routes_fset, populate_route_lines=True,
save_route_data=True,
populate_directions=True,
directions_language="es",
future=if_async)
runs for 20+ minutes ends with error
>>>>