In principle, this approach works, but with an extra step because excel is bad in saving the desired xml.
The approach below requires sumo version 1.24.0 or later.
- in your additional file where you define the edgeData output, set output file extension to csv: file="output.csv"
- load the csv in excel, prefix any new column with 'edge_' ( i.e. edge 'edge_flow')
- convert the csv into the required xml format by calling
python %sumo_home%\tools\xml\csv2xml.py output_modified.csv -o output_modified.xml -x %sumo_home%\data\xsd\datamode_file.xsd
- load output_modified.xml in sumo-gui
The alternative would be a small python script along the lines of
regards,
Jakob
I would like to generate a visualization map of the edges with the variable TimeLoss/vehicle, that is, an average of the time lost in seconds / vehicle.
The SUMO output of edgedata-output, for example, provides the total edge timeLoss, and I can obtain the timeLoss per vehicle if, after outputting the file, I add a column of the traffic volume obtained by:
Average traffic volume (#/h) = speed * 3.6 * density
And then another column with the division of timeLoss / flow.
My intention is to perform these calculations with Excel and then save as XML and load it into SUMO in Open EdgeData.
Is this possible?
If so, is there a more practical method?
Thank you in advance.
Regards,
Pedro Oliveira
_______________________________________________
sumo-user mailing list
sumo-user@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/sumo-user
