Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [sumo-user] Problem with converting csv to xml
Hello,
the default separator for records is ';'.
You can change this using option --delimiter
regards,
Jakob

2018-02-20 6:05 GMT+01:00 Vrinda Khirwadkar (vkhrwdkr) <vkhrwdkr@xxxxxxxxxxx>:

Hello team,

Thanks for all your previous suggestions. I am able to proceed ahead in my research. However, I am again stuck at one point.
I am trying to create route.xml file from pre-defined routes csv file using csv2xml.py tool. I am using below command and options for the same. This runs without any error but the output it produces is not as expected. It is putting all attributes values at one place and MISSING_VALUE in edges.
Can you please suggest what should be the correct way of using csv2xml script.

Thanks in advance!

Command  -
csv2xml.py "C:\Users\Bhushan\Sumo\rou.csv" -q "," -t "routes" -x "http://sumo.dlr.de/xsd/routes_file.xsd" -o "C:\Users\Bhushan\Sumo\rou.xml"

Input File - (rou.csv):
id,type,depart,departLane,departSpeed,edges
60,pas1,0.79,free,max,-230604780#2 230604780#2 230604780#3 230604780#4 230604780#5 130576322#0 130576322#1 130576322#2 130576322#3 130576322#4 130576322#5 130576322#6 130576322#7 130576322#8 130576322#9 130576322#10 130576322#11 6122889#0 6122889#1 6122889#2 6122889#3 6122889#
451,pas2,4.77,free,max,-6095593 6089496#2 6089496#3 6100188#1 6100188#2 -6097263#1 -6097263#0 6143547#7 6143547#8 6126772#10 6126772#11 6126772#12 6116950#0 6116950#1 6116950#2 6116950#3 6126074#0 6109854#0 6109854#1 6128264#5

Output File - (rou.xml):
<routes>
    <vehicle depart,departLane,departSpeed,edges="60,pas1,0.79,free,max,-230604780#2 230604780#2 230604780#3 230604780#4 230604780#5 130576322#0 130576322#1 130576322#2 130576322#3 130576322#4 130576322#5 130576322#6 130576322#7 130576322#8 130576322#9 130576322#10 130576322#11 6122889#0 6122889#1 6122889#2 6122889#3 6122889#">
        <route edges="MISSING_VALUE"/>
    </vehicle>
    <vehicle depart,departLane,departSpeed,edges="451,pas2,4.77,free,max,-6095593 6089496#2 6089496#3 6100188#1 6100188#2 -6097263#1 -6097263#0 6143547#7 6143547#8 6126772#10 6126772#11 6126772#12 6116950#0 6116950#1 6116950#2 6116950#3 6126074#0 6109854#0 6109854#1 6128264#5">
        <route edges="MISSING_VALUE"/>
    </vehicle>
</routes>


Thanks and regards,

Vrinda Khirwadkar

University of Memphis



From: Jakob Erdmann <namdre.sumo@xxxxxxxxxxxxxx>
Sent: Monday, February 12, 2018 6:33 AM
To: Sumo project User discussions
Cc: Vrinda Khirwadkar (vkhrwdkr)
Subject: Re: [sumo-user] Reading large SUMO output files
 
Hello,
you can use the tool traceExporter.py to filter sumo fcd-output on the fly and put the output into one or more target files (for each target file a bounding box, and time range can be configured). It is also possible to change the sampling interval and the percentage of vehicles that shall be exported.

Read here about connecting sumo and traceExporter directly via a socket so that no large file must be written:
http://sumo.dlr.de/wiki/Tools/TraceExporter#Input_Options

Read here about filtering: http://sumo.dlr.de/wiki/Tools/TraceExporter#fcd
http://sumo.dlr.de/wiki/Tools/TraceExporter#Processing_Options
Tools/TraceExporter - Sumo
sumo.dlr.de
The filter file is a simple csv format giving begin;end;bounding_box;outfile where the bounding box is x1,y1,x2,y2 defining the lower left and the upper right corner ...



Unfortunately, there is currently no tool to perform the same type of processing for the netstate-dump.
regards,
Jakob

2018-02-06 5:24 GMT+01:00 Vrinda Khirwadkar (vkhrwdkr) <vkhrwdkr@xxxxxxxxxxx>:

Hello team,


I ran a simulation for an area with below mentioned configurations. Total number of vehicles generated in trip.xml file were 145436 for 1 hour. Simulation took approximately 3-4 hours to complete. Now due to size of the output file (fcd and netstate dump), I am not able to analyse it. Can you please suggest any tool or python script which I can use to break the output files based on given timestamp, say output file for every 10 or 15 minutes?


Also, will it be a good idea to run simulation for longer duration, for e.g. 30 days with below network file or we should take smaller area. Please suggest.


Input Configuration: 

  1. Net file: 61 MB ; total route length: 3132 km ; No. of edges: 29332
  2. Trip File: 21 MB

Output Configuration:

  1. Fcd Output: 27 GB
  2. netstate-dump: 15 GB
  3. tripinfo-output: 11 MB

Thank you again for your quick suggestions.


Vrinda Khirwadkar

University of Memphis


_______________________________________________
sumo-user mailing list
sumo-user@xxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.eclipse.org/mailman/listinfo/sumo-user



_______________________________________________
sumo-user mailing list
sumo-user@xxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.eclipse.org/mailman/listinfo/sumo-user


Back to the top