I have a CSV that contains some data relating to hikes undertaken by various people. For each hike, there is an
GPX field (along with some other data - see image below).
The XML that makes up a GPX-file is stored for each hike under the
GPX column in the CSV.
Essentially, my goal is to bring this CSV into SQL Server and conduct spatial operations on it. In order to do so, I would like to convert each GPX for each row to a geography data type (WKB or WKT)
Is there any way I can convert each GPX into a WKT or WKB as a line geometry?
Open to solutions in Python, SQL, or anything else you guys can think of.
Essentially, I'd like the output to look something like this:
Here is a link to the complete dataset i am using (found on Kaggle).