Merge remote-tracking branch 'origin/dev' into dev

1 files changed, 16 insertions, 0 deletions

diff --git a/scripts/csv2geojson b/scripts/csv2geojson
new file mode 100755
index 0000000..90e6141
--- /dev/null
+++ b/scripts/csv2geojson
@@ -0,0 +1,16 @@
+#! /bin/bash
+
+echo --------------
+head -1 $1 | sed 's/,/ /g' | awk '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}'
+echo --------------
+echo 
+
+read -p "Number of latitude column: " lat_col
+read -p "Number of longitude column: " lon_col
+
+sed 's/[^,]*/"\0"/g' $1 |\
+sed 's/.*/[\0]/g' |\
+sed '1d' |\
+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' ]}'