Conversation

Notices

1. Embed this notice
   Linux Walt Alt (@lnxw37a2) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw37a2@pleroma.soykaf.com)'s status on Friday, 25-Apr-2025 02:45:08 JST Linux Walt Alt (@lnxw37a2) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

   in reply to

   • Elias Mårtenson
   • Sylke Vicious [2]
   @loke I don't know who's maintaining it, and I'm sure it isn't exactly what you want, but Patrick L Arnold (who was \@pla or \@pla1 in the Identica days) had written something that published his bicycle rides to his Mastodon account. Unfortunately, he was killed when a car ran into him a few years back.
   
   Maybe @metalbiker knows.
   • Embed this notice
     Elias Mårtenson (loke@functional.cafe)'s status on Friday, 25-Apr-2025 02:45:09 JST Elias Mårtenson

     So, I've been playing around with the GPX file format and PostGIS. My goal is to build a tool where I can run my own server that collects GPX tracks from bike rides, and match them against predefined routes. Like a self-hosted Strava if you like.

     I started this because the enshittification of Strava has reached a tipping point and I cannot in good faith upload anything to them anymore.

     Once I get this working, I want to add the ability to share rides and favourite segments via the Fediverse. Not entirely sure how far you can take that, but that's something to think about later.

     Anyway, it seems I can use PostGIS to match a ride against a set of segments, at least when using a small set of test tracks and some synthetic data that I've generated.

     Is there anyone here that is familiar with PostGIS who would be willing to advice me as to whether I'm actually doing this right? I can't help but think that my successful experiments are actually pure luck.