RAW DATA AND TIME STAMP

Questions and discussions about operating Tru-Traffic

Moderator: bullock

RAW DATA AND TIME STAMP

Postby trafficdata2000 » Fri Feb 26, 2016 1:47 pm

Greg, is there a way that one can export trimmed raw data running by the second from the program after the data has been imported and used to generate a report? Also, is it possible to export only time stamps that show the times as the vehicle passes through every intersection? I have attached some samples.
Attachments
1st Street AM-NB-001.xls
Raw data trimmed by software
(64.5 KiB) Downloaded 628 times
I-580 (Hacienda) AM EB-TDS.pdf
Time Stamps
(11.87 KiB) Downloaded 622 times
trafficdata2000
 
Posts: 7
Joined: Thu Oct 16, 2014 10:14 pm

Re: RAW DATA AND TIME STAMP

Postby bullock » Fri Feb 26, 2016 11:44 pm

Hi.

To export a trip log to a text file (which can be opened in, say, Excel) with second by second data, navigate to GPS View, then right-click on a trip log and choose Export: Export Trip Log..., then change the file type to either TSV or CSV

To export only time stamps that show the times as the vehicle passes through each intersection,
  1. Generate a Travel Time & Delay Report
  2. Select the desired Details tab that you want to export.
  3. Click the Save button at the top of the report.
The resulting HTML file may be opened in, say, Excel for further analysis.

If you wish, you may first prune the list of columns to show only the columns of interest. To do this, use View: Preferences...: Layout: TT&D Report: Report Columns, and uncheck the columns you don't need.
bullock
Site Admin
 
Posts: 218
Joined: Thu May 06, 2004 6:51 pm
Location: Pacific Grove, CA


Return to Program Operation

Who is online

Users browsing this forum: No registered users and 6 guests

cron