source: tmcsimulator/branches/realtime_VDS/bin/createVDSgson.bash @ 586

#!/bin/bash

# Files:  vds_config_d12.csv is the config file with VDS lat/long and other identifying data

#         5minagg_latest.txt is the 5 min aggregate real time data.  We need two fields: id and speed.

#



# FIRST: Remove first line of 5minagg (contains date). 

tail -n+2 5minagg_latest.txt > 5min_latest_tail.txt

# SECOND: sort it

sort 5min_latest_tail.txt > 5min_latest_sorted.txt

# Join the two files on the ID field, appending speed as the last field

join -t"," 5min_latest_sorted.txt  vds_config_d12ML_sorted.csv -o 1.1,2.2,2.6,2.7,2.9,2.11,2.12,1.4  > vds_speeds.csv 



#

#3.  Run this awk program to convert output csv to geojson

#

# Convert a csv with postmile and coordinates to a json file

# Note it switches lat/long to long/lat

# Sample invocation:  

# Determine how many lines in file

eof=`wc vds_speeds.csv | cut -f3 -d" " `

# Pass that as parameter to awk program, who uses it to not print a comma after last record.

awk -F',' -v eof="$eof" -f csvToGson.awk vds_speeds.csv > vds_speeds.gson

# Copy result from jdalbey home to dynamic_data folder on server

cp vds_speeds.gson /web/webapps/realtime_VDS/dynamicdata/vds_realtime.gson