save into an sqlite database data of the first trackpoint of a gpx track using openstreetmap reverse nominatim

gpx-reverse-osm.sh

#!/usr/local/Cellar/bash/4.4.12/bin/bash

# sqlite3 tracks.db "CREATE TABLE tracks ( id integer primary key, gpxfile varchar, osm json)"

GPX=$1
echo "$GPX"

COORD=$(xml sel -N x=http://www.topografix.com/GPX/1/1 -t -v "//x:trkpt[1]/@*" "$GPX")
readarray -t y <<<"$COORD"
LAT=${y[0]}
LON=${y[1]}
OSM=$(curl -s "http://nominatim.openstreetmap.org/reverse?format=json&lat=$LAT&lon=$LON&zoom=18&addressdetails=1")

sqlite3 tracks.db "INSERT INTO tracks (gpxfile, osm) VALUES ('$GPX', '$OSM');"