From 4293d05f61212386a9a0af1bc04299ac2651e378 Mon Sep 17 00:00:00 2001
From: typebrook <typebrook@gmail.com>
Date: Thu, 24 Oct 2019 17:42:07 +0800
Subject: update

---
 scripts/csv2geojson | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100755 scripts/csv2geojson

(limited to 'scripts')

diff --git a/scripts/csv2geojson b/scripts/csv2geojson
new file mode 100755
index 0000000..ec1d35c
--- /dev/null
+++ b/scripts/csv2geojson
@@ -0,0 +1,7 @@
+#! /bin/bash
+
+sed 's/[^,]*/"\0"/g' $1 |\
+sed 's/.*/[\0]/g' |\
+sed '1d' |\
+jq '. | {"type": "Feature",  "properties": {},  "geometry":{ "type": "Point",  "coordinates": [(.[-1] | tonumber), (.[-2] | tonumber)] } }'|\
+jq -s '{"type": "FeatureCollection", "features": .}'
-- 
cgit v1.2.3-70-g09d2


From f8b90f8c8e0cdcb4e12862d4b393c1226675b287 Mon Sep 17 00:00:00 2001
From: typebrook <typebrook@gmail.com>
Date: Thu, 24 Oct 2019 18:21:32 +0800
Subject: update

---
 scripts/csv2geojson | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'scripts')

diff --git a/scripts/csv2geojson b/scripts/csv2geojson
index ec1d35c..49ed0c9 100755
--- a/scripts/csv2geojson
+++ b/scripts/csv2geojson
@@ -1,5 +1,13 @@
 #! /bin/bash
 
+echo --------------
+head -1 $1 | sed 's/,/ /g'
+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' |\
-- 
cgit v1.2.3-70-g09d2


From 005b07bd7e66248692bb4ac6f7eab1fe33fe2016 Mon Sep 17 00:00:00 2001
From: typebrook <typebrook@gmail.com>
Date: Thu, 24 Oct 2019 18:45:31 +0800
Subject: update

---
 scripts/csv2geojson | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'scripts')

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