[openstreetmap/openstreetmap-website] Add a gpx_tracks table and convert trace points into linestrings (PR #7348)

[Ruben L. Mendoza]

Rub21 left a comment (openstreetmap/openstreetmap-website#7348)

I wrote a bash script to convert the old traces: it runs `rake db:gpx_tracks` in parallel, passing a range of trace ids to each process. 
https://gist.github.com/Rub21/5376e14fc7597af471945d7d6b8ddd6f

It splits the traces into ranges of ids and runs a few rake processes at the same time. It shows the plan and asks for a yes before it starts. status reads the logs and shows the percentage, the segments written and the errors. Traces that already have rows are skipped.


Note: the bash script is only a proposal to run the conversion, if there is another way you normally do migrations, I can take a look at it.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/7348#issuecomment-5477064443
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/7348/c5477064443 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20260831/41e9da79/attachment-0001.htm>