source: tmcsimulator/trunk/webapps/visualizer/data_layers/cmsToGeoJson.awk @ 516

# Convert a csv with cctv location data to a geojson file
# This was used for a one-off task to convert the static csv file we manually produced into json
# Sample invocation:  awk -F',' -f awkpgm1 filename

# Manually remove the first line with column headers before running this.

# Remove quotes around those streets names that have them
//{gsub("\"","",$5);printf "  {\n  \"type\": \"Feature\",\n  \"id\": \"%s\",\n  \"geometry\":\n      {\n      \"type\": \"Point\",\n      \"coordinates\": [%s,%s]\n      },\n  \"properties\":\n      {\n      \"location\":\"%c %s %5.2f\",\n      \"street\":\"%s\"\n      }\n  },\n", $1,$7,$8,$10,$12,$15, $5}

#
# When finished prepend:
#{
#  "type": "FeatureCollection",
#  "features": [
# 
# and Append:
#  ] }