27 lines
938 B
Bash
27 lines
938 B
Bash
|
#!/bin/bash
|
||
|
|
#
|
||
|
|
# Author: Macgregor
|
||
|
|
# Liscense: GPLv3
|
||
|
|
#
|
||
|
|
# routes = route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color
|
||
|
|
# route_id,route_short_name,route_long_name,route_type --for MUMBAI routes
|
||
|
|
# route_id,service_id,trip_id --for MUMBAI trips
|
||
|
|
|
||
|
|
if [ ${#} -eq 2 ] ; then
|
||
|
|
|
||
|
|
FILE_IN_FREQ="${1}"
|
||
|
|
FILE_OUT_FREQ="${2}"
|
||
|
|
|
||
|
|
# FPAT regex parse CSV and then strip not needed quotes from field data
|
||
|
|
cat "${FILE_IN_FREQ}" | grep -v "trip_id" | gawk -v sq="${SQLITE_DB_IMPORT_SEP}" 'BEGIN { FPAT = "([^,]*)|(\"[^\"]+\")" } {
|
||
|
|
trip_id = $1; start_time = $2; end_time = $3; headways = $4;
|
||
|
|
|
||
|
|
if( length(alltrips[trip_id]) > 0 )
|
||
|
|
alltrips[trip_id] = ((alltrips[trip_id] + headways) / 2); # hack: ouch average out the headways!
|
||
|
|
else
|
||
|
|
alltrips[trip_id] = headways;
|
||
|
|
} END {
|
||
|
|
for( tid in alltrips)
|
||
|
|
print tid sq int(alltrips[tid]);
|
||
|
|
}' | grep -v "^$" | tr -d '"' >"${FILE_OUT_FREQ}"
|
||
|
|
fi
|