From 005b07bd7e66248692bb4ac6f7eab1fe33fe2016 Mon Sep 17 00:00:00 2001 From: typebrook Date: Thu, 24 Oct 2019 18:45:31 +0800 Subject: update --- scripts/csv2geojson | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'scripts/csv2geojson') diff --git a/scripts/csv2geojson b/scripts/csv2geojson index 49ed0c9..90e6141 100755 --- a/scripts/csv2geojson +++ b/scripts/csv2geojson @@ -1,7 +1,7 @@ #! /bin/bash echo -------------- -head -1 $1 | sed 's/,/ /g' +head -1 $1 | sed 's/,/ /g' | awk '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' echo -------------- echo @@ -11,5 +11,6 @@ read -p "Number of longitude column: " lon_col sed 's/[^,]*/"\0"/g' $1 |\ sed 's/.*/[\0]/g' |\ sed '1d' |\ -jq '. | {"type": "Feature", "properties": {}, "geometry":{ "type": "Point", "coordinates": [(.[-1] | tonumber), (.[-2] | tonumber)] } }'|\ +jq --arg LAT_INDEX $lat_col LON_INDEX $lon_col '. | {"type": "Feature", "properties": {}, "geometry":{ "type": "Point", "coordinates": [(.[LAT_INDEX] | tonumber), (.[LON_INDEX] | tonumber)] } }'|\ jq -s '{"type": "FeatureCollection", "features": .}' +#awk '{for (i=1; i<= NF; i++) if (i != 2 && i != 3) printf $i " "; printf [ " " {; print ""}' test' ]}' -- cgit v1.2.3-70-g09d2