ho.sh

#!/bin/bash
# [email protected] for Todd S
# uses 'xmlstarlet' to extract XML data to CSV

# fix input file - example
# sed 's/\x0d\xEF\xBB\xBF/\x0a/g' <ut-landmarks.gpx >ut-landmarks-good.gpx
#  - will still have one ^M at start of file?


# rock art - this one is different
xmlstarlet sel -T -t -m /gpx/wpt -v "concat(@lat,',',@lon,',',name)" -n utah-rock-art.gpx  >utah-rock-art.csv

# mines
xmlstarlet sel -T -t -m /gpx/wpt -v "concat(@lat, ',', @lon, ',', ele, ',', extensions)" -n ut-mines.gpx >ut-mines.csv

# land features
xmlstarlet sel -T -t -m /gpx/wpt -v "concat(@lat, ',', @lon, ',', ele, ',', extensions)" -n ut-land-features.gpx >ut-land-features.csv

# landmarks
xmlstarlet sel -T -t -m /gpx/wpt -v "concat(@lat, ',', @lon, ',', ele, ',', extensions)" -n ut-landmarks.gpx >ut-landmarks.csv

# towns
xmlstarlet sel -T -t -m /gpx/wpt -v "concat(@lat, ',', @lon, ',', ele, ',', extensions)" -n ut-towns.gpx >ut-towns.csv

xmlstar.sh

#!/bin/bash
# Fun with xmlstarlet

# validate the file
xmlstarlet val ut-landmarks.gpx

# look at distinct ("unique" [sic]) elements
xmlstarlet el -u ut-landmarks.gpx

# look at attribute values
xmlstarlet el -v ut-landmarks.gpx

# format the XML
xmlstarlet fo utah-rock-art.gpx

# count something
xml sel -t -v "count(/gpx/trk)" -n utah-rock-art.gpx

# extract to CSV 
xmlstarlet sel -T -t -m /gpx/wpt -v "concat(@lat, ',', @lon, ',', ele, ',', extensions)" -n ut-land-features.gpx >ut-land-features.csv